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:
--
?php
mysql_connect(localhost,username,password) or die (Unable to connect to
MySQL server.);
$db =
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.
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;
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 to PHP
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
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 database.
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 PROTECTED]
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
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:
//
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 13,
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
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
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 =
20 matches
Mail list logo