Re: Parsing html table into MySQL
| From: | i_union | Date: | Sun, 16 Sep 2001 15:44:10 +0000 |
| Subject: | Re: Parsing html table into MySQL | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67501@lists.php.net to get a copy of this message | ||
No I need to copy the rows values from HTML table you can see it in exlamle
http://66.96.230.191/table.html This is a live score
system which updates
every 2 min, So I need to get these values and parse it in MySQL after that
I neeed to get some element from my database and show in my page..
I have problems in regex I dont know good coding and need only smmall
support Please help me :)
----- Original Message -----
From: "Christian Dechery" <cdechery@easynet.com.br>
To: "i_union" <i_union@yahoo.com>; "Chris Lambert" <chris@php.net>
Cc: <php-general@lists.php.net>
Sent: Monday, September 10, 2001 7:57 PM
Subject: Re: [PHP] Parsing html table into MySQL
> 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.net
>
>
> p.s: meu novo email é cdechery@easynet.com.br
> ____________________________
> . Christian Dechery (lemming)
> . http://www.tanamesa.com.br
> . Gaita-L Owner / Web Developer
>
>
> --
> 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.net
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com