已经在数据库mysql里面建立了1个表 hid hmc hpic hurl 在本机网站跟目录下面也新建了upload的文件夹子 图片可以上传到
upload的文件夹子 就是不能存进数据库 大家帮我看看是什么原因 数据库是mysql5.5
<?php
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 2000000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
echo "Hmc: " . $_POST["hmc"] . "<br />";
if (file_exists("../upload/" . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
"../upload/" . $_FILES["file"]["name"]);
echo "Stored in: " . "../upload/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
?>
<?php
$hpic="../upload/" . $_FILES["file"]["name"];
mysql_select_db($database_conn, $conn);
mysql_query("INSERT INTO hdp (hmc,hpic,hurl) VALUES ('$_POST[hmc]','$hpic','$_POST[hurl]')");
mysql_close($conn);
header("Location: " . "hdp.php" );
?>
upload的文件夹子 就是不能存进数据库 大家帮我看看是什么原因 数据库是mysql5.5
<?php
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 2000000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
echo "Hmc: " . $_POST["hmc"] . "<br />";
if (file_exists("../upload/" . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
"../upload/" . $_FILES["file"]["name"]);
echo "Stored in: " . "../upload/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
?>
<?php
$hpic="../upload/" . $_FILES["file"]["name"];
mysql_select_db($database_conn, $conn);
mysql_query("INSERT INTO hdp (hmc,hpic,hurl) VALUES ('$_POST[hmc]','$hpic','$_POST[hurl]')");
mysql_close($conn);
header("Location: " . "hdp.php" );
?>
用以下的代码可以上传
<?php
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 2000000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
echo "Hmc: " . $_POST["hmc"] . "<br />"; if (file_exists("../upload/" . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
"../upload/" . $_FILES["file"]["name"]);
echo "Stored in: " . "../upload/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
?>
-----------------------------------------------------------------
在下面的是传文件后使用命令写入数据库代码
<?php
$hpic="../upload/" . $_FILES["file"]["name"];
mysql_select_db($database_conn, $conn);
mysql_query("INSERT INTO hdp (hmc,hpic,hurl) VALUES ('$_POST[hmc]','$hpic','$_POST[hurl]')");
mysql_close($conn);
header("Location: " . "hdp.php" );
?>
在DW里面连接数据库一切正常 在MYSQL里面建立的其它数据表 都正常 只有这个表获取不到值 是不是上面这条写错了那
<!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>
<form action="upload.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
<table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
<td align="right">幻灯片标题</td>
<td><input type="text" name="hmc" id="hmc" /></td>
</tr>
<tr>
<td align="right">链接URL</td>
<td><input type="text" name="hurl" id="hurl" /></td>
</tr>
<tr>
<td align="right">上传图片文件</td>
<td><input type="file" name="file" id="file" /></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="button" id="button" value="提交" /></td>
</tr>
</table>
</form>
</body>
</html>