blocks|key|3783336|text|请参阅mysql_connect的PHP文档。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3783337|<?php

$link+=+mysql_connect('localhost',+'mysql_user',+'mysql_password');

if+(!$link)+{
++++die('Could+not+connect:+'+.+mysql_error());
}

echo+'Connected+successfully';

mysql_close($link);|code-block|syntax|javascript|3783338|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/manual/en/function.mysql-connect.php^0|3|D|3|D|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Refer to the PHP documentation for <a href="http://www.php.net/manual/en/function.mysql-connect.php" rel="nofollow noreferrer"><code>mysql_connect</code></a>.

<pre><code>&lt;?php

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');

if (!$link) {
 die('Could not connect: ' . mysql_error());
}

echo 'Connected successfully';

mysql_close($link);
</code></pre>

blocks|key|1335856|text|这是它的最基本的部分：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1335857|$db1+=+mysql_connect(+...+);
mysql_select_db('existing_db',$db1);

$db2+=+mysql_connect(+...+);
mysql_select_db('not_existing_db',+$db2);

mysql_query(...+,+$db2);|code-block|syntax|javascript|1335858|更多信息：|1335859|1335860|http://php.net/manual/en/function.mysql-connect.php|unordered-list-item|offset|length|1335861|MySQL+PHP+Connect+Tutorial|1335862|1335863|entityMap|0|LINK|mutability|MUTABLE|url|1|http://www.tizag.com/mysqlTutorial/mysqlconnection.php^0|0|0|0|0|0|1F|0|0|0|Q|1|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|14|8|@]|9|@$M|15|N|16|1|17]]|A|$]]|$1|O|3|P|5|L|7|18|8|@]|9|@$M|19|N|1A|1|1B]]|A|$]]|$1|Q|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|K]]|Y|$5|U|V|W|A|$X|Z]]]]

Here is the bare bone of it:

<pre><code>$db1 = mysql_connect( ... );
mysql_select_db('existing_db',$db1);

$db2 = mysql_connect( ... );
mysql_select_db('not_existing_db', $db2);

mysql_query(... , $db2);
</code></pre>

More Info:

<ul>
<li><a href="http://php.net/manual/en/function.mysql-connect.php" rel="nofollow noreferrer">http://php.net/manual/en/function.mysql-connect.php</a></li>
<li><a href="http://www.tizag.com/mysqlTutorial/mysqlconnection.php" rel="nofollow noreferrer">MySQL PHP Connect Tutorial</a></li>
</ul>

blocks|key|3783366|text|详细教程：http://www.phpf1.com/tutorial/php-mysql-tutorial.html?page=1|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3783367|<?php

++mysql_connect("localhost",+"username",+"password")+or+die(mysql_error());
++echo+"Connection+to+the+server+was+successful! ";

++mysql_select_db("test")+or+die(mysql_error());
++echo+"Database+was+selected! ";

?>|code-block|syntax|javascript|3783368|entityMap|0|LINK|mutability|MUTABLE|url|http://www.phpf1.com/tutorial/php-mysql-tutorial.html?page=1^0|5|1O|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

A Detailed Tutorial:
<a href="http://www.phpf1.com/tutorial/php-mysql-tutorial.html?page=1" rel="nofollow noreferrer">http://www.phpf1.com/tutorial/php-mysql-tutorial.html?page=1</a>

<pre><code>&lt;?php

 mysql_connect("localhost", "username", "password") or die(mysql_error());
 echo "Connection to the server was successful!&lt;br/&gt;";

 mysql_select_db("test") or die(mysql_error());
 echo "Database was selected!&lt;br/&gt;";

?&gt;
</code></pre>

blocks|key|1468012|text|也请注意mysqli，它是连接mysql+http://php.net/manual/en/book.mysqli.php的“新方法”它有更多的功能，有传言说mysql将在php6中被弃用。您可以将其用作对象(但如果您也是OO新手，则可能更难理解)，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1468013|//--connection+to+the+database--
$db=mysqli_connect('sql.mysqlhost.com','database_username','password','database_name');//you+can+also+use+$db=new+mysqli(....)+but+mysql_connect+does+the+same+thing+and+it's+more+cler+on+what+it's+doing
//--a+simple+query--
if($result=$db::query('SELECT+name,value+FROM+mytable')){//query+ok
++++echo+'Select+returned+',$result->num_rows,'rows ';
++++while($row=$result->fetch_assoc()){//get+one+row+in+an+assoc.array
++++++++++++echo+'Name:',$row['name'],'+Value:',$row['value'],' ';//print+each+row
++++}
++++$result->close();
}
else//query+error
+die('MYSQL+ERROR:'.$db->error);|code-block|syntax|javascript|1468014|或者使用mysql中的函数|1468015|//--connection+to+the+database--
$db=mysqli_connect('sql.mysqlhost.com','database_username','password','database_name');
//--a+simple+query--
if($result=mysql_query($db,'SELECT+name,value+FROM+mytable')){//query+ok
++++echo+'Select+returned+',mysql_num_rows($result),'rows ';
++++while($row=mysqli_fetch_assoc($result)){//get+one+row+in+an+assoc.array
++++++++++++echo+'Name:',$row['name'],'+Value:',$row['value'],' ';//print+each+row
++++}
++++mysql_free_result($result);
}
else//query+error
+die('MYSQL+ERROR:'.mysqli_connect_error());|1468016|您还可以使用在主机前加上'p:‘的sql持久连接，例如，如果您的主机是sql.myhost.com：|style|BOLD|1468017|$db=mysqli_connect('p:sql.mysqlhost.com','database_username','password','database_name');|1468018|使用持久连接应该会给带来巨大的性能提升，和mysqli应该比普通的mysql扩展更好地处理持久连接。|1468019|记住要清理查询的输入以避免SQL注入，您可以这样做：|1468020|$result=mysql_query($db,"SELECT+name,value+FROM+mytable+where+name='".mysqli_real_escape_string($input_name)."'");|1468021|或者使用准备好的语句，这有点复杂，只有在多次重复相同的命令，只更改输入数据的情况下才更好。|1468022|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/book.mysqli.php^0|L|14|0|0|0|0|0|7|H|0|0|A|A|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@$A|19|B|1A|1|1B]]|C|$]]|$1|D|3|E|5|F|7|1C|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|1D|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|1E|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|1F|8|@$A|1G|B|1H|O|P]]|9|@]|C|$]]|$1|Q|3|R|5|F|7|1I|8|@]|9|@]|C|$G|H]]|$1|S|3|T|5|6|7|1J|8|@$A|1K|B|1L|O|P]]|9|@]|C|$]]|$1|U|3|V|5|6|7|1M|8|@]|9|@]|C|$]]|$1|W|3|X|5|F|7|1N|8|@]|9|@]|C|$G|H]]|$1|Y|3|Z|5|6|7|1O|8|@]|9|@]|C|$]]|$1|10|3|-4|5|6|7|1P|8|@]|9|@]|C|$]]]|11|$12|$5|13|14|15|C|$16|17]]]]

Watch also mysqli,it's the "new way" of connecting to mysql
 <a href="http://php.net/manual/en/book.mysqli.php" rel="nofollow noreferrer">http://php.net/manual/en/book.mysqli.php</a>
it has more functions and there are rumors that in php6 mysql will be deprecated for the mysqli implementation.
you can use it as an object(but if you're new also to OO it may be a little more difficult to understand)like this:

<pre><code>//--connection to the database--
$db=mysqli_connect('sql.mysqlhost.com','database_username','password','database_name');//you can also use $db=new mysqli(....) but mysql_connect does the same thing and it's more cler on what it's doing
//--a simple query--
if($result=$db::query('SELECT name,value FROM mytable')){//query ok
 echo 'Select returned ',$result-&gt;num_rows,'rows&lt;br/&gt;';
 while($row=$result-&gt;fetch_assoc()){//get one row in an assoc.array
 echo 'Name:',$row['name'],' Value:',$row['value'],'&lt;br/&gt;';//print each row
 }
 $result-&gt;close();
}
else//query error
 die('MYSQL ERROR:'.$db-&gt;error);
</code></pre>

or with functions like in mysql

<pre><code>//--connection to the database--
$db=mysqli_connect('sql.mysqlhost.com','database_username','password','database_name');
//--a simple query--
if($result=mysql_query($db,'SELECT name,value FROM mytable')){//query ok
 echo 'Select returned ',mysql_num_rows($result),'rows&lt;br/&gt;';
 while($row=mysqli_fetch_assoc($result)){//get one row in an assoc.array
 echo 'Name:',$row['name'],' Value:',$row['value'],'&lt;br/&gt;';//print each row
 }
 mysql_free_result($result);
}
else//query error
 die('MYSQL ERROR:'.mysqli_connect_error());
</code></pre>

You can also use a persistent mysql connection prepending 'p:' to the sql host,for example if your host is sql.myhost.com:

<pre><code>$db=mysqli_connect('p:sql.mysqlhost.com','database_username','password','database_name');
</code></pre>

Using a persistent connection should give you a great performance boost and mysqli should handle the persistent connection a lot better than the normal mysql extension.

Remember to sanitize the input of your query to avoid SQL INJECTION,you can do like this:

<pre><code>$result=mysql_query($db,"SELECT name,value FROM mytable where name='".mysqli_real_escape_string($input_name)."'");
</code></pre>

or using a prepared statement that's a little more complicated and it's better only if you repeat the same command multiple times only changing the input data.

i am new in php and want to know the code for php mysql database connection code

PHP Data Base Connection help with mysql

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我是php新手，想知道php mysql数据库连接代码的代码

问mysql的PHP数据库连接帮助
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql的PHP数据库连接帮助EN