Simple Chat using PHP, MySQLi, AJAX and JQuery

Submitted by nurhodelta_17 on
In this tutorial, I'm going to show you how to create a simple chat using PHP, MySQLi, AJAX and JQuery. I have created a sample chat room and sample users to focus this tutorial on creating a simple chat. Also, I have created a simple login, but if you want, you may learn How to Create a Login with Validation.

Creating our Database

First, we're going to create our database to hold our sample data and our chats. 1. Open phpMyAdmin. 2.

Simple FB-like Comment using PHP, MySQLi, AJAX and JQuery

Submitted by nurhodelta_17 on
In this tutorial, I'm gonna show you how to create a simple fb-like comment using PHP, MySQLi, AJAX and JQuery. This tutorial will show you how to comment on one post which I've prepared as a sample. This does not a include a good design but will give you idea on the topic.

Creating our Database

First, we're going to create our database. This will store our post and comment data. 1. Open phpMyAdmin. 2. Click databases, create a database and name it as "fb_db". 3. After creating a database, click the SQL and paste the below codes.

How to Insert Data into MySQL Database using PHP, MySQLi, AJAX and JQuery

Submitted by nurhodelta_17 on
This tutorial will show you how to insert data into mysql database using PHP, MySQLi, AJAX and JQuery. You might wonder why use AJAX and JQuery when you can insert into database using PHP and MySQLi. Yes, but with the use of AJAX and JQuery, you don't need to reload the page in doing an action. This tutorial will not give you a good design but will give you idea on the topic. Creating our Database

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

Submitted by nurhodelta_17 on
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

Submitted by Dhatz Edsil on
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

Submitted by nurhodelta_17 on
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

Submitted by nurhodelta_17 on
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

Submitted by nurhodelta_17 on
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.