aci_new_connect¶

aci_new_connect — 建定一个到数据库服务器的新连接

说明¶

aci_new_connect(
        string $username,
        string $password,
        string $db = ?,
        string $charset = ?,
        int $session_mode = ?
): resource

aci_new_connect() 创建一个到服务器的新连接并登录。

范例¶

示例 #1 aci_new_connect() 例子

<?php
echo "<html><pre>";
$db = "";

$c1 = aci_connect('sysdba', 'szoscar55', 'localhost:2003/OSRDB');
$c2 = aci_new_connect("scott", "tiger", $db);

function create_table($conn)
{
  $stmt = aci_parse($conn, "create table scott.hallo (test
varchar2(64))");
  aci_execute($stmt);
  echo $conn . " created table\n\n";
}

function drop_table($conn)
{
  $stmt = aci_parse($conn, "drop table scott.hallo");
  aci_execute($stmt);
  echo $conn . " dropped table\n\n";
}

function insert_data($conn)
{
  $stmt = aci_parse($conn, "insert into scott.hallo
                        values('$conn' || ' ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'))");
  aci_execute($stmt, aci_DEFAULT);
  echo $conn . " inserted hallo\n\n";
}

function delete_data($conn)
{
  $stmt = aci_parse($conn, "delete from scott.hallo");
  aci_execute($stmt, aci_DEFAULT);
  echo $conn . " deleted hallo\n\n";
}

function commit($conn)
{
  aci_commit($conn);
  echo $conn . " committed\n\n";
}

function rollback($conn)
{
  aci_rollback($conn);
  echo $conn . " rollback\n\n";
}

function select_data($conn)
{
  $stmt = aci_parse($conn, "select * from scott.hallo");
  aci_execute($stmt, aci_DEFAULT);
  echo $conn . "----selecting\n\n";
  while (aci_fetch($stmt)) {
        echo $conn . " <" . aci_result($stmt, "TEST") . ">\n\n";
  }
  echo $conn . "----done\n\n";
}

create_table($c1);
insert_data($c1);

select_data($c1);
select_data($c2);

rollback($c1);

select_data($c1);
select_data($c2);

insert_data($c2);
commit($c2);

select_data($c1);

delete_data($c1);
select_data($c1);
select_data($c2);
commit($c1);

select_data($c1);
select_data($c2);

drop_table($c1);
echo "</pre></html>";
?>

aci_new_connect() 在出错时返回 false。

注意:
在 PHP 5.0.0 之前的版本必须使用 acinlogon() 替代本函数。该函数名仍然可用，
为向下兼容作为 aci_new_connect() 的别名。不过其已被废弃，不推荐使用。

参数¶

用户名.

用户密码.

包含要连接的数据库实例。

使用客户端库来确定字符集。字符集不需要与数据库的字符集相匹配。如果不匹配，数据库会尽可能地将数据从数据库字符集进行转换。因为依赖于字符集，可能不能给出可用的结果。转换也增加一些时间开销。

传递此参数可减少连接时间。

session_mode

此参数收受下列值：aci_DEFAULT。

返回值¶

错误时返回连接标识符或false。

下面演示如何分离连接。

示例 #2 aci_new_connect() example

<?php
echo "<html><pre>";
$db = "";

$c1 = aci_connect("scott", "tiger", $db);
$c2 = aci_new_connect("scott", "tiger", $db);

function create_table($conn)
{
  $stmt = aci_parse($conn, "create table scott.hallo (test
varchar2(64))");
  aci_execute($stmt);
  echo $conn . " created table\n\n";
}

function drop_table($conn)
{
  $stmt = aci_parse($conn, "drop table scott.hallo");
  aci_execute($stmt);
  echo $conn . " dropped table\n\n";
}

function insert_data($conn)
{
  $stmt = aci_parse($conn, "insert into scott.hallo
                        values('$conn' || ' ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'))");
  aci_execute($stmt, aci_DEFAULT);
  echo $conn . " inserted hallo\n\n";
}

function delete_data($conn)
{
  $stmt = aci_parse($conn, "delete from scott.hallo");
  aci_execute($stmt, aci_DEFAULT);
  echo $conn . " deleted hallo\n\n";
}

function commit($conn)
{
  aci_commit($conn);
  echo $conn . " committed\n\n";
}

function rollback($conn)
{
  aci_rollback($conn);
  echo $conn . " rollback\n\n";
}

function select_data($conn)
{
  $stmt = aci_parse($conn, "select * from scott.hallo");
  aci_execute($stmt, aci_DEFAULT);
  echo $conn . "----selecting\n\n";
  while (aci_fetch($stmt)) {
        echo $conn . " <" . aci_result($stmt, "TEST") . ">\n\n";
  }
  echo $conn . "----done\n\n";
}

create_table($c1);
insert_data($c1);

select_data($c1);
select_data($c2);

rollback($c1);

select_data($c1);
select_data($c2);

insert_data($c2);
commit($c2);

select_data($c1);

delete_data($c1);
select_data($c1);
select_data($c2);
commit($c1);

select_data($c1);
select_data($c2);

drop_table($c1);
echo "</pre></html>";
?>

注释¶

注意: 在5.0.0之前的PHP版本中，必须改用acinlogon（）。

参见¶

aci_connect() - 建立一个到数据库服务器的连接