Database:
1) CREATE DATABASE EMPLOYEES;
2) USE EMPLOYEES;
3) CREATE table emp(id int PRIMARY KEY,name Varchar(20),Salary Integer);
Program:
Output:
1) CREATE DATABASE EMPLOYEES;
2) USE EMPLOYEES;
3) CREATE table emp(id int PRIMARY KEY,name Varchar(20),Salary Integer);
Program:
<?php
$host = "localhost";
$user = "root";
$pass = "1234";
$dbname = "employees";
$conn = mysqli_connect($host,$user,$pass,$dbname);
if(!$conn)
{
die('Could Not Connect:'.mysqli_errort());
}
echo "Connected Successfully: <br>";
$sql = "Insert into emp values(1,'Atharva',10000)";
if(mysqli_query($conn,$sql))
{
echo "Record Inserted Succefully";
}
else
{
echo "Could not insert record:".mysqli_error($conn);
}
mysqli_close($conn);
?>
Output:
