dubey

<?php
$host = 'localhost:3306';
$user = 'root';
$pass = ' ';
$conn=mysqli_connect($host,$user,$pass);
if (!conn)
{
	die ('could not connect: ' . mysqli_connect_error());
}
echo 'connected sucessful<br/>';

$sql ='INSERT INTO EMP(id,name,emp_salary) VALUES (4,"Aditi", 20000)';
if(mysqli_query($conn, $sql))
{
	echo "Record inserted sucessfully";
}
else
{
	echo "Could not inserted record: ". mysqli_error($conn);
}
mysqli_close($conn);
?>








creation
<?php
$host = 'localhost:3306';
$user = 'root';
$pass = ' ';
$conn=mysqli_connect($host,$user,$pass);
if (!conn)
{
	die ('could not connect: ' . mysqli_connect_error());
}
echo 'connected sucessful<br/>';

$sql = 'CREATE Database MYBD';
if(mysqli_query( $conn,$sql)){
	echo "Database MYBD created successfully.";
}
else
{
	echo "Sorry, database creation failed".mysqli_error($conn);
}
mysqli_close($conn);
?>
-*