21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
$host="localhost";
$user="root";
$password="123456";
$database="teacher";
$table_name="student";
$conn=mysql_connect($host,$user,$password);
echo "1111";
if(!mysql_connect($host,$user,$password))
die("connect erroring..... ".mysql_error());
mysql_select_db($database,$conn);
// mysql_query("SET NAMES 'GB2312'"); //blob 类型是二进制的,不需要设置语言编码
$result=mysql_query("select * from student where picnum=$_GET[picnum]");
$row=mysql_fetch_object($result);
Header("Content-type:image/gif");
echo $row->pic;
?>
<html>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<HEAD>
<body>
<?php
$host="localhost";
$user="root";
$password="123456";
$database="test1";
$table_name="teacher";
$conn=mysql_connect($host,$user,$password);
if(!mysql_connect($host,$user,$password))
die("connect erroring..... ".mysql_error());
mysql_select_db($database,$conn);
mysql_query("SET NAMES 'GB2312'");
$v_find="select picnum from teacher";
$result=mysql_query($v_find,$conn) ;
while($row=mysql_fetch_object($result))
{
echo "<img src='pic.php?picnum=".$row->picnum."'>";
}
?>
</body>
</html>