資料庫連結
<code><span>$server</span> = <span>"127.0.0.1"</span>; <span>$username</span> = <span>"username"</span>; <span>$pass</span> = <span>"password"</span>; <span>$con</span> = new mysqli(<span>$server</span>,<span>$username</span>,<span>$pass</span>[,<span>$db_name</span>]); ///创建一个数据库链接,如果带上后面参数 <span>$db_name</span> 创建一个到数据库<span>$db_name</span>的链接,如果后面不带参数,创建一个到server的链接,在后面可以使用 <span>$con</span> -> select_db(<span>$db_name</span>);来选择数据表</code>
建立資料庫
<code><span>try</span>{
<span>$con</span> -> query(<span>$create_db</span>);
}<span>catch</span> (<span>exception</span><span>$e</span>){
}
<span>$con</span> -> select_db(<span>"nwpu"</span>);
<span>///使用try 可以避免重复创建数据库报错,</span></code>建立資料表
<code>$table = "<span><span>create</span><span>table</span> name(<span>".
"</span><span>first</span><span>varchar</span>(<span>20</span>) <span>PRIMARY</span><span>KEY</span>,<span>".
"</span>sec <span>VARCHAR</span>(<span>20</span>)<span>".
"</span>)<span>";
$con -> query($table);
///使用query执行sql语句</span></span></code>關閉資料庫
<code><span>$con</span> -> <span>close</span>();</code>
').addClass('pre-numbering')。 $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i
').text(i)); }; $numbering.fadeIn(1700); }); });以上就介紹了PHP 資料庫操作 mysqli，包含了面向的內容，希望對PHP教學有興趣的朋友有幫助。 🎜 🎜 🎜
