Extracting Data

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?

Cheers,
Adam

re: Extracting Data

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

re: Extracting Data

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.

re: Extracting Data

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.

re: Extracting Data

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]