PHP - Updating A Dynamic Menu Problem

Hey guys,

I got another one that i could use some help on.  I have a input form that utilizes a javascript that adds additional rows to my table.  here is a look at what i got.

Code: [Select]
<script type="text/javascript">
function insertRow()
{
    var x = document.getElementById('results_table').insertRow(-1);
    var a = x.insertCell(0);
    var b = x.insertCell(1);
    var c = x.insertCell(2);
    var d = x.insertCell(3);
    var e = x.insertCell(4);

    a.innerHTML="<input type=\"text\" name=\"id\">";
    b.innerHTML="<input type=\"text\" name=\"place\">";
    c.innerHTML="<input type=\"text\" name=\"username\">";
    d.innerHTML="<input type=\"text\" name=\"earnings\">";
    e.innerHTML="<input type=\"button\" value=\"delete\" onClick=\"deleteRow(this)\">";
}

function deleteRow(r)
{
    var i=r.parentNode.parentNode.rowIndex;
    document.getElementById('results_table').deleteRow(i);
}

</script>
this is my code stored in the header of my page.  basically just a button to add a new row and a button in each row to delete rows if needed.

here is a look at my html table, pretty basic...

Code: [Select]
<table id="results_table">

            <th>Event ID</th><th>Place</th><th>Username</th><th>Earnings</th>

            <tr>
                <td><input type="text" name="id"></td><td><input type="text" name="place"></td><td><input type="text" name="username"></td><td><input type="text" name="earnings"></td><td><input type="button" value="delete" onClick="deleteRow(this)"</td>
            </tr>

        </table>
Now what I am hoping to acheive is once i submit all of these rows to the database i will insert each of these rows into their own row in the database.  is this doable?

the structure of my database is:

ResultID (Primary Key)
Place
Earnings
UserID (Foreign Key)
EventID (Foreign Key)


now i think the biggest problem i'm having with submitting data to the database is that in the original HTML form I am typing in the actual username and not the userID. 

so when it comes to processing I need to do a switch of these two things before I run my query.  Should something like this work?

Code: [Select]

$username = $_POST['username'];

$userID = "SELECT userID FROM users WHERE username="$username";

$query = mysql_query($userID);



also i've never tried to submit multiple entries at a time.  maybe i have to create an array somehow in order to capture each rows data.  any thoughts?

as always thanks for the help.

Hello,, I have looked for numerous examples, and have only got part of the answer.
I have successfully populated a drop down list by reading the database.
It populates with a list of quest titles. Once the user selects the quest.
I want a textbox to populate with the Quest Description.

I found an example that uses AJAX/PHP to do this, but it doesn't access a db to read/populate.
The main code is in index.html
The original example you select a country, and it populates a text field with the currency code.
It passes a variable called $country to another file called find_ccode.php.
I changed the first case in find_ccode.php to access my database, and populate the text box with quest description.
Ideally I will like to make this case dynamic based off QuestID, would populate textbox with corresponding Quest Description (QDescrip).
I then tried the other way in index.php
I dynamically populated the dropdown list, and gave the option values the QuestIDs to be passed to $country, but something isn't working.
I have a write files command to let me know what the $country variable is passing, and it never writes. It works in index.html though.
I apologize in advance for my amateurish coding. I still have a lot to learn. I have included the code below, but if you know a more elegant way of doing it. I am creating a role-playing game, as you probably have figured out by now. I hope to one day put it on the web, but right now using it as a way of learning html, and PHP.

I really want to know how to catch the value of the dropdown box. I would like to know what it is before sending over.
also what is this.value. I assume this is what the value of the dropdown box is when you have selected something.

I have been beating my head for days trying to figure this out. Any help is very much appreciated!

Index.html
<html>
<head>
<title>Changing textbox value based on dropdown list using Ajax and PHP</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script>
//  Developed by Roshan Bhattarai
//  Visit http://roshanbh.com.np for this script and more.
//  This notice MUST stay intact for legal use

//fuction to return the xml http object
function getXMLHTTP() {
      var xmlhttp=false;   
      try{
         xmlhttp=new XMLHttpRequest();
      }
      catch(e)   {      
         try{         
            xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
         }
         catch(e){
            try{
            xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
            }
            catch(e1){
               xmlhttp=false;
            }
         }
      }
          
      return xmlhttp;
   }
   
   
   
function getCurrencyCode(strURL)
{      
   var req = getXMLHTTP();      
   if (req)
   {
      //function to be called when state is changed
      req.onreadystatechange = function()
      {
         //when state is completed i.e 4
         if (req.readyState == 4)
         {         
            // only if http status is "OK"
            if (req.status == 200)
            {                  
               document.getElementById('cur_code').value=req.responseText;                  
            }
            else
            {
               alert("There was a problem while using XMLHTTP:\n" + req.statusText);
            }
         }            
       }         
       req.open("GET", strURL, true);
       req.send(null);
   }         
}
</script>




</head>

<body style="font: 12px Verdana, Arial, Helvetica, sans-serif;">

<form style="text-align:center" method="post" action="" name="form1">
<p style="color:#000099 ">When you change the dropdown list, the respective currency code of the country will be displayed in the textbox which is fetched from PHP using Ajax. </p>
<p>Country : <select name="country" onChange="getCurrencyCode('find_ccode.php?country='+this.value)"

<?php

mysql_connect('localhost', '$user', '$password');

mysql_select_db('sok');

$result = mysql_query('select QuestID,QTitle, QDescrip from QuestList');

$options="";

while ($row=mysql_fetch_array($result)) {

    $QuestID=$row["QuestID"];
    $QTitle=$row["QTitle"];
    $options.="<OPTION VALUE=\"$QuestID\">".$QTitle;
}
?>
   <option value="">Select Country</option>
   <option value="1">USA</option>
   <option value="2">UK</option>
   <option value="3">Nepal</option>   
        </select><br/><br/>
 Currency :   <input type="text" name="cur_code" id="cur_code" ></p>
</form>
</body>
</html>

Index.php
<html>
<head>
<title>Changing textbox value based on dropdown list using Ajax and PHP</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script>
//  Developed by Roshan Bhattarai
//  Visit http://roshanbh.com.np for this script and more.
//  This notice MUST stay intact for legal use

//fuction to return the xml http object
function getXMLHTTP() {
      var xmlhttp=false;   
      try{
         xmlhttp=new XMLHttpRequest();
      }
      catch(e)   {      
         try{         
            xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
         }
         catch(e){
            try{
            xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
            }
            catch(e1){
               xmlhttp=false;
            }
         }
      }
          
      return xmlhttp;
   }
   
   
   
function getCurrencyCode(strURL)
{      
   var req = getXMLHTTP();      
   if (req)
   {
      //function to be called when state is changed
      req.onreadystatechange = function()
      {
         //when state is completed i.e 4
         if (req.readyState == 4)
         {         
            // only if http status is "OK"
            if (req.status == 200)
            {                  
               document.getElementById('cur_code').value=req.responseText;                  
            }
            else
            {
               alert("There was a problem while using XMLHTTP:\n" + req.statusText);
            }
         }            
       }         
       req.open("GET", strURL, true);
       req.send(null);
   }         
}
</script>

</head>

<body style="font: 12px Verdana, Arial, Helvetica, sans-serif;">

<form style="text-align:center" method="post" action="" name="form1">
<p style="color:#000099 ">When you change the dropdown list, the respective currency code of the country will be displayed in the textbox which is fetched from PHP using Ajax. </p>
<p>Quest : <select name="country" getCurrencyCode('find_ccode.php?country='+this.value)">'

<?php

mysql_connect('localhost', '$user', '$password');

mysql_select_db('sok');

$result = mysql_query('select QuestID,QTitle, QDescrip from QuestList');

$options="";

while ($row=mysql_fetch_array($result)) {

    $QuestID=$row["QuestID"];
    $QTitle=$row["QTitle"];
    $options.="<OPTION VALUE=\"$QuestID\">".$QTitle;
   
}

$myFile = "test_catchoption.txt";
$fh = fopen($myFile, 'w') or die("can't open file");   
fwrite($fh, $options);
fclose($fh);
?>

Choose your Quest
<?=$options?>
</SELECT>
 <br/><br/>
 Quest Description :   <input type="text" name="cur_code" id="cur_code" ></p>
</form>
</body>
</html>


find_ccode.php
<?php
// Developed by Roshan Bhattarai
// Visit http://roshanbh.com.np for this script and more.
// This notice MUST stay intact for legal use
$country=$_REQUEST['country'];
$myFile = "testFilefindcc.txt";
$fh = fopen($myFile, 'w') or die("can't open file");   
fwrite($fh, $country);
fclose($fh);
switch($country)
{
   case "1" :
   mysql_connect('localhost', '$user', '$password');
    mysql_select_db('sok');

$result = mysql_query("select * from QuestList where QuestID = '1'");
$row = mysql_fetch_assoc($result);
        echo $row['QDescrip'];
      break;
   case "2" :   
      echo "GBP";
      break;
   case "3" :   
      echo "NPR";
      break;
}
?>

I'm trying to make my menu dynamic for example I will have a menu with it's submenus and when the user logs on the submenu account will then be shown where it wasn't shown before the user logged on.

here is my submenu.controller
Code: [Select]
<?php
class submenus_controller extends controller{

protected $_helpers = array('form', 'html');
protected $_observers = array('seo_uris');

public $model='submenus';

public function ajax_set_submenu($submenu_id){

$submenu=$this->_model->get($submenu_id);

$_SESSION['submenu']=$submenu;



}

}
?>

and here is my default page
Code: [Select]
<!doctype html>
<!--[if lt IE 7]> <html class="no-js ie6 oldie" lang="en"> <![endif]-->
<!--[if IE 7]>    <html class="no-js ie7 oldie" lang="en"> <![endif]-->
<!--[if IE 8]>    <html class="no-js ie8 oldie" lang="en"> <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
<head>

<title><?php echo $this->get_title();?></title>

<meta name="author" content="team digitalpro">
<meta name="viewport" content="width=device-width,initial-scale=1">

<meta name = "Description" content = "<?php echo $this->get_description();?>" />
<meta name = "Keywords" content = "<?php echo $this->get_keywords(); ?>" />

<link rel="stylesheet" href="/css/style.css">
<script src="js/libs/modernizr-2.0.6.min.js"></script>

</head>
<body>
  <div id="container">
<header>
<div class="inhoud">
<div id="logo"><a href="/"><img src="/img/logo.gif" width="306" height="126" border="0" /></a></div>
<nav>
<div class="menu">
<ul>
<?php 
if (isset($this->_params['menus']) && is_array($this->_params['menus'])){
foreach ($this->_params['menus'] as $menu){

if (!empty($menu['submenus.page_id'])){

$uri=$this->get_uri('/pages/view/'.$menu['submenus.page_id']);

}else{

$uri=$this->get_uri("/{$menu['submenus.controller']}/{$menu['submenus.action']}");

}

// p($menu);
?>
<li><a href="<?php echo $uri ?>" onclick="javascript:return setMenu(<?php echo $menu['id'] ?>);"><?php echo strtoupper($menu['name'])?></a></li>
<?php
}
}
?>
</ul>
</div>
</nav>
</div>
</header>
<div id="hero-pic">
<div id="slogans"><img src="../img/slogans.png" width="277" height="214" /></div>
<img src="../img/hero.gif" width="996" height="286" /></div>
<main>
<div id="left">
<div class="inhoud">
<div id="left-nav">
<ul>
<?php 
if (isset($this->_params['submenus']) && is_array($this->_params['submenus'])){

foreach ($this->_params['submenus'] as $submenu){

if (!empty($submenu['page_id'])){

$uri=$this->get_uri('/pages/view/'.$submenu['page_id']);

}else{

$uri=$this->get_uri("/{$submenu['controller']}/{$submenu['action']}");

}
?>
<li<?php if ($_SESSION['submenu']['id'] == $submenu['id']){?> class="active"<?php ;} ?>>
<a href="<?php echo $uri ?>" onclick="javascript:return setSubMenu(<?php echo $submenu['id'] ?>);">
<?php echo strtoupper($submenu['name'])?>
</a>
</li>
<?php
}
}
?>
</ul>
</div>
<form method="post" action="">
<input type="text" id="search" />
<input type="submit" name="button" value="GO" class="go" />
</form>
<div class="sub-links">
<ul>
<li><a href="#">Home</a></li>
<li><a href="#">Contact us</a></li>
<li><a href="#">Sitemap</a></li>
<li><a href="#">Privacy policy</a></li>
</ul>
</div>
</div>
</div>
<div id="right">
<div class="inhoud">
<?php echo $this->page('view') ?>
</div>
</div>
</main>
<footer>
<!-- <div class="inhoud">
<ul>
<li><a href="#">COMPANY </a></li>
<li><a href="#">PRIVATE EQUITY </a></li>
<li><a href="#">CONSULTING </a></li>
<li><a href="#">INVEST </a></li>
<li><a href="#">PARTNERS </a></li>
<li><a href="#">NEWS</a></li>
</ul> -->
<p>&nbsp;</p>
<p>&nbsp;</p>
</div>
</footer>
</div>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
<script>window.jQuery || document.write('<script src="/js/libs/jquery-1.6.2.min.js"><\/script>')</script>
<script defer src="/js/plugins.js"></script>
<script defer src="/js/script.js"></script>
<script>
window._gaq = [['_setAccount','UAXXXXXXXX1'],['_trackPageview'],['_trackPageLoadTime']];
Modernizr.load({
load: ('https:' == location.protocol ? '//ssl' : '//www') + '.google-analytics.com/ga.js'
});

setMenu = function(menu_id){

$.ajax({
url: "/menus/ajax_set_menu/"+menu_id,
type: 'POST',
dataType: "html",
data: {
format: 'JSON',
},
success: function(data) {

}
});
}

setSubMenu = function(submenu_id){

$.ajax({
url: "/submenus/ajax_set_submenu/"+submenu_id,
type: 'POST',
dataType: "html",
data: {
format: 'JSON',
},
success: function(data) {

}
});
}

</script>
<!--[if lt IE 7 ]>
<script src="//ajax.googleapis.com/ajax/libs/chrome-frame/1.0.3/CFInstall.min.js"></script>
<script>window.attachEvent('onload',function(){CFInstall.check({mode:'overlay'})})</script>
<![endif]-->
</body>
</html>

Hi,
I am using php dynamic listing from database. it is working but I wanna integrate to a horizontal css menu how can i integrate my codes to any css horizantal dropdown menu.

thans.

here my dynamic list.

<?php

function sinirsiz_kategori($parent) {

 
    $sql = mysql_query("SELECT * FROM kategoriler ORDER BY id DESC");

 
    while($row = mysql_fetch_array($sql)) {

         $diziler[$row['id']] = array('baslik' => $row['baslik'],'parent' => $row['parent']);

    }

 
    $has_childs = false;

 
    foreach($diziler as $key => $value)  {

            if ($value['parent'] == $parent) {       

 
                    if ($has_childs === false){

                            $has_childs = true;

                            echo "\t<ul>";

                    }

 
                    echo "<li><a href=\"".$value['baslik'].".php\">".$value['baslik']."</a>";

                    sinirsiz_kategori($key);

                    echo "</li>\n";

            }

    }

 
    if ($has_childs === true) echo "</ul>";

 
}

 
 
?>
<?=sinirsiz_kategori(0)?>

I want make the following,
(I have already a database with three tables (Countries, Timeline and Category)).

1: list of countries (drop down menu 1), Timeline of the countries history (drop down 2) and Category (drop down 3).
2: The selected values of the drop down menus must show take the information from the database.

Can any one help me with the coding?