Setting array elements as variables...

[ender]

Hi,

I've been trying to search a database for each element in an array but have been having some problems. First off, here is the small script:

<?php

mysql_connect("hostname", "username", "password");
mysql_select_db(database);

$html = "This is some sample text for the html of the page. Here is a card name: [card]Verdant Force[/card]. Heres another [card]Counterspell[/card] and then the rest of the page...";

preg_match_all("/\[card\](.*?)\[\/card\]/i", $html, $matches);

foreach ($matches[1] as $value) {

$cardinfo=$db->sql_query("SELECT id, title FROM cards WHERE title='$value'");
list($card_id, $card_title)=$db ->sql_fetchrow($cardinfo);
	echo "$value, $card_id, $card_title<br><br>";

}

?>

For some reason, it keeps giving me the following error:

Fatal error: Call to a member function on a non-object in /directory/.../file.php on line #

And this is the array:

Array (
[0] => Array ( [0] => [card]Verdant Force[/card] [1] => [card]Counterspell[/card] )
[1] => Array ( [0] => Verdant Force [1] => Counterspell )
)

If anyone has any information on setting the elements as variables so I can just search them that way or a different way I can do this, I would greatly appreciate it. The array is fine, as I can print out the values for $value, but I'm not sure why it won't let me search the database for those values.

Thanks,

~ender

[ppowell]

For one thing, you are producing an error in your preg_match() statement. '[' and ']' are reserved characters in Regular Expressions and evaluate as such, which is causing your entire preg_match() statement to blow up.

My advice is for you to use a different delimiter or try this:

preg_match_all('/\\[card\\](.*?)\\[/card\\]/i', $html, $matches);

Also use single quotes and not double quotes here as it will allow you to use a single backslash to escape the brackets from Regular Expression usage and since you're not evaluating any PHP code here no worries.

Phil

[ender]

Oh, yeah I have all the brackets and whatnot escaped. For some reason the forum is stripping some of the slashes out. I checked that part and everything seems to be working with the preg_match_all. Here is the exact code:

preg_match_all("/[card](.*?)[\/card]/i", $html, $matches);

Thanks for the tip on the single quotes though,

~ender