Passing values from generated select box input fields - This is driving me nuts!

Dev Articles Community Forums Sponsor:

October 1st, 2004, 08:37 AM

Johana Solendha

Registered User

Join Date: Oct 2004

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

Passing values from generated select box input fields - This is driving me nuts!

Hello everyone! URL

I really need some help dears.. URL

Here's what I desperatly need to acomplish: when the user selects an option in the select box, the ID of a particular row is called and allows the input fields to echo the correspondent column values.

From what gather, I can do this via javascript.

Is there any other way?

And how can I achieve this?

Thank for all the help! URL

PHP Code:


		
			
<?php 
mysql_connect($config['sql_host'], $config['sql_username'], $config['sql_password']); 
    mysql_select_db($config['sql_database']); 
        $sql = mysql_query("SELECT packname,packvalue,packdescription FROM packs "); 
echo "<table>"; 
echo "<tr><td>Please choose: "; 
echo "<select name='packselected' size='1'>"; 
while ($r = mysql_fetch_array($sql)) 
{ 
    echo "<option value='". $r['packvalue'] ."'>". $r['packname'] ."</option>"; 
} 
echo "</select></td></tr>"; 
echo "</table>"; 
?> 
      <p>Edit Point Packs value:<br> 
        <input name="packvalue" type="text" size="10" value="<?php $query = mysql_query("SELECT packvalue FROM packs"); $row = mysql_fetch_array($query); echo "$row[packvalue]"; ?>"> 
      </p> 
        <p>Pack Name:<br> 
          <input name="packname" type="text" size="20" value="<?php $query = mysql_query("SELECT packname FROM packs"); $row = mysql_fetch_array($query); echo "$row[packname]"; ?>"> 
        </p> 
      <p>Pack description:<br> 
        <textarea name="packdescription" value="<?php $query = mysql_query("SELECT packdescription FROM packs"); $row = mysql_fetch_array($query); echo "$row[packdescription]"; ?>"><?php $query = mysql_query("SELECT packdescription FROM packs"); $row = mysql_fetch_array($query); echo "$row[packdescription]"; ?></textarea> 
      </p> 
      <p> 
        <input type="submit" name="Submit" value="Update Settings"> 
      </p></td> 
  </tr> 
</table> 
</form>

October 1st, 2004, 02:32 PM

xlordt

Registered User

Join Date: Sep 2004

Location: 127.0.0.1

Posts: 20

Time spent in forums: 30 m 39 sec
Reputation Power: 0

do you want that on focus or are you adding a submit button for this? also.. no offence but your code is messy kinda makes it hard to read

so i really cant understand it. Why not use Javascript?

October 1st, 2004, 02:35 PM

Johana Solendha

Registered User

Join Date: Oct 2004

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

Quote:

Originally Posted by xlordt

do you want that on focus or are you adding a submit button for this? also.. no offence but your code is messy kinda makes it hard to read

so i really cant understand it. Why not use Javascript?

Sorry about the code!

The submit button will update data in my table. I know I can use javascript, the problem is how.

October 1st, 2004, 02:56 PM

xlordt

Registered User

Join Date: Sep 2004

Location: 127.0.0.1

Posts: 20

Time spent in forums: 30 m 39 sec
Reputation Power: 0

Quote:

Originally Posted by Johana Solendha

Sorry about the code!

The submit button will update data in my table. I know I can use javascript, the problem is how.

Ok, currently i dont have db connection because im upgrading my other system.. but i will post something that you can work with that will surely help you alot

*Edited*

PHP Code:


		
			
<?php



 $texts  = array( 1 => "This is text field",

                  2 => "This is a Text field 2" );

?>



<script>

  function Populateit( )

  {

     var vals = "<?php echo $_POST['optionsz']; ?>";

     

     document.getElementById( "forms" ).elements[vals].value = "<?php echo $texts[$_POST['optionsz']]; ?>";

  }

</script>



<form method="post" action="hello.php" name="form" id="forms" onSubmit="Populateit( );">

 <select name="optionsz">

  <option value=1>Text Field</option>

  <option value=2>Text Area</option>

 </select>

<input type="text" name="tests"><br />

<input type="text" name="tests2"><br />

<input type="submit" name="submit" value="Submit">

<br />

</form>

havent tested it.. so i dont know if it will fully work.. but looks like it does.. anyways.. if not i will hit you up laters

October 1st, 2004, 04:09 PM

Johana Solendha

Registered User

Join Date: Oct 2004

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

Quote:

Originally Posted by xlordt

Ok, currently i dont have db connection because im upgrading my other system.. but i will post something that you can work with that will surely help you alot

*Edited*
hehe hold forgot you wanted it from the option box

Thank you so much for the assistance!

October 1st, 2004, 07:31 PM

Johana Solendha

Registered User

Join Date: Oct 2004

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

Thank you so much, but I don't think I explianed myself well.

I need the combo box to changer the values of the input fields. The values are fetched from the database.

October 2nd, 2004, 01:29 AM

digitallysmooth

you know how we do

Join Date: Jun 2002

Posts: 788

Time spent in forums: 2 h 34 m 21 sec
Reputation Power: 7

Essentially you are looking to do the following:

a. Query the database and return a specific amount or records
b. Place all records into Javascript variables in the page
c. Once a select box is changed, the value triggers the appropriate javascript variable and the values are pulled up into the input box fields.

Does this get it? I hope this helps. From here you should be able to write all the code yourself.

__________________
__________________________________________________ _
Wil Moore III, MCP | Integrations Specialist | Senior Consultant
Are You Listed...? | DigitallySmooth Inc.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: