[Resolved] Select box values help

n00854180t

I have a script which enters user information into a database. I want the user to be able to select 1 of 3 things from a select box and have a different image displayed depending on which they selected.

I am running into problems when I try to do this by puting a tag in the <option value=""> tag.

I tried doing it like this, but it just gives me a blank value instead of the variable...
This is just the relavent part of the script. I tried putting semi colons after the variables, but it didn't do anything. I am not getting errors, the value just doesn't show up in the database. I also tried it like this: <option value="<?php $thing1image='<img src="img.gif">'; $thing1image; ?>">thing1</option> and it gives me a blank value.

<?php


// stuff

$thing1image='<img src="img.gif">';
?>

<form method="post" action="<?php $PHP_SELF?>">
<font face="verdana" size="1">
Character Name: <br>
<input type="text" name="txtUser"><br>
Password: <br><input type="password" name="txtPass"><br>
Empire: <br><select name="txtEmpire">
<option value="<?php $thing1image ?>">thing1</option>
<option value="<?php $thing2image ?>">thing2</option>
<option value="<?php $thing3image ?>">thing3</option>
<input type="submit" name="submit" value="Register">
</form><a href="login.php">Login</a> <a href="admin.php">Admin</a>
</font>

br__ken

try this, or do it your own way.. don't use the html tag as the option value , i think thats what made it turn blank..

you can always format it later when you know the image name..

<?
if($_POST):
	print_r($_POST);
	echo "<br>Their Image = &lt;img src=\"" . $_POST['txtEmpire'] . "\">";
else:
	$images=array("img1.jpg", "img2.jpg", "img3.jpg");
	?>
	<form method="post" action="<?=$GLOBALS['PHP_SELF']?>"> 
	<font face="verdana" size="1"> 
	Character Name: <br> 
	<input type="text" name="txtUser"><br> 
	Password: <br><input type="password" name="txtPass"><br> 
	Empire: <br><select name="txtEmpire"> 
	<?
	// build options box
	foreach ($images as $k=>$v){
		?><option value="<?=$v?>">Image <?=++$k?></option>
	<?}?>
	<input type="submit" name="submit" value="Register"> 
	</form><a href="login.php">Login</a> <a href="admin.php">Admin</a> 
	</font> 
<?
endif;
?>

n00854180t

I tried that out and it doesn't work, just echoes the name of the image. Also I need the select box to display three separate values, rather than just "Image 1, 2, 3". Thanks for the help though.

bad76

Hi,
for me this work fine.

First you have to put an echo on <?php $thing1image?> else nothing is writed in tag.
Second you have to encode/decode the string.

<?php
$thing1image='<img src="img1.gif">';
$thing2image='<img src="img2.gif">';
$thing3image='<img src="img3.gif">';
echo urldecode($txtEmpire);
?>

<form method="get" action="<?php $PHP_SELF?>">
<font face="verdana" size="1">
Character Name: <br>
<input type="text" name="txtUser"><br>
Password: <br><input type="password" name="txtPass"><br>
Empire: <br><select name="txtEmpire">
<option value="<?=urlencode($thing1image)?>" SELECTED>thing1</option>
<option value="<?=urlencode($thing2image) ?>">thing2</option>
<option value="<?=urlencode($thing3image) ?>">thing3</option>
<input type="submit" name="submit" value="Register">
</form><a href="login.php">Login</a> <a href="admin.php">Admin</a>
</font>

see you

n00854180t

That doesn't work either I am afraid. All of the code that displays the values is in another file so I have that covered...

If I use that code it just outputs this:

%3Cimg+src%3D%thing1image.gif%22%3E

kevinsequeira

can u post the latest edited code .

reg
kevin

n00854180t

I reverted it to the old code (no pictures). I just want the picture to display after the person registers. I want them to see the empire name, not the image name heh...

<link href="bord.css" rel="stylesheet" type="text/css">

<?php

$loginURL = '<a href="loginscript.php">login</a>';
include("dbconn.php");

if ($submit) {

$sql = "INSERT INTO characters (cName,cPass,cEmpire,cRank,cCrank,cOutfit) VALUES ('$txtUser','$txtPass','$txtEmpire','$txtRank','$txtCRank','$txtOutfit')";

$result = mysql_query($sql,$db);

echo "You are registered, " . $txtUser .".  You may now " . $loginURL . ".";
} else {


?>


<form method="post" action="<?php $PHP_SELF?>">
<font face="verdana" size="1">
Character Name: <br>
<input class="text" type="text" name="txtUser"><br>
Password: <br><input class="text" type="password" name="txtPass"><br>
Empire: <br><select  class="text" name="txtEmpire">
<option value="Vanu Sovereignty">Vanu Sovereignty</option>
<option value="Terran Republic">Terran Republic</option>
<option value="New Conglomerate">New Conglomerate</option>
</select><br>
Rank: <br><select class="text" name="txtRank">
<option value="Battle Rank 1">Battle Rank 1</option>
<option value="Battle Rank 2">Battle Rank 2</option>
<option value="Battle Rank 3">Battle Rank 3</option>
<option value="Battle Rank 4">Battle Rank 4</option>
<option value="Battle Rank 5">Battle Rank 5</option>
<option value="Battle Rank 6">Battle Rank 6</option>
<option value="Battle Rank 7">Battle Rank 7</option>
<option value="Battle Rank 8">Battle Rank 8</option>
<option value="Battle Rank 9">Battle Rank 9</option>
<option value="Battle Rank 10">Battle Rank 10</option>
<option value="Battle Rank 11">Battle Rank 11</option>
<option value="Battle Rank 12">Battle Rank 12</option>
<option value="Battle Rank 13">Battle Rank 13</option>
<option value="Battle Rank 14">Battle Rank 14</option>
<option value="Battle Rank 15">Battle Rank 15</option>
<option value="Battle Rank 16">Battle Rank 16</option>
<option value="Battle Rank 17">Battle Rank 17</option>
<option value="Battle Rank 18">Battle Rank 18</option>
<option value="Battle Rank 19">Battle Rank 19</option>
<option value="Battle Rank 20">Battle Rank 20</option>
</select><br>
Command Rank: <br><select class="text" name="txtCRank">
<option value="No Command Rank">No Command Rank</option>
<option value="Command Rank 1">Command Rank 1</option>
<option value="Command Rank 2">Command Rank 2</option>
<option value="Command Rank 3">Command Rank 3</option>
<option value="Command Rank 4">Command Rank 4</option>
<option value="Command Rank 5">Command Rank 5</option>
<option value="Command Rank 6">Command Rank 6</option>
<option value="Command Rank 7">Command Rank 7</option>
<option value="Command Rank 8">Command Rank 8</option>
<option value="Command Rank 9">Command Rank 9</option>
<option value="Command Rank 10">Command Rank 10</option>
</select><br>
Outfit: <br><input class="text" type="text" name="txtOutfit"><br>
<input class="submit" name="submit" type="submit" value="Register">
</form><a href="login.php">Login</a> <a href="admin.php">Admin</a>
</font>

</body>

<?php

}

?>

kevinsequeira

have this after u insert into db

.
.

$pictures = array(
"Vanu Sovereignty"=>"image1.gif",
"Terran Republic"=>"picture2.gif",
"New Conglomerate"=>"picture3.gif"
);
foreach($pictures as $key=>$value){
	if($key == $txtEmpire){
		echo "<img src=www.servername/path_to_image/".$value.">";
	}
}
.
.

reg
kevin

n00854180t

Originally posted by kevinsequeira
NM, just read what u posted ....

reg
kevin

kevinsequeira

take a look at what i edited my earlier post to.

reg
kevin

n00854180t

Not quite sure exactly how to use that code. Thanks.

kevinsequeira

.
.
.
.
if ($submit) {

  $sql = "INSERT INTO characters (cName,cPass,cEmpire,cRank,cCrank,cOutfit) VALUES  ('$txtUser','$txtPass','$txtEmpire','$txtRank','$t
  xtCRank','$txtOutfit')";

  $result = mysql_query($sql,$db);

  echo "You are registered, " . $txtUser .".  You may now " . $loginURL . "."; 
  $pictures = array(
  "Vanu Sovereignty"=>"picture.gif",
  "Terran Republic"=>"picture2.gif",
  "New Conglomerate"=>"picture3.gif"
  );
  foreach($pictures as $key=>$value){
  	if($key == $txtEmpire){
  		echo "<img src=".$value.">";
  	}
  }
		//depending on what the value of $txtEmpire is it will display corresponding picture		
} else {
.
.
.
.

reg
kevin

n00854180t

Hehe I thought I was just misunderstanding the code but I had actually put it under the } else { LOL!

Thanks a lot!

n00854180t

Hmm...That actually doesn't do what I intended. That code just echoes the picture whereever it is. I need it to make the sql query input the html for the image.

kevinsequeira

I need it to make the sql query input the html for the image.

could u explain that ???

reg
kevin

n00854180t

Sorry what I mean is I need the code to put the html tags for the image into the database based on which option they select.

n00854180t

Can anyone help?

bad76

Hi,
i'm not online, so i can't reply before...

If I use that code it just outputs this:

%3Cimg+src%3D%thing1image.gif%22%3E

If you look at my code, you can see the

echo urldecode($txtEmpire);

line. Even you get %3C and other char this reconvert in html tag.
You can apply this function just before INSERT or when output it.
I think you can also use unescape() javascript function on client-side...

i hope this help you...

n00854180t

It just echoes a blank value in my table, like it did when I tried to just use a variable as the value of the select option.

bad76

Can i look your insert/update query?