具有COUNT（URL）查询的多个变量

Question

The query below worked when it contained just one variable ($MyURL). But when I added $MySection, I started getting this error message:

PDOStatement::bindParam() expects parameter 3 to be long, string given in...

I know how to add multiple values in a query that fetches an array, but this kind of query is confusing for me. What am I doing wrong?

$sql= "SELECT COUNT(URL) AS num FROM pox_topics 
WHERE URL = :MyURL AND Site = 'PX' AND Section = ':MySection' AND Live != 0";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':MyURL',$MyURL,':MySection',$MySection,PDO::PARAM_STR);
$stmt->execute();
$Total = $stmt->fetch();

EDIT:

I've tried the following query with PDO::PARAM_STR following $MyURL, $MySection and following both of them...

$sql= "SELECT COUNT(URL) AS num FROM pox_topics 
WHERE URL = :MyURL AND Site = 'PX' AND Section = :MySection AND Live != 0";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':MyURL',$MyURL,PDO::PARAM_STR);
$stmt->bindParam(':MySection',$MySection);
$stmt->execute();
$Total = $stmt->fetch();

But I'm getting this error message: "Invalid parameter number: number of bound variables does not match number of tokens"

Answer 1

You have quotes around your 2nd bind ':MySection' in AND Section = ':MySection', those need to be removed.

Then you're using both of your binds in the same bindParam. They need to be on separate statements.

$sql= "SELECT COUNT(URL) AS num FROM pox_topics 
WHERE URL = :MyURL AND Site = 'PX' AND Section = :MySection AND Live != 0";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':MyURL',$MyURL);
$stmt->bindParam(':MySection',$MySection,PDO::PARAM_STR);
$stmt->execute();
$Total = $stmt->fetch();

Sidenote: Unsure which one you want to use PDO::PARAM_STR for. Adjust respectively.

Also make sure those variables have values. Error reporting will throw you something about it, should they fail.

Example from the manual http://php.net/manual/en/pdostatement.bindparam.php

$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
    FROM fruit
    WHERE calories < :calories AND colour = :colour');
$sth->bindParam(':calories', $calories, PDO::PARAM_INT);
$sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);
$sth->execute();

---

Add error reporting to the top of your file(s) which will help find errors.

<?php 
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Then the rest of your code

Sidenote: Displaying errors should only be done in staging, and never production.

Also use PDO's error handling:

• http://php.net/manual/en/pdo.error-handling.php