<span style="font-size:24px;color:#ff0000;"><strong>新手初涉PHP,望各位大牛多多指点</strong></span>,为了媳妇而学,干爸爹
<?php
//文件读取
echo("<h1>逐行读取文本内容</h1>");
$fh = fopen('table/同顺兴产品表.txt','r');
$tableArr = array();
for ($line = fgets($fh); !feof($fh); $line = fgets($fh)) {
$line = trim($line);
$info = explode("\t", $line);
$tableArr[] = $info;
}
fclose($fh);//关闭读取文件
//将tablArr里的第一个元素去掉
$temp = array_slice($tableArr, 1);
//print_r($temp);
/*for($i = 0;$i < count($temp);$i++){
foreach($temp[$i] as $value){
echo($value."\t");
}
echo("<br />");
}*/
$link=@mysql_connect("localhost","root","888") or die ("connect mysql failed"); // die连接失败
//选择要操作的数据库
mysql_select_db("product") or die("Unable to select database!");
//构造一个SQL查询,清空表
$query = "delete from productinfo;";
//执行该查询
$result = mysql_query($query) or die("Error in query: $query. ".mysql_error());
//mysql插入语句
//$query = 'load data local infile "D:/wamp/www/test_1/table/同顺兴产品表.txt" into table productinfo';
//拼接mysql语句
$query = "INSERT INTO productinfo VALUES ";
$sql = "(";
for($i = 0;$i < count($temp);$i++){
if(0 < $i) $sql = $sql."(";
for($j = 0;$j < count($temp[$i]);$j++){
$sql = $sql.'"'.$temp[$i][$j].'"';
if(count($temp[$i]) - 1 != $j)
$sql = $sql.",";
}
if(count($temp) - 1 == $i) $sql = $sql.");";
else $sql = $sql."),";
}
$query = $query.$sql;
//构造一个SQL查询
$result = mysql_query($query) or die("Error in query: $query. ".mysql_error());
//插入操作成功后,显示插入记录的记录号
echo("记录已经插入, mysql_insert_id() = ".mysql_insert_id()."<br />");
mysql_close($link); // 关闭数据库连接
?>
<?php
echo("<h1>Hello PHP</h1>");
echo("<h2>Hello PHPSTORM</h2>");
// 连接数据库mysql_connect ( $URL, $USER, $PASSWORD ) 数据库地址,用户名,密码
$link=@mysql_connect("localhost","root","888") or die ("connect mysql failed"); // die连接失败
//选择要操作的数据库,执行查询语句
//选择数据库
mysql_select_db("product") or die("Unable to select database!");
//构造一个SQL查询
$query = "SELECT * FROM `productinfo`;";
//执行该查询
$result = mysql_query($query) or die("Error in query: $query. ".mysql_error());
mysql_close($link); // 关闭数据库连接
// 显示数据
echo("<table border='1'>");
echo("<tr><td>产品ID</td><td>产品名</td><td>保质期</td><td>价格</td><td>供应商</td></tr>");
while(NULL!=($row=mysql_fetch_row($result))){
echo("<tr>");
foreach ($row as $value){
echo("<td>".iconv("GBK","UTF-8",$value)."</td>");
}
echo("</tr>");
}
echo("</table>");
?>