[PHP-DB] PHP 4.3.4 + Oracle 9i + Apache 2.0.47
Hello, The system is Solaris sun4u sparc SUNW,UltraAX-i2, SunOS 5.8 i'm compiling this with a gcc 3.3. I'm trying to configure a PHP 4.3.4 with oracle oci8 support. i've pushed the vars for oracle in the enviroment ORACLE_BASE="/opt/oracle/app/oracle" export ORACLE_BASE ORACLE_HOME="/opt/oracle/app/oracle/product/9.2" export ORACLE_HOME LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/network/lib export LD_LIBRARY_PATH PATH=$PATH:$ORACLE_HOME/bin:/usr/ccs/bin: export PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib export CLASSPATH LC_LANG=de_DE export LC_LANG LC_ALL=de_DE export LC_ALL and the configure with this options run through: ./configure \ --disable-cli \ --without-pear \ --enable-sigchild \ --prefix=${APACHE_DIR}/ext/php-4.3.4 \ --with-apxs2=${APACHE_DIR}/bin/apxs \ --enable-ftp=shared \ --with-mysql=shared \ --enable-sysvsem \ --enable-sysvshm \ --with-oracle=$ORACLE_HOME \ --with-oci8=$ORACLE_HOME when i start to make the build all runs fine till the oci8 module compiling, then a whole bunch off missing functions and wrong syntaxes in the code showing up: /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1191: error: request for member `pError' in something not a structure or union /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1191: error: request for member `error' in something not a structure or union /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1196: error: invalid type argument of `->' /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1196: warning: passing arg 1 of `zend_list_insert' makes pointer from integer without a cast /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1197: error: invalid type argument of `->' /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1200: error: invalid type argument of `->' /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1202: warning: return makes pointer from integer without a cast /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: At top level: /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1210: error: parse error before '*' token /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: In function `_oci_get_ocicoll': /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1212: error: invalid operands to binary * /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1214: error: `id' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1218: error: `collection' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1218: error: invalid type argument of `unary *' /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1223: error: invalid type argument of `unary *' /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: At top level: /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1234: error: parse error before '*' token /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: In function `_oci_get_ocidesc': /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1236: error: `desc' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1238: error: `id' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1243: error: `descriptor' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: At top level: /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1255: error: parse error before '*' token /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: In function `_oci_make_zval': /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1258: error: `ub4' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1258: error: parse error before "loblen" /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1262: error: `column' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1267: error: `statement' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1268: error: `value' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1276: error: `SQLT_RDD' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1276: error: `mode' undeclared (first use in this function) /park/pub/source/www-rom/modules/php4/build/php-4.3.4/ex
[PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)
Apache on NT using MS SQL Srvr 2000 PHP 4.03pl1 I return these dates into strings and now I want to compare my database date to see if it is later than today's date. Pretty sure my "Expires" field is a string: Here is the "Expires" field from the SQL: Convert(varchar, DATEADD(Year,3,DateCertified),101) AS Expires Here is my PHP code trying to compare dates: $today = date("m/d/Y"); If ($today < odbc_result($data,"Expires")) { echo "License has expired"; } Else { echo "License has not expired"; } Sure could use a simple solution to a simple problem that has me simply confounded. - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
RE: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)
Strtotime() Look it up in the manual :-) -Original Message- From: Karen Resplendo [mailto:[EMAIL PROTECTED] Sent: den 7 november 2003 19:44 To: [EMAIL PROTECTED] Subject: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?) Apache on NT using MS SQL Srvr 2000 PHP 4.03pl1 I return these dates into strings and now I want to compare my database date to see if it is later than today's date. Pretty sure my "Expires" field is a string: Here is the "Expires" field from the SQL: Convert(varchar, DATEADD(Year,3,DateCertified),101) AS Expires Here is my PHP code trying to compare dates: $today = date("m/d/Y"); If ($today < odbc_result($data,"Expires")) { echo "License has expired"; } Else { echo "License has not expired"; } Sure could use a simple solution to a simple problem that has me simply confounded. - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)
On Saturday 08 November 2003 02:44, Karen Resplendo wrote: > Apache on NT using MS SQL Srvr 2000 > PHP 4.03pl1 > > I return these dates into strings and now I want to compare my database > date to see if it is later than today's date. Pretty sure my "Expires" > field is a string: > > Here is the "Expires" field from the SQL: > Convert(varchar, DATEADD(Year,3,DateCertified),101) AS Expires > > Here is my PHP code trying to compare dates: > > $today = date("m/d/Y"); > >If ($today < odbc_result($data,"Expires")) > { > echo "License has expired"; > } >Else > { > echo "License has not expired"; > } > > Sure could use a simple solution to a simple problem that has me simply > confounded. Why not just do the comparison directly within the query? And if you want to get the above working, have you tried debugging it? Like: print($today); print(odbc_result($data,"Expires")); Are they what you expected them to be? -- 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 -- /* Alaska: A prelude to "No." */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)
Yes, the values echo out the way I expect them. But these are displayed values, not dates, I'm pretty sure, and that is why the comparison is failing. The question began very simply. I will try to make it simpler: How do I compare a string date from a database to today's date using PHP? I can do it with my eyes closed in SQL. I don't want to if I can avoid it. Jason Wong <[EMAIL PROTECTED]> wrote: On Saturday 08 November 2003 02:44, Karen Resplendo wrote: > Apache on NT using MS SQL Srvr 2000 > PHP 4.03pl1 > > I return these dates into strings and now I want to compare my database > date to see if it is later than today's date. Pretty sure my "Expires" > field is a string: > > Here is the "Expires" field from the SQL: > Convert(varchar, DATEADD(Year,3,DateCertified),101) AS Expires > > Here is my PHP code trying to compare dates: > > $today = date("m/d/Y"); > > If ($today < odbc_result($data,"Expires")) > { > echo " License has expired "; > } > Else > { > echo " License has not expired "; > } > > Sure could use a simple solution to a simple problem that has me simply > confounded. Why not just do the comparison directly within the query? And if you want to get the above working, have you tried debugging it? Like: print($today); print(odbc_result($data,"Expires")); Are they what you expected them to be? -- 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 -- /* Alaska: A prelude to "No." */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)
On Saturday 08 November 2003 03:08, Karen Resplendo wrote: > Yes, the values echo out the way I expect them. But these are displayed > values, not dates, I'm pretty sure, and that is why the comparison is > failing. > > The question began very simply. I will try to make it simpler: > > How do I compare a string date from a database to today's date using PHP? The proper way would be to convert both to unix timestamps then a simple greater-than or equal-to comparison would suffice. > I can do it with my eyes closed in SQL. I don't want to if I can avoid it. It's more efficient to do so, so can I ask why you want to avoid it? -- 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 -- /* A truth that's told with bad intent Beats all the lies you can invent. -- William Blake */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)
Education :) (it seems like such a simple thing to do, to look up, to have in someone's library of code, yet. . . . . . .) > I can do it with my eyes closed in SQL. I don't want to if I can avoid it. It's more efficient to do so, so can I ask why you want to avoid it? -- 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 -- /* A truth that's told with bad intent Beats all the lies you can invent. -- William Blake */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
[PHP-DB] Strtotime works for date comparisons on nonUnix--thank you :)
$today = Strtotime(date("m/d/Y")); $expires=Strtotime(odbc_result($data,"Expires")); If ($today <= $expires) { echo "License has not expired"; } Else { echo "License has expired"; } :-P - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: [PHP-DB] Strtotime works for date comparisons on nonUnix--thank you :)
On Saturday 08 November 2003 03:43, Karen Resplendo wrote: >$today = Strtotime(date("m/d/Y")); >$expires=Strtotime(odbc_result($data,"Expires")); > >If ($today <= $expires) > { > echo "License has not expired"; > } >Else > { > echo "License has expired"; > } > > :-P Not sure what your subject is trying to convey, but strtotime() converts dates to unix timestamps, and works on all systems that PHP runs on - Windows/Unix/Linux/whatever. -- 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 -- /* Take your work seriously but never take yourself seriously; and do not take what happens either to yourself or your work seriously. -- Booth Tarkington */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Tristan Pretty is out of the office.
I will be out of the office starting 23/10/2003 and will not return until 11/11/2003. I will respond to your message when I return. Please contact Fiona or Alan for any issues. * The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] Adding a log file
Erik Osterman wrote: Consider using this // // STDERR logging function // function warn( $msg, $die = 0 ) { $fp = fopen("php://stderr", 'w') or die("Failed to open STDERR"); fwrite($fp, "[".strftime("%Y-%m-%d %T")."] $msg\n") or die("Failed to write to stderr"); fclose($fp); if($die) die($msg); } There is also the error_log() and syslog() functions. http://us2.php.net/error_log http://us2.php.net/syslog -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: [PHP] Adding a log file
Consider using this // // STDERR logging function // function warn( $msg, $die = 0 ) { $fp = fopen("php://stderr", 'w') or die("Failed to open STDERR"); fwrite($fp, "[".strftime("%Y-%m-%d %T")."] $msg\n") or die("Failed to write to stderr"); fclose($fp); if($die) die($msg); } This function will log all output to your Apache BASE error log. It's kind of like Perl's warn function for PHP. Also, it's good practice to use assertions... look into assert at http://php.net/assert Here is some sample usage... assert_options (ASSERT_ACTIVE, 1); assert_options (ASSERT_WARNING, 0); assert_options (ASSERT_QUIET_EVAL, 1); assert_options (ASSERT_BAIL, 1); // Create a handler function function assert_callback ($file, $line, $code) { $body = file($file); if(empty($code)) $code = trim($body[$line-1]); print "Assertion Failed: File '$file' Line '$line' Code '$code'"; warn("Assertion failed ($code) in $file on line $line '$code'"); print ""; } // Set up the callback assert_options (ASSERT_CALLBACK, 'assert_callback'); Regards, Erik Osterman http://osterman.com/ -Original Message- From: Robert Sossomon [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 7:38 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Adding a log file I am seeing some errors with a program I wrote and I need to write everything to a log file that the program is doing. The following syntax I KNOW is wrong, but not sure they are important to put here correctly yet. //script addtocart $Addcart (info1, info2) Mysqlquey($addcart) I am seeing random items NOT being added to my shopping cart. The reason, I have no clue. I can pull another catgory of items and the first 20 will do fine, I go back to the first category I have and the script seems to work correctly but the data is not written to the shopping cart. Problem with the shopping cart??? I wouldn't think so. Problem with the add page, I don't see how. So where is the error coming from? No clue, which is why I want to log everything. I use 3 different add pages so that each form uses a different way to add. This works for me, and seems to work rather well. But I need to log everything on the 3 forms to see where the errors are coming from. TIA! Robert ~~~ To rest is to rust. ~~~ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php