PHP自学第一课

最新推荐文章于 2024-03-18 09:58:54 发布

bobo11436906

最新推荐文章于 2024-03-18 09:58:54 发布

阅读量350

点赞数

分类专栏： PHP学习数据库连接文章标签： PHP数据库链接

本文链接：https://blog.csdn.net/bobo11436906/article/details/51816457

版权

PHP学习同时被 2 个专栏收录

1 篇文章 0 订阅

订阅专栏

数据库连接

1 篇文章 0 订阅

订阅专栏

1.PDO链接方式

try

{
   $conn = new PDO('mysql:host=localhost;dbname=toha','root', '3602001');

   if (!$conn) {
        echo "链接数据库失败！";
   }
   $sqlInsert = "SELECT * FROM memberinfo";
   $conn->exec("set names utf8");

   $stmt = $conn->prepare($sqlInsert);
   $rs = $stmt->execute();
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $name = $row['NAME'];
    $pwd = $row['pwd'];
    echo "Name: $name ";
    echo "Age: $pwd ".'<br/>';
}
}
catch(Exception $ex)
{
   echo $ex;

}

2. mysq原方法

$conn = mysql_connect('localhost','root','3602001');
if (!$conn) {
   die('Could not connect: ' . mysql_error());
}

$Sql = "SELECT * FROM memberinfo where NAME = '$_POST[username]'";
$sqlInsert = " INSERT INTO memberinfo(NAME,pwd) values('$_POST[username]','$_POST[pwd]')";
mysql_select_db('toha');
mysql_set_charset('utf8',$conn);
$rs = mysql_query($Sql,$conn);
if (mysql_num_rows($rs)<1) {
   $rs2 = mysql_query($sqlInsert,$conn);
   if ($rs2) {
       exit("成功");
   }
}