PHP访问MySql数据库介绍-php手册-PHP中文网

PHP访问MySql数据库介绍

php中文网

发布： 2016-06-06 19:36:04

原创

1902人浏览过

在网站后台，经常要与数据库打交道。本文介绍如何使用XAMPP来管理MySql 数据库及如何用PHP来访问 MySql 数据库。一．使用XAMPP来管理MySql 数据库首先使用XAMPP打开MySql的管理页面。步骤如下：启动XAMPP后点击Admin进入XAMPP for Windows的主页面

在网站后台，经常要与数据库打交道。本文介绍如何使用xampp来管理mysql数据库及如何用php来访问mysql数据库。

一．使用XAMPP来管理MySql数据库

首先使用XAMPP打开MySql的管理页面。步骤如下：启动XAMPP后点击Admin进入XAMPP for Windows的主页面，在主页面中点击phpMyAdmin。

PHP访问MySql数据库介绍

立即学习“PHP免费学习笔记（深入）”；

如意雅阁o2oMall集市

如意雅阁o2oMall集市基于PHP+Mysql开发的电脑访问、手机访问方式数据互融互通，后台涵盖了订单管理、会员管理、推广员、CRM客户管理、营销推广管理、财务管理、统计报表。全面适应020 o2o模式的商城集市整站程序。

查看详情

立即学习“PHP免费学习笔记（深入）”；

进入phpMyAdmin页面后，新建数据库test并在此数据库中建立t_student表，表共三个字段，编号id,姓名name,年龄age。

PHP访问MySql数据库介绍

然后就可以开始用PHP来访问MySql数据库了。由于PHP已经对访问MySql数据库作了良好的封装，因此用PHP访问MySql是一件非常容易的事情。

二．PHP访问MySql数据库

下面的PHP程序访问test数据库中t_student表，读取数据并以表格的形式输出数据。全部程序代码如下：

<span> 1</span> <span>//</span><span> by MoreWindows( http://blog.csdn.net/MoreWindows )
</span><span> 2</span> <span>//定义常量</span>
<span> 3</span> <span>define</span>(DB_HOST, 'localhost'<span>);
</span><span> 4</span> <span>define</span>(DB_USER, 'root'<span>);
</span><span> 5</span> <span>define</span>(DB_PASS, '111111'<span>);
</span><span> 6</span> <span>define</span>(DB_DATABASENAME, 'test'<span>);
</span><span> 7</span> <span>define</span>(DB_TABLENAME, 't_student'<span>);
</span><span> 8</span> <span>//</span><span><strong>数据库</strong>表的列名</span>
<span> 9</span> <span>$dbcolarray</span> = <span>array</span>('id', 'name', 'age'<span>);
</span><span>10</span> 
<span>11</span> <span>//</span><span>mysql_connect</span>
<span>12</span> <span>$conn</span> = <span>mysql_connect</span>(DB_HOST, DB_USER, DB_PASS) or <span>die</span>("connect failed" . <span>mysql_error</span><span>());
</span><span>13</span> <span>mysql_select_db</span>(DB_DATABASENAME, <span>$conn</span><span>);
</span><span>14</span> 
<span>15</span> <span>//</span><span>读取表中纪录条数</span>
<span>16</span> <span>$sql</span> = <span>sprintf</span>("select count(*) from %s",<span> DB_TABLENAME);
</span><span>17</span> <span>$result</span> = <span>mysql_query</span>(<span>$sql</span>, <span>$conn</span><span>);
</span><span>18</span> <span>if</span> (<span>$result</span><span>)
</span><span>19</span> <span>{
</span><span>20</span>     <span>$count</span> = <span>mysql_fetch_row</span>(<span>$result</span><span>);
</span><span>21</span> <span>}
</span><span>22</span> <span>else</span>
<span>23</span> <span>{
</span><span>24</span>     <span>die</span>("query failed"<span>);
</span><span>25</span> <span>}
</span><span>26</span> <span>echo</span> "表中有<span>$count</span>[0] 条记录<br />"<span>;
</span><span>27</span> 
<span>28</span> 
<span>29</span> <span>$sql</span> = <span>sprintf</span>("select %s from %s", <span>implode</span>(",",<span>$dbcolarray</span>),<span> DB_TABLENAME);
</span><span>30</span> <span>$result</span> = <span>mysql_query</span>(<span>$sql</span>, <span>$conn</span><span>);
</span><span>31</span> <span>//</span><span>表格</span>
<span>32</span> <span>echo</span> '<table id="Table" border=1 cellpadding=10 cellspacing=2 bordercolor=#ffaaoo>'<span>; 
</span><span>33</span> <span>//</span><span>表头 http://www.cnblogs.com/sosoft/</span>
<span>34</span> <span>$thstr</span> = "<th>" . <span>implode</span>("</th><th>", <span>$dbcolarray</span>) . "</th>"<span>;
</span><span>35</span> <span>echo</span> <span>$thstr</span><span>;
</span><span>36</span> <span>//</span><span>表中的内容</span>
<span>37</span> <span>while</span> (<span>$row</span>=<span>mysql_fetch_array</span>(<span>$result</span>, MYSQL_ASSOC))<span>//</span><span>与$row=mysql_fetch_assoc($result)等价</span>
<span>38</span> <span>{
</span><span>39</span>     <span>echo</span> "<tr>"<span>;
</span><span>40</span>     <span>$tdstr</span> = ""<span>;
</span><span>41</span>     <span>foreach</span> (<span>$dbcolarray</span> <span>as</span> <span>$td</span><span>)
</span><span>42</span>         <span>$tdstr</span> .= "<td><span>$row</span>[<span>$td</span>]</td>"<span>;
</span><span>43</span>     <span>echo</span> <span>$tdstr</span><span>;
</span><span>44</span>     <span>echo</span> "</tr>"<span>;
</span><span>45</span> <span>}
</span><span>46</span> <span>echo</span> "</table>"<span>;
</span><span>47</span> <span>mysql_free_result</span>(<span>$result</span><span>);
</span><span>48</span> <span>mysql_close</span>(<span>$conn</span>);

登录后复制

运行结果如下：

PHP访问MySql数据库介绍

这种HTML元素全由PHP输出的方式比较原始，可以进行优化。