mysql query with php variable and "%"

Question

I have the following code:

if ($mysqli->connect_errno) {
    echo "Fallo al contenctar a MySQL: ("
         . $mysqli->connect_errno
         . ") "
         . $mysqli->connect_error;
}

$resultado = $mysqli->query('select title FROM 4d_topics 
                             where title Like "B%" and forum_id=174');

$row_cnt = $resultado->num_rows;
for ($i = 0; $i <= $row_cnt; $i++) {
    $resultado->data_seek($i);
    $row = $resultado->fetch_row();
    printf ($row[0]);
    echo '<br>';
}

And that works, but, how can i change "B" with a php variable (like... $letter) which contains a letter?

For example...

$resultado = $mysqli->query('select title FROM 4d_topics 
                             where title Like **"$Letter%"** and forum_id=174');

Are you asking about string concatenation? Try, $resultado = $mysqli->query('select title FROM 4d_topics where title Like %' . $Letter . '% and forum_id=174'); Kinda weird how you know how to echo the error message with brackets. Here's a good read. — Dave Chen
– Dave Chen, Commented Jul 13, 2015 at 1:05

Oscar Lidenbrock · Accepted Answer · 2015-07-13 01:12:39Z

1

You can use this code (puedes usar este código):

$letter = 'B';
$resultado = $mysqli->query('select title FROM 4d_topics where title Like "'.$letter.'%" and forum_id=174');

answered Jul 13, 2015 at 1:12

Oscar Lidenbrock

8165 silver badges9 bronze badges

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

Comments

Josua M C · Accepted Answer · 2015-07-13 01:55:48Z

0

Try this:

function searching_letter($value){
    return $mysqli->query('select title FROM 4d_topics 
                         where title Like '.$value.' and forum_id=174');
}

if ($mysqli->connect_errno) {
    echo "Fallo al contenctar a MySQL: ("
         . $mysqli->connect_errno
         . ") "
         . $mysqli->connect_error;
}

$value = 'B%';
$resultado = searching_letter($value);

$row_cnt = $resultado->num_rows;
for ($i = 0; $i <= $row_cnt; $i++) {
    $resultado->data_seek($i);
    $row = $resultado->fetch_row();
    printf ($row[0]);
    echo '<br>';
}

with this code you can change the like from the start %B or %B% or B%

edited Jul 13, 2015 at 1:55

answered Jul 13, 2015 at 1:41

Josua M C

3,1566 gold badges47 silver badges89 bronze badges

Collectives™ on Stack Overflow

mysql query with php variable and "%"

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related