Grip Task - Data Science and Business Analytics Internship ! #grip #inte...

on
0

Data insert from PHP to MySQL Cloud Database

on



Data insert from PHP to MySQL Cloud Database:

    Database Structure:
image.png
 Coding:
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form method="post">
ID:
<input type="text" name="txteid">
<br>
NAME:
<input type="text" name="txtename">
<br>
SALARY:
<input type="text" name="txtesal">
<br>
<input type="submit" name="btn" value="SUBMIT">
</form>
<?php
if(isset($_POST["btn"]))
{
$con=mysqli_connect("bv5j6bkan8d05hcsgr5n-mysql.services.clever-cloud.com","uwaqwybztij3coyv","68XungoCdJIEiFbk1Cbb","bv5j6bkan8d05hcsgr5n");

// mysqli_connect(host,username,password,database name)
$eid=$_POST["txteid"];
$ename=$_POST["txtename"];
$esal=$_POST["txtesal"];
$q="insert into emp values('$eid','$ename','$esal')";
$r=mysqli_query($con,$q);

if($r)
{
echo "Data Added";
}
else
{
echo "Data not added";
}

mysqli_close($con);
}

?>

</body>
</html>

Source Video : Click Here
Useful Links:

Comments

Post a Comment