RE: [PHP-DB] Connecting to MySQL

2011-01-15 Thread Cristiano Di Buduo
Resolved itself, just had to reboot. Works fine now. Thanks anyway :) From: cristiano_di_bu...@hotmail.com To: phps...@gmail.com Subject: RE: [PHP-DB] Connecting to MySQL Date: Fri, 14 Jan 2011 21:58:33 +0100 It outputs: PDO PDO support enabled

Re: [PHP-DB] Connecting to MySQL

2011-01-15 Thread Kranthi Krishna
note that you'll have to restart apache after any changes to httpd.conf/php.ini in your case httpd.conf was changed when u installed PDO Kranthi. http://goo.gl/e6t3 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Connecting to MySQL

2011-01-14 Thread Bastien Koert
On Fri, Jan 14, 2011 at 2:15 PM, Cristiano Di Buduo cristiano_di_bu...@hotmail.com wrote: I just downloaded both PHP and MySQL, both newest stable versions, both are working well, but when i try{} to :     $dbh = new PDO('mysql:host=localhost;dbname=test', user, passwd); i catch{} a could

Re: [PHP-DB] Connecting to mysql from another host

2007-08-03 Thread Goltsios Theodore
Well you it depends on what method you use to access mysql. If for instance if you use PDO you could do something like that to connect and query: ?php $dbhost = 'remote_hostname'; $dbuser = 'mysql_username'; $dbpass = 'mypass'; $db = 'database_to_use'; $db_handler = new

Re: [PHP-DB] Connecting To Mysql through php/mysqli

2005-02-03 Thread David Robley
On Thu, 3 Feb 2005 13:49, Graeme wrote: I like the idea of a mysqli_queasy() function. Maybe it would allow you to sumbit SQL statements that don't conform to any standard? ;) graeme. Bastien Koert wrote: the second error is a misspelling in the mysqli_query command bastien Call to

RE: [PHP-DB] Connecting To Mysql through php/mysqli

2005-02-02 Thread Bastien Koert
mysqli_select_db progblem is that the arguements are reversed, should be $link, $dbname the second error is a misspelling in the mysqli_query command bastien From: J. Connolly [EMAIL PROTECTED] To: PHP list php-db@lists.php.net Subject: [PHP-DB] Connecting To Mysql through php/mysqli Date: Wed,

RE: [PHP-DB] Connecting To Mysql through php/mysqli

2005-02-02 Thread J. Connolly
Thank you Bastian, I found that the two variables were reversed right when your answer came in. The book i got is horrible. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Connecting To Mysql through php/mysqli

2005-02-02 Thread graeme
I like the idea of a mysqli_queasy() function. Maybe it would allow you to sumbit SQL statements that don't conform to any standard? ;) graeme. Bastien Koert wrote: the second error is a misspelling in the mysqli_query command bastien Call to undefined function mysqli_quesry() in C:\Apache --

Re: [PHP-DB] connecting to mySQL - testing server specified doesnot map to the http://localhost/_MMServerScript/MMHTTPDB.php

2003-06-17 Thread John W. Holmes
Ildiko Nyari wrote: I have installed the PHP, mySQL and Apache on WIN XP, but: 1. when I want to open in the explorer: http://localhost/test.php I always get a download window, and than my Dreamweaver MX opens, and so I can't see the test.php file I created in the explorer. You don't have

RE: [PHP-DB] connecting to mySQL - testing server specified does not map to the http://localhost/_MMServerScript/MMHTTPDB.php

2003-06-17 Thread Creative Solutions New Media
PHP is for sure not installed correctly. I hand a similar problem when I did the install for the first time. It was a while agoand I don't remember clearly but I seem to remember that it had to do with mis-configuring apache for PHP. Honestly the best solution for all the time it would take

RE: [PHP-DB] Connecting to Mysql Server

2003-01-29 Thread Neil Lathwood
web man wrote: How can I change the default connecting port using php script. That depends on hwo you connect currently, try this: http://www.php.net/manual/en/function.mysql-connect.php Neil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Connecting to mySQL database

2002-02-16 Thread DL Neil
Hi Alvin, I'm new to both PHP and mySQL but have no choice but to crash-course on both before end of mid of march to complete my University project. I would really appreciate alittle help from any kind soul out there. I have already created a mySQL database and create all the tables *well

RE: [PHP-DB] Connecting to MySQL Database

2001-12-13 Thread Jonathan Hilgeman
Can you show us the code that checks the username and password to see if they're correct? Is this a custom admin page that you created? If your page is authenticating against the mysql database, then you should know that MySQL encrypts the password and stores the encrypted password. So if

Re: [PHP-DB] Connecting to MySQL Database

2001-12-13 Thread Michael Elliott
Alright here goes. This is my login function: function login($username, $password) // check username and password with db // if yes, return true // else return false { // connect to db $conn = db_connect(); if (!$conn) return 0; // check if username is unique $result =

RE: [PHP-DB] Connecting to MySQL Database

2001-12-13 Thread Jonathan Hilgeman
would be to put all the session information at the very top of the script. - Jonathan -Original Message- From: Michael Elliott [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 8:40 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Connecting to MySQL Database Alright here goes

Re: [PHP-DB] Connecting to MySQL

2001-06-22 Thread Christopher Ostmo
Keith Whyman pressed the little lettered thingies in this order... Can anyone help with this problem ! user name should just be keith but the @localhost gets added and then I can't connect ??? Warning: MySQL Connection Failed: Access denied for user: 'keith@localhost' (Using password:

Re: [PHP-DB] Connecting to MySQL

2001-06-22 Thread Keith Whyman
Thanks everyone for the help ! Discovered the problem ! My provider had changed the name of the host, without telling anyone ! ahhh the sort of thing that makes life fun ! :-) Sounds like either: 1) You don't have your correct username/password info in the mySQL/user table or 2) Your

Re: [PHP-DB] Connecting to MySQL

2001-06-22 Thread Dobromir Velev
Hi, the @localhost is to show the database server you are trying to log on and it has nothing to do with your problem. Please check your username and password and if you have the right permissions. Dobromir Velev -Original Message- From: Keith Whyman [EMAIL PROTECTED] To: [EMAIL

Re: [PHP-DB] Connecting to MySQL

2001-06-22 Thread Jan de Koster
What needs to be done is that you create a new user in the 'user' databese where you replace 'localhost' with the IP number of the machine you will be using to log in to your database and then grant the appropriate priviliges. hope to have been of any help. jan Lester June Cabrera wrote: How

Re: [PHP-DB] Connecting to MySQL

2001-06-22 Thread Andreas D. Landmark
At 22.06.2001 09:42, you wrote: How can I connect to our MySQL server remotely. Ordinarily, we upload the same PHP application the same machine that runs MySQL too. So, I just access it using localhost in the mysql_connect( ) function, like:

RE: [PHP-DB] Connecting to MySQL

2001-06-21 Thread Jonathan Hilgeman
Sounds like either: 1) You don't have your correct username/password info in the mySQL/user table or 2) Your server is bound to an IP address or something (a frequent problem on Win machines, but it looks like you're using Linux or something) The localhost part isn't really the username that is