PHP 操作ACCES 插入记录

最新推荐文章于 2021-03-11 17:44:51 发布

网络剑客

最新推荐文章于 2021-03-11 17:44:51 发布

阅读量671

点赞数

分类专栏： PHP技术

本文链接：https://blog.csdn.net/dongsg11200/article/details/8850431

版权

PHP技术专栏收录该内容

99 篇文章 1 订阅

订阅专栏

<?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); 
}
?>