Question 7950 in PHP Versions Question posted in
You can find a list of all versions here.

You have an error in my request but which? – PHP Versions

The request of my function has a problem:

function rdvDelete($rdv)
{
    $pdo = connexion();
    $sql = $pdo->prepare("DELETE FROM visitors,rdvs WHERE rdvs.idRdv = :rdv AND visitors.idVisitor = rdvs.idVisitor"); <-- line 34
    $sql->execute(['rdv' => $rdv]);
}

$rdv = 3 !!!

And this display this error

[error] 639#639: *9791 FastCGI sent in stderr: "PHP message: PHP 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 ‘WHERE rdvs.idRdv = ? AND visitors.idVisitor =
rdvs.idVisitor’ at line 1 in
/var/www/MY-WEBSITE/model/m_manage-rdvs.php:34

Thanks

Tags:

3

Answers


  1. Chosen as BEST ANSWER
    0

    I solved my problem with this query :

    DELETE visitors, rdvs FROM visitors INNER JOIN rdvs ON visitors.idVisitor = rdvs.idVisitor WHERE rdvs.idRdv = :rdv

  2. 0

    I believe your prepared statement has an error. You need to specify both parameters in the statement before executing with the actual values of the parameters. Do this

    function rdvDelete($rdv)
{

    $pdo = connexion();
    $sql = $pdo->prepare("DELETE FROM visitors,rdvs WHERE rdvs.idRdv = :rdv AND visitors.idVisitor = :rdvs); <-- line 34
    $sql->execute(['rdv' => $rdv, 'rdvs' = $rdvs]);
}
    Login or Signup to reply.
  3. 0

    SQLite does not support explicit or implicit joins in DELETE statements. You are attempting the implicit join with comma separated tables in FROM clause and join condition in WHERE. For correlated delete statements, consider using IN or EXISTS operators on a subquery:

    DELETE FROM visitors
WHERE idVisitor IN (
    SELECT rdvs.idVisitor
    FROM rdvs
    WHERE rdvs.idRdv = :rdv
)

    DELETE FROM visitors
WHERE EXISTS (
    SELECT 1
    FROM rdvs
    WHERE rdvs.idVisitor = visitors.idVisitor
      AND rdvs.idRdv = :rdv
)
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search