PHP 操作ACCES 插入记录

<?php
error_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++){//500
for($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); 
}
?>

posted @ 2013-04-25 16:44  网络剑客  阅读(133)  评论(0)    收藏  举报