PHP MySQL扩展连接数据库代码示例
<?php
//PHP MySQL扩展连接数据库代码示例
/*------------------------------------------------------ */
//-- 数据库配置
/*------------------------------------------------------ */
$db_server = '127.0.0.1:3306'; //localhost::3306
$db_username = 'root';
$db_password = 'root';
$db_database = 'study';
$db_link = mysql_connect($db_server, $db_username, $db_password);
$db_charset = 'utf8';
if (!$db_link) {
die('Could not connect: ' . mysql_error());
}
//设置字符集
mysql_query('SET NAMES ' . $db_charset);
//选择数据库
//方法一:
//$sql = 'USE '.$db_database;
//mysql_query($sql,$db_link);
//mysql_query($sql);
//方法二:
mysql_select_db($db_database, $db_link);
/*------------------------------------------------------ */
//-- 增删改查
/*------------------------------------------------------ */
//查询数据
$sql = 'SELECT * FROM `students` WHERE 1 ';
$result = mysql_query($sql, $db_link);
$list = array();
while ($row = mysql_fetch_assoc($res)) {
$list[] = $row;
}
mysql_free_result($result);
//添加数据
$sql = 'INSERT INTO `students` (`sname`,`ssex`,`sbirthday`,`class`) VALUES ("小明","男","2008-11-05","123")';
$result = mysql_query($sql, $db_link);
if ($result) {
echo '添加数据成功';
} else {
echo '添加数据失败';
}
//修改数据
$sql = 'UPDATE `students` SET `class`=456 WHERE `class`= 95033';
$result = mysql_query($sql);
if ($result) {
echo '修改数据成功';
} else {
echo '修改数据失败';
}
//删除数据
$sql = 'DELETE FROM `students` WHERE `sname`="小明"';
$result = mysql_query($sql);
if ($result) {
echo '删除数据成功';
} else {
echo '删除数据失败';
}
//关闭mysql连接
mysql_close($db_link);
