请教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导出大量数据 apache问题依旧 mysql数据库中新建了用户权限不够 怎么给用户增加权限 对于用php+mysql做留言如何设计数据库的问题 php sqlserver 有什么 弊病 php blog制作问题 求救啊,做不出来就被开除了! 关于url地址栏的“问号”的问题 高手来看!一直困扰的莫名其妙的session问题 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();
?>
我改变了一下后,两种情况都可以了!怪