Home >Backend Development >PHP Tutorial >Several common code examples for connecting to databases in PHP_PHP Tutorial

Several common code examples for connecting to databases in PHP_PHP Tutorial

WBOY
WBOYOriginal
2016-07-15 13:32:27841browse

PHP connection database code for PHP connection MYSQL database

  1. < ?php
  2. $mysql_server_name='localhost';
  3. //Change to your own mysql database server
  4. $mysql_username='root' ;
  5. //Change to your own mysql database username
  6. $mysql_password='12345678';
  7. //Change to your own mysql Database password
  8. $mysql_database='mycounter' ;
  9. //Change to your own mysql database name
  10. $ conn=mysql_connect($mysql_server_name,
    $mysql_username,$mysql_password,
    $mysql_database);
  11. $sql='CREATE DATABASE mycounter
    DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
  12. ';
  13. mysql_query($sql); >sql
  14. ='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);
  15. //echo $sql; );
  16. echo "Hello! The database mycounter has been successfully created! "; ?> PHP connection to database PHP connection ACCESS database code method
  17. PHP connection database PHP connection MS SQL database code method
  18. 1. Install SQL server and add MSSQL extension for PHP
  19. 2. Use the following code to connect and test
  20. 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>
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>

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...

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