Advertisement
Guest User

new crud

a guest
Nov 15th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. <?php
  2. // to make a connection with database
  3. $link = mysql_connect("localhost", "root") or die(mysql_error());
  4.  
  5. // to select the targeted database
  6. mysql_select_db("mydb", $link) or die(mysql_error());
  7.  
  8. $name = $_POST["name"];
  9. $age = $_POST["age"];
  10. $gender = $_POST["gender"];
  11.  
  12. $arrtitle = $_POST["title"];
  13. $title = implode(" ",$arrtitle);
  14.  
  15.  
  16. $arrhobby = $_POST["hobby"];
  17. $hobby = implode(" ",$arrhobby);
  18.  
  19.  
  20. $comment = $_POST["comment"];
  21.  
  22. // to create a query to be executed in sql
  23. $query = "insert into users values('$name','$age','$gender','$title','$hobby','$comment')"
  24. or die(mysql_error());
  25.  
  26.  
  27.  
  28. // to run sql query in database
  29. $result = mysql_query($query);
  30.  
  31. //Check whether the insert was successful or not
  32. if($result)
  33. {
  34.  
  35. echo("Data insert");
  36.  
  37. }
  38. else
  39. {
  40.  
  41. die("Insert failed");
  42. }
  43.  
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement