php-windows Digest 3 Feb 2001 12:32:20 -0000 Issue 426
Topics (messages 5355 through 5361):
Re: PHP and mail server
5355 by: phobo
Re: Reading CSV data into a database
5356 by: phobo
Re: [PHP] Re: [PHP-WIN] For My Information
5357 by: Boaz Yahav
5358 by: phobo
200 DOLLARS FOR YOU
5359 by: Matt Spears
db paging with SQL 7
5360 by: Scott Parks
XSLT Problem
5361 by: Andrew Golovin
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
Probably not the best idea sending this to the php windows list - but i'm
sure you can do something with php.ini ...
[mail function]
sendmail_path = ;for unix only, may supply arguments as well (default
is 'sendmail -t -i')
Siggy
----- Original Message -----
From: "Francois Allard" <[EMAIL PROTECTED]>
To: "PHP-NEWSGROUP" <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 5:05 AM
Subject: [PHP-WIN] PHP and mail server
> Good morning
>
> I am wandering, in PHP 4 is there any way I can setup PHP to use a
different
> smtp server or I have to use absolutely the linux one (sendmail, qmail).
> I'm on a linux server and I would like to tell PHP to use another smtp
> server.
>
> Thanks
>
> Franck
use the mysql functions. - see www.php.net/mysql.
if you're on windows (i assume, since you're on this list), mysql functions
are built in.
in a nut shell :
> $row = 1;
> $fp = fopen ("test.txt","r");
$con = mysql_connect(-mysql_server_ip-, -username-, -password-);
$con = mysql_select_db (-databasename-)
> while ($data = fgetcsv ($fp, 1000, "\t")) {
> $num = count ($data);
> $row++;
> for ($c=0; $c<$num; $c++) {
> print $data[$c] . "<br>";
> }
mysql_query("INSERT into tablename SET('blah', $data);
> }
> fclose ($fp);
mysql_close($con);
>
> ?>
Siggy
----- Original Message -----
From: "Ben Cairns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 6:00 AM
Subject: [PHP-WIN] Reading CSV data into a database
> I have this script:
> <?
>
> $row = 1;
> $fp = fopen ("test.txt","r");
> while ($data = fgetcsv ($fp, 1000, "\t")) {
> $num = count ($data);
> $row++;
> for ($c=0; $c<$num; $c++) {
> print $data[$c] . "<br>";
> }
> }
> fclose ($fp);
>
> ?>
> It reads a csv file (actually its tab seperated) into an array called
$data.
>
> When I call this in my browser, this is fine. But what I need to do is to
> put this information into a MySQL database...
>
> The file contains these fields:
> region
> event_type
> event_date
> title
> info
> times
> venue
> price
> event_id (this is auto_incrementing)
>
> How do I read this file into the database?
>
> Any help appreciated, as I have RTFM but I still no idea......
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
Guys,
I don't believe that there is any question today that IIS5 on win2K
is the best webserver $$$ can buy.
Sincerely
berber
Visit http://www.weberdev.com Today!!!
To see where PHP might take you tomorrow.
-----Original Message-----
From: Dan Malcolm [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 2:32 PM
To: Tom Mathews
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] Re: [PHP-WIN] For My Information
Tom,
Thanks. I believe myaccess2000_1_4 is one of the ones I've tried. I'll try
again to make sure I didn't miss anything. I used dbtools to do the dBase
conversion.
Agree that the older versions of IIS were crap, but newer one (version 3 and
4) seems to be pretty good.
Dan
----- Original Message -----
From: "Tom Mathews" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 6:09 AM
Subject: Re: [PHP-WIN] For My Information
> 1) I think that people use Apache as old versions of IIS were crap. In
addition, it is about the widest used server out there in the commercial
world (Linux running Apache with PHP3 is I believe the most common config at
the moment) so if you're developing something to put on such a site, it's
more likely to work if you develop with something close to that setup (note
probs with case sensititivity and so on on with Apache that won't necesarily
be exposed on IIS)
>
> 2) Check out the MySQL (www.mysql.com) site and look to download
myaccess2000_1_4.zip, this is an Access plug-in that someone has kindly
written to convert data and structure from Access 2000 MDB to MySQL (I've
not tried them, but I think it also allows dbase conversion and a few
others).
>
> Tom
>
> Dan Malcolm wrote:
>
> > I see in the posts, that a lot of people are using Apache on NT instead
of the built in IIS. Is there a reason? I have PHP up and running with
dBase tables converted to MySQL and ODBC connected to Access 2000, on an NT
4 box with IIS 4 and it runs very well. Performance is great. My only
problem is automating the conversion to update tables in MySQL. I would
like like to convert the Access 2000 tables also but the converters either
don't seem to work with Access 2k, or not much at all, or are not such that
a timed batch file can be generated using them. I just looked at what I've
written and it's a little jumbled. Mega-Sigh. Let me summarize.
> >
> > 1.. Why Apache on NT 4.0?
> > 2.. Is there a good way to automatically convert Access 2000 to MySQL
to keep MySQL data up to date? The data needs to be updated several times a
week. No I can't just switch everything over and not have to convert again.
> > 3.. A way to do #2 for dBase would be good too, but less critical
because the data only gets updated every couple months.
> > Thanks in advance.
> >
> > Dan Malcolm
> > [EMAIL PROTECTED]
> > [EMAIL PROTECTED]
>
>
----------------------------------------------------------------------------
----
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Lets just say I'm glad you posted that on a Windows list :P
I personally find Apache more stable, less mem hogging, and as its what is
used on linux machines, I know that my PHP code CAN work on any platform ;)
And ... yuo say 'best that money can buy' ... I hope you know the price of
Apache? www.apache.org ....
Sure, it doesn't have a nice wee GUI, but after 20 mins reading a FAQ sheet
you can do anything that IIS can, plus more.
BUT, you're entitled to your own opinion, as is everyone :)
Siggy
----- Original Message -----
From: "Boaz Yahav" <[EMAIL PROTECTED]>
To: "'Dan Malcolm'" <[EMAIL PROTECTED]>; "Tom Mathews"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 11:23 AM
Subject: [PHP-WIN] RE: [PHP] Re: [PHP-WIN] For My Information
> Guys,
>
> I don't believe that there is any question today that IIS5 on win2K
> is the best webserver $$$ can buy.
>
> Sincerely
>
> berber
>
> Visit http://www.weberdev.com Today!!!
> To see where PHP might take you tomorrow.
>
>
> -----Original Message-----
> From: Dan Malcolm [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 2:32 PM
> To: Tom Mathews
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP] Re: [PHP-WIN] For My Information
>
>
> Tom,
> Thanks. I believe myaccess2000_1_4 is one of the ones I've tried. I'll
try
> again to make sure I didn't miss anything. I used dbtools to do the dBase
> conversion.
>
>
> Agree that the older versions of IIS were crap, but newer one (version 3
and
> 4) seems to be pretty good.
>
> Dan
> ----- Original Message -----
> From: "Tom Mathews" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, February 02, 2001 6:09 AM
> Subject: Re: [PHP-WIN] For My Information
>
>
> > 1) I think that people use Apache as old versions of IIS were crap. In
> addition, it is about the widest used server out there in the commercial
> world (Linux running Apache with PHP3 is I believe the most common config
at
> the moment) so if you're developing something to put on such a site, it's
> more likely to work if you develop with something close to that setup
(note
> probs with case sensititivity and so on on with Apache that won't
necesarily
> be exposed on IIS)
> >
> > 2) Check out the MySQL (www.mysql.com) site and look to download
> myaccess2000_1_4.zip, this is an Access plug-in that someone has kindly
> written to convert data and structure from Access 2000 MDB to MySQL (I've
> not tried them, but I think it also allows dbase conversion and a few
> others).
> >
> > Tom
> >
> > Dan Malcolm wrote:
> >
> > > I see in the posts, that a lot of people are using Apache on NT
instead
> of the built in IIS. Is there a reason? I have PHP up and running with
> dBase tables converted to MySQL and ODBC connected to Access 2000, on an
NT
> 4 box with IIS 4 and it runs very well. Performance is great. My only
> problem is automating the conversion to update tables in MySQL. I would
> like like to convert the Access 2000 tables also but the converters either
> don't seem to work with Access 2k, or not much at all, or are not such
that
> a timed batch file can be generated using them. I just looked at what
I've
> written and it's a little jumbled. Mega-Sigh. Let me summarize.
> > >
> > > 1.. Why Apache on NT 4.0?
> > > 2.. Is there a good way to automatically convert Access 2000 to
MySQL
> to keep MySQL data up to date? The data needs to be updated several times
a
> week. No I can't just switch everything over and not have to convert
again.
> > > 3.. A way to do #2 for dBase would be good too, but less critical
> because the data only gets updated every couple months.
> > > Thanks in advance.
> > >
> > > Dan Malcolm
> > > [EMAIL PROTECTED]
> > > [EMAIL PROTECTED]
> >
> >
>
>
> --------------------------------------------------------------------------
--
> ----
>
>
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
Has anyone seen a good tutorial on db paging with MS SQL 7 and PHP?
Something were you return 10 results and build a next, previous button at
the bottom and
call $PHP_SELF with a variable to load the next page. All the examples I
see are for
mysql.
tia
-Scott
Hello!
I trying to use example code from manual on xslt_process()
(http://www.php.net/manual/en/function.xslt-process.php)
All annotation form online manual is applied. But i always had an
error:
Fatal error: msgtype: error in C:\usr\bin\htdocs\thruport\xmltest.php on line 40
Script is attached.
I have Apache 1.3.14 (Win32) and PHP 4.0.4pl1
My question is what's wrong with this code? And what is that error?
Best regards!
Andrew Golovin
http://exper.ural.ru/
PGP Fingerprint: 24FD A0CD 667C 1FC7 C2F7 A2EA 9742 D484 FD3C 598D
