PHP - database not selected. What is wrong with my code?

Question

I am learning PHP and tried to connect to MySQL. Altough I am using select DB, is still reports "No database selected". What is wrong, please? Thanks.

<?php

$user="test";
$pass="aaa";
ConnectToDb();

function ConnectToDb()
{
$pripojeni=mysql_connect('localhost',$user,$pass);
$selectedDB=mysql_select_db('1a');
    if($query=mysql_query('select * from project')) 
  {
  while($d=mysql_fetch_array($query)) 
  {
        echo "TEST";
        }
  }
  else echo mysql_error($pripojeni);
  }
?>

Amy B · Accepted Answer · 2010-03-23 07:03:18Z

3

$user and $pass are in the wrong variable scope.

Pass the values as parameters:

ConnectToDb('test', 'aaa');

function ConnectToDb($user, $pass)
{
    $pripojeni = mysql_connect('localhost', $user, $pass);
    ...
}

answered Mar 23, 2010 at 7:03

Amy B

18k12 gold badges66 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Petr Over a year ago

Thanks..I thought its the same as other languages.

Bjoern · Accepted Answer · 2010-03-23 07:08:03Z

0

You should give the function at least some parameters... try this:

[...]

ConnectToDb($user,$pass);

function ConnectToDb($MyUser,$MyPass) {
  $pripojeni=mysql_connect('localhost',$MyUser,$MyPass);

[...]

...in order to tell your function which user and which password to use. Otherwise the function doesn't know that $user and $pass are related to it.

answered Mar 23, 2010 at 7:08

Bjoern

16.3k4 gold badges47 silver badges50 bronze badges

Collectives™ on Stack Overflow

PHP - database not selected. What is wrong with my code?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related