CREATE TABLE STUDENT

Hydrase

Mar 4th, 2025

45

0

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

text 0.60 KB | None | 0 0

raw download clone embed print report

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?php
$conn=mysqli_connect("localhost","root","","COLLEGE");
if($conn->connect_error)
{
die("Connection Failed".$conn->connect_error);
}
echo "Connected successfully<br>";
$sql="CREATE TABLE STUDENT(SID INT NOT NULL PRIMARY KEY,NAME VARCHAR(30) NOT NULL,EMAIL VARCHAR(30),FEES INT,DOB DATE)";
if($conn->query($sql)===TRUE)
{
echo"Table STUDENT created successfully";
}
else
{
echo"Error Creating Table STUDENT:".$conn->error;
}
$conn->close();
?>
</body>
</html>

Add Comment

Please, Sign In to add comment

Public Pastes