php对mysql数据库简单连接操作
- 原创
- 2016-12-05 13:26:26 1687浏览
前些阵子忙完了公司前端静态页面的事情了之后，简单学习了下php的基础知识，今天想了想回顾一下php连接数据库的方式，写一下随笔存一下看看
php连接数据库端口和新建数据库
<span style="color: #000000">php
</span><span style="color: #800080">$servername</span> = "localhost"<span style="color: #000000">;
</span><span style="color: #800080">$username</span> = "root"<span style="color: #000000">;
</span><span style="color: #008000">//</span><span style="color: #008000"> 创建连接</span>
<span style="color: #800080">$conn</span> = <span style="color: #008080">mysqli_connect</span>(<span style="color: #800080">$servername</span>, <span style="color: #800080">$username</span><span style="color: #000000">);
</span><span style="color: #008000">//</span><span style="color: #008000"> 检测连接</span>
<span style="color: #0000ff">if</span> (!<span style="color: #800080">$conn</span><span style="color: #000000">) {
</span><span style="color: #0000ff">die</span>("连接失败: " . <span style="color: #008080">mysqli_connect_error</span><span style="color: #000000">());
}
</span><span style="color: #008000">//</span><span style="color: #008000"> 创建数据库</span>
<span style="color: #800080">$sql</span> = "CREATE DATABASE myDB"<span style="color: #000000">;
</span><span style="color: #0000ff">if</span> (<span style="color: #008080">mysqli_query</span>(<span style="color: #800080">$conn</span>, <span style="color: #800080">$sql</span><span style="color: #000000">)) {
</span><span style="color: #0000ff">echo</span> "数据库创建成功"<span style="color: #000000">;
} </span><span style="color: #0000ff">else</span><span style="color: #000000"> {
</span><span style="color: #008000">//</span><span style="color: #008000">数据库已经存在</span>
<span style="color: #0000ff">echo</span> "Error creating database: " . <span style="color: #008080">mysqli_error</span>(<span style="color: #800080">$conn</span><span style="color: #000000">);
}
</span><span style="color: #008080">mysqli_close</span>(<span style="color: #800080">$conn</span><span style="color: #000000">);
</span>?>
连接成功后，创建简单的数据表
<span style="color: #008000">//</span><span style="color: #008000"> 使用 sql 创建数据表</span>
<span style="color: #800080">$sql</span> = "<span style="color: #000000">CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)</span>"<span style="color: #000000">;
</span><span style="color: #0000ff">if</span> (<span style="color: #800080">$conn</span>->query(<span style="color: #800080">$sql</span>) === <span style="color: #0000ff">TRUE</span><span style="color: #000000">) {
</span><span style="color: #0000ff">echo</span> "Table MyGuests created successfully"<span style="color: #000000">;
} </span><span style="color: #0000ff">else</span><span style="color: #000000"> {
</span><span style="color: #0000ff">echo</span> "创建数据表错误: " . <span style="color: #800080">$conn</span>-><span style="color: #000000">error;
}</span>
在连接数据库的时候，要保证数据库的服务器端口是打开的，不然无法连接到，书写代码之前，可以使用navicat对数据库进行测试连接
在学习的时候，打开数据库服务，可以通过wamp的集成环境来进行
声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。
上一条：网上图书商城9--支付模块
下一条：php面向对象之二-封装性
