计应134（实验班） 幸南霖
当我开始去接触PHP的时候，真切的感受到其所具有的魅力，本着学习的态度和打破固有的语言和模式的想法，开始了MySQL之旅。
1.mysql扩展
<?php
//1:获取数据库连接$connection = @ mysql_connect(\'127.0.0.1:3306\', \'root\', \'root\') or die(\'Mysql connection failed \' . mysql_error());//2:选择数据库mysql_select_db(\'phptest\') or die(\'Database phptest not exist \' . mysql_error());//3:查询数据$sql = \'SELECT id as `编号`, name as `姓名`, birthday as `出生日期`, phone as `联系方式` , address as `地址` \' .\'FROM `t_user` LIMIT 0 , 30\';$result = mysql_query($sql) or die(\'Query failed \' . mysql_error());//4:处理查询结果#打印查询数据echo \'<table>\';#打印列信息$i = 0;echo \'<tr>\';while ($i < mysql_num_fields($result)) { $meta = mysql_fetch_field($result); echo \'<td>\'; echo $meta->name; echo \'</td>\'; $i++;}echo \'<tr/>\';#打印行记录while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo \'<tr>\'; foreach ($line as $value) { echo \'<td>\' . $value . \'</td>\'; } echo \'</tr>\';}echo \'</table>\';//5:释放结果内存mysql_free_result($result);//6:关闭数据库连接mysql_close($connection);?><?php
#使用面向对象的方式操作mysql数据库
//1:创建mysqli对象
$mysqli= newmysqli();
//2：连接数据库
$mysqli->connect(\'127.0.0.1\', \'root\', \'root\');
$mysqli->select_db(\'phptest\');
if($mysqli->connect_errno) {
echo\'连接数据库失败\';
exit();
}
//3:获取MySQLi_STMT(执行SQL命令)对象,$stmt
$sql= \'SELECT id as `编号`, name as `姓名`, birthday as `出生日期`, phone as `联系方式` , address as `地址` \'.
\'FROM `t_user` LIMIT 0 , 30\';
if($stmt= $mysqli->prepare($sql)) {
#执行查询
$stmt->execute();
$stmt->bind_result($id, $name, $birthday, $phone, $address);
#打印查询数据
echo\'<table>\';
#打印列信息
echo\'<tr>\';
$meta= $stmt->result_metadata()->fetch_fields();
foreach($metaas$val) {
echo\'<td>\';
echo$val->name;
echo\'</td>\';
}
echo\'<tr/>\';
while($stmt->fetch()) {
echo\'<tr>\';
echo\'<td>\'. $id. \'</td>\';
echo\'<td>\'. $name. \'</td>\';
echo\'<td>\'. $birthday. \'</td>\';
echo\'<td>\'. $phone. \'</td>\';
echo\'<td>\'. $address. \'</td>\';
echo\'</tr>\';
}
echo\'</table>\';
echo\'<h4>查询结果记录数：\'. $stmt->num_rows.\'</h4>\';
//4:关闭MySQLi_STMT
$stmt->close();
}
//5:关闭数据库连接
$mysqli->close();
?>
3.PDO_MYSQL扩展
数据库连接配置信息pdo-inc.php：
<?php $dsn = \'mysql:host=127.0.0.1:3306;dbname=phptest\';$username = \'root\';$password = \'root\';$opt = array ( PDO :: ATTR_TIMEOUT => 40);?><?php//1：引入数据库连接信息require_once (\'pdo-inc.php\');//2:创建PDO对象try { $pdo = new PDO($dsn, $username, $password, $opt);} catch (PDOException $e) { echo \'数据库连接失败 \' . $e->getMessage(); exit ();}$sql = \'SELECT id as `编号`, name as `姓名`, birthday as `出生日期`, phone as `联系方式` , address as `地址` \' .\'FROM `t_user` LIMIT 0 , 30\';//3：创建预编译命令对象PDOStatementif ($stmt = $pdo->prepare($sql)) { //4:执行 $stmt->execute(); #打印查询数据 echo \'<table>\'; echo \'<tr>\'; for ($i = 0, $columnCount = $stmt->columnCount(); $i < $columnCount; $i++) { $meta = $stmt->getColumnMeta($i); echo \'<td>\'; echo $meta[\'name\']; echo \'</td>\'; } echo \'<tr/>\'; $row_num = 0; while ($row = $stmt->fetch(PDO :: FETCH_NUM)) { $row_num++; echo \'<tr>\'; foreach ($row as $value) { echo \'<td>\' . $value . \'</td>\'; } echo \'</tr>\'; } echo \'</table>\'; #需要统计查询的行数 echo \'一共\' . $row_num . \'条记录<br/>使用PDOStatement::rowCount来统计，一共\' . $stmt->rowCount() . \'条记录\'; //5:关闭游标 $stmt->closeCursor();}//6:释放PDO对象$pdo = null;?>
请发表评论