Why not use an actual SQL query which is optimised to be faster than string
processing ?
You would probably get more mileage from loading the CSV into a pre-formed
table with an index, in MySQL (this operation is very fast). I've loaded
5000 records from a CSV in 5 millisec into MySQL on a P500
Hello Neil,
I want to really thank you. You cracked my month long problem for me.
The destination path was supposed to be the absolute path:
/home/ayserve/public_html/fu/
It is working fine now.
Regards,
Bunmi
Neil Smth wrote:
At 18:44 16/10/2003 +, you wrote:
From: Ruprecht Helms <[EMAIL PR
Hi Kim
AFAIK, LOAD DATA INFILE will only work off a file. So you would have to
create a temp file. Another option is to create a multiple value insert
query e.g.
INSERT INTO arb_table (arb_column_1...arb_column_n)
VALUES (arb_value_1..arb_value_n), (arb_value_1..arb_value_n), .
Although
From: "Kim Kohen" <[EMAIL PROTECTED]>
> I have some data from Filemaker Pro which needs to have a lot of
> search/replacing done before importing into MySQL. I have used
ereg_replace
> in PHP and end up with a variable holding the correct data. (there are
> several hundred rows of data in the vari
From: "Rory McKinley" <[EMAIL PROTECTED]>
> AFAIK, LOAD DATA INFILE will only work off a file. So you would have to
> create a temp file. Another option is to create a multiple value insert
> query e.g.
>
> INSERT INTO arb_table (arb_column_1...arb_column_n)
> VALUES (arb_value_1..arb_value_n), (a
Hi;
I need to usestatement in a xxx.php
file.
I have to use a php variable on the right of the day variable like > .
When i get this variable in abc.php file
if (phpversion() <= "4.1.0")
{ $vars = array_merge($HTTP_GET_VARS, $HTTP_POST_VARS); }
else { $vars = $_REQUEST; }
print_r($vars
Shahmat,
I have the following table in my MySQL db:
mysql> describe news;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+--
John,
Thanks much for the excellent tips, I guess I was trying to make it too
difficult. We're working on the SQL and indexes to alleviate the slowdowns
and I don't expect this to really be an issue in the future, it just
concerned me that it was even possible... I thought I'd coded it better than
How do I get rid of the undefined variable errors I get on a new (default)
set up of Apache 1.3.28/PHP4.3.2 (without re-writing the code). It works on
the internet on my host providers server but I am running this on localhost.
I also get undefined offset error.
Regards,
John
pete
MüCella Erdem Efe wrote:
Hi;
I need to usestatement in a xxx.php
file.
I have to use a php variable on the right of the day variable like > .
When i get this variable in abc.php file
if (phpversion() <= "4.1.0")
{ $vars = array_merge($HTTP_GET_VARS, $HTTP_POST_VARS); }
else { $vars
From: "Dillon, John" <[EMAIL PROTECTED]>
> How do I get rid of the undefined variable errors I get on a new (default)
> set up of Apache 1.3.28/PHP4.3.2 (without re-writing the code). It works
on
> the internet on my host providers server but I am running this on
localhost.
> I also get undefined
What does it show?
It seems strange that Firebird *and* PHP somehow caused a problem, but somet
higns you can try are this. Output the php file into an HTML (use another
browser perhaps, or wget) and then see if you can view the idnividual HTML
file.
-dd
"Thejavo" <[EMAIL PROTECTED]> wrote in m
From: "Dillon, John" <[EMAIL PROTECTED]>
> How do I get rid of the undefined variable errors I get on a new (default)
> set up of Apache 1.3.28/PHP4.3.2 (without re-writing the code). It works
on
> the internet on my host providers server but I am running this on
localhost.
> I also get undefined
If this is the wrong list for this request, please tell me where to send
it.
I've just started using the SOAP classes define a web service and have
gotten a lot done, but am having some strange and peculiar errors.
I started by using this tutorial:
http://www.phppatterns.com/index.php/article/art
I am working on a quote system and have been trying to figure out how to
make them system automatically add an entire vendor or category at one
time. I can make the system display all of them and give the sales
folks in my office a chance to change the price, however if I have just
one "Add" butto
From: "Robert Sossomon" <[EMAIL PROTECTED]>
> I am working on a quote system and have been trying to figure out how to
> make them system automatically add an entire vendor or category at one
> time. I can make the system display all of them and give the sales
> folks in my office a chance to cha
From: "Dillon, John" <[EMAIL PROTECTED]>
> Hm. Adjusted error_reporting to none. Why would I still get:
>
> "Forbidden
> You don't have permission to access /method="post" on this server.
> --
--
>
> Apache/1.3.28 Server
An example is:
http://www.garlandcnorris.com/quotes/seestore.php
I have a session tracker installed on it already, but the modifying the
information (instead of remove and readding it) and adding an entire
group are pieces I am stumbling on.
TIA!
~
Hello
I'm trying to modify all my php scripts to generate utf-8 output.
I got trouble with getting utf-8 encoded text from pgsql.
My database contains koi8-r encoded text.
I tried to call
pg_set_client_encoding ($db_connection, 'UNICODE');
but it didn't help, i still recieved koi8-r encoded text.
From: "Robert Sossomon" <[EMAIL PROTECTED]>
> An example is:
> http://www.garlandcnorris.com/quotes/seestore.php
>
> I have a session tracker installed on it already, but the modifying the
> information (instead of remove and readding it) and adding an entire
> group are pieces I am stumbling on.
It's just the syntax:
1. Don't use the "/" after .php:
abc";
maybe you will get the link you want.
Gabriel.
"MüCella Erdem Efe" <[EMAIL PROTECTED]> escribió en el mensaje
news:[EMAIL PROTECTED]
> Hi;
>
> I need to usestatement in a
xxx.php
> file.
>
> I have to use a php variable on th
BOTH would be wonderful.
But for right now I could handle just the multiple adds. I don't figure
they would be able to mess up too many that they will have to go back
and modify more then 1 or 2, but right now the majority of the quotes
are for an entire vendor or category, so adding the whole th
Where are you getting the PHP variable from, another page, or ???
I use the print function in my scripts, mainly have the script write
everything to one big variable and then printing the variable. By using
this method I can code the pieces in the big variable and they all come
out nice and "pret
Sorry, I was over thinking...
Just modify it by removing the echo and the / and it should code right
out for you.
> >
BECOMES:
>
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
hmm really... SQL_ASCII :-\
can i change charset of a database?
Agri
On Tue, 21 Oct 2003 14:59:06 -0400
Gerard Samuel <[EMAIL PROTECTED]> wrote:
> In what character set is your database initialised as???
>
> Agri wrote:
>
> >Hello
> >
> >I'm trying to modify all my php scripts to generate
seems to be a bug
pg_set_client_encoding ($db_connection, 'UNICODE'); -- doesn't work
pg_query ($dbconn, "set client_encoding to 'UNICODE'"); --- does work
Agri
PS: Gerard Samuel, thnx a lot :-)
On Tue, 21 Oct 2003 23:16:18 +0400
Agri <[EMAIL PROTECTED]> wrote:
> hmm really... SQL_ASCII :
Hi there everyone,
I have this system where you can create folders on your HD for inserting PDF files via
a web interface and you can also remove these folders, this works no problem, but I
have run into a snag, I need to send more than 1 field in the below array via a form,
how can I do?
Basi
Chris Payne wrote:
Basically, aswell as sending the ID,
> I need to send the title and path too
> and i'm abit confused.
You could pass the value as "id/title/path" where / is a delimiter, then
pull it apart on the other side.
Or, you could format 3 different elements like this:
Now, when
Chris - it might take a little work, but I think I have a good solution
for ya. I would maybe use the $id as the key, and then use hidden inputs
to set the other stuff in a multidimensional array. like so
then, on the flip side of the script when you need the data, the array
keys are the
Or you could hire John or me to do it for you. :-) Just kidding. I used the delimiting
solution all over the place it is pretty simple.
<>< Ryan
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 4:42 PM
To: Chris Payne
Cc: [EMAIL PROTECTED]
In the input definition onclick call a javascript function with all your parameters.
Might be a missing quote here and there but this is close to ones I use all the time:
echo "";
Now here is what is in "yourjavascriptfunctio('$parameter1,$parameter2,$parameter3'):
function yourjavascriptfunc
My ascii file coming in has quotes around each comma delimited item. After reading the
rows into array these quotes are gone. Can't figure out how to put them back in the
array items when displaying the fields. Rows are saved to table and bad rows are
displayed in browser. Hope this fits this li
$fieldarray = array("one","Two", "three", "four");
$line = "\"".implode("\",\"",$fieldarray) ."\"";
this will print out "one","Two","three","four"
hth
jeff
G'day CPT John W. Holmes and Rory
>> AFAIK, LOAD DATA INFILE will only work off a file. So you would have to
>> create a temp file. Another option is to create a multiple value insert
>> query e.g.
> Agree that LOAD DATA INFILE will probably still be faster overall, even with
> the file write. Tr
The reason curly braces are needed are because you are putting an array
element into a string. Consider..
$sBlah = 'blah';
echo "$sBlahfoo$sBlahfoo";
PHP will attempt to echo the variable $sBlahfoo twice. if you use
echo "{$sBlah}foo{$sBlah}foo";
you have told php explicitly when to look for
This what I got when I tried to install the PHP Forum:
Warning: main(./config.php) [function.main]: failed to create stream:
Permission denied in /home/content/j/i/g/jigger/html/common.php on line 111
Warning: main() [function.main]: Failed opening './config.php' for inclusion
(include_path='.:/u
MYSQL and PHP 4.3.3
*sigh* I hate eregs and I'm really bad with them :/
I have a form that has a field in which the user is supposed to enter an IRC channel
name. IRC channel names begin with a '#'.
ereg("^#") does not work. I am getting the error "Warning: Wrong parameter count for
ereg(
37 matches
Mail list logo