Re: Help with PHP to MySQL db connection

2004-09-29 Thread Wesley Furgiuele
This is really just a PHP question, I think. Are MySQL and Apache running on the same machine? What version of MySQL are you running? Typically, you need a PHP mysql_connect() call including the MySQL host, username, and password. You only list the host above. With a default installation of MySQ

RE: **[SPAM]** Help with PHP to MySQL db connection

2004-09-29 Thread Jay Blanchard
[snip] $dbhost = 'localhost'; [/snip] Try changing this to 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help with PHP to MySQL db connection

2004-09-29 Thread Andrew Lietzow
Hola, MySQL wizards. I'm using LAMP on Fedora Core 2. Some kind soul produced a tutorial on the net and the first script, , I am trying to use yields an error in the browser of: < Couldn't connect to MySQL > Here is the script. --- Birthdays Create Database $dbho

Re: Can connect with PHP to MYSQL

2004-08-13 Thread Andreas Ahlenstorf
> I think that's the problem. > Could be a lot of editing PHP scripts for a lot of people(!?) > Thanks Try to compile PHP against the client library for MySQL 4.1. I'll wonder if it won't work. ext/mysqli is required if you like to use things like prepared statements... Regards, A. -- MySQL Ge

Re: Can connect with PHP to MYSQL

2004-08-13 Thread leegold
On Fri, 13 Aug 2004 11:24:46 -0400, "Wesley Furgiuele" <[EMAIL PROTECTED]> said: > What error are you getting? My problem when moving to 4.1 was > forgetting that I was using an older MySQL client. > > I'm not positive, but I think that in order to connect to MySQL 4.1 > with PHP you need to

Re: Can connect with PHP to MYSQL

2004-08-13 Thread Wesley Furgiuele
What error are you getting? My problem when moving to 4.1 was forgetting that I was using an older MySQL client. I'm not positive, but I think that in order to connect to MySQL 4.1 with PHP you need to use the mysqli functions, not mysql, and mysqli requires PHP 5. If you want to keep using

Re: Can connect with PHP to MYSQL

2004-08-13 Thread suomi
i usually do $link = mysql_connect($server, $userid, $password); and it works, except when the pw is incorrect suomi leegold wrote: I can connect in the php by using 'root' and the root pw. But when I tried adding a user ( sarah ) with GRANT I cannot connect from php. The php is simple, what

Can connect with PHP to MYSQL

2004-08-13 Thread leegold
I can connect in the php by using 'root' and the root pw. But when I tried adding a user ( sarah ) with GRANT I cannot connect from php. The php is simple, what am I overlooking? Again putting the root user name and pw it'll work in php but not for sarah: the php mysql_pconnect("localhost",

Re: php to mysql

2004-06-03 Thread Jon Drukman
venkata ramana wrote: Hi, I don't know whether I can ask this question on this mailing list or not, but I want to know how the php communicates with mysql, when it is on the localhost. Does it use unix domain sockets or it uses TCP sockets only? Any help or pointers in this regard will be of

php to mysql

2004-06-03 Thread venkata ramana
Hi, I don't know whether I can ask this question on this mailing list or not, but I want to know how the php communicates with mysql, when it is on the localhost. Does it use unix domain sockets or it uses TCP sockets only? Any help or pointers in this regard will be of great help for me. T

RE: Slow Connection from PHP to MySQL 5.0

2004-04-16 Thread Matt Chatterley
like to keep it installed on Windows at the moment - because it's more convenient to debug (and restart)! Cheers, Matt > -Original Message- > From: [EMAIL PROTECTED] [mailto:mysql-list- > [EMAIL PROTECTED] > Sent: 15 April 2004 20:29 > To: Matt Chatterley > Subject: Re:

Slow Connection from PHP to MySQL 5.0

2004-04-15 Thread Matt Chatterley
ional. The two servers are on different subnets of a LAN, but are able to talk to each other unrestricted (all TCP services I have tried work perfectly, e.g. SMTP, FTP). The problem is that connections from PHP to MySQL seem to take 4-5 seconds (after which any queries within the connection go

[Newbie Q] csv file upload via php to mysql tutorial request

2002-11-07 Thread kristina
Hello listers My reason for emailing is this - I want to know how to upload a csv file via php to a mysql database. I have found a few examples but they are all much to advanced for my needs. I just want the bear basics so I can understand it. I can see that phpMyAdmin does this, wh

RE: Persistent connection with php to mysql

2001-03-18 Thread Cal Evans
with php to mysql Hi, some of you work with php and mysql to connect a website with a mysql database. do u prefer an simple connection or a persistent connection? and if u prefer the last one. how can u make this connection in the index.php3? do u make this with an "./include"? thank

Persistent connection with php to mysql

2001-03-18 Thread Denis Mettler
Hi, some of you work with php and mysql to connect a website with a mysql database. do u prefer an simple connection or a persistent connection? and if u prefer the last one. how can u make this connection in the index.php3? do u make this with an "./include"? thanks regards denis