MYSQL

Introduction:

This tutorial is a continuation from my previous tutorial in which I covered the database design and HTML password reset form scripting for this password reset ticket system.

Part Two - Fake Data:

Before we can even think of making a password reset ticket system, we need to create a fake user to which we can reset their password.

Introduction:

This tutorial is on how to create a full ticket system in PHP, HTML, and MySQLi. Since ticket systems require a lot of fairly complex code, for beginners, this will be split up in to multiple tutorials/sections.

Introduction: This is a second part to my previous tutorial - 'Creating an Email Subscription List in PHP/MySQLi', found here; http://www.sourcecodester.com/tutorials/php/7813/email-subscription-list-phphtml.html Mail Function: Before we can begin with our actual email subscription email sending script, we need to know exactly how we are going to be sending our emails. Luckily enough, there is a built in function in to PHP called 'mail', guess what it does...

Introduction: This tutorial is on how to delete data through HTML/PHP from a MySQLi table. Listing: This tutorial is carrying on from my previous two tutorials in which I taught you how to insert and list data to/from a MySQL(i) database and table.

Introduction: This tutorial is on how to list data from a MySQL table. HTML: Before we begin, we are going to create some basic HTML code to correctly format our information we will be listing later.

Introduction: This tutorial will be on allowing users to input data in to an HTML form, and then upload that data to a MySQL database through PHP. HTML: First we need our HTML form. This example will just be for a user to enter their username and email address, we will not do any validation or username checking (to assure no duplicate usernames within our website) as this is not the purpose of this tutorial.

Introduction: This tutorial is on how to use timestamps properly in PHP and MySQLi to sort information from databases in to the correct order. What's a Timestamp? A timestamp is a data type in PHP and MySQL(i) which is used to hold the correct format of a specified date, time, or date and time together. Database: To enable a database table to hold a timestamp we can first create a database, named 'fln', then create a table named 'test', and give it the following column structure... id, int, 5 length, primary key, auto increment date, dateti