Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #8169

Re: about php connection string

Show all headers | View raw

On Fri, 01 Feb 2013 11:29:30 +0000, The Natural Philosopher wrote:
> On 01/02/13 11:12, Kim Andr?? Aker?? wrote:
>> P?? Fri, 01 Feb 2013 08:47:36 +0100, skrev <amitjaluf@gmail.com>:
>>
>>> Hello All
>>> i am writing a connection string to connect database to the web page
>>> but when i run this with Firefox it shows Nothing. I am using
>>> Linux(Debian) on machine.
>>>
>>> here is the code can anyone help me where i am wrong.
>>>
>>> <?php
>>>      $db=mysql_connect("localhost","xyz","");
>>>      mysql_select_db("mysql",$db);
>>>      $rs=mysql_query("select * from emp",$db);
>>>      printf("User: %s\n",mysql_result($rs,0,"Ename"));
>>> ?>
>>
>> First, what do you see if you view the page source in Firefox? Do you
>> see your original PHP code, or is it just blank? If you see PHP code, it
>> would mean that your server (Apache, nginx, etc) is not configured to
>> process PHP code.
>>
>> Second, does the database user you use to connect with actually have
>> access to the database you're selecting?
>>
>> If you don't see PHP code in your page source, you might have errors in
>> your query or database connection. To see the errors, I suggest you
>> temporarily enable error reporting to see any hidden error messages. You
>> can do this in runtime by putting these two lines at the top of your
>> first <?php code block:
>
> I found that later versions of mysql tend to default to NOT allowing 
> 'localhost' but will accept '127.0.0.1'

#1 newbie trap. "localhost" is NOT A NETWORK CONNECTION to mysql.
"localhost" is a OS socket or named pipe connection, depending on OS.

-- 
Cunningham's First Law:
Any sufficiently complex deterministic system will exhibit
non-deterministic behaviour.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

about php connection string amitjaluf@gmail.com - 2013-01-31 23:47 -0800
  Re: about php connection string Kim André Akerø <kimandre@nospambetadome.com> - 2013-02-01 12:12 +0100
    Re: about php connection string The Natural Philosopher <tnp@invalid.invalid> - 2013-02-01 11:29 +0000
      Re: about php connection string Jerry Stuckle <jstucklex@attglobal.net> - 2013-02-01 08:46 -0500
      Re: about php connection string "Peter H. Coffin" <hellsop@ninehells.com> - 2013-02-01 08:55 -0600
    Re: about php connection string amitjaluf@gmail.com - 2013-02-03 19:41 -0800

csiph-web