Complex problem

kish89

Now I need some php code which will extract data from html table from auction site, table structure on auction site is like this:
Code:

<table width="90%" cellpadding="1" cellspacing="0" bgcolor="#efefef" border="0">

	  <tr>

		<td>

			<table width="100%" border="0" cellspacing="1" cellpadding="4" bgcolor="#ffffff">


					<tr valign="top" bgcolor="#ffffff">

					  <td colspan="4"><font face="Tahoma,Verdana,Arial"

				 SIZE=2 COLOR=#003399><span 
        style="FONT-SIZE: 10pt; COLOR: #003399; LINE-HEIGHT: 115%; FONT-FAMILY: 'Tahoma','sans-serif'; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: HR; mso-ansi-language: HR; mso-bidi-language: AR-SA">Auction:&nbsp; 
        <b><a href="http://www.aukcije.hr/item.php?id=344756" 
        target=_blank><span 
        style="COLOR: #003399; LINE-HEIGHT: 115%; mso-bidi-font-size: 11.0pt">1auction</span></a></b> 
        (Number: <a href="http://www.aukcije.hr/item.php?id=344756" 
        target=_blank><span 
        style="COLOR: #003399; LINE-HEIGHT: 115%; mso-bidi-font-size: 11.0pt">344756</span></a> 
        – 08/17) </span>   </font>   

						</td>

					</tr>


					<tr bgcolor="#ffffff">

					  <td width="33%" bgcolor="#eeeeee"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399><span 
        style="FONT-SIZE: 10pt; COLOR: #003399; LINE-HEIGHT: 115%; FONT-FAMILY: 'Tahoma','sans-serif'; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: HR; mso-ansi-language: HR; mso-bidi-language: AR-SA">Buyer 
        name </span> </font> 
					  </td>

					  <td width="33%" bgcolor="#eeeeee"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>E-mail</font>
					  </td>

					  <td width="17%" bgcolor="#eeeeee"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399> Price</font> 
					  </td>

					  <td width="17%" bgcolor="#eeeeee"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>Quantity</font>
					  </td>

					</tr>


					<tr>

					  <td width="33%" bgcolor="#ffffff"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>
						<span><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>buyer1</font></span>&nbsp;&nbsp;

					  	<a href="feedback.php?auction_id=344770&amp;id=20508" ><b> Sendcommen</b></a>t</font>

					  </td>

					  <td width="33%" bgcolor="#ffffff"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>
						<a href="mailto:mail@mail.net" >

						mail@mail.net
						</a></font> </td>

					  <td width="17%" bgcolor="#ffffff"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>
						52,00</font> </td>

					  <td width="17%" bgcolor="#ffffff"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>
						1</font>

					  </td>

					</tr>


					<tr>

					  <td colspan="4" bgcolor="#ffffff">&nbsp;</td>

					</tr>

					<tr valign="top" bgcolor="#ffffff">

					  <td colspan="4"><table width="100%" border="0" cellspacing="0" cellpadding="0">

						  <tr>

							<td bgcolor="#000000"><img height="1" src="./images/transparent.gif" width="1"></td>

						  </tr>

						</table></td>

					</tr>


					<tr valign="top" bgcolor="#ffffff">

					  <td colspan="4"><font face="Tahoma,Verdana,Arial"

				 SIZE=2 COLOR=#003399><span 
        style="FONT-SIZE: 10pt; COLOR: #003399; LINE-HEIGHT: 115%; FONT-FAMILY: 'Tahoma','sans-serif'; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: HR; mso-ansi-language: HR; mso-bidi-language: AR-SA">Auction:&nbsp;<b>2auction</b> 
        (Number: <a href="http://www.aukcije.hr/item.php?id=344770" 
        target=_blank><span 
        style="COLOR: #003399; LINE-HEIGHT: 115%; mso-bidi-font-size: 11.0pt">344770</span></a> 
        – 08/27) </span>   
        </font>   

						</td>

					</tr>


					<tr bgcolor="#ffffff">

					  <td width="33%" bgcolor="#eeeeee"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399><span 
        style="FONT-SIZE: 10pt; COLOR: #003399; LINE-HEIGHT: 115%; FONT-FAMILY: 'Tahoma','sans-serif'; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: HR; mso-ansi-language: HR; mso-bidi-language: AR-SA">Buyer 
        name </span> </font> 
					  </td>

					  <td width="33%" bgcolor="#eeeeee"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>E-mail</font>
					  </td>

					  <td width="17%" bgcolor="#eeeeee"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399><span 
        style="FONT-SIZE: 10pt; COLOR: #003399; LINE-HEIGHT: 115%; FONT-FAMILY: 'Tahoma','sans-serif'; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: HR; mso-ansi-language: HR; mso-bidi-language: AR-SA">Price</span> </font> 
					  </td>

					  <td width="17%" bgcolor="#eeeeee"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>Quantity</font>
					  </td>

					</tr>


					<tr>

					  <td width="33%" bgcolor="#ffffff"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>
						<span><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>buyer2</font></span>&nbsp;&nbsp;

					  	<a href="feedback.php?auction_id=344770&amp;id=20508" ><b> Sendcomment</b></a>
						<br></font>

					  </td>

					  <td width="33%" bgcolor="#ffffff"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399><a 
        href="mailto:mail.mail@mail.net">mail.mail@mail.net</a></font> </td>

					  <td width="17%" bgcolor="#ffffff"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>
						30,00</font> </td>

					  <td width="17%" bgcolor="#ffffff"><font face="Tahoma,Verdana,Arial"
				 SIZE=2 
				 COLOR=#003399>
						1</font>

					  </td>

					</tr>


					<tr>

					  <td colspan="4" bgcolor="#ffffff">&nbsp;</td>

					</tr>

					<tr valign="top" bgcolor="#ffffff">

					  <td colspan="4"><table width="100%" border="0" cellspacing="0" cellpadding="0">

						  <tr>

							<td bgcolor="#000000"><img height="1" src="./images/transparent.gif" width="1"></td>

						  </tr>

						</table></td></tr></table></tr></table>

Php code needs extract data from this fields in html table: „Auction“ , „Price“ , „Quantity“ ,„Buyer name“ , „E-mail“ and„Number“.
When script extracts that data, it needs to enter that data to mysql database, but it needs to do some comparison.
So if extracted auction name is „1auction“ it compares that name with auction name which is in database and adds all extracted data for that auction in database.
Sorry for my bad english but I hope so you know what I need.
Thank you!

devphp12

if m not worng then u need to fetch data from other site?

n if it then u can do it with cURL

kish89

Yes, I need to fetch data from other site.
Can you please give me some example based on table I have posted.
Thank you.

Ilyes

Hi,
I don't thing we need to use cURL here...

You just open that page as you open a text file, then search ofr tags <td> and <tr> then extract data. This will not be easy, it need a small work, I will check this later when I have time.

kish89

Ok ,thank you

devphp12

if u wan to go with curl then use this

$xx = "http://www.abc.com";
$cURL = curl_init();

curl_setopt($cURL, CURLOPT_URL, $xx);
curl_setopt($cURL, CURLOPT_HEADER,0);


curl_setopt($cURL, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($cURL, CURLOPT_COOKIESESSION, true);
curl_setopt($cURL, CURLOPT_FOLLOWLOCATION, 1);
$strPage = curl_exec($cURL);
curl_close($cURL);

list($a,$b)=split("<td>",$strPage );

print_r($a);
print_r($b);

you get dta in it

kish89

It's not working 🙁
Output is blank page

devphp12

is ther curl installed on ur pc?
then only u can use this functionality

chk using phpinfo()

kish89

Hi,
Yes, curl is installed.
Problem was in $xx = "http://www.abc.com"; , I wrote wrong link.
But I have another problem.
Script doesn't extract table values, maybe because on that html page is not only table for which I gave you a code, there are also images, text, another tables, etc.
How to get this script working?
Thanks.

devphp12

if images are then use same code

eaxh evry time u get result in variable n print it

<?php list($a,$b)=split("<img",$strPage );

print_r($a);
print_r($b);
?>

kish89

I can't connect start with the end 🙁.
So, can anybody give me an example code to extract data from html table which example code is in my first post.
For more details please read my first post.
Thank you very much!