getting information from drop down list

studioh3o

I was wanting to know if anybody could tell me how i would grab the value from a drop down list and use it to pull information from a MYSQL database. any help would be appreciated. thanks in advance.

Mike

scoppc

<select name="town" id="town">
<option value="Jakarta" selected="selected">Jakarta</option>
<option value="Kuala Lumpur">Kuala Lumpur</option>
</select>

in your php page:

$town=$_POST['town'];
print "You have chosen " . $town . " as your destination";

Is that what you want?

studioh3o

scoppc

well thats alittle bit of what im wanting to know, what im wanting to pull from a databse is an image /description of product/ and price. all the information will be determined by what is choosen from the drop down list. the values on the drop down list will coincide with the product_id filed of my Mysql databse.

thanks for the info that you have give.

oh also i need this to be all on one page.

Mike

scoppc

Well, the concept is simple
1. Check to see whether any product ID has been passed to this file
2. If it is not, then set a default product ID to be displayed.
If there is a product ID, then use it
3. Query mysql database based on the product ID
4. Display it

You can accomplish above tasks by using scripts that look like this:

<?php
$pid=$_GET['prodID'];
if (empty($pid)){
    //set default value for $pid
    $pid=1;
}
?>
<html>
<head>
<title>Our Product</title>
</head>
<body>
<form action="product.php" method=get>
<select name="prodID">
<option value="1" selected="selected">PDA</option>
<option value="2">Handphone</option>
</select>
</form>

<?php
//you can now display the product info
//based on $pid that you got.
//query goes here....
?>
</body>
</html>

studioh3o

ok... i have been trying to display images from a databse and everytime i do it i get an erro here is the error...

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING
what is the exact way to code to show images from a database.
all thats stored in the databse is the file name and the exttension (image1.jpg)
thanks for the great help you have given me so far, i really appreciate it..

Mike

scoppc

It is pretty straight forward.

<img src="../path/to/image/folder/<?php print $data['image']; ?>" alt="image">

studioh3o

ok. i'll try this out and let you know...thanks for the help...

Mike

studioh3o

Ok scoppc im having a problem... could you let me know what is wrong with my code.
<?php
$proid=$_get['select']
if (empty($proid)){
//set default ID
$proid=1;
}
mysql_connect ("localhost","Mike","studioh3o") or die(mysql_error() . "<B>Can't connect to the server</B>");
mysql_select_db("store") or die(mysql_error() . "<B>Specified database does NOT exist</B>");
$query = "select description, price, image, product_id from products WHERE product_id = $proid ";
$result = mysql_query($query) or die(mysql_error() . "<B>Bad Query</B>");
$num= mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) {
$img=$row["image"];
$desc=$row["description"];
$money=$row["price"];

}
?>

all the above code is before the start of my html tags

all this code is in between my html tages and this all is in an html file named m_shirt3.htm

<form action="m_shirt2.htm" method="get" name="list" id="list">
<div align="center">
<select name="select">
<option value="1" selected>Truth</option>
<option value="2">Integrity</option>
<option value="3">Freedom</option>
<option value="4">Role Model</option>
<option value="5">Grace</option>
</select>
<input type="image" name="Submit2" value="Select" src="images/select.jpg">
</div>
</form></td>
</tr>
</table>

                  </td>
                </tr>
                <tr> 
                  <td bgcolor="#99CCFF"> 
                    <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
                      <tr> 
					                            <td><?php echo"<img src=\"http://www.heismy.com/beta/test/images/$img\n">?></td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <tr> 
                  <td valign="top" bgcolor="#99CCFF" height="11"> 
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td bgcolor="#FFFFFF">back of shirt</td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <tr> 
                  <td bgcolor="#99CCFF" height="19"> 
                    <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
                      <tr> 
                        <td><?php echo '$desc'?></td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <tr> 
                  <td bgcolor="#99CCFF"> 
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td bgcolor="#FFFFFF"><?php echo'$money'?></td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <tr>
                  <td bgcolor="#99CCFF">
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td bgcolor="#FFFFFF">Add to cart/view cart</td>
                      </tr>
                    </table>
                  </td>
                </tr>
              </table>

The_Chancer

Just a small thing - you are missing a ; off your first line....

Did you cut n paste or retype ???

Oh - and use single quotes ' ' instead of double quotes " " in your array identifier...

e.g.

$this['something'];

studioh3o

ok the chancer, i did what you suggested but the script still isnt workin. all im getting is what you can see in the attched screen shot.. any help would be great..
the code is below..

<?php
$proid=$_get['select'];
if (empty($proid)){
///set default ID
$proid=1;
}
mysql_connect ("localhost","Mike","studioh3o") or die(mysql_error() . "<B>Can't connect to the server</B>");
mysql_select_db("store") or die(mysql_error() . "<B>Specified database does NOT exist</B>");
$query = "select description, price, image, product_id from products WHERE product_id = $proid ";
$result = mysql_query($query) or die(mysql_error() . "<B>Bad Query</B>");
$num= mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) {
$img=$row['image'];
$desc=$row['description'];
$money=$row['price'];
}
?>

the above is before the <html> tags

<form action="m_shirt3.htm" method="get" name="list" id="list">
<div align="center">
<select name="select">
<option value="1" selected>Truth</option>
<option value="2">Integrity</option>
<option value="3">Freedom</option>
<option value="4">Role Model</option>
<option value="5">Grace</option>
</select>
<input type="image" name="Submit2" value="Select" src="images/select.jpg">
</div>
</form></td>
</tr>
</table>

                  </td>
                </tr>
                <tr> 
                  <td bgcolor="#99CCFF"> 
                    <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
                      <tr> 
					  <!-- put php scrupt here for images -->
                        <td><?php echo'<img src=\"http://www.heismy.com/beta/test/images/$img\n">'?></td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <tr> 
                  <td valign="top" bgcolor="#99CCFF" height="11"> 
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td bgcolor="#FFFFFF">back of shirt</td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <tr> 
                  <td bgcolor="#99CCFF" height="19"> 
                    <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
                      <tr> 
                        <td><?php echo '$desc'?></td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <tr> 
                  <td bgcolor="#99CCFF"> 
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td bgcolor="#FFFFFF"><?php echo'$money'?></td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <tr>
                  <td bgcolor="#99CCFF">
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td bgcolor="#FFFFFF">Add to cart/view cart</td>
                      </tr>
                    </table>
                  </td>
                </tr>
              </table>

above is in between <html>tags..
any help would be great.. thanks in advance.

Mike

sanu

<?php 
$proid=$_get['select']; 
if (empty($proid)){ 
///set default ID 
$proid=1; 
} 
mysql_connect ("localhost","Mike","studioh3o") or die(mysql_error() . "<B>Can't connect to the server</B>"); 
mysql_select_db("store") or die(mysql_error() . "<B>Specified database does NOT exist</B>"); 
$query = "select description, price, image, product_id from products WHERE product_id = $proid "; 
$result = mysql_query($query) or die(mysql_error() . "<B>Bad Query</B>"); 
$num= mysql_num_rows($result); 
while ($row = mysql_fetch_array($result)) { 
$img=$row['image']; 
$desc=$row['description']; 
$money=$row['price']; 
} 
?>

could you tell us the line no. you are getting Error

studioh3o

im not getting an error thats the crazy part.the page is coming up and everything.... its just not showing any info...

Mike

haze

Originally posted by studioh3o
im not getting an error thats the crazy part.the page is coming up and everything.... its just not showing any info...

Mike

do you have error display turned on in the config?

studioh3o

come to find out , im a moron and have been saving it with a html extension instead of a .php extension...