php access Ôö¼Ó¼Ç¼
$conn=new com("ADODB.Connection");
$connstr="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("d:/web/tiku.mdb");
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs_1=new com("ADODB.RecordSet");
$rs->Open("select * from fill_table",$conn,1,1);
$rs_1->Open("select * from stud_answer_table",$conn,1,1);
ÕâÖÖ·½Ê½µÄÁ´½Ó
stud_answer_table ÊǿյÄ
ÎÒÏëÑ»·Ôö¼Ó¼Ç¼ ¿ÉÊDz»Ì«»áÓÃsqlÓï¾ä ÀïÃæÒ²Ã»ÓÐaddnewÓï¾ä
ÇëÎʸÃÔõôд
INSERT INTO person (stud_id,question_type,question_id)
VALUES ($number, 'fill_table', $rs->fields[0]);
insert Óï¾ä¾ÍÕâÑù
ºÜÉÙÈË»áPHP½áºÏACCESSÓõÄ
ÎÒÄÇÑùµÄ·½Ê½ ¶¼²»»áô£¿
$mmm="INSERT INTO stud_answer_table (stud_id,question_type,question_id)
VALUES ('".$number."','".$type."',".$rs->fields[0].")";
Â¥ÉÏ˵µÄºÜ¶Ô
ÎÒȷʵsql php
¶¼²»ÊìϤ
²»¹ý »¹ºÃÕÒµ½·½·¨ÁË
ÈÔÈ»¸Ðл
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
¹ýÍêÄêҪȥÎ人ÁË£¬ÏëÁ˽âÒ»ÏÂPHPÅàѵ±È½ÏÕý¹æ?
Ŷ ¶ÔÁË£¬»¹ÓУ¡PHPÊÖ²á±ØÐëµÃŪһ¸ö
àÅ ÌìÌìÔÚ¿´Ê¥¾£¨Ò»ÌìÒ²¾ÍÖ»ÄÜ¿´¸ö¶þʮҳ£©£¬PHP100ÊÓÆµ½Ì³Ì¿´ÁË33½²ÁË£¨Ò»ÌìÒ²Ö»¿´Ò»½²£©
ÎÒ»á¼á³Ö°ÑÕâ±¾ÊéºÍÊÓÆµ¸ã¶¨ ......
ÇëÎÊ£¬ÒÔÏ´úÂ룬Ϊʲô²»¹ÜÓ㿾Ístr_replaceÕâ¸öº¯Êý£¬Ì滻ôÓÐÆð×÷Óã¿
PHP code:
$gg='<script type=\"text/JavaScript\">
alimama_pid=\"mm_14281022_2030060_8250750\";
alima ......