Display MySQL data in a modal on button click using ajax jquery PHP

In this tutorial, we will learn how to display MySQL data in a bootstrap modal on button click using ajax jQuery PHP. It seems very unprofessional while redirecting to another web page just to view some information. To simplify this problem, we will use a bootstrap modal which looks very user-friendly. After clicking the button, […]

How to export MySQL table data into excel using jQuery

Hi friends, in this tutorial we will learn how to export MySQL table data into excel using jQuery plugin. On the other hand, it can also be done with the help of PHP script. We will discuss it in the upcoming tutorial. But for now, in order to export table data successfully, we have to […]

Create multi-step form submission in PHP using jQuery

Hi Friends, In this tutorial, we will learn how to create multi-step form submission in PHP using jQuery. It is very simple and in order to do this, please follow the below steps one by one. We have to create a table in our database. I have a table name “stepformtbl” in my database. DDL […]

PHP difference between two dates in years, months and days

To calculate the PHP difference between two dates in years, months, and days, we have to use three functions strtotime() function floor() function() abs() function Read Here, strtotime, floor and abs functions in PHP Let us consider two dates and store in variables.$date1 = ‘2016-06-01’;$date2 = ‘2020-08-08’; Now, the difference between these two dates will […]

strtotime,floor,abs,ceil functions in PHP

strtotime():- This function converts and English text DateTime into a unique timestamp but we have to wrap the result using this date format date(‘Y-m-d’) to avoid the errors. For example The output is 2020-01-01 floor():- This function returns a number down to its nearest integer. For example The output will be like this—- Ceil():- This […]

Insert Multiple Rows Using the Same id in PHP

In this tutorial, we will learn how to insert multiple rows using the same id in PHP. For example, we have some fruit items like orange, mango, banana, etc. Now, we will consider the fruit as an item category and fruit-related items as a fruit subcategory. We will insert all the subcategory items using the […]

Insert Multiple Rows into MySQL with PHP Using Foreach Arrays

In this tutorial, we are going to learn how to insert multiple rows into MySQL with PHP using foreach arrays. To insert multiple form data, we need to generate multiple form rows and we will do it by using click function in jquery to generate the rows on clicking the button multiple times, and on […]

How to get value from ajax response in PHP

  In this tutorial, we are going to learn how to get value from ajax response in PHP. Most of the ajax request is sent via get() method but here we will use the post() method because post method is secure than get method and does not allow data to be shown in the URL. As […]

How to Append Data to Dropdownlist Using Jquery Ajax PHP

  In this tutorial, I am going to explain how to append data to dropdownlist using jquery ajax php. In order to do this, we use onchange function of jquery and send the data with get() or post() method to the ajax request and take the response data using ‘JSON’. For eg:- We have a […]

PHP MySQL ajax search autocomplete

  PHP MySQL ajax search autocomplete example In this tutorial, we will go through a PHP MySQL ajax search autocomplete example or jquery ajax search example. Here I am using a table named ‘users’ as we have to fetch the data from the users table to perform the search operation. In order to do the […]

Theme of 96 THEME.