PHP / Oracle SQL语句,OciParse [英] PHP/Oracle SQL statements, OciParse
问题描述
好吧我是使用Oracle9i w / PHP的新手,是一个MySQL家伙...使用插入表等的
正确的sql语句是什么?关于OciParse如何工作,我不太了解
。我可以成功连接,只是我的sql语法是
非常糟糕。
$ conn = OCILogon($ username,$ passwd,$ db);
if($ conn){
$ sql ="
CREATE TABLE库
(
" item_id"数字PRIMARY KEY auto_increment,;
" transaction_id"数字NULL,
" vendor_id"数字NULL ,
" user_id"数字NULL,
" item_barcode" varchar(16)NULL,
" item_description" BLOB NULL,
" item_purchase_price" varchar(16)NULL,
" item_purchase_date" date NULL,
" item_offer_price" varchar(16)NULL,
" item_offer_date" date NULL,
" item_sold_price" varchar(16)NULL,
" item_sold_date" date NULL,
" item_location" varchar(16)NULL,
" item_quantity" varchar(16)NULL,
" item_shipping_weight" varchar(16)NULL,
" item_status" varchar(16)NULL,
);
CREATE TABLE coin_singles
(
" item_id" numeric PRIMARY KEY,
" coin_grade_services" 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_census" varchar(255)NULL,
" coin_issue_dates" varchar(16)NULL,
" coin_title" varchar(255)NULL,
" coin_description" BLOB NULL,
" coin_condition1" varchar(32)NULL,
" coin_condition2" varchar(32)NULL ,
" coin_condition3" varchar(32)NULL,
" coin_photo1" varchar(32)NULL,
" coin_photo2" varchar (32)NULL,
" coin_photo3" varchar(32)NULL,
);
&
echo"< br>" ;;
echo $ conn;
echo"< br> ;" ;;
echo $ sql;
echo"< br>" ;;
//解析SQL声明
$ sql_statement = OCIParse($ conn,$ sql)
或死(无法解析语句。);
echo $ sql_statement;
//执行SQL查询
OCIExecute($ sql_statement)
或死(无法执行语句。);
}否则{
echo(&Connection)失败!);
}
OCILogoff($ conn);
? >
conn = OCILogon(
username,
passwd中
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($username,$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_barcode" varchar(16) NULL,
"item_description" BLOB NULL,
"item_purchase_price" varchar(16) NULL,
"item_purchase_date" date NULL,
"item_offer_price" varchar(16) NULL,
"item_offer_date" date NULL,
"item_sold_price" varchar(16) NULL,
"item_sold_date" date NULL,
"item_location" varchar(16) NULL,
"item_quantity" varchar(16) NULL,
"item_shipping_weight" varchar(16) NULL,
"item_status" varchar(16) NULL,
);
CREATE TABLE coin_singles
(
"item_id" numeric PRIMARY KEY,
"coin_grade_services" 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_census" varchar(255) NULL,
"coin_issue_dates" varchar(16) NULL,
"coin_title" varchar(255) NULL,
"coin_description" BLOB NULL,
"coin_condition1" varchar(32) NULL,
"coin_condition2" varchar(32) NULL,
"coin_condition3" varchar(32) NULL,
"coin_photo1" varchar(32) NULL,
"coin_photo2" varchar(32) NULL,
"coin_photo3" 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);
?>
conn = OCILogon(
username,
passwd,
这篇关于PHP / Oracle SQL语句,OciParse的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!