CMS takes the work out of building interactive websites.

Create a website at Omnis Network using Joomla, PostNuke or other popular software.

$5.95 Web Hosting
Installs instantly using the FANTASTICO script installer!!

Your site will have automatic features like member sign up and site search.

Features like message boards and chat are easily added.

PHP MySQL
Interactive Website Design

Creating the Database

We have provided 2 versions of code for creating a database via code. Newer versions of MySQL will require the second version.
If you download the zip package and have a new version of PHP be sure to use the new code. (Below)

NOTE: The best way to create your databases is by using the PHP MySQL Administration Panel, provided by your web host. Some web hosts, however will allow you create them using the code presented below.

The process of creating a database with scripting, actually requires one line of code after connecting to the server. In the code below, the line of code after the comment statement, creates a database named mydatabase.

<?php
$link = mysql_connect("localhost");
if (! $link)
die("Couldn't connect to MySQL");
//create database
mysql_create_db("mydatabase");

mysql_close($link);
?>

Newer versions use:
//create database
mysql_query("CREATE DATABASE mydatabase");

Note: The correct procedure for creating the database on the internet would be via your web host provided control panel. You would assign a username and password at the time of creation.

Download the Scripts

The Birthdays Database management files can be downloaded in a zip file. The package contains an integrated db management system, with a simple login file and interface. To run the scripts on your PC you must have a localhost server installed along with PHP and the MySQL server.
Download birthdays_db.zip

MySQL Tutorial

To extend your knowledge of MySQL study the Docs and Tutorials at the official MySQL website. MYSQL.com

Connect to the server Top Recommended $5.95 Hosting Creating a table
PHP MySQL is a service provided by Net Success 2000 Plus Inc
PO Box 1508
Somerset, KY 42502
Last Modified: July 2, 2007

| HTML TOC | Web Design | Create a Website |

PHP MySQL - Interactive Website Design Copyright © 2007