One can read and learn AJAX implementation at webpage at this blog article – "How to implement AJAX in html website". Common example of AJAX implementation in real world can be examined at Google Map, YouTube etc.
We can use AJAX in a website using jQuery various readymade methods also. These methods works as abstraction layer of AJAX internal functionalities. Following are list of commonly used methods –
- $.load() –
It is simple in use and used to get or request content from a webpage. It uses common syntax as below -
$(selector).load(URL, data, callback);
- $.get() –
It fetches data using an AJAX HTTP GET request and uses common syntax as below -
$.get(URL,data,function(data, status, xhr), dataType) - $.post() –
It fetches data using an AJAX HTTP POST request and uses common syntax as below -
$(selector).post(URL,data, function(data, status, xhr), dataType) - $.getJSON() -
It fetches JSON encode data using a HTTP GET request and uses common syntax as below -
$(selector).getJSON(url, data, success(data, status, xhr)) - $.ajax() -
It executes an async AJAX request and uses common syntax as below -
$.ajax({name:value, name:value, ... })
For example –
$.ajax({url:”test.txt”, cache:false, type: “GET”, dataType: “xml”, success: callbackFunction, error:callbackFunction })
Following are example to show mySQL PHP data list(ajax-jquery-php-data.php) via jQuery AJAX. You can click at "Demo" link for viewing live example. Source code with SQL file is also available for download, you need to click at the "Download Source" link for this.
Main or Index file has a button named as "Load Data". mySQL PHP data is listed at click event of the button. -
Main or Index page html code sample -
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">mySQL PHP data code sample -
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Loading mySQL data via jQuery AJAX</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script >
$(document).ready(function() {
$('button').click(function() {
$.ajax({
url: "ajax-jquery-php-data.php",
success: function(r) {//success(result,status,xhr)
$("div").html(r);
},
error: function(e) {//error(xhr,status,error)
alert("ERROR: " + e.status + " " + e.statusText);
}
});
});
});
</script>
</head>
<body>
<button>Load Data</button>
<div id="result"></div>
</body>
</html>
It has general code to show mySQL data using PHP. You can list own data of a specific database. I have used Drupal opensource database and 'node' table to test the script. You have to change variable value of your own at very first line of the code only.
<?php
$host='localhost';$username='root';$password='yp';$dbname='drupal_db';$table='node';
$con = mysql_connect($host, $username, $password) or die('ERROR: ' . mysql_error());
mysql_select_db($dbname, $con) or die('ERROR: '.mysql_error());
$q = "select * from $table";
$r = mysql_query($q);
echo '<table border="1" border-color="#999999" style="border:1px solid #999999;border-collapse:collapse;font-family:Arial, Helvetica, sans-serif; font-size:12px;">';
echo '<tr bgcolor="#eeeeee">';
$row = mysql_fetch_assoc($r, MYSQL_ASSOC);
foreach ($row as $col => $value) {
echo "<th>";
echo $col;
echo "</th>";
}
echo '</tr>';
while($rows = mysql_fetch_array($r, MYSQL_ASSOC))
{
echo '<tr>';
foreach($rows as $value){
echo '<td>';
echo $value;
echo '</td>';
}// end of foreach
echo '</tr>';
} // end of while
echo "</table>";
?>
Best Books for Web Development in PHP
1
Programming PHP : Creating Dynamic Web Pages
Book Description
It's the new and updated version of this book - Fourth Edition - that teaches you everything you need to know to build effective web applications using the latest features in PHP 7.4.
The book explains language syntax, programming techniques, and other details using examples that illustrate both correct usage and common idioms.
For those with a working knowledge of HTML, the book contains many style tips and practical programming advice in a clear and concise manner to help you become a top PHP programmer.
The book teaches about fundamentals of the language including data types, variables, operators and flow control statements. It explores about functions, strings, arrays and objects.
It teaches to apply common web application techniques, such as form processing, data validation, session tracking, and cookies.
It teaches to interact with relational databases such as MySQL or NoSQL databases such as MongoDB. It also teaches to generate dynamic images, creating PDF files, and parsing XML files.
You can learn about secure scripts, error handling, performance tuning and other advanced topics in this book.
You can get a quick reference to PHP core functions and standard extensions in this book.
Book details
Format: Kindle Edition, PaperbackRating: 4.6 out of 5
Author: Kevin Tatroe, Peter Macintyre
Print Length: 540 pages
Publication Date: 27 March 2020
Publisher: O′Reilly, 4th edition
Kindle Price: Rs. 1,567.50*
Paperback Price: Rs. 3,614.00*
*Price and stock are correct and available at the time of article publication.
Get it here from Amazon
2
PHP Web Development with Laminas
Book Description
This book teaches how to build fully secure and functional e-commerce applications with PHP using the next generation Zend Framework-Laminas. You can learn to develop modern object-oriented applications with PHP by using Test-Driven Development (TDD) and Behavior-Driven Development (BDD) aided by mature reusable components.
This book provides a practical approach to equip you with the knowledge of the Laminas framework needed to start building web applications based on reuse of loosely coupled components.
You will learn how to build the basic structure of a PHP web application divided into layers. You can understand the MVC components of Laminas and be able to take advantage of the Eclipse platform as a method to develop with Laminas.
Books teach to explore how object-relational mapping is implemented with Laminas-DB, behavior-driven development concepts to sharpen your skills, how to build complete models and reusable components, practice testing How to Create HTML Forms With Laminas-Forms.
By the end of this web development book, you will be able to build completely secure MVC applications in PHP language using Laminas.
Book details
Format: Kindle EditionAuthor: Flávio Gomes da Silva Lisboa
Text-to-Speech: Enabled
Enhanced typesetting: Not Enabled
X-Ray: Not Enabled
Word Wise: Not Enabled
Publication Date: 9 December 2022
Publisher: Packt Publishing
Kindle Price: Rs. 750.74*
*Price and stock are correct and available at the time of article publication.
Get it here from Amazon
3
Getting started with Laravel 9, master the most popular PHP framework
Book Description
This book is for all those who want to build their first application in Laravel 9. This book provides a step-by-step introduction to the writing framework, gets to know its most relevant aspects and focuses above all on practice.
Using this book you will be able to build any basic application with the framework. There are total 19 chapters in this book. Using this book, you will be able to know what are the required software to install Laravel for different operating systems.
In this book you can learn - project creation, database configuration, routing, view controllers, redirection, directive and templating engines in the form of blades, model building, CRUD applications etc.
You can learn to perform common eloquent operations that can be applied to databases using query builders. You can learn how to generate test data using classes.
You can also learn the file upload process. You can learn how to use REST APIs through CRUD type applications in VU3 using Axios requests and web components with Oruga UI.
You can also learn how to configure Browsersync with Laravel to automatically reload applications. You can learn how to protect an app in Vue with the login required to access its various modules using SPA authentication or Laravel Sanctum tokens.
Book details
Format: Kindle EditionRating: 1 out of 5
Author: Andrés Cruz Yoris
Print Length: 453 pages
Publication Date: 8 May 2022
Text-to-Speech: Enabled
Screen Reader: Supported
Enhanced typesetting: Enabled
X-Ray: Not Enabled
Word Wise: Not Enabled
Kindle Price: Rs. 449.00*
*Price and stock are correct and available at the time of article publication.
Get it here from Amazon
4
Learning Drupal as a framework: Your guide to custom Drupal 9. Full code included
Book Description
This book uses PHP> 7.4. This course teaches you about the advanced concepts of Drupal 9, object-oriented PHP and Symfony components.
After the course, you will be able to build a variety of robust and scalable software solutions.
This book discusses advanced topics such as custom entities, entity forms, access controls, events, caching, workflows, and more when building real software.
It gives you powerful and ready-to-use snippets for your next Drupal project with +2400 lines of custom code.
Book details
Format: Kindle EditionRating: 5 out of 5
Author: Stef Van Looveren
Print Length: 282 pages
Publication Date: 17 July 2022
Text-to-Speech: Enabled
Screen Reader: Supported
Enhanced typesetting: Enabled
X-Ray: Not Enabled
Word Wise: Not Enabled
Kindle Price: Rs. 449.00*
*Price and stock are correct and available at the time of article publication.
Get it here from Amazon
5
Getting started with CodeIgniter 4
Book Description
This book is for anyone who wants to build their first applications in CodeIgniter 4 a popular PHP framework, this writing offers a step-by-step introduction to the framework, knowing the most relevant aspects of it, and is focused above all on practice.
The book is aimed at those people who want to learn something new, learn about a framework that has very little documentation, who want to improve a skill in web development, who want to grow as a developer, and who want to continue scaling their path with other frameworks superior to this one.
This book has a total of 15 chapters and consists of explanations and practices. It teaches you how to run the framework, how to configure a database, how to create the first components, how to use of migrations for table management, working with the MVC, how to prepare CRUD application, how to use the routes, grouped routes, their options, and the different types.
You can learn about the use of the session and also of the flash session to save data and present it to the user. You can learn to manage views in a reusable way. You can learn about how to work with HTML forms and apply validations from the server side in CodeIgniter. You can learn about the authentication module with the login interface, and how to build a Rest Api type CRUD that can be consumed with JSON or XML.
You can also learn about generating test data with seeders, how to handle the relational schema of the database, how to do uploading files in the application, how to use libraries and help functions, how to integrate the PayPal platform, etc.
Book details
Format: Kindle EditionAuthor: Andres Cruz
Print Length: 328 pages
Publication Date: 13 May 2022
Text-to-Speech: Enabled
Screen Reader: Supported
Enhanced typesetting: Enabled
X-Ray: Not Enabled
Word Wise: Not Enabled
Kindle Price: Rs. 319.00*
*Price and stock are correct and available at the time of article publication.
Get it here from Amazon
0 comments:
Post a Comment