PHP

In this tutorial, I'll show you how to create a simple search on mysql table using PHP, MySQLi and AJAX. This tutorial does not include a good design but will give you an idea on how to search for rows in mysql table.

Creating our Database

First, we're going to create our database. This contains the data that we are going to search. 1. Open phpMyAdmin. 2. Click databases, create a database and name it as "ajax_search". 3. After creating a database, click the SQL and paste the below code.

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.

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.

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.