Wednesday, December 26, 2007

PHP - MYSQL Programmers

DB Connection - mysql_connect('localhost', 'mysql_user', 'mysql_password')
Create DB
----------
$sql = 'CREATE DATABASE my_db';
if (
mysql_query($sql, $link)) {
echo
"Database my_db created successfully\n";
} else {
echo
'Error creating database: ' . mysql_error() . "\n";
}

Fetching datas
---------------

("localhost", "mysql_user", "mysql_password") or
die(
"Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while (
$row = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf("ID: %s Name: %s", $row["id"], $row["name"]);
}

mysql_free_result($result);
?>

1 comment: