PHP

How to Add Seconds, Minutes, Hours, Days, Months and Years to a Date in PHP

In this tutorial, I'm going to show you how to add number of seconds, minutes, hours, days, months or years using PHP. This tutorial will not give you a good design but will give you idea on the topic. Also, If you wanted to convert our output date, you may do so by visiting my previous tutorial about Converting Date Formats. Creating Form and Output Date We determine our output date by user input upon submission.

How to Set up Expiration on MySQL Row in PHP/MySQLi

This tutorial will show you how to set up expiration on mysql row in PHP/MySQLi. In this tutorial, I've set up to update the expired row but in case that you wanted to delete the row, I've added the delete code in the comment. So feel free to switch it. This tutorial also has two mysqli methods that I've included in the comments as well so you can switch between them.

Creating our Database

I've created a sample database that we are going to use in this tutorial. 1. Open phpMyAdmin. 2. Click databases, create a database and name it as "expiration". 3.

Adding and Deleting Item(s) in Array using PHP

In my previous tutorial, I've created the Basic Array Functions. To follow up the tutorials about array, I've created another which will give you knowledge on how to add and delete item/s in array. This tutorial does not include a good design but will give you idea on the topic.

Creating our Form and Script

We create our add form, delete form and our scripts in adding and deleting items. To create the page, open your HTML code editor and paste the code below after the tag.

Getting the Last Inserted ID in MySQL Table using PHP

In this tutorial, I'm going to show you how to get the last inserted id in our database table. In this tutorial, I have set up an Insert Form to show the id that will be inserted in our MySQL database. I've included 2 mysqli methods in this tutorial in the comments. So, feel free to switch between the two. Creating our Database First, we're going to create a database that contains our data. 1

Converting From MySQL DateTime to another Format in PHP

In this tutorial, Im going to show you how to convert mysql datetime format into your desired format. I've added symbols and their value for you to further understand the conversion. This tutorial uses two mysqli methods that I have included in the comments. So, feel free to switch between the two. Creating our Database First, we're going to create a database that contains our data. 1. Open

How to Select Data By Month and Year in PHP/MySQL

In my previous tutorial, I've discussed How to Select Data between two Dates. So, I've created another topic regarding selecting data with dates which is on How to Select Data by Month and Year using PHP. Also, in this tutorial, I've created two mysqli methods that I've added in the comment so feel free to switch between them. Creating our Database First, we're going to create a database that

Selecting Rows from MySQL Table using checkbox in PHP/MySQL

In this tutorial, I'm going to show you how to select rows from MySQL Table using checkbox in PHP/MySQLi. This tutorial does not include a good design but will give you knowledge on the said topic. Creating our Database First, we're going to create a database that contains our data. 1. Open phpMyAdmin. 2. Click databases, create a database and name it as "checkbox". 3. After creating a database

Setting up Cookie upon Login using PHP/MySQLi

In my previous post, I created a Simple Login with Validation, so I've decided to create another tutorial to show how to set up cookie upon user login. But in this tutorial, I have created a simple login since the focus of this tutorial is to give you knowledge on how to set up cookie. Cookies are small amount of data that has been stored in user's computer. This is used so that when the same

Simple Running Time using PHP and Javascript

This tutorial will show you how to create a running time using PHP and Javascript. This tutorial does not include a good design but will give you knowledge on how to create a simple running time. Creating our Time Script This script creates our running time. In this script, we have also included a small PHP code to show our running time. So, for us to show the time in our desired page, we just

Easy and Simple Edit/Update MySQL Table using PHP

This tutorial will show and give you knowledge on how to edit/update MySQL table using PHP. Is this tutorial, I'm gonna show you how to edit using 3 methods namely MySQLi Object-oriented, MySQLi Procedural and PDO. Creating our Database First, we're going to create a database that contains our data. 1. Open phpMyAdmin. 2. Click databases, create a database and name it as "edit". 3. After creating