|
 |
| |
ช่วยด้วยคะ สอบถามปัญหาการ update ข้อมูล ไม่ติด error แต่ไม่มีการอัพเดทบนฐานข้อมูล |
| |
 |
|
|
 |
 |
|
manage.php *****
<meta http-equiv=Content-Type content="text/html; charset=utf8">
<?php
include ('function1.php');
$dblink = connect_db();
$todo = $_GET ['todo'];
$pid = $_POST ['pid'];
$name = $_POST ['name'];
$info = $_POST ['info'];
$cid = $_POST ['cid'];
$pic = $_POST ['pic'];
$lat = $_POST ['lat'];
$longitude = $_POST ['longitude'];
if( $todo == 'insertplace' ) {
$strSQL = "INSERT INTO tbl_placeinfo (pid, pname, info, cid, pic, lat , longitude)
VALUES ('$pid' , '$pname' , '$info' , '$cid' , '$pic' , '$lat','$longitude' ) ";
$result = mysqli_query($dblink, $strSQL);
if ($result){
echo 'Insert Complete';
}
else echo $strSQL;
}
if( $todo == 'insertcatalog' ) {
$strSQL = "INSERT INTO tbl_catalog (cid, cname, status)
VALUES ('$cid' , '$cname' , '$status' ) ";
$result = mysqli_query($dblink, $strSQL);
if ($result){
echo 'Insert Complete';
}
else echo $strSQL;
}
if( $todo == 'updateplace' ) {
$pid = $_POST ['pid'] ;
$strSQL = " UPDATE tbl_placeinfo SET pid = '$pid', pname = '$pname' , info = '$info' , cid = '$cid' , pic = '$pic' , lat = '$lat' ,longitude = '$longitude'
WHERE pid = '$pid' ";
$resultSQL = mysqli_query($dblink,$strSQL);
if ($resultSQL) {
echo 'Update Complete';
echo '<meta HTTP-EQUIV = "refresh" CONTENT = "2; URL=showinfo.php">';
}
else echo $strSQL;
}
?>
********************** update form
<meta http-equiv=Content-Type content="text/html; charset=utf8">
<?
include "function1.php";
$dblink = connect_db();
$pid = $_GET['pid'];
$strSQL = "SELECT pid, pname, info, cid, pic, lat, longitude FROM tbl_placeinfo WHERE pid = '$pid' ";
$resultSQL = mysqli_query($dblink, $strSQL);
$rows = mysqli_fetch_array($resultSQL);
?>
<form method = "POST" action = "manage.php?todo=updateplace">
<fieldset>
<legend>แก้ไขสถานที่</legend>
<div>
<label> Name </label>
<input type = "text" name = "pname" value="<?=$rows['pname']?>" >
</div>
<div>
<label> Info </label>
<textarea name = "info"> <?=$rows['info'] ?></textarea>
</div>
<div>
<label> Catalog </label>
<?
catalog_select_update($rows['cid']);
?>
</div>
<div>
<label> Picture </label>
<input type = "file" value = "Choose File" name = "pic" >
</div>
<div>
<label> Lattitude </label>
<input type = "text" name = "lat" value="<?=$rows['lat']?>" >
</div>
<div>
<label> Longitude </label>
<input type = "text" name = "longitude" value="<?=$rows['longitude']?>">
</div>
<div>
<input type = "hidden" name = "pid" value = "<?=$pid?>">
<input type="submit" value ="Update" />
<input type="reset" value ="Clear" />
</div>
</fieldset>
</form>
************ function
function catalog_select_update($cid){
$dblink = connect_db ();
$strSQL = " SELECT cid , cname FROM tbl_catalog ";
$resultSQL = mysqli_query($dblink,$strSQL);
echo '<select cname ="cid">';
echo '<option value=" "> เลือกหมวดหมู่</option>';
while ($rows = mysqli_fetch_array($resultSQL))
{
echo '<option value= "'.$rows['cid'].' " ' ;
if ($rows ['cid'] == $cid) echo ' selected';
echo '>'.$rows['cname'].' </option>';
}
echo '</select>';
}
?>
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2014-08-06 16:09:24 |
By :
pmars |
View :
740 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
1. echo $todo = $_GET ['todo']; ออกมาดูครับมีค่าอยู่จริงหรือไม่
2. $resultSQL = mysqli_query($dblink,$strSQL) or die (mysql_error()); เพิ่มส่วนนี้เข้าไปใน update
|
| |
|
|
| |
| Date :
2014-08-06 16:37:19 |
By :
Ex-[S]i[L]e[N]t |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
รับค่ามา $name = $_POST ['name'];
ชื่อฟิลด์ที่ต้องการ update คือ pname
ค่าทีี่ต้องการอัพเดท คือ $pname
pname เอามาจากไหน หาไม่เจอ
ตัวอื่น ๆ ที่ไม่มีค่า ก็ต้องไปไล่หาว่าค่ามันหายไปไหน
หรือ ตั้งชื่อตัวแปร ไม่ตรงกันก็ได้มั้ง
|
| |
|
|
| |
| Date :
2014-08-06 19:25:32 |
By :
apisitp |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 05
|
Quote:
