PHP基本

最新推荐文章于 2022-05-06 08:07:31 发布

luqiao1976

最新推荐文章于 2022-05-06 08:07:31 发布

阅读量240

点赞数

分类专栏：备忘

本文链接：https://blog.csdn.net/pxgame/article/details/79893951

版权

备忘专栏收录该内容

16 篇文章 0 订阅

订阅专栏

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>

<?php

$con=mysql_connect("localhost","root","");// or die('Error:'.mysql_error());
if(!$con){
die("连接失败!".mysql_errno());

}
echo "连接数据库成功";

//建库建表
/*
mysql_query("CREATE DATABASE dbmysql",$con);
mysql_select_db("dbmysql",$con);
$sql="CREATE TABLE person (personID int NOT NULL AUTO_INCREMENT,FirstName varchar(15),LastName varchar(15),Age int,PRIMARY KEY(personID))";
$str=mysql_query($sql,$con);
echo "<br>".$str."<br>";
*/

mysql_select_db("dbmysql",$con);

//往表里插数据
/*
mysql_query("insert into person(`FirstName`, `LastName`, `Age`)values('tom','tony','20')");
mysql_query("insert into person(`FirstName`, `LastName`, `Age`)values('lh','h','16')");
mysql_query("insert into person(`FirstName`, `LastName`, `Age`)values('jy','j','24')");
*/

//查询数据
$result=mysql_query("select * from person");
while($row=mysql_fetch_array($result)){
echo $row["FirstName"]."".$row["LastName"];
echo "<br>";
}
/*
//更新数据
mysql_query("update person set FirstName='dx',LastName='x',`Age`=18 where `personID`=3");
//删除数据
mysql_query("delete from person where `personID`=2");

//mysql_list_dbs()函数==>列出 MySQL 服务器中所有的数据库
$dl=mysql_list_dbs($con);
while($db=mysql_fetch_object($dl)){
echo $db->Database."<br>";
}

//mysql_num_fields()函数==>返回结果集中字段的数
$db_selected = mysql_select_db("dbmysql",$con);
$sql = "SELECT * FROM person";
$result = mysql_query($sql,$con);
echo mysql_num_fields($result);//输出列的个数

//mysql_num_rows()函数==>返回结果集中行的数目
echo mysql_num_rows($result);//查询出的总行数

//mysql_affected_rows()函数==>返回前一次MySQL操作所影响的记录行数
mysql_select_db("dbmysql");
mysql_query("DELETE FROM person WHERE personid =3");
$rc = mysql_affected_rows();
echo "Records deleted: " . $rc;

//mysql_real_escape_string()函数==>转义SQL语句中使用的字符串中的特殊字符
//获得用户名和密码的代码
$user="a\r\nbc";
$pwd="a\r\nbc";
//转义用户名，以便在 SQL 中使用
$user = mysql_real_escape_string($user);
$pwd = ($pwd);
$sql = "SELECT * FROM users WHERE user='" . $user . "' AND password='" . $pwd . "'";
echo $sql; //用户名和密码对比

//mysql_result() 函数返回结果集中一个字段的值
$db_selected = mysql_select_db("dbmysql", $con);
$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);
echo mysql_result($result,1,2);
mysql_close($con);
*/

?>
</body>
</html>