PHP - How To Access Database Fields As An Array Variables ?

Hiya
I was wondering how one would get make dynamic url variable value pairs from a databases fields.

I have a database that I want to use to store variable value pairs that will be used on my pages for dynamic content.

It will check one thing for certain besides if the variable value pair match.

The table looks like this
rpg loc_type loc_type template
I want it to check if the rpg is in an array and then check if the url variable and value pair match on from the database.

I dont know much about auto code that would generate this on its own and I'm not sure if you can say

$_GET[$location];

I dont want to hard code it so it only works with what i code I want the urls variable value pair to be based on the database info which determines which template to show based on those values.

Hello,

A named field in an html form e.g.

<input type="text" name="time"> is accessed as $_GET['time'] or $_POST['time'] by the processing script.

What about an unnamed field like the one below:

<input type="text" value="" id="1" />

How do I harvest this field's input as a variable from my php processing script?

Thanks in advance

I have a user class that is very dependent on the database class, which is why the user class extends the database. I tried creating a protected method in the parent class called getDBCObject, which returned the database object/variable/handle that I want the user to have access to. I tried the method below, but it doesn't work:


<?php

/*
 * @DATABASE
 * ~~~~~~~~~~~~
 * @FILE DESCRIPTION: Handles all database related processes
 * @LAST MODIFIED: April 4, 2012
 */

class database
{
    protected $dbc;
    
    function __construct($db_host, $db_name, $db_user, $db_password)
    {
        try
        {
            $this->dbc = new PDO("mysql:host=$db_host;dbname=$db_name", $db_user, $db_password);
        }
        catch(PDOException $e)
        {
            echo '<b>An error occured while trying to create a database connection: </b>'. $e->getMessage();
        }
    }
    
    /*
     * @METHOD  getDBCObject
     * @DESC    Gives the $dbc object/variable to its child classes
     */
    
    protected function getDBCObject()
    {
        return $this->dbc;
    }
}

?>



My user class:


<?php

/*
 * @DATABASE
 * ~~~~~~~~~~~~
 * @FILE DESCRIPTION: User related proccess
 * @LAST MODIFIED: April 5, 2012
 */

class user extends database
{
    protected $dbc;
    
    public function __construct()
    {
        if(parent::getDBCObject() == null)
        {
            echo '<br/>A database class/connection is required before creating the user class.';
        }
    }
    
    public function isLoggedIn()
    {
        if($_COOKIE['user'])
        {
            //soon to come
        }
        else
        {
            return false;
        }
    }
}

?>



Any feedback on how I can let the user class use the $dbc variable in the database class?

Ok here is what i got so far and now I am stuck.  The user enters a number of how many squares (rectangles is note accurate) they wish to calculate.  If its between 1 and 100 it continues, if its any other number it tells you to put in a number between 1 and 100.  That was easy for me to do.

If the number is between 1 and 100 it creates and input for length, width and height of each rectangle. creating the variables as it goes, i.e. "length$i" when $i is the while counter and increases to the ammount of rectangles you wished to view.  Again, not that hard for me.

 So I am at the point where is I put in 50 I get length1 - through length30, width1 - width50, and height1 - height50.  THis works great.  However I now what to store those variables and calculate the area of each one via a while look which again creates an area$i variable which can be added (it would create area1 - area50 which I then wish to add together)

Here is what I have so far.

<?php
session_start();  


if (isset($_REQUEST['numpack'])) {
    if ($_REQUEST['numpack'] <= 0 || $_REQUEST['numpack'] > 100 ) {
    $error = "Please enter a number between 1 and 100";    
    echo $error;

?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<table width="0" border="0" cellspacing="5" cellpadding="5">
  <tr>
    <td colspan="2">How many Squares</td>
    </tr>
  <tr>
    <td>
      <input name="numpack" type="text"  size="4" maxlength="3"></td>
    <td><input type="submit" name="button" id="button" value="Submit"></td>
  </tr>
</table>
</form>
<?php
} else {
?>
<form name="form2" method="post" action="<?php $_SERVER['PHP_SELF']; ?>">
<?php   
   
   
   
   $i=1;
   while($i<=ceil($_REQUEST['numpack']))
  {
  ?>
  <table width="325" border="0" cellspacing="5" cellpadding="5" style="float: left;" class="aluminium">
  <tr>
    <td align="center" rowspan="2"><span class="transparent" style="color: #FFF; font-weight: bold;"><?=$i; ?>.</span></td>
    <td align="center">L</td>
    <td align="center">x</td>
    <td align="center">W</td>
    <td align="center">x</td>
    <td align="center">H</td>
  </tr>
  <tr>
    <td align="center"><input name="length<?=$i; ?>" type="text"  size="4" maxlength="3"></td>
    <td align="center">x</td>
    <td align="center"><input name="width<?=$i; ?>" type="text" size="4" maxlength="3"></td>
    <td align="center">x</td>
    <td align="center"><input name="height<?=$i; ?>" type="text"  size="4" maxlength="3"></td>
  </tr>
</table>
    <?php
  $i++;
  }
?>


</form>
<?php   
   
}
}
If (!isset($_REQUEST['numpack'])) {
?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<table width="0" border="0" cellspacing="5" cellpadding="5">
  <tr>
    <td colspan="2">How many Squares</td>
    </tr>
  <tr>
    <td>
      <input name="numpack" type="text"  size="4" maxlength="3"></td>
    <td><input type="submit" name="button" id="button" value="Submit"></td>
  </tr>
</table>
</form>    
<?php    
}
?>

Now I was reading up on session data and think this might be the best way to go, but again how do I do this? and two I want to make sure that if there are 2 people accessing it at the same time, it does not change the variables on them... (i.e. user one puts in 50 values, and user two puts in 50 different values I do not want cross contamination)

Any ideas on how to proceed?