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 #181032 is a reply to message #181031]

Sun, 07 April 2013 07:06

J.O. Aho
Messages: 194
Registered: September 2010

Karma:

Senior Member

On 07/04/13 05:23, nag wrote:
> 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.

Check the example in the online documentation page.
http://www.php.net/manual/en/function.mysql-select-db.php

It's not the perfect way to do it. I would suggest you used try/catch
and throw an exception, the catch would tell the user that there is some
issues (do not show what went wrong, as that can be used to hack your
site), keep in mind to generate the theme outside the try/catch, this
way all pages will look nice no matter what happens.
Use syslog http://www.php.net/manual/en/function.syslog.php
to log what went wrong, now you have somewhere to find all the errors
and without displaying it to the whole world.

--

//Aho

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:34:03 GMT 2024

Total time taken to generate the page: 0.04555 seconds