请教php 提交 access ? 先要获取表单提交的变量比如$name1 = $_REQUEST("name1"); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 那试试用odbc_connect()和odbc_exec() Access 有一些参数必须用[]扩起来,否则可能跟系统变量冲突,比如insert into [people] ([id],[name]) values( 2,'benbena') to benbena(ben).和参数好像不相关。以下是我读access 时用到的,正常啊。$rs=$dbc->execute("select * from people"); ============================to downcast.-----------<?$dbc=new com("adodb.connection"); $dbc->open("DRIVER=Microsoft Access Driver (*.mdb);DBQ=f:\\db1.mdb");$id1 = $_REQUEST("id1");$name1 = $_REQUEST("name1");$sex1 = $_REQUEST("sex1");$year1 = $_REQUEST("year1");$work1 = $_REQUEST("work1");$startwork1 = $_REQUEST("startwork1");$rs=$dbc->execute("insert into people(id,姓名,性别,出生年月,工作地,开始工作时间) values($id1,$name1,$sex1,$year1,$work1,$startwork)");$rs->close(); ?>===========还是没有成:出错信息如下:Notice: Array to string conversion in F:\Program Files\Apache Group\Apache2\htdocs\taikang\writeaccess.php on line 4Fatal error: Call to undefined function: array() in F:\Program Files\Apache Group\Apache2\htdocs\taikang\writeaccess.php on line 4还请帮忙。谢谢 晕死~~$name1 = $_REQUEST["name1"];对不起打错了 -_- $rs=$dbc->execute("insert into people(id,姓名,性别,出生年月,工作地,开始工作时间) values('$id1','$name1','$sex1','$year1','$work1','$startwork')"); <?$dbc=new com("adodb.connection"); $dbc->open("DRIVER=Microsoft Access Driver (*.mdb);DBQ=d:\\db1.mdb"); //DBQ=d:\db1.mdb$rs=$dbc->execute("insert into people(name,sex,year,work,startwork) values(".$name1.",".$sex1.",".$year1.",".$work1.",".$startwork1.");");$rs->close(); ?>我改变了一下后,两种情况都可以了!怪 《Linux程序设计》(第二版)机械工业出版社,译者: 杨晓云 王建桥 杨涛 高文雅 等 ,绝对的入门好书,正在学习中…… 这个php代码如何打开,望高手指点 新手求解!!Cannot modify header information…的问题TAT 这个组合函数怎么拼装? php调用java webservice问题? php文件测试时,出现这一段话,请高手们帮忙看看,谢谢 ! mysql存储进程几问——循环流程和变量使用范围、二次使用游标等 深圳PHP培训(PCTI)开始试招生 TOM在线搜索引擎频道招聘信息 能不能点击链接时直接下载php文件?而不是在服务器上执行。 新手问题 很焦急,期盼高手的回答 大家提点意见!来者有分
to downcast.
-----------
<?
$dbc=new com("adodb.connection");
$dbc->open("DRIVER=Microsoft Access Driver (*.mdb);DBQ=f:\\db1.mdb");
$id1 = $_REQUEST("id1");
$name1 = $_REQUEST("name1");
$sex1 = $_REQUEST("sex1");
$year1 = $_REQUEST("year1");
$work1 = $_REQUEST("work1");
$startwork1 = $_REQUEST("startwork1");
$rs=$dbc->execute("insert into people(id,姓名,性别,出生年月,工作地,开始工作时间) values($id1,$name1,$sex1,$year1,$work1,$startwork)");$rs->close();
?>
===========
还是没有成:出错信息如下:
Notice: Array to string conversion in F:\Program Files\Apache Group\Apache2\htdocs\taikang\writeaccess.php on line 4Fatal error: Call to undefined function: array() in F:\Program Files\Apache Group\Apache2\htdocs\taikang\writeaccess.php on line 4还请帮忙。谢谢
$dbc=new com("adodb.connection");
$dbc->open("DRIVER=Microsoft Access Driver (*.mdb);DBQ=d:\\db1.mdb"); //DBQ=d:\db1.mdb
$rs=$dbc->execute("insert into people(name,sex,year,work,startwork) values(".$name1.",".$sex1.",".$year1.",".$work1.",".$startwork1.");");$rs->close();
?>
我改变了一下后,两种情况都可以了!怪