From Core to Advanced
In this tutorial, we will learn how to get only date from timestamp in PHP. Timestamp or date-time object is very essential in creating dynamic web applications. It helps us to know the exact time and store the time in our MySQL database while inserting the data in the database or updating the data in … Read more
Edit Post Update How to Store Form Data in Session in PHP In this tutorial, we will learn how to store form data in a session in PHP. We will take an example as shown in the above image with the help of an HTML form. Using session, we can keep the form values even … Read more
There are two ways to get a date one month later in PHP By using the date function By using the DateTime::modify Illustration of the example using the date() function to get a date one month later in PHP We will use the date() function to get the date in a specific format. We will … Read more
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 to redirect to another web page to view some information. To simplify this problem, we will use a bootstrap modal which looks very user-friendly. After clicking the button, Below … 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. I have a table name “stepformtbl” in my database. DDL information of the table CREATE TABLE stepformtbl (id int(10) … 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