I have the following example case:
1- More than 1000 record in my MySQL database.
2- I have to submit those record via HTTP GET or POST method.
3- I have to read the confirmation message that will be printed on the
remote page showing me that the vars have been inserted in the remote
database.
4-
Nabil wrote:
1-the problem is that the 30 second of execution time expired before i can
send even 200 records.
http://php.net/set_time_limit
Personally I'd call set_time_limit once for each iteration of the loop
with a sensible timeout like 30 seconds. Alternatively you can call it
once at the
On 09 January 2004 03:58, Jacob Hackamack wrote:
Hello,
I have a couple of quick questions. When I execute this code on my
php page (I know that the .PSD image isn¹t web ready, but Safari does
what I need it to do :) ) it displays the entire source as one line.
Is there anyway to have it
see 2 comments below
Jacob Hackamack wrote:
Hello,
I have a couple of quick questions. When I execute this code on my php page
(I know that the .PSD image isnt web ready, but Safari does what I need it
to do :) ) it displays the entire source as one line. Is there anyway to
have it be broken.
Google is not my friend today...
I have a reportng tool on a database i have, and I want to be able to
exort the selected results (I've saved the SQL query as a session variable
for ease of use)
and save that data as a csv file... with headers if possible...
Now I have found loadsa sites that
You didn't try to hard isn't it! :)
If you want to save a file as csv just save the vars like this
1,2,3
4,5,6
...
0,0,0
If you want to link a csv file for download put a
href='file.csv'download/a.
It's not so hard after all. :)
Or I didn't get your message.
Anyway, good luck!
- Original
Cheers for prompt reply...
But.. what?
I need to take an SQL query, and export teh results to a csv file...
Are you really sure that simply pointing to a non existant csv file does
that?
I don't see it somehow...?
I'm sorry if I'm wrong...
Viorel Dragomir [EMAIL PROTECTED]
09/01/2004 15:50
Tristan --
...and then [EMAIL PROTECTED] said...
%
% Google is not my friend today...
...
% Now I have found loadsa sites that let me upload a csv file, but not the
% other way around...
You might check PHPClasses to see if anyone has done this; I wouldn't be
surprised. In general, though,
It looks like is not so simple. But is not difficult at all..
Try to make something like:
?php
header(Content-type: text/csv);
$query = SELECT * FROM tables;
$result = mysql_query($query);
while($row = mysql_fetch_row($result)){
print implode(,, $row);
}
Viorel, et al --
...and then Viorel Dragomir said...
%
% It looks like is not so simple. But is not difficult at all..
Right.
%
...
% while($row = mysql_fetch_row($result)){
% print implode(,, $row);
I agree that implode is a better way to go. I had to have my fields
export in
Getting there...
That did indeed output my results to the screen...
Next steo is to output that same data to a new file...
I've done downloads on my site elsewhere, using header(), but with
existing files...
I guess I need to learn how to use fwrite?
Viorel Dragomir [EMAIL PROTECTED]
Tristan --
...and then [EMAIL PROTECTED] said...
%
% Getting there...
% That did indeed output my results to the screen...
Yay!
% Next steo is to output that same data to a new file...
A file on the surfer's computer or a file on your server?
%
% I've done downloads on my site elsewhere,
On the users computer...
When my bosses look at the reporting
tool I built.
They are gonna hit the export link,
and get directed to a page that let's them save the data as a csv file,
for use in excel.
That's the code I'm working on here
today...
ho hum... is it the weekend yet ;-)
David
Tristan --
...and then [EMAIL PROTECTED] said...
%
% On the users computer...
OK; that's what I figured.
% When my bosses look at the reporting tool I built.
% They are gonna hit the export link, and get directed to a page that let's
% them save the data as a csv file, for use in excel.
Google works!!!
just found this, and it works:
On
the other side it may be better and easier to create a csv file on the
fly. Create a page, say csv-export.php, and link to it using a
href="" This way the user's browser
is tricked
that the link points to a CSV file, if it does not honor
Is there a way to change the information in one record of a database, for
example the password, without having to open the entire row, delete it, and
then add it with $row_data[name] and all and the $newpass as changed
password?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
$result=mysql_query(UPDATE tablename SET userpwd='$newpass' WHERE
username='$name');
-Original Message-
From: Jeroen Wasteels [mailto:[EMAIL PROTECTED]
Sent: sexta-feira, 9 de Janeiro de 2004 18:24
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Need help replacing one record
Is there a way
If I understand your question correctly, an UPDATE query should be all you
need.
UPDATE tablename SET columname='value' WHERE someid='somenum';
I'm assuming you don't have the MySQL doc. Check mysql.com for the docs for
your version of the server.
Rich Hutchins, CIW Professional
Sr. Technical
Here's my dilemma:
2 tables and 2 others that have current data in them.
The 2 tables that have the current data in them I know how to display,
the problem I am having is the 2 tables I need to transfer information
to have to have the same key in one location
Tables:
CREATE TABLE `store_orders`
Howdy all,
I have been using PHP, MySQL and Apache on Win2K for about a year now and
have recently begun the process of switching development to Linux --
RH9.0.
Yesterday (by using the excellent reference by Patrick Harper,
http://www.internetsecurityguru.com/documents/snort_acid_rh9.pdf ) I
[EMAIL PROTECTED] wrote:
Howdy all,
I have been using PHP, MySQL and Apache on Win2K for about a year now and
have recently begun the process of switching development to Linux --
RH9.0.
Yesterday (by using the excellent reference by Patrick Harper,
21 matches
Mail list logo
