Posted by David Haynes on 04/17/06 18:35

rjames.clarke@gmail.com wrote:
> I want to check if any of the items in a PHP array exist in a MySQL
> table.
> What is the best way to do this with making repeated calls to the
> database for each item?
>
> Actual application is:
> I have an array (in PHP) of serial numbers of units about to be
> shipped.
> I want to check the ship record (a table in a MySQL database) to check
> if that serial number has been used before.
> According to our quality policy we never reuse serial numbers, serial
> numbers are unique. So prior to printing the packing slip I want to
> warn the shipping guy/gal a serial number may be incorrect.
>
> I could brute force it and increment through the "to be shipped array"
> and check each item against the table. But that is, as I said brute
> force, and I am having to be concerned with system speed lately.
>
> Thanks
> Bob
>

My suggestion:

Load the shipped table as an associative array and then do an isset() on
the $array[$serial_number] in question. Only load those rows that have
the shipped status set the way you need.

-david-

• Next in forum: Re: seperator instead of a comma for listed items in DB?
• Prev in forum: seperator instead of a comma for listed items in DB?
• Thread view: Re: Check if any items in an array (php) is in a table (mysql).

[Reply to this message]