pg_send_query

(PHP 4 >= 4.2.0, PHP 5, PHP 7)

pg_send_query 锟斤拷锟斤拷锟届步锟斤拷询

说锟斤拷

pg_send_query ( resource $connection , string $query ) : bool
pg_send_query ( string $query ) : bool

pg_send_query() 锟斤拷 connection 锟斤拷锟接凤拷锟斤拷锟届步锟斤拷询锟斤拷锟斤拷 pg_query() 锟斤拷同锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 PostgreSQL 锟斤拷锟酵讹拷锟斤拷锟窖拷锟斤拷锟� pg_get_result() 锟斤拷锟轿得碉拷锟斤拷锟斤拷锟斤拷锟街达拷胁锟窖憋拷疟锟斤拷锟街达拷胁锟斤拷岜伙拷锟斤拷锟斤拷锟斤拷锟� pg_connection_busy() 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷欠锟轿︼拷锟斤拷锟斤拷锟窖拷锟斤拷锟街达拷锟斤拷校锟斤拷锟斤拷锟斤拷锟� pg_cancel_query() 锟斤拷锟叫匡拷锟斤拷取锟斤拷锟斤拷询锟斤拷

锟斤拷锟斤拷锟矫伙拷锟斤拷锟斤拷一锟轿凤拷锟酵讹拷锟斤拷锟窖拷锟斤拷锟斤拷没锟斤拷锟斤拷锟酵拷锟斤拷锟矫︼拷锟斤拷锟斤拷臃锟斤拷投锟斤拷锟斤拷询锟斤拷锟斤拷锟斤拷锟斤拷锟矫︼拷锟斤拷锟斤拷臃锟斤拷锟斤拷瞬锟窖拷锟斤拷锟斤拷却锟斤拷锟揭伙拷锟斤拷锟窖拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷薪锟斤拷锟斤拷

Example #1 锟届步锟斤拷询

<?php
    $dbconn 
pg_connect("dbname=publisher") or die("Could not connect");
    if (!
pg_connection_busy($dbconn)) {
        
pg_send_query($dbconn,"select * from authors; select count(*) from authors;");
    }
    
$res1 pg_get_result($dbconn);
    echo 
"First call to pg_get_result(): $res1\n";
    
$rows1 pg_num_rows($res1);
    echo 
"$res1 has $rows1 records\n\n";
    
$res2 pg_get_result($dbconn);
    echo 
"second call to pg_get_result(): $res2\n";
    
$rows2 pg_num_rows($res2);
    echo 
"$res2 has $rows2 records\n";
?>

锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷拢锟�

first call to pg_get_result(): Resource id #3
Resource id #3 has 3 records

second call to pg_get_result(): Resource id #4
Resource id #4 has 1 records

锟轿硷拷 pg_query()锟斤拷pg_cancel_query()锟斤拷pg_get_result() 锟斤拷 pg_connection_busy()锟斤拷