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>";
}
?>