Advertisement
Guest User

Untitled

a guest
Sep 14th, 2017
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 1.68 KB | None | 0 0
  1. <table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
  2. <tr>
  3. <td><center><strong><a href="guestbook.php">Nazad na formular za upis</a> </strong></center></td>
  4. </tr>
  5. </table>
  6. <br>
  7.  
  8. <?php
  9.  
  10. $host="localhost";
  11. $username="root";
  12. $password="";
  13. $db_name="db_guestbook";
  14. $tbl_name="tbl_data";
  15.  
  16. $con = mysql_connect("$host", "$username", "$password") or die(mysql_error());
  17. if(!$con)
  18.     die(mysql_error());
  19. mysql_select_db("$db_name") or die(mysql_error());
  20.  
  21. if($_SERVER['REQUEST_METHOD'] == 'POST')
  22. {
  23.    $id = $_POST['id'];
  24.    $name = $_POST['name'];
  25. }
  26. else
  27. {
  28. $id = (int)$_GET['id'];
  29.  
  30. $sql = "SELECT * FROM $tbl_name WHERE ID = $id";
  31. $result = mysql_query($sql);
  32. $row = mysql_fetch_array($result, MYSQL_BOTH);
  33.  
  34. ?>
  35.  
  36. <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  37. <tr>
  38. <td><table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#DFFFDF">
  39. <form name="entryform" action="" method="post">
  40. <tr>
  41. <td width="70">Ime</td>
  42. <td width="15">:</td>
  43. <td width="315"><textarea rows="1" name="tname"><? echo $row['Name']; ?></textarea></td>
  44. </tr>
  45. <tr>
  46. <td>E-Mail</td>
  47. <td>:</td>
  48. <td><textarea rows="1" name="temail"><? echo $row['Email']; ?></textarea></td>
  49. </tr>
  50. <tr>
  51. <td valign="top">Komentar</td>
  52. <td valign="top">:</td>
  53. <td><textarea rows="6" cols="40" name="tcomment"><? echo $row['Comment']; ?></textarea></td>
  54. </tr>
  55. <tr>
  56. <td valign="top">Datum </td>
  57. <td valign="top">:</td>
  58. <td><? echo $row['Datetime']; ?></td>
  59. </tr>
  60. <td></td><td></td><td valign="top" align="right"><input type="submit" value="Potvrdi"/></td>
  61. </table></td>
  62. </tr>
  63. </form>
  64. </table>
  65. <BR>
  66.    
  67. <?php
  68. mysql_close();
  69. }
  70.  
  71. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement