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

 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

+----+----------+-------------+
| 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...

$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.