[PHP-DB] Get Confused : Use Transaction or not

Hi, I want to develop a multiuser system using PHP(5.04),MySQL(4.1.10) and PEAR(DataObject). There is only one MySQL account for PHP to operate data. All user's information will be stored in database,include id,passwd and etc. However,I get confused when I write queries in PHP script. Because one

RE: [PHP-DB] Get Confused : Use Transaction or not

Transactions are not necessarily the answer, though they are useful. What you need to do is decide if your design should allow multiple users to access the same record at the same time. Concurrency is the real issue, not the use of transactions. If users should not be allowed access to the same

[PHP-DB] Too many $_GETs?

Is there a point where a link in a PHP/MySQL-based site has too many $_GET variables attached to it? I use the format "index.php?a=1&b=2&c=3&e=4" to pass variables from page to page, and am wondering where the limit is on such a format. Right now, eight variables are passed, each being one to f

RE: [PHP-DB] Too many $_GETs?

As far as I know there is no limit on the amount of variables, however there is a limit on the length of the URL including query (I believe 256 characters). Normally I would use hidden fields in a form (method POST) for this kinda stuff. Jos -Original Message- From: [EMAIL PROTECTED] [m

Re: [PHP-DB] Too many $_GETs?

On Monday 25 April 2005 17:54, Juffermans, Jos wrote: > As far as I know there is no limit on the amount of variables, however > there is a limit on the length of the URL including query (I believe 256 > characters). > > Normally I would use hidden fields in a form (method POST) for this kinda > st

Re: [PHP-DB] Too many $_GETs?

The limit on GETs is not something to do with PHP or MySQL, it's a web server standard. I forgot what the length limit is for a URL (256, 1024 ?), which is what a GET is. If you want to keep variables or information from page to page you should use sessions. You can manage sessions without usin

Re: [PHP-DB] Too many $_GETs?

AFIAK its around 2K, but nay one who trusts it that far is really taking a chance with it Bastien From: Brent Baisley <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] CC: php-db@lists.php.net (PHP) Subject: Re: [PHP-DB] Too many $_GETs? Date: Mon, 25 Apr 2005 12:08:08 -0400 The limit on GETs is not some

Re: [PHP-DB] Too many $_GETs?

The browser may also have something to do with it. Use hidden input forms to transfer data from page to page. Uses POST and makes for a prettier URL. put those in the form, and change the method to POST. Then you can access the data via the $_POST var. And yes, it is that simple. -

[PHP-DB] Help with PHP

I'm not sure if this is the correct distro to be sending this question to, if it's not, let me know which one I should send it to. I am having an issue where a variable in on php file won't go to the next php file: Here is the code I am using: get colors $get_colors = "select Cat_Name from l

RE: [PHP-DB] Help with PHP

I apologize but I figured out my mistake. Thanks -Rich -Original Message- From: ReClMaples [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 10:05 PM To: PHP Subject: [PHP-DB] Help with PHP I'm not sure if this is the correct distro to be sending this question to, if it's not, let