Advertisement
Hydrase

Books Table

Jun 7th, 2025 (edited)
18
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. <html>
  2. <?php
  3. //CONNECTION
  4. $dbhost="localhost";
  5. $dbuser="root";
  6. $dbpass="";
  7. $conn=mysqli_connect($dbhost,$dbuser,$dbpass);
  8. if($conn->connect_error)
  9. {
  10. die("<br>Connection failed: ".$conn->connect_error);
  11. }
  12. else
  13. {
  14. echo"<br>Connection successfull!";
  15. }
  16. //CREATING DATABASE
  17. $q1="CREATE DATABASE BOOKS";
  18. if($conn->query($q1)===TRUE)
  19. {
  20. echo"<br>Database BOOKS created!";
  21. }
  22. else
  23. {
  24. echo"<br>Error creating database: ".$conn->error;
  25. }
  26. //CONNECTING TO DATABASE BOOKS
  27. $dbhost="localhost";
  28. $dbuser="root";
  29. $dbpass="";
  30. $db="BOOKS";
  31. $conn=mysqli_connect($dbhost,$dbuser,$dbpass,$db);
  32. if($conn->connect_error)
  33. {
  34. die("<br>Connection failed: ".$conn->connect_error);
  35. }
  36. else
  37. {
  38. echo"<br>Connection to database ".$db." successfull!";
  39. }
  40. //CREATING TABLE
  41. $q2="CREATE TABLE BOOK_DETAILS(BOOKID INT(3) PRIMARY KEY NOT NULL,AUTHOR VARCHAR(20) NOT NULL,TITLE VARCHAR(30) NOT NULL)";
  42. if($conn->query($q2)===TRUE)
  43. {
  44. echo"<br>Table BOOK_DETAILS created successfully!";
  45. }
  46. else
  47. {
  48. echo"<br>Error creating table: ".$conn->error;
  49. }
  50.  
  51. //INSERTING MULTIPLE QUERIES
  52. $sql="INSERT INTO BOOK_DETAILS(BOOKID,AUTHOR,TITLE) VALUES(200,'H.G.Wells','Invisible Man');";
  53. $sql.="INSERT INTO BOOK_DETAILS(BOOKID,AUTHOR,TITLE) VALUES(257,'Jonathan Swift','Gullivers Travel');";
  54. $sql.="INSERT INTO BOOK_DETAILS(BOOKID,AUTHOR,TITLE) VALUES(258,'Jules Verne','Around the World in 80 days');";
  55. $sql.="INSERT INTO BOOK_DETAILS(BOOKID,AUTHOR,TITLE) VALUES(279,'Khushwant Singh','A History of Sikhs');";
  56. $sql.="INSERT INTO BOOK_DETAILS(BOOKID,AUTHOR,TITLE) VALUES(186,'G.G.Shaw','Man and Superman');";
  57. if($conn->multi_query($sql)===TRUE)
  58. {
  59. echo"<br>New records created successfully!";
  60. }
  61. else
  62. {
  63. echo"<br>Error: ".$sql."<br>".$conn->error;
  64. }
  65. $conn->close();
  66. ?>
  67. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement