简单的数据库插入,查询功能
<?php
//本地服务器连接
$con = mysql_connect ( "localhost", "root", "12345678" );
if (! $con) {
echo 'loseConnect';
echo '<br/>';
} else {
echo 'connetSuccess';
echo '<br/>';
}
//数据库选择
mysql_select_db ( "mytest_1", $con );
//数据库输出格式
mysql_query ( "SET NAMES 'gbk'" );
//简单的插入功能
mysql_query ( "insert into student (name,sex,num) values ('李四','女','2003')" );
mysql_query ( "insert into student (name,sex,num) values ('王五','男','2004')" );
echo mysql_error ();
echo '<br/>';
// mysql_close($con);
//数据库查询并显示
$result = mysql_query ( "select * from student order by num" );
while ( $row = mysql_fetch_array ( $result ) ) {
echo $row ['name'] . " " . $row ['sex'] . " " . $row ['num'];
echo '<br/>';
}
?>