Several common code examples for connecting to databases in PHP_PHP Tutorial

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
18. PHP connection database PHP connection MS SQL database code method
19. 1. Install SQL server and add MSSQL extension for PHP
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>
</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> ?php   </span></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 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 class="tag-name">li</span><span class="tag">></span><span> . $row[Employee] . </span><span class="tag"><span class="tag-name">li</span><span class="tag">></span><span>;   </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...