Re: a standalone PHP script to update MySql server

> It's pretty easy to use PHP to update MySql server through the web sever. Is there an easy way to use PHP scripts to update the MySql sever in a standalone mode (without the web sever)? Any sample scripts? You use the same scripts, but a "different" PHP. If you are on Windows, you can do: c:/path/to/php.exe -q c:/path/to/your/script.php and it will run it. On Un*x, if you compiled PHP from source, go back to the source directory and copy "config.nice" to "config.cgi" Then, edit "config.cgi" and take out the line that says: --with-apxs=/path/to/your/apxs Or, if you compiled as a static Module, the line that says: --with-apache=/path/to/apache/source Then, make "config.cgi" executable: chmod +x config.cgi and run it: ./config.cgi It will (hopefully) produce a binary file called "php". Last time I did this, I had to rip out some fancy stuff like GD or TTF support or something, because I couldn't get it to compile as CGI (stand-alone) with some things... YMMV. Throw that file some place convenient, like, /usr/bin and make it world-executable: chmod +x /usr/bin/php Then, you can call PHP scripts from the command line a variety of ways: #1 /usr/bin/php -q /path/to/your/script.php #2 Add a line to the tip-top of a PHP script: #!/usr/bin/php -q Now, all that compiling and stuff *may* be just too geeky or tricky or something for some people. There is a hack (slow, inefficient, ugly) way: You can use "wget" or "lynx --dump" from the command line to "surf" to a page, which wastes an HTTP connection for as long as that script takes to run. But it works. :-) Once you've got that working, several cool things are possible: cron jobs, to run PHP scripts at specific time intervals. See man cron, man crontab, and man 5 crontab PHP shell scripts for people who consider Perl ASCII soup [like me :-)] Web pages that do double-duty as shell scripts, if you don't mind either very bare-bones web-site, or some <TAGS> in your shell output :-) -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm