Getting error in exexuting sql query

Asked Jul 22 '18 at 16:29

Active Jul 22 '18 at 16:49

Viewed 18 times

My sql query is 

$stmt = $db->prepare('INSERT INTO blog_members (bio) 
                        VALUES (:bio) 
                      WHERE username='.$_SESSION['username'].'') ;
$stmt->execute(array(':bio'=> $bio));
?>                                        
 <input type="text" name="bio" id="bio" class="form-control input-lg" placeholder="Your Name" value="<?php if(isset($error)){ echo htmlspecialchars($_POST['bio'], ENT_QUOTES); } ?>" tabindex="1">

    <p><input type='submit' name='submit' value='Submit'></p>
</form>

and the error is

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE username=ashua4' at line 1' in C:\xampp\htdocs\gauravblog\user\update-profile.php:147 Stack trace: #0 C:\xampp\htdocs\gauravblog\user\update-profile.php(147): PDO->prepare('INSERT INTO blo...') #1 {main} thrown in C:\xampp\htdocs\gauravblog\user\update-profile.php on line 147

edited Jul 22 '18 at 16:49

RiggsFolly

93,638
21
103
149

asked Jul 22 '18 at 16:29

Gaurav Awasthi

3

Your SQL query doesn't make any sense. You cannot use WHERE clause in the INSERT INTO ... VALUES() type of query. – Karol Samborski Jul 22 '18 at 16:32
Then how we insert in specific columns of database – Gaurav Awasthi Jul 22 '18 at 16:34
You are inserting the column called `bio` an INSERT makes a new row. Are you trying to UPDATE and existing row?? – RiggsFolly Jul 22 '18 at 16:36
`INSERT INTO table_name (columns list) VALUES (column values)` – Karol Samborski Jul 22 '18 at 16:36
I want to update existing row – Gaurav Awasthi Jul 22 '18 at 16:37
I have a user table where I want to insert bio of specific user – Gaurav Awasthi Jul 22 '18 at 16:38
1

Then the command is UPDATE and not INSERT – RiggsFolly Jul 22 '18 at 16:48

Getting error in exexuting sql query

0 Answers0