php操作数据库

一：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);