快来帮帮忙啊?十分着急啊 ?高手快来啊?php-excel_reader2.php
用---------php-excel_reader2.php上传excel数据插入数据库,为什么只能插入500条数据,
插入代码:::
include 'php-excel-reader-2.21/excel_reader2.php';
set_time_limit(0);//设置运行时间
ignore_user_abort(true);
$data = new Spreadsheet_Excel_Reader();
$salt = substr(uniqid(rand()), -6);
$password = md5(md5($password).$salt);
$sqladd = $uid ? "uid='".intval($uid)."'," : '';
$sqladd .= $questionid > 0 ? " secques='".$this->quescrypt($questionid, $answer)."'," : " secques='',";
$data->setOutputEncoding('gbk');
//$file='D:\111.xls';//$_POST['file'];
//$file1=$_POST['file'];
//echo "+++++++++++++++".$file1;
//”data.xls”是指要导入到mysql中的excel文件
mysql_query("set names 'gbk'");//输出中文
$data->read($file);
$formhash=$_POST['formhash'];
echo $formhash."=======================================================================================".$file;
for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
//echo "=======================================================================================".$file;
//echo $i;
//以下注释的for循环打印excel表数据
/*
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
echo "\"".$data->sheets[0]['cells'][$i][$j]."\",";
}
echo "\n";
*/
//以下代码是将excel表数据【3个字段】插入到mysql中,根据你的excel表字段的多少,改写以下代码吧!
$sql = "INSERT INTO uc_members(username ,Phone,Address,cattype) VALUES(".
$data->sheets[0]['cells'][$i][4].",'".
$data->sheets[0]['cells'][$i][4]."','".
$data->sheets[0]['cells'][$i][2]."','".
$data->sheets[0]['cells'][$i][3]."')".';';
if($data->sheets[0]['cells'][$i][4]==$data->sheets[0]['cells'][$i+1][4]){
//echo '您的数据发现重复数据!';
}else{
mysql_query($sql);
}
}
用---------php-excel_reader2.php上传excel数据插入数据库,为什么只能插入500条数据,
插入代码:::
include 'php-excel-reader-2.21/excel_reader2.php';
set_time_limit(0);//设置运行时间
ignore_user_abort(true);
$data = new Spreadsheet_Excel_Reader();
$salt = substr(uniqid(rand()), -6);
$password = md5(md5($password).$salt);
$sqladd = $uid ? "uid='".intval($uid)."'," : '';
$sqladd .= $questionid > 0 ? " secques='".$this->quescrypt($questionid, $answer)."'," : " secques='',";
$data->setOutputEncoding('gbk');
//$file='D:\111.xls';//$_POST['file'];
//$file1=$_POST['file'];
//echo "+++++++++++++++".$file1;
//”data.xls”是指要导入到mysql中的excel文件
mysql_query("set names 'gbk'");//输出中文
$data->read($file);
$formhash=$_POST['formhash'];
echo $formhash."=======================================================================================".$file;
for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
//echo "=======================================================================================".$file;
//echo $i;
//以下注释的for循环打印excel表数据
/*
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
echo "\"".$data->sheets[0]['cells'][$i][$j]."\",";
}
echo "\n";
*/
//以下代码是将excel表数据【3个字段】插入到mysql中,根据你的excel表字段的多少,改写以下代码吧!
$sql = "INSERT INTO uc_members(username ,Phone,Address,cattype) VALUES(".
$data->sheets[0]['cells'][$i][4].",'".
$data->sheets[0]['cells'][$i][4]."','".
$data->sheets[0]['cells'][$i][2]."','".
$data->sheets[0]['cells'][$i][3]."')".';';
if($data->sheets[0]['cells'][$i][4]==$data->sheets[0]['cells'][$i+1][4]){
//echo '您的数据发现重复数据!';
}else{
mysql_query($sql);
}
}
====================================用技术换广告,谢谢支持=====================================
Ventes Batteries PC Portable, Alimentation PC Portable, Batteries Camescope, Appareil Numerique, des Chargeurs
rolex watches, Replica Watches, Replica Watch
R4DS Cartes, Cartes R4, R4 DSi, R4 SDHC Pour Nintendo DS / DS, Dsi
baterias
R4DS Cartes, Cartes R4, R4 DSi, R4 SDHC Pour Nintendo DS / DS, Dsi
R4DS Cartes, Cartes R4, R4 DSi, R4 SDHC Pour Nintendo DS / DS, Dsi
R4DS Cartes, Cartes R4, R4 DSi, R4 SDHC Pour Nintendo DS / DS, Dsi
R4DS Cartes, Cartes R4, R4 DSi, R4 SDHC Pour Nintendo DS / DS, Dsi