Guest User

Untitled

a guest
Oct 22nd, 2018
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <body>
  4. <?php
  5. $servername="localhost";
  6. $username="root";
  7. $password="";
  8. $dbname="student99";
  9. $conn=new mysqli($servername,$username,$password,$dbname);
  10. if($conn->connect_error)
  11. {
  12. die("connection failed:".$conn->connection_error);
  13. }
  14. echo "Connection Successful";
  15. /*$sql="CREATE TABLE Stu_Details(ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, NAME VARCHAR(50) NOT NULL)";
  16. if($conn->query($sql)==true)
  17. {
  18. echo "<br><br>DONE";
  19. }
  20. else
  21. {
  22. echo "<br><br>ERROR".$conn->error;
  23. }*/
  24. $sql="INSERT INTO Stu_Details VALUES(1,'HARSH VARDHAN');";
  25. /*$conn->query($sql);
  26. echo "Record Inserted";
  27. else
  28. {
  29. echo "<br><br>ERROR".$conn->error;
  30. }*/
  31. $sql.="INSERT INTO Stu_Details VALUES(2,'CHINMAY JAIN')";
  32. $conn->multi_query($sql);
  33. if($conn->multi_query($sql)==true)
  34. echo "Record Inserted";
  35. else
  36. {
  37. echo "<br><br>ERROR".$conn->error;
  38. }
  39. $conn->close();
  40. ?>
  41. </body>
  42. </html>
Add Comment
Please, Sign In to add comment