Insert multiple checkbox value using jQuery AJAX in PHP MySql

In this post I show you how to insert multiple checkbox value in database using jQuery AJAX in PHP MySLQ without page refresh. when an user uses a checkbox, the checkbox value is inserted into the MySQL database without refreshing the web page with Ajax, jQuery in PHP. I will insert the value of boxes in the database and examples with values ​​such as the name of the course and how many courses you like, if the user chooses more than one in the box, then all the checkbox values ​​will be stored in an array with jQuery and I will use this array to convert to a string and insert the values ​​of all the checkbox into the table using the jQuery & Ajax method using PHP.

Continue ReadingInsert multiple checkbox value using jQuery AJAX in PHP MySql
Autocomplete Textbox using jQuery AJAX in PHP MySql

The Autocomplete text box allows users to quickly find and select values ​​from a list of pre-populated options. Suggestions are displayed automatically when the user enters the field.By using jQuery with Ajax we can easily present automated proposals for all queries from the database in the text field. I don't use the jQuery plugin to ask for text fields for autocomplete, but I do use the simple Ajax method with PHP and MySQL for autocomplete text fields. Let's start with a tutorial on how to fill in text boxes automatically. Here we present text fields for entering a city name. When users enter the city name, they display the city name starting with the characters they entered in the text box and the city displayed below the text box. This type of city is automatically selected from the users table from the MySQL database. 

Continue ReadingAutocomplete Textbox using jQuery AJAX in PHP MySql
How to load records using Select option with jQuery AJAX in PHP MySQL

In this post you will create How to load records using Select option with jQuery AJAX in PHP Mysql. For this I have use example of city name. When user select particular city name then at that time city relates to that user name and other details will be load with out page refresh. I have use a table, In table have user city name and users full details. I have use simple ajax function call when user select city name from select box then it send request to php page and on the basis of selected city name it select user data from users table as per selected city name.

Continue ReadingHow to load records using Select option with jQuery AJAX in PHP MySQL
How to Upload & Display Image Using jQuery AJAX PHP and MySQL

In this article we will learn how to upload & display image using jQuery AJAX in PHP MySQL. uploading images using the AJAX function is easy and simple to implement on your web page.  I use jQuery AJAX to implement image uploads. There is a form with fields for file input and buttons to upload. When a form with the selected image file is sent, the AJAX script is run. In this code, a PHP upload request is sent with the uploaded image. The PHP code moves the uploaded image to the uploads folder and returns the HTML image to display the preview in AJAX response.

Continue ReadingHow to Upload & Display Image Using jQuery AJAX PHP and MySQL
Insert Form Data using Jquery Ajax serialize() function in PHP Mysqli

In this post, you will learn how to create insert form data into a MySQL table using the JQuery Ajax serialize () method with PHP code without refreshing the page. This generates text strings from whole form data in the standard encoded URL notation form. This can be an action for a jQuery object that has selected various form controls, like input tag, textarea tag and select option tags. After using the serialize () method, the data for the entire form is converted to an associative array, and users can use the form data in a PHP script using the post method. After using this method, we don't have to specify data individually from the form. We cannot use this method with input file types. This method works in most browsers. Here I only explain if you want to learn in detail, please follow in below.

Continue ReadingInsert Form Data using Jquery Ajax serialize() function in PHP Mysqli
Delete multiple record with checkboxes in PHP Mysqli using Jquery AJAX

are checked without refreshing the page. If the user wants to delete multiple tables, he can check the box for that table row and click the Delete button when the system asks Are you sure want to delete this records. If he clicks Ok, if no check box is selected, the system will display a warning message again. Please select at least one checkbox. If the user has selected one or more check boxes, the user can delete multiple rows of the table with our page refreshing. For this I use Ajax  in JQuery code. Use Ajax to delete the code from the delete.php file. Ajax Delete multiple data with checkboxes in PHP Jquery Mysql

Continue ReadingDelete multiple record with checkboxes in PHP Mysqli using Jquery AJAX
Live Search in PHP Mysqli using jQuery AJAX

In this post we are going to learn Live search in PHP Mysqli using jQuery AJAX.On most websites, we see a search bar on the website and we can search for content within it. If you use Facebook or Twitter, there is an outstanding direct search feature that you can use to find new friends or followers. Suppose we enter text on this site to find it. After that, we can get instant results from the site without refreshing the page. This function is performed by Ajax with Jquery. With the help of Jquery we can use the Ajax http dom function . Using this function, it searches data from the server and sends the results back to the front end of the website without refreshing the page. This function gives your website a stunning display. I have provided the source code with this post. I hope you learn these things.

Continue ReadingLive Search in PHP Mysqli using jQuery AJAX
Dynamic Dependent Drop down in PHP using jQuery AJAX

The dynamic dependent select box is used to automatically add dependent data to the drop-down list. Based on the drop-down options, the dependent data is retrieved from the database and displayed in the next select option field. In general, the field of dynamic dependency select option is used to implement the country,state and city functionality. Using Ajax and PHP, you can easily implement dynamically dependent drop-down without refreshing the page.

Continue ReadingDynamic Dependent Drop down in PHP using jQuery AJAX