Advertisement
Hydrase

INSERT RECORDS INTO STUDENT TABLE

Mar 4th, 2025
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. <!doctype html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <title>Untitled Document</title>
  6. </head>
  7. <body>
  8. <?php
  9. $conn=mysqli_connect("localhost","root","","COLLEGE");
  10. if($conn->connect_error)
  11. {
  12. die("Connection Failed".$conn->connect_error);
  13. }
  14. echo "Connected successfully<br>";
  15. $sql="INSERT INTO STUDENT VALUES(101,'JOSUKE','[email protected]',20000,'2003-07-23');";
  16. $sql.="INSERT INTO STUDENT VALUES(102,'JOHNNY','[email protected]',20000,'1998-03-06');";
  17. $sql.="INSERT INTO STUDENT VALUES(103,'JOTARO','[email protected]',250000,'2003-02-19');";
  18. $sql.="INSERT INTO STUDENT VALUES(104,'JOLYNE','[email protected]',30000,'2003-07-23');";
  19. $sql.="INSERT INTO STUDENT VALUES(105,'ARAKI','[email protected]',23000,'2003-07-23');";
  20. if($conn->multi_query($sql)===TRUE)
  21. {
  22. echo"Record Inserted Successfully successfully";
  23. }
  24. else
  25. {
  26. echo"unablr to insert record into Table STUDENT:".$conn->error;
  27. }
  28. $conn->close();
  29. ?>
  30. </body>
  31. </html>
  32.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement