PHP code examples with database connectivity

PHP code examples with database connectivity
 PHP.TheDemoSite.co.uk

Just examples of PHP code, linking to your MySQL database and JavaScript.
1. Home | 2. The Database | 3. Add a User | 4. Login | 5. Get your db online

PHP code examples with database connectivity

Also, while here don't forget to have a look at phpFormMailer (easy to use PHP form mail - more secure than many cgi form mail)

2. The Database

 

The MySQL database (you will need a MySQLi host also this host provides PHP PDO hosting) used for this example has a simple three field table named members.  The SQL query used to create the table is shown below:

CREATE TABLE members (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
password VARCHAR(12) NOT NULL,
username VARCHAR(12) NOT NULL,
index(password),
index(username))

As can be seen above the "id" is the primary key and is auto incremental.  The "username" and "password" fields are both indexed and must have a value to enter a valid record.  Now add a User to this table.

 


Managed dedicated servers
No hassle managed dedicated servers
No bandwidth limits
Seiretto.com


PHP and MySQL UK hosting
business database host providing shared and reseller hosting
Seiretto.co.uk


Reseller hosting businesss
Start your own reseller hosting business
Seiretto.com/reseller



TheDemoSite.co.uk is a MySQL database and PHP FREE code example site hosted with:
Seiretto website hosting Copyright © 1996-2008 Seiretto.  All rights reserved.