How to convert HTML Table structure to DB schema or XML format

From:	Tariq Murtaza	Date:	Tue, 28 Jan 2003 05:13:27 +0000
Subject:	How to convert HTML Table structure to DB schema or XML format
Groups:	php.general
Request:	Send a blank email to php-general+get-133344@lists.php.net to get a copy of this message

Hi All, How to convert HTML Table structure to DB schema or XML format Here is the sample table Looking for your commnets / directions (Note: I dont know about regular expressions much :( ) Regards Tariq <table width="83%" border="1" cellpadding="2" cellspacing="0" > <tr>

     <td colspan="8" height="25"> <b> <a href=http://www.ababasons.com

A. BABA & SONS</a></b> </td> <tr>

     <td colspan="8" align="left" valign="top"> <p>240/2, SECTOR 6.1,

Lahore.<br>

         [LAHORE ] </p></td>

<tr>

     <td><b>Phone:</b></td>
     <td>92021-6974878</td>
     <td><b>Mobile:</b></td>
     <td colspan="3">0333-66566 </td>
     <td><b>Fax:</b></td>
     <td colspan="3">92021-6901145</td>

</tr> <tr>

     <td colspan="8" height="25"> <b> <a href=http://www.ababasons.com

ABC & CO</a></b> </td>

<tr>

     <td colspan="8" align="left" valign="top"> <p>240/2, SECTOR 6.1,

NORTH KARACHI,

         KARACHI.<br>
         [KARACHI ] </p></td>

<tr>

     <td><b>Phone:</b></td>
     <td>92021-6974878</td>
     <td><b>Mobile:</b></td>
     <td colspan="3">033-565659</td>
     <td><b>Fax:</b></td>
     <td colspan="3">92021-6118625 </td>

</tr> <tr>

     <td colspan="8" height="25"> <b> <a href=http://www.ababasons.com

ARahat Textile</a></b> </td>

<tr>

     <td colspan="8" align="left" valign="top"> <p>240/2, SECTOR 6.1,

NORTH KARACHI,

         KARACHI.<br>
         [KARACHI ] </p></td>

<tr>

     <td><b>Phone:</b></td>
     <td>92021-6974878</td>
     <td><b>Mobile:</b></td>
     <td colspan="3">&nbsp; </td>
     <td><b>Fax:</b></td>
     <td colspan="3">92021-6966625 </td>

</tr> <tr>

     <td colspan="8" height="25"> <b> <a href=http://www.ababasons.com

A. Corvid Ltd</a></b> </td>

<tr>

     <td colspan="8" align="left" valign="top"> <p>240/2, SECTOR 6.1,

NORTH Peshawar<br>

         [PESHAWAR ] </p></td>

<tr>

     <td width="7%"><b>Phone:</b></td>
     <td width="26%">92021-6974878</td>
     <td width="8%"><b>Mobile:</b></td>
     <td colspan="3">0332-656656 </td>
     <td width="5%"><b>Fax:</b></td>
     <td width="33%" colspan="3">92021-69086265</td>

</tr> </table>