如何在PHP中使用Array作为sql查询

Question

I'm trying tu create a function that read from an excel file and put data into a PHP Array .

my question is : it is possible to make a select query from that array , like into LinqToSQL in Vb.Net : Exemple :

Dim list as new List(of Data)
Dim query = From d in list WHERE d.name = "Jon"

so my question is : how to use an array as an sql query in php

i hope get some answer :)

Answer 1

You could use a foreach.

foreach($array as $key=>$value){
    //query here
}

Just be mindful that this will query as many times as there are elements in your array.

Or load each element in your array as a query:

$array = array();
$query = "SELECT * FROM table WHERE column=value;";
array_push($array,$query);