PHP Tutorial

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 encryption to transfer data securely, or at least more seucrely than plain text, from a Visual Basic application (or other source) to a PHP API. Why Cryptography? Cryptography should be used for all sensitive information being used in public release applications, or if the data is sent cross-networks.

Introduction This tutorial is on using MD5 encryption in PHP. Why MD5? MD5 is built in to PHP and is only a one way encryption. This means that even if someone was able to gain access to an encrypted md5 string, called an 'MD5 Hash', it is unlikely they would be able to convert the hash back in to the original plain text string. Decryption: Decryption in most cryptography languages essentially work by using the reverse algorithm to the encryption algorithm used by the cryptography method in question.

Introduction: This tutorial is on how to process data through the GET type in PHP.

Introduction: This tutorial is on how to handle POST data in PHP. POST? POST Data in PHP is data that has been sent behind the scenes from another page, or external source, which can be accessed by the page being sent the information. POST is one of the two methods available to use through HTML Forms.

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

This tutorial is a continuation of our last topic called “How to Import CSV/Excel File into MySQL Database using PHP”. But this time, we will be focusing on how to Export MySQL Data into Excel file. To do this application open our last project called “excel”. At this time, we will modify the index file. To do this, open the “index.php” and add the following code above the table tag.

This tutorial will teach you on how to change table row background color when the qty is bellow 10. I use 10 as a default minimum value of qty, you can change it to any number if you want. This tutorial is helpful for thus creating a system that involves products. This is useful because it provides a legend or a prom the certain product is bellow the minimum qty. The admin can easily identify which product need to be order by the use of this feature.