Help extracting data from html and writing it to mysql?

method · #1 (**permalink**) 06-10-08, 11:58 PM

Hi all. i wonder how i can extract the following data from an html file and set them to variables so i can write them to mysql database:

Data to extract :

1)http://www.someurl.com/
2)12345678
3)http://www.somesite.com/pic1.jpg
4)Tom

Note: the number of these set of data is not fixed!! Some times it reaches 900!!

So i be happy if some one show me a solution that works for large sets of data and allow me write them to mysql db.Thanks

Quote:

HTML Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>title here</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<link rel="stylesheet" type="text/css" href="http://www.locahost.com/res/style.css" />
</head>
<body id="export">
	<div id="header">
		<h1>List</h1>
	</div>

	<table id="friends" width="100%" border="1">
		<thead>
			<tr>
				<th>ID</th>
				<th width="90">Picture</th>
				<th>Name</th>
			</tr>
		</thead>
		<tbody>
			<tr>
				<td><a href="http://www.someurl.com/">12345678</a></td>
				<td><img src="http://www.somesite.com/pic1.jpg" alt="" /></td>
				<td>Tom</td>
			</tr>

	                <tr>
				<td><a href="http://www.someurl2.com/">87654321</a></td>
				<td><img src="http://www.somesite2.com/pic2.jpg" alt="" /></td>
				<td>jerry</td>
			</tr>



		</tbody>
	</table>
	<br />
</body>
</html>

nashruddin · #2 (**permalink**) 06-12-08, 11:40 AM

that's a very complicated task. but here's how to parse the links:

PHP Code:


			
$html = file_get_contents('http://www.example.com');

$re="<a\s[^>]*href\s*=\s*(['\"]??)([^'\">]*?)\\1[^>]*>(.*)<\/a>";
preg_match_all("/$re/siU", $html, $matches);
$links = $matches[2];

print_r($links);
/*
will print:
Array
{
   [0] => http://www.someurl.com
   [1] => http://www.somesite.com/pic1.jpg
}
*/

---
Cool PHP programmer writing cool PHP scripts

method · #3 (**permalink**) 06-12-08, 12:53 PM

Thanks for your reply. But is there any way to get the 2)12345678 and 3) tom ? I need those very badly :-(