<?php
require_once(dirname(__FILE__)."/config.php");
error_reporting(E_ALL ^ E_NOTICE);
if($_POST){
$Import_TmpFile = $_FILES['file']['tmp_name'];require_once '../include/Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('UTF-8');
$data->read($Import_TmpFile);
$array =array();
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
$array[$i][$j] = $data->sheets[0]['cells'][$i][$j];
}
}
sava_data($array);}
function sava_data($array){
$count =0;
$total =0;
foreach($array as $tmp){
$inQuery = "Insert into #@__hedui (mtype,uname,sfz,phone,shi,shoujuhao,city,school,zhuanye) value('".$tmp[1]."','".$tmp[2]."','".$tmp[3]."','".$tmp[4]."','".$tmp[5]."','".$tmp[6]."','".$tmp[7]."','".$tmp[8]."','".$tmp[9]."')";
$res = $dsql->ExecuteNoneQuery($inQuery);
if($res){
$query = "delete from #@__hedui where sfz='身份证'";
$dsql->ExecuteNoneQuery($query);
$count++;
}
$total++;
}
echo "<script>alert('共有".($total-1)."条数据,导入".($count-1)."条数据成功');</script>";
}
function TtoD($text){
$jd1900 = GregorianToJD(1, 1, 1900)-2;
$myJd = $text+$jd1900;
$myDate = JDToGregorian($myJd);
$myDate = explode('/',$myDate);
$myDateStr = str_pad($myDate[2],4,'0', STR_PAD_LEFT)."-".str_pad($myDate[0],2,'0', STR_PAD_LEFT)."-".str_pad($myDate[1],2,'0', STR_PAD_LEFT);
return $myDateStr;
}
?>
为什么会出现Fatal error: Call to a member function ExecuteNoneQuery() on a non-object这个错误!~
require_once(dirname(__FILE__)."/config.php");
error_reporting(E_ALL ^ E_NOTICE);
if($_POST){
$Import_TmpFile = $_FILES['file']['tmp_name'];require_once '../include/Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('UTF-8');
$data->read($Import_TmpFile);
$array =array();
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
$array[$i][$j] = $data->sheets[0]['cells'][$i][$j];
}
}
sava_data($array);}
function sava_data($array){
$count =0;
$total =0;
foreach($array as $tmp){
$inQuery = "Insert into #@__hedui (mtype,uname,sfz,phone,shi,shoujuhao,city,school,zhuanye) value('".$tmp[1]."','".$tmp[2]."','".$tmp[3]."','".$tmp[4]."','".$tmp[5]."','".$tmp[6]."','".$tmp[7]."','".$tmp[8]."','".$tmp[9]."')";
$res = $dsql->ExecuteNoneQuery($inQuery);
if($res){
$query = "delete from #@__hedui where sfz='身份证'";
$dsql->ExecuteNoneQuery($query);
$count++;
}
$total++;
}
echo "<script>alert('共有".($total-1)."条数据,导入".($count-1)."条数据成功');</script>";
}
function TtoD($text){
$jd1900 = GregorianToJD(1, 1, 1900)-2;
$myJd = $text+$jd1900;
$myDate = JDToGregorian($myJd);
$myDate = explode('/',$myDate);
$myDateStr = str_pad($myDate[2],4,'0', STR_PAD_LEFT)."-".str_pad($myDate[0],2,'0', STR_PAD_LEFT)."-".str_pad($myDate[1],2,'0', STR_PAD_LEFT);
return $myDateStr;
}
?>
为什么会出现Fatal error: Call to a member function ExecuteNoneQuery() on a non-object这个错误!~
解决方案 »
- php curl模拟登录 但是服务那边是用js获取cookie的,获取不到,php代码里能获取到,请问应该在curl里怎么设置...
- PHP 文件包含后,数据不显示
- 请问如何抓取远程页面的内容
- 各个站点用户共享
- 两个列表框的问题。
- [100分求助]xp sp3+php5.2+mysql5.0+apache2.2+phpmyadmin3.2无法加载mysql扩展问题!
- php+MYSQL:前台显示正常,数据库看到的却是乱码
- 两个嵌套表单要分别提交,请问如何实现?
- 哪位大侠知道怎么配置PHP4.31-dev for Win32 + IIS?急
- FORM发送指定邮件
- ajax提交 传图片问题
- 求用正则将 $str="|你好|我好|他好|";
$inQuery = "Insert into #@__hedui (mtype,uname,sfz,phone,shi,shoujuhao,city,school,zhuanye) value('".$tmp[1]."','".$tmp[2]."','".$tmp[3]."','".$tmp[4]."','".$tmp[5]."','".$tmp[6]."','".$tmp[7]."','".$tmp[8]."','".$tmp[9]."')";
$res = $dsql->ExecuteNoneQuery($inQuery);