bitscn.com
mysql入门之二_php操作mysql
1.        本地连接mysql
$con= mysql_connect(localhost, root, xxxxxx);
if(!$con) {
die('could not connect: ' .mysql_error());
}else {
echoconnect success
/n;
}
2.        sae连接mysql
$con =mysql_connect(sae_mysql_host_m.':'.sae_mysql_port,
sae_mysql_user,sae_mysql_pass);
if (!$con) {
die('could not connect: ' .mysql_error());
} else {
echoconnect success
/n;
}
mysql_select_db(sae_mysql_db,$con);
3.        断开mysql
mysql_close($con);
4.        建立数据库
$sql = create database ifnot exists $database_name;
if(mysql_query($sql, $con)) {
echo database create success
/n;
}else {
echoerror creating database: . mysql_error() .
/n;
}
5.        连接使用数据库
mysql_select_db($database_name,$con);
6.        建立数据表
$sql =create table $table_name (
namevarchar(80),
ageint
)engine=myisam default charset=utf8;
if(mysql_query($sql,$con)) {
echo table create success
/n;
}else {
echoerror creating table: . mysql_error() .
/n;
}
7.        查找数据
$sql= select * from $table_name where name like /%$input%/;
$result= mysql_query($sql,$con);
while($row =mysql_fetch_array($result)) {
echo$row['name'] . . $row['age'];
echo
;
}
8.        设置字符集（设置之后的sql操作基于utf8字符集）
mysql_query(set names 'utf8');
mysql_query(set character_set_client=utf8);
mysql_query(set character_set_results=utf8);
bitscn.com