[PHP-DB] Cannot load module php_mysql.dl!!

2004-11-17 Thread colin_e
Jonathan, this appears to be an FAQ. LOts of people have the same problem, here's my commentary from a couple of weeks ago- Regards: Colin - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - I spent some time experimenting with

RE: [PHP-DB] neebee: on table designs.

2004-11-17 Thread Bastien Koert
small tables are easier to maintain and grow and quicker to search. need more info about the data to really help. probably 1 main clients table with basic info and then 1 or more smaller tables that hold certain specifics bastien From: phpnews [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:

RE: [PHP-DB] mysql db dump with php

2004-11-17 Thread Nate Nielsen
I tried this but to no avail. What I surmise is that one of the following is holding this up from being an option. 1) I'm on a shared server so I will have to specify the location of the file to save in order to get to it afterwards. I tried specifying the path and the file name in the examples

RE: [PHP-DB] mysql db dump with php

2004-11-17 Thread dpgirago
Nate, Don't know if this is the case or not, but the destination database has to already exist on the upload server. dave Nate Nielsen [EMAIL PROTECTED] 11/17/2004 10:08 AM To: [EMAIL PROTECTED] cc: Subject: RE: [PHP-DB] mysql db dump with php I tried this but to no avail.

[PHP-DB] Re: neebee: on table designs.

2004-11-17 Thread Sebastian Mendel
Phpnews wrote: Hi All, I have 5000+ individual clients, each clients may have 100+ records. Each client can modify to their own records. In the order of maintenance, robustness, scalability then performance, which of the following do you think is best. i)1 big table with 50+

[PHP-DB] Re: neebee: on table designs.

2004-11-17 Thread tony
Thanks you all, Nate Nielsen I would say just from a basic normalization standpoint that you should definitely not do the 5000+ tables option. That would be an absolute mess to maintain. Surely you wouldn't want to join 5000 tables to search all of your clients either. yes that was a very

RE: [PHP-DB] mysql db dump with php

2004-11-17 Thread Bastien Koert
if you have access to phpmyadmin, use that to dump the table and then re-import the created files in the server bastien From: Nate Nielsen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql db dump with php Date: Wed, 17 Nov 2004 10:08:43 -0600 I tried this but to no avail.

RE: [PHP-DB] PHP on an Windows intranet with MSOffice-like templates

2004-11-17 Thread Bastien Koert
yes, its possible. use www.fpdf.org to create the pdfs for you (gets around the word COM interface) and allows for database storage of template letters as text, simpler to maintain and change. FPDF will have some examples that will make this easy for you. Another option is to use straight html

[PHP-DB] validate/sanitize data

2004-11-17 Thread Todd Trent
I need to add textarea input into a mysql database. The input can be anything you would find in normal paragraph text - [:alnum:][:punct:][:space:]. In this case it is likely that the input could also include special accent characters (grave, acute, tilde, etc. - ex. é). Is addslashes enough to

RE: [PHP-DB] validate/sanitize data

2004-11-17 Thread Bastien Koert
see htmlentities function in the manual http://ca3.php.net/manual/en/function.htmlentities.php bastien From: Todd Trent [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] validate/sanitize data Date: Wed, 17 Nov 2004 15:06:55 -0500 I need to add textarea input into a mysql database. The

Re: [PHP-DB] validate/sanitize data

2004-11-17 Thread John Holmes
Todd Trent wrote: I need to add textarea input into a mysql database. The input can be anything you would find in normal paragraph text - [:alnum:][:punct:][:space:]. In this case it is likely that the input could also include special accent characters (grave, acute, tilde, etc. - ex. ). Is

RE: [PHP-DB] validate/sanitize data

2004-11-17 Thread Todd Trent
http://us2.php.net/mysql_escape_string http://us2.php.net/htmlentities thanks guys, great help. Todd Trent VP Hogfish Design 2550 26th Street West Bradenton, FL 34205 Tel: 941-749-0144 url: www.hogfishdesign.com

Re: [PHP-DB] PHP on an Windows intranet with MSOffice-like templates

2004-11-17 Thread Ricardo J. S. Oliveira
You're welcome... Best regards, Ricardo Oliveira ---Original Message--- From: [EMAIL PROTECTED] Date: 11/17/04 00:02:48 To: Ricardo J. S. Oliveira Subject: Re: [PHP-DB] PHP on an Windows intranet with MSOffice-like templates You're my hero. Thanks! -P Quoting "Ricardo J.

[PHP-DB] Re: oci8 cannot connect after restarting DB

2004-11-17 Thread John Lim
Hi This is because you are using persistent connections, which are left dangling and do not restart after the database restarts. Apparently you can hack your tnsnames.ora or oci8 extension. See http://bugs.php.net/bug.php?id=15390 and http://bugs.php.net/bug.php?id=30808 Regards, John Michael