creating data base

By: Unknown on 00:15

Create a DB
 
<?
mysql_connect('localhost');
if(mysql_query("CREATE DATABASE foo")) {
echo "Database foo created";
} else {
echo mysql_error();
}
?>
 
Output:
 
Database foo created 
Create a Table
<?
mysql_select_db('foo');
$result = mysql_query("CREATE TABLE users (
id varchar(16) binary NOT NULL default '',
Password varchar(16) NOT NULL default '',
Name varchar(64) default NULL,
email varchar(64) default NULL,
ts timestamp(14) NOT NULL,
PRIMARY KEY (id)
)");
if($result) {
echo "Table created";
} else {
echo mysql_error();
}
?>
Output:
 
Table created\

 Inserting Data
 
INSERT Query
<?php
function add_user($id, $pass, $name, $email) {
$result=mysql_query("insert into users values
('$id',ENCRYPT('$pass'),'$name','$email',NULL)");
if($result) {
echo "Row inserted<br />";
} else {
echo mysql_error()."<br />";
}
}
mysql_connect('localhost');
mysql_select_db('foo');
add_user('rasmus','foobar','Rasmus Lerdorf','rasmus@php.net');
add_user('carl','carlspass','Carl AlexandeR Lerdorf','carl@lerdorf.com');
?>
Output:
Row insertedRow inserted
                                     "NewsPowered by"