PHP - Dynamic Multi-level Drop Down Menu

I am having a lot of trouble with this code, and I have no clue how to fix it.  Right now, I have a GUI for a fictitious car dealership that has 5 populated drop down menus called Make, Model, Year, Color, and Mileage.  What I want the code to do is read the selections made by the user with the drop down menus once the user hits the submit button and then filter the tables that I have in a mysql database to meets the choice requirements of the user.

The code will bring up the GUI, but once I hit the submit button, I get the following errors

Please if anyone can help me that would be fantastic.  I really have no clue

What am I missing here?

The array:
protected $form_bonus = array(
"Attacker" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38), 
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array( 
"normal" => 1.195,
"rps" => 1.494),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
),
"Defender" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38), 
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.15,
"rps" => 1.38),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
)
);

accessing it:
$bonus *= form_bonus[$this->role][$this->race]['rps'];

error:
PHP Parse error:  syntax error, unexpected '['

In javascript you can do multiple methods on the same line like:
if(document.getElementById('myElement').className.match(/^[0-9]/)){/*Do something*/}

in that we have getElementById() and match() on the same line, and it works the same as if you were to split them on multiple lines.

Is it possible to do that with php?

For example:
$obj = new MyObject();

$obj->add(2, 3)->to_string();

Hi there.

Im a noob to sql and php not sure if this is right place to post,

Im trying to get a dynamic drop down menu to show the 1st column in my sql database the column is called cat and holds category info ie audio, internet, music ect. ( i have no idea how to do lol )

it has taken me 2 days to find and edit this  the bold and underline'd bit is what im trying to change with the dropdown menu.

Or thinking bout it is there a way to do it with the URL. IE.. page name.php?cat=audio ?
would that be easer ? is there any security issues with doing it that way ?


Code==================================
$db_host = '*******';
$db_user = '******';
$db_pwd = '*****;

$database = 'nbbcj_co_uk';
$table = 'penapps';

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$result = mysql_query("SELECT * FROM {$table} WHERE `cat` = 'audio' LIMIT 10 ");
if (!$result) {
    die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

//echo "<h1>Table: {$table}</h1>";
echo "<table border='1' width='100%'><tr>";
// printing table headers
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    //echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
// printing table rows
while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
        echo "<td>$cell</td>";

    echo "</tr>\n";
}
mysql_free_result($result);
?>
code end ======================

the test page can been seen here http://www.nbbcj.co.uk/testd/1/test1.php

Any more questions let me know

Thanks for any help you can give, a we all have to start some ware lol

thanks kaine.

db table    username------>id->username->cash->points->referrer db table    referral_levels------>id->level->earnings->signupBonusCash->signupBonusPoints->status

username    referrer
--------    --------
admin
kelly88     admin   // UPDATE USERNAME ADMIN WITH referral level 1 POINTS/CASH //
jacob       kelly88 // UPDATE USERNAME ADMIN WITH referral level 2 POINTS/CASH AND USERNAME kelly88 WITH referral level 1 POINTS/CASH //
david16     jacob   // UPDATE USERNAME ADMIN WITH referral level 3 POINTS/CASH AND USERNAME kelly88 WITH referral level 2 POINTS/CASH AND USERNAME jacob WITH referral level 1 POINTS/CASH //

Is this possible. If yes - HOW?   Current test registration code with referral level 1

<?php
if(!empty($_GET['ref'])){
	
	$referrerUsername = filter_input(INPUT_GET, 'ref', FILTER_SANITIZE_STRING);
	
	if(usernameExist($referrerUsername, $db) === TRUE){
		$_SESSION['ref'] = $referrerUsername;
	}
	
}

// define variables with the value for each field
// the value from POST,GET if this exist, or an empty value
$errors = array();
$username = isset($_POST['username']) ? filter_input(INPUT_POST, 'username', FILTER_SANITIZE_STRING) : '';
$referrer = !empty($_SESSION['ref']) ? $_SESSION['ref'] : (isset($_POST['referrer']) ? filter_input(INPUT_POST, 'referrer', FILTER_SANITIZE_STRING) : '');

if(!empty($_POST['submit'])){
	
	if(empty($username)){
       	 $errors[] = $lang['error']['a_019'];
    }
	else if(validUsernameLenght($username) === FALSE){
        $errors[] = $lang['error']['a_020'];
   	}
	else if(validUsernameChars($username) === FALSE){
        $errors[] = $lang['error']['a_021'];
    }
	else if(usernameExist($username, $db) === TRUE){
       	$errors[] = $lang['error']['a_022'];
    }
	
	if(!empty($referrer)){
		
		if(usernameExist($referrer, $db) === FALSE){
			$errors[] = $lang['error']['a_037'];
		}
		else if($username == $referrer){
			$errors[] = $lang['error']['a_038'];
		}
			
	}
	
}

if(!empty($_POST['submit']) and empty($errors)){
	/*
	$queryOne = 'INSERT INTO users(username, referrer) VALUES (:username, :referrer)';
	$insertOne = $db->prepare($queryOne);
	$insertOne->bindParam(':username', $username, PDO::PARAM_STR);
	$insertOne->bindParam(':referrer', $referrer, PDO::PARAM_STR);
	$successOne = $insertOne->execute();
	*/
	if($referrer){
		
		$query = 'SELECT signupBonusCash AS sbc, signupBonusPoints AS sbp FROM referral_levels WHERE level = 1 AND status = "enabled"';
		$select = $db->query($query);
		$row = $select->fetch(PDO::FETCH_ASSOC);
		
		$queryTwo = 'UPDATE users SET points = points + :points, cash = cash + :cash WHERE username = :referrer';
   	 	$selectTwo = $db->prepare($queryTwo);
		$selectTwo->bindParam(':cash', $row['sbc'], PDO::PARAM_STR);
		$selectTwo->bindParam(':points', $row['sbp'], PDO::PARAM_STR);
		$selectTwo->bindParam(':referrer', $referrer, PDO::PARAM_STR);
		$selectTwo->execute();
		
	}
	
}

if(!empty($errors)){ 
	foreach($errors as $error){
		print $error.'<br>'; 
	}
}	

print '
<form method="POST">
<table style="width:100%">
	<tr>
    	<td style="width:30%;font-weight:bold">Username</td>
    	<td style="width:70%"><input type="text" name="username" maxlength="255" style="width:200px" value="'.cleanOutput($username).'"></td>
	</tr>';
	
	if(!empty($_SESSION['ref'])){
		
		print '
	<tr>
    	<td style="font-weight:bold">'.$lang['global']['a_047'].'</td>
    	<td><input type="text" name="referrer" readonly="readonly" maxlength="255" style="width:200px" value="'.cleanOutput($referrer).'"></td>
  	</tr>';
	
	}else{
		
		print '
	<tr>
    	<td style="font-weight:bold">'.$lang['global']['a_047'].'</td>
    	<td><input type="text" name="referrer" maxlength="255" style="width:200px" value="'.cleanOutput($referrer).'"></td>
  	</tr>';
	
	}
	
	print '
	<tr>
    	<td colspan="2" style="text-align:center"><input type="submit" name="submit" value="Submit"></td>
  	</tr>
</table>
</form>'; 

?>

I want to create an array from a file with this structure

TITLE1, HEADER1, key11, key12, key13, key14
TITLE2, HEADER2, key21, key22, key23, key24
.
.
.

How I can get a foreach with these elements:

$title="TITLE"
$header="HEADER"
$key="(one random key)"

If needed, I can change the file structure too.

$form_bonus = array(
"Attacker" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38),
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.195,
"rps" => 1.494),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
),
"Defender" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38),
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.15,
"rps" => 1.38),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
)
);
echo "<pre>".print_r($form_bonus)."</pre>";

output: 1

what am i missing here?

Mmm i'm not sure if i'm approaching this correctly.

Anyways, I wanted to create a multi-level thread, Where the child thread would be after the parent thread.

Something like this:

Hello World
       - Hello World
               - Hi!
               - What's up?
       - Hi Bob!
Goodbye World
       - ....This guy got issues
       - Dude! You should watch Despicable Me! "It's so fuzzy i'm going to dieee!"


Anyways, so my table looks something along the line of this:

|    post id   |    parent_id    |            title            |      body    |   date      |
      1                |       NULL        |    Hello                  | Hi, i'm K    |   date
      2                |       NULL        |    Thread One       | Body One  |   date
      3                |          1           |    Hello World | Body One  |   date
      4                |          2           |    Thread post 4   | Body One  |   date
      5                |          1           |    Thread post 5   | Body One  |   date
      6                |          1           |    Thread post 6   | Body One  |   date
      7                |          3           |    Hi What's up    | Body One  |   date


And here's the PHP code, although it's not very neat I want to clean it up and make it neater.  I can only go two level deep so far.   Any suggestion or recommendations? 

Using while & for:


// Select * Threads
$q = "SELECT * FROM test_db ORDER BY post_id ASC";
$r = @mysql_query($q);



while ($pid_row = @mysql_fetch_object($r)) {

// Array
$pid_arr[] = $pid_row->post_id; // Assign Indexes to Post ID
$ppid_arr[] = $pid_row->parent_id; // Assign Indexes to ParentID
$md_arr = array($pid_arr, $ppid_arr);  // Create multi-dimensional array matrix

$parent_id = $pid_row->parent_id;




}

for ($i = 0; $i < count($pid_arr); $i++) {

for ($a = 0; $a < count($ppid_arr); $a++) {
$pid = $pid_arr[$i]; // pid = post id
$ppid = $ppid_arr[$i]; // ppid = parent id

//echo "<div>~~ PID $pid ~~ PPID $ppid ~~</div>";

if ($ppid === NULL) {
$ppid_is_null = " & parent_id is NULL";
} else {
$ppid_is_null = NULL;
}

// Select Top level Thread
$z = "SELECT * FROM test_db WHERE post_id = '$pid'";
$y = @mysql_query($z);

while ($t_row = @mysql_fetch_object($y)) 
{

$title = $t_row->title;  // title of child thread
$level = $t_row->level;  // level of child thread...is this useful?
}




// Display top level thread lvl 1
if ($ppid === NULL) {  // If the parent_id is NULL, display top level thread
echo '<div>PID: ' . $pid . ' || PPID: ' . $ppid . " || Title: " . $title . "</div><br>\n";

$post = $pid; // PostID = 1
$parent = $ppid; // Parent ID ex: [1]

// Get child id, where parent id = [1]
// trying to get the child thread here...but it's not working
$child_q = "SELECT * FROM test_db WHERE parent_id = '$post'";
$child_r = @mysql_query($child_q);

while($c_row = @mysql_fetch_object($child_r)) {
$c_arr[] = $c_row->post_id;
$c_ppid_arr[] = $c_row->parent_id;
}
for ($n = 0; $n < count($c_arr); $n++) {
if ($c_ppid_arr[$n] === $post) {
echo "<div>$c_arr[$n]</div>";



}

}
break;

//echo "<div>PID: $pid</div>";




} 




break;
}

}



Using While:

<?php 
require_once('db_connection');
echo '<hr><hr><br>';

// I just realized that selecting * where parent id is null might limit the amount of rows retrieved.

// Query to select threads
$n = NULL;
$q = "SELECT * FROM test_db WHERE (test_db.parent_id is NULL) Order By date ASC";
$r = @mysql_query($q);

while ($threads = @mysql_fetch_object($r)){
$pid = $threads->post_id;
$sid = $threads->subject_id;
$parent_id = $threads->parent_id;
$title = $threads->title;
$body = $threads->body;



echo '<div>PostID: ' . $pid . ' || Parent: ' . $parent_id . ' || SubjectID: ' . $sid . ' || Title: ' . $title . ' || Body: ' . $body . '</div>';

$q2 = "SELECT * FROM test_db WHERE parent_id = '$pid' Order by date DESC";
$r2 = @mysql_query($q2);

while ($level2 = @mysql_fetch_object($r2)) {
$level2_pid = $level2->post_id;
$level = 1.5 *($level2->level); // lvl 2: 3em


echo '<div style="text-indent:' . $level . 'em">' . 'PostID: ' . $level2->post_id . ' || ParentID: ' . $level2->parent_id . '</div>';


$q3 = "SELECT * FROM test_db WHERE parent_id = '$level2_pid'";
$r3 = @mysql_query($r3);
while ($level3 = @mysql_fetch_object($r3)) {

$level3 = 1.5 + $level;

echo '<div style="text-indent:' . $level3 . 'em">' . 'PostID: ' . $level3->post_id . ' || ParentID: ' . $level3->parent_id . '</div>';

}






}


}


?>


I'm not a comp. sci major or anything, so I'm learning this as I go.  Any help would be greatly appreciated.   It seems like the while & for is more practical, but i'm not quiet sure.  What am I doing wrong?

- K

I just joined this forum today ^_^  Hope to be good friends with you guys and gals

Hello,

I have the following function

function make_agent_drop($dropname,$parent=''){

$agents = mysql_query("SELECT * FROM ad_category WHERE cat_status='1'  AND parent_id='".(is_numeric($parent)?$parent:"0")."'") or die(mysql_error());

$anum = mysql_num_rows($agents);

if($anum>0){

$agentdrop='<select style="width:150px; height:20px; margin-left:100px; font-size:11px;" name="'.$dropname.'" id="'.$dropname.'" class="text" '.(is_numeric($parent)?'':'onchange="update_subcatdrop($(this).val());').'">

<option value="0">Select a Category</option>';

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

$agentdrop.='<option value="'.$row['cat_id'].'">'.$row['cat_name'].'</option>';

}

$agentdrop.='</select>';

}else{

$agentdrop= 'No '.(is_numeric($parent)?'Sub':'').'Categories Found.';

} 

return $agentdrop;

 

;
}


I creates a drop down from database cats and sub cats..  I am trying to figure out how to add a submit button to dynamically appear when it displays the sub category...

Thanks!
Dan

I am a beginner. 

How do you capture the selected value in dynamic dropdown and submit it to a different table in mysql

Holy smoke, it has been a looooooong time since I have been here. Love the new look of the site btw. Well I am working on a new project for my church. The idea is an email to SMS program. So one use of this would be that if there is a youth activity I could send a message to the entire youth group with one message. I am trying to figure out something specific with it. I need to create a form that grabs info from the database. So more specifically what I need is one drop down that will have "Youth Group", "Parents", "Deacons", etc. now based on what I select I need the second drop down to populate with the corresponding people in that group. Now I want an "All" to be in the drop down to which would let me send the message I type to ALL people in the desired group but to also have the individual names come up just in case I need to do a specific person.

How would I go about doing something like this? I have done much research and cant quite find what I would need to do. Any help would be GREATLY appreciated.

I really can't get my head around this dynamic drop box. What I want is for a drop box to be populated with values in my database.

I have this that connects to my SQL and picks out the table required:

function displayUsers(){
   global $database;
   $q = "SELECT username,"
       ."FROM ".TBL_USERS." ORDER BY userlevel DESC,username";
   $result = $database->query($q);    ...

I then have this to pick out any errors, and also using the num_rows to get the number of rows (values) there a

$num_rows = mysql_numrows($result);
   if(!$result || ($num_rows < 0)){
      echo "Error displaying info";
      return;
   }
   if($num_rows == 0){
      echo "Database table empty";
      return;
   }

From here, I guess I want the num_rows to keep 'adding on' the number of <option value=""> in my selection box according the number of values I have in my database.

At this point, I can pull out the values into a dynamic table ... but I want it into a drop box -- but I'll but up the code for the dynamic table so you can get an idea:


/* Display table contents */
   echo "<table align=\"left\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\">\n";
   echo "<tr><td><b>Username</b></td></tr>\n";
   for($i=0; $i<$num_rows; $i++){
      $uname  = mysql_result($result,$i,"username");
      echo "<tr><td>$uname</td></tr>\n";
   }
   echo "</table><br>\n";
}

I hope you can use the code above to help me develop this darn drop box!

Thanks, Ollie!

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=306771.0

Hi,

Can anyone point me in the right direction please? I want to have a drop down box which when a user clicks on a category the results on the page have changed to show only the data which is relative to the category chosen by the user. I also need a way so that when they click view all they are able to see all the results again.

Not really sure what to look for or even how hard this might be.

Lee   

I have attempted to get a php reporting page built for our off site managers to run reports.  Because of the number of employees I think it ouwld be best to sort by foreman, then be able to pick from the resulting drop down list of current employees under that foreman.   My issue I think really comes from having the first drop down be dynamic in that you would see a list of foremen which comes from a query of the main employees table and then picks up only active employees and their foreman.  The tutorials I have seen all reference an 'id" field but since I am pulling the info for the drop down from a query, should I have some sort of rowID?  If so how?  The tutorial I have found checks to see if you pick a number which I seem to have gotten around but when I do the query and look for $GF (general foreman) then the query comes back empty (this is bolded and underlined below).  Should this be some sort of rowID for the general foreman drop down?   Below is what I have been able to sort-of get working (adding in the URL handlers I think will be useful for people in the future to be able to bookmark it/send out emails with links already in it etc)   Here is the tutorial http://www.plus2net....p_down_list.php   Not sure if i understand why he used the $nocitia tags either   I know Im close on this but am starting to go crosseyed!  Thanks for pointing me in the right direction.

<?php
require 'config.php';  // Database connection
//////// End of connecting to database ////////
?>

<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>Multiple drop down list box</title>
<SCRIPT language=JavaScript>
function reload(form)
{
var val=form.GF.options[form.GF.options.selectedIndex].value;
var val2=form.EMPLOYEE_ID.options[form.EMPLOYEE_ID.options.selectedIndex].value;
var val3=form.SEPARATED.options[form.SEPARATED.options.selectedIndex].value;

self.location='dd3.php?GF=' + val + '&EMPLOYEE_ID=' + val2 + '&SEPARATED=' + val3 ;
}

</script>
</head>

<body>
<?Php

@$GF=$_GET['GF']; // Use this line or below line if register_global is off
@$EMPLOYEE_ID=$_GET['EMPLOYEE_ID']; // Use this line or below line if register_global is off
@$SEPARATED=$_GET['SEPARATED']; // Use this line or below line if register_global is off


///////// Getting the data from Mysql table for first list box//////////
$quer2="SELECT tbl_Employee_Master.Current_GF as GF FROM tbl_Employee_Master GROUP BY tbl_Employee_Master.Current_GF, tbl_Employee_Master.Separated HAVING (((tbl_Employee_Master.Separated)=0))";
///////////// End of query for first list box////////////

/////// for second drop down list we will check if category is selected else we will display all the subcategory/////
if(strlen($GF) > 0){
$quer="SELECT Employee_ID tbl_Employee_Master WHERE Current_GF=$GF";
}else{$quer="SELECT DISTINCT Employee_ID, Last_Name, First_Name FROM tbl_Employee_Master order by Last_Name"; }
////////// end of query for second subcategory drop down list box ///////////////////////////

echo "<form method=post name=f1 action='dd-check.php'>";
/// Add your form processing page address to action in above line. Example  action=dd-check.php////
//////////        Starting of first drop downlist /////////
echo "<select name='GF' onchange=\"reload(this.form)\"><option value=''>Select one</option>";
foreach ($dbo->query($quer2) as $noticia2) {
if($noticia2['GF']==@$GF){echo "<option selected value='$noticia2[GF]'>$noticia2[GF]</option>"."<BR>";}
else{echo  "<option value='$noticia2[GF]'>$noticia2[GF]</option>";}
}
echo "</select>";
//////////////////  This will end the first drop down list ///////////

//////////        Starting of second drop downlist /////////
echo "<select name='EMPLOYEE_ID'><option value=''>Select one</option>";
foreach ($dbo->query($quer) as $noticia) {
echo  "<option value='$noticia[Employee_ID]'>$noticia[Employee_ID] $noticia[Last_Name] $noticia[First_Name]</option>";
}
echo "</select>";
//////////////////  This will end the second drop down list ///////////
//// Add your other form fields as needed here/////
echo "<input type=submit value=Submit>";
echo "</form>";
?>
<br><br>
<a href=dd.php>Reset and start again</a>
<br><br>
<center><a href='http://www.plus2net.com' rel="nofollow">PHP SQL HTML free tutorials and scripts</a></center>
</body>

</html>