Level 55
@heropaulexy that's great! Check the line 64 on C:\xampp\htdocs\projects\product-crud\update.php
What do you expect from us without any piece of code?
Sep 21, 2022
7
Level 1
PHP ERROR
I have got a little challenge with my PHP it's throwing this error
Fatal error: Uncaught PDOException: 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 ')' at line 2 in C:\xampp\htdocs\projects\product-crud\update.php:64 Stack trace: #0 C:\xampp\htdocs\projects\product-crud\update.php(64): PDOStatement->execute() #1 {main} thrown in C:\xampp\htdocs\projects\product-crud\update.php on line 64
Level 102
Its an sql error, not php :)
Level 102
@heropaulexy you have an extra closing )
$query = $pdo->prepare("UPDATE products SET title = :title, description = :description, image = :image, price = :price WHERE id = :id");
Level 1
@Sinnbeck thanks alot. it worked
Level 1
this is the code. Line 64 is the last line
$query = $pdo->prepare("UPDATE products SET title = :title,
description = :description, image = :image, price = :price WHERE id = :id)");
$query->bindValue(':title', $title);
$query->bindValue(':description', $description);
$query->bindValue(':image', $imagePath);
$query->bindValue(':price', $price);
$query->bindValue(':id', $id);
$query->execute();
Level 75
It's Oxbir.
Level 102
@MichalOravec 😮 how do you know?
Please or to participate in this conversation.