[PHP-DB] Re: Connect to Oracle DB

2003-09-15 Thread Philippe Saladin
Frederico Madeia [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ... How i connect one server running PHP(linux) to other server running Oracle(linux) ?? when i tryed to connect with ora_logon, the server return me: Call to undefined function: ora_logon(). 1) the oracle

[PHP-DB] $PHP_SELF does not work with all browsers

2003-09-15 Thread Alain Barthlemy
I wrote a page browser that allows me to list different persons in a table according to the first alphabet-letter of their name Thus if I choose letter nr 65 (A): $chrLettre = chr(65); $chosenLettre = $chrLettre; echo a href=\$PHP_SELF?chosenLettre\.$chosenLettre./a\n; 1) Station

Re: [PHP-DB] $PHP_SELF does not work with all browsers

2003-09-15 Thread mike karthauser
on 15/9/03 1:46 pm, Alain Barthélemy at [EMAIL PROTECTED] wrote: http://localhost/~webpage/?chosenLettre=65 /// where is $PHP_SELF Try using $_SERVER['PHP_SELF'] -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web

Re: [PHP-DB] Re: Connect to Oracle DB

2003-09-15 Thread roy.a.jones
I just wanted to add my two cents ... I have compiled php with BOTH --with-oracle and --with-oci8. It is usually preferred to have your architectures/systems separate to prevent some performance issues. As a test/demo system then having them on the same box is perfectly acceptable and

Re: [PHP-DB] $PHP_SELF does not work with all browsers

2003-09-15 Thread Alain Barthlemy
Le lundi 15 septembre 2003, 14:16:15 ou environ mike karthauser [EMAIL PROTECTED] a écrit: on 15/9/03 1:46 pm, Alain Barthélemy at [EMAIL PROTECTED] wrote: http://localhost/~webpage/?chosenLettre=65 /// where is $PHP_SELF Try using $_SERVER['PHP_SELF'] -- Mike Karthauser

[PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
From: Jonathan Villa [EMAIL PROTECTED] I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which

AW: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Lars Jedinski
I used to have the same problem and solved it as follows: I wrote my php script and created my crontab runing the script with the lynx-browser. The output is sent to me via eMail in crontab e.g.: MAILTO:[EMAIL PROTECTED] 15 15 * * * lynx -dump http://www.myDomain.com/myScript.php That works fine

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located outside the doc root. I guess I could always include it onto a page On Mon, 2003-09-15 at

[PHP-DB] Weird MSSQL problem

2003-09-15 Thread Martin Greco
Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 set to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it retrieve no rows, and if i paste this query on the Query Analizer it works

[PHP-DB] Weird MSSQL problem

2003-09-15 Thread Martin Greco
Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 set to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it retrieve no rows, and if i paste this query on the Query Analizer it works

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
From: Jonathan Villa [EMAIL PROTECTED] wget -q -O - www.domain.com/cron.php /dev/null Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located

RE: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Ryan Marks
Not necessarily. You can wget /path/to/file.php or my personal preference is not to use wget, but php directly /path/to/php/executable /path/to/file.php Just a thought, Ryan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:28 PM To:

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
From: Ryan Marks [EMAIL PROTECTED] Not necessarily. You can wget /path/to/file.php or my personal preference is not to use wget, but php directly /path/to/php/executable /path/to/file.php Are you sure about that? I thought wget had to go through HTTP? This didn't work for me, am I doing it

RE: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
I believe this would need php to installed as a cgi, which I prefer not to do... On Mon, 2003-09-15 at 15:31, Ryan Marks wrote: Not necessarily. You can wget /path/to/file.php or my personal preference is not to use wget, but php directly /path/to/php/executable /path/to/file.php Just a

RE: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Ryan Marks
My bad... wget does require http or ftp protocol and a hostname that can be resolved by the server. -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:47 PM To: Ryan Marks; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB]

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Pat Lashley
--On Monday, September 15, 2003 15:27:45 -0500 Jonathan Villa [EMAIL PROTECTED] wrote: Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Matt Babineau
Goto your shell and type php -i w/o the quotes. You should see the phpinfo() output. You can pass the path to your script as a command line variable, and it will process it. Here, read about it, I think this is the right answer for you: http://us3.php.net/features.commandline Matt On Mon,

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
- Original Message - From: Pat Lashley [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 15, 2003 5:12 PM Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? --On Monday, September 15, 2003 15:27:45 -0500 Jonathan Villa [EMAIL PROTECTED]

[PHP-DB] Re: MS-SQL 2000 weird problem

2003-09-15 Thread Curt Zirzow
On Mon, 15 Sep 2003 15:21:41 -0300, Martin Greco [EMAIL PROTECTED] wrote: Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it

[PHP-DB] Re: [PHP] MS-SQL 2000 weird problem

2003-09-15 Thread Dan Anderson
Any thoughts? Are you dying and outputting an error where something could happen to bodge up the server? I'm not familiar with MS SQL Server, but I know under mysql: ?php $link = mysql_connect($host,$username,$password) or die(); // I forget the next line off the top of my head /* returns