Re: [PHP-DB] Validation of multiple variables using single include file
See the thread at: http://www.phpbuilder.com/forum/read.php3?num=2id=163227thread=162776 for a php solution to this. Thanks to that Vincent chap over there in the netherlands. Russ On Tue, 13 Nov 2001 22:33:12 -0500 CK Raju [EMAIL PROTECTED] wrote: I use PHP with MySQL on Linux box. I have some 70 odd forms in one of my application, each with varying number of parameters. Is it possible to have a single function declared using JavaScript that can accept multiple variables as parameters for validation check, before the form is submitted. What would be the syntax ? ie at the end of the form I can just write onClick=validate(parameterA, parameterB, parameterC) Thanx in advance. CK Raju -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Next
I am writing a questionaire, am gonna include java timer etc... and it is written in PHP 4 and Mysql running on Apache. I have my questionaire database full of questions I randomly select say 40 questions. But rather than display the whole array on the screen I would like to have 1 question per page and a next button. I hope that makes sense any ideas anyone? Many thanks for you halp in advance. Peter -- Regards, Peter Allum Connect U Ltd ** Confidentiality: This email and its attachments are intended for the above name only and may be confidential. If they have come to you in error you must take no action based upon them, nor must you copy or show them to anyone. Please reply to this email and highlight the error. Security Warning: Please note that this email has been created in the knowledge that Internet email is not a 100% secure medium. We advise that you understand and observe this lack of security when emailing us. Viruses: Although we have taken steps to ensure that this email and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. [EMAIL PROTECTED] ** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] last update on...
I am looking for some automatation using MYSQL and PHP: All entries in a table have a date-field, so that our user are automatically informed about the last update of the corresponding entry, but not about the site's generall update. The idea is to look into the date-fields, select the latest entry and printing it into HTML (we make our updates only using the database, so one of our entries, but not always the last one, has the correct date). So we have the table: entry 1 / 2000-11-29 entry 2 / 2001-09-02 entry 3 / 2001-11-04 entry 4 / 2001-11-03 Obviously the second date's enrtry should be selected, but I have no idea how to do it... Thanks, Torsten Reimer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] last update on...
entry 1 / 2000-11-29 entry 2 / 2001-09-02 entry 3 / 2001-11-04 entry 4 / 2001-11-03 Obviously the second date's enrtry should be selected, but I have no idea how to do it... Sorry, it has to be the third entry... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Next
Use sessions. (session_start() and session_register()), and at the start of the test save row_ids(question_ids) in arrray which you make with session_register a session variable. On other pages you do session_start() and after that you have access to the array. Regards, Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Peter Allum [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 11:37 AM Subject: [PHP-DB] Next I am writing a questionaire, am gonna include java timer etc... and it is written in PHP 4 and Mysql running on Apache. I have my questionaire database full of questions I randomly select say 40 questions. But rather than display the whole array on the screen I would like to have 1 question per page and a next button. I hope that makes sense any ideas anyone? Many thanks for you halp in advance. Peter -- Regards, Peter Allum Connect U Ltd ** Confidentiality: This email and its attachments are intended for the above name only and may be confidential. If they have come to you in error you must take no action based upon them, nor must you copy or show them to anyone. Please reply to this email and highlight the error. Security Warning: Please note that this email has been created in the knowledge that Internet email is not a 100% secure medium. We advise that you understand and observe this lack of security when emailing us. Viruses: Although we have taken steps to ensure that this email and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. [EMAIL PROTECTED] ** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] last update on...
I am looking for some automatation using MYSQL and PHP: All entries in a table have a date-field, so that our user are automatically informed about the last update of the corresponding entry, but not about the site's generall update. The idea is to look into the date-fields, select the latest entry and printing it into HTML (we make our updates only using the database, so one of our entries, but not always the last one, has the correct date). So we have the table: entry 1 / 2000-11-29 entry 2 / 2001-09-02 entry 3 / 2001-11-04 entry 4 / 2001-11-03 Obviously the second date's enrtry should be selected, but I have no idea how to do it... If you only need that 3rd entry (ie the latest date's record) a simple SELECT columns FROM table ORDER BY date DESC LIMIT 1; will provide you with the record with the latest date (of course you can add a where clause to tell MySQL which records should be even considered for selection) Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Next
Pass the current question number in a parameter to the next page in the URL. In the following, the PHP variable would track your current page: print A href=\myform.php3?page=$page\Next/A; - then, in myform.php3: ?php $page++; display the question for this page ? -Original Message- From: Peter Allum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 3:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Next I am writing a questionaire, am gonna include java timer etc... and it is written in PHP 4 and Mysql running on Apache. I have my questionaire database full of questions I randomly select say 40 questions. But rather than display the whole array on the screen I would like to have 1 question per page and a next button. I hope that makes sense any ideas anyone? Many thanks for you halp in advance. Peter -- Regards, Peter Allum Connect U Ltd ** Confidentiality: This email and its attachments are intended for the above name only and may be confidential. If they have come to you in error you must take no action based upon them, nor must you copy or show them to anyone. Please reply to this email and highlight the error. Security Warning: Please note that this email has been created in the knowledge that Internet email is not a 100% secure medium. We advise that you understand and observe this lack of security when emailing us. Viruses: Although we have taken steps to ensure that this email and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. [EMAIL PROTECTED] ** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Access with PHP on Linux?
Steve, To clarify, you cannot run Access on Linux. You can install ODBC support for PHP on Linux, and use ODBC drivers to talk to an Access db on Windows. ODBC support for PHP under Linux requires linking PHP with an ODBC Driver Manager. iODBC (www.iodbc.org) is your best bet, and there are HOWTO's on that site for linking --with-iodbc. Also, you will need ODBC drivers; OpenLink provides a free download of our commercial drivers at www.openlinksw.com. Please let me know if you require further assistance. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Steve Farmer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 10:32 PM To: Andreas D. Landmark; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Access with PHP on Linux? Hi Andreas, At 11:54 PM + 13/11/01, Andreas D. Landmark wrote: At 13.11.2001 23:23, Chris Payne wrote: Hi there everyone, [snip] I want to keep it an access DB if possible as i've had problems changing the DB to MySQL. Install ODBC, that would let you interface with degenerate database formats as access et al. When you say install ODBC, I assume you mean on the Linux box. Could you give me a pointer as to the best way to achieve this ? [snip -- Andreas D Landmark / noXtension Regards Steve -- - Minds are like parachutes, they work best when open Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: file upload, again
To get around this, I made a small shell script which runs as root. The php page calls the script via the system call. All the shell script does is move a specific file from tmp to a specific location. I'm probably asking for someone to exploit it, but I don't know exactly what they can do. -Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: file upload, again
Look in you apache.conf file and find out what user the web server runs as, then give that user the right to write to that directory, probably through a group used for nothing else is most secure. Brian Mauter wrote: To get around this, I made a small shell script which runs as root. The php page calls the script via the system call. All the shell script does is move a specific file from tmp to a specific location. I'm probably asking for someone to exploit it, but I don't know exactly what they can do. -Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] image content in mail().
Hi, Who can I send an HTML e-mail with a image with mail()? Can PHP encode the image for me? Thank's Bruno. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Move next
Do we have a matching command for rs.movelast in PHP to get the data in the last record of the array $row=mysql_fetch_array($result); Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Move next
use count() to determine number of elements in the array. Then use the returned result as an index to the last element. Or, do you want to get to the last row of a result set from a mysql query? In which case, go with: $result = mysql_query(...)... $rows = mysql_num_rows($result); mysql_data_seek($result,$rows); -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:51 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Move next Do we have a matching command for rs.movelast in PHP to get the data in the last record of the array $row=mysql_fetch_array($result); Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] parse/fatal errors
Hi, I'm trying to get a BBS http://phpboard.thelinuxcommunity.org/ running on our intranet and I'm experiencing a lot of difficulty. I'm running FreeBSD 4.4 with current versions of MySQL and Apache + php4 I followed the INSTALL instructions for phpBoard and they seemed fairly simple but when I point a browser to the BBS directory, I get the following: Parse error: parse error, expecting `T_VARIABLE' or `'$'' in /usr/local/share/doc/apache/phpboard/config_inc.php3 on line 178 (Line 178 is $user_table_name = 'users';) Fatal error: Failed opening required 'sql_inc.php3' (include_path ='.:/usr/local/lib/php') in /usr/local/share/doc/apache/phpboard/index.php on line 24 (Line 24 isrequire $inc_dir . sql_inc.php3;) phpBoard includes a perl script that you can use to change your scripts extensions. So, if your extensions are .php, you can change them to .html, .php3 or even .phtml When I convert everything to .phtml and point a browser at the BBS directory, it lists the file contents of the directory. Can anybody help? Thanks Joe Joe Warner | Sr. Operations Technical Analyst | Siemens Health Services | 215 N. Admiral Byrd Road | Salt Lake City, UT 84116 | Ph: 801-539-4978 | Fax: 801-533-8004 | [EMAIL PROTECTED] --- This message and any included attachments are from Siemens Medical Solutions Health Services Corporation and are intended only for the addressee(s). The information contained herein may include trade secrets or privileged or otherwise confidential information. Unauthorized review, forwarding, printing, copying, distributing, or using such information is strictly prohibited and may be unlawful. If you received this message in error, or have reason to believe you are not authorized to receive it, please promptly delete this message and notify the sender by e-mail with a copy to [EMAIL PROTECTED] Thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] parse/fatal errors
Unless you show us the offending source code indicated by the error message, we can't help -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] parse/fatal errors Hi, I'm trying to get a BBS http://phpboard.thelinuxcommunity.org/ running on our intranet and I'm experiencing a lot of difficulty. I'm running FreeBSD 4.4 with current versions of MySQL and Apache + php4 I followed the INSTALL instructions for phpBoard and they seemed fairly simple but when I point a browser to the BBS directory, I get the following: Parse error: parse error, expecting `T_VARIABLE' or `'$'' in /usr/local/share/doc/apache/phpboard/config_inc.php3 on line 178 (Line 178 is $user_table_name = 'users';) Fatal error: Failed opening required 'sql_inc.php3' (include_path ='.:/usr/local/lib/php') in /usr/local/share/doc/apache/phpboard/index.php on line 24 (Line 24 isrequire $inc_dir . sql_inc.php3;) phpBoard includes a perl script that you can use to change your scripts extensions. So, if your extensions are .php, you can change them to .html, .php3 or even .phtml When I convert everything to .phtml and point a browser at the BBS directory, it lists the file contents of the directory. Can anybody help? Thanks Joe Joe Warner | Sr. Operations Technical Analyst | Siemens Health Services | 215 N. Admiral Byrd Road | Salt Lake City, UT 84116 | Ph: 801-539-4978 | Fax: 801-533-8004 | [EMAIL PROTECTED] --- This message and any included attachments are from Siemens Medical Solutions Health Services Corporation and are intended only for the addressee(s). The information contained herein may include trade secrets or privileged or otherwise confidential information. Unauthorized review, forwarding, printing, copying, distributing, or using such information is strictly prohibited and may be unlawful. If you received this message in error, or have reason to believe you are not authorized to receive it, please promptly delete this message and notify the sender by e-mail with a copy to [EMAIL PROTECTED] Thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] About Berkeley DB2 Databases
Hello, I read a paper about Berkeley DB2 databases and I have a few doubts about PHP db2 support I compiled my php with --with-db2 option... 1) How can I create a Berkeley db2 database with the Berkeley DB Concurrent Access Method I want. Let's say... a B+Tree ... or hash method. USING php. 2) How can I use structured data (like objects) as values of a Berkeley database USING php (I read http://www.dst.usb.ve/manuales/php-eng/function.dba-insert.html function, but it assumes only a string). Thank you very much, Ricardo Núñez [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] parse/fatal errors
Unless you show us the offending source code indicated by the error message, we can't help OK, what should I post? Do you want me to post the contents of all the files referenced by the error messages? e.g.- config_inc.php3, sql_inc.php3 and index.php ? Thanks Joe Joe Warner | Sr. Operations Technical Analyst | Siemens Health Services | 215 N. Admiral Byrd Road | Salt Lake City, UT 84116 | Ph: 801-539-4978 | Fax: 801-533-8004 | [EMAIL PROTECTED] Rick Emery remery@excel. To: '[EMAIL PROTECTED]' com [EMAIL PROTECTED], [EMAIL PROTECTED] cc: 11/14/2001 Subject: RE: [PHP-DB] parse/fatal errors 12:09 PM Unless you show us the offending source code indicated by the error message, we can't help -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] parse/fatal errors Hi, I'm trying to get a BBS http://phpboard.thelinuxcommunity.org/ running on our intranet and I'm experiencing a lot of difficulty. I'm running FreeBSD 4.4 with current versions of MySQL and Apache + php4 I followed the INSTALL instructions for phpBoard and they seemed fairly simple but when I point a browser to the BBS directory, I get the following: Parse error: parse error, expecting `T_VARIABLE' or `'$'' in /usr/local/share/doc/apache/phpboard/config_inc.php3 on line 178 (Line 178 is $user_table_name = 'users';) Fatal error: Failed opening required 'sql_inc.php3' (include_path ='.:/usr/local/lib/php') in /usr/local/share/doc/apache/phpboard/index.php on line 24 (Line 24 isrequire $inc_dir . sql_inc.php3;) phpBoard includes a perl script that you can use to change your scripts extensions. So, if your extensions are .php, you can change them to .html, .php3 or even .phtml When I convert everything to .phtml and point a browser at the BBS directory, it lists the file contents of the directory. Can anybody help? Thanks Joe Joe Warner | Sr. Operations Technical Analyst | Siemens Health Services | 215 N. Admiral Byrd Road | Salt Lake City, UT 84116 | Ph: 801-539-4978 | Fax: 801-533-8004 | [EMAIL PROTECTED] --- This message and any included attachments are from Siemens Medical Solutions Health Services Corporation and are intended only for the addressee(s). The information contained herein may include trade secrets or privileged or otherwise confidential information. Unauthorized review, forwarding, printing, copying, distributing, or using such information is strictly prohibited and may be unlawful. If you received this message in error, or have reason to believe you are not authorized to receive it, please promptly delete this message and notify the sender by e-mail with a copy to [EMAIL PROTECTED] Thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- This message and any included attachments are from Siemens Medical Solutions Health Services Corporation and are intended only for the addressee(s). The information contained herein may include trade secrets or privileged or otherwise confidential information. Unauthorized review, forwarding, printing, copying, distributing, or using such information is strictly prohibited and may be unlawful. If you received this message in error, or have reason to believe you are not authorized to receive it, please promptly delete this message and notify the sender by e-mail with a copy to [EMAIL PROTECTED] Thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] About Berkeley DB2 Databases
I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has DB2 got to do with Berkeley? An I suffering a bit of confusion between IBM's DB2 product, and Berkeley database tables, and PHP's support of these? -Lorenzo -Original Message- From: Ricardo Núñez Sent: Wed 11/14/2001 2:21 PM To: [EMAIL PROTECTED] Cc: Subject: [PHP-DB] About Berkeley DB2 Databases Hello, I read a paper about Berkeley DB2 databases and I have a few doubts about PHP db2 support I compiled my php with --with-db2 option... 1) How can I create a Berkeley db2 database with the Berkeley DB Concurrent Access Method I want. Let's say... a B+Tree ... or hash method. USING php. 2) How can I use structured data (like objects) as values of a Berkeley database USING php (I read http://www.dst.usb.ve/manuales/php-eng/function.dba-insert.html function, but it assumes only a string). Thank you very much, Ricardo Núñez [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Oracle via php under windows 2k
Hello These are pretty basic questions, but I would appreciate help: I need to access Oracle (already running on a separate server) via PHP4/Apache from a windows system. 1) Can this be done? (It will be possible with php scripts but i've oci8 errors) 2) Where do I find instructions? 3) Where do I get php_oci8 ?? i need to rebuild php ? I would find php4 with oci8 extension ready yet ! :) Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle via php under windows 2k
I don't use oracle with my windows php but in my extensions directory there is a php_oci8.dll. Do you have it? did you uncomment the line in your php.ini? If you installed your php from the installer, probably you don't have this file. download the zipped file from www.php.net and extract the extensions in your extensions_dir. If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Hope I don't sad a lot of things you've done before. Bruno. - Original Message - From: titanesk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 6:07 PM Subject: [PHP-DB] Oracle via php under windows 2k Hello These are pretty basic questions, but I would appreciate help: I need to access Oracle (already running on a separate server) via PHP4/Apache from a windows system. 1) Can this be done? (It will be possible with php scripts but i've oci8 errors) 2) Where do I find instructions? 3) Where do I get php_oci8 ?? i need to rebuild php ? I would find php4 with oci8 extension ready yet ! :) Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] About Berkeley DB2 Databases
Mensaje citado por: Gonzalez, Lorenzo [EMAIL PROTECTED]: I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has DB2 got to do with Berkeley? An I suffering a bit of confusion between IBM's DB2 product, and Berkeley database tables, and PHP's support of these? I can tell you that IBM DB2 is a RELATIONAL Database Management system, but Berkeley Databases are not, but the could be the BASE of a relational database management system (if you want read http://www.sleepycat.com/docs/ref/refs/bdb_usenix.html). --with-db2 include BERKELEY DB2 (BERKELEY Databases version # 2) support. --with-ibm-db2 IS the option to include IBM DB2 support. I'm learning about Berkeley DB2 files because the are used in Linux systems and the are efficient. -Lorenzo -Original Message- From: Ricardo Núñez Sent: Wed 11/14/2001 2:21 PM To: [EMAIL PROTECTED] Cc: Subject: [PHP-DB] About Berkeley DB2 Databases Hello, I read a paper about Berkeley DB2 databases and I have a few doubts about PHP db2 support I compiled my php with --with-db2 option... 1) How can I create a Berkeley db2 database with the Berkeley DB Concurrent Access Method I want. Let's say... a B+Tree ... or hash method. USING php. 2) How can I use structured data (like objects) as values of a Berkeley database USING php (I read http://www.dst.usb.ve/manuales/php-eng/function.dba-insert.html function, but it assumes only a string). Thank you very much, Ricardo Núñez [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] Saludos, Ing. Ricardo Núñez Webmaster de la DST Universidad Simón Bolívar E-Mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] About Berkeley DB2 Databases
On Wed, 14 Nov 2001 16:27:20 -0400 (VET) Ricardo Núñez [EMAIL PROTECTED] wrote: Mensaje citado por: Gonzalez, Lorenzo [EMAIL PROTECTED]: I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has DB2 got to do with Berkeley? An I suffering a bit of confusion between IBM's DB2 product, and Berkeley database tables, and PHP's support of these? I can tell you that IBM DB2 is a RELATIONAL Database Management system, but Berkeley Databases are not, but the could be the BASE of a relational database management system (if you want read http://www.sleepycat.com/docs/ref/refs/bdb_usenix.html). --with-db2 include BERKELEY DB2 (BERKELEY Databases version # 2) support. --with-ibm-db2 IS the option to include IBM DB2 support. I'm learning about Berkeley DB2 files because the are used in Linux systems and the are efficient. I never successed to install php with Berk. db2 support. db3 with dba works fine (except a bug, store extra suffs when create a new db, in my case it's the script itself...). Any tips welcome. pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] About Berkeley DB2 Db Nr. 2
Hello again, Nr. 2 I compiled my php with --with-db2 option... 1) Does PHP support Berkeley DB2 concurrency control? How? 2) Does PHP support Berkeley DB2 transaction control? How? Thank you very much, Ricardo Núñez [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Need Help on subtract Time
Hi everyone, I have a table with those field. ---Username, Uid, and Time. Ok, I tried to select data which their time is 2 min less from the current time or so. Could anyone help me out, How to do it? This is what I got, but doesn't work. select * from tablename where time date(H:i:s,(time()-720)); Please help!!! Thanks. Kelvin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] About Berkeley DB2 Databases
Hi, systems and the are efficient. I never successed to install php with Berk. db2 support. db3 with dba works fine (except a bug, store extra suffs when create a new db, in my case it's the script itself...). Any tips welcome. I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. Saludos, Ing. Ricardo Núñez Webmaster de la DST Universidad Simón Bolívar E-Mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] About Berkeley DB2 Databases
I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have ? any link ? (or email :) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Need Help on subtract Time
select * from tablename where time now() - interval 2 minute this assumes the field time is defined as TIMESTAMP -Original Message- From: kelvin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 2:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need Help on subtract Time Hi everyone, I have a table with those field. ---Username, Uid, and Time. Ok, I tried to select data which their time is 2 min less from the current time or so. Could anyone help me out, How to do it? This is what I got, but doesn't work. select * from tablename where time date(H:i:s,(time()-720)); Please help!!! Thanks. Kelvin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] About Berkeley DB2 Databases
Mensaje citado por: Pierre-Alain Joye [EMAIL PROTECTED]: I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have ? any link ? (or email :) No problem, but... I don't remember the command to list the libraries... What's the command? What if I send you a 'rpm -qa'? pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] Saludos, Ing. Ricardo Núñez Webmaster de la DST Universidad Simón Bolívar E-Mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] About Berkeley DB2 Databases
Thanks for the clarification of --with-db2 vs. --with-ibm-db2 ... silly me! To list your libraries: ldconfig -p Cheers, Lorenzo -Original Message- From: Ricardo Núñez Sent: Wed 11/14/2001 3:56 PM To: Pierre-Alain Joye Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] About Berkeley DB2 Databases Mensaje citado por: Pierre-Alain Joye [EMAIL PROTECTED]: I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have ? any link ? (or email :) No problem, but... I don't remember the command to list the libraries... What's the command? What if I send you a 'rpm -qa'? pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] Saludos, Ing. Ricardo Núñez Webmaster de la DST Universidad Simón Bolívar E-Mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] About Berkeley DB2 Databases
On Wed, 14 Nov 2001 16:56:47 -0400 (VET) Ricardo Núñez [EMAIL PROTECTED] wrote: Mensaje citado por: Pierre-Alain Joye [EMAIL PROTECTED]: I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have ? any link ? (or email :) ldconfig -p | grep db :) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle via php under windows 2k
If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Yes, the oracle 8 client has to be installed onto the server : it's the middleware between Oracle and the client. See your oracle dba. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
