INSERT RECORDS INTO STUDENT TABLE

Hydrase

Mar 4th, 2025

Never

Add comment

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

text 0.95 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="INSERT INTO STUDENT VALUES(101,'JOSUKE','[email protected]',20000,'2003-07-23');";
$sql.="INSERT INTO STUDENT VALUES(102,'JOHNNY','[email protected]',20000,'1998-03-06');";
$sql.="INSERT INTO STUDENT VALUES(103,'JOTARO','[email protected]',250000,'2003-02-19');";
$sql.="INSERT INTO STUDENT VALUES(104,'JOLYNE','[email protected]',30000,'2003-07-23');";
$sql.="INSERT INTO STUDENT VALUES(105,'ARAKI','[email protected]',23000,'2003-07-23');";
if($conn->multi_query($sql)===TRUE)
{
echo"Record Inserted Successfully successfully";
}
else
{
echo"unablr to insert record into Table STUDENT:".$conn->error;
}
$conn->close();
?>
</body>
</html>

Add Comment

Please, Sign In to add comment