Page 206 - PHP Novice to Ninja

PHP
1

Hello to everyone again.

I don’t understand this line:

$sql = 'DELETE FROM jokecategory WHERE categoryid = :id';

These the complete code:

    // Delete joke associations with this category
try
{
  $sql = 'DELETE FROM jokecategory WHERE categoryid = :id';
  $s = $pdo->prepare($sql);
  $s->bindValue(':id', $_POST['id']);
  $s->execute();
}
catch (PDOException $e)
{
  $error = 'Error removing jokes from category.';
  include 'error.html.php';
  exit();
}

Thank you

2

What exactly can’t you understand?
This line creates a variable containing SQL query for the database.
The query asks database to delete one row from jokecategory table

3

I don’t understand where the query take the id.

In the joke category table I have jokeid e categoryid…

4

Combining those two lines, are you still confused?

5

Yes, but :id is the id of the category table?

6

It’s the ID of the category, yes, as indicated by “categoryid” being the field name matched. The SQL is removing entries from the jokecategory table where the categoryid is whatever is specified.

7

Ok thank you.

8

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.