php操作数据库

zeromax

　　一：mysql
　　1：查询（其它操作只是sql不同）

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM Persons");
while($row = mysql_fetch_array($result))
{
echo $row['FirstName'] . " " . $row['LastName'];
echo "<br />";
}
mysql_close($con);
?>
　　二：oracle
　　须要打开php.in

在php.ini里的：
....
extension=php_mysqli.dll
;extension=php_oci8.dll
....

把 extension=php_oci8.dll 前面的分号去掉；
　　可用<?php phpinfo();?> 查看
　　1)得到连接

function oracle_link_dongguan($user_dongguan,$passwd_dongguan,$passport_dongguan){
$oracle_link_dongguan = oci_connect($user_dongguan, $passwd_dongguan, $passport_dongguan,'zhs16gbk');
if (!$oracle_link_dongguan) { $e = oci_error(); echo htmlentities($e['message']); exit; }
return $oracle_link_dongguan;
}
$passport_dongguan ="(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = )
)
)";

$linki = oracle_link_dongguan("username","password",$passport_dongguan);
　　2）：编译执行

$result_pu = oci_parse($linki,"select USER_ID from PUB_USER where lower(USER_NAME)='$user_name'");
oci_execute($result_pu);
$record_arr = array();
while($row_pu=oci_fetch_array($result_pu)){ $record_arr[] = $row_pu; }
　　3）：释放资源关闭链接

oci_free_statement($result_bd);
oci_close($linki_dongguan);