How to Create a Simple Search on MySQL Table using PHP, MySQLi and AJAX

6 years ago By nurhodelta_17
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.

Daily Time Record (DTR) for OJT

6 years ago By Dhatz Edsil
Daily Time Record for OJT system is a system capable of recording and tracking On-the-Job trainees. It is effecient since the ojt's will just log into the system and it will records its log. After recording the logs of trainess, the system is capable of exporting these records via MS Excel or MS Word. The system uses DataTable which make the presentation of records organize. contact me if you want

How to Download File using PHP/MySQLi

6 years ago By nurhodelta_17
In my previous tutorial, I've created a Simple File Upload using PHP/MySQLi. As a follow-up, I've created another tutorial on how to create a Simple File Download. Most files can be easily download by clicking their link. However, some files cannot be downloaded by doing so. Thus, I've created this tutorial. This tutorial will not give you a good design, but will give you a good idea about the

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

6 years ago By nurhodelta_17
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

6 years ago By nurhodelta_17
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.

How to Set Up Expiration to Sessions using PHP

6 years ago By nurhodelta_17
In this tutorial I'm going to show you how to set up expiration on PHP sessions. I have created a simple login in this tutorial but if you prefer, may also learn Login with Validation in my previous tutorial. This tutorial will not give you a good design but will give you an idea in setting up session and expiry in PHP.

Creating our Login Form and Login Script

First, we create our login form with the login script.

Adding and Deleting Item(s) in Array using PHP

6 years ago By nurhodelta_17
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.
Subscribe to