Database Tables & PHP Variables

[jamie_scott]

Hi all,

let see where do I begin...

I have a php website that calls a number of variables from a config.inc file e.g. <?php $companyname ?>. Therefore I only need to change the config file to make all necessary changes across multiple pages.. Easy enough hey.

Now I want to take this one step further and write all of these variables into a mysql database table rather than the config.inc file. That way I can add a front end e.g. DaDaBIK and change all avaiable content on the fly.

My question is how and what is the best was of doing this? I am able to create the table but not sure how I can write a table field to a variable e.g.

Row1 = Hello World

My variable: $companyname = Row1 ????

Any help on this would be most appreciated.

Cheers

Jamie

[tsinka]

Hi,

you could create a table like

parameter:
parameter_id (auto_increment, you only need it if you want to access parameters by id)
parameter (varchar)
value (varchar)

Taking your example it could contain:

1,'companyname','Hello World'

in the php code (shortened):

    query_to_read_out_records
    loop result_set {
        $variable = $result['parameter'];
        $value = $result['value'];

    ${$variable} = $value;
}

In this case ${$variable} = $value would be the same as:

$companyname = "Hello World";

and you can access it with $companyname later in the code.

Another way would be to create an array inside the loop and to use it later in the code:

$arrParams[$variable] = $value;

Thomas