Monday, November 14, 2011

Code to insert Data in MYSQL using PHP





$host="localhost"; // Host name
$db_username="root"; // Mysql username
$db_password=""; // Mysql password
$db_name="test"; // Database name
$user="user"; // Table names

mysql_connect("$host", "$db_username", "$db_password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");


$location=$_POST['location'];
$state=$_POST['txtHint'];
$quality=$_POST['ddlQuality'];
$subquality=$_POST['ddlSubQuality'];
$op=$_POST['txtOp'];
$vv=$_POST['txtVv'];
// Here $location is a variable and in $_POST['location'] location is input textbox name.

$insert="INSERT INTO user VALUES('$location', '$state','$quality','$subquality','$op','$vv')";
$result=mysql_query($insert);
you can use also this method  :

$insert="INSERT INTO user VALUES('$_POST['location']', '$_POST['txtHint']','$_POST['ddlQuality']','$_POST['ddlSubQuality']','$_POST['txtOp']','$_POST['txtVv']')";
$result=mysql_query($insert);

?>

No comments:

Post a Comment