PHP 操作ACCES 插入记录

来源:互联网 发布:易建联篮网数据 编辑:程序博客网 时间:2024/06/05 06:32
<?phperror_reporting(0);set_time_limit(0);$connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath('365XG20110729.mdb'); $connid = @odbc_connect($connstr,"","",SQL_CUR_USE_ODBC ) or die ("数据库连接错误!"); //for($card=36501002;$card<=36502000;$card++){//1000//for($card=80281001;$card<=80282000;$card++){//500for($card=11000001;$card<=11001000;$card++){//1000$Card_ID =  $card;$Card_Pass = rand(100000,999999);//1000元//echo "ID".$Card_ID."  ".$sql  = "INSERT INTO [Qianbo_Card] ([Card_ID],[Card_Pass],[Users],[Money]) VALUES ($Card_ID,$Card_Pass,true,1000);";//500元//echo "ID".$Card_ID."  ".$sql  = "INSERT INTO [Qianbo_Card] ([Card_ID],[Card_Pass],[Users],[Money]) VALUES ($Card_ID,$Card_Pass,true,500);";//1000元echo "ID".$Card_ID."  ".$sql  = "INSERT INTO [Qianbo_Card] ([Card_ID],[Card_Pass],[Users],[Money]) VALUES ($Card_ID,$Card_Pass,true,1000);"; $query  = odbc_do($connid,$sql);odbc_close($sql); }?>

原创粉丝点击