FUDforum: comp.lang.php » Connecting to MySQL server....

Home » Imported messages » comp.lang.php » Connecting to MySQL server....

Show: Today's Messages :: Polls :: Message Navigator

Re: Connecting to MySQL server.... [message #181057 is a reply to message #181040]

Sun, 07 April 2013 18:17

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 4/7/2013 9:09 AM, M. Strobel wrote:
> Am 07.04.2013 14:32, schrieb Jerry Stuckle:
>> On 4/7/2013 4:45 AM, M. Strobel wrote:
>>> Am 07.04.2013 05:23, schrieb nag:
>>>> Hi,
>>>>
>>>> I have debconnect.php like the following...
>>>>
>>>>
>>>> <?php
>>>>
>>>> $con=mysql_connect("localhost","root","") ;
>>>>
>>>> if(!$con){
>>>> die('Error in Connection: '. mysql_error());
>>>> }
>>>> mysql_select_db('newdb',$con);
>>>>
>>>> ?>
>>>>
>>>> If I give the password or user name wrong it is flashing the error, but if the
>>>> database name wrong it is simply displaying a blank php file. How can I change the
>>>> above to show the error even if the wrong database name is given.
>>>>
>>>> Thank you.
>>>>
>>>>
>>>>
>>>>
>>> Two more observations:
>>>
>>> - you are using the deprecated mysql API, use mysqli or PDO instead.
>>> - if the db server is local, it is a lot faster to connect to a path pointing to a
>>> local socket
>>>
>>> /Str.
>>>
>>
>> "localhost" DOES use a socket (Linux) or named pipe (Windows).
>
> I am talking about the difference between AF_UNIX and AF_INET, on Linux - is this new
> that "localhost" does not start an IP connection? Can't check now, don't have a test DB.
>
> /Str.
>

No, localhost has NEVER started an IP connection in MySQL.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		Connecting to MySQL server.... By: Nagaraju Kachapuram on Sun, 07 April 2013 03:23
		Re: Connecting to MySQL server.... By: J.O. Aho on Sun, 07 April 2013 07:06
		Re: Connecting to MySQL server.... By: The Natural Philosoph on Sun, 07 April 2013 08:07
		Re: Connecting to MySQL server.... By: M. Strobel on Sun, 07 April 2013 08:45
		Re: Connecting to MySQL server.... By: Jerry Stuckle on Sun, 07 April 2013 12:32
		Re: Connecting to MySQL server.... By: M. Strobel on Sun, 07 April 2013 13:09
		Re: Connecting to MySQL server.... By: The Natural Philosoph on Sun, 07 April 2013 15:04
		Re: Connecting to MySQL server.... By: Jerry Stuckle on Mon, 08 April 2013 02:14
		Re: Connecting to MySQL server.... By: Jerry Stuckle on Sun, 07 April 2013 18:17
		Re: Connecting to MySQL server.... By: Peter H. Coffin on Mon, 08 April 2013 01:08
		Re: Connecting to MySQL server.... By: Jerry Stuckle on Mon, 08 April 2013 02:13

Previous Topic:	comparing arrays
Next Topic:	PHP with MS SQL SERVER: is it suitable?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 04:39:38 GMT 2024

Total time taken to generate the page: 0.04281 seconds