PHP Array from mysql table

ajnoz

I am currently trying to make a website. I have an array that is for the variable $page. It currently looks like

Expand|Select|Wrap|Line Numbers

 
 if ($page == logout){include ('logout.php');}

  $pages = array(
 
        'register'        => 'regform.php',

        'verify'        => 'verify.php'

    );
 
    if (array_key_exists($page, $pages))

        include($pages[$page]);

I am trying to put all of this into an sql table, which currently looks like

Expand|Select|Wrap|Line Numbers

 +----+----------+-------------+

| id | name     | page        |

+----+----------+-------------+

|  1 | register | regform.php |

|  2 | verify   | verify.php  |

+----+----------+-------------+

I have tried a few different pieces of code but so far nothing has worked.

if you can advise, that would be great

TheServant

How about a foreach loop? I will do it for MySQL, but logic is the same for SQL...

Expand|Select|Wrap|Line Numbers

 $query = "INSERT INTO table (";

$values = " (";
 
foreach($pages as $name=>$page) {

$query .= $name . ", "; // To get: register, verify, etc...

$values .= "'$page', "; // To get: 'regform.php', 'verify.php', etc...

}
 
/* remove last commas and replace with closing brackets */

$query = substr_replace($query ,")",-2);

$values = substr_replace($values ,")",-2);
 
$query_string = $query . $values;
 
/* Run $query_string */

Or something to that effect.

PHP Array from mysql table

re: PHP Array from mysql table

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about