解决方案 »
- phpmyadmin出现了Fatal error: Call to a member function getName() 怎么都打不开了。
- 求助!关于页面中换行问题
- Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resourc
- 用php去除mysql中某字段的所有汉字内容难题。。。。。
- strpos问题..........救命......
- PHP的得分终于超过了灌水区
- 求救!unable to save result..... 再线等,分不够再加!!
- 菜鸟求教!
- 在phpx联盟中的回复不满意,就上这里来请教,谢谢!
- php中的sockets如何使用
- if的问题
- windows下apache经常卡死
<?phprequire_once 'Excel/reader.php';$data = new Spreadsheet_Excel_Reader();if($_FILES){ $check = substr($_FILES["file"]["name"],strrpos($_FILES["file"]["name"],".")+1); if ( $check == "xls" || $check == "xlsx")
{
move_uploaded_file($_FILES["file"]["tmp_name"],"upload/" . $_FILES["file"]["name"]);
}
else
{
exit('no');
}$data->setOutputEncoding('UTF-8');$data->read("upload/" . $_FILES["file"]["name"]);error_reporting(E_ALL ^ E_NOTICE);$db_host = 'localhost'; //edit_config
$db_user = 'root';
$db_password = 'root';
$db_port = 3306;
$db_name = 'test';$con = mysql_connect($db_host,$db_user,$db_password);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}$db_selected = mysql_select_db($db_name, $con);if (!$db_selected)
{
die ("Can\'t use test_db : " . mysql_error());
}//删除已存在表if(!($result = mysql_query("DROP TABLE IF EXISTS `uchome_test`",$con))){ echo mysql_error(); }//新建表
$result = mysql_query("CREATE TABLE uchome_test (
uid mediumint(8) unsigned NOT NULL,
username char(15) NOT NULL default '',
shuipiao int(8) unsigned NOT NULL default 20,
PRIMARY KEY (uid)
) ENGINE=MyISAM",$con);if(!$result){ echo mysql_error(); }
for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
$insertdata[$j] = $data->sheets[0]['cells'][$i][$j];
}
$result = mysql_query("INSERT INTO `uchome_test` (uid,username,shuipiao) VALUES ('{$insertdata[1]}','{$insertdata[2]}','{$insertdata[3]}')",$con);
if(!$result){ echo mysql_error(); }
echo "插入一行";
echo "\n";
echo "<br />";}mysql_close($con);}else{echo <<<EOF<html>
<body>
<form action="{$_SERVER['PHP_SELF']}" method="post"
enctype="multipart/form-data">
<label for="file">Excel:</label>
<input type="file" name="file" id="file" />
<br />
<input type="submit" name="submit" value="import" />
</form>
</body>
</html>EOF;}?>