iteration of mysql query using for each in php

Question

For example the value of array is:

Array ( [0] => what [1] => is [2] => life [3] => )

This value is stored in a variable called $specialized

$string = "SELECT * FROM questions where";        
$intA = 0;
foreach ($specailized as $spec) {
    $string += " question like '%" + $spec +"'% ";  
    if ($intA > 1) { 
        $str += " and ";
    }
    $intA++;
}
print($string);

The result is always numbers. Like 001 if this possible? I want to get a string value stored in $string like this.

SELECT * FROM questions where question like '% what%' and question like '% is%' and question like '%life%'

Using `+`'s is a JS/C method of concatenation. In PHP, you're to use dots `.` — Funk Forty Niner, Feb 29 '20 at 15:11

Oto Shavadze · Answer 1 · 2020-02-29T15:55:38.387

1

I think you need this

$string = "SELECT * FROM questions where 1=1 ";        
$specailized = array("what","is","life");
foreach ($specailized as $spec) {
    $string .= " and question like '%" . $spec ."%' ";  
}

echo $string;

Also note, that if array values comes from user, then you should care about sql injections

edited Feb 29 '20 at 15:55

answered Feb 29 '20 at 15:13

Oto Shavadze

40,603
55
152
236

yup it is not working when i user $string variable mysqli query – codezzz Feb 29 '20 at 15:26
but thanks it works – codezzz Feb 29 '20 at 15:26
the error is the single qoute is misplaced – codezzz Feb 29 '20 at 15:54
Yep, correct, I edited – Oto Shavadze Feb 29 '20 at 15:56
Thanks a lot sir. – codezzz Feb 29 '20 at 16:05

iteration of mysql query using for each in php

1 Answers1