From Core to Advanced
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, … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 the click function in jquery to generate the rows on clicking the button multiple times, and … Read more
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 the post method is more secure than get method and does not allow data to be shown in the URL. … Read more
In this tutorial, I am going to explain how to append data to dropdown list 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 … Read more
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 user’s table to perform the search operation. In order to do the search successfully, we need to know three … Read more
