PHP - Dynamic Unordered List

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,
for uni i've got to make a shopping cart application in php/mysql. I'm almost done with it, managed to teach myself some nifty jquery and have been able to learn loads more PHP, I'm really enjoying it. I've come to a bit of a stand still though, I showed my application as it is to my lecturer and he had one little point.
My application, you have lists, each list has its own categories (users can add, edit, delete their own) and in each category, there are items (which like categorys can be added, edited or deleted).

So basically, you have a browse_list.php, which browses all the lists, each list has it's own unique hyperlink to browse_list_category.php?list_id= using the get method, it selects all the categories associated with that list, which, like browse_list.php have their own hyperlinks, but this time they link to browse_category_item.php?category_id= and they list what ever items are associated with that category. Sounds a mouth full, but it's really quite simple.

I showed my lecturer that and he wasn't happy with the whole category/item layout. He said it would be better if the category list had a nested item list underneath it. He was happy with the whole list to category part with the hyperlink, though.
Kinda like:

Quote

-list
-------category
-------item
-list1
------category1
------item1
------category2
------item2
------category3
------item3


My database layout is
tbllist -main list table, list_id, list_name
tblcategory - main category table, category_id, category_name
tblcategory_list - link table for list and category (many-many) list_id, category_id
tblitem - main item table, item_id, item_name
tbl_category_item - link table for category and item (many-many) category_id, item_id

So, now you've kinda got the gist of what I'm doing.. I just need help with displaying each item in a category, under the category.. like a nested list
<ul>
<li>category 1</li>
<ul>
<li> item 1</li>
<li> item 2</li>
<li> item 3</li>
</ul>
</ul>

I did try and have a go earlier, kinda rushed and managed to come up with this:
<ul id="sortme" class="shoppinglist">
<?php
// Split records in $result by table rows and put them in $row.
while($row = mysql_fetch_array($result)) {
echo '<li class="list" id="' . $row['category_id'] . '"><div class="text"><a href="browse_item_category.php?category_id=' .  $row['category_id'] . '">' . $row['category_name'] . "</a></div> <div class=\"actions\"><a href=\"#\" class=\"tick\">Tick</a> <a href=\"categoryupdater.php?category_id=" . $row['category_id'] . "\" class=\"edit\">Edit</a><a href=\"#\" class=\"delete\">Delete</a></div> </li>\n";
}
?><ul id="sortme" class="shoppinglist">
<?php
while($row = mysql_fetch_array($resultitem)) {
echo '<li class="list" id="' . $row['item_id'] . '"><div class="text">' . $row['item_name'] . "</div> <div class=\"actions\"><a href=\"#\" class=\"tick\">Tick</a> <a href=\"itemupdater.php?item_id=" . $row['item_id'] . "\" class=\"edit\">Edit</a><a href=\"#\" class=\"delete\">Delete</a></div> </li>\n";
}

?>
</ul>
</ul>

but this i get this

not the whole list nested'ness


it's a bit long winded I know but could anyone possible give me a hand? i've done pretty well so far not asking for help, but I think this is going to be the end of me!

Folks,

I need help (Php code ) to generate a Dynamic Text on a Base Image. What i want to do is, to make this Image as header on my Site and to make this Header Specific to a Site, i want to Add the Domain Name on the Lower Left of the Image.

Got the Idea?

Here is the Image link:

Quote

http://img27.imageshack.us/i/shoppingheader1.jpg/


PHP Variable that holds the Domain name is:  $domain 

All i need the Dynamic PHP Codes that i can put on all my sites to generate this Text on Image (Header) Dynamically...

May Anyone Help me with this Please?

Cheers
Natasha T.

Hi all

I need to combine these two scripts:

Firstly, the following decides which out of the following list is selected based on its value in the mySQL table:

<select name="pack_choice">
<option value="Meters / Pack"<?php echo (($result['pack_choice']=="Meters / Pack") ? ' selected="selected"':'') ?>>Meters / Pack (m2)</option>
<option value="m3"<?php echo (($result['pack_choice']=="m3") ? ' selected="selected"':'') ?>>Meters / Pack (m3)</option>
<option value="Quantity"<?php echo (($result['pack_choice']=="Quantity") ? ' selected="selected"':'') ?>>Quantity</option>
</select>

Although this works OK, I need it also to show dynamic values like this:

select name="category">
<?php
$listCategories=mysql_query("SELECT * FROM `product_categories` ORDER BY id ASC");
while($categoryReturned=mysql_fetch_array($listCategories)) {
echo "<option value=\"".$categoryReturned['name']."\">".$categoryReturned['name']."</option>";
}
?>
</select>

I'm not sure if this is possible?

Many thanks for your help.

Pete

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!

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.

Is it possible to get bittorrent peer list (IP list) via php, udp protocol ?

txh!

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? =)

Hello!

If you search Google, you'll notice the URL: http://www.google.com/webhp?hl=en#hl=en&source=hp&q=php+freaks&aq=f&aqi=g10&aql=&oq=&gs_rfai=CtdaTdtdRTNnPD5HuzASZtMWiCgAAAKoEBU_Q0ZT5&pbx=1&fp=19d754eee0b4f223

You can copy that URL anywhere you like... and the user will still see the same results.

So basically the URL dynamically does an action, and accesses the database.

How on do I make a URL like this? Meaning when you change the URL parameter values, it request a slightly different database query?

Does that make sense? Similarly with NexTag.com: http://www.nextag.com/serv/main/buyer/ProductCompare.jsp?search=camera&page=0&node=500001&psort=%2FDigital-Cameras--zzcameraz500001zB6z5---html&zipcode=&cptitle=657166355&cptitle=656751324&cptitle=620051906&cptitle=705150048

That was a Dynamically made URL (I selected from check boxes which products to compare) and it makes that URL so anyone can see those products.

Any ideas on how to do this?


More examples on the URL: http://www.cars.com/go/compare/modelCompare.jsp?myids=9721,11439  (i select the cars, it generates that URL. Notice the IDs 9721,11439)
 

Hi all, it's been a while since I wrote in PHP but a University project has forced me to touch up on my knowledge of it. I'm trying to re-create an old form making system I made a few years ago from memory. But it's not working. I know it's something very obvious but I just need another eye to take a look for me.

I get the following error message: Warning: Invalid argument supplied for foreach() in /home/birdneto/public_html/rebelfrogv2/p_createaccount.php on line 169

So I know it's do with my show_form(); function. Can anyone help?

Code: [Select]
<div id="page-body-special">
<?php

// List page details
$page_header = "Create your account";
$page_desc = "Enter your details below to create an account. Creating an account comes with great benefits! You can create a wishlist, sign up for our mailing list and purchase items. Make sure you enter all your information correctly.";

// List form details
$form_name = "createaccount";

// List all the field names here
$field_email_address = "email_address";
$field_email_address_confirm = "confirm_email_address";
$field_password = "password";
$field_password_confirm = "confirm_password";

$field_house_number = "house_number";
$field_street_name = "street_name";
$field_city = "city";
$field_county = "county";
$field_postcode = "postcode";
$field_phone_number = "phone_number";

$field_newsletter = "newsletter";

$field_submit = "submit";

// Define all the field meta data (field name, maxlength, minlength, field type, [field options], [field description])
$fields = array(
array($field_email_address, 80, 8, "text", $_POST[$field_email_address]),
array($field_email_address_confirm, 80, 8, "text", $_POST[$field_email_address_confirm]),
array($field_password, 16, 8, "password", $_POST[$field_password]),
array($field_password_confirm, 16, 8, "password", $_POST[$field_password_confirm]),

array($field_house_number, 2, 4, "password", $_POST[$field_house_number]),
array($field_street_name, 16, 8, "password", $_POST[$field_street_name]),
array($field_city, 16, 8, "password", $_POST[$field_city]),
array($field_county, 16, 8, "password", $_POST[$field_county]),
array($field_postcode, 16, 8, "password", $_POST[$field_postcode]),
array($field_phone_number, 16, 8, "password", $_POST[$field_phone_number]),

array($field_newsletter, 0, 0, "checkbox", $_POST[$field_newsletter], 0, "Would you like to sign up to our newsletter?"),

array($field_submit, 0, 0, "submit", "Create Account")
);

// Check if form has been submitted or not. All fields must be declared here with an if statement
if($_POST['submit'])
{
// Set no_errors and show_form to inital 0
$no_errors = 1;

function show_errors($field)
{
if($field == $field_email_address)
{
if(strlen($_POST[$field_email_address]) < $fields[0][2] and strlen($_POST[$field_email_address]) > $fields[0][1])
{
$no_errors = 0;
$error = "Your email address must be between " . $fields[0][2] . " and " . $fields[0][1] . " characters";
}
}

if($field == $field_email_address_confirm)
{
if($_POST[$field_email_address_confirm] != $_POST[$field_email_address])
{
$no_errors = 0;
$error = "Your emails do not match each other";
}
}

if($field == $field_password)
{
if(strlen($_POST[$field_password]) < $fields[2][2] and strlen($_POST[$field_password]) > $fields[2][1])
{
$no_errors = 0;
$error = "Your password must be between " . $fields[2][2] . " and " . $fields[2][1] . " characters";
}
}

if($field == $field_password_confirm)
{
if($_POST[$field_password_confirm] != $_POST[$field_password_confirm])
{
$no_errors = 0;
$error = "Your passwords do not match";
}
}

if($field == $field_house_number)
{
if(strlen($_POST[$field_house_number]) < $fields[4][2] and strlen($_POST[$field_house_number]) > $fields[4][1])
{
$no_errors = 0;
$error = "Your house number must be between " . $fields[4][2] . " and " . $fields[4][1] . " numbers";
}
}

if($field == $field_street_name)
{
if(strlen($_POST[$field_street_name]) < $fields[5][2] and strlen($_POST[$field_street_name]) > $fields[5][1])
{
$no_errors = 0;
$error = "Your street name must be between " . $fields[5][2] . " and " . $fields[5][1] . " characters";
}
}

if($field == $field_city)
{
if(strlen($_POST[$field_city]) < $fields[6][2] and strlen($_POST[$field_city]) > $fields[6][1])
{
$no_errors = 0;
$error = "Your city must be between " . $fields[6][2] . " and " . $fields[6][1] . " characters";
}
}

if($field == $field_county)
{
if(strlen($_POST[$field_county]) < $fields[7][2] and strlen($_POST[$field_county]) > $fields[7][1])
{
$no_errors = 0;
$error = "Your county must be between " . $fields[7][2] . " and " . $fields[7][1] . " characters";
}
}

if($field == $field_postcode)
{
if(strlen($_POST[$field_postcode]) < $fields[8][2] and strlen($_POST[$field_postcode]) > $fields[8][1])
{
$no_errors = 0;
$error = "Your postcode must be between " . $fields[8][2] . " and " . $fields[8][1] . " characters";
}
}

if($field == $field_phone_number)
{
if(strlen($_POST[$field_phone_number]) < $fields[7][2])
{
$no_errors = 0;
$error = "Your phone number must be under " . $fields[7][2] . " numbers";
}
}

return $error;
}

if($no_errors == 0)
{
show_form();
}
else
{
echo "<p>Form posted</p>"; echo $br . $br;
}
}
else
{
show_form();
}

function show_form()
{
// Show the page header
echo $br . '<form method="post" action="./?p=' . $page . '" name="' . $form_name . '">'; echo $br . $br;
echo '<table id="form-' . $form_name . '">'; echo $br;

// List all fields in form format
foreach($fields as $meta)
{
// Explode the array and implode it, changes commas to spaces, then makes all words have capital letters
$label_exp = explode("_", $meta[0]);
$label_imp = ucwords(implode(" ", $label_exp));

// Is the field type a submission?
if($meta[3] == "submit")
{
echo ' <tr><td colspan="2"><input type="' . $meta[3] . '" name="' . $meta[0] . '" class="' . $meta[0] . '" value="' . $meta[4] . '" /></td></tr>'; echo $br;
}
// Is the field type a select?
elseif($meta[3] == "select")
{
$options = explode(",", $meta[5]);

echo ' <tr><td><label>' . $label_imp . '</label></td><td><select type="' . $meta[3] . '" name="' . $meta[0] . '" class="' . $meta[0] . '">'; echo $br;

foreach($options as $option)
{
function is_selected()
{
if($option == $_POST[$meta[0]])
{
echo 'selected="selected"';
}
}

echo(' <option ' . is_selected($option) . '>' . $option . '</option>'); echo $br;
}

echo ' </select></td></tr>'; echo $br;
}
// Is the field type a checkbox?
elseif($meta[3] == "checkbox")
{
echo ' <tr><td><label>' . $meta[6] . '</label></td><td><input type="' . $meta[3] . '" name="' . $meta[0] . '" class="' . $meta[0] . '" /></td></tr>'; echo $br;
}
// Is the field type anything else?
else
{
echo ' <tr><td><label>' . $label_imp . '</label></td><td><input type="' . $meta[3] . '" name="' . $meta[0] . '" class="' . $meta[0] . '" maxlength="' . $meta[1] . '" value="' . $meta[4] . '" /></td></tr>'; echo $br;
}
}

// Show the page footer
echo '</table>'; echo $br . $br;
echo '</form>'; echo $br . $br;
}

echo $br . "<h1>" . $page_header . "</h1>"; echo $br . $br;
echo "<p>" . $page_desc . "</p>"; echo $br . $br;

echo '<div class="clear"></div>'; echo $br . $br;

?>
</div>