hi i am using the below code to insert records into mysql database
how can i send a simple command from corona sdk to post this info to
http://www.qurantour.com/form1.html
<!DOCTYPE html>
<html lang=“en”>
<head>
<meta charset=“UTF-8”>
<title>Add Record Form</title>
</head>
<body>
<form action=“insert.php” method=“post”>
<p>
<label for=“firstName”>First Name:</label>
<input type=“text” name=“firstname” id=“firstName”>
</p>
<p>
<label for=“lastName”>Last Name:</label>
<input type=“text” name=“lastname” id=“lastName”>
</p>
<p>
<label for=“emailAddress”>Email Address:</label>
<input type=“text” name=“email” id=“emailAddress”>
</p>
<input type=“submit” value=“Submit”>
</form>
</body>
</html>
<?php
// $servername = “qurantour.com.mysql”;
// $username = “qurantour_com_db_”;
// $password = “1234567”;
// $dbname = “qurantour_com_db_”;
$link = mysqli_connect(“qurantour.com.mysql”, “qurantour_com_db_”, “1234567”, “qurantour_com_db_”);
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$first_name = mysqli_real_escape_string($link, $_POST[‘firstname’]);
$last_name = mysqli_real_escape_string($link, $_POST[‘lastname’]);
$email_address = mysqli_real_escape_string($link, $_POST[‘email’]);
$sql = “INSERT INTO MyGuests (firstname, lastname, email) VALUES (’$first_name’, ‘$last_name’, ‘$email_address’)”;
if(mysqli_query($link, $sql)){
echo “Records added successfully.”;
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// close connection
mysqli_close($link);
?>