PHP连接mysql数据库基本代码
版权声明:
本文为博主原创文章,转载请声明原文链接...谢谢。o_0。
更新时间:
2017-02-06 10:26:07
温馨提示:
学无止境,技术类文章有它的时效性,请留意文章更新时间,如发现内容有误请留言指出,防止别人"踩坑",我会及时更新文章
下面是使用mysqli 对象连接并操作数据库的方法(推荐)
//创建对象并打开连接,最后一个参数是选择的数据库名称 $mysqli = new mysqli('localhost', '用户名', '密码', '数据库名'); //检查连接是否成功 if (mysqli_connect_errno()) { //注意mysqli_connect_error()新特性 die('Unable to connect!') . mysqli_connect_error(); } $selectsql = "select * from yuming"; $res = $mysqli->query($selectsql); //取出数据 while ($row = $res->fetch_array()) { echo $row[0]; }
使用mysql连接数据库
//root是帐号,123456是密码 $conn = mysql_connect("localhost", 'root', '123456') or die(mysql_error()); //test是mysql数据库名 $mycon = mysql_select_db('test', $conn); if ($mycon) { echo ("数据库连接成功"); } else { echo ("数据库连接失败"); } //设置数据库连接字符集 mysql_query("set name utf8"); $rs = mysql_query("select * from biao"); if (mysql_num_rows($rs) != 0) { while ($row = mysql_fetch_array($rs)) { print_r($row['id'] . "<br>"); } } mysql_free_result($rs); mysql_close($conn);
使用pdo方式连接
$dbh = new PDO('mysql:host=localhost;dbname=access_control', 'root', ''); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $dbh->exec('set names utf8'); /*添加*/ //$sql = "INSERT INTO `user` SET `login`=:login AND `password`=:password"; $sql = "INSERT INTO `user` (`login` ,`password`)VALUES (:login, :password)"; $stmt = $dbh->prepare($sql); $stmt->execute(array(':login' => 'kevin2', ':password' => '')); echo $dbh->lastinsertid(); /*修改*/ $sql = "UPDATE `user` SET `password`=:password WHERE `user_id`=:userId"; $stmt = $dbh->prepare($sql); $stmt->execute(array(':userId' => '7', ':password' => '4607e782c4d86fd5364d7e4508bb10d9')); echo $stmt->rowCount(); /*删除*/ $sql = "DELETE FROM `user` WHERE `login` LIKE 'kevin_'"; $stmt = $dbh->prepare($sql); $stmt->execute(); echo $stmt->rowCount(); /*查询*/ $login = 'kevin%'; $sql = "SELECT * FROM `user` WHERE `login` LIKE :login"; $stmt = $dbh->prepare($sql); $stmt->execute(array(':login' => $login)); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { print_r($row); } print_r($stmt->fetchAll(PDO::FETCH_ASSOC)); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); //不显示错误 $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); //显示警告错误,并继续执行 $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //产生致命错误,PDOException
防止sql注入的方法
//pdo的方法 $username = PDO::quote($_GET['username']); $pdo->query("SELECT * FROM users WHERE username = $username"); //mysqli的方法 $username = mysqli_real_escape_string($_GET['username']); $mysqli->query("SELECT * FROM users WHERE username = '$username'");