Ad:

PHP Discussion Thread
Marked Solved
Views: 3599

Jan 29th, 2009

Set variables using php function

Expand Post »

Hi There folks.

I was thinking of trying to make a php function in my sites configuration file so that I could keep all mysql database info in one central file.

I should mention that this is the first time I have tried to make my own function.

I have the file started, but can't get it to work like I'd hoped.

Is it possible to set a variable like

PHP Syntax (Toggle Plain Text)

$username = "";

in a function and be able to insert that into a file.

I'd assumed that I would call the function and it would set the variable, but so far it hasn't worked.

Here is what I have

PHP Syntax (Toggle Plain Text)
function &configDB($db)
{
 if($db=='calendar')
 {
$cfg[host]	= "localhost";
$cfg[user]	= "MyDBs";
$cfg[pass]	= "Pass";
$cfg[database]	= "MyDB1";
 }else
{
  $server	= "localhost";
  $dbusername	= "MyDBs";
  $dbpassword	= "Pass";
  $db_name	= "MyDB2";
 }
}
function &configDB($db)
{
 if($db=='calendar')
 {
$cfg[host]	= "localhost";
$cfg[user]	= "MyDBs";
$cfg[pass]	= "Pass";
$cfg[database]	= "MyDB1";
 }else
{
  $server	= "localhost";
  $dbusername	= "MyDBs";
  $dbpassword	= "Pass";
  $db_name	= "MyDB2";
 }
}

Then Call it by

PHP Syntax (Toggle Plain Text)
configDB('main');
configDB('main');

Would this be correct.

Help in passing variables would be appreciated.

Similar Threads

insert csv file into mysql through php in PHP
optional variables in php functions in PHP
php.ini confusion in PHP
php socket server - can't connect from flash xml client socket in PHP
Passing Variables in PHP

PomonaGrange

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

67 posts
since Jun 2008

Permalink

Jan 29th, 2009

Re: Set variables using php function

Your function variables are LOCAL variables (only visible to the function). You usually have to RETURN a value from the function to pass the value to the outside. Create your complete connection variable in the function and then do:

PHP Syntax (Toggle Plain Text)

return $connection;

at the end of the function. Your example does nothing useful.

$db = 'whatever';
$conn = configDB($db);

This will then give you a your connection object in $conn and can be used to run queries:

$result = mysql_query('SELECT * FROM myTable',$conn);

However, you're hard-coding connection data (user + password). This is not recommended, although OK for testing.

ardav

Sponsor

Featured Poster

Reputation Points: 1048

Solved Threads: 948

Sarcastic Poster

Offline

6,698 posts
since Oct 2006

Permalink

Jan 29th, 2009

Re: Set variables using php function

Thanks

PomonaGrange

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

67 posts
since Jun 2008

Permalink

Jan 29th, 2009

Re: Set variables using php function

Damn! Forgot to code tag the examples. Sorry!

ardav

Sponsor

Featured Poster

Reputation Points: 1048

Solved Threads: 948

Sarcastic Poster

Offline

6,698 posts
since Oct 2006

Permalink

Jan 29th, 2009

Re: Set variables using php function

Click to Expand / Collapse Quote originally posted by ardav ...

Damn! Forgot to code tag the examples. Sorry!

Not a problem, I caught your gist...

Thanks again.

PomonaGrange

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

67 posts
since Jun 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: does anyone know to do this?

Next Thread in PHP Forum Timeline: Any more strtotime bugfixes ?

DaniWeb Message

Cancel Changes

User Name
Password