How to bind param an array and a value in a query

Question

I have an array of n elements and I want to bind it with the value of $genre. This is what I've tried: $genre = $_GET['a_gen'] ?? ''; The $genre is from a previous query and it is a string. $aTitle is also an array of strings.

<?php
                    if (isset($_POST['submit-search'])) {
                        $stmt = $conn -> prepare("SELECT a_titlu, a_autor, a_text, a_data, a_imagine, a_gen FROM articol WHERE a_titlu LIKE ? OR a_text LIKE ? 
                            OR a_autor LIKE ? OR a_data LIKE ?");
                        $search ='%'.$_POST['search'].'%';
                        $stmt -> bind_param('ssss', $search, $search, $search, $search);
                        $stmt -> execute();
                        $stmt -> store_result();
                        $stmt -> bind_result($a_titlu, $a_autor, $a_text, $a_data, $a_imagine, $a_gen);
                        $stmt -> get_result();
                        $count = $stmt -> num_rows();
                        $genre = $_GET['a_gen'] ?? '';
                        $aTitle = array();
                        if ($count > 0) {
                            if($count == 1)
                                echo "<h5 class='text-center toateArt'>Am găsit ".$count." rezultat!</h5>";
                            else
                                echo "<h5 class='text-center toateArt'>Am găsit ".$count." rezultate!</h5>";
                            while ($stmt -> fetch()) {
                                array_push($aTitle, $a_titlu);
                                echo "<div class='card'>
                                        <img src=".$a_imagine." class='imgRes' />
                                        <h3 class='articleTitle'>".$a_titlu."</h3>
                                        <h6 class='articleDT'><i class='fa fa-calendar'></i>".$a_data."&nbsp<i class='fa fa-user'></i>".$a_autor."</h6>
                                        <p class='articleDescription' style='text-align: justify;'>".$a_text."</p>
                                        <div class='button_cont' align='right'>
                                            <a class='buttonA' style='text-decoration: none;' href='article.php?title=".$a_titlu."&date=".$a_data."'>Citește</a>
                                        </div>
                                    </div>
                                <br>";
                            }
                        }
                    }
                ?>
                <?php
                    $in = str_repeat('?,', count($aTitle) - 1) . '?';
                    $aTitle[] = $genre;
                    $stmt = $conn -> prepare("SELECT  a_titlu, a_data, a_gen FROM articol WHERE a_titlu NOT IN ($in) AND a_gen = ?");
                    $types = str_repeat('s', count($aTitle));
                    $stmt -> bind_param($types, ...$aTitle);
                    $stmt -> execute();
                    $stmt -> store_result();
                    $stmt -> bind_result($a_titlu, $a_data, $a_gen);
                    $stmt -> get_result();
                    $count = $stmt -> num_rows();

                        while ($stmt -> fetch()) {
                            echo "<div class='card'><p>".$a_titlu."</p><p>".$a_data."</p><p>".$a_gen."</p></div><br>";
                        }
                ?>

you need a type for genre too

Your Common Sense
– Your Common Sense

2020-04-27 18:38:16 +00:00
Commented Apr 27, 2020 at 18:38 — Your Common Sense
– Your Common Sense, Commented Apr 27, 2020 at 18:38
$genre is from a previous query and it is a string

Bogdan Paul
– Bogdan Paul

2020-04-27 18:40:33 +00:00
Commented Apr 27, 2020 at 18:40 — Bogdan Paul
– Bogdan Paul, Commented Apr 27, 2020 at 18:40
sigh*. $types . = 's';

Your Common Sense
– Your Common Sense

2020-04-27 18:42:14 +00:00
Commented Apr 27, 2020 at 18:42 — Your Common Sense
– Your Common Sense, Commented Apr 27, 2020 at 18:42
What is this $aGenre = ('s' $genre)?

Dharman
– Dharman ♦

2020-04-27 18:48:58 +00:00
Commented Apr 27, 2020 at 18:48 — Dharman
– Dharman ♦, Commented Apr 27, 2020 at 18:48

Nigel Ren · Accepted Answer · 2020-04-27 18:48:10Z

1

As you can't put in an additional parameter after using the argument unpacking on $aTitle, so the easiest way would be to add this into the array at the end.

$in = str_repeat('?,', count($aTitle) - 1) . '?';
// Now add in value
$aTitle[] = $genre;
$stmt = $conn -> prepare("SELECT  a_titlu, a_data, a_gen 
                          FROM articol 
                          WHERE a_titlu NOT IN ($in) AND a_gen = ?");
$types = str_repeat('s', count($aTitle));
$stmt -> bind_param($types, ...$aTitle);

answered Apr 27, 2020 at 18:48

Nigel Ren

57.2k11 gold badges49 silver badges59 bronze badges

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

3 Comments

Bogdan Paul Over a year ago

I've checked and it doesn't add the $genre at the final of the array

Nigel Ren Over a year ago

Try checking $aTitle before the $aTitle[] = $genre; and after.

Bogdan Paul Over a year ago

It works now! It seems that the $_GET['a_gen'] was empty and that's why it doesn't work. I've just added like this: $genre = $a_gen; thanks!

Collectives™ on Stack Overflow

How to bind param an array and a value in a query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related