Insert dropdown list selection into mysql Database

Question

can someone tell me how to insert the selected text not the value of a dropdown list (select box) into a mysql database when user hits the button enroll. The code right now inserts the id of the row i am rendering but I need to insert the value. Sorry if I am not that explanatory.. Much help is appreciated. !!!

Updated: Can Someone tell me how to redirect after succesfulling inserting to a confirmation page ?????

$db = &JFactory::getDBO();

$query = "
INSERT INTO
`jos_jquarks_persontraining`
(

course_name,

courseDate,

user_id,
employeeNumber,
department,
name,
timeStamp
)
VALUES
(

'{$courseTitle}',
'{$varcourseDate}',

'{$id}',
'{$username}',
'{$department}',
'{$name}',
'{$acknowledge}',
'{$vardate}'
)";

$db->setQuery($query);

$db->query();

if($db->getErrorNum()) { 
JError::raiseError( 500, $db->stderr()); 
} 

}

?>

 <form name="quiz_info" method="post" action="<?php echo $_SERVER['REQUEST_URI']; ?>">

<?php

echo JText::_('Please select the date:');

$database= &JFactory::getDBO();

$database->setQuery('SELECT training_id,CONCAT(trainingDate,"-",trainingHour) AS trainingDate FROM training WHERE openSeats > 0');


$result = $database->loadObjectList();



echo '<select name="dateSelectBox">';
foreach ($result as $row) {

echo '<option value="'.$row->training_id.'">'.$row->trainingDate.'</option>';
                        }
echo '</select>';

Mathieu Dumoulin · Accepted Answer · 2011-11-17 20:21:26Z

1

You have two ways to do that, the first one requires you to change the VALUE of your OPTIONs. But that is usually not the right way to go. What i'd do is simply reload the list of values that you can print, loop it until you find the right one that matches value for id. Then, take that LABEL that you want to insert and save it to database by any means possible.

In Joomla anyway, you should always load your data from the view and assign it to your template. Since the tutorials and best pratice in joomla also tells you that you should cache your retrived data from your model, you could simply use your controller to preload the data in the model, use it to find your "label" to insert into the database and then go on to your view again for result...

answered Nov 17, 2011 at 20:21

Mathieu Dumoulin

12.3k7 gold badges47 silver badges71 bronze badges

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

Comments

Erbureth · Accepted Answer · 2011-11-17 20:22:58Z

0

Just use

echo '<option value="'.$row->trainingDate.'">'.$row->trainingDate.'</option>';

on the third last line, but the whole method looks quite fishy to me.

You should really use ID's of the training dates instead of the dates themselves, it's better design
You are not reducing the number of open seats in the code. Anyway, try designing your DB to include "capacity" column, you can then check for open seats in more consistent way.

answered Nov 17, 2011 at 20:22

Erbureth

3,4231 gold badge24 silver badges42 bronze badges

3 Comments

user959443 Over a year ago

Cool stuff, yes I am trying to create a trigger to reduce the seats in the mysql table, but for this other table I am building I would like to insert both the id of the training, and the date for reporting purposes

user959443 Over a year ago

Can you please help , I need to redirect after succesfully inserting

Erbureth Over a year ago

Redirecting is described for exemple here: plus2net.com/php_tutorial/php_redirect.php

Jose Vega · Accepted Answer · 2011-11-17 20:31:24Z

0

I think your best bet is to have a table in your database that has an id to value and then when trying to figure out what the id means, do a join to that table.

When you submit a form you can do $_POST and that will show you everything that was sent from the form. If you want to go the extra step you will need to create hidden fields in the form that will hold the value, something along the lines of when the users submits you will need to match that option id to the hidden id.

edited Nov 17, 2011 at 20:31

answered Nov 17, 2011 at 20:24

Jose Vega

10.3k7 gold badges43 silver badges58 bronze badges

3 Comments

user959443 Over a year ago

yes that seems to be the best idea, but I would think there is a way to refer the value of a select box using post: echo '<option value="'.$row->training_id.'" text="'.$row->trainingDate.'">'.$row->trainingDate.'</option>';

Jose Vega Over a year ago

When you submit a form you can do $_POST and that will show you everything that was sent from the form. If you want to go the extra step you will need to create hidden fields in the form that will hold the value, something along the lines of <input type='hidden' name='id' value='whatever value you want'> when the users submits you will need to match that option id to the hidden id.

user959443 Over a year ago

See my updated question, do you know how can I redirect to an specific page once the insertion went trough?

Collectives™ on Stack Overflow

Insert dropdown list selection into mysql Database

3 Answers 3

Comments

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related