MYBLOG

下文为博主自学PHP的笔记，简要介绍了php对mysql的增删改查等操作，非常基础的知识。在这里记录一下，留做笔记。

1、数据库连接
<?
  $con=mysql_connect("127.0.0.1:3306","root","");
  if(!$con)
  {
    die("链接失败");
  }
 else
 {
   echo("数据库连接成功");
 }
 mysql_close($con);
?>
2、创建数据库
<?
  $con=mysql_connect("127.0.0.1:3306","root","");
  if(!$con)
  {
    die("链接失败");
  }
  $con=mysql_connect("127.0.0.1:3306","root","");
  if(!$con)
  {
    die("数据库连接失败");
  }
  if(mysql_query("CREATE DATABASE MyStudy",$con))
  {
    echo("数据库创建成功");
  }
  else
  {
    echo("数据库创建失败");
  }
  mysql_close($con);
?>
3、创建表
  <?
     $con=mysql_connect("127.0.0.1:3306","root","");
	 if(!$con)
	 {
	   die("数据库连接失败");
	 }
	 @mysql_select_db("MyStudy",$con);
	 $sql="CREATE TABLE USERINFOR(USERID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(USERID),USERNAME VARCHAR(150),PASSWORD VARCHAR(200));";
	 if(mysql_query($sql,$con))
	 {
	   echo("USERINFOR表创建成功！");
	 }
	 else
	 {
	  echo("USERINFOR表创建失败！");
	 }
	 mysql_close($con);
  ?>
4、插入数据
<?
  $con=mysql_connect("127.0.0.1:3306","root","");
  if(!$con)
  {
    die("数据库连接失败");
  }
  @mysql_select_db("MyStudy",$con);
  $sql="INSERT INTO USERINFOR(USERNAME,PASSWORD) VALUES('用户名','密码');";
  if(mysql_query($sql,$con))
  {
    echo("插入数据成功");
  }
  else
  {
    echo("插入数据失败");
  }
  mysql_close($con);
?>
5、数据库查询
<?
  $con=mysql_connect("127.0.0.1:3306","root","");
  if(!$con)
  {
    die("链接失败");
  }
  @mysql_select_db("test");
  $sql="SELECT * FROM USERINFOR";
  $rs=mysql_query($sql,$con);
  while($row=mysql_fetch_array($rs))
  {
    echo "$row[0]";
	echo "$row[1]";
	echo "$row[2]";
	echo "$row[3]";
  }
  mysql_close($con);
?>
6、Where条件
<?
  $con=mysql_connect("127.0.0.1:3306","root","");
  if(!$con)
  {
    die("数据库连接失败");
  }
  @mysql_select_db("test");
  $sql="SELECT USERNAME FROM USERINFOR WHERE USERNAME='admin'";
  $rs=mysql_query($sql,$con);
  while($row=mysql_fetch_array($rs))
  {
     echo "$row[USERNAME]";
  }
   mysql_close($con);
?>
7、Order By
<?
  $con=mysql_connect("127.0.0.1:3306","root","");
  if(!$con)
  {
    die("数据库链接失败");
  }
  @mysql_select_db("test");
  $sql="SELECT USERNAME FROM USERINFOR ORDER BY USERID DESC";
  $rs=mysql_query($sql,$con);
  while($row=mysql_fetch_array($rs))
  {
     echo "$row[USERNAME]";
  }
  mysql_close($con);
?>
8、更新数据
<?
  $con=mysql_connect("127.0.0.1:3306","root","");
  if(!$con)
  {
     die("数据库连接失败！");
  }
  @mysql_select_db("test");
  $sql="UPDATE USERINFOR SET PASSWORD='PASSWORD' WHERE USERID=1;";
  mysql_query($sql,$con);
  $rs=mysql_query("SELECT PASSWORD FROM USERINFOR WHERE USERID=1;",$con);
  while($row=mysql_fetch_array($rs))
  {
    echo "$row[PASSWORD]";
  }
  mysql_close($con);
?>
9、删除数据
<?
  $con=mysql_connect("127.0.0.1:3306","root","");
  if(!$con)
  {
     die("数据库连接失败");
  }
  @mysql_select_db("test");
  $sql="DELETE FROM USERINFOR WHERE USERID=1;";
  if(mysql_query($sql,$con))
  {
    echo("删除成功");
  }
  else
  {
    echo("删除失败");
  }
?>

笔记下载