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
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:
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
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.
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+
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
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.
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
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
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
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
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
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.
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
14 matches
Mail list logo