文档介绍:-1- 目录一、利用 PHP 访问 MySQL 数据库二、 PHP 学****指南三、综合实例-2- <!-- 连接数据库: ---------> <? $hostname= " localhost "; $database= “ spatial "; $username= “ root "; $password= “ abc123 "; $connection = mysql_pconnect ($hostname, $username, $password) or trigger_error(mysql_error(), E_USER_ERROR); echo $connection."<br>"; ?> 连接数据库-3- 关闭数据库链接<!-- 关闭数据库链接: ---------> <? //连接到数据库服务器 include (""); //关闭数据库连接$close = mysql_close ($connection); echo $close; ?>-4- <!-- 创建数据库: ---------> <?php // 连接到数据库服务器 include (""); if ($connection) { //建立数据库 Books $create_db= mysql_query ("Create Database Books",$connection); if (!$create_db) echo "create database failed!<br>"; else echo "create database essfully!<br>"; } ?>-5- 选择数据库<!-- 创建数据库: ---------> <?php //连接到数据库服务器 $connection = mysql_connect ("localhost", "root", “ abc123"); if($connection) { //选择数据库 $select_db= mysql_select_db ("Books", $connection); if (!$select_db) echo "select database failed!<br>"; else echo "select database essfully!<br>"; } ?>-6- 删除数据库<!-- 删除数据库: ---------> <?php //连接到数据库服务器 include (""); if($connection) { //删除数据库$drop_db= mysql_drop_db ("Books", $connection); if(!$drop_db) echo "drop database failed!<br>"; else echo "drop database essfully!<br>"; } ?>-7- 创建数据表<!-- 创建数据表: ---------> <? include (""); if ($connection) {// 选择数据库 Books mysql_select_db ("Books", $connection); // puters $query="CREATE puters ( "; $query.="id int(3) auto_increment not null primary key, "; $query.="name char(10) not null, "; $query.="price float default 0,"; $query.="publish_date date)"; echo $query."<br>"; $result=mysql_query($query); if (!$query) echo "create talbe failed!<br>"; else echo "create talbe essfully!<br>"; }-8- 在数据库中增加数据: <!-- 创建数据表 -------> <?php //连接到数据库服务器 include (""); if ($connection)