Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pg_prepare('stm_name', 'SELECT ...');
- Warning: pg_prepare() [function.pg-prepare]: Query failed: ERROR: prepared statement "insert_av" already exists in xxx on line 221
- try{
- $qrParamExist = pg_query_params("SELECT name FROM pg_prepared_statements WHERE name = $1", array($prepared_statement_name));
- if($qrParamExist){
- if(pg_num_rows($qrParamExist) != 0){
- echo 'parametized statement already created';
- }else{
- echo 'parametized statement not present';
- }
- }else{
- throw new Exception('Unable to query the database.');
- }
- }catch(Exception $e){
- echo $e->getMessage();
- }
- try{
- $prepare = pg_prepare('my_stmt_name', "SELECT ...");
- if($prepare){
- $this->rayPrepared['my_stmt_name'] = true;
- }else{
- throw new Exception('Prepared statement failed.');
- }
- }catch(Exception $e){
- echo $e->getMessage();
- }
- <?
- $prepared_statement_name = 'activity1';
- $mydbname = '...';
- $conn = pg_connect("host=... port=... dbname=... user=... password=...");
- $result = pg_query_params($conn, 'SELECT name FROM pg_prepared_statements WHERE name = $1', array($prepared_statement_name));
- if (pg_num_rows($result) == 0) {
- $result = pg_prepare($conn, $prepared_statement_name, 'SELECT * FROM pg_stat_activity WHERE datname = $1');
- }
- $result = pg_execute($conn, $prepared_statement_name, array($mydbname));
- while($row = pg_fetch_row($result)) {
- var_dump($row);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement