Delete element of array

[stonefish]

I am trying to check if any of the elements in a certain array (which is to be inserted into a mysql table) are already listed in the table. For example I have an array containing multiple URL's, and I want to check whether any of these urls is already in my table. If it is i need to remove that particular element of the array. Can anyone point me in the right direction, i am currently trying array_search and in_array.

Thanks in advance

[Shrike]

You could grab all of the URLs which are present in the array from the database. Rather than querying the database for every URL you could do a big WHERE / OR statement, such as

$urls = array( 'a url', 'another url', 'etc' );
$qry = 'SELECT url FROM table WHERE url = ' . implode( ' OR url = ', $urls );
while( $row = fetch( $qry ))
{
  $matches[] = $row['url'];
}
$nomatches = array_diff( $urls, $matches );

Then when you have the fetched URL's from the database in a second array, do an array_diff() on the two arrays to get an array containing those URLs not in the database.

What exactly are you trying to do? This might be a long way around 🙂

[stonefish]

Thanks, but how do i then delete then element of the array that has been matched in the mysql table?

[Shrike]

The new array $nomatches would contain all of the elements from $urls which weren't in the database.