Question

求PHP大神解决语法错误问题

<?php
header('Content-Type:text/html;Charset=utf-8;');

$url="http://www.renrendai.com/";
$str=file_get_contents($url);
$biao1="#<script id=\"loan-list-rsp\" type=\"text/x-json\">(.*)</script>#";
preg_match($biao1,$str,$str1);

$biao2="#\"title\":\"(.*?)\",\"picture\"#";
preg_match_all($biao2,$str1[1],$title);

$biao3="#amount\":(.*?),\"interest#";
preg_match_all($biao3,$str1[1],$amount);

$biao4="#interest\":(.*?),\"months#";
preg_match_all($biao4,$str1[1],$interest);

$biao5="#months\":(.*?),\"loanType#";
preg_match_all($biao5,$str1[1],$months);

$a=count($title[1]);
echo "<pre>";
for($i=0;$i<=$a-1;$i++)
{
echo $title[1][$i].": "."年利率 ".$interest[1][$i]." 金额 ".$amount[1][$i]." 期限 ".$months[1][$i];
echo "<pre>";
}

$con = mysql_connect("localhost","root","root");

if (!$con)
{
die('Could not connect: ' . mysql_error());
}

//if (mysql_query("CREATE DATABASE SJ",$con))
//{
//echo "Database created";
//}
//else
//{
// echo "Error creating database: " . mysql_error();
//}
mysql_select_db('SJ', $con) or die(mysql_error());
$sql="CREATE TABLE biao(
Name CHAR (15),
Rate INT(4) ,
Amount INT(5),
Time INT (2),
)";

mysql_query("insert into biao (Name,Rate,Amount,Time) values
('".$title[1][0]."','".$interest[1][0]."','".$amount[1][0]."','".$months[1][0]."')");

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "Table persons created successfully";

$result = mysql_query("SELECT * FROM biao")or die(mysql_error());

$query = mysql_query($sql);
while($row = mysql_fetch_array($query))
{
echo $row['Name'] . " " . $row['Rate']. " ". $row['Amount']. " " . $row['Time'];
echo "<br />";
}
mysql_close($con);

?>

Answer 1

$sql="CREATE TABLE biao(
Name CHAR (15),
Rate INT(4) ,
Amount INT(5),
Time INT (2), // 去掉这个逗号，你的语句应该先在phpmyadmin里边执行看看再运行
)";

追问

谢谢你，太大意了。