[PHP-DB] ifx_connect and Apache 2

2005-08-17 Thread HENCHOZ Daniel
Hello, I've installed the following components under Solaris 9 : Apache 2.0.54 PHP 5.0.4 Informix server 9.40.UC6 Client SDK 2.81.UC2R1 I can connect to my database using php CLI with the following script : html head titlePHP Informix/title /head body ?php printf(brH3Tableau des

[PHP-DB] Files stored in mysql

2005-08-17 Thread Vincent Lape
I need some advise on how to handle some pfd files. We have sales guys out in the field and generally need to access client reports regularly. I was thinking about making a dir for each rep, subdir for each client and posting the pfd files there. After the reps auth from the login page I call an

RE: [PHP-DB] Files stored in mysql

2005-08-17 Thread Bastien Koert
Assuming you make your users log in, you could simply limit the display to the users folder/clients...ie use a rep_id (or whatever you call it) as the main folder name. Then simply start reading the folder contents based on the rep_id folder being the base folder. Note that the folders and

Re: [PHP-DB] Files stored in mysql

2005-08-17 Thread Mark Cain
Here is one way to do it. It happens to be the way that I use for a group of folks that have authentication levels of access to pdf. I store all of the pdf files above the www folder. This keeps them out of prying eyes. You of course could store them in a database. the security levels for the

[PHP-DB] DB Access, Sessions and Blocking Access

2005-08-17 Thread Bret Walker
Hello- I'm developing a web-based system whereby users can edit documents and then e-mail the documents to selected recipients. The documents are comprised of the data from several MySQL fields. I want to make sure that two people don't edit a document at the same time. My users log in via a

Re: [PHP-DB] DB Access, Sessions and Blocking Access

2005-08-17 Thread Philip Hallstrom
I'm developing a web-based system whereby users can edit documents and then e-mail the documents to selected recipients. The documents are comprised of the data from several MySQL fields. I want to make sure that two people don't edit a document at the same time. My users log in via a script

[PHP-DB] Faster multiple insert and other queries

2005-08-17 Thread ioannes
Multiple inserts using mysql were very slow so I read http://ee.php.net/manual/en/function.mysql-query.php for the function below. It works well, reducing insert/query times dramatically. However, I don't understand the difference below between 1 second and 5 seconds taken for the code below.

RE: [PHP-DB] DB Access, Sessions and Blocking Access

2005-08-17 Thread Bastien Koert
Bret Can you figure out how many minutes the average userwould take for an update/edit function? You could then write a CRON script to reset those accounts after some predetermined expiry time is reached. Another option is to timestamp when the user requests the record and when it gets