数据库链接
<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').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i ').text(i)); }; $numbering.fadeIn(1700); }); });
以上就介绍了PHP 数据库操作 mysqli,包括了方面的内容,希望对PHP教程有兴趣的朋友有所帮助。