Add.php
<?php
session_start();
include('config.php');
$strSQL = "SELECT * FROM member WHERE UserID = '".$_SESSION['UserID']."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
error_reporting (E_ALL ^ E_NOTICE);
?>
<!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=windows-874" />
<title>รายล่ะเอียด</title>
</head>
<body>
<?php
$result = mysql_query("SELECT * FROM `name` WHERE `TID` ='".$_GET["TID"]."'");
while($row = mysql_fetch_array($result))
{
echo "<br />";
echo $row['TID'];
echo "เรื่อง";
print $row['Name'];
}
$result = mysql_query("SELECT * FROM `link` WHERE `TID` ='".$_GET["TID"]."'");
while($row = mysql_fetch_array($result))
{
echo "<br />";
echo "ชื่อ";
print $row['Link'];
}
mysql_close();
?>
<form method="post" action="link.php">
<table width="400" align="center">
<tr><td align="center">ลิงค์ : </td><td><input type="text" name="Link" size="50"></td></tr>
<tr>
<td align="center">ชื่อ : </td>
<td><input type="text" name="Namelink" size="50"></td></tr>
<tr>
<td align="center"></td>
<td align="center"> <input type="radio" name="Status" id="radio" value="S1" />
1
<label for="Status"></label>
<input type="radio" name="Status" id="radio2" value=2" />
2
<input type="radio" name="Status" id="radio3" value="3" />
<label for="Status"></label>
3</td>
</tr>
<tr><td align="center" colspan="2"><input type="submit" value="ตอบ">
<input type=hidden name="TID" id="TID" value="<?php echo $row["TID"];?>" readonly>
<input type=hidden name="Username" id="Username" value="<?php echo $objResult["Username"];?>" readonly></td></tr>
</table>
</form>
</body>
</html>
link.php
<?php
session_start();
include('config.php');
$strSQL = "SELECT * FROM member WHERE UserID = '".$_SESSION['UserID']."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
?>
<!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=windows-874" />
<title>เพิ่ม</title>
</head>
<body>
<?php
include('config.php');
$adate=date("D/M/Y");
$result = mysql_query ("INSERT INTO `link` (`TID`, `Username`, `Status`, `Link`, `Namelink`, `adate`)
VALUES ( '".$_POST["TID"]."', '".$_POST["Username"]."', '".$_POST["Status"]."', '".$_POST["Link"]."', '".$_POST["Namelink"]."', '".$_POST["adate"]."')")or die (mysql_error());
if($result){
echo "เพิ่มแล้ว";
} else{
echo "Error";
}
mysql_close();
?>
<a href=javascript:history.back();>กลับไปแก้ไข</a>
</body>
</html>
ค่าตัวเองแปร TID มันไม่สามารถยัดลง Database ได้ครับ ตัวอื่นลงหมดยกเว้นมันนี้ล่ะ ผิดตรงไหนเหรอครับ
Tag : PHP, MySQL
