What is the correct syntax to for and SQL update in php?

Question

I am trying to update an entry in the database using html and php. However, I keep getting an error saying my sql syntax is wrong.

Here is the code from the php file:

<?php 
$server = "127.0.0.1";
$dbUsername = "root";
$dbPassword = "";
//create connection
$dbconn = new mysqli($server, $dbUsername, $dbPassword, $dbname);

 $email_follow = $_POST['email_follow'];
 $follow = $_POST['follow'];

 $update = mysqli_query($dbconn, "UPDATE CustomerDetails SET Follow Up = '$follow' WHERE Email = '$email_follow'");

if ($dbconn->query($update) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $dbconn->error;
}
 ?>

Here is the html form:

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

Email:
<input type="email" name="email_follow" id="email_follow">

Enter Follow Up Details:
<input type="text" name="follow" id="follow">


<input type="submit" value="Update">

</form>

Any help is appreciated. Thank you!

Possible duplicate of [When to use single quotes, double quotes, and back ticks in MySQL](https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-back-ticks-in-mysql) — Qirel, Jun 25 '18 at 04:26

flyingfox · Accepted Answer · 2018-06-25T04:38:48.307

2

You table property Follow Up has a space,you need to add ` to wrap it

So change

UPDATE CustomerDetails SET Follow Up = '$follow' WHERE Email = '$email_follow'

to

UPDATE CustomerDetails SET `Follow Up` = '$follow' WHERE Email = '$email_follow'

edited Jun 25 '18 at 04:38

answered Jun 25 '18 at 04:06

flyingfox

13,414
3
24
39

do I use a back tick or just single quotes? – zaveriraj2 Jun 25 '18 at 04:13
This answer is incorrect, as it is using single quotes, when you have to use backticks. – Qirel Jun 25 '18 at 04:25
@zaveriraj2 updated my answer,you need to use backticks – flyingfox Jun 25 '18 at 04:39

munsifali · Answer 2 · 2018-06-25T04:25:34.317

0

Need to use dot operator and need to use tick instead of single quote

Tick - Follow Up - Correct.

$query = "UPDATE CustomerDetails
    SET `Follow Up` = '".$follow."'
    WHERE Email = '".$email_follow."'";

$update = mysqli_query($dbconn, $query);

edited Jun 25 '18 at 04:25

answered Jun 25 '18 at 04:05

munsifali

1,732
2
24
43

Down voter don't forget to write comment when you down vote any ans. – munsifali Jun 25 '18 at 04:08
it doesn't recognize the WHERE keyword when I try this. – zaveriraj2 Jun 25 '18 at 04:09
`Follow Up` will still give an error. The answer that @lucumt provided is correct. – Dave Jun 25 '18 at 04:10
@dave are u sure lucumt query produce correct result ? – munsifali Jun 25 '18 at 04:12
@zaveriraj2 you should define "doesn't recognize" or comment actual error i will easier for us to solve the issue. – munsifali Jun 25 '18 at 04:16
You don't have to concat it with "the dot operator", it's not needed. – Qirel Jun 25 '18 at 04:27

shubhangee · Answer 3 · 2018-06-25T06:42:40.547

0

Give a try with below code

UPDATE CustomerDetails SET `Follow Up` = '".$follow."' WHERE Email = '".$email_follow."'

edited Jun 25 '18 at 06:42

answered Jun 25 '18 at 06:29

shubhangee

529
3
10

What is the correct syntax to for and SQL update in php?

3 Answers3