简单的MYSQL数据库处理

来源：互联网发布：js 通过class 隐藏编辑：程序博客网时间：2024/05/21 21:45

$conn=mysql_connect("loaclhost","root","admin");
if(!$conn){
   echo "数据库连接成功！";}
   else{
   echo "数据库连接失败！";
}
?>
//创建一个名为a的数据库
<?php
$conn=mysql_connect("localhost","root","admin");
if(!$conn){
     die('不能够连接数据库'.mysql_error());
   }
   if(mysql_query("CREATE DATABASE a",$conn)){
    echo "DATABASE created";
   }
   else{
   echo "Error creating database:".mysql_error();
   }
   mysql_select_db("a",$conn);//选择数据库a
   $sql="CREATE TABLE B(//创建数据表B
   ID int NOT NULL AUTO_INCREMENT,//NOT NULL确保主键字段不为空AUTO_INCREMENT新纪录被添加时逐一增加该字段的值
   PRIMARY KEY(ID),//把ID设置为主键
   FirstName varchar(15),
   LastName varchar(15),Aga int)";
   masql_query($sql,$conn);
   mysql_close();//提前关闭连接
?>
<?php
$conn=mysql_connect("localhost","root","admin");
if(!$conn){
die('不能够连接数据库'.mysql_error());
}
mysql_select_db("a",$conn);
mysql_query("INSERT INTO B(FirstName,LastName,Aga)VALUES('chen','yicai','20')");
mysql_query("INSERT INTO B(FirstName,LastName,Aga)   VALUES('SKAIH','DW','20')");
mysql_close();
?>
//选取数据
<?php
$conn=mysql_connect('localhost','root','admin');
if(!$conn){
die('不能连接到数据库'.mysql_error());
}
mysql_select_db("a",$conn);
$result=mysql_query("SELECT * FROM B");
while($row=mysql_fetch_array($result)){ //mysql_fetch_array($result)函数以数组的形式从记录集返回第一行
echo $row['FirstName']."".$row['LastName']."<br/>";
}
?>
<?php
$conn=mysql_connect('loaclhost','root','admin');
if(!$conn){
die("数据库不能连接到".mysql_error());
}
mysql_select_db("a",$conn);
$result=mysql_query("SELECT * FROM B WHILE FirstName='chen'");//从B中选取所有FirstName='chen'的行
while($row=mysql_fetch_array（$result)){
echo $row['FirstName']."".$row['LastName']."<br/>";
}
?>
//排序数据
<?php
$conn=mysql_connect("loaclhost","root","admin");
if(!$conn){
die("连接不到数据库！".mysql_error());
}
mysql_select_db("a",$conn);
$result=$mysql_query("SELECT ?*FROM B OBDER BY age");//根据Age列对结果进行排序
while($row=mysql_fetch_array($result))
{
echo $row['FirstName'];
echo "".$row['LastName'];
echo "".$row['Age'];
echo "<br/>";
}
mysql_close($conn);
?>
//修改数据
<?php
$conn=mysql_connect("loaclhost","root","admin");
if(!$conn){
die("无法连接数据库！".mysql_error());
}
mysql_select_db("a",$conn);
$result=mysql_query("UPDATE B SET Age='20' WHILE FirstName='chen' AND LastName='yicai'");
mysql_close($conn);
?>
//删除数据
<?php
$conn=mysql_connect(“localhost”,"root","admin");
if(!$conn){
   die("无法连接数据库！".mysql_error());
}
mysql_select_db("a",$conn);
mysql_query("DELECT FROM B WHILE LastName='yicai'");
?>

0 0