Tema: Coger datos de tabla e insertarlos en la tabla de la DB
Ver Mensaje Individual
  #1 (permalink)  
Antiguo 07/07/2013, 13:12
carlosuc99
 
Fecha de Ingreso: junio-2011
Mensajes: 342
Antigüedad: 13 años, 6 meses
Puntos: 5
Exclamación Coger datos de tabla e insertarlos en la tabla de la DB
Buenas,

Tengo esta tabla en HTML:

Código HTML: 
Ver original
  1. <table cellspacing="0" cellpadding="0" border="0" rules="none" width="780">
  2.  
  3.  
  4.     <tbody><tr class="textenu" bgcolor="#75AADB">
  5.          <td width="10%">MSN <a class="lien" href="American Airlines-destroyed-dc10.htm"><img src="http://www.forosdelweb.com/f18/images/sort_up.gif" border="0"></a>&nbsp;<a class="lien" href="American Airlines-destroyed-dc10-0-msndesc.htm"><img src="http://www.forosdelweb.com/f18/images/sort_down.gif" border="0"></a></td> <td width="10%">LN</td>        <td width="15%">Type <a class="lien" href="American Airlines-destroyed-dc10-0-typeasc.htm"><img src="http://www.forosdelweb.com/f18/images/sort_up.gif" border="0"></a>&nbsp;<a class="lien" href="American Airlines-destroyed-dc10-0-typedesc.htm"><img src="http://www.forosdelweb.com/f18/images/sort_down.gif" border="0"></a></td>
  6.         <td width="18%">Delivery date <a class="lien" href="American Airlines-destroyed-dc10-0-ddasc.htm"><img src="http://www.forosdelweb.com/f18/images/sort_up.gif" border="0"></a>&nbsp;<a class="lien" href="American Airlines-destroyed-dc10-0-dddesc.htm"><img src="http://www.forosdelweb.com/f18/images/sort_down.gif" border="0"></a></td>
  7.         <td width="18%">Registration <a class="lien" href="American Airlines-destroyed-dc10-0-regasc.htm"><img src="http://www.forosdelweb.com/f18/images/sort_up.gif" border="0"></a>&nbsp;<a class="lien" href="American Airlines-destroyed-dc10-0-regdesc.htm"><img src="http://www.forosdelweb.com/f18/images/sort_down.gif" border="0"></a></td>
  8.         <td width="30%">Remark</td>
  9.     </tr>
  10.  
  11. <tr class="trtab">
  12.     <td width="10%" class="tdtexten3">
  13.     <a class="lien" title="Go to McDonnell Douglas DC-10 MSN 46510 history and information" href="http://www.forosdelweb.com/f18/ficheapp/plane-dc10-46510.htm">46510</a></td>
  14.     <td width="9%" class="tdtexten">
  15.     <a class="lien" title="Go to McDonnell Douglas DC-10 MSN 46510 history and information" href="http://www.forosdelweb.com/f18/ficheapp/plane-dc10-46510.htm">22</a></td>
  16.     
  17.  
  18.     <td width="15%" class="tdtexten">DC10-10</td>
  19.     <td width="18%" class="tdtexten">28/02/1972</td>
  20.     <td cwidth="18%" class="tdtexten"><a class="lien" title="Go to McDonnell Douglas DC-10 MSN N110AA history and information" href="http://www.forosdelweb.com/f18/ficheapp/plane-dc10-46510.htm">N110AA</a></td>
  21.     <td width="30%" class="tdtexten">Crashed 25/05/79 at Chicago OHare</td>
  22.   </tr>
  23. <tr class="trtab">
  24.     <td width="10%" class="tdtexten3">
  25.     <a class="lien" title="Go to McDonnell Douglas DC-10 MSN 46711 history and information" href="http://www.forosdelweb.com/f18/ficheapp/plane-dc10-46711.htm">46711</a></td>
  26.     <td width="9%" class="tdtexten">
  27.     <a class="lien" title="Go to McDonnell Douglas DC-10 MSN 46711 history and information" href="http://www.forosdelweb.com/f18/ficheapp/plane-dc10-46711.htm">105</a></td>
  28.     
  29.  
  30.     <td width="15%" class="tdtexten">DC10-30</td>
  31.     <td width="18%" class="tdtexten">24/02/1984</td>
  32.     <td cwidth="18%" class="tdtexten"><a class="lien" title="Go to McDonnell Douglas DC-10 MSN N139AA history and information" href="http://www.forosdelweb.com/f18/ficheapp/plane-dc10-46711.htm">N139AA</a></td>
  33.     <td width="30%" class="tdtexten">Crashed 14/04/93 at Dallas</td>
  34.   </tr>
  35. <tr class="trtab">
  36.     <td width="10%" class="tdtexten3">
  37.     <a class="lien" title="Go to McDonnell Douglas DC-10 MSN 47846 history and information" href="http://www.forosdelweb.com/f18/ficheapp/plane-dc10-47846.htm">47846</a></td>
  38.     <td width="9%" class="tdtexten">
  39.     <a class="lien" title="Go to McDonnell Douglas DC-10 MSN 47846 history and information" href="http://www.forosdelweb.com/f18/ficheapp/plane-dc10-47846.htm">69</a></td>
  40.     
  41.  
  42.     <td width="15%" class="tdtexten">DC10-30</td>
  43.     <td width="18%" class="tdtexten">21/10/1981</td>
  44.     <td cwidth="18%" class="tdtexten"><a class="lien" title="Go to McDonnell Douglas DC-10 MSN N136AA history and information" href="http://www.forosdelweb.com/f18/ficheapp/plane-dc10-47846.htm">N136AA</a></td>
  45.     <td width="30%" class="tdtexten">Crashed 21/05/88 at Dallas Ft Worth during TO</td>
  46.   </tr>
  47. </tbody></table>

Lo que quiero es coger los datos de cada fila e insertarlos en la base de datos. Ej: La fila 1 insertarlos en la 1 fila de la tabla con sus correspondientes columnas.

Cómo lo puedo hacer?

PD: En caso de que no se pueda hacer con esa tabla, se puede con esta?

Código HTML: 
Ver original
  1. <table>
  2.   <tr><th title="Aircraft Registration">Registration</th><th title="Manufacturer">Manuf.</th>
  3.                           <th>Model</th><th title="a/c type according to ICAO Doc 8643">Type</th><th title="construction number">c/n</th><th title="line number">l/n</th>
  4.                           <th title="Registrant or Operator">Reg/Opr</th><th>built</th>
  5.                           <th>delivery</th><th>until</th><th>status</th>
  6.                           </tr>
  7.     <tr> <td ><a href="http://www.airframes.org/reg/n14551" target ="new">N14551</a></td><td>McDonnell Douglas</td><td >MD-82</td><td>MD82</td><td align="right">53033</td><td align="right">1822</td><td><a href="http://www.airframes.org/airlines/icao/aal" target ="new">AAL</a></td><td>1991</td><td>1991-02-26</td><td></td><td>active</td></tr>
  8.     <tr> <td ><a href="http://www.airframes.org/reg/n16545" target ="new">N16545</a></td><td>McDonnell Douglas</td><td >MD-82</td><td>MD82</td><td align="right">53027</td><td align="right">1805</td><td><a href="http://www.airframes.org/airlines/icao/aal" target ="new">AAL</a></td><td>1990</td><td>1990-12-18</td><td></td><td>active</td></tr>
  9. </table>