A quick trip through the MySQL manual hints that you may have to use forward
slashes in your path on a windows system. So...
LOAD DATA LOCAL INFILE 'C:/WINDOWS/TEMP/phpC255.TMP' INTO TABLE
abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY
'\r\n' (dp_indpri,dp_nom,dp_ville)
.
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
My sample code is:
--
---
This throws the following error:
---
Warning: My
Looks like is to do with MySQL permissions. Check your host's (the one you
are trying to connect from) permissions to the server.
To change permissions, from the MySQL prompt type;
GRANT ALL ON * TO username@host IDENTIFIED BY password;
Substitute in username, host and password for your ones.
Should have added; You don't have to GRANT ALL, obviously you can assign
permissions as required so you could just do GRANT SELECT, UPDATE if that is
all that is required.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2003 13:20
To: [EMAIL PROTECT
PHPMyAdmin is just a web-based tool for administering MySQL and it's pretty
intuitive, assuming you've used similar tools before. You can download it
and read more here http://www.phpwizard.net/projects/phpMyAdmin/
I would recommend SQLYog as an alternative;
http://www.webyog.com/sqlyog/index.htm
Hi All,
Can anyone tell me how can i select and upload files using php.
Thanks in advance,
Gabriel,
- Original Message -
From: "Clarkson, Nick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 10:59 AM
Subject: RE: [PHP-DB] MySQL problem -- new t
Gabriel --
...and then Gabriel Gramajo said...
%
% Hi All,
% Can anyone tell me how can i select and upload files using php.
You can begin by not hijacking a thread and changing the topic. When you
want to start something new, start a fresh message.
You could next check the list archives;
Just forwarding this on to the general list as it was only sent directly to
me.
-Original Message-
From: karthikeyan.balasubramanian
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 9:03 AM
To: Hutchins, Richard
Subject: Re: [PHP-DB] [Import text file]
try using something lik
If you cut and pasted your code, try to put localhost into quotes as well.
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:
When changing/adding permissions to the mysql db for specific users,
dont forget to do 'flush privileges'...
my 2 cents
On Thu, 2003-02-13 at 07:19, Evan Morris wrote:
> Hi all
>
> I am new to PHP (just basically started yesterday). I am currently having a
> problem connecting to a MySQL databa
This LIST need some change :).
Generally we just say reply and give our suggestions. This works in other
list.
This one goes only to the person who posed the question.
Have a great day.
Karthikeyan B.
- Original Message -
From: "Hutchins, Richard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTEC
On Friday 14 February 2003 00:29, karthikeyan.balasubramanian wrote:
> This LIST need some change :).
Your email client needs changing :)
> Generally we just say reply and give our suggestions. This works in other
> list.
The 'other' list is broken.
> This one goes only to the person who posed
Well ... in fact, most lists that I've been on use the Reply-To header to
automate this. MOST email clients I have used do not recognize email as
"list email" and while they have a Reply and Reply All option, I've never
seen a Reply-List option.
So ... what is right, and who is broke could be arg
Mitch, et al --
...and then [EMAIL PROTECTED] said...
%
% Well ... in fact, most lists that I've been on use the Reply-To header to
% automate this. MOST email clients I have used do not recognize email as
That doesn't make it right :-)
% "list email" and while they have a Reply and Reply All
On Wed, Feb 12, 2003 at 03:33:22PM -0500, Zach Davis wrote:
> I have a question about the way I'm using the crypt function in a PHP/SQL
> gradebook I'm building.
>
> When I add a user to the users table, I also generate a encrypted version
> of their password using the following statement:
>
>
Hi,
I am new to PHP and had just written a simple php script to get things
started. I have the following code:
Input yourname
So this page is suppose to display a input box and a submit button and once
you enter ur name and press the button, it should show Hello [ur name] and
the in
It's the good ole' register_globals feature...
You'll need to either turn register_globals on in your php.ini file or access the
variables from their respective arrays ($_SERVER,$_GET,$_POST)... since your form
method is post it will be: $_POST['vname'].
Make sense?
If you put this at the top
Try referring to your variables as:
$_POST['submit1'] and
$_POST['vname']
Then check our register_globals on php.net to find out why.
I'm pretty sure that's what the problem is.
> -Original Message-
> From: Poon, Kelvin (Infomart) [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 1
Thanks everyone, it worked
-Original Message-
From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 4:14 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Simple PHP Script
It's the good ole' register_globals feature...
You'll need to either turn register_gl
Howdy,
I have a SELECT query displaying the results in repeated rows in a
table. I have a COMMENTS column coming out of the database table which
will likely contain a paragraph of information. I would like to display
only the first 10 or so words and then have a more link that people can
click on t
try SUBSTRING
http://www.mysql.com/doc/en/String_functions.html
Peter
-Original Message-
From: Bruce Levick [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2003 22:23
To: [EMAIL PROTECTED]
Subject: [PHP-DB] first 10 or so words
Howdy,
I have a SELECT query displaying the results in repeat
I need to know exactly how to hook up to an Access database under Office
Xp. I normally use MySQL, but the current site sits on Windows servers.
I am using php 4.3.0
Office Xp Pro w/ Access
I'm running Apache 2.0.43
I need to know how to check if ODBC is set up on my machine (I hear that
by def
I need to import a fixed width txt to a my sql database, I
know how to do that with a coma separated value.
any1 knows how i can do this easilly or know some software to do this?
any help would be appreciated.
thanx
Pedro
--
Pedro Oliveira <[EMAIL PROTECTED]>
--
PHP Database Mailing List (
Hi everyone,
I want to dump some data from mysql into a file, and use php to force the browser to
pop a download file window. This seems a simple procedure, but I am having trouble to
make it work with IE. The following is what I did:
ob_start();
$query = "SELE
24 matches
Mail list logo