Help with a Dynamic form passing DB information

psytae

I am trying to build a dynamic form for someone to choose one of the objects that results from the sql query and pass on the ItemID from the database to the next reults.php

Not sure how to pass the DB entry to result.php. I am not getting any errors with the script below but I can't seem to get the script right on the result.php to recieve the information passed to it, if it is even passing it correctly in the first place. Any help would be appreciated.

<?php
require_once("dbconn.php");
$IR = (isset($_POST["ItemRequested"])) ? mysql_real_escape_string($_POST["ItemRequested"]) : '';

?>
<html>
	<head><title>Title here</title></head>
	<body>
		<form METHOD="post" ACTION="result.php">
<?$sql = "SELECT itemID, typeID, typeName
	FROM `Item`
	WHERE `typeName` LIKE '%".$IR."%'";
$runItem = mysql_query($sql) or die ("Query not valid!".mysql_error());

while($item = mysql_fetch_array( $runItem ))
{
	?><img src="typeicon:<?echo $item['typeID']?>" width="64"><A HREF="showinfo:<?echo $item['typeID'];?>"><?echo $item['typeName']?></A>: <input type="radio" align="absmiddle" name="Selection"[COLOR="Red"] value="<?echo $item['itemID'][/COLOR]?>"><br>

<?
}
?>
		<input type="submit" />
	</body>
</html>

Krik

This line make no sense at all

<img src="typeicon:<?echo $item['typeID']?>" width="64"><A HREF="showinfo:<?echo $item['typeID'];?>"><?echo $item['typeName']?></A>: <input type="radio" align="absmiddle" name="Selection" value="<?echo $item['itemID']?>"><br>

The image src is "typeicon:<?echo $item['typeID']?>"

The href is "showinfo:<?echo $item['typeID'];?>"

And then you have no closing </form> tag.

So first the "typeicon:" and the "showinfo:". Those just can not be part of any valid file name. If you wish to pass a value via GET (in a url) you would do it like myfile.php?itemid=<?echo $item['typeID'];?>.

If you wish to pass the data via the form make the submit button the item that is clicked not the <a href="">. Or use javascript to submit the form when the <a href=""> is clicked.

psytae

So are you saying it can't be done via post? I would rather not pass anything via url.

Secondly typeicon, and showinfo are special commands inside the in game browser this will be made specifically for to give more information on the item by popping up another window, when clicked not to submit the form. The submit button should be doing that instead. But for the moment lets forget them. would the following work then? I didn't think you could declare a value without doing the $ like $itemID= .

<?php
require_once("dbconn.php");
$IR = (isset($_POST["ItemRequested"])) ? mysql_real_escape_string($_POST["ItemRequested"]) : '';

?>
<html>
	<head><title>Title here</title></head>
	<body>
		<form METHOD="post" ACTION="result.php">
<?$sql = "SELECT itemID, typeID, typeName
	FROM `Item`
	WHERE `typeName` LIKE '%".$IR."%'";
$runItem = mysql_query($sql) or die ("Query not valid!".mysql_error());

while($item = mysql_fetch_array( $runItem ))
{
itemID=<?echo $item['typeID'];?>
	<?echo $item['typeName']?>: <input type="radio" align="absmiddle" name="Selection" value="itemID"><br>

<?
}
?>
		<input type="submit" />
</form>
	</body>
</html>

psytae

I guess where I am most confused here is passing a PHP variable as an html variable using post, since on the receiving side I would have to declare the variable again from the $_POST and this is kind of where I am getting lost because I can't seem to get the information to show up in my debugging code.

here are both sides that I have so far.

requested.php

<?php
require_once("dbconn.php");
$IR = (isset($_POST["ItemRequested"])) ? mysql_real_escape_string($_POST["ItemRequested"]) : '';

?>
<html>
	<head><title>Title Here</title></head>
	<body>
		<HR>
		<P>
		<form METHOD="post" ACTION="result.php">
<?$sql = "SELECT itemID, typeID, typeName
	FROM `Item`
	WHERE `typeName` LIKE '%".$IR."%'";
$runItem = mysql_query($sql) or die ("Query not valid!".mysql_error());

while($item = mysql_fetch_array( $runItem ))
{
	$Item_ID = $item['itemID']?>
	<?echo $item['typeName']?>: <input type="radio" align="absmiddle" name="Selection" value="<?$Item_ID?>"><br>

<?
}
?>
		<input type="submit" />
		</form>
<HR>
	</body>
</html>

result.php

<?php
$Item?> = $_POST["<?$Item_ID?>"]
<html>
	<head><title>Title Here</title></head>
	<body>
		<HR>
		<?echo $Item?>
		<P>
		<HR>
	</body>
</html>

Dj-Dark-1

Try this, this is me slightly fixing your code:

<?
require_once("dbconn.php");

$IR = (isset($_POST["ItemRequested"])) ? mysql_real_escape_string($_POST["ItemRequested"]) : '';

?>

<html>
    <head><title>Title Here</title></head>
    <body>
        <hr>
        <p>
        <form METHOD="post" ACTION="result.php">
<?$sql = "SELECT itemID, typeID, typeName
    FROM `Item`
    WHERE `typeName` LIKE '%$IR%'";
$runItem = mysql_query($sql) or die ("Query not valid!".mysql_error());

while($item = mysql_fetch_array( $runItem ))
{
    $Item_ID = $item['itemID']?>
    <?echo $item['typeName']?>: <input type="radio" align="absmiddle" name="Selection" value="<? echo "$Item_ID"; ?>"><br> //Take note on this

<?
}
?>
        <input type="submit" />
        </form>
<hr>
    </body>
</html>

Why have you done this:

<?php
$Item?> = $_POST["<?$Item_ID?>"]

Try this:

<?
$Item = $_POST['Selection']; ?> //Notice how this has changed
<html>
    <head><title>Title Here</title></head>
    <body>
        <HR>
        <? echo "$Item"; ?>
        <P>
        <HR>
    </body>
</html>

Done this quite fast, might not be right though but give it a shot.

psytae

ok I think I get it now. It is not value= that is passed to the next page it is the name= field that is passed the value and that gets passed to the next page.

Dj-Dark-1

Yes, try that and see if it works.

psytae

yea that works for my debug code at least. thanks for your help.