Guest User

Untitled

a guest
Jul 10th, 2016
32
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. <?php
  2. $servername="ip.arpitsingla.me";
  3. $username="bhaskar";
  4. $password="bhaskarMachau";
  5. $dbname="sura2016";
  6.  
  7. $mobile="";
  8. $errmobile="";
  9. if ($_SERVER["REQUEST_METHOD"] == "POST")
  10. {
  11. if (!empty($_POST["mobile"]))
  12. {
  13. $mobile=$_POST["mobile"];
  14.  
  15. }
  16. else
  17. {
  18. $errmobile="Please fill";
  19. }
  20. }
  21.  
  22.  
  23. $conn = new mysqli($servername, $username, $password, $dbname);
  24. if ($conn->connect_error)
  25. {
  26. die("Connection failed: " . $conn->connect_error);
  27. }
  28.  
  29. $sql1="DELETE From Mobile";
  30. if ($conn->query($sql1) === TRUE)
  31. {
  32.  
  33. }
  34. else
  35. {
  36.  
  37. }
  38.  
  39. $sql="INSERT INTO Mobile(number) Values ($mobile)";
  40.  
  41. if ($conn->query($sql) === TRUE)
  42. {
  43. echo $mobile;
  44. }
  45. else
  46. {
  47. #echo "Error: " . $sql . "<br>" . $conn->error;
  48. }
  49. ?>
  50. <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="POST">
  51. Enter your Mobile Number : &nbsp
  52. <input type="text" name="mobile" style="height:20px;width=100px;"></input>
  53. <br><br>
  54. <input type="submit" value="Submit">
Add Comment
Please, Sign In to add comment