21,887
社区成员
发帖
与我相关
我的任务
分享
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>查看帖子单独页面</title>
</head>
<body>
<?
//$in_id = $_REQUEST['in_id'];
$in_id = intval($_GET['in_id']);
if($in_id <= 0) exit('BAD_REQUEST');
$mysql_server_name = "localhost";
$mysql_username = "lipichang";
$mysql_password = "123456";
$mysql_database = "lyb";
echo $in_id;
//建立连线————透过(服务器地址,使用名称,密码)
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
mysql_query("SET NAMES 'gbk'");
$sql = "SELECT * FROM `newinsert` where in_id = ".$in_id;
echo $sql;
$result = mysql_query($sql);
while($row = mysql_fetch_row($result))
{
//print_r($result);
print_r($row);
}
?>
</body>
</html>
SELECT * FROM `newinsert` where in_id =
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in F:\AppServ\www\only.php on line 31
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>查看帖子单独页面</title>
</head>
<body>
<?
$in_id = $_REQUEST['in_id'];
$mysql_server_name = "localhost";
$mysql_username = "lipichang";
$mysql_password = "123456";
$mysql_database = "lyb";
echo $in_id;
//建立连线————透过(服务器地址,使用名称,密码)
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql = "SELECT * FROM `newinsert` where in_id = ".$in_id;
echo $sql;
mysql_select_db($mysql_database,$conn);
mysql_query("SET NAMES 'gbk'");
$result = mysql_query($sql);
while($row = mysql_fetch_row($result))
{
print_r($result);
}
?>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>查看所有帖子页面</title>
</head>
<body>
<?
$mysql_server_name = "localhost";
$mysql_username = "lipichang";
$mysql_password = "123456";
$mysql_database = "lyb";
//建立连线————透过(服务器地址,使用名称,密码)
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql = "SELECT * FROM `newinsert`";
mysql_select_db($mysql_database,$conn);
mysql_query("SET NAMES 'gbk'");
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$id=$row[0];
?>
<li><a href="only.php">第<?=$row['in_id'];?>个帖子</a><li>
发表人:<?=$row['1']."先生(小姐)";?>
<li><a href="only.php">标题:<?=$row['2'];?></a></li>
<li>发表时间:<?=$row['4'];?></a></li>
<? echo "<P>-------------------------------------------------------<P>";?>
<?
}
mysql_free_result($result);
?>
</body>
</html>
<li><a href="only.php?id=<?=$row['0'];?>">第<?=$row['0'];?>个帖子</a><li>