mysql php语句_php+mysql中的一些语句

mysql建立一个表格：

create table hyhtbsc(

id int(4) primary key auto_increment,

username varchar(20),

password varchar(20)

);

查询数据库内容：

$conn = mysql_connect("localhost","root","pass");

mysql_select_db("mydb",$conn);

$sql = "select * from mytable";

$result = mysql_query($sql,$conn);

while($row = mysql_fetch_array($result)){

echo "

".$row['myfield']."";

}

mysql_free_result($result);

mysql_close($conn);

?>

添加数据库内容：

$id=trim($_POST['id']);

$conn = mysql_connect("localhost","root","pass");

mysql_select_db("mydb", $conn);

if($id != ''){

$sql="INSERT INTO ggs_chapter (id) VALUES ('".$book_id."')";

mysql_query($sql,$conn);

echo '添加成功！';

}

?>

$sql="select * from table"; $result=mysql_query($sql,$conn); while($row = mysql_fetch_array($result)){ echo "".$row['name'].""; } mysql_free_result($result); mysql_close($conn); ?>