PHP mysql CREATE INSERT SELECT

来源：互联网发布：mac git文件夹打不开编辑：程序博客网时间：2024/06/01 09:58

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