php mysql_connect 与mysql_pconnect实现与详细说明
在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 "
";
}

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

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
Recommended: Win version, supports code prompts!

SublimeText3 Chinese version
Chinese version, very easy to use

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool