PHP: PDO: Error Array ( [0] => 00000 [1] => [2] => )

Trabla: successfull execution of sql using PDO object returns error:
Array ( [0] => 00000 [1] => [2] => )


//--------------------------------------------------------------------
//-- TRABLA CODE -----
//Postgresql CREATE TABLE sql

$sql = 'CREATE TABLE my_table( 
id bigserial NOT NULL PRIMARY KEY,
name character varying(255)
);';

$db->exec( $sql ) or die(print_r($db->errorInfo(), true));
//--------------------------------------------------------------------



Solving:  
PDO execute returns 0!!! if no record updated - to fix use check  ===  false

//--------------------------------------------------------------------
//-- Fixed CODE -----
//Postgresql CREATE TABLE sql

$sql = 'CREATE TABLE my_table( 
id bigserial NOT NULL PRIMARY KEY,
name character varying(255)
);';


if ( $db->exec( $sql ) === false ){

   die(print_r($db->errorInfo(), true));

}

//--------------------------------------------------------------------

No comments:

Post a Comment