Re: [PHP-DB] win32 Timestamp problem
On Wednesday 10 March 2004 04:36, J. Kevin C. Burton wrote: Hey all, after reading documentation on the Win32 bug regarding Timestamps not being able to go prior than 1970.. I am in need of a way to calculate someone's age. Has anyone found a fix or workaround for this bug? Or a way to calculate age without using the timestamp? As you're asking on the PHP-DB list I would assume that your dates are stored in a database of some sort, in which case you could use your database's native functions to do your date calculations. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Neither spread the germs of gossip nor encourage others to do so. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] JPGRAPH, problem...
On Sunday 08 February 2004 05:16, Carlos D. Carrasco wrote: You're asking on the wrong list. As your problem does not involve the use of databases with PHP it should be asked on the php-general list. Also your clock is about a month slow, please fix it. I did resolve my problem about the graphic X,Y, very interesting, but CAN NOT include the image in the middle of a text, it say that can not start nothing befor the ?php please if you have did something with this library and solve this problem, let me know how. You cannot just output image data in the middle of an HTML page. All images in an HTML page are separate files and are each requested separately by your browser. Thus in your page where you want your image to appear you need your img tag looking something like: img src=/path/to/your/image_generation_script.php?optional_parameter_a=1 image_generation_script.php will obviously be the script that creates the graph and outputs the image. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Life is like a bowl of soup with hairs floating on it. You have to eat it nevertheless. -- Flaubert */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] win32 Timestamp problem
On 09 March 2004 20:36, J. Kevin C. Burton wrote: Hey all, after reading documentation on the Win32 bug regarding Timestamps not being able to go prior than 1970.. I am in need of a way to calculate someone's age. Has anyone found a fix or workaround for this bug? Or a way to calculate age without using the timestamp? They say that v5 of PHP will fix this issue, but I've been using every stable release of PHP5 and it's a no go. No, it won't. It's an operating system issue, and nothing PHP *can* fix. Any help would be appreciated. Have you looked at the Calendar extension? http://www.php.net/calendar Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: [EMAIL PROTECTED] Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] win32 Timestamp problem
Will this fit you needs? ?php $birthdate=xx.xx.; $parth=explode(.,$birthdate); $seconds=mktime(0,0,0,$parth[1],$parth[0],$parth[2]); $seconds=time()-$seconds; $age=date(Y,$seconds)-1970; echo $age; ? Am Mittwoch, 10. März 2004 12:31 schrieb Ford, Mike [LSS]: On 09 March 2004 20:36, J. Kevin C. Burton wrote: Hey all, after reading documentation on the Win32 bug regarding Timestamps not being able to go prior than 1970.. I am in need of a way to calculate someone's age. Has anyone found a fix or workaround for this bug? Or a way to calculate age without using the timestamp? They say that v5 of PHP will fix this issue, but I've been using every stable release of PHP5 and it's a no go. No, it won't. It's an operating system issue, and nothing PHP *can* fix. Any help would be appreciated. Have you looked at the Calendar extension? http://www.php.net/calendar Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: [EMAIL PROTECTED] Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- Sebastian Mangelkramer IMAC - Information Management Consulting Blarerstraße 56, D-78462 Konstanz Tel. +49 (0)7531 - 90 39-12 Fax +49 (0)7531 - 90 39-47 E-Mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] win32 Timestamp problem
Hi, See http://php.weblogs.com/adodb_date_time_library I wrote this to fix this problem. INTRODUCTION PHP native date functions use integer timestamps for computations. Because of this, dates are restricted to the years 1901-2038 on Unix and 1970-2038 on Windows due to integer overflow for dates beyond those years. This library overcomes these limitations by replacing the native function's signed integers (normally 32-bits) with PHP floating point numbers (normally 64-bits). Mike Ford [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On 09 March 2004 20:36, J. Kevin C. Burton wrote: Hey all, after reading documentation on the Win32 bug regarding Timestamps not being able to go prior than 1970.. I am in need of a way to calculate someone's age. Has anyone found a fix or workaround for this bug? Or a way to calculate age without using the timestamp? They say that v5 of PHP will fix this issue, but I've been using every stable release of PHP5 and it's a no go. No, it won't. It's an operating system issue, and nothing PHP *can* fix. Any help would be appreciated. Have you looked at the Calendar extension? http://www.php.net/calendar Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: [EMAIL PROTECTED] Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP5B5 + Oracle9i + Apache1.3
Hi, same here [Wed Mar 10 14:42:10 2004] [notice] child pid 11646 exit signal Segmentation fault (11) [Wed Mar 10 14:42:10 2004] [notice] child pid 11648 exit signal Segmentation fault (11) [Wed Mar 10 14:42:10 2004] [notice] child pid 11649 exit signal Segmentation fault (11) but with PHP5b4 / Oracle 9.2 / Apache 1.3.29 Benjamin Php.Net [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] Hallo I have a trouble with PHP5Beta4 + Oracle9i + Apache1.3. When I start Apache it fails with Error 1067: The process terminated unexpectelly. When I change PHP5Beta4 to PHP4.3.4 it works fine. Can you help me? Thanks, Josef -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] getting BLOBS (ORACLE) back to filesystem
Elke Stahl wrote:
i successfully stored blobs in an oracle table via php. but it seems to be
impossible getting them back to filesystem!
It is a binary (no picture or executable) which arives via mail and is
written into a unix-filesystem.
ive stored this binary as blob datatype together with other informations in
a table with the help of a php-script. afterwards the binary will be deleted
from filesystem.
If the binary is to be used again, it should be read out of the database and
written back into the unix-filesystem.
I need a solution for the last part.
Maybe something like:
$query = 'SELECT BLOBDATA FROM BTAB WHERE BLOBID = '.MYBLOBID;
$stmt = OCIParse ($conn, $query);
OCIExecute($stmt, OCI_DEFAULT);
OCIFetchInto($stmt, $arr, OCI_ASSOC);
$result = $arr['BLOBDATA']-load();
$fh = fopen('c:/temp/sometempfile.pdf', 'wb');
fwrite($fh, $result);
fclose($fh);
Depending how the file is to be used, maybe it is worth checking
whether it really needs to be written back to the filesystem. For
example files stored in Oracle 9i can be accessed directly by a URL.
Another example: the PL/SQL UTL_SMTP package could be used to mail it.
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP5B5 + Oracle9i + Apache1.3
Josef Suchanek wrote: my platform is W2K or WXP. For the first I tried Apache 1.3.22 included in Oracle 9i installation with bad result. Then I tested Apache 1.3.29 with the same bad result. Then I tried IIS without problem and last test was with Apache 2.0.48. It worked fine too. What about logging a PHP bug? When I tested apache 1.3.xx without oci8 module web server started and worked well but when I uncommented oci8 module then apache crashed in all cases. All binaries was downloaded directly from apache.net without my recompilation. Can you try the latest PHP5 snapshot from snaps.php.net? If you log a bug the maintainers will want this. Bad think is that there are two web server releases on computer. That's all. I have 1.3.28 and 2.0.47. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
