At 11:14 PM 08.17.2001 -0500, Teresa Raymond wrote:
>I have never worked with SQL before but I need to dump about 900 html
>files into a SQL database. Someone else has written a PHP script to put
>the content of the html pages in the database but you can only do it one
>page at a time by submitting a form with the relevant contents copied and
>pasted into it. This seemed a little crazy to me, so...
It can be done in Perl...but I would do something like this in shell and
just run the php script through a for loop. However, since this *is* a
Perl list, you can really just do the same thing in Perl. Just run the
sucker through a for loop. The reason I'd do it in shell vs in Perl is
because it is a little easier to suck up files in shell than it is in Perl
and Frankly, that is what shell scripting is for.
- Jim
>It seems to me that a Perl script ought to be able to do this. So, to
>start with I need some introductory information about SQL. How do you
>access it, by open database? Anyway, if I could get some pointers on
>where to start, that would be great.
>
>*Teresa Raymond
>*Mariposa Net
>*http://www.mariposanet.com
>
>--
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
- Jim
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
http://www.perlmonks.org/index.pl?node_id=67861&lastnode_id=67861
-----BEGIN PERL GEEK CODE BLOCK----- ------BEGIN GEEK CODE BLOCK------
Version: 0.01 Version: 3.12
P++>*@$c?P6?R+++>++++@$M GIT/CM/J d++(--) s++:++ a-
>++++$O!MA->++++E!> PU-->+++BD C++++(+) UB++++$L++++$S++++$
$C-@D!>++++(-)$S++++@$X?WP+>++++MO!>+++ P++(+)>+++++ L+++(++++)>+++++$ !E*
+PP+++>++++n-CO?PO!o >++++G W++(+++) N+ o !K w--- PS---(-)@ PE
>*(!)$A-->++++@$Ee---(-)Ev++uL++>*@$uB+ Y+>+++ PGP t+(+++)>+++@ 5- X++ R@
>*@$uS+>*@$uH+uo+w-@$m! tv+ b? DI-(+++) D+++(++) G(++++)
------END PERL GEEK CODE BLOCK------ ------END GEEK CODE BLOCK------
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
