您好,登錄后才能下訂單哦!
本篇文章給大家分享的是有關(guān)怎么在PHP中使用MariaDB實(shí)現(xiàn)數(shù)據(jù)庫(kù)操作,小編覺(jué)得挺實(shí)用的,因此分享給大家學(xué)習(xí),希望大家閱讀完這篇文章后可以有所收獲,話(huà)不多說(shuō),跟著小編一起來(lái)看看吧。
<?php $db = new mysqli('localhost', 'root', 'admin', 'test'); if (mysqli_connect_errno()) { echo '<p>' . 'Connect DB error'; exit; } ?>
其實(shí)這問(wèn)題比較簡(jiǎn)單,從PHP引擎返回的錯(cuò)誤就知道m(xù)ysqli沒(méi)有被正確的加載,絕大多數(shù)的問(wèn)題都發(fā)生在php.ini文件的配置中,“extension=php_mysqli.dll”這個(gè)配置項(xiàng)前面默認(rèn)的分號(hào)沒(méi)有去掉。這個(gè)錯(cuò)誤我倒沒(méi)有犯,php安裝路徑中的ext目錄中,也有php_mysqli.dll這個(gè)文件,那問(wèn)題發(fā)生在哪里呢?問(wèn)題應(yīng)該還是發(fā)生在php.ini文件中哪個(gè)地方寫(xiě)錯(cuò)了。走讀后發(fā)現(xiàn)“extension_dir = "ext"”個(gè)地方?jīng)]有修改。我當(dāng)時(shí)腦子沒(méi)多想,覺(jué)得PHP引擎是能夠自動(dòng)找到這個(gè)相對(duì)路徑的。但后來(lái)想想,PHP引擎是被Apache加載的,Apache可不知道這個(gè)相對(duì)關(guān)系。還是老老實(shí)實(shí)的把這個(gè)地方改成了絕對(duì)路徑,OK了。其實(shí)可以在這個(gè)代碼之前,先寫(xiě)這么一段代碼,看看mysqli組件是否已經(jīng)被加載了,這個(gè)方法適用于其他組件的加載前的判斷。
if (extension_loaded('mysqli')) { echo 'yes'; } else { echo 'no'; }
下面用一個(gè)用戶(hù)注冊(cè)和系統(tǒng)登錄記錄PHP+MySQL的最基本操作方法。
1、創(chuàng)建數(shù)據(jù)庫(kù)、表和用戶(hù)。
DROP DATABASE IF EXISTS `test`; CREATE DATABASE `test` USE `test`; DROP TABLE IF EXISTS `tbl_user`; CREATE TABLE `tbl_user` ( `username` varchar(32) NOT NULL default '', `password` varchar(32) NOT NULL default '', PRIMARY KEY (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
2、創(chuàng)建注冊(cè)和登錄的html頁(yè)面,分別是register.html和login.html。如下圖所示:
3、注冊(cè)和登錄的代碼:
register_do.php
<?php $username = $_POST['username']; $password = $_POST['password']; $db = new mysqli('localhost', 'root', 'admin', 'test'); if (mysqli_connect_errno()) { echo '<p>' . 'Connect DB error'; exit; } $query = "select * from tbl_user where username = '" . $username . "'"; echo '<p>' . $query; $result = $db->query($query); if ($result) { echo '<p>' . 'The user '. $username .' exist'; echo '<p>' . '<a href="register.html" rel="external nofollow" rel="external nofollow" >Back to register</a>'; } else { $query = "insert into tbl_user values ('". $username ."', '". $password ."')"; echo '<p>' . $query; $result = $db->query($query); if ($result) { echo '<p>' . '<a href="register.html" rel="external nofollow" rel="external nofollow" >Register successful</a>'; } } ?>
login_do.php
<?php $username = $_POST['username']; $password = $_POST['password']; $db = new mysqli('localhost', 'root', 'admin', 'test'); if (mysqli_connect_errno()) { echo '<p>' . 'Connect DB error'; exit; } $query = "select * from tbl_user where username = '" . $username . "' and password = '" . $password . "'"; echo '<p>' . $query; $result = $db->query($query); if ($result->num_rows) { echo '<p>' . '<a href="login.html" rel="external nofollow" rel="external nofollow" >Login successful</a>'; } else { echo '<p>' . '<a href="login.html" rel="external nofollow" rel="external nofollow" >Login failed</a>'; } ?>
userlist.php
<?php $db = new mysqli('localhost', 'root', 'admin', 'test'); if (mysqli_connect_errno()) { echo '<p>' . 'Connect DB error'; exit; } echo '<p>' . 'All user as follows:'; $query = "select * from tbl_user order by username"; if ($result = $db->query($query)) { while ($row = $result->fetch_assoc()) { echo '<p>' . 'Username : ' . $row['username'] . ' <a href="userdelete.php?username=' . $row['username'] . '" rel="external nofollow" >delete</a>'; } } ?>
4、該頁(yè)面最終的顯示效果如下圖所示:
5、刪除用戶(hù)的代碼:
userdelete.php
<?php $username = $_GET['username']; $db = new mysqli('localhost', 'root', 'admin', 'test'); if (mysqli_connect_errno()) { echo '<p>' . 'Connect DB error'; exit; } $query = "delete from tbl_user where username = '" . $username . "'"; echo $query; if ($result = $db->query($query)) { echo '<p>' . 'Delete user ' . $username . ' successful'; } else { echo '<p>' . 'Delete user ' . $username . ' failed'; } echo '<p>' . '<a href="userlist.php" rel="external nofollow" >Back to user list</a>'; ?>
Prepare預(yù)處理
1、圖書(shū)添加的頁(yè)面如下圖所示(bookadd.html):
2、建表腳本如下:
DROP DATABASE IF EXISTS `test`; CREATE DATABASE IF NOT EXISTS `test`; USE `test`; DROP TABLE IF EXISTS `tbl_book`; CREATE TABLE IF NOT EXISTS `tbl_book` ( `isbn` varchar(32) NOT NULL, `title` varchar(32) NOT NULL, `author` varchar(32) NOT NULL, `price` float NOT NULL, PRIMARY KEY (`isbn`) ) ENGINE=InnoDB DEFAULT CHARSET=utf-8;
3、添加的邏輯處理代碼如下(bookadd_do.php):這里特別要注意的是這句話(huà)“$db->query("set names utf-8")
”,代表向數(shù)據(jù)庫(kù)寫(xiě)入數(shù)據(jù)時(shí),采用utf-8編解碼,顯示的對(duì)數(shù)據(jù)庫(kù)表操作的編解碼進(jìn)行設(shè)置,以防止中文的亂碼。后面我會(huì)專(zhuān)門(mén)針對(duì)這個(gè)技術(shù)點(diǎn)記錄一篇文章。
<?php $isbn = $_POST['isbn']; $title = $_POST['title']; $author = $_POST['author']; $price = $_POST['price']; $db = new mysqli('localhost', 'root', 'admin', 'test'); if (mysqli_connect_errno()) { echo '<p>' . 'Connect DB error'; exit; } $db->query("set names utf-8"); //特別注意這句話(huà) $stmt = $db->stmt_init(); $stmt->prepare("insert into tbl_book values (?,?,?,?)"); $stmt->bind_param("sssd", $isbn, $title, $author, $price); $stmt->execute(); echo '<p>' . 'Affect rows is ' . $stmt->affected_rows; echo '<p>' . '<a href="booklist.php" rel="external nofollow" >Go to book list page</a>'; ?>
4、顯示圖書(shū)信息的邏輯代碼如下,同樣注意這句話(huà)“$db->query("set names utf-8")
”:
<?php $db = new mysqli('localhost', 'root', 'admin', 'test'); if (mysqli_connect_errno()) { echo '<p>' . 'Connect DB error'; exit; } $db->query("set names utf-8"); //特別注意這句話(huà) $stmt = $db->stmt_init(); $stmt->prepare("select * from tbl_book"); $stmt->bind_result($isbn, $title, $author, $price); $stmt->execute(); while($stmt->fetch()) { echo 'ISBN : ' . $isbn . '<p>'; echo 'Title : ' . $title . '<p>'; echo 'Author : ' . $author . '<p>'; echo 'Price : ' . $price . '<p>'; echo '<p>' . '-----------------------------' . '<p>'; } ?>
5、顯示的頁(yè)面如下圖所示:
以上就是怎么在PHP中使用MariaDB實(shí)現(xiàn)數(shù)據(jù)庫(kù)操作,小編相信有部分知識(shí)點(diǎn)可能是我們?nèi)粘9ぷ鲿?huì)見(jiàn)到或用到的。希望你能通過(guò)這篇文章學(xué)到更多知識(shí)。更多詳情敬請(qǐng)關(guān)注億速云行業(yè)資訊頻道。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。