Ryflex Posted December 17, 2010 Share Posted December 17, 2010 Hi all, I have a page with 4 textboxes which can be filled out. The thing is I want people to be able to only train 1 type at a time. Underneath I posted the Form page and the exec page does anyone have and idea?? Thnx Ryflex FORM: <?php //authentication & database configuration require_once('auth.php'); require_once('config.php'); //member_ID and city_ID and greyed out empty declaration $member_ID = $_SESSION['SESS_MEMBER_ID']; $city_ID = $_SESSION['SESS_CITY_ID']; $ro = ""; //Database connection $global_dbh = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die("Could not connect to database"); mysql_select_db(DB_DATABASE, $global_dbh) or die("Could not select database"); //get infantry units type = 1 $sql = "SELECT name, resource_1, resource_2, resource_3, timestamp FROM unittype WHERE type = 1"; $result = mysql_query($sql) or die("Could not find units"); //get the 4 unit types in the $n[] array while($data = mysql_fetch_assoc($result)) { $one[] = $data[resource_1]; $two[] = $data[resource_2]; $three[] = $data[resource_3]; $time[] = $data[timestamp]; } //query amount of infantry troops $sql = "SELECT * FROM infantry WHERE member_id = '$member_ID'"; $result = mysql_query($sql) or die("Could not find amount of troops"); //get amount of infantry troops while($data = mysql_fetch_assoc($result)) { $n[] = $data[name]; $training[] = $data[training]; $timestamp[] = $data[timestamp]; $amount[] = $data[amount]; } //check if a training is underway $sql = "SELECT * FROM infantry WHERE member_id = '$member_ID' AND training = 1"; $trcurr = mysql_fetch_array( mysql_query($sql)); if($trcurr['training'] == 1) { $ro = "READONLY STYLE='color:#999999;background:#DEDEDE'"; } ?> <html> <head> <title>Infantry Training</title> <link href="loginmodule.css" rel="stylesheet" type="text/css" /> </head> <body> <p>You can only train 1 type of infantry at a time.</p> <form id="create" name="create" method="POST" action="infantry_exec.php"> <table> <tr> <td><b><?php echo $n[0]; ?></b></td> <td><b><input name="<?php echo $n[0]; ?>" type="text" <?php echo $ro; ?> maxlength="10" id="<?php echo $n[0]; ?>" /></b></td> </tr> <tr> <td><b><?php echo $n[1]; ?></b></td> <td><b><input name="<?php echo $n[1]; ?>" type="text" <?php echo $ro; ?> maxlength="10" id="<?php echo $n[1]; ?>" /></b></td> </tr> <tr> <td><b><?php echo $n[2]; ?></b></td> <td><b><input name="<?php echo $n[2]; ?>" type="text" <?php echo $ro; ?> maxlength="10" id="<?php echo $n[2]; ?>" /></b></td> </tr> <tr> <td><b><?php echo $n[3]; ?></b></td> <td><b><input name="<?php echo $n[3]; ?>" type="text" <?php echo $ro; ?> maxlength="10" id="<?php echo $n[3]; ?>" /></b></td> </tr> <tr> <td colspan="2"><center><input type="submit" name="Submit" value="Train!!!" /></center></td> </tr> </table> </form> </body> </html> EXEC: <?php //authentication & database configuration require_once('auth.php'); require_once('config.php'); //member_ID and city_ID $member_ID = $_SESSION['SESS_MEMBER_ID']; $city_ID = $_SESSION['SESS_CITY_ID']; //Database connection $global_dbh = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die("Could not connect to database"); mysql_select_db(DB_DATABASE, $global_dbh) or die("Could not select database"); //query names of infantry troops $sql = "SELECT * FROM infantry WHERE member_id = '$member_ID'"; $result = mysql_query($sql) or die("Could not find amount of troops"); //get names of infantry troops while($data = mysql_fetch_assoc($result)) { $n[] = $data[name]; } //convert POST to normal variable $amount = array(0 => $_POST[$n[0]], 1 => $_POST[$n[1]], 2 => $_POST[$n[2]], 3 => $_POST[$n[3]]); ?> Quote Link to comment https://forums.phpfreaks.com/topic/222001-form-with-radio-and-post/ Share on other sites More sharing options...
sloth456 Posted December 17, 2010 Share Posted December 17, 2010 Kind of difficult to visualize the output and get an idea of what you're trying to achieve, can you post a URL to the form and rephrase your question. Quote Link to comment https://forums.phpfreaks.com/topic/222001-form-with-radio-and-post/#findComment-1148754 Share on other sites More sharing options...
Ryflex Posted December 17, 2010 Author Share Posted December 17, 2010 Hi sloth456, This is what the Form page shows You can only train 1 type of infantry at a time. gunner [textbox] marine [textbox] sniper [textbox] special ops [textbox] Train!!! The EXEC page only puts the amounts out of the textbox into the database. In the FORM page I need something that functions like a radio button idea so only one thing can be "trained" at a time. Thnx Ryflex Quote Link to comment https://forums.phpfreaks.com/topic/222001-form-with-radio-and-post/#findComment-1148769 Share on other sites More sharing options...
Rifts Posted December 17, 2010 Share Posted December 17, 2010 just have a different submit button of each? Quote Link to comment https://forums.phpfreaks.com/topic/222001-form-with-radio-and-post/#findComment-1148779 Share on other sites More sharing options...
Pikachu2000 Posted December 17, 2010 Share Posted December 17, 2010 You could use a radio button group to indicate which type of unit is to be trained, and have only one text field, or keep the 4 text fields and while you validate the form, check that only one of them has a value. Quote Link to comment https://forums.phpfreaks.com/topic/222001-form-with-radio-and-post/#findComment-1148806 Share on other sites More sharing options...
Ryflex Posted December 18, 2010 Author Share Posted December 18, 2010 Hi all, I changed the form with radio buttons but when I get the $_POST[train] it only says: on. <form id="create" name="create" method="POST" action="infantry_exec.php"> <table> <tr> <td><b><?php echo $n[0]; ?></b></td> <td><b><input name="train" type="radio" value-"<?php echo $n[0]; ?>" /></b></td> <td rowspan="4"> How many troops do you want to train?<BR><input name="amount" maxlength="10" <?php echo $ro; ?> id="amount"></td> </tr> <tr> <td><b><?php echo $n[1]; ?></b></td> <td><b><input name="train" type="radio" value="<?php echo $n[1]; ?>" /></b></td> </tr> <tr> <td><b><?php echo $n[2]; ?></b></td> <td><b><input name="train" type="radio" value="<?php echo $n[2]; ?>" /></b></td> </tr> <tr> <td><b><?php echo $n[3]; ?></b></td> <td><b><input name="train" type="radio" value="<?php echo $n[3]; ?>" /></b></td> </tr> <tr> <td colspan="2"><center><input type="submit" name="Submit" value="Train!!!" /></center></td> </tr> </table> </form> //convert POST to normal variable $amount = $_POST[amount]; $type = $_POST[train]; echo "$amount <BR> $type"; Thnx Ryflex Quote Link to comment https://forums.phpfreaks.com/topic/222001-form-with-radio-and-post/#findComment-1148975 Share on other sites More sharing options...
Ryflex Posted December 18, 2010 Author Share Posted December 18, 2010 Hi all, Already found the problem, the value statement of the first line was value- instead of value= Thnx Ryflex Quote Link to comment https://forums.phpfreaks.com/topic/222001-form-with-radio-and-post/#findComment-1148977 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.