preg_match and mysql

lucilue2003

Hi, need help searching for some specific strings...

<td width=85><a href="A-Blast/index.html" onClick="opengame(this.href,350,390); return false"><img src="A-Blast/a-blast.gif" width="73" height="50" border="1" style="border-color:#000000" alt="Go play A-Blast"></a></td>
<td valign="top" width=513>» <a href="A-Blast/index.html" onClick="opengame(this.href,350,390); return false">
A-Blast</a> 
Category: Puzzle</td>

CREATE TABLE game (
category_name varchar(100) NOT NULL default '',
game_id int(11) NOT NULL auto_increment,
game_name varchar(100) NOT NULL default '',
game_link varchar(100) NOT NULL default '',
game_window_height int(11) NOT NULL default '0',
game_window_width int(11) NOT NULL default '0',
game_image_name varchar(100) NOT NULL default '',
game_image_height varchar(100) NOT NULL default '',
game_image_width varchar(100) NOT NULL default '',
PRIMARY KEY (game_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

from the above, i need to be able to insert the follwoing:

'category_name' Puzzle,
game_name = A-Blast
game_link = A-Blast/index.html
game_window_height = 350,
game_window_width =390
game_image_name =A-Blast/a-blast.gif
game_image_height =73,
game_image_width =50,

can you please help me with the preg_match statements...
thanks.

planetsim

Can you explain in a lot more detail what you are trying to accomplish?

Why do you need the preg_match statement, whats it looking for? at the moment it makes no sense since you have shown Database Only stuff.

lucilue2003

all i want to do is to extract things out of the html code and and assign it to a variable and then insert it into a database. I know how to insert but i dont' know how to extract the information i need from that html code i gave.

I tired using preg_match to find the code but i dont' know which statement to use to extract the information i want. I have many html file with the code shown and i am using code to read all files and i'm trying to extract information from all files and insert to database.

I was able to do this so far:
$html = preg_replace("'<table[^>]?>.?<a href=(.?)'si","<a href=",$data);
$html = preg_replace("'</tr>.?</table>'si","",$html);
$html = preg_replace("'<td[^{>]*?>'si","",$html);}

which now leaves with the following:
<a href="A-Blast/index.html" onClick="opengame(this.href,350,390); return false"><img src="A-Blast/a-blast.gif" width="73" height="50" border="1" style="border-color:#000000" alt="Go play A-Blast"></a></td>
» <a href="A-Blast/index.html" onClick="opengame(this.href,350,390); return false">
A-Blast</a> 
Category: Puzzle</td>

   <a href="A-Blast3d/index.html" onClick="opengame(this.href,550,403); return false"><img src="A-Blast3d/a-blast3d.gif" width="73" height="50" border="1" style="border-color:#000000" alt="Go play A-Blast3d"></a></td>
       <span class="raquo">&raquo;</span> <a href="A-Blast3d/index.html" onClick="opengame(this.href,550,403); return false"> 
         A-Blast3d</a><br>
         <span class="I-desc">Category: Adventure</span></td>

i just need to extract what i want and this i need help with.