Advertisement
Guest User

prabeshya

a guest
Feb 11th, 2018
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $dbname = "bit2018";
  6. //create connection
  7. $conn = mysqli_connect($servername,$username,$password,$dbname);
  8. //check connection
  9. if(!$conn)
  10. {
  11. die("connection failed: " . mysqli_connect_error());
  12. }
  13. //sql to create table
  14. $sql = "INSERT INTO student_3rd (std_fname, std_lname, std_roll, std_contact, std_address)
  15. VALUES ('Nishan', 'pokharel',21,'9842123421','Godawari')
  16. ";
  17. if (mysqli_query($conn, $sql))
  18. {
  19. echo "New record created successfully ";
  20. }
  21. else
  22. {
  23. echo"Error : " .$sql ."<br>" . mysqli_error($conn);
  24. }
  25. mysqli_close($conn);
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement