แอดข็อมูลลงฐานข้อมูลไม่ได้ครับ ดูให้ทีครับบบบบ มือใหม่ครับบบบบบบบบบบบบบบบบบบบบบบบบ
Code (PHP) <?
session_start();
include "function.php";
?>
<!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=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<H3>เพิ่มข่าวสารใหม่</H3>
<FORM ACTION="index.php?option=working&com_working=working&do=adds" METHOD="POST" ENCTYPE="mutipart/form-data">
<table>
<tr>
<td><b>หัวข้อข่าว : </b></td>
<td><input name="title" id="title" type="text" size="30"> </td>
</tr>
<tr>
<td><b>ประเภท : </b></td>
<td>
<select name="type" id="type">
<option value="0"> -- เลือก --</option>
<?
for ($i=1;$i<=count ($newtype);$i++) {
echo "<option value='$i'>$newtype[$i] </option>";
}
?>
</select>
</td>
</tr>
<tr>
<td valign="top"><b>เนื้อหา : </b></td>
<td><textarea name="detail" id="detail" cols="30" rows="8"></textarea></td>
</tr>
<tr>
<td valign="top"><b>รูปภาพ : </b></td>
<td><input name="photo" id="photo" type="file" ></td>
</tr>
<tr>
<td> </td>
<td><input type="Submit" value="Submit">
<input type="Reset" value="Reset"></td>
</tr>
<br>
</table>
<br>
</body>
</FORM>
</html>
Code (PHP) <?php
session_start();
include "config.inc.php";
$title=$_POST['title'];
$detail=$_POST['detail'];
$type=$_POST['type'];
$photo=$_FILES['photo']['tmp_name'];
$photo_name=$_FILES['photo']['name'];
$photo_size=$_FILES['photo']['size'];
$photo_type=$_FILES['photo']['type'];
$date_today=date("Y-m-d");
$time_today=date("H:i:s");
if ($title=="" or $detail=="" or $type=="0")
{
echo "";
exit();
}
$sql="INSERT INTO tb_new values('','$title','$detail','$type','','$date_today','$time_today')";
mysql_db_query("$dbname",$sql);
$ext = strtolower(end(explode('.', $photo_name)));
if ($ext == "jpg" or $ext == "jpeg" or $ext == "png" or $ext == "gif") {
$sql="select max(id_new) from tb_new";
$result=mysql_db_query($dbname,$sql);
$r=mysql_fetch_array($result);
$id_max=$r[0];
$filename=$id_max.".".$ext;
copy($photo,"photo/$filename");
$sql="update tb_new set photo_new='$filename' where
id_new='$id_max' ";
mysql_db_query($dbname,$sql);
}
echo "fghfh";
mysql_close();
?>
Tag PHP, MySQL
Date :
2011-01-16 02:16:06By :
vanuView :
697Reply :
2
error แบบนี้ครับ
Date :
2011-01-16 03:11:11By :
vanu
$result=mysql_db_query($dbname,$sql); บรรทัดที่ 39 ของไฟล์ที่ 2
Date :
2011-01-16 12:13:37By :
ppanchai
Server 03
Load balance : Server 03
