PHP PDO mutiple select, multiple conditions

Question

How can i fill my array with PDO statement which have multiple conditions?

$stmt = $conn->prepare("SELECT * 
                        FROM the_table 
                        WHERE stmt1 = '$value1' 
                          AND stmt2 = '$value2' 
                        ORDER BY sent_date");
$stmt->execute();
$row = $stmt->fetchAll();

So, this works, but I need the of the table data from my table, because I going to get only the first statement values. What I mean? If my first value (like $value1) is out the selecting change to the second statement's value (like $value2). And i will get all of my table data where exists $value1 and $value2 I need the values an array like $row

Sorry for this composition :D. Thanks in advance.

This is not how you use prepared statements.. I also don't know what your question is. — chris85
– chris85, Commented Dec 16, 2016 at 20:49
Welcome to SO. Please read What topics can I ask about and How to ask a good question And the perfect question And how to create a Minimal, Complete and Verifiable example — RiggsFolly
– RiggsFolly, Commented Dec 16, 2016 at 20:53
How can I fill my array with 2 conditions. This is the question. — Chraze
– Chraze, Commented Dec 16, 2016 at 21:06
What does this query give you? I don't understand 1. I need the of the table data from my table 2. If my first value (like $value1) is out the selecting change to the second statement's value (like $value2). 3. I need the values an array like $row. — chris85
– chris85, Commented Dec 16, 2016 at 21:10

Amin NAIRI · Accepted Answer · 2016-12-16 21:10:01Z

1

Basically, you would prepare your query like that

<?php

/* insert code for database connexion here */

$value1 = 'something';
$value2 = 'whatever';

/* The query itself */
$query = $connexion->prepare('SELECT * FROM the_table WHERE stmt1 = :first AND stmt2 = :second ORDER BY sent_date');

/* Now we add the wanted values to our query */
$query->execute([
    'first' => $value1,
    'second' => $value2
]);

$result = $query->fetchAll();

Do not forget to check if the result is what your expected.

answered Dec 16, 2016 at 21:10

Amin NAIRI

2,52423 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP PDO mutiple select, multiple conditions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related