Re: Parsing html table into MySQL

From: 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

« previous php.general (#67501) next »