Announcements | Last Post | |
---|---|---|
SoC Curricula | 09/30/2017 01:08PM | |
Demarcation or scoping of examinations and assessment | 02/13/2017 07:59AM | |
School of Computing Short Learning Programmes | 11/24/2014 08:37AM | |
Unisa contact information | 07/28/2011 01:28PM |
Team selection July 25, 2013 05:39PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 03, 2013 11:43PM |
Registered: 11 years ago Posts: 10 Rating: 0 |
Re: Team selection September 04, 2013 08:06AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 12, 2013 05:01PM |
Registered: 10 years ago Posts: 15 Rating: 0 |
Re: Team selection September 13, 2013 07:14AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Language: PHP$db_found = mysql_select_db($database) or die(mysql_error());
Re: Team selection September 18, 2013 01:14PM |
Registered: 10 years ago Posts: 36 Rating: 0 |
Re: Team selection September 18, 2013 02:22PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 19, 2013 10:27AM |
Registered: 10 years ago Posts: 7 Rating: 0 |
Re: Team selection September 19, 2013 10:36AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 19, 2013 12:35PM |
Registered: 10 years ago Posts: 4 Rating: 0 |
Re: Team selection September 19, 2013 12:46PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 23, 2013 12:19PM |
Registered: 11 years ago Posts: 51 Rating: 0 |
Re: Team selection September 23, 2013 12:44PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 23, 2013 08:46PM |
Registered: 10 years ago Posts: 36 Rating: 0 |
Re: Team selection September 25, 2013 08:08AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 25, 2013 01:11PM |
Registered: 10 years ago Posts: 3 Rating: 0 |
Re: Team selection September 25, 2013 03:48PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 25, 2013 03:55PM |
Registered: 10 years ago Posts: 28 Rating: 0 |
Re: Team selection September 25, 2013 04:02PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 25, 2013 07:34PM |
Registered: 10 years ago Posts: 6 Rating: 0 |
Re: Team selection September 26, 2013 07:42AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection September 28, 2013 05:00PM |
Registered: 11 years ago Posts: 51 Rating: 0 |
Any help will be much appreciatedLanguage: PHP<?php if (isset($_POST[';submit';])){ $id = $_GET[';fixture_id';]; $sql="INSERT INTO selection (fixture_id,point_guard,shooting_guard,small_forward,power_forward,center)VALUES(';$id';,';$pg';,';$sg';,';$sf';,';$pf';,';$center';)"; $qry = mysql_query($sql); if (!$qry) { die(';Error: '; . mysql_error($db_handle)); } } ?>
Re: Team selection September 28, 2013 07:04PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: Team selection September 30, 2013 10:17AM |
Registered: 10 years ago Posts: 28 Rating: 0 |
Re: Team selection September 30, 2013 01:32PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection October 01, 2013 07:35AM |
Registered: 10 years ago Posts: 11 Rating: 0 |
Language: PHPforeach ($_REQUEST[';opponents';] as $opponents){ print $opponents; echo';<br>';; }
Language: PHPif(isset($_POST["submit"])) { foreach ($_REQUEST[';opponents';] as $against){ var_dump($against); print $against; echo';<br>';; } } else { echo';<h1>Select your Team</h1>';; $x = array("THP", "HKR", "LHP", "LH", "FLH"); //players positions gets assigned to x which will be used to query the database echo ';<form name="playerselect" method="post" action="">';; //query database with different query after each loop for ($i = 0; sizeof($x) > $i; $i++) { //query where position field equeals variable x $result = mysql_query("SELECT `name`, `position` FROM `player_info` WHERE `position` = ';$x[$i]';") or die(mysql_error()) ; //Gets data from DB and assigns values to arrays below while($row = mysql_fetch_array($result)) { $playername[] = $row[';name';]; $position[] = $row[';position';]; } //print player position print $position[0]; echo';<br>';; //unset the array so that it is empty for the next query in the new loop unset($position); echo ';<select name="players[]" >'; ; foreach ($playername as $name ) { //Put playernames relevant to the position in the option element echo';<option value="$name" selected="selected">';.$name;';</option>';; echo';<br>';; } echo';</select>';; //unset array so that its contents is empty for the next query in the new loop unset($playername); echo';<br>';; }
Re: Team selection October 01, 2013 08:33AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection October 01, 2013 09:24AM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: Team selection October 01, 2013 09:40AM |
Registered: 10 years ago Posts: 11 Rating: 0 |
Language: PHPecho ';<select name="players[]" >'; ; foreach ($playername as $name ) { //Put playernames relevant to the position in the option element echo';<option value="$name" selected="selected">';.$name;';</option>';; echo';<br>';; }
Now the code above should print all the selected players from the previous page but strangely it only prints the arrays actual name, which is $name...?Language: PHPforeach ($_REQUEST[';players';] as $selected_player) { print $selected_player echo';<br>';; }
Language: PHP$x = array("THP", "HKR", "LHP", "LH", "FLH"); //players positions gets assigned to x which will be used to query the database
Language: PHPfor ($i = 0; sizeof($x) > $i; $i++)
Language: PHP//query where position field equeals variable x $result = mysql_query("SELECT `name`, `position` FROM `player_info` WHERE `position` = ';$x[$i]';") or die(mysql_error()) ;
Language: PHPwhile($row = mysql_fetch_array($result)) { $playername[] = $row[';name';]; $position[] = $row[';position';]; }
Language: PHPecho ';<select name="players[]" >'; ; foreach ($playername as $name ) { //Put playernames relevant to the position in the option element echo';<option value="$name" selected="selected">';.$name;';</option>';; echo';<br>';; } echo';</select>';;
Language: PHPunset($playername);
Re: Team selection October 01, 2013 11:41AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Language: PHPecho "<option value=\"$name\" selected=\"selected\">".$name;"</option>"; // in the page source then Oliver is the value <select name="players[]" ><option value="Oliver" selected="selected">Oliver
Re: Team selection October 01, 2013 11:53AM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: Team selection October 03, 2013 07:39AM |
Registered: 10 years ago Posts: 28 Rating: 0 |
Re: Team selection October 03, 2013 09:44AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection October 11, 2013 12:54PM |
Registered: 10 years ago Posts: 3 Rating: 0 |
Re: Team selection October 13, 2013 07:05PM |
Registered: 10 years ago Posts: 16 Rating: 0 |
Re: Team selection October 21, 2013 06:43AM |
Registered: 10 years ago Posts: 7 Rating: 0 |
Re: Team selection October 21, 2013 09:56AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection October 21, 2013 10:02AM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: Team selection October 21, 2013 11:55AM |
Registered: 10 years ago Posts: 7 Rating: 0 |
Re: Team selection October 21, 2013 12:10PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: Team selection October 21, 2013 12:16PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Team selection October 22, 2013 05:00AM |
Registered: 10 years ago Posts: 7 Rating: 0 |