Search PHP Array from results of SQL

Question

I currently have an array in php that stores product names, normally 5 - 10. I would like to create something where the results of a SQL query is matched against the array to make sure they are all correct, and if not to show an error.

So far I have put the results into an array, then ran the query to get the results. I believe I need to put some sort of while loop with the results of the query and check the array in that while loop?

withouth any code or hint it's quite hard to answer you correctly. What do you want to check and why? a foreach loop with in_array() function may be enough for your needs but who knows. — kawashita86
– kawashita86, Commented Mar 26, 2013 at 8:44

James Donnelly · Accepted Answer · 2013-03-26 09:17:35Z

1

You have the array with the product name($products) and the results of the query($row). While you loop trough the results you can check if the element is present,otherwise echo error and break the loop:

While(...) {     
    if(!in_array($row['retrivedprod'],$products)) {
        echo 'error';
        break;
     }
}

edited Mar 26, 2013 at 9:17

James Donnelly

129k35 gold badges215 silver badges224 bronze badges

answered Mar 26, 2013 at 8:51

Razorphyn

1,33215 silver badges38 bronze badges

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

Comments

Sandro · Accepted Answer · 2013-03-26 09:05:31Z

1

You can cycle while receiving results from db with a while loop and checking results with the in_array function http://php.net/manual/en/function.in-array.php $availability = 0;

$cart_products = array("book", "album");
$available_products = array();

while($row = mysql_fetch_array($result)) {
    $available_products[] = $row['product'];
}

foreach($cart_products as $key => $value){  
    if (in_array($value, $available_products)){
       $availability = 1;
    }
}

edited Mar 26, 2013 at 9:05

answered Mar 26, 2013 at 8:44

Sandro

2361 silver badge8 bronze badges

1 Comment

Jon Over a year ago

If the only contribution is a link, it should be made in comment form. ^^ Otherwise, please provide a code sample explaining the why/how-to.

Collectives™ on Stack Overflow

Search PHP Array from results of SQL

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related