php-windows Digest 4 May 2001 11:26:28 -0000 Issue 579
Topics (messages 7270 through 7276):
Re: mysql dump
7270 by: Giro De Roover
encrypt
7271 by: Seth Cox
7274 by: Daniel Beulshausen
how to create a PHP4 library
7272 by: Andre Steffens
echo vs print?
7273 by: Johan Lundqvist
7275 by: Daniel Beulshausen
Aache Browser
7276 by: him
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
OK I got it but it was painfull.
In first place, I read somewhere that the latest release og phpMyadmin had
fixes the backslash story and it is not true
There is no way of having working now. In first place phpmyadmin keeps
referring to a .TMP files which
I haven't choose and don't even exist. The text file i want to upload is
update.txt and is located in My Documents
So this what I did:
1/ save my file on .txt extension with fied delemited by tabs (no commas or
others quote)
2/Make that you leave the first column empty , because mysql will add the ID
field in case you don't have one (if ID is the primary and auto_increment
3/open a console and launch mysql, select your database
ie: use test
and type
load data local infile 'c:\\My Documents\\update.txt' into table
my_contact;
this is it, it WORKS !!!!!!
Thanks for your help I hope that my suffering will help someone out there
Giro
Open a console
"Johan Lundqvist" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Sorry if I was a bit fuzzy...
> You have to escape out the "\" by typing "\\", so in your exaple it
> would say:
>
> LOAD DATA LOCAL INFILE 'c:\\Windows\\Temp\\phpC021.TMP' INTO TABLE
> my_contact
> FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES
> TERMINATED
> BY '\n'
>
> Since you get the error:
> MySQL said: File 'c:windowstempphpc021.tmp' not found (Errcode: 2)
> you might see that it took away the backslashes?? If you don't know why,
> take a look at php manual Chapter 6. Types and the page about Strings.
>
> Happy hunting
>
> /Johan
>
> Giro De Roover wrote:
> >
> > How is that done and where ??
> >
> > "Johan Lundqvist" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > Hi Giro,
> > >
> > > You'll have to type c:\\Windows\\Temp\\phpC021.TMP
> > >
> > > /Johan
> > >
> > > Giro De Roover wrote:
> > > >
> > > > Hi everyone,
> > > >
> > > > I am experiencing problem with mysql trying to import a text file
with
> > data
> > > > into a table, i am using phpmyadmin in order to do that, going to
insert
> > > > textfiles into table and after choosing the file I want to upload i
got
> > this
> > > > error, any help will be appreciated.
> > > >
> > > > Giro
> > > >
> > > > Error
> > > > SQL-query:
> > > >
> > > > LOAD DATA LOCAL INFILE 'c:\Windows\Temp\phpC021.TMP' INTO TABLE
> > my_contact
> > > > FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES
> > TERMINATED
> > > > BY '\n'
> > > > MySQL said: File 'c:windowstempphpc021.tmp' not found (Errcode: 2)
> > > >
> > > > --
> > > > PHP Windows Mailing List (http://www.php.net/)
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> > >
> > > --
> > > PHP Windows Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> > >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
I've searched everywhere and I cannot find the php_crypt.dll file anywhere. I didn't
come with the package when I installed PHP 4.05 on my windows nt Sambar server. If
this is the extension that allows the encrypt() and decrypt() functions, does anyone
know where I can find that dll, or if that's not the extension, does anyone know it?
Thanks so much
Seth Cox
Owner - SC Developments
256.704.7384 - Office
877.647.6712 - Toll Free
www.scdevelopments.com
At 22:20 03.05.2001 -0500, Seth Cox wrote:
>I've searched everywhere and I cannot find the php_crypt.dll file
>anywhere. I didn't come with the package when I installed PHP 4.05 on my
>windows nt Sambar server. If this is the extension that allows the
>encrypt() and decrypt() functions, does anyone know where I can find that
>dll, or if that's not the extension, does anyone know it?
yes, the php3_crypt.dll add support for decrypt/encrypt, but those
functions have been nuked out in PHP 4.
daniel
/*--
daniel beulshausen - [EMAIL PROTECTED]
using php on windows? http://www.php4win.de
I use PHP with windows and want create a php4 library from a C sourcecode...
How to do this ?
thanx
Hi there,
I'm lookin into some code a friend of mine wrote and we got in to this
arguement:
Is there any differens in performance when using "echo" vs "print"??
I belive print is, more or less, an alias for echo, he doesn't.
Someone got any answer to this???
/Johan
At 10:38 04.05.2001 +0200, Johan Lundqvist wrote:
>Hi there,
>
>I'm lookin into some code a friend of mine wrote and we got in to this
>arguement:
>
>Is there any differens in performance when using "echo" vs "print"??
>I belive print is, more or less, an alias for echo, he doesn't.
>
>Someone got any answer to this???
in php 3 there had been some (marginal tough), in php 4 they should perform
nearly equal.
daniel
/*--
daniel beulshausen - [EMAIL PROTECTED]
using php on windows? http://www.php4win.de
Sir,
The site you have suggested is not available online.The page is not
being displayed.
