Re: How to replace define in a require file with mysql?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ronald Wiplinger wrote:
Jim Lucas wrote:
Ronald Wiplinger wrote:
I have a file linked with require into my program with statements like:

define("_ADDRESS","Address");
define("_CITY","City");

I would like to replace this with a mysql table with these two fields
(out of many other fields).

How can I do that?

bye

Ronald

Well, if you have all the settings in a DB already, then what I would
do is this.

SELECT param_name, param_value FROM yourTable;

then

while ( list($name, $value) = mysql_fetch_row($results_handler) ) {
    define($name, $value);
}

put this in place of your existing defines and you should be good.


Thanks! Works fine!
I need now a modification for that.

Two values:
SELECT param_name, param_value1, param_value2 FROM yourTable;

IF param_value1 is empty, than it should use param_value2

How can I add this?

Thank you again.

bye

Ronald
In PHP i would do it like this.

while ( list($name, $value1, $value2) = mysql_fetch_row($results_handler) ) {
	define($name, ( empty($value1) ? $value2 : $value ) );
}


--
Jim Lucas

   "Some men are born to greatness, some achieve greatness,
       and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V
    by William Shakespeare

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux