21,886
社区成员
发帖
与我相关
我的任务
分享
>Sujet: </label> <input type=\"hidden\" name=\"sujet\" value=\"".$row['sujet']."\">
<?php
$conn = mysql_connect("localhost","root","") or die("Sorry, can't connect: ".mysql_error());
mysql_select_db($db);
$query = "SELECT sujet, bdate, nature, adetail, decideur FROM besoin ORDER BY bdate DESC";
$result = mysql_query($query, $conn) or die("Sorry, don't get result for error: ".mysql_error());
while($row = mysql_fetch_assoc($result)){
echo " <tr> <td>".$row["sujet"]." </td>";
echo " <td>".$row["bdate"]." </td>";
echo " <td>".$row["nature"]." </td>";
echo " <td>".$row["adetail"]." </td>";
echo " <td>".$row["decideur"]." </td>";
//这个东西?
echo " <td> <a href=\"detail.php?sujet=".$row["sujet"]."\" alt=\"detail\">DETAIL </a> </td>"
echo " </tr> <br>";
}
?>
detail.php:
<?php
$conn = mysql_connect("localhost","root","") or die("Sorry, can't connect: ".mysql_error());
mysql_select_db($db);
//这个?
$sujec = isset($_GET['sujet'])?$_GET['sujet']: '';
//todo check?
$query = "SELECT sujet, bdate, etat, qdate, qdetail, pdate, pdetail FROM besoin where sujet = $sujec ";
$result = mysql_query($query, $conn) or die("Sorry, don't get result for error: ".mysql_error());
$row = mysql_fetch_assoc($result);
echo" <div id=\"form\">";
echo " <form>";
echo " <label>Sujet: </label> <input type=\"text\" name=\"sujet\" value=\"".$row['sujet']."\"> <br> <br>";
echo " <label>Etat: </label> <input type=\"text\" name=\"etat\" value=\"".$row["etat"]."\"/> <br> <br>";
echo " <label>Date: </label> <input type=\"text\" name=\"bdate\" value=\"".$row["bdate"]."\"/> <br> <br>";
echo " <h2>Qualification </h2> <br>";
echo " <label>Date: </label> <input type=\"text\" name=\"qdate\" value=\"".$row["qdate"]."\"/> <br> <br>";
echo " <label>Detail: </label> <br>";
echo " <textarea name=\"qdetail\" cols=\"40\" rows=\"5\">".$row["qdetail"]." </textarea> <br> <br>";
echo " <h2>Proposition </h2> <br>";
echo " <label>Date: </label> <input type=\"text\" name=\"pdate\" value=\"".$row["pdate"]."\" /> <br> <br>";
echo " <label>Detail: </label> <br>";
echo " <textarea name=\"pdetail\" cols=\"40\" rows=\"5\">".$row["pdetail"]." </textarea> <br> <br>";
echo " </form> <br>";
echo " </div>";
?>