PHP - Can I Split Showing Of Content Of Dynamic List In 2 Parts , When I Echo List

Hello PhpFreaks... been a while since I stopped by. I need to reach out for some assistance. The task I am trying to complete seems so simple, but I can't get my brain around it and have searched through these forums and the almighty google and have not found what I need. So here is what I need some directions on.

I am trying to create a multi-level un-ordered list using PHP & MySQL. It is going to be a database driven menu with an unknown number of parent items with 0 or more child items. Surely I am not the first one to need to solve this problem, but cannot find the simplest solution that gets me what I want.

Ok.. so I got a table setup like this with some test data in it....

Code: [Select]
CREATE TABLE IF NOT EXISTS `navigation` (
  `linkId` int(11) NOT NULL AUTO_INCREMENT,
  `displayName` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `parentId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`linkId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;


INSERT INTO `navigation` (`linkId`, `displayName`, `url`, `parentId`) VALUES
(1, 'Home', '/', 0),
(2, 'City Hall', '/city_hall/', 0),
(3, 'City Council', '/city_council', 0),
(4, 'Upcoming Meetings', '/city_council/upcoming_meetings.php', 3),
(5, 'Past Minutes', '/city_council/past_minutes', 3),
(6, 'Council Members', '/city_council/council_members.php', 3),
(7, 'Forms & Downloads', '/downloads', 0),
(8, 'Parks & Recreation', '/parks', 0),
(9, 'Park Name', '/parks/park.php', 8),
(10, 'Another Link', '/parks/link2.php', 8);

I have a query and loop that grabs the entire menu, and places it in 2 arrays to separate the top-level parent items and the items that have a parent id != 0.


$items = $db->getData("SELECT linkId, displayName, url, parentId FROM navigation ORDER BY parentId, linkId ASC");
while ($row = mysql_fetch_object($items['result'])) {
    if ($row->parentId == 0) {
        $parent_menu[$row->linkId]['label'] = $row->displayName;
        $parent_menu[$row->linkId]['link'] = $row->url;
    } else {
        $sub_menu[$row->linkId]['parent'] = $row->parentId;
        $sub_menu[$row->linkId]['label'] = $row->displayName;
        $sub_menu[$row->linkId]['link'] = $row->url;
    }
}

That gives me an array that looks like this.

Code: [Select]
Array(
    [1] => Array (
            [label] => Home
            [link] => /
        )

    [2] => Array (
            [label] => City Hall
            [link] => /city_hall/
        )

    [3] => Array(
            [label] => City Council
            [link] => /city_council
        )

    [7] => Array(
            [label] => Forms & Downloads
            [link] => /downloads
        )

    [8] => Array(
            [label] => Parks & Recreation
            [link] => /parks
        )

)

Array
(
    [4] => Array(
            [parent] => 3
            [label] => Upcoming Meetings
            [link] => /city_council/upcoming_meetings.php
        )

    [5] => Array(
            [parent] => 3
            [label] => Past Minutes
            [link] => /city_council/past_minutes
        )

    [6] => Array(
            [parent] => 3
            [label] => Council Members
            [link] => /city_council/council_members.php
        )

    [9] => Array(
            [parent] => 8
            [label] => Park Name
            [link] => /parks/park.php
        )

    [10] => Array(
            [parent] => 8
            [label] => Another Link
            [link] => /parks/link2.php
        )
)

Taking that array and doing a couple loops, gets me close (sorta.. I realize that there needs to be recursion for this to work).


echo '<ul>'."\r\n";
foreach($parent_menu as $pid => $pvalue){
echo '  <li><a href="'.$pvalue['link'].'">'.$pvalue['label'].'</a>'."\r\n";

foreach($sub_menu as $sid => $svalue){
if($svalue['parent'] == $pid){
echo '    <li>'.$svalue['label'].'</li>'."\r\n";
}
}

echo '</li>'."\r\n";
}
echo '</ul>'."\r\n";


That gets me a list that is not quite correct markup. The nested <ul> items are missing because I could not determine the best way to do this.

The goal for the data presented here is to be marked up like this.

Code: [Select]
<ul>
  <li><a href="/">Home</a></li>
  <li><a href="/city_hall">City Hall</a></li>
  <li><a href="/city_council">City Council</a>
    <ul>
      <li><a href="/city_council/upcoming_meetings.php">Upcoming Meetings</a></li>
      <li><a href="/city_council/past_minutes">Past Minutes</a></li>
      <li><a href="/city_council/council_members.php">Council Members</a></li>
    </ul>
  </li>
  <li><a href="/downloads">Forms &amp; Downloads</a></li>
  <li><a href="/parks">Parks &amp; Recreation</a>
    <ul>
      <li><a href="/parks/park.php">Park 1</a></li>
      <li><a href="/parks/link2.php">Another Link</a></li>
    </ul>
  </li>
</ul>

Thats where I am at here. Any ideas or tips would be helpful and appreciated. So anyone solved this problem before? Sorry for the long post, but I wanted to give all information and code that I have.

Thanks in advance,

Nathan

the line : echo $form['catcher_id'] gives me a dropdown list

when i choose another item from the dropdown i want to do a few things but my code not working:

$selected_catcher = $form['catcher_id'];
foreach($selected_catcher as $val)
{ 
$catcher_name = $val->getName();
echo $catcher_name." ".$val->getId();

if ($catcher_name = "zed-catcher")
{
echo $form['service_code']->renderLabel();
echo $form['service_code']->renderError();
echo $form['service_code'];

}
}




please help?
thanks

please help me the concept or code to retrive data from the database and display data according to the data from the dynamic list box option.

Hi,

I am hoping someone can help me out with a slight issue I have with php and mySQL.

I have an ajax-powered form with a select (dropdown) field populated through a php function. Based on the user-selected values in this field, data is displayed on the webpage; i.e. selected value 1 returns values x and y on the page. I am now trying to call additional data (value z) from a different table in the same database, and as before, use the selected values from the dropdown to display the data.

For some reason, value z is not changing according to the user-selected value.

This is my code:

[The function to populate the select field]

Code: [Select]
function kfl_get_funds_names()
{
$result = array();
$result['CDF'] = 'Crosby Dragon Fund';
$result['CPF'] = 'Crosby Phoenix Fund';
$result['AMZPIF'] = 'AMZ Plus Income Fund';
$result['KASBIIF'] = 'KASB Islamic Income Opportunity';
$result['KASBCPGF'] = 'KASB Capital Protected Gold Fund';
$result['KASBLF'] = 'KASB Income Opportunity Fund';
$result['KASBCF'] = 'KASB Cash Fund';
$result['KASBBF'] = 'KASB Asset Allocation Fund';
$result['KASBSMF'] = 'KASB Stock Market Fund';

return $result;
}
[the code calling and using the function to interact with the database]

Code: [Select]
$funds_to_display = kfl_get_funds_names();
$current_symbol = key( $funds_to_display );
$current_nav_rates = kfl_get_latest_rates( $current_symbol );
[the code calling additional data, value z, from the database, and using the info in the select field to filter it]
Code: [Select]
$cutoff = kfl_cutoff( $current_symbol );
The display of each of these items is as follows:

Code: [Select]
<?php echo $current_nav_rates['nav_date']; ?>
<?php echo $funds_to_display[$current_symbol]; ?>
<?php echo $cutoff['cutoff']; ?>
I can't get the $cutoff code to display the correct values. It picks up the first symbol to display and doesn't change with user selection. The code for the selection box, by the way:

Code: [Select]
<select id="dailynav-funds" autocomplete="off" name="dnf">
<?php
foreach ($funds_to_display as $fund_symbol => $fund_name)
{
echo '<option';
if( $fund_symbol == $current_symbol ) {
echo ' selected="selected"';
}
echo ' value="' . $fund_symbol . '">';
echo $fund_name;
echo '</option>';
}
?>
</select>
I've tried to get data using $_GET['dnf'] into the cutoff code, but that throws up parse errors. What am I doing wrong, and how can I resolve this issue?

Thanks in advance!

Hi,

i m new with php programming... I m working on one form in which i have created filter options for filter dynamic table content by completed, approve and rejected status....

but problem is when i m selecting any filtered option using select list data is displayed... but when i m clicking on next button in paging... dynamic table showing blank... same slect list getting blank.... anyone will help me...?

code of php file Code: [Select]
<?php require_once('../Connections/localhost.php'); ?>
<?php 
if (!isset($_SESSION)) { 
  session_start(); 
} 
$MM_authorizedUsers = "client"; 
$MM_donotCheckaccess = "false"; 

// *** Restrict Access To Page: Grant or deny access to this page 
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {  
  // For security, start by assuming the visitor is NOT authorized.  
  $isValid = False;  

  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username.  
  // Therefore, we know that a user is NOT logged in if that Session variable is blank.  
  if (!empty($UserName)) {  
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login.  
    // Parse the strings into arrays.  
    $arrUsers = Explode(",", $strUsers);  
    $arrGroups = Explode(",", $strGroups);  
    if (in_array($UserName, $arrUsers)) {  
      $isValid = true;  
    }  
    // Or, you may restrict access to only certain users based on their username.  
    if (in_array($UserGroup, $arrGroups)) {  
      $isValid = true;  
    }  
    if (($strUsers == "") && false) {  
      $isValid = true;  
    }  
  }  
  return $isValid;  
} 

$MM_restrictGoTo = "../index.php"; 
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {    
  $MM_qsChar = "?"; 
  $MM_referrer = $_SERVER['PHP_SELF']; 
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&"; 
  if (isset($_SERVER['QUERY_STRING']) && strlen($_SERVER['QUERY_STRING']) > 0)  
  $MM_referrer .= "?" . $_SERVER['QUERY_STRING']; 
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer); 
  header("Location: ". $MM_restrictGoTo);  
  exit; 
} 
?>
<?php 
if (!function_exists("GetSQLValueString")) { 
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")  
{ 
  if (PHP_VERSION < 6) { 
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; 
  } 

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); 

  switch ($theType) { 
    case "text": 
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; 
      break;     
    case "long": 
    case "int": 
      $theValue = ($theValue != "") ? intval($theValue) : "NULL"; 
      break; 
    case "double": 
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; 
      break; 
    case "date": 
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; 
      break; 
    case "defined": 
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; 
      break; 
  } 
  return $theValue; 
} 
} 

$currentPage = $_SERVER["PHP_SELF"]; 

$maxRows_Recordset1 = 30; 
$pageNum_Recordset1 = 0; 
if (isset($_GET['pageNum_Recordset1'])) { 
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1']; 
} 
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1; 

$myID = $_SESSION['MM_Username'];   


$mystatus=$_GET['status']; 
            switch ($options) 
            { 
            case "All"; 
            $All="selected"; 
            break; 
            case "Completed"; 
            $Completed="selected"; 
            break; 
            case"Rejected"; 
            $Rejected="selected"; 
            break; 
            case"Pending";  
            $Pending="selected";  
            break; 
            } 
            $mystatus=$_POST['status']; 
$maxRows_Recordset1 = 10; 
$pageNum_Recordset1 = 0; 
if (isset($_GET['pageNum_Recordset1'])) { 
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1']; 
} 
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1; 

//databse queary for filters 
    $query_Recordset1 = "SELECT username, Jobid, Market, General_10, Entry_Points, Dept_Points, General_Points, Total_Points FROM form_gf "; 
    if($mystatus !=='All'){ 
    $query_Recordset1 .= "WHERE status = '$mystatus'";} 
    else { 
    $query_Recordset1 .= "ORDER BY form_gf.Jobid";} 
           

mysql_select_db($database_localhost, $localhost); 

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1); 
$Recordset1 = mysql_query($query_limit_Recordset1, $localhost) or die(mysql_error()); 
$row_Recordset1 = mysql_fetch_assoc($Recordset1); 

if (isset($_GET['totalRows_Recordset1'])) { 
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1']; 
} else { 
  $all_Recordset1 = mysql_query($query_Recordset1); 
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1); 
} 
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1; 

mysql_select_db($database_localhost, $localhost); 
$query_status = "SELECT dropdown.options FROM dropdown WHERE dropdown.dropdownname = 'status'"; 
$status = mysql_query($query_status, $localhost) or die(mysql_error()); 
$row_status = mysql_fetch_assoc($status); 
$totalRows_status = mysql_num_rows($status);mysql_select_db($database_localhost, $localhost); 
$query_status = "SELECT options FROM dropdown WHERE dropdownname = 'status' ORDER BY options ASC"; 
$status = mysql_query($query_status, $localhost) or die(mysql_error()); 
$row_status = mysql_fetch_assoc($status); 
$totalRows_status = mysql_num_rows($status); 

$queryString_Recordset1 = "";           
if (!empty($_SERVER['QUERY_STRING'])) { 
  $params = explode("&", $_SERVER['QUERY_STRING']); 
  $newParams = array(); 
  foreach ($params as $param) { 
    if (stristr($param, "pageNum_Recordset1") == false &&  
        stristr($param, "totalRows_Recordset1") == false) { 
      array_push($newParams, $param); 
    } 
  } 
  if (count($newParams) != 0) { 
    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams)); 
  } 
} 
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1); 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Brakedown Report</title>
<link href="../template.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../Menu/js/jquery.js"></script>
<script type="text/javascript" src="../Menu/js/interface.js"></script>
<script type="text/javascript" src="../Menu/js/fisheye_patched.js"></script>
<!--[if lt IE 7]>
 <style type="text/css">
 .dock img { behavior: url(iepngfix.htc) }
 </style>
<![endif]-->

<link href="../Menu/style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.Header {    font-family: "Segoe UI";
    font-size: 12px;
    font-weight: 500;
    color: #CCC;}

.table {
    font-family: "Segoe UI";
    font-size: 10pt;
    border: 1px solid #000;
}
.text {
    font-family: "Segoe UI";
    font-size: 10pt;
}
a {
    font-family: "Segoe UI";
    font-size: 12px;
    color: #333;
    font-weight: bold;
}
a:link {
    text-decoration: none;
}
a:visited {
    text-decoration: none;
    color: #333;
}
a:hover {
    text-decoration: none;
    color: #36F;
}
a:active {
    text-decoration: none;
    color: #333;
}
</style>
</head>

<body>
<!--Wrapper Start-->
<div id="wrapper">
<!--Header Start-->

    <div id="header">
            <div id="logo"><img src="../images/logo.png" alt="isnlogo" width="64" height="30" align="middle" longdesc="http://www.isngs.com" /></div>
            <div id="userinfo">
              <table width="180" border="0" align="right" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="27" height="34"><img src="../images/user.png" width="26" height="30" alt="user" /></td>
                  <td width="77">Sagar Dhande</td>
                  <td width="26"><img src="../images/arrow.png" width="26" height="30" alt="arrow" /></td>
                </tr>
              </table>
            </div>
        <div id="status"></div>
    </div>
       
        <!--Header end-->
    <div id="content">
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr align="center">
    <td width="99%">   <div id="dash3">
      <div id="dash3_grid_head">Total Reccords&nbsp;&nbsp;&nbsp;&nbsp;</div>
      <div id="dash3_grid_cont_back"><br />
        <table width="890" border="0" align="center" cellpadding="0" cellspacing="0" class="table">
          <tr class="Header"><form action="" method="post">
            <td  height="55" colspan="3" align="center" valign="middle" id="filters">Filter By Status</td>
            <td align="left" valign="middle"><select name="status" id="status2" onchange="document.forms[0].submit();">
              <option value="" <?php if (!(strcmp("", $mystatus))) {echo "selected=\"selected\"";} ?>></option>
              <?php 
do {   
?>
              <option value="<?php echo $row_status['options']?>"<?php if (!(strcmp($row_status['options'], $mystatus))) {echo "selected=\"selected\"";} ?>><?php echo $row_status['options']?></option>
              <?php 
} while ($row_status = mysql_fetch_assoc($status)); 
  $rows = mysql_num_rows($status); 
  if($rows > 0) { 
      mysql_data_seek($status, 0); 
      $row_status = mysql_fetch_assoc($status); 
  } 
?>
            </select></td>
            <td align="left" valign="bottom"><a href="excel.php"></a></td>
            <td align="left" valign="bottom">&nbsp;</td>
            <td align="center" valign="middle"><a href="../excelexprt.php"></a></td>
            <td align="center" valign="middle">&nbsp;</td>
            <td align="center" valign="middle">&nbsp;</td>
            <td align="right" valign="middle"><a href="excel.php"><img src="../images/Export.png" alt="Export" width="48" height="48" border="0" /></a></td>
         </form> </tr>
          <tr class="Header">
            <td  height="2" colspan="10" align="center" valign="bottom" id="filters3"><hr  color="#333333" size="1px"/></td>
            </tr>
          <tr class="Header">
    <td  height="345" colspan="10" align="center" valign="bottom" id="filters"><a href="../excelexprt.php">
      <iframe src="pai1.php" width="485px" height="370px" frameborder="0"></iframe>
    </a></td>
     
  </tr>
          <tr class="Header">
            <td  height="22" colspan="3" align="center" valign="bottom" id="filters2">&nbsp;</td>
            <td align="left" valign="bottom">&nbsp;</td>
            <td align="left" valign="bottom">&nbsp;</td>
            <td align="left" valign="bottom">&nbsp;</td>
            <td colspan="4" align="center" valign="middle">&nbsp;</td>
          </tr>
  <tr class="Header">
    <td  style="border: 1px solid #000;"  height="44" colspan="3" align="center" valign="middle" bgcolor="#666666">Options</td>
    <td style="border: 1px solid #000;"  width="100" align="center" valign="middle" bgcolor="#666666" class="Header">Job ID</td>
    <td style="border: 1px solid #000;"  width="100" align="center" valign="middle" bgcolor="#666666">Market ID</td>
    <td style="border: 1px solid #000;"  width="100" align="center" valign="middle" bgcolor="#666666">Transaction No.</td>
    <td style="border: 1px solid #000;"  width="100" align="center" valign="middle" bgcolor="#666666">Entry Points</td>
    <td style="border: 1px solid #000;"  width="100" align="center" valign="middle" bgcolor="#666666">Department Points</td>
    <td style="border: 1px solid #000;"  width="100" align="center" valign="middle" bgcolor="#666666">General Points</td>
    <td style="border: 1px solid #000;"  width="100" align="center" valign="middle" bgcolor="#666666">Total Points</td>
  </tr>
 
  <?php do { ?> <tr>
      <td width="31" height="28"  align="center"  style="border: 1px solid #000;"><a href="../pdf.php?Jobid=<?php echo $row_Recordset1['Jobid']; ?>" target="_blank"><img src="../images/pdf.png" alt="PDF Export" width="16" height="16" border="0" /></a></td>
      <td width="31" style="border: 1px solid #000;"  align="center"><a href="../view.php?Jobid=<?php echo $row_Recordset1['Jobid']; ?>" target="_blank"><img src="../images/preview.png" alt="Preview" width="16" height="16" border="0" /></a></td>
      <td width="31" style="border: 1px solid #000;"  align="center"><a href="../update_form.php?Jobid=<?php echo $row_Recordset1['Jobid']; ?>" target="_blank"><img src="../images/Edit.png" alt="Edit" width="16" height="16" border="0" /></a></td>
      <td style="border: 1px solid #000;" align="right"><?php echo $row_Recordset1['Jobid']; ?>&nbsp;&nbsp;</td>
      <td style="border: 1px solid #000;" align="right"><?php echo $row_Recordset1['Market']; ?>&nbsp;&nbsp;</td>
      <td style="border: 1px solid #000;" align="right"><?php echo $row_Recordset1['General_10']; ?>&nbsp;&nbsp;</td>
      <td style="border: 1px solid #000;" align="right"><?php echo $row_Recordset1['Entry_Points']; ?>&nbsp;&nbsp;</td>
      <td style="border: 1px solid #000;" align="right"><?php echo $row_Recordset1['Dept_Points']; ?>&nbsp;&nbsp;</td>
      <td style="border: 1px solid #000;" align="right"><?php echo $row_Recordset1['General_Points']; ?>&nbsp;&nbsp;</td>
      <td style="border: 1px solid #000;" align="right"><?php echo $row_Recordset1['Total_Points']; ?>&nbsp;&nbsp;</td>
    </tr>
      <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>


<table border="0" align="center" width="270px">
    <tr>
          <td width="30px" valign="middle"><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
              <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>"><img src="../images/first.png" alt="First" width="16" height="16" alt="First Page" />&nbsp;</a>
<?php } // Show if not first page ?></td>
          <td width="30px" valign="middle"><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
              <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>"><img src="../images/previous.png" alt="Previous Page"  width="16" height="16" alt="previous" />&nbsp;</a>
          <?php } // Show if not first page ?></td>
          <td width="150px" style="font-family:'Segoe UI'; font-size:12px; color:#333; font-weight:700; line-height:40px;"> Records <?php echo ($startRow_Recordset1 + 1) ?> to <?php echo min($startRow_Recordset1 + $maxRows_Recordset1, $totalRows_Recordset1) ?> of <?php echo $totalRows_Recordset1 ?></td>
      <td width="30px" valign="middle"><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
              <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>"><img src="../images/Next.png"  width="16" height="16" alt="Next" />&nbsp;</a>
<?php } // Show if not last page ?></td>
          <td width="30px" valign="middle"><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
              <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1); ?>"><img src="../images/Last.png" alt="Last Page"  width="16" height="16" alt="Last" />&nbsp;</a>
          <?php } // Show if not last page ?></td>
    </tr>
  </table>
</table>
      </div>
      <div id="dash3_grid_bot"></div>
      </div><br />
  <br />
  <br />
  </td>
  </tr>
</table>

        <div id="dashboard">

         
        </div>
  </div>

    <div class="dock" id="dock2">
      <div class="dock-container2">
      <a class="dock-item2" href="client.php"><span>Dashboard</span><img src="../Menu/images/Dashboard-.png" alt="home" /></a> 
      <a class="dock-item2" href="brakedown.php"><span>Brakedown Report</span><img src="../Menu/images/brakedown.png" alt="contact" /></a> 
      <a class="dock-item2" href="Compliance.php"><span>Compliance Report</span><img src="../Menu/images/compliance.png" alt="portfolio" /></a> 
      <a class="dock-item2" href="jobstatus.php"><span>Job Status Report</span><img src="../Menu/images/jobstatus.png" alt="music" /></a> 
      <a class="dock-item2" href="reports.php"><span>Reports</span><img src="../Menu/images/charts.png" alt="video" /></a> 
      <a class="dock-item2" href="#"><span>Logout</span><img src="../Menu/images/off.png" alt="history" /></a> 
      </div>
    </div>
    <!--Menu End-->
</div>
<!--Wrapper End-->
<!--dock menu JS options -->
<script type="text/javascript">
     
    $(document).ready(
        function()
        {
            $('#dock2').Fisheye(
                {
                    maxWidth: 60,
                    items: 'a',
                    itemsText: 'span',
                    container: '.dock-container2',
                    itemWidth: 40,
                    proximity: 80,
                    alignment : 'left',
                    valign: 'bottom',
                    halign : 'center'
                }
            )
        }
    );

</script>
</body>
</html>
<?php 
mysql_free_result($Recordset1); 
mysql_free_result($status); 
?>

Please Help me guys
     

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;
}
?>

Hi,
In my mysql database i have a text input option, in the registration form and edit my details form i have a multiple select dropdown list, which user selects options to populate the text input box, which ultimately populates the text field in the mysql database.
All works perfectly.

The dropdownlist consists of 3 parts <optgroups> first is current selection (what is the usesr current selection)works fine, The second <optgroup> is existing words, what words we(the site) have given as options, and the third <optgroup> is the words that others have used. This is where im having a small problem.
Because its a text field when i call the data from the database, it calls the entire text box as a single option in my select list..

I want to break the words in the text field (at the comma) and have them listed each one as an option in the select list.


Example what i need:

Words in text box:(my input allows the "comma")
word1, word2, word3, word4, word5, word6,

How i want them called/displayed:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

here's my code:
$query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $original_functionsexperience =doSelectSql($query,1);
         $query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $functionsexperiencelist=doSelectSql($query);
          $funcexpList ="<select multiple=\"multiple\" onchange=\"setFunctionsexperience(this.options)\">";   
         foreach ($functionsexperiencelist as $functionsexperienceal)
            {
            $selected="";
            if ($functionsexperienceals->allwords == $original_functionsexperience)
               $selected=' selected="selected"';
            $allwords=$functionsexperienceal->allwords;
            $funcexpList .= "<optgroup label=\"Current selection\">
            <option value=\"".$allwords."\" ".$selected." >".$allwords."</option>
            </optgroup>      
              <optgroup label=\"Existing Words\">
              <option value=\"existing1,\">existing1</option>
              <option value=\"existing2,\">existing2</option>
              <option value=\"existing3,\">existing3</option>
              <option value=\"existing4,\">existing4</option>
              <option value=\"existing5,\">existing5</option>
              <option value=\"existing6,\">existing6</option>
         </optgroup>
         <optgroup label=\"Others added\">    //heres problem
         <option value=\"".$allwordsgeneral."\">".$allwordsgeneral."</option>
         </optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         
      
         
   The result im getting for optgroup others added:
   word1, word2, word3, word4, word5,

how can i get it like this:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

Hi, I use the following code to create a select menu from an array of options stored in LISTS.php:


include 'LISTS.php';

print('<select id="from" name="from">');
foreach ($langList as $lang) {printf('<option %s>%s</option>', 
     ($from1 == $lang ? 'selected="selected"' : ''), $lang);
     }
echo '</select>';


where LISTS.php includes the following:
$langList = array(' ','English', 'French', 'German', 'Dutch', 'Spanish');

This works great, but now I want to do something similar with a checkbox list, where each checkbox has an associated 'onchange' javascript function and I'm getting pretty stuck.

My checkbox list is of the following form:

Code: [Select]
<html>
<ul style="height: 95px; overflow: auto; width: 200px; border: 1px solid #480091; list-style-type: none; margin: 0; padding: 0;">
    <li id="li1b"><label for="chk1b"><input name="chk1b" id="chk1b" type="checkbox" onchange="function1('chk1b','li1b')">Option1</label></li>
    <li id="li2b"><label for="chk2b"><input name="chk2b" id="chk2b" type="checkbox" onchange="function1('chk2b','li2b')">Option2</label></li>
//etc.
 </ul>
</html>
What I want to do is have 'Option1', 'Option2', etc. stored in an array in LISTS.php and have a PHP script that populates the checkbox list accordingly, in a similar manner to my select menu above. I can't work out how to get the ID of the next <li> and the next <input> in the list to go up by one each time, e.g. 'li1b' then 'li2b', 'li3b', etc.

Could someone pls help me out? Thanks!

(not sure if this should be in php or javascript section)

I am trying to create a dropdown list that loads content according to the option chosen..

The idea is that you select from 4 or so dropdown boxes, which then selects the appropriate content  that the user picked

Pretty much like http://www.cooldiamonds.com/ (after you click enter)

This is what I've got so far:

Option.html
Code: [Select]

<script src="http://code.jquery.com/jquery-latest.js" type="text/javascript"></script><br>

<script type="text/javascript">

$(document).ready(function(){
  $('.select').change(function() {
   
    var option = $(this).val();
    $.get('option.php', {select:option}, function(data) {
      $('#result').html(data).hide().fadeIn(1000);
    });
  });
 
});
</script>

</head>

<body>


<p> Selection 1</p>
<select name="select" id="select" class="select">
<option value="">Select</option>
<option value="option1">Option 1</option>
<option value="option2">Option 2</option>
</select>


<p> Selection 2</p>
<select name="select2" id="select2" class="select">
<option value="">Select</option>
<option value="option3">Option 3</option>
<option value="option4">Option 4</option>
</select>

<p> Selection 3</p>
<select name="select3" id="select3" class="select">
<option value="">Select</option>
<option value="option5">Option 5</option>
<option value="option6">Option 6</option>
</select>

<p> Selection 4</p>
<select name="select3" id="select3" class="select">
<option value="">Select</option>
<option value="option7">Option 7</option>
<option value="option8">Option 8</option>
</select>


<div id="result" style="border:1px solid #000;padding:10px;color:#ff0000;display:none;"></div>

option.php
Code: [Select]
<?php

   // Multiple Selections
if ($_GET['select'] == 'option1' && $_GET['select2'] == 'option3') {
  echo 'the option you have chosen is 1 and 3';} 
elseif ($_GET['select2'] == 'option4' && $_GET['select3'] == 'option5' && $_GET['select4'] == 'option7') {
  echo 'the option you have chosen is 4, 5 and 7';}   
  
  // and so on
  
  //Selection 1
  elseif($_GET['select'] == 'option1') {
  echo 'the option you have chosen is 1';} 
  elseif($_GET['select'] == 'option2') {
  echo 'the option you have chosen is 2';} 
  
  //Selection 2
  elseif($_GET['select2'] == 'option3') {
  echo 'the option you have chosen is 3';} 
  elseif($_GET['select2'] == 'option4') {
  echo 'the option you have chosen is 4';} 

  //Selection 3
  elseif($_GET['select3'] == 'option5') {
  echo 'the option you have chosen is 5';} 
  elseif($_GET['select3'] == 'option6') {
  echo 'the option you have chosen is 6';} 

  // Selection 4
  elseif($_GET['select4'] == 'option7') {
  echo 'the option you have chosen is 7';} 
  elseif($_GET['select4'] == 'option8') {
  echo 'the option you have chosen is 8';} 
 
?>

You can view it he http://adamwatkin.com/option.html

As you can see selection 1 works fine, but the other selections do not work and neither does multiple selections.

Its almost certainty theres errors in the code, does anyone have any idea what the problem is?

Any help will be appreciated
Cheers

Is there a way to take data that is listed like a,b,c,d,e and turn that into an unordered list?

Basically, I'm going to have a list of schools that will be listed with comma separators.  I'll print that data out in two places, one will be printed as it's in the database.  The other I would like to echo as an unordered list.

How hard would something like this be? I have a database with all my users.

I need an empty list and when a user clicks a button "Add me to the list" they are added to the first position in the list

Slots
1. Tom
2.
3.
4.
5.

Later, Jerry wants to be added to the list. So this happens

Slots
1. Jerry
2. Tom
3.
4.
5.

More people join the list

1. Bob
2. John
3. Jerry
4. Tom
5.

Tom gets upset clicks the same button to join the list again, and he's bumped back up to first place. 

Slots
1. Tom
2. Bob
3. John
4. Jerry
5.

Is this possible? And is so, how would I go about getting started on such a thing? I've been using PHP for about a year and a half.

My query gets the results and orders by one of the fields.

Once I get the MySQL results I would like to find the first entry that has a letter as the first character of the same field that the list was ordered by, then split the results in to two parts and swap them.

So that the results that have a letter at the start of the same sorted field are as the begining and the results that have the numbers as the start at the end of the array.

But also so that the array works the same way as the original results string, so i can use say $results['mysqlfield']

Hello there,

this is a really noob question, but I've no idea on how to make it work without making everything messy and crappy.

I have one SQL table called categories, and another called subcategories.
Inside the subcategories table there's a field named 'parent' that will link it to the correspondent category, so it should look something like this in html:

Code: [Select]
<ul>
<li>Category
<ul>
<li>Subcategory</li>
</ul>
</li>
</ul>

Would you please give this poor guy a hand? =)