Hi All,
I am quite new to php. I have a requirement to query dbase file to
implement searching on table columns. Now I am following a basic
approach using dbase_get_record_with_names($fileHandler,
$iterationIndex). This seems to be a rudimentary approach and has
performance bottleneck. For the
See below:
--- John Holmes [EMAIL PROTECTED] wrote:
Are you sure it's the date that's causing the
rejection? What does
mysql_error() say?
No, I'm not sure. At first the date was being
accepted but wrong in the database. It was setting
it to 1/1/2000. Someone suggested I add '' around the
On Fri, 15 Oct 2004 17:26, Stuart Felenstein wrote:
See below:
--- John Holmes [EMAIL PROTECTED] wrote:
Are you sure it's the date that's causing the
rejection? What does
mysql_error() say?
No, I'm not sure. At first the date was being
accepted but wrong in the database. It was
Yes, my apologies to the list!
Stuart
--- David Robley [EMAIL PROTECTED] wrote:
May I suggest that as well as echoing mysql_error()
you also echo your
query; that way you can see _exactly_ what is being
passed to mysql and you
can resolve problems like this simply and without
resorting to
hi all,
i want to how i can save the data retrieved from mysql through php in pdf
format.
thanks for your help in advance.
with best wishes
balwant
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
If you see the code I have the begin , then the $query
follows. With both statements present, only the
second one does the insert. If I // or remove the
second, the first one takes.
Am I missing something here ?
Stuart
Code:
function begin()
{
mysql_query(BEGIN);
}
function commit()
{
Stuart Felenstein wrote:
If you see the code I have the begin , then the $query
follows. With both statements present, only the
second one does the insert. If I // or remove the
second, the first one takes.
Am I missing something here ?
Yep... you're missing a mysql_query() call for each
check this
- Original Message -
From: balwantsingh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 15, 2004 11:23 AM
Subject: [PHP-DB] pdf
hi all,
i want to how i can save the data retrieved from mysql through php in pdf
format.
thanks for your help in advance.
I can't believe this, my problem doesn't attract any attention.
But I am quite sure that everybody else besides me has more experience
than me in this specific field.
Anyone pl, is my question absurd or just impossible.
-Original Message-
From: Swapan Mazumdar [mailto:[EMAIL PROTECTED]
That made a world of difference! :) Thank you.
But - I want to confirm, am I still using transactions
even though I'm issuing individual query calls for
each insert.
And, if I can ask another question to the list :
In this line (from the second insert)
VALUES (null, LAST_INSERT_ID(), ..);
On Friday 15 October 2004 19:11, Swapan Mazumdar wrote:
I can't believe this, my problem doesn't attract any attention.
But I am quite sure that everybody else besides me has more experience
than me in this specific field.
Anyone pl, is my question absurd or just impossible.
I may be wrong,
www.fpdf.org
bastien
From: balwantsingh [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] pdf
Date: Fri, 15 Oct 2004 13:53:00 +0530
hi all,
i want to how i can save the data retrieved from mysql through php in pdf
format.
thanks for your help in advance.
with
John,
Big thank you! for your help. I had been trying out
the mysql_insert_id and was not having luck. It's
working great (with just a few more bumps to get
over).
--- John Holmes [EMAIL PROTECTED] wrote:
Stuart Felenstein wrote:
But - I want to confirm, am I still using
transactions
Here is my situation , not sure how I should handle
it.
I have this multi page form, at the end I use mysql
transaction to get the data into all the tables.
All the tables are innodb with the exception of one.
The last page has one field which takes a copy/paste
of a document, so it's a text
i want to how i can save the data retrieved from mysql through php in pdf
format.
http://www.fpdf.org/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I have finally convinced my office manager to move from Access to MySQL.
Unfortunately the office users are used to Access forms instead of web
forms.
I have attempted to make my web forms look as much like the Access forms
they are used to but I am not a web designer. Does anyone know a good
Try odbtp, http://odbtp.sourceforge.net.
-- bob
On Fri, 15 Oct 2004, Swapan Mazumdar wrote:
Hi All,
I am quite new to php. I have a requirement to query dbase file to
implement searching on table columns. Now I am following a basic
approach using dbase_get_record_with_names($fileHandler,
Trying to get array of values into table.
Each value will be part of a new record, so it's a
loop.
I am getting a parse error though and for further down
in the code though I know this is what's causing it.
Is there anything wrong with this statement ?
if ( is_array( $_SESSION['l_industry'] )
Where would that go?
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p )
{
$query = INSERT INTO Profiles_Industries
(ProfileID,
IndID)
VALUES ($LID, $p);
}
do you have a } for the if
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES
($LID, $p);
} //foreach ( $_SESSION['l_industry'] as $p )
} //if ( is_array( $_SESSION['l_industry'] ) )
--
Yep, I had found it shortly before.
Only it's not looping. It is taking last value only.
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries
where is your insert statement? I am guessing it is after your loop
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES
($LID, $p);
/This is where
Actually it did just loop. I need to test again.
The insert statement is the the one $query =
So it's after yes, but contained in the braces, like
you diagram below.
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
where is your insert statement? I am guessing it is
after your loop
if (
Hopefully these functions will explain it.
I'm starting the transaction, then provided it takes
with no errors it gets the commit
function begin()
{
mysql_query(BEGIN);
}
function commit()
{
mysql_query(COMMIT);
}
function rollback()
{
mysql_query(ROLLBACK);
}
begin();
$query = INSERT
Perry, Matthew (Fire Marshal's Office) wrote:
I have finally convinced my office manager to move from Access to MySQL.
Unfortunately the office users are used to Access forms instead of web
forms.
I have attempted to make my web forms look as much like the Access forms
they are used to but I am
I tried a little research on the mysql list but didn't find what I was
looking for.What is the limit of a MySQL database? How many hundreds
of thousands of records can a database hold before it gets too
sluggish to work on a production server?
thanks,
--
How many records it can hold before becoming too slow for practical use
depends entirely of the hardware that makes up the server.
Current versions of MySQL has a finite limit of 2^64 records per table, but
how many billion records you can shove into it before you start seeing
performance
ApexEleven wrote:
I tried a little research on the mysql list but didn't find what I was
looking for.What is the limit of a MySQL database? How many hundreds
of thousands of records can a database hold before it gets too
sluggish to work on a production server?
Check the output from phpinfo()...
I would like to know if you are able to create a PHP web form that has
different SUBMIT buttons --- or if you used the HTML command
SELECT NAME=approval_command
OPTIONDelete Record
OPTIONUpdate And Approve For Listing
OPTIONFor Management
/SELECT
Basically I want the delete record to find the
What about in MySQL:
SELECT personID from persons ORDER BY RAND(NOW()) LIMIT 1
If the table is large, then the following might be better:
LOCK TABLES foo READ;
SELECT FLOOR(RAND() * COUNT(*)) AS rand_row FROM foo;
SELECT * FROM foo LIMIT $rand_row, 1;
UNLOCK TABLES;
There's a whole discussion on
skip the two step process and use RAND in the sql statement
SELECT * FROM table1, table2 WHERE a=b AND cd
ORDER BY RAND() LIMIT 1000;
bastien
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
To: [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: [PHP-DB] How to optimize select of random record in DB ?
Date:
31 matches
Mail list logo
