PHP code to select a value of a select control in HTML

Question

3.00/5 (2 votes)

See more:

I have a control in html look like this.

PHP

<select  name='diet' class='inputbox'>
         <option value=''>Select one</option>
         <option value='VEG' >VEG</option>
         <option value='Non-Veg' >Non-Veg</option>
         <option value='Eggiterian' >Eggiterian</option>
       </select>

Now through PHP I stored the data in MYSQL.
Now at the time of retrieve, I execute a query.

Like this

PHP

$qry="SELECT diet FROM tablename where id=" .$id ;
$res=mysql_query($qry);
while($val = mysql_fetch_array($res))
{
 //please help me here to select the above control's value
}

Database can store only VEG, non-VEG, or Eggiterian value.
at the time of retrieval process it should select the value present in the query result.

Please help me.

I want to select the value of the combo box by the value of my query result.

PHP

$qry="SELECT diet FROM tablename where id=" .$id ; 
$res=mysql_query($qry); 
while($val = mysql_fetch_array($res)) 
{ 
echo " <select name='diet' class='inputbox'>
 <option value=''>Select one</option> 
<option value='VEG' >VEG</option>
 <option value='Non-Veg' >Non-Veg</option> 
<option value='Eggiterian' >Eggiterian</option>
 </select>"; 
}

I need to select the option of combo box with the value present in my database table. Value will be either veg or non-veg or eggiterian. please help

Posted 6-Oct-12 0:23am

Sourav Sarkar-SS

Updated 6-Oct-12 1:25am

v2

Add a Solution

2 solutions

Solution 1

Try:

PHP

$diet= $_POST["diet"];

Refer: PHP HTML Form Example[^]

Posted 6-Oct-12 0:30am

Sandeep Mewara

Comments

[no name] 6-Oct-12 7:04am

no dear
you didn't understood my question
I want to select the value of the combo box by the value of my query result.
$qry="SELECT diet FROM tablename where id=" .$id ;
$res=mysql_query($qry);
while($val = mysql_fetch_array($res))
{
echo " <select name='diet' class='inputbox'>
<option value=''>Select one</option>
<option value='VEG' >VEG</option>
<option value='Non-Veg' >Non-Veg</option>
<option value='Eggiterian' >Eggiterian</option>
</select>";
}

I need to select the option of combo box with the value present in my database table. Value will be either veg or non-veg or eggiterian.

please help

[no name] 6-Oct-12 9:24am

this is very bad
giving wrong answer
and not replying after that
It pretend others to give the answer
you are a ..........

Sandeep Mewara 6-Oct-12 10:21am

You fail to post proper question and then try to abuse later.

Thanks, but you are not welcome.

[no name] 6-Oct-12 10:58am

first what is wrong in my question?
second when I replied why you are not replied?
third you are not a judge who decide its a proper question or not, if you didn't understood the question then can ask for clarification or leave for others to answer

Sandeep Mewara 6-Oct-12 11:29am

what is wrong in my question?
Answer was based on what you asked. Now, you say it is not so and try to abuse. Forget it.

when I replied why you are not replied?
I will not sit whole day for you to reply back

you are not a judge who decide its a proper question or not,
Everyone can judge that so can I. Just like you can judge an answer is right or not and downvoted me. So, don't try to tell me what I can do and what I cannot.

Don't expect any more comment from me. It was not nice knowing you so, have a nice day. Bye.

[no name] 6-Oct-12 14:41pm

Me too
Its a feeling like in hell by knowing you and talking with you.
I don't need any of your f***ing suggestion any more.
Don't answer my question any more.
stay out of these, If you don't know
be happy with .Net what you know

[no name] 6-Oct-12 11:00am

now can you please delete your answer as its a wrong answer and that make my question unanswered and let others to answer my question.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrick Wanjau · Accepted Answer · 2012-10-06T08:35:00

Solution 2

PHP

if(isset($_REQUEST['diet'])){
  $id = $_REQUEST['diet'];
  $res = mysql_query("SELECT diet FROM tablename where id=".$id);
  while($val = mysql_fetch_array($res)){
    echo $val['diet']."<br />";
    next($val);
  } 
}
?>

See if this works. All the best...:-)

Posted 6-Oct-12 8:35am

Patrick Wanjau

Comments

[no name] 6-Oct-12 14:41pm

Hey thanks!

Patrick Wanjau 6-Oct-12 14:45pm

you're welcome