Monday, December 31, 2007

Array Random

((float) microtime() * 10000000);
$input = array("Neo", "Morpheus", "Trinity", "Cypher", "Tank");
$rand_keys = array_rand($input, 2);
echo
$input[$rand_keys[0]] . "\n";
?>

Shuffle

$numbers= range(1, 20);
srand((float)microtime() * 1000000);
shuffle($numbers);
foreach (
$numbers as $number) {
echo
"$number ";
}

Last Inserted ID

$con = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!
$link) {
die(
'Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');

mysql_query("INSERT INTO mytable (product) values ('kossu')");
printf("Last inserted record has id %d\n", mysql_insert_id());

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);
?>