Advertisement
Guest User

Untitled

a guest
Nov 30th, 2018
263
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2. $servername= "localhost";
  3. $username= "root";
  4. $password= "";
  5. $dbname= "lisan";
  6. $conn= new mysqli ($servername, $username, $password, $dbname);
  7. if( $conn->connect_error)
  8. {
  9. echo "wrong!";
  10. }
  11. else{
  12. echo "done!";
  13. }
  14. /*
  15. $sql= "create database lisan";
  16. if ($conn->query($sql) === TRUE)
  17. {
  18. echo "DONE";
  19. }
  20.  
  21. else{
  22. echo "wrong";
  23. }
  24. */
  25. /*
  26. $sql ="create table information (ID INT (100) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  27. FATHERNAME varchar (100) not null,
  28. MOTHERNAME varchar (100) not null)";
  29. if ($conn->query($sql) === TRUE)
  30. {
  31. echo "table success";
  32. }
  33. else {
  34. echo "wrong";
  35. }
  36. */
  37.  
  38. $sql = "INSERT INTO information (FATHERNAME, MOTHERNAME) VALUES ('Mostafa', 'Shilpi')";
  39.  
  40. if ($conn->query($sql) === TRUE)
  41. {
  42. echo " Data insert saucess!";
  43. }
  44. else{
  45. echo "Wrong ";
  46. }
  47.  
  48.  
  49. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement