From Core to Advanced
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
Hi friends, in this tutorial you will learn how to perform the login and logout using session in PHP and MySQLi or PDO. In order to perform, we need three files with the .php extension. 1. login.php 2. home.php 3. logout.php Here, we will not be doing registration … Read more
In this tutorial, I am going to explain the process of how to Upload image in PHP MySQL Database and display that image from the database and store it in the project folder. First of all, we have to create a table in the database and then we can insert the image in that particular … Read more
In this tutorial, I am going to explain the crud operation in PHP using ajax jquery in MySQL as given below—- 1. How to insert, edit, and delete the form data in PHP using ajax jquery i.e. without reloading the page. 2. How to validate the HTML … Read more