php-windows Digest 21 Sep 2005 13:02:04 -0000 Issue 2781
Topics (messages 26366 through 26371):
Re: MySQL Problem
26366 by: Vincent Kruger
Zend Safeguard
26367 by: Joakim Ling
Re: Calling MSSQL Stored Procedure
26368 by: Robert Twitty
26369 by: Robert Twitty
26370 by: Alf Stockton
26371 by: Alf Stockton
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]
----------------------------------------------------------------------
--- Begin Message ---
Hey all,
Thanks for the help, but it's all seemed to start work the next day.
Sorry all about the double post, that was my bad.
:D
V
-----Original Message-----
From: Vincent Kruger [mailto:[EMAIL PROTECTED]
Sent: 19 September 2005 04:46 PM
To: [email protected]
Subject: [PHP-WIN] FW: MySQL Problem
-----Original Message-----
From: Vincent Kruger [mailto:[EMAIL PROTECTED]
Sent: 19 September 2005 04:42 PM
To: '[email protected]'
Subject: MySQL Problem
My php 5.0.5 doesn't want to load the mysql module and the libmysql file is
in the root directory of php I just can't seem to get it working. I've also
upgraded to mysql 4.1.12 but that’s working fine.
Please help.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 2005/09/16
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 2005/09/16
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 2005/09/16
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 2005/09/16
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 2005/09/16
--- End Message ---
--- Begin Message ---
Hi
Does Zend Safeguard Suite 3.6 works with PHP 5?
Cheers
--- End Message ---
--- Begin Message ---
The code will generate a blank screen if there are no reesults returned by
the stored procedure. Have you verified that the query performed by the
stored procedure will generate a result set for the current time? To
verify this, use strtotime( "YYYY-MM-DD HH:MM:SS" ) instead of time().
Make sure you call strtotime() with a date / time that you know will
generate a result set.
-- bob
On Tue, 20 Sep 2005, Alf Stockton wrote:
> Robert Twitty wrote:
>
> >Hi Alf
> >
> >Based on a previous posting, the code for the stored procedure
> >spGetActivePromotions does not return a value. Therefore, $ret is going to
> >be undefined. The procedure returns a result set that you must iterate
> >via $rs:
> >
> > while (!$rs->EOF) {
> > print_r($rs->fields);
> > $rs->MoveNext();
> > }
> >
> >
> >
> Hello Bob,
> I have tried the above and still I get a blank page back. No data no
> errors nothing. I have also looked in Apache logs and there is a
> reference in the access.log but nothing in the error.log.
> I have attached a copy of my program just in case you can see from that
> what I have done wrong.
> BTW I have attempted both dates with the same result.
> I have also checked and yes the ODBTP server is running as an Apache
> service.
>
> --
>
> Regards,
> Alf Stockton www.stockton.co.za
>
> Q: Why do firemen wear red suspenders?
> A: To conform with departmental regulations concerning uniform dress.
>
> My email disclaimer is available at www.stockton.co.za/disclaimer.html
>
>
--- End Message ---
--- Begin Message ---
IF the "echo $ActualDate" is not displaying, then is it possible that the
script is terminating before that statement? Also, to make sure your
ODBTP setup is working properly, run the following code after connecting:
$rs = $DB->Execute( "SELECT * FROM AnyTable" );
if( !$rs ) {
print $DB->ErrorMsg();
die;
}
while (!$rs->EOF) {
print_r($rs->fields);
$rs->MoveNext();
}
Also, you should enable ADODb debugging.
-- bob
> Bob,
> I added the following to my code but still no success.
> // $ActualDate = time();
> // $ActualDate = date('Y-m-d H:i:s', time());
> $ActualDate = strtotime("2005/05/16 06:00:00");
> echo $ActualDate;
> and I still get nothing back not even the echo $ActualDate ?
> BTW The date string above is/was copied directly out of the database.
>
> --
>
> Regards,
> Alf Stockton www.stockton.co.za
>
> Q: "What is the burning question on the mind of every dyslexic
> existentialist?"
> A: "Is there a dog?"
>
> My email disclaimer is available at www.stockton.co.za/disclaimer.html
>
>
--- End Message ---
--- Begin Message ---
Robert Twitty wrote:
The code will generate a blank screen if there are no reesults returned by
the stored procedure. Have you verified that the query performed by the
stored procedure will generate a result set for the current time? To
verify this, use strtotime( "YYYY-MM-DD HH:MM:SS" ) instead of time().
Make sure you call strtotime() with a date / time that you know will
generate a result set.
Bob,
I added the following to my code but still no success.
// $ActualDate = time();
// $ActualDate = date('Y-m-d H:i:s', time());
$ActualDate = strtotime("2005/05/16 06:00:00");
echo $ActualDate;
and I still get nothing back not even the echo $ActualDate ?
BTW The date string above is/was copied directly out of the database.
--
Regards,
Alf Stockton www.stockton.co.za
Q: "What is the burning question on the mind of every dyslexic
existentialist?"
A: "Is there a dog?"
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--- End Message ---
--- Begin Message ---
Robert Twitty wrote:
The ODBTP package includes 2 versions of php_odbtp.dll. One for PHP4 and
the other for PHP5. You need to place the correct php_odbtp.dll file in
the same directory where php_mssql.dll and the other extensions are
located. For PHP4, this should be php\extensions, and php\ext for PHP5.
You then need to place the follwwing entry into the php.ini file:
extension=php_odbtp.dll
Place it in the same section where the "extension=php_mssql.dll" entry is
located.
Thanks Bob. That with a few other alterations and now I get some valid data.
So now back to the original program and let us see if I can get that to
work.
--
Regards,
Alf Stockton www.stockton.co.za
Your object is to save the world, while still leading a pleasant life.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--- End Message ---
