如何根据不同的外部值在mysql表中显示行

Question

I hope someone can help with the following... I have multiple product names in a MYSQL database table on one hand and on the other hand I am getting some info such as pricing (excluding product name and some other static info) from xml feeds. The xml feed gives a product code, with which I can match the rows I need in the database because the database includes name of the product but also product code whilst xml doesn't include name of the product.

What I want to do is to fetch the name of the product and some other values from the database and link them with the other info from the xml, so that the end result is that I display the name of the products and the other info on the front-end. There are multiple products from multiple xml's...

If this was single product with a single code, I know I can use the SELECT statement with a where clause, wherein the WHERE clause is the product ID, but because I have multiple products with multiple ID's and I don't need to fetch everything from the database (but only those products displayed/searched for on the front-end), I am a bit stuck and don't know how to do this.

I hope this makes sense. If not, please do let me know.

Thanks in advance.

Answer 1

When you're processing the XML feed, put all the product codes into an array. Then you can construct the SQL query dynamically from this:

$codes_string = implode(', ', $product_codes);
$sql = "SELECT * FROM product_table WHERE product_id IN ($codes_string)";

I'm assuming product IDs are numeric IDs. If they're strings you'll need to put quotes around each of them:

$codes_string = implode("', '", $product_codes);
$sql = "SELECT * FROM product_table WHERE product_id IN ('$codes_string')";