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