Advertisement
Guest User

Untitled

a guest
Mar 8th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 2.68 KB | None | 0 0
  1. <html>
  2. <head>
  3. <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
  4. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
  5. <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
  6. </head>
  7. <body>
  8. <?php
  9. $servername = "localhost";
  10. $username = "stud";
  11. $password = "stud";
  12. $dbname = "ramunasziginskas";
  13. $today = date("Y-m-d H:i:s");
  14. $ip = $_SERVER["REMOTE_ADDR"];
  15.  
  16. //$ip = ip2long($ip);
  17. // Create connection
  18. $conn = mysqli_connect($servername, $username, $password, $dbname);
  19. // Check connection
  20. if (!$conn){
  21. die("Nepavyko prisijungti: " . mysqli_connect_error());
  22. }
  23. ?>
  24. <div class="container" style="width:40%">
  25.  <form method="post"  action=" ">
  26.     <?php
  27. if(isset($_POST['submit']))
  28. {
  29.   // Enter the Code you want to execute after the form has been submitted
  30. $vardas = mysqli_real_escape_string($conn, $_POST['vardas']);
  31. $epastas = mysqli_real_escape_string($conn, $_POST['epastas']);
  32. $zinute = mysqli_real_escape_string($conn, $_POST['zinute']);
  33. $oras = mysqli_real_escape_string($conn, $_POST['oras']);
  34.  
  35. $sql = "INSERT INTO ramunasziginskas (data, ip, vardas, epastas, zinute, oras)
  36. VALUES ('$today', '$ip' , '$vardas', '$epastas', '$zinute', '$oras')";
  37.  
  38. if (mysqli_query($conn, $sql)) {
  39. //echo "Sėkmingai išsaugota!<br>";
  40.  
  41. } else {
  42.  echo "Klaida: " . $sql . "<br>" . mysqli_error($conn);
  43. }
  44.     ?> <div  style="background-color:#ccc; text-align:center;"> <?php
  45.     echo "<b>" . $vardas . " </b> | " . $epastas . " | " . $today . " (" . $ip . ") | " . $zinute . " | ". $oras ."</div>";
  46.   // Dispaly Success or failure Message if any
  47. }
  48. else              
  49. {
  50.   echo $vardas;
  51.     // Display the Form and the Submit Button
  52. }
  53.  
  54. mysqli_close($conn);
  55. ?>
  56. <div class="form-group col-lg-6">
  57. <label for="vardas" class="control-label">Vardas:</label>
  58. <input name="vardas" id="vardas" type="text" class="form-control input-sm" required="true">
  59. </div>
  60. <div class="form-group col-lg-6">
  61. <label for="epastas" class="control-label">El. paštas:</label>
  62. <input name="epastas" id="epastas" type="email" class="form-control input-sm" required="true">
  63. </div>
  64. <div class="form-group col-lg-12">
  65. <label for="oras" class="control-label">Oras:</label>
  66. <input name="oras" id="oras" type="text" class="form-control input-sm" required="true">
  67. </div>
  68. <div class="form-group col-lg-12">
  69. <label for="zinute" class="control-label">Tekstas:</label>
  70. <textarea name="zinute" class="form-control input-sm" required="true" ></textarea>
  71. </div>
  72. <div class="form-group">
  73. <input type="submit" name="submit" value="siusti" class="btn btn-default">
  74. </div>
  75. </form>
  76. </div>
  77.  
  78. </body>
  79. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement