NextIndexPrevious

Programs in PHP

19. Program to Insert records into the table in Database.
<?php

$conn = mysqli_connect('servername','username','password','databasename');

if(!$conn)
{
	die('Connection failed!'.mysqli_error($conn));
}

$sql = "INSERT INTO tablename('sno','name','pwd') VALUES('101','Surya','surya123')";
 	
if(mysqli_query($conn,$sql))
{
	echo "Record Inserted";
}
else
{
	echo mysql_error();
}

?>

-------------------------------------------------------------
Note: When we using XAMPP or WAMP,
servername = localhost, username = root, password is empty.

Father of PHP

Rasmus Lerdorf

Rasmus Lerdorf

Born: November 22, 1968, Greenland
Google+