Extracting Data

[adamjblakey]

Hi,

How would i go about doing the following.

I have a URL like this e.g. www.website.co.uk/orgs-details.asp?OrgsID=

On this page there is Company Name, Contact:, Tel, E-mail: and Web site:

I want to extract these details and add them into a table.

How would i do this?

This is how the data is shown if this helps?

<table width="385" border="0" cellspacing="0" cellpadding="0"> 
              <tr> 
                <td valign="top"><h1>Company Name</h1> 
                  <table width="100%" border="0" cellspacing="0" cellpadding="3"> 
                    <tr> 
                      <th width="30%"><strong>Contact:</strong></th> 
                      <td width="70%"><strong>Persons Name 
                        </strong> </td> 
                    </tr> 
 
                    <tr> 
                      <th><strong>Tel:</strong></th> 
                      <td><strong>000 000 000</strong></td> 
                    </tr> 
                    <tr> 
                      <td>&nbsp;</td> 
                      <td><span class="small">Information Here</span>.</td>
 
                    </tr>
 
                    <tr> 
                      <th><strong>E-mail:</strong></th> 
                      <td><strong><a href="[e-mail]">[e-mail]</a></strong></td> 
                    </tr> 
 
                    <tr> 
                      <th><strong>Web site:</strong></th> 
                      <td><strong><a href="http://www.website.com" target="_blank" id="451" onClick="return trackclick(this.id);" title="Visit Site">www.website.com</a></strong></td> 
                    </tr> 
 
                  </table>

Cheers,
Adam

[ronverdonk]

I do not understand exactly what you want to accomplish.

Is that url you show yours? Or do you want to 'scrape' a website: extract the data from a remote website and store it into your own page?

And what are the 'tables'you talk about, your HTML table or a database table?

Ronald

[TheServant]

Who puts the data on there? If it is the companies themselves they must use a form, and you could just incorporate some database storage code with the form.

Also, is that data currently being called by the page (using sessions, MySQL or something else), or is it just written in the html? If it is being called then you already have the information stored.

If you just want to know how put a name in a table, you need to use php in something like:
[HTML]<tr>
<th width="30%"><strong>Contact:</strong></th>
<td width="70%"><strong><?php echo($persons_name); ?></strong> </td>
</tr>[/HTML]

If this makes no sense, you need to learn php, inparticular: variables.

[adamjblakey]

I want to extract data from one of my old sites and put it into a an sql database.

So basically i need something that will loop through all the page e.g. id=1, id=2 etc and will put the data from each id into an sql database table.

[adamjblakey]

Could something like this be adapted to work that i have used in the past to extract email addresses:

[PHP]
for($i=1;$i<$max_val;$i++) {
$content = file_get_contents('http://www.website.com/slist.php?item='.$i);
preg_match_all($email_match_regex, $content, $matches);
if(count($matches[0])) {
foreach($matches[1] as $index => $value) {
$insert_id = mysql_query('INSERT INTO.....');
}
}
}
[/PHP]