PHP - Get Selected From Html Select Menu

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

Im doing a search system and Im having some problems. I need to search in two tables (news and pages), I already had sucess doing my search system for just one table, but for two tables its not easy to do. I already use a select statment with two tables using UNION because I want to show number of search results, that is number of returned rows of my first sql statment. But now I need to do a select statment that allows me to acess all fields of my news table and all fields of my pages table. I need to acess in my news table this fields: id, title, content, link, date, nViews I need to acess in my pages table this fields: id, title, content, link Im trying to do this also with UNION, but in this case Im not having any row returning. Do you see what I have wrong in my code?   <?php
//first I get my $search keyword
$search = $url[1];

$pdo = connecting();
//then I want to show number of returned rows for keyword searched
$readALL = $pdo->prepare("SELECT title,content FROM news WHERE title LIKE ? OR content LIKE ?
UNION SELECT title,content FROM pages WHERE title LIKE ? OR content like ?");
$readALL->bindValue(1,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(2,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(3,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(4,"%$search%", PDO::PARAM_STR);
$readALL->execute();
//I show number of returned rows
echo '<p>Your search keyword returned <strong>'.$readALL->rowCount().'</strong> results!</p>';
//If dont return any rows I show a error message
if($readALL->rowCount() <=0){
echo 'Sorry but we didnt found any result for your keyword search.';
}
else{
//If return rows I want to show, if it is a page result I want to show title and link that I have in my page table
//if it is a news result I want to show title and link that I have in my news table and also date of news
echo '<ul class="searchlist">';
$readALL2 = $pdo->prepare("SELECT * FROM news WHERE status = ? AND title LIKE ? OR content LIKE ? LIMIT 0,4
UNION SELECT * FROM pages where title LIKE ? OR content LIKE ? LIMIT 0,4");
$readALL2->bindValue(1, '1');
$readALL2->bindValue(2, "%$search%", PDO::PARAM_STR);
$readALL2->bindValue(3, "%$search%", PDO::PARAM_STR);
$readALL2->bindValue(4, "%$search%", PDO::PARAM_STR);
$readALL2->execute();

while ($result = $readALL2->fetch(PDO::FETCH_ASSOC)){
echo '<li>';
echo '<img src="'.BASE.'/uploads/news/'.$result['thumb'].'"/>';
echo '<a href="'.BASE.'/news/'.$result['id_news'].'">'.$result['title'].'</a>';
//if it is a news result I also want to show date on my list
//echo '<span id="date">'.$result['date'].'</span>';
echo '</li>';
}
echo ' </ul>';
//but how can I do my select statement to have access to my news table fields and my page table fields??
}
?>

Hi,
My output in html is :
Code: [Select]
<uL><li id="B1"></li>
<li id="B2"></li>
<li id="B3"></li>
<li id="B4"></li>
<li id="B5"></li>
<li id="B6"></li>
<li id="B7"></li>
<li id="B8"></li>
<li id="B9"></li>
<li id="B10"></li>
<li id="B11"></li>
<li id="B12" class="active"></li>
<li id="B13" class="no"></li>
<li id="B14" class="no"></li>
<li id="B15" class="no"></li>
<li id="B16" class="no"></li>
<li id="B17" class="no"></li>
<li id="B18" class="no"></li>
<li id="B19" class="no"></li>
<li id="B20" class="no"></li>
</ul>
If MySQL query result is equal to `6`, then `<li>` tag with `id` equal to "`B12`" should have class "`active`". All the `<li>` elements occuring after this active element should have class "`no`".

This shows images of horizontal rating between `0` and `10` and between 0.5
Example : 0 .5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10
In the example above elements from `0` to `5` will be blue, element `6` will be white and elements from `7` to `10` are black.

How could I generate this using PHP and/or MySQL?

Thanks, XXXX chirstmas XXXX

Not sure exactly where this problem is coming from, but php seems the most likely candidate to fix it.  My php loads, from a MySQL database, a list of names (students in a class) and a drop-down for each student with attendance options.  Based on the information in the database, the appropriate attendance option is selected (<option selected></option>).  Everything works fine on the initial page load. 

Next, I want to update the status, so I select a new option from the drop-down list and click submit.  The php code updates the database correctly, but the selected option (in HTML) is still the original one.  If I change the option to something different and submit again, I get the previously selected option (that I selected the first time) - in essence, the HTML is always one step behind the database.

I've attached the snippet of relevant code - again, I know that the code works when the page loads initially and that the database is getting updated correctly.  Any help or comments are appreciated.

I got a form which people can use to send a request for information to one or more recipients, depending on which recipients have been selected in the form. At the moment the HTML checkboxes all have a different name attribute and e-mails are sent using an if statement:


<input type="checkbox" name="mr-a" value="A" /> A<br />
<input type="checkbox" name="mr-b" value="B" /> B<br />
<input type="checkbox" name="mr-c" value="C" /> C<br />

if (isset($_POST['mr-a'])) {
// Send e-mail to A
}
if (isset($_POST['mr-b'])) {
// Send e-mail to B
}
if (isset($_POST['mr-c'])) {
// Send e-mail to C
}

I'm sure there's a much better way of doing this, and I think I should start by creating an array of checkboxes. But I can't figure out how to then use a loop to send the e-mails. Here's the code I got so far. I'm hoping that all I need is a loop where is says 'Send e-mails using a foreach loop?':


<?php

// Minimal validation:
if (isset($_POST['submit'])) {

$errors = array();

if (!$_POST['name'] ) {

$errors[] = 'Error: no name entered';

} else {

$name = $_POST['name'];

}

if (!$_POST['email'] ) {

$errors[] = 'Error: no e-mail address entered';

} else {

$email = $_POST['email'];

}

if (!count($errors)) {

// Send e-mails using a foreach loop?

}
?>

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="utf-8" />
 <title>Lorem Ipsum</title>
 <!--[if lt IE 9]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
 <link rel="stylesheet" href="style.css" type="text/css" />
</head>
 
<body id="index" class="home">

<h1>Lorem Ipsum</h1>
<p>Confirmation message.</p>

</body>
</html>

<?php

// Get out!

exit(0);
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="utf-8" />
 <title>Lorem Ipsum</title>
 <!--[if lt IE 9]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
 <link rel="stylesheet" href="style.css" type="text/css" />
</head>
 
<body id="index" class="home">

<h1>Lorem Ipsum</h1>
<p>Contact A, B and/or C.</p>

<?php

if (isset($errors)) {

foreach ($errors as $error) {

echo("<p class=\"red\">$error<p>");

}

}
?>

<form method="post" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>">
 <fieldset>
  <legend>Who do you want to contact</legend>
  <input type="checkbox" name="mr[]" value="A" /> A<br />
  <input type="checkbox" name="mr[]" value="B" /> B<br />
  <input type="checkbox" name="mr[]" value="C" /> C<br />
 </fieldset>
 
 <br />
 
 <fieldset>
  <legend>Your Details</legend>
  <label for="name">Name</label><input type="text" name="name" value="<?php if (isset($_POST['name'])) {echo $_POST['name'];}?>"><br />
  <label for="email">Email</label><input type="email" name="email" value="<?php if (isset($_POST['email'])) {echo $_POST['email'];}?>"><br />
  <input type="submit" name="submit" value="Next" />
 </fieldset>
</form>

</body>
</html>

Hi

I want to add student from a dropdown list to database but I have some problem.

This is my select dropdown menu code
<form name ="student" method = "POST" action ="confirmation.php">
<select name="name">
                                    <option selected>Select Student</option>
                                    <?php
                                    $arrStudent = executeSelectQuery("select * FROM user ");

                                    for ($i = 0; $i < count($arrStudent); $i++) {
                                        $student_result = $arrStudent[$i]['student_id'];
                                        $name_result = $arrStudent[$i]['student_name'];
                                    ?>
                                        <option value="<?php echo $id_result; ?>"><?php echo $id_result; ?>, <?php echo $name_result; ?></option>
                                    <?php
                                    }
                                    ?>
                                </select>
</form>

The output in the dropdown menu look something like this:
1, Alvin
2, Benny
3, Charles
4, Daniel
5, Eva
and so on...

After submitting the form, it will proceed to confirmation.php page.

At the confirmation page, I have the following variable:
$student_result = $_REQUEST['student_id'];
$name_result = $_REQUEST['student_name'];

I want to insert to database with the following insert query
$sql = "INSERT INTO student(student_id, student_name)
    VALUES ('". $student_result . "', '". $name_result ."')";
$insert = executeInsertQuery($sql);

It can insert successfully but, it will not insert the student_name.

May I know where I did wrongly?

Thanks
Ben Chew

Hi, I'm no pro at PHP but I am trying to get a drop down menu to a authenticate before moving to the next part of the form.

What I want is once a selection has been made, ONLY THEN can the user move on, OTHERWISE a message echo appears.

This is the html menu box

<select size="1" name="title">
                    <option>Please Select</option>
                    <option value="Mr">Mr</option>
                    <option value="Mrs">Mrs</option>
                    <option value="Miss">Miss</option>
                    <option value="Ms">Ms</option>
                    <option value="Dr">Dr</option>
                  </select>   

Then this is what I have in the form PHP:

$visitortitle = $_POST['visitortitle'];

if ( HOW DO I GET THIS PART TO AUTHENTICATE AN OPTION HAS BEEN SELECTED? ) {
echo "<p>Please enter a title correctly<br />before you try submitting the form again.</p>\n";
die ( '<a href="pef.html">click here go back and try again</a>' );
echo $id;}

If anyone can help me sort out this part of the form I can move on as the rest is working fine?

Thanks
Gary
 

Could someone help me I really dont know how to go about coding this, so i would be happy if someone could point me in the right way

Well what I am trying to do is use mysql_num_rows to call up how many rows in the table.

The using how many rows, use a menu with the numbers of rows that are in the table
ex below
mysql_num_rows gets 5 rows
so menu is

<select name="order" >
  <option value="1">1</option>
  <option value="2">2</option>
  <option value="3">3</option>
  <option value="4">4</option>
  <option value="5">5</option>
</select>

Hello,

I'm using a dynamically created select menu for a user to make a choice which will then be put in my database with the following code:

<select>
      <?php foreach ($course_number as $row) {
    echo "<option value = '{$row['course_id']}'";
    if ($errors && $_POST["course_id"] == $row['course_id']) {echo 'selected = "selected"';
    }
    echo ">{$row['course_number']}</option>";
    } ?>
Unfortunately, I'm having some problems figuring out how to pull off the selected value.  Right now my database portion looks like this:

$data = array('assignment_name' => $_POST['assignment_name'],

  'due_date' => $_POST['due_date'],

  'course_id' =>  $_POST["row['course_id']"]);

$inserted = $dbWrite->insert('assignments_instructors',$data)

While the assignment_name and due_dates work (they come from text fields), my course_id gives me an Undefined index: row['course_id'] error.  Any help would be appreciated.

Thank you.

I am using jquery .change function to perform an operation when a month is selected from a drop down menu. The change works but I am unable to update the value of the drop down menu with the updated month. My drop down shows the starting value as default even on change. Can anyone help. Following is the code snippet that does change and then the drop down menu form.

Code: [Select]
$("#monthName").change(function()
{
alert($("#monthName").val());
if ($("#post").val() == 1)
{
$("#monthselect").submit();
}
});
Code: [Select]
                   <form id="monthselect" action="<?=$_SERVER['PHP_SELF']?>" method="get">
                        <input id="post" type="hidden" name="post" value="1">
                        <label>SELECT MONTH</label>
                        <select id="monthName" name="monthName">
                                                     
                                <option value="January">January</option>
                                <option value="February">February</option>
                                <option value="March">March</option>
                                <option value="April">April</option>
                                <option value="May">May</option>
                                <option value="June">June</option>
                                <option value="July">July</option>
                                <option value="August">August</option>
                                <option value="September">September</option>
                                <option value="October">October</option>
                                <option value="November">November</option>
                                <option value="December">December</option>

                        </select>
                    </form>
Even after the change, January shows up by default even if I select say June or July. I tried something like following but did not work.

Code: [Select]
$("#monthName option[value=" + $("#monthName").val() +"]").attr("selected","selected") ;

hello all, I was hoping someone could help me figure out how to add sizes to my shopping cart.
Right now the items add just fine. The site sells shirts and I'm having trouble displaying the sizes once selected and added to the cart. It will post the size selected, but if the customer tries to add another shirt the size will overwrite the last.

Any help is appreciated.

Heres how I add items to the cart...
Code: [Select]
session_start();
// Process actions
$cart = $_SESSION['cart'];
$action = $_GET['action'];
switch ($action) {
case 'empty':
if($cart) {
unset($cart);
}
break;
case 'add':
if ($cart) {
$cart .= ','.$_GET['product_id'];
} else {
$cart = $_GET['product_id'];
}
break;
The form with the size selection and add to cart button..
Code: [Select]
  <form action="cart.php?action=add&amp;product_id=<?php echo $row_rs_products['product_id'] ?>" method="POST" name="addcart" id="addcart">
      <table width="300" border="0">
        <tr>
          <td><label for="sizes"></label>
            <select name="product_size" id="product_size" title="<?php echo $row_rs_products['product_size']; ?>">
              <?php
do {  
?>
              <?php
} while ($row_rs_sizes = mysql_fetch_assoc($rs_sizes));
  $rows = mysql_num_rows($rs_sizes);
  if($rows > 0) {
      mysql_data_seek($rs_sizes, 0);
  $row_rs_sizes = mysql_fetch_assoc($rs_sizes);
  }
?>
            </select></td>
          <td><input type="submit" name="submit" id="submit" value="add to cart">
function displaying the cart..
Code: [Select]
function showCart() {
global $db;
$cart = $_SESSION['cart'];
if ($cart) {
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$output[] = '<form action="cart.php?action=update" method="post" id="cart">';
$output[] = '<table>';
// start div
$output[] = '<div id="cart_table">';
//
$output[] = '<tr>';
$output[] = '<td><h4>Product</h4></td>';
$output[] = '<td><h4>Item No.</h4></td>';
$output[] = '<td><h4>Price</h4></td>';
$output[] = '<td><h4>Size</h4></td>';
$output[] = '<td><h4>Quantity</h4></td>';
$output[] = '<td><h4>Price Total</h4></td>';
$output[] = '<td><h4>&nbsp;</h4></td>';
$output[] = '</tr>';
//new row
foreach ($contents as $product_id=>$qty) {
$sql = 'SELECT * FROM products WHERE product_id = '.$product_id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
//
$output[] = '<tr>';
$output[] = '<td><a href="product.php?product_id='.$product_id.'">'.$product_title.'</a></td>';
$output[] = '<td>'.$product_plu.'</td>';
$output[] = '<td>$'.$product_price.'</td>';
//
//$output[] = '<td>'.$product_size.'</td>';
$output[] = '<td>'.$_POST['product_size'].'</td>';
//
$output[] = '<td><input type="text" name="qty'.$product_id.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
$output[] = '<td>X&nbsp;$'.($product_price * $qty).'</td>';
$total += $product_price * $qty;
$output[] = '<td><a href="cart.php?action=delete&product_id='.$product_id.'" class="r">Remove</a>&nbsp;</td>';
$output[] = '</tr>';
//end div
$output[] = '</div>';



}
$output[] = '</table>';
$output[] = '<p>Grand total: <strong>$'.$total.'</strong></p>';
$output[] = '<div class="float-right"><button type="submit">Update cart</button>';
$output[] = '</form>';

Hello All   From the begin i have the following code.

<?php
$sql = "SELECT id,phonemodel FROM iphone";
$rows = $conn->sqlExec($sql);

$nr_row = $conn->num_rows;
$meniu ='<ul>';
if($nr_row>=0) {
  foreach($rows as $row) {
     $meniu .= '<li><a href="iphone.php?id='.$row['id'].'">'.$row['phonemodel'].'</a></li>';
	 }
  }
  $meniu .= '</ul>';
  
  echo $meniu;
	 
	 if(isset($_GET['id'])) {
	    $id =  (int)$_GET['id'];
		$sql = "SELECT * FROM iphone WHERE  id = $id";
$rows = $conn->sqlExec($sql);

$nr_rows = $conn->num_rows;
if($nr_rows>0) {
  foreach($rows as $row){
   echo 'Name Tel: '.$row["phonemodel"].' Title : '.$row["titlereparation"].' 
   Pret : '.$row["price"].' Message : '.$row["msj"].' ID : '.$row["id"].'<br />';
   }
  }
  else {
  echo '0 Results';
  }
}
?> 

Basicaly i have a website for phone repairs.And i want to create in iphone.php a menu from DB and when i acces the menu with _GET variable, when i press Iphone 5s (iphone.php?id=id page) the code have to display to me,all reparations for iphone 5s. Until now,i succssed to create the Menu but the code keep add same line in the menu when i add for example a second reparation for 5s.And i don't know how to select all reparation for 5s and display them in a single link like above Iphone 5s (iphone.php?id=id page). Now the script working like this.Create a menu with all phone names. Iphone 5s Iphone 3 Iphone 3s Iphone 4 Iphone 5s Iphone 5s Shoud be like Iphone 5s Iphone 3 Iphone 3s Iphone 4 Other new devices.. And display the reparation in every link from list By ID.i try it to select by phone names,not working. Any body with any ideea please? Thx so much

Hi there,
i am relatively new to php, mysql, css etc but learning fast.
My problem is such;
i have a php file which is doing a SELECT mysql_query, WHILE results to strings, then ECHO the resulting rows to produce a list  formatted using  <table> and finally this <table> is inside a <form> which will POST the  changes back to the specific database.tble.row.

I wish to have a drop down menu within the <form><table> which will be populated from a separate database.table.

I have accomplished the drop down menu outside the <?php ?> tags inside  <form><table> which POSTS to a php file but my problem is to add the populating drop down menu inside <?php ?> an already ECHOing resulting rows from the sql query.

 i.e <?php blurb and stuff ?>
<form><table><tr><td>
<select name etc>
<?php
$result = mysql_query("SELECT * FROM tbl WHERE string = tble.rw ORDER BY column");
while($row=mysql_fetch_array($result)){
echo "<OPTION VALUE=".$row['column'].">".$row['column']."</OPTION>";
}
?>
</select> WORKS!!!!

but placing this inside

<?php $x =mysql_query[select] while {strings = conditions; echo ("<form><table><tr><td>
insert populated drop menu here
</td> etc ");
echo"";}?>

doesnt work and just leaves the select drop menu blank

Hoep you understand my problem.
I do not think i can attached the population WHILE loop to a string and just insert the string to the form but maybe i am wrong.

thanks in advance and if you go tthis far reading you must be on lots and lots of coffee

zark

Howdy everyone, please i need help changing a php coded form from a checkbox to a select menu. Here's the form.

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" >
            <table class="dtable2">
                <tr><th colspan="5">Enter a domain name:</th></tr>
            <tr><td colspan="5"><center>www.<input name="domain" type="text" size="35" /></center></td></tr>
                <tr><th colspan="5">Select an extension:</th></tr>
            <tr>
            <?php
               $i = 0;
                foreach ($this->serverList as $value) {
                    if ($value['check'] == true) $checked=" checked ";
                  else $checked = " ";
                  
                  echo '<td><input type="checkbox" name="top_'.$value['top'].'"'.$checked.'/>.'.$value['top'].'</td>';
                    $i++;                  
                  if ($i > 4) {
                      $i = 0;
                      echo '</tr><tr>';
                  }
               }
               
            ?>            
            </tr>
            </table>
            <center><input type="submit" name="submitBtn" class="sbtn" value="Check" /></center>
            </form>
<?php




I'll really appreciate your help.