Can PHP do this?
Moderator: General Moderators
Can PHP do this?
If I wanted to execute sql statements (reports) on a nightly basis and have the results formatted and emailed to specific people, is php capable?
Thank you... all I am looking for is an idea of how difficult this would be and what kinds of things are involved.
Regards,
J
Thank you... all I am looking for is an idea of how difficult this would be and what kinds of things are involved.
Regards,
J
- Ambush Commander
- DevNet Master
- Posts: 3698
- Joined: Mon Oct 25, 2004 9:29 pm
- Location: New Jersey, US
-
blackbeard
- Forum Contributor
- Posts: 123
- Joined: Thu Aug 03, 2006 6:20 pm
You can use PHP to create the code that creates the report, but in order to run it on a schedule, you need to set up a cron job that calls the script, if you're in a linux/unix environment.
If you're running on a windows box, you can use the Task Scheduler to run the script (I've never used it, don't even know for a fact if it's different or even available on a windows server.)
If you're running on a windows box, you can use the Task Scheduler to run the script (I've never used it, don't even know for a fact if it's different or even available on a windows server.)
CLI = Command Line Interface 
I'm using CRON every night to run certain scripts (i'm using a linux machine)..
Never tried the windows task scheduler for that purpose though... 
I'm using CRON every night to run certain scripts (i'm using a linux machine)..
Last edited by dreamline on Thu Aug 10, 2006 8:00 am, edited 2 times in total.
I dont know about the Task Scheduler running php scripts...blackbeard wrote:You can use PHP to create the code that creates the report, but in order to run it on a schedule, you need to set up a cron job that calls the script, if you're in a linux/unix environment.
If you're running on a windows box, you can use the Task Scheduler to run the script (I've never used it, don't even know for a fact if it's different or even available on a windows server.)
...so the consensus is - it can be done without too much hassle or advanced skillsets?
-
litebearer
- Forum Contributor
- Posts: 194
- Joined: Sat Mar 27, 2004 5:54 am
jmilane wrote:Thanks a lot. Please dont charge me for that. I didnt know you were so expensive.feyd wrote:icron. Better and more reliable than task scheduler.
His answers on the forums are completely free of charge. =] And 100% correct.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
jmilane wrote:Thanks a lot. Please dont charge me for that. I didnt know you were so expensive.feyd wrote:icron. Better and more reliable than task scheduler.
Edit: It reminds me a joke... It goes like this:
"You're a high priced lawyer!
If I give you $500, will you answer two questions for me?"
"Absolutely! What's the second question?"
Now I can make a comparison between feyd and the lawyer (that would be funny
lawyer - charges $500 for 2 questions
feyd - charges $500 for 2 hours