Html Form To Input Data Into Mysql Database
Im trying to get my html form once submitted, then the data gets saved into a mysql database. However once i click the submit button it just takes me to my php code shown in my br
Solution 1:
You can use this code.. Dont use mysql and mysqli combinations.
<div id="contact_form">
<form action="contact_insert.php" method="post">
Firstname: <input type="text" name="firstname">
Lastname: <input type="text" name="surname">
Email: <input type="text" name="email">
<input type="submit" name="submit">
</form>
</div>
<?php
if(isset($_POST['submit']))
{
$username="root";
$password="password";
$server="127.0.0.1";
$database="eddiesdb";
$con = mysql_connect($server,$username,$password);
$sql="INSERT INTO customer (FirstName, Surname, EmailAddress)
VALUES
('$_POST[firstname]','$_POST[surname]','$_POST[email]')";
$a=mysql_query($sql);
if (!$a)
{
echo mysql_error();
}
else
{
echo "1 record added";
}
mysql_close($con);
}
?>
Solution 2:
Make sure your file has .php
extension.
Make sure you have put your PHP code in <?php ... ?>
tags.
Solution 3:
Your script:
$con = mysql_connect($server,$username,$password);
// Check connection
if (mysql_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="INSERT INTO customer (FirstName, Surname, EmailAddress)
VALUES
('$_POST[firstname]','$_POST[surname]','$_POST[email]')";
if (!mysqli_query($con,$sql))
{
die('Error: ' . mysqli_error($con));
}
echo "1 record added";
mysqli_close($con);
You wrote if (!mysqli_query($con,$sql))
but in $con
, you're using mysql_connect
, not mysqli_connect
,
So, it'll be:
if (!mysql_query($con,$sql)) {
die('Error: ' . mysql_error($con));
}
echo "1 record added";
mysql_close($con);
Solution 4:
You created object of MySql like this
$con = mysql_connect($server,$username,$password);
and you use mysqli_qurey at below like
if (!mysqli_query($con,$sql))
How it possible??
Solution 5:
your password to local database must be empty and you should keep both the files in htdocs on xammp (form.html and contact_insert.php) in the same folder.
Post a Comment for "Html Form To Input Data Into Mysql Database"