search
Homephp教程php手册php mysql_connect 与mysql_pconnect实现与详细说明

php mysql_connect 与mysql_pconnect实现与详细说明

Jun 13, 2016 am 10:08 AM
connectmysqlphpandexistaccomplishdatabasehavedetailedillustrateconnect

在php中连接mysql数据库有二种如有mysql_connect 与mysql_pconnect,一个是软连接,一个是持续连接,两者区别在于一个当页面浏览完自动关闭已经打开的MySQL连接页mysql_pconnect如果不关闭就一直连接。

在php教程中连接mysql教程数据库教程有二种如有mysql_connect 与mysql_pconnect,一个是软连接,一个是持续连接,两者区别在于一个当页面浏览完自动关闭已经打开的mysql连接页mysql_pconnect如果不关闭就一直连接。
*/

$hostname="localhost";        //定义连接到的mysql服务器名
$username="root";         //定义用于连接的用户名
$password="";          //定义用于连接的密码
$link=mysql_connect($hostname,$username,$password);  //连接到本地mysql服务器
if($link)           //如果成功连接
{
  echo "成功连接";         //输出内容
}
else            //如果连接失败
{
  echo "连接失败";         //输出内容
}
//mysql_close($link) //关闭已经打开的mysql连接

//mysql_pconnect连接mysql数据库

$link=mysql_pconnect($hostname,$username,$password);  //打开持续性连接
if(!$link)            //如果不能连接
{
  die('不能连接'.mysql_error());        //输出信息
  exit();            //结束所有php操作
}
echo '持续连接成功';

/*
下面看软连接查询数据库内容

*/

$link=mysql_connect($hostname,$username,$password)or die("could not connect:".mysql_error());
//转换编码以支持中文
mysql_query('set   names   gb2312;');
//选择操作库test
mysql_select_db("test")or die("could not select database:".mysql_error());
//执行sql查询,从表中选择名字
$query="select name from friends";
$result=mysql_query($query)or die("query failed:".mysql_error());
//匹配结果集到行循环输出内容
for($i=mysql_num_rows($result)-1;$i>=0;$i--)
{
//移动内部结果的指针,如果没有结果则输内容
  if(!mysql_data_seek($result,$i))
  {
    echo "cannot seek to row $i:".mysql_error()."n";
    continue;
  }
//从查询结果取得一行作为对象
  if(!($row=mysql_fetch_object($result)))
  continue;
//输出结果内容
  echo "$row->name
n";
}
//释放结果集
mysql_free_result($result);

/*
其它操作

$escaped_item=mysql_escape_string($str);    //将字符串转义
printf("escaped string:%sn",$escaped_item);    //输出转义后的结果

$mydb=mysql_list_dbs($link);      //列出数据库
while($result=mysql_fetch_object($mydb))   //通过循环遍历结果集并赋值给对象
{
  echo $result->database."n";      //输出对象内容
  echo "
";
}

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
Will R.E.P.O. Have Crossplay?
1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool