PDO query with parameter

Question

I used mysql and now i want to update my code to PDO. I have a problem with query:

$stmt4 = $pdo->prepare("SELECT * FROM ore_lavoro WHERE dottore = :dottore AND disponibile = 'si' AND data = :data AND fine >= :fine AND inizio >= '1' AND inizio <= ".$start."");
$stmt4->execute(['dottore' => $dottore_disponibile,'data' => $data_final,'fine' => $end]); 
$count2 = $stmt4->rowCount();
print "There are " .  $count2 . " matching records.";
$data4 = $stmt4->fetchAll();

If i i make this query i have this message: "There are 0 matching records."

$stmt4 = $pdo->prepare("SELECT * FROM ore_lavoro WHERE dottore = :dottore AND disponibile = 'si' AND data = :data AND fine >= ".$end." AND inizio >= '1' AND inizio <= ".$start."");
$stmt4->execute(['dottore' => $dottore_disponibile,'data' => $data_final]); 
$count2 = $stmt4->rowCount();

If i make this, instead, i recived: "There are 1 matching records" that is the correct answer because in my db i have 1 row with this parameters. Why? What am I doing wrong This is my db: https://ibb.co/n6qNXMB

Obviously, there is nothing visibly wrong with this code, it's the same as in any tutorial. In order to ask a question regarding the data stored in your database, you must provide a [minimal working example](https://phpdelusions.net/pdo/mcve) that clearly demonstrates the problem — Your Common Sense, Nov 25 '20 at 11:05
Absolutely not. MCVE means a *working* example, i.e. you are posting a code that everyone can copy and paste and run. — Your Common Sense, Nov 25 '20 at 11:28
if `fine` is indeed has an **int** type, then both queries should work. — Your Common Sense, Nov 25 '20 at 12:34
Look, the only difference is that the second query is like `fine >= 2` and the first one is `fine >= '2'` with 2 being in quotes. but the fact is, Mysql doesn't see any difference, either '2' or 2 should work. You need to check it out again — Your Common Sense, Nov 25 '20 at 12:43
@YourCommonSense my "dottore" field is varchar, what i have to change to the code if a field is varchar or text? thanks — Alessandro Ceccon, Nov 26 '20 at 11:22
There are no problems with dottore field, as far as I can see — Your Common Sense, Nov 26 '20 at 11:23
But for the feature, if i have only varchar field, the pdo statement is similar? Thanks a lot — Alessandro Ceccon, Nov 26 '20 at 12:41
As I can see, the problem is in the `fine` column. Am I right? Did you resolve it? — Your Common Sense, Nov 26 '20 at 12:48
Not yet, in the night i recreated the database, and this afternoon i'll try again with the query, thanks — Alessandro Ceccon, Nov 26 '20 at 13:03

PDO query with parameter

0 Answers0