preg_match_all problem

Minau

Hi - I have a preg_match_all problem.

I need to extract several strings from a repeating code:

<tr>
                    <td align="center" valign="top">
                      <input type="checkbox" name="list" value="01AR012730">
                    </td>
                    <td width="180"><a href="dshost.php?back=result.php&amp;left=details.php&amp;id_vid=28683">Vart tog pappa vägen<br><i>Lillemann</i></a></td>

                <td align="center" width="50">2001</td>
                <td align="right" width="5"><input type="radio" id="rad101AR012730" name="rad01AR012730" checked></td>
                <td align="right" width="5"><input type="radio" id="rad201AR012730" name="rad01AR012730"></td>

                <td align="right"><img src="../images/disabled.gif" onClick="Show_();" border="0" WIDTH="46" HEIGHT="15"> </td>

              </tr>

              <tr>
                <td align="center" valign="top">
                  <input type="checkbox" name="list" value="01AR013200">

                </td>
                <td width="180"><a href="dshost.php?back=result.php&amp;left=details.php&amp;id_vid=28684">Bara 16 år<br><i>Leman</i></a></td>
                <td align="center" width="50">2002</td>
                <td align="right" width="5"><input type="radio" id="rad101AR013200" name="rad01AR013200" checked></td>
                <td align="right" width="5"><input type="radio" id="rad201AR013200" name="rad01AR013200"></td>

                <td align="right"><img src="../images/disabled.gif" onClick="Show_();" border="0" WIDTH="46" HEIGHT="15"> </td>

              </tr>


              <tr>
                <td align="center" valign="top">
                  <input type="checkbox" name="list" value="01HQ000430">
                </td>
                <td width="180"><a href="dshost.php?back=result.php&amp;left=details.php&amp;id_vid=27190">Cry Wolf<br><i>Lisa Ge</i></a></td>
                <td align="center" width="50">1995</td>
                <td align="right" width="5"><input type="radio" id="rad101HQ000430" name="rad01HQ000430" checked></td>

                <td align="right" width="5"><input type="radio" id="rad201HQ000430" name="rad01HQ000430"></td>

                <td align="right"><img src="../images/disabled.gif" onClick="Show_();" border="0" WIDTH="46" HEIGHT="15"> </td>

              </tr>

              <tr>
                <td align="center" valign="top">
                  <input type="checkbox" name="list" value="01DG010400">
                </td>
                <td width="180"><a href="dshost.php?back=result.php&amp;left=details.php&amp;id_vid=2271">You Make Me Want To Wear ...<br><i>Lisa H</i></a></td>

                <td align="center" width="50">1993</td>
                <td align="right" width="5"><input type="radio" id="rad101DG010400" name="rad01DG010400" checked></td>
                <td align="right" width="5"><input type="radio" id="rad201DG010400" name="rad01DG010400"></td>

                <td align="right"><img src="../images/disabled.gif" onClick="Show_();" border="0" WIDTH="46" HEIGHT="15"> </td>

              </tr>

It is clear that its repeating by <tr>......</tr>
from the forst I would like to extract following data:

01AR012730,Vart tog pappa vägen, Lillemann, 2001

and so on for the rest.
I tryed somthing like

preg_match_all('%<input type="checkbox" name="list" value="(\S*)">.*<a href="dshost\.asp\?back=result\.asp&amp;left=details\.asp&amp;id_vid=\d*">(.*)<br><i>(.*)</i></a><td><td align="center" width="50">(\d\d\d\d)</td>%',$string,$result);

but it does not work. Can you please help me?

Minau

Is this totally weird? (Because if it is I can explain it again)

tsinka

Hi,

I hope I understood you completely 🙂

Find attached a script that worked on my server (rename it from .php.txt to .php).

Thomas

Minau

that was JUST what I was loking for :-)

Tanx !!!

c",)

Minau

Hmmm - maby I did'nt get the whole point.

Im now trying with

<tr> 
          <td width="55" rowspan="2"><img src="images/covers/01HL024550030.jpg" alt="" width="50" height="50" vspace="2" border="1"></td>

      <td nowrap valign="top"> <span class="txt"> <a href="../playlists/details_new.asp?id_vid=26995"><strong><font color="#333333"> 
        Brai </font></strong> <br>
        <font color="#333333">Coldeffgggr</font></a><font color="#333333"><a href="../playlists/details_new.asp?id_vid=26995"></a></font></font> 
        </span> </td>
      <td align="right" valign="middle"> <input type="radio" id="rad101HL024030" name="rad01HL024030" VALUE="rad101HL024030">
        30 </td>

      <td align="right" valign="middle"> <input type="radio" id="rad201HL024030" name="rad01HL024030" checked VALUE="rad201HL024030">
        Full </td>
      <td align="right" valign="middle">  <img src="images/play-disabled.gif"  border="0" WIDTH="46" HEIGHT="15"> 
         </td>
    </tr>
    <tr>
      <td colspan="4" valign="top"> Thirandom random random random random random2000 </td>

    </tr>

<tr> 
          <td width="55" rowspan="2"><img src="images/covers/01HL024030.jpg" alt="" width="50" height="50" vspace="2" border="1"></td>

      <td nowrap valign="top"> <span class="txt"> <a href="../playlists/details_new.asp?id_vid=26995"><strong><font color="#333333"> 
        BrainStorm </font></strong> <br>
        <font color="#333333">Colder</font></a><font color="#333333"><a href="../playlists/details_new.asp?id_vid=26995"></a></font></font> 
        </span> </td>
      <td align="right" valign="middle"> <input type="radio" id="rad101HL024030" name="rad01HL024030" VALUE="rad101HL024030">
        30 </td>

      <td align="right" valign="middle"> <input type="radio" id="rad201HL024030" name="rad01HL024030" checked VALUE="rad201HL024030">
        Full </td>
      <td align="right" valign="middle">  <img src="images/play-disabled.gif"  border="0" WIDTH="46" HEIGHT="15"> 
         </td>
    </tr>
    <tr>
      <td colspan="4" valign="top"> This Latvian band captured many hearts in the Eurovision Song Contest in 2000 </td>

    </tr>

I have tryed

preg_match_all('§<tr>.?/images/covers/([^"]+).jpg.?.?(.?) (.?) </a></td>.?</tr><tr><td colspan=\"4\" valign=\"top\">(.*?)</td></tr>§si',$str,$r);

to extract (from the first) somthing like
01HL024550030,Brai, Coldeffgggr, Thirandom random random random random random200

but it did'nt workd out.

So - maby the preg_match_all is more difecult than i emagined? what am I doing wrong?

(and why the "si" after the §?)

DRuCuLa

errr... digits in PHP regex is \d and not just d...
my 1 cent.

tsinka

Ok,

the pattern has to be corrected a little bit. But the main question is:

What exactly do you want to do ? Do you have several HTML code sniplets with a given layout or do you want to extract data regardless of what the repeating code looks like ? Tell me a little bit more about the application you want to develop 🙂

About that si stuff:

those are two pattern modifiers:

s: match strings containing multiple lines. Without that modifier preg_match would stop at the first occurence of a line ending.
i: case insensitive match

Thomas

Minau

Actually it was by curiosity that I came into a problem. Every Month I a guy I know, have to make a list over some artists playing at a - hmmm “koncert place”? never mind.

All the info is on the website, but he always says that it is wery boring to take the artists data – 1 by 1 and copy it. So I imagined that I could help him.

So the first thread I made was because he had to get the data. He was very happy and asked if I could make it with data+description (on another seek site). So – with the example from you it would be very easy to customise it. Well the second tread was because preg_match_all was a little more tuff then expected :-)

So the answer to your question is: I have several HTML code sniplets with a given layout from where I want to extract some data

tsinka

I added some code to my last script. It now contains the two HTML code snipplets and two different patterns. Additionally, I added trim to remove leading and trailing whitespaces from the result.

Thomas

tsinka

Does that guy want to get the data from a foreign site or is that a site he owns ?

Thomas

Minau

Nope - He does not own it.

he just do the advetizes for them (but based om there website)

Minau

Have just tjecked the code you have made

it is perfect - great. :-D

I think that I now undestand a bit more of preg_match_all - tanx a lot

munaf

Many thanks to tsinka

I was searching for that too