PHP mysql CREATE INSERT SELECT

 

index.php

<?php

$accounts = mysql_connect("localhost","root","2009") or die (mysql_error());

mysql_select_db("realmd",$accounts);
$sql = "create table zxl
(
ID int not null AUTO_INCREMENT,
primary key(ID),
Username char(20),
Password char(20)

)";

mysql_query($sql,$accounts);
echo 'OK';

?>

 

 

 

 

 

 

插入数据

<?php

$accounts = mysql_connect("localhost","root","2009") or die (mysql_error());

mysql_select_db("realmd",$accounts);
$sql = "

INSERT INTO zxl (Username,Password) VALUES('uu','pp');

";

mysql_query($sql,$accounts);
echo 'OK';

?>

 查询:

<?php

$accounts = mysql_connect("localhost","root","2009") or die (mysql_error());

mysql_select_db("realmd",$accounts);
$sql = "

SELECT * FROM zxl ;

";

$result = mysql_query($sql,$accounts);
while($row = mysql_fetch_array($result)){
$username = $row['Username'];
$password = $row['Password'];

echo $row['Username'] . " password is " . $row['Password'] . "<br>";
}


?>