Hi.
Is there an easy way to "lift" data from HTML tables and enter that into
my database? I'm a total novice and so far my searches have yielded
little. I see Navicat has an import option, but that appears to be for
well structured data like Word, Excel or PDF...
Thanks,
Blago
"Blagovist"
news:462f0f0f_3@x-privat.org...
> Hi.
> Is there an easy way to "lift" data from HTML tables and enter that into
> my database? I'm a total novice and so far my searches have yielded
> little. I see Navicat has an import option, but that appears to be for
> well structured data like Word, Excel or PDF...
>
> Thanks,
>
> Blago
If you've got Excel, then you can "bounce" a table via that (copy / paste)
then use that to import via Navicat....
D.
--
googlegroups > /dev/nul
Post removed (X-No-Archive: yes)
Virginner wrote:
> "Blagovist"
> news:462f0f0f_3@x-privat.org...
>> Hi.
>> Is there an easy way to "lift" data from HTML tables and enter that into
>> my database? I'm a total novice and so far my searches have yielded
>> little. I see Navicat has an import option, but that appears to be for
>> well structured data like Word, Excel or PDF...
>>
>> Thanks,
>>
>> Blago
>
> If you've got Excel, then you can "bounce" a table via that (copy / paste)
> then use that to import via Navicat....
>
> D.
I found something called easywebsave (an IE add-on) that looks
promising. But still a long way from being automated.
Blaqgo
Blagovist wrote:
> Virginner wrote:
>> "Blagovist"
>> news:462f0f0f_3@x-privat.org...
>>> Hi.
>>> Is there an easy way to "lift" data from HTML tables and enter that
>>> into my database? I'm a total novice and so far my searches have
>>> yielded little. I see Navicat has an import option, but that appears
>>> to be for well structured data like Word, Excel or PDF...
>>>
>>> Thanks,
>>>
>>> Blago
>>
>> If you've got Excel, then you can "bounce" a table via that (copy /
>> paste) then use that to import via Navicat....
>>
>> D.
>
> I found something called easywebsave (an IE add-on) that looks
> promising. But still a long way from being automated.
>
> Blaqgo
The following code relies heavily on your input html table being well-formatted
XHTML:
$text = " [your table here]
";
/* first, strip the first and last tr tags.
preg_match('/
$to_split=$match[1];
/* now split wherever a row is closed, then opened. */
$rows = preg_split('/<\/td>.*?<\/tr>.*?
foreach ($rows as $row)
{
// now split the rows into cells.
$cells[]=preg_split('/<\/td>.*?
}
Your data is now split in a two-dimensional array. Putting it into a database is
pretty trivial after that.
--
cb
On 26 Apr, 21:50, Christoph Burschka
> Blagovist wrote:
> > Virginner wrote:
> >> "Blagovist"
> >>news:462f0f0f_3@x-privat.org...
> >>> Hi.
> >>> Is there an easy way to "lift" data from HTML tables and enter that
> >>> into my database? I'm a total novice and so far my searches have
> >>> yielded little. I see Navicat has an import option, but that appears
> >>> to be for well structured data like Word, Excel or PDF...
>
> >>> Thanks,
>
> >>> Blago
>
> >> If you've got Excel, then you can "bounce" a table via that (copy /
> >> paste) then use that to import via Navicat....
>
> >> D.
>
> > I found something called easywebsave (an IE add-on) that looks
> > promising. But still a long way from being automated.
>
> > Blaqgo
>
> The following code relies heavily on your input html table being well-formatted
> XHTML:
>
> $text = " [your table here]
";
>
> /* first, strip the first and last tr tags.
> preg_match('/
> $to_split=$match[1];
>
> /* now split wherever a row is closed, then opened. */
> $rows = preg_split('/<\/td>.*?<\/tr>.*?
>
> foreach ($rows as $row)
> {
> // now split the rows into cells.
> $cells[]=preg_split('/<\/td>.*?
>
> }
>
> Your data is now split in a two-dimensional array. Putting it into a database is
> pretty trivial after that.
>
> --
> cb- Hide quoted text -
>
> - Show quoted text -
But what if that data had individual formatting. The data in one cell
could have a superscript or be in bold. All those tags would be
included.
Post removed (X-No-Archive: yes)
"Blagovist"
news:463097cb_1@x-privat.org...
> Virginner wrote:
>> "Blagovist"
>> news:462f0f0f_3@x-privat.org...
>>> Hi.
>>> Is there an easy way to "lift" data from HTML tables and enter that into
>>> my database? I'm a total novice and so far my searches have yielded
>>> little. I see Navicat has an import option, but that appears to be for
>>> well structured data like Word, Excel or PDF...
>>>
>>> Thanks,
>>>
>>> Blago
>>
>> If you've got Excel, then you can "bounce" a table via that (copy /
>> paste) then use that to import via Navicat....
>>
>> D.
>
> I found something called easywebsave (an IE add-on) that looks promising.
> But still a long way from being automated.
Ah! You didn't state "automated" in your OP, hence my suggestion about
Excel -> Navicat.
If you want it automated, then file_get_contents of the url into a string,
strip_tags except table related ones, then use a few explodes or preg_splits
to rip the reaming data into array(s).
D.
--
googlegroups > /dev/nul
Captain Paralytic wrote:
> On 26 Apr, 21:50, Christoph Burschka
>> Blagovist wrote:
>>> Virginner wrote:
>>>> "Blagovist"
>>>> news:462f0f0f_3@x-privat.org...
>>>>> Hi.
>>>>> Is there an easy way to "lift" data from HTML tables and enter that
>>>>> into my database? I'm a total novice and so far my searches have
>>>>> yielded little. I see Navicat has an import option, but that appears
>>>>> to be for well structured data like Word, Excel or PDF...
>>>>> Thanks,
>>>>> Blago
>>>> If you've got Excel, then you can "bounce" a table via that (copy /
>>>> paste) then use that to import via Navicat....
>>>> D.
>>> I found something called easywebsave (an IE add-on) that looks
>>> promising. But still a long way from being automated.
>>> Blaqgo
>> The following code relies heavily on your input html table being well-formatted
>> XHTML:
>>
>> $text = " [your table here]
";
>>
>> /* first, strip the first and last tr tags.
>> preg_match('/
>> $to_split=$match[1];
>>
>> /* now split wherever a row is closed, then opened. */
>> $rows = preg_split('/<\/td>.*?<\/tr>.*?
>>
>> foreach ($rows as $row)
>> {
>> // now split the rows into cells.
>> $cells[]=preg_split('/<\/td>.*?
>>
>> }
>>
>> Your data is now split in a two-dimensional array. Putting it into a database is
>> pretty trivial after that.
>>
>> --
>> cb- Hide quoted text -
>>
>> - Show quoted text -
>
> But what if that data had individual formatting. The data in one cell
> could have a superscript or be in bold. All those tags would be
> included.
>
Hopefully, that information is in the style attribute of the cell tag (and will
get split away, since
if there's markup inside the cell, strip_tags() will remove it.
--
cb