Home  >  Article  >  Backend Development  >  Learning PHP--two ways to connect to MySQL, two ways of mysql_PHP tutorial

Learning PHP--two ways to connect to MySQL, two ways of mysql_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 09:58:39876browse

Learning of PHP - two ways to connect to MySQL, two ways of mysql

Record the two ways of connecting to MySQL in PHP.

Mock the data first and then execute sql.

<span>/*</span><span>创建数据库</span><span>*/</span>
<span>CREATE</span> <span>DATABASE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `test`;

</span><span>/*</span><span>选择数据库</span><span>*/</span>
<span>USE</span><span> `test`;

</span><span>/*</span><span>创建表</span><span>*/</span>
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span> `<span>user</span><span>` (
    name </span><span>varchar</span>(<span>50</span><span>),
    age </span><span>int</span><span>
);

</span><span>/*</span><span>插入测试数据</span><span>*/</span>
<span>INSERT</span> <span>INTO</span> `<span>user</span>` (name, age) <span>VALUES</span>(<span>'</span><span>harry</span><span>'</span>, <span>20</span>), (<span>'</span><span>tony</span><span>'</span>, <span>23</span>), (<span>'</span><span>harry</span><span>'</span>, <span>24</span>);

The first is to use PHP’s native method to connect to the database. The code is as follows:

<?<span>php
</span><span>$host</span> = 'localhost'<span>;
</span><span>$database</span> = 'test'<span>;
</span><span>$username</span> = 'root'<span>;
</span><span>$password</span> = 'root'<span>;
</span><span>$selectName</span> = 'harry';<span>//</span><span>要查找的用户名,一般是用户输入的信息</span>

<span>$connection</span> = <span>mysql_connect</span>(<span>$host</span>, <span>$username</span>, <span>$password</span>);<span>//</span><span>连接到数据库</span>
<span>mysql_query</span>("set names 'utf8'");<span>//</span><span>编码转化</span>
<span>if</span> (!<span>$connection</span><span>) {
    </span><span>die</span>("could not connect to the database.\n" . <span>mysql_error</span>());<span>//</span><span>诊断连接错误</span>
<span>}
</span><span>$selectedDb</span> = <span>mysql_select_db</span>(<span>$database</span>);<span>//</span><span>选择数据库</span>
<span>if</span> (!<span>$selectedDb</span><span>) {
    </span><span>die</span>("could not to the database\n" . <span>mysql_error</span><span>());
}
</span><span>$selectName</span> = <span>mysql_real_escape_string</span>(<span>$selectName</span>);<span>//</span><span>防止SQL注入</span>
<span>$query</span> = "select * from user where name = '<span>$selectName</span>'";<span>//</span><span>构建查询语句</span>
<span>$result</span> = <span>mysql_query</span>(<span>$query</span>);<span>//</span><span>执行查询</span>
<span>if</span> (!<span>$result</span><span>) {
    </span><span>die</span>("could not to the database\n" . <span>mysql_error</span><span>());
}
</span><span>while</span> (<span>$row</span> = <span>mysql_fetch_row</span>(<span>$result</span><span>)) {
    </span><span>//</span><span>取出结果并显示</span>
    <span>$name</span> = <span>$row</span>[0<span>];
    </span><span>$age</span> = <span>$row</span>[1<span>];
    </span><span>echo</span> "Name: <span>$name</span> "<span>;
    </span><span>echo</span> "Age: <span>$age</span> "<span>;
    </span><span>echo</span> "\n"<span>;
}</span>

Its operating structure is as follows:

Name: harry Age: 20<span> 
Name</span>: tony Age: 23 

The second method is to use PDO to connect to the database. The code is as follows:

<?<span>php
</span><span>$host</span> = 'localhost'<span>;
</span><span>$database</span> = 'test'<span>;
</span><span>$username</span> = 'root'<span>;
</span><span>$password</span> = 'root'<span>;
</span><span>$selectName</span> = 'harry';<span>//</span><span>要查找的用户名,一般是用户输入的信息</span>

<span>$pdo</span> = <span>new</span> PDO("mysql:host=<span>$host</span>;dbname=<span>$database</span>", <span>$username</span>, <span>$password</span>);<span>//</span><span>创建一个pdo对象</span>
<span>$pdo</span>-><span>exec</span>("set names 'utf8'"<span>);
</span><span>$sql</span> = "select * from user where name = ?"<span>;
</span><span>$stmt</span> = <span>$pdo</span>->prepare(<span>$sql</span><span>);
</span><span>$rs</span> = <span>$stmt</span>->execute(<span>array</span>(<span>$selectName</span><span>));

</span><span>if</span> (<span>$rs</span><span>) {
    </span><span>//</span><span> PDO::FETCH_ASSOC 关联数组形式
    // PDO::FETCH_NUM 数字索引数组形式</span>
    <span>while</span> (<span>$row</span> = <span>$stmt</span>->fetch(PDO::<span>FETCH_ASSOC)) {
        </span><span>$name</span> = <span>$row</span>['name'<span>];
        </span><span>$age</span> = <span>$row</span>['age'<span>];
        </span><span>echo</span> "Name: <span>$name</span> "<span>;
        </span><span>echo</span> "Age: <span>$age</span> "<span>;
        </span><span>echo</span> "\n"<span>;
    }
}

</span><span>$pdo</span> = <span>null</span>;<span>//</span><span>关闭连接</span>

The result is the same as the first one.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/977524.htmlTechArticlePHP learning--two ways to connect to MySQL, two ways of mysql. Record the two ways of connecting PHP to MySQL. Way. First mock the data and execute sql. /* Create database */ CREAT...
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