Re: [PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-16 Thread Brad Hubbard
On Tue, 16 Apr 2002 14:51, Manuel Lemos did align ASCII characters thusly: then stored in cookie. The security weakness of this method is that if the secret key leaks, hackers may use to forge new sessions. Is this documented anywhere? Anyway what part didn't you understand? I think

Re: [PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-16 Thread Manuel Lemos
Hello, Brad Hubbard wrote: On Tue, 16 Apr 2002 14:51, Manuel Lemos did align ASCII characters thusly: then stored in cookie. The security weakness of this method is that if the secret key leaks, hackers may use to forge new sessions. Is this documented anywhere? Anyway what

[PHP-DB] url structure /articles/region/date/id

2002-04-16 Thread olinux
This question comes about from these two fine articles Building Dynamic Pages With Search Engines in Mind http://www.phpbuilder.com/columns/tim2526.php3 Search Engine-Friendly URLs http://www.promotionbase.com/article/485 I have a database of articles with atributes region date and id - how

[PHP-DB] Tutorials

2002-04-16 Thread Barry Rumsey
Are there any good tutorials for beginners on forms and inserts into mulit-tables ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to turn off error display

2002-04-16 Thread bob parker
In the code shown below, everything works ok but php displays an error message when pg_fetch_row tries to access beyond the last row. How can I turn the error display off? // exec query $result = pg_exec($dbcon, $sql); $i = 0; while (($row = pg_fetch_row(

Re: [PHP-DB] How to turn off error display

2002-04-16 Thread bob parker
On Tuesday 16 April 2002 22:30, you wrote: I believe what you are looking for is: pg_fetch_row( $result, $i++ ) But check the manual for . =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * Thanks, I think that's it Bob Parker -- PHP Database Mailing List

[PHP-DB] Query

2002-04-16 Thread Jeroen Timmers
hello, i have a table with a datetime field, now i want to view al the records with time 12:00:00 and the date is not important. Who could help me? Jeroen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Oracel 9i connection problems.

2002-04-16 Thread Paul Edmondson
OK just tested against Apache-1.3.23 with the same result apache seg faults. Apache configured as before. PHP configured as before except with --with-apxs= Extra information: ldd /usr/local/apache-1.3.23/bin/httpd libpthread.so.0 = /lib/libpthread.so.0 (0x40016000)

RE: [PHP-DB] Oracel 9i connection problems.

2002-04-16 Thread Pedro . Sere
Put this on your php page Putenv(ORACLE_HOME=/home/oracle/8.0.5); Putenv(LD_LIBRARY_PATH=/home/oracle/8.0.5/lib); Putenv(TWO_TASK=WAGNER_PC); and test it work with version 8 Pedro SERE P.SERE EU - COMMISSION - SG Internal Information

[PHP-DB] Can Anyone Spare A Few Minutes

2002-04-16 Thread Bzdpltd
Hi there all, I wonder if there are any people on this list who have much experience using sessions. We have a catalogue, and I have never used sessions before, and finding it very difficult to complete this project. If there is anyone who could possibly spare some time, I would most

Re: [PHP-DB] Oracel 9i connection problems.

2002-04-16 Thread Thies C. Arntzen
On Tue, Apr 16, 2002 at 06:28:19PM +0200, [EMAIL PROTECTED] wrote: Put this on your php page Putenv(ORACLE_HOME=/home/oracle/8.0.5); Putenv(LD_LIBRARY_PATH=/home/oracle/8.0.5/lib); Putenv(TWO_TASK=WAGNER_PC); no. do not use PutEnv or SetEnv in httpd.conf! please set _ALL_ needed

[PHP-DB] PHP to Fax

2002-04-16 Thread Jonathan Hilgeman
Okay, this is a new one. I'm trying to figure out the best way to send a GIF or JPG image to a fax machine using PHP and probably some other service (since I can't think of any PHP functions that deal with faxing). #1 Now, does anyone know of a good service that I could use that would work well

Re: [PHP-DB] cron job and php

2002-04-16 Thread Harpreet Kaur
Thanks Lisi. The use of php in front of the path made /home/harpreet/crontest.php run one time when run from the telnet prompt. But it still doesnt run from the crontab. I created a mycron.txt file with the below statement. The put crontab mysql.txt to specify the cron. But it doesnt seem to

Re[2]: [PHP-DB] cron job and php

2002-04-16 Thread Julie Meloni
At 03:54 PM 4/16/02 +, Harpreet Kaur wrote: Can i run a php page using a crontab job. I am trying to do so but no luck. My cron job statement is : * * * * * lynx /home/harpreet/crontest.php Actually i want to run a script every 10 minutes to do some background job like we do in sql server.

Re: [PHP-DB] cron job and php

2002-04-16 Thread Steve Cayford
Where is your php binary? (try which php) The command path under crontab is not always the same as in a login shell, so you might need to spell it out like: */10 * * * * /usr/local/bin/php /home/harpreet/crontest.php -Steve On Tuesday, April 16, 2002, at 12:17 PM, Harpreet Kaur wrote:

Re: [PHP-DB] PHP to Fax

2002-04-16 Thread Jason Wong
On Wednesday 17 April 2002 00:36, Jonathan Hilgeman wrote: #2 Does anyone know about fax servers or how to obtain one? If using *nix then www.hylafax.org. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] Re: LOBS with CURSOR_SHARING=FORCE gives core dump

2002-04-16 Thread Prince
Hi Thies, Thanks for the response. I already talked to oracle support and they said they won't support PHP as they believe its not an OCI problem. Anyway, I will send you the C program (sample program shipped with oracle) I was testing with. You can also find a simple PL/SQL progragram

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-16 Thread Frank Flynn
Picture a Church, full of pews. This is your empty table. As people (your data) come in to the church they fill the pews but unlike real life the first person goes all the way to the left hand side of the first pew, the second sits next to them and the third... When one pew is full they start

[PHP-DB] results on multiple pages

2002-04-16 Thread James Kupernik
I am retrieve records from my MySQL table and I want to display the results 12 per page along with allow for a sort. I was just send a query to the table with a limit each time, but it didn't sort all the records, so I need to load all the results into a table to sort then display. Here is what I

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-16 Thread Lisi
Thanks for the explanation! Very clear. How do you know how fragmented your DB is? I apologize if this is covered somewhere, like I said I was very confused buy this whole topic. Thanks, -Lisi At 01:00 PM 4/16/02 -0700, Frank Flynn wrote: Picture a Church, full of pews. This is your

Re: [PHP-DB] results on multiple pages

2002-04-16 Thread Richard Emery
Why don't you let mysql sort and limit the records for you? That's easy enough. Just keep track of where you are in the database and select only the records that you need. - Original Message - From: James Kupernik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002

RE: [PHP-DB] Delete from mysql table is there a way to....

2002-04-16 Thread Gurhan Ozen
The tables gets fragmented as deletions, updates take place on a table. If the DB operations get slower on a table, there is a good possibility that the table has been fragmented.. If you are using MySQL , you can use CHECK TABLE or myisamchk periodically to check your tables. See:

[PHP-DB] Inserting a String Variable into mysql_query() returns Query was empty error

2002-04-16 Thread eat pasta type fasta
I am creating a string out of bunch of variables and an array and I need it to become a query which will make me a table. It looks like this when I echo it: CREATE TABLE How Are You (Reply1 VARCHAR(255), Reply2 VARCHAR(255), Reply3 VARCHAR(255), Reply4 VARCHAR(255), Reply5 VARCHAR(255), date

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-16 Thread Frank Flynn
On 4/16/02 2:34 PM, Lisi [EMAIL PROTECTED] wrote: Thanks for the explanation! Very clear. How do you know how fragmented your DB is? I apologize if this is covered somewhere, like I said I was very confused buy this whole topic. Thanks, -Lisi Oh, sorry each database is different but

Re: [PHP-DB] results on multiple pages

2002-04-16 Thread Richard Emery
I don't understand what you're saying - Original Message - From: James M Kupernik [EMAIL PROTECTED] To: 'Richard Emery' [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 4:05 PM Subject: RE: [PHP-DB] results on multiple pages Because if I limit the record sort, then if the record I

Re: [PHP-DB] Inserting a String Variable into mysql_query() returns Query was empty error

2002-04-16 Thread Richard Emery
Are you trying to create a table named How Are You? If so, can't do it. It MUST be a one-word name. You would have discovered this yourself had you typed your CREATE statement into the mysql command line. Second ALWAYS include an or die(Error: .mysql_error()) part after your mysql_query().

[PHP-DB] PHP and OCI NLS behaviour

2002-04-16 Thread Miguel Carvalho
Hi, First of all i have searched for this trouble on the news( groups.google.com); on Oracle docson phpbuilder site; in php general, php db mailing list's . The problem: Background info: PHP version: 4.1.2 OS: Linux Suse 7 OCI version: 8 Database version: 7.x Database OS: HP/UX I need to do

Re: [PHP-DB] Inserting a String Variable into mysql_query() returns Query was empty error

2002-04-16 Thread Clever
Maybe the mistake is in the name. You can't name a table How Are You. Only oneword name table allowed :) - Original Message - From: eat pasta type fasta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 6:13 PM Subject: [PHP-DB] Inserting a String Variable into

Re: [PHP-DB] PHP and OCI NLS behaviour

2002-04-16 Thread Rouvas Stathis
Hi, place appropriate NLS_LANG definitions in the Apache startup script (/etc/rc.d/apache ?). -Stathis. Miguel Carvalho wrote: Hi, First of all i have searched for this trouble on the news( groups.google.com); on Oracle docson phpbuilder site; in php general, php db mailing list's .

Re: [PHP-DB] PHP and OCI NLS behaviour

2002-04-16 Thread Graeme Merrall
Rouvas Stathis wrote: Hi, place appropriate NLS_LANG definitions in the Apache startup script (/etc/rc.d/apache ?). As a background to this, it's essential to do this because certain things happen when the module is initialised in PHP. Hence if you use putenv() to alter some Oracle

[PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-16 Thread Michael Kimsal
Brad Hubbard wrote: Can I get some feedback on the conventional wisdom as to the best solution for high volume registration and authentication of users accessing a secure site? I have worked before with database/session based methods as well as htaccess. Which is preferred? Are there

RE: [PHP-DB] Definitive answer for large scale registration/authentication

2002-04-16 Thread Peter Lovatt
hi Depends a little on what you are doing next. I am not an htaccess expert so this is written as a 'sessions' user, but if you use a database/session system you have a lot of flexibility, and can log what users are up to. If it is well programmed, with security in mind you can make it very

[PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-16 Thread Brad Hubbard
On Tue, 16 Apr 2002 23:18, Michael Kimsal did align ASCII characters thusly: I guess the first thing you should help us with is defining high volume. :) 1/sec? 100 sec? Actually, this will probably have less impact on archictecture than hardware, but I'm always curious as to what 'high

[PHP-DB] Re: [PHP] Re: Cross DB application

2002-04-16 Thread Manuel Lemos
Hello, Richard Ellerbrock wrote: I'm planning to write a database application for MySQL, and then port it to PostrgeSQL. Is there any library or class that could help me to write/maintain just one source code for both MySQL and PostgreSQL ? I think your best (if not the only)

[PHP-DB] cannot load mysql extension, php config ???

2002-04-16 Thread Daniel Negron/KBE
Hi, Hope in the right place ? Just finished loading RH7.2 Apache 1.3.23, MySQL 3.23.49a, and PHP 4.1.2 I have gotten this to work properly on W2K, IIS4 5 with no problems. To start off ... all of these are working properly individually. PHP works fine on Apache MySQL works fine by itself,

[PHP-DB] Re: [PHP] Re: cannot load mysql extension, php config ???

2002-04-16 Thread Daniel Negron/KBE
--with-mysql=shared/usr is listed in teh configure command. you can see @ www.flost.net/info.php Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com

Re: [PHP-DB] Inserting a String Variable into mysql_query() returns Query was empty error

2002-04-16 Thread Jason Wong
On Wednesday 17 April 2002 05:35, Richard Emery wrote: Are you trying to create a table named How Are You? If so, can't do it. It MUST be a one-word name. Not strictly true. You can surround the table name with backticks: CREATE TABLE `How Are You` ... However this is /not/ recommended,