Several common code examples for connecting to databases in PHP

Several common code examples for connecting to databases in PHP_PHP Tutorial

WBOY

Release： 2016-07-15 13:32:27

Original

841 people have browsed it

PHP connection database code for PHP connection MYSQL database

< ?php
$mysql_server_name='localhost';
//Change to your own mysql database server
$mysql_username='root' ;
//Change to your own mysql database username
$mysql_password='12345678';
//Change to your own mysql Database password
$mysql_database='mycounter' ;
//Change to your own mysql database name
$ conn=mysql_connect($mysql_server_name,
$mysql_username,$mysql_password,
$mysql_database);
$sql='CREATE DATABASE mycounter
DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
';
mysql_query($sql); >sql
='CREATE TABLE `counter` (`id` INT(255) UNSIGNED NOT NULL AUTO_INCREMENT ,`count` INT (255) UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY ( `id` ) ) TYPE = innodb;';

mysql_select_db($mysql_database,$conn); >mysql_query($sql);
//echo $sql; );
echo "Hello! The database mycounter has been successfully created! "; ?> PHP connection to database PHP connection ACCESS database code method
PHP connection database PHP connection MS SQL database code method
1. Install SQL server and add MSSQL extension for PHP
PHP connects to the database PHP connects to the Oracle database

PHP provides two sets of functions to connect to Oracle, namely ORA_ and OCI function. The ORA_ function is slightly older, and the usage syntax of the two is almost the same.

<ol class="dp-xml">
<li class="alt"><span><span class="tag"><</span><span> ?  </span></span></li><li><span>$</span><span class="attribute">conn</span><span> = </span><span class="attribute-value">new</span><span> com("ADODB.Connection");   </span></li><li class="alt"><span>$</span><span class="attribute">connstr</span><span> = </span><span class="attribute-value">"DRIVER={Microsoft<br /> Access Driver (*.mdb)}; <br />DBQ="</span><span>. realpath("data/db.mdb");   </span></li><li><span>$conn-</span><span class="tag">></span><span>Open($connstr);   </span></span></li>
<li class="alt">
<span>$</span><span class="attribute">rs</span><span> = </span><span class="attribute-value">new</span><span> com("ADODB.RecordSet");   </span>
</li>
<li>
<span>$rs-</span><span class="tag">></span><span>Open("select *<br> from szd_t",$conn,1,1);   </span>
</li>
<li class="alt">
<span>while(! $rs-</span><span class="tag">></span><span>eof) {   </span>
</li>
<li>
<span>$</span><span class="attribute">f</span><span> = $rs-</span><span class="tag">></span><span>Fields(1);   </span>
</li>
<li class="alt">
<span>echo $f-</span><span class="tag">></span><span>value;   </span>
</li>
<li>
<span>$rs-</span><span class="tag">></span><span>MoveNext();   </span>
</li>
<li class="alt"><span>}   </span></li>
<li>
<span class="tag">?></span><span> </span>
</li>
</ol>

Copy after login

The above PHP code to connect to the database uses the Oracle database name, user name and password defined by TNSNAME (specified in your tnsnames.ora file) to connect to the database based on a successful connection. , the ora_logon function returns a non-zero connection ID and stores it in the variable $conn

http://www.bkjia.com/PHPjc/446144.html

www.bkjia.com

true

http: //www.bkjia.com/PHPjc/446144.html

<ol class="dp-xml">
<li class="alt"><span><span class="tag"><</span><span> ?php   </span></span></li><li><span>$</span><span class="attribute">myServer</span><span> = </span><span class="attribute-value">localhost</span><span>; //主机  </span></li><li class="alt"><span>$</span><span class="attribute">myUser</span><span> = </span><span class="attribute-value">sa</span><span>; //用户名  </span></li><li><span>$</span><span class="attribute">myPass</span><span> = </span><span class="attribute-value">password</span><span>; //密码  </span></li><li class="alt"><span>$</span><span class="attribute">myDB</span><span> = </span><span class="attribute-value">Northwind</span><span>; //MSSQL库名  </span></li><li><span>$</span><span class="attribute">s</span><span> = @mssql_connect($myServer,<br /> $myUser, $myPass)   </span></li><li class="alt"><span>or die(Couldnt connect to <br />SQL Server on $myServer);   </span></li><li><span>$</span><span class="attribute">d</span><span> = @mssql_select_db($myDB, $s)   </span></li><li class="alt"><span>or die(Couldnt open database $myDB);   </span></li><li><span>$</span><span class="attribute">query</span><span> = </span><span class="attribute-value">SELECT</span><span> TitleOfCourtesy<br />+ +FirstName+ +LastName AS Employee ;   </span></li><li class="alt"><span>$query </span><span class="attribute">.</span><span>= </span><span class="attribute-value">FROM</span><span> Employees ;   </span></li><li><span>$query </span><span class="attribute">.</span><span>= </span><span class="attribute-value">WHERE</span><span> </span><span class="attribute">Country</span><span>=</span><span class="attribute-value">USA</span><span> <br />AND Left(HomePhone, 5) = (206);   </span></li><li class="alt"><span>$</span><span class="attribute">result</span><span> = </span><span class="attribute-value">mssql_query</span><span>($query);   </span></li><li><span>$</span><span class="attribute">numRows</span><span> = </span><span class="attribute-value">mssql_num_rows</span><span>($result);   </span></li><li class="alt"><span>echo </span><span class="tag">< </span><span class="tag-name">h1</span><span class="tag">></span><span> . $numRows . Row .<br> ($</span><span class="attribute">numRows</span><span> == 1 ? : s) . Returned </span><span class="tag"></ </span><span class="tag-name">h1</span><span class="tag">></span><span>;   </span></span></li>
<li>
<span>while($</span><span class="attribute">row</span><span> = </span><span class="attribute-value">mssql_fetch_array</span><span>($result))   </span>
</li>
<li class="alt"><span>{   </span></li>
<li>
<span>echo </span><span class="tag">< </span><span class="tag-name">li</span><span class="tag">></span><span> . $row[Employee] . </span><span class="tag">< /</span><span class="tag-name">li</span><span class="tag">></span><span>;   </span>
</li>
<li class="alt"><span>}   </span></li>
<li>
<span class="tag">?></span><span>  </span>
</li>
</ol>

Copy after login

TechArticle

PHP connection database code for PHP connection MYSQL database?php $ mysql_server_name = 'localhost'; //Change to your own mysql database server$ mysql_username = 'root'; //Change to your own my...