Re: [PHP-DB] Can't open SQLite DB... but only when using mod_php??

2007-10-04 Thread Markus Wolff - NorthClick
Am Donnerstag, den 04.10.2007, 10:53 +1000 schrieb Chris: mmh wonder what could possibly be wrong when even trying 777? :-) Some hosts check for and disable access to files that have wide-open permissions - usually when php is running as a cgi but I've seen it when using mod_php too. Hi

Re: [PHP-DB] Can't open SQLite DB... but only when using mod_php??

2007-10-04 Thread Markus Wolff - NorthClick
Am Mittwoch, den 03.10.2007, 20:25 +0300 schrieb Thodoris: I came up with this try to edit your php.ini and in case you use pdo_sqlite extension then change the order of the loaded modules to this: extension=pdo.so extension=pdo_sqlite.so extension=sqlite.so Still no

[PHP-DB] Prevention for multiple submissions from the same form

2007-10-04 Thread T K
Hi, I have a form with a button, which adds user inputted data into database. I've been looking for a way to prevent users from pressing the same button twice mistakingly. I've learned that this is possible to make and send a unique id in hidden input, and check if the id is used before database

[PHP-DB] Re: [PHP] Re: the opposite of a join?

2007-10-04 Thread Robert Cummings
On Thu, 2007-10-04 at 11:56 +1000, Chris wrote: Robert Cummings wrote: On Thu, 2007-10-04 at 11:23 +1000, Chris wrote: Robert Cummings wrote: On Wed, 2007-10-03 at 14:49 -0700, Jim Lucas wrote: This is only from my own personal testing. Mind you that I have only been using PostgreSQL

Re: [PHP-DB] Prevention for multiple submissions from the same form

2007-10-04 Thread TG
The most common method I've seen is with Javascript. onsubmit, disable submit button. As a backup, in case the user's JS is disabled, you might consider the unique ID thing. -TG - Original Message - From: T K [EMAIL PROTECTED] To: php-db@lists.php.net Date: Thu, 4 Oct 2007 20:09:01

RE: [PHP-DB] Prevention for multiple submissions from the same form

2007-10-04 Thread Jonathan Gravois
I used the JavaScript method to disable the button after the first click and discovered from irate customers and administration that this resulted in an unsubmittable form on the AOL Browser although it worked perfectly in all others. Just a mention in case your clientele is AOL heavy (like ours).

RE: [PHP-DB] Prevention for multiple submissions from the same form

2007-10-04 Thread Bastien Koert
after submit direct the user to a different page...or use js and disable the button after the first click bastien Date: Thu, 4 Oct 2007 20:09:01 +0900 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Prevention for multiple submissions from the same form Hi, I have a form

[PHP-DB] MySQL Identifying worst-performing codes

2007-10-04 Thread Lasitha Alawatta
Hello friends, There is a tool call idera (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature; Identifying of worst-performing codes - Identifies performance bottlenecks such as the worst-performing stored procedures,

Re: [PHP-DB] Prevention for multiple submissions from the same form

2007-10-04 Thread Lasitha Alawatta
Hi TK, Try this, input type=Submit name=butSubmit value=Submit ?php if($_POST['butSubmit']=='Submit') {? disabled=disabled ?php }? Regards, Lasitha -Original Message- From: T K [mailto:[EMAIL PROTECTED] Sent: Thursday, October 04, 2007 3:09 PM To: php-db@lists.php.net Subject:

[PHP-DB] RE: [PHP] MySQL Identifying worst-performing codes

2007-10-04 Thread Jay Blanchard
[snip] There is  a tool call idera (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature;  Identifying of worst-performing codes - Identifies performance bottlenecks such as the worst-performing stored procedures, long-running queries, most

Re: [PHP-DB] Prevention for multiple submissions from the same form

2007-10-04 Thread T K
Thank you for answering my question. Can anybody explain a simple JavaScript only solution? I haven't used JavaScript except for some copy-and-paste jobs. Tek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL Identifying worst-performing codes

2007-10-04 Thread Colin Guthrie
Lasitha Alawatta wrote: There is a tool call “idera” (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature; Identifying of worst-performing codes – Identifies performance bottlenecks such as the worst-performing stored

RE: [PHP-DB] Prevention for multiple submissions from the same form

2007-10-04 Thread Bastien Koert
try input type='submit' name='submit' value='Submit' onclick='this.style.disabled=true;' / bastien Date: Fri, 5 Oct 2007 00:14:44 +0900 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re: [PHP-DB] Prevention for multiple submissions from the same form Thank you for answering

[PHP-DB] [PHP] Re: [PHP-DB] Re: [PHP] Re: the opposite of a join?

2007-10-04 Thread John A DAVIS
left join where item in right table is null "Chris" [EMAIL PROTECTED] 10/3/2007 10:32:01 PM Aleksandar Vojnovic wrote: I would also suggest to limit yourself to things you actually need not to select the whole table.In this case you can't because you're looking for records that exist in

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] Re: the opposite of a join?

2007-10-04 Thread Chris
John A DAVIS wrote: left join where item in right table is null That's still going to look at all records in both tables: 1) so it can work out if there is a match from table 1 to table 2 2) so it can then remember to display any records that don't have a match I was thinking more that if

[PHP-DB] Preparing SQL insert statements from CSV files

2007-10-04 Thread T K
Hi, I have to parse csv files and put them into database. I was able to parse the files by fgetcsv() and made an HTML table. But, when it comes to parse more closely and make INSERT INTO statement, then I'm having problems with, probably for-loop. For example, how do you do this task with the

Re: [PHP-DB] Preparing SQL insert statements from CSV files

2007-10-04 Thread Chris
T K wrote: Hi, I have to parse csv files and put them into database. I was able to parse the files by fgetcsv() and made an HTML table. But, when it comes to parse more closely and make INSERT INTO statement, then I'm having problems with, probably for-loop. Do you need to do anything to the

Re: [PHP-DB] Preparing SQL insert statements from CSV files

2007-10-04 Thread Bruce Cowin
And if you're using MS SQL Server, you can use BULK INSERT. Regards, Bruce Chris [EMAIL PROTECTED] 5/10/2007 3:30:13 p.m. T K wrote: Hi, I have to parse csv files and put them into database. I was able to parse the files by fgetcsv() and made an HTML table. But, when it comes to parse