Unable to execute mysql query correctly

Question

New to coding . tried to create a database that stores details for an advertisement . the php works fine till the end . but the output always shows not inserted . could someone please help me out ?? the form and php are given here .

<html>
<body>

<form action="basic.php" method="post">

Name: <input type="text" name="adtitle"></input><br>
Name: <input type="text" name="sellersname"></input><br>
Name: <input type="text" name="email"></input><br>
Name: <input type="text" name="description"></input><br>
Name: <input type="text" name="noo"></input><br>
Name: <input type="text" name="base"></input><br>
Name: <input type="text" name="cutoff"></input><br>

<input type="submit"></input>
</form>

</body>
</html>

<?php
$serverName = "127.0.0.1";
$userName = "root";
$password = "";
$database = "demo";

$con = mysqli_connect($serverName, $userName, $password, $database);
if(!$con)
{echo 'not connected';}
if(!mysqli_select_db($con,'demo'))
{echo'db not selected';
}


$Title = $_POST['adtitle'];
$Sname= $_POST['sellersname'];
$email = $_POST['email'];
$Description = $_POST['description'];
$Mobileno = $_POST['noo'];
$Base = $_POST['base'];
$Cutoff = $_POST['cutoff'];

$sql = "INSERT INTO advert (Title,Seller name,email,Description,Number,Base,Cutoff)VALUES('$Title','$Sname','$email','$Description','$Mobileno','$Base','$Cutoff')";
if(!mysqli_query($con,$sql))
{echo'not inserted';}
else {echo'innserted';}

?>

Instead of echo'not inserted'; check for errors, php.net/manual/en/mysqli.error.php. You also are open to SQL injections with this code which code be the cause of your current issue. — chris85
– chris85, Commented May 24, 2016 at 19:47

chris85 · Accepted Answer · 2016-05-24 19:53:39Z

2

You have a field, seller name, which has a whitespace in it.

You must quote it in backticks:

Change it from:

"INSERT INTO advert (Title,Seller name,email,Description,Number,Base,Cutoff) VALUES ('$Title','$Sname','$email','$Description','$Mobileno','$Base','$Cutoff')"

to:

"INSERT INTO advert (Title,`Seller name`,email,Description,Number,Base,Cutoff)VALUES('$Title','$Sname','$email','$Description','$Mobileno','$Base','$Cutoff')"

edited May 24, 2016 at 19:53

chris85

23.9k7 gold badges37 silver badges51 bronze badges

answered May 24, 2016 at 19:50

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to execute mysql query correctly

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related