mysql语句 php_PHP+MYSQL 执行SQL语句

header("Content-type:text/html;charset=gbk");

?>

$host = "127.0.0.1";

$userName = "root";

$password = "root";

$dbName = "db_database13";

$connID = mysql_connect($host, $userName, $password);

mysql_select_db($dbName, $connID);

mysql_query("set names gbk");

echo "

学号

姓名

班级

语文

数学

英语

$query = mysql_query("select sno, sname, class, chinese, math ,english from tb_student", $connID);

while($result = mysql_fetch_array($query))

{

echo "

".$result["sno"]."".$result["sname"]."".$result["class"]."".$result["chinese"]."".$result["math"]."".$result["english"]."";

}

echo "

";

mysql_close($connID);

?>