1.
<?php
/* MySQL
Create DATABASE foo CharSet GBK
Create Database foo CharSet UTF8
*/
$conn = mysql_connect (' localhost ', ' root ', ');
if ($conn) {
echo ' Connect success ';
mysql_select_db (' MyApp ', $conn);
$result = mysql_query ("Select ID, name from users WHERE id = 1");
$result _arr = Mysql_fetch_assoc ($result);
Print_r ($result _arr);
$result _arr = Mysql_fetch_assoc ($result);
Print_r ($result _arr);
echo ' Data length: '. mysql_num_rows ($result);
$data _count = mysql_num_rows ($result);
for ($i =0; $i < $data _count; $i + +) {
Print_r (MYSQL_FETCH_ASSOC ($result));
// }
$result = mysql_query ("Select COUNT (*) from users WHERE name = ' Iwen '");
if ($result) {
$result _arr = mysql_fetch_array ($result);
echo ' Data length: '. $result _arr[0];
}else{
echo ' Query fail ';
}
}else{
echo ' Connect fail ';
}
PHP Operations Database