I'm studying programming. I have a php File in my XAMPP, this File is use to insert data to my database.
I want to use post method to call php File and execute sql string.
my PHP file:
<?php
$DB_HostName = "localhost"; // ten host
$DB_Name = "QM_TEST";
$DB_User = "root";
$DB_Pass = "";
$DB_Table = "Customer";
$name = $_GET[@"name"];
$address = $_GET[@"address"];
$con = mysql_connect($DB_HostName,$DB_User,$DB_Pass) or die(mysql_error());
mysql_select_db($DB_Name,$con) or die(mysql_error());
$sql = "insert into $DB_Table (name, address) values('$name','$address');";
$res = mysql_query($sql,$con) or die(mysql_error());
mysql_close($con);
if ($res) {
echo "success";
}else{
echo "faild";
}// end else
?>