Home >Backend Development >PHP Tutorial >Several common code examples for connecting to databases in PHP_PHP Tutorial
PHP connection database code for PHP connection MYSQL database
<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.htmlwww.bkjia.comtruehttp: //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...