Re: Parsing html table into MySQL
| From: | Christian Dechery | Date: | Mon, 10 Sep 2001 14:57:51 +0000 |
| Subject: | Re: Parsing html table into MySQL | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67498@lists.php.net to get a copy of this message | ||
wait a minute... do you want to parse the HTML to get the values to populate a mysql table, or do you have this table in another DB and just want it copied to your mysql one??
If it is the former, you'll some very hardcore regex work to be done... I once did this... it is very stressing work...
- you need to analyse the HTML document and find patterns that indicate 'begin of row' 'begin and end of column' and 'end of row', 'end of table' - these patterns must be unique or you'll find yourself looking for it indefinetly and going into an endless loop - do a giant loop that only ends on 'end of table' and grab the values within this patterns... the code to get this done is huge (not complex), and (I expect) will be only used once, right?
At 19:25 16/9/2001 +0500, i_union wrote:
I need to get from another page table and put it into MySQL table dynamically for example http://66.96.230.191/table.html so I need to parse this table in database. If you have any code how to implement such operation by using php MySQL please help me; thanks in advance _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.netp.s: meu novo email é cdechery@easynet.com.br ____________________________ . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer