getting a value from mysql db and post it to php page

Question

i have a little problem while getting a value from database and post it to another page , heres my code . on search.php the user enter the price min and price max , then on page result.php it shows from database the name and price of the product and a link for more infos .(info.php) this 3rd page will show some additional informations based on the Id of the product shown on result.php i tried to hide the value of Id_product from result and post it to 3rd form but doesnt work.i got an error Notice: Undefined index: id in info.php line 4

//////search.php /////

<form  method="post" action="result.php" > 
<tr> <INPUT type=text size=20 name=pricemin ><BR>  </tr>  
<tr> <INPUT type=text size=20 name=pricemax ><BR>  </tr>
<tr> <input type="submit" class="Nom" id="button" value="Valider" /></tr></form>

///////result.php //////

<?php include 'includes/connection.php';
$pricemin = $_POST['pricemin'];
$pricemax = $_POST['pricemax'];
$query = "SELECT * FROM product where price between '$pricemin' and '$pricemax'";
$result = mysql_query($query);?>
<?php if(mysql_num_rows($result) > 0)
while($products = mysql_fetch_array($result)) {?>   
<?php echo $products['name_product'] ;echo $products['price_product'] ;
echo "<a href='http://localhost/mywebsite/info.php'>More infos</a>"
?>
<form method="post" action="info.php" >
<input type="hidden" name="id" value="<?php echo $products['id_product']; ?>" />
</form><?php } ?>...

///// info.php //////

<?php
include 'includes/connection.php';
$id_product = $_POST['id'];
$query = "SELECT * FROM product where id_product='$id_product'";
$result = mysql_query($query);   ?>
<html><head><title>.. </title></head><body>
<?php 
while($products = mysql_fetch_array($result)) {?>
<h1>Product ID : <?php echo  $products['id_product'] ; ?> </h1>
<h1>Product name : <?php echo  $products['name_product'] ; ?> </h1>
<h1>Product Qt : <?php echo  $products['quantity_product'] ; ?> </h1>
<h1>Product Spec : <?php echo  $products['spec_product'] ; ?> </h1>
<?php } ?></body></html>

What is your problem? Also are you aware that the name of your input boxes at search.php is different from the one you are calling at result.php — magicianiam
– magicianiam, Commented May 30, 2012 at 19:13
beside that because ive edited my code ,my problem is between result.php and info.php how can i get the id value from my database and post it to info.php . because the hidden input didnt solve my pb — Common
– Common, Commented May 30, 2012 at 19:22
im working on the answer right now. you really should clean your code here. — magicianiam
– magicianiam, Commented May 30, 2012 at 19:22
please , learn what spaghetti code is .. because that's what you writing — tereško
– tereško, Commented May 30, 2012 at 19:35
hi sir , my speciality have nothing to do with programming but i have a family to feed (some spaghetti), to keep my job i have to do this spaghetti code sir , have a nice day ! life aint easy — Common
– Common, Commented May 30, 2012 at 19:40

magicianiam · Accepted Answer · 2012-05-30 19:27:43Z

1

try this:

//////search.php /////

<form  method="post" action="result.php" > 
<tr> <INPUT type=text size=20 name=pricemin ><BR>  </tr>  
<tr> <INPUT type=text size=20 name=pricemax ><BR>  </tr>
<tr> <input type="submit" class="Nom" id="button" value="Valider" /></tr></form>

///////result.php //////

<?php include 'includes/connection.php';
$pricemin = $_POST['pricemin '];
$pricemax = $_POST['pricemax '];
$query = "SELECT * FROM product where price between '".$pricemin."' and '".$pricemax."'";
$result = mysql_query($query);

if(mysql_num_rows($result) > 0)
while($products = mysql_fetch_array($result)) {
$id = $products['id_product'];
echo $products['name_product'] ;echo $products['price_product'] ;
echo "<a href='info.php?id=";
echo $id;
echo "'>More infos</a>"
?>

<?php } ?>...

///// info.php //////

<?php
include 'includes/connection.php';
$id_product = $_GET['id'];
$query = "SELECT * FROM bien where id_product= '".$id_product."'";
$result = mysql_query($query);   ?>
<html><head><title>.. </title></head><body>
<?php 
while($products = mysql_fetch_array($result)) {?>
<h1>Product ID : <?php echo  $products['id_product'] ; ?> </h1>
<h1>Product name : <?php echo  $products['name_product'] ; ?> </h1>
<h1>Product Qt : <?php echo  $products['quantity_product'] ; ?> </h1>
<h1>Product Spec : <?php echo  $products['spec_product'] ; ?> </h1>
<?php } ?></body></html>

this should pass ID to info.php

Also Form will only work if you submit a button, so if you were to click a link, form will not submit unless you use a JS onsubmit function.

answered May 30, 2012 at 19:27

magicianiam

1,5797 gold badges33 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Common Over a year ago

Work like a magic , thats what i was looking for :) Thank you my friend very very much.

magicianiam Over a year ago

glad to help you. also learn to clean your code. btw if you want to pass data to another page use link instead of a form when you dont need the user to input any data but to just click.

Collectives™ on Stack Overflow

getting a value from mysql db and post it to php page

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related