Ok I'm a newbie to using Oracle9i w/ PHP, been a MySQL guy... What is the
proper sql statement to use insert tables, etc. as below.? I don't know much
about how OciParse works. I can connect successfuly, just my sql syntax is
pretty bad.
$conn = OCILogon($usern ame,$passwd,$db );
if ($conn) {
$sql = "
CREATE TABLE inventory
(
"item_id" numeric PRIMARY KEY auto_increment, ;
"transaction_id " numeric NULL,
"vendor_id" numeric NULL,
"user_id" numeric NULL,
"item_barco de" varchar(16) NULL,
"item_descripti on" BLOB NULL,
"item_purchase_ price" varchar(16) NULL,
"item_purchase_ date" date NULL,
"item_offer_pri ce" varchar(16) NULL,
"item_offer_dat e" date NULL,
"item_sold_pric e" varchar(16) NULL,
"item_sold_date " date NULL,
"item_locat ion" varchar(16) NULL,
"item_quant ity" varchar(16) NULL,
"item_shipping_ weight" varchar(16) NULL,
"item_statu s" varchar(16) NULL,
);
CREATE TABLE coin_singles
(
"item_id" numeric PRIMARY KEY,
"coin_grade_ser vices" varchar(32) NULL,
"coin_grade " varchar(32) NULL,
"coin_mint_date " varchar(16) NULL,
"coin_type1 " varchar(32) NULL,
"coin_type2 " varchar(32) NULL,
"coin_censu s" varchar(255) NULL,
"coin_issue_dat es" varchar(16) NULL,
"coin_title " varchar(255) NULL,
"coin_descripti on" BLOB NULL,
"coin_condition 1" varchar(32) NULL,
"coin_condition 2" varchar(32) NULL,
"coin_condition 3" varchar(32) NULL,
"coin_photo 1" varchar(32) NULL,
"coin_photo 2" varchar(32) NULL,
"coin_photo 3" varchar(32) NULL,
);
"
echo "<br>";
echo $conn;
echo "<br>";
echo $sql;
echo "<br>";
// parse SQL statement
$sql_statement = OCIParse($conn, $sql)
or die("Couldn't parse statement.");
echo $sql_statement;
// execute SQL query
OCIExecute($sql _statement)
or die("Couldn't execute statement.");
} else {
echo ("Connection failed!");
}
OCILogoff($conn );
?>