1.已经phpinfo过支持oci8
2.无法使用oci_execute()函数
3.结果不执行也没有看出问题 在哪
<?php
header("Content-type:text/html;charset=utf8");
try{
$user = "*****"; //ORACLE用户名
$password = "***";
$conn = oci_connect($user,$password,"(DEscriptION=(ADDRESS=(PROTOCOL =TCP)(HOST=1.1.1.1(PORT = 1521))(CONNECT_DATA =(SID=tjfxdb)))");
var_dump($conn);
echo "连接成功";
$sql="insert into sd_realtime_sync_03(comcode) value('201503')";
$query=oci_parse($conn, $sql);
$bo=oci_execute($query);//只插入到表3
echo $bo;
}catch(Exception $e){
echo ("Error:".$e->getMessage());
}
?>
结果:
insert into t_model_list (MODEL_ID, SUBSYS_ID, MENU_LEVEL, MODEL_NAME, WIN_NAME, WIN_TYPE, TOOLBAR, TOOL_SPACE)
values (9796, 4, '40,187', '门诊费用补助结算', 'w_kc24_list_mzbcbx', 'M', null, null);
语法错误了 values