Advertisement
Hydrase

Table Employee creation

Jun 7th, 2025
19
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. <html>
  2. <body>
  3. <?php
  4. $conn=mysqli_connect("localhost","root","","COLLEGE");
  5. if($conn->connect_error){
  6. die("Connection failed".$conn->connect_error);
  7. }
  8. echo"connection successful";
  9. $sql="CREATE TABLE EMP(EMPNO INT NOT NULL PRIMARY KEY,ENAME
  10. VARCHAR(30),MOBILE INT,DOB DATE)";
  11. if($conn->multi_query($sql)===TRUE){
  12. echo"<br>Operations successful";
  13. }
  14. else{
  15. echo"<br>Operations unsuccessful";
  16. }
  17. $conn->close();
  18. ?>
  19. </body>
  20. </html>
  21.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement