create a new page on submit from database

[tibewww]

Hi everybody,
 
I'm starting with PHP and Mysql, so it's getting diffictul at this poinf for me and i'm looking for a bit of help =).
 
I've created a chained menu using php and a database, following this tutorial:

http://www.yourinspirationweb.com/en/how-to-create-chained-select-with-php-and-jquery/
 
The frist table content a list of categories like :
 
CREATE TABLE IF NOT EXISTS `chainmenu_categories` (
  `id_cat` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  PRIMARY KEY (`id_cat`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
 
My second table, the type, like :
 

CREATE TABLE IF NOT EXISTS `type` (
  `id_type` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `id_cat` int(4) unsigned NOT NULL,
  `name` varchar(40) NOT NULL,
  `destination` varchar(40) NOT NULL,
  PRIMARY KEY (`id_type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
 
I managed, once cliking on submit, to redirect to an other page by that in my select.php:

 

var result = $("select#type option:selected").html();

$("#select_form").submit(function( event ) {

  var the_url = $("#type").val();

  window.location = the_url;

  event.preventDefault();

});

 

and adding this on my select.class.php

 

public function ShowCategory()

        {

            $sql = "SELECT * FROM chainmenu_categories";

            $res = mysql_query($sql,$this->conn);

            $category = '<option value="0">choose...</option>';

            while($row = mysql_fetch_array($res))

            {

                $category .= '<option value="' . $row['id_cat'] . $row['destination']. '">' . $row['name'] . '</option>';

            }

            return $category;

        }

 

So now it redirect each time to a different  page depending of the option choose from the menu, like: http://mydomain.com//3 or http://mydomain.com//4 or http://mydomain.com//5 etc etc

 

But as the page doesnt exist, it redirect each time to a dead link,

 

Is anybody can give me a help to create these pages from the chained menu ( or have some highlite) ? and If possiblles, some pointer to create the admin interface to allow an admin to add the pages / chained menu ?

 

I've been trying to start with something which look like:

 

<?php require('db_config.php'); 

 

 

 

$stmt = $db->prepare('SELECT id_type, name FROM type WHERE id_cat=$_POST[id]');

$stmt->execute(array(':id_cat' => $_GET['name']));

$row = $stmt->fetch();

 

but dont know if i'm in the good way at all, I' just so confused !

Thank you in advance for your recommandatiosn guys !!

 

[tibewww]

the link of the original tutorial ( without the submit working) is:

 

http://www.yourinspirationweb.com/en/how-to-create-chained-select-with-php-and-jquery/