Thanks a million.
That's actually much simpler than I thought it would be...
I'm gonna give it a go just now, but I'm sure it will work!
On Tue, 2002-11-05 at 17:09, Erwin wrote:
> > I am pretty up to standard with getting stuff into and out of mysql,
> > so I am basically just in need of pointers with generating the text
> > file and ftp'ing automatically.
> > It would be an even greater plus if it wasn't actually necessary to
> > create a physical text file on the hard drive, but to simply ftp the
> > "memory" file via the ftp functions, but I don't think that is
> > possible?
> In fact, it is...just open the file on the ftp directly
> $fp = fopen( 'ftp://ftp.domain.com/file.txt', 'w' );
> You can then write directly to that filepointer:
> fwrite( $fp, 'some text' );
> Don't forget to close the file (I think PHP does that anyway, but it's nicer
> if you do that)
> fclose( $fp );
> > My routine will already have connections to the db, and the query will
> > have already been run
> > (something like select number from table where group=1)
> > and I would then have a while to step through the result set.
> > This is where I need help, how to "create" the file and add the
> > numbers and "static" text to the file, and once completed with the
> > loop, to ftp to a server with username and password.
> You'll have to loop trough the resultset
> $query = 'select number from table where group=1';
> $result = mysql_query( $query );
> $content = '';
> while ( $res = mysql_fetch_array( $result ) ) // This piece of code will
> add all the Cellphone-numbers to the $content variable
> $content .= 'Cellphone: ' . $res['number'] . "\n";
> $content .= 'Reference: ' . $reference . "\n";
> $content .= 'Notify: ' . $notify . "\n";
> // And add everything else to the $content variable which needs to be
> $fp = fopen('ftp://ftp.domain.com', 'w' );
> fwrite( $fp, $content );
> fclose( $fp );
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php