已经在数据库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" );
?>
解决方案 »
- fatal error 网上找的答案都解决不了
- php源码IE下乱码,Firefox不是乱码,请大家帮忙看看。
- 怎么得打”http://www.verycd.com/sto/book/“你的内容?
- 这是怎么回事啊?哪位知道的??
- 重新编译了下 MagickWand (for Win32) 散分
- PHP中如何将从数据库中提取出来的数据清单页面(比如说是把所有的帖子都列出来)静态化?
- 新闻系统生成一个新的静态html文章后,其文章目录是否自动重新生成还是手动重新生成?
- php中有没有类似asp中的application对象来存储所有用户共享的变量?
- 奇怪!这个问题怎么解决啊!
- help me!!!高手救救我
- 又来老问题了,使用PHPMAILER发送不了邮件
- 一开始学php用wampserver搭建吗?
用以下的代码可以上传
<?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>