Opstelling PHP - Forum

Yearupie Achternaamloos

18-01-2010 19:06

<?php
foreach ($_POST[''.$positie.''] as $speler_id => $val) { }
?>
Je sluit al meteen weer je foreach?

<?php
$_POST[''.$positie.'']
?>

Waarom al die haakjes? Haal ze gewoon weg!
<?php
$_POST[$positie]
?>

PHP Scripter

18-01-2010 19:14

Heb het nu zo:


<?php
if (($_GET['post']) == 'submit') {
	
        $posities = array('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');

        foreach($posities as $positie) {
		
		foreach ($_POST[$positie] as $speler_id => $val) {

		mysql_query ( 
				 "
				 INSERT INTO
				 opstelling
				 (wedstrijd_id,speler_id,speler_positie)
				 VALUES
				 ('".$wedstrijd_id."','".$speler_id."','".$speler_positie."')
				 " 
				 )
		}
			}
				}
?>

Maar er zit nog niet veel beweging in, volgens mij klopt de logica niet?

Yearupie Achternaamloos

18-01-2010 19:18

Maak een juiste foutafhandeling, en bekijk eens zelf waar je de variabelen vandaan haalt. ($wedstrijd_id en $speler_positie)

PHP Scripter

18-01-2010 19:22

$wedstrijd_id komt van een variable get, en $speler_positie is dus het probleem, waar haal ik die vandaan?

Daarbij krijg ik deze melding:
Parse error: syntax error, unexpected '}' in --- on line 44


<?php
if (($_GET['post']) == 'submit') {
	
		$speler_positie = echo $_POST[spellers];
	
        $posities = array('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');

        foreach($posities as $positie) {
		
		foreach ($_POST[$positie] as $speler_id => $val) {

		mysql_query ( 
				 "
				 INSERT INTO
				 opstelling
				 (wedstrijd_id,speler_id,speler_positie)
				 VALUES
				 ('".$wedstrijd_id."','".$speler_id."','".$speler_positie."')
				 " 
				 )
		}
			}
				}
?>

Yearupie Achternaamloos

18-01-2010 19:24

Een ; op regel 19 van je script vergeten

PHP Scripter

18-01-2010 19:28

Parse error: syntax error, unexpected ';' in /home/sis0088

Yearupie Achternaamloos

18-01-2010 19:30

Sorry mijn fout, regel 20.

PHP Scripter

21-01-2010 13:32

Ik heb het nu zo:


<?php
if ($_POST['submit']) {
	
		$speler_id = $_POST[spelersid];
		$speler_pos = $_POST[spelerspos];		
	
        /* $posities = array('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');

        foreach($posities as $positie) {
		
		foreach ($_POST[$positie] as $speler_id => $val) {
			
		*/			

		mysql_query ( 
				 "
				 INSERT INTO
				 opstelling
				 (wedstrijd_id,speler_id,speler_positie)
				 VALUES
				 ('".$wedstrijd_id."','".$speler_id."','".$spelerpos."')
				 "
				 );
		}
?>

<form name="opstelling" method="post" action="<?PHP $_SERVER['PHP_SELF']; ?>">

<div class="voetbalveld" align="center" valign="top">
<table class="voetbalveld" width="902" border="0">
  <tr>
    <td width="125" align="center" valign="top"><img src="../../images/shirts/11.png" /></td>
    <td width="125" align="center" valign="top">&nbsp;</td>
    <td width="125" align="center" valign="top">&nbsp;</td>
    <td width="125" align="center" valign="top"><img src="../../images/shirts/9.png" /></td>
    <td width="125" align="center" valign="top">&nbsp;</td>
    <td width="125" align="center" valign="top">&nbsp;</td>
    <td width="122" align="center" valign="bottom"><img src="../../images/shirts/7.png" /></td>
  </tr>
  <tr>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
  </tr>
  
  <tr>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top"><img src="../../images/shirts/8.png" /></td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top"><img src="../../images/shirts/10.png" /></td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top"><img src="../../images/shirts/6.png" /></td>
    <td align="center" valign="top">&nbsp;</td>
  </tr>
  <tr>
    <td align="center" valign="top">&nbsp;</td>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
    <td align="center" valign="top">&nbsp;</td>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
    <td align="center" valign="top">&nbsp;</td>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
    <td align="center" valign="top">&nbsp;</td>
  </tr>
  <tr>
    <td align="center" valign="top"><img src="../../images/shirts/5.png" /></td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top"><img src="../../images/shirts/3.png" /></td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top"><img src="../../images/shirts/4.png" /></td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top"><img src="../../images/shirts/2.png" /></td>
  </tr>   
  <tr>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
    <td align="center" valign="top">&nbsp;</td>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
    <td align="center" valign="top">&nbsp;</td>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
    <td align="center" valign="top">&nbsp;</td>
    <td style="color:#111111" align="center" valign="top"><select name="spelerpos" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    </td>
  </tr>
  <tr>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top"><img src="../../images/shirts/1.png" /></td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
  </tr>   
  <tr>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td style="color:#111111" align="center" valign="top">
<select name="1" style="width: 125px">
<?php
    $query_2 = "SELECT * FROM `tplss_players`";	
	$sql_2 = mysql_query($query_2) or die ( mysql_error( ) );
		while($rij_2 = mysql_fetch_object($sql_2)){
	$speler_v = $rij_2->PlayerFirstName;
	$speler_a = $rij_2->PlayerLastName;
	$spelerid = $rij_2->PlayerID;

	echo $speler_v;
	echo "&nbsp;";
	echo $speler_a;

	echo '
  <option name="spelerid" value="'.$spelerid.'">'.$speler_v.'&nbsp;'.$speler_a.'</option>
	';
	
	}	
?>
</select>    
    </td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
  </tr>
  <tr>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
  </tr>  
  <tr>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
    <td align="center" valign="top">&nbsp;</td>
  </tr>  
</table>
</div>
<br />
<div align="center">
<input type="submit" value="Opstelling opslaan" name="submit" />
</form>
</div>

Ik kom er niet meer uit. Ik loop vast. Let trouwens niet op die Querys die telkens worden opgehaald. Dit is tijdelijk, even kijken hoe ik dat ga doen.

Niels K

21-01-2010 13:36

Als je een form submit moet je dat via $_SERVER['REQUEST_METHOD'] doen en niet via if (isset($_POST['submit']))

Op de 3e en 4e regel gaat het ook niet goed. Want je vergeet de quotes.

Maar geeft hij geen errors dan?

-

- wes -

21-01-2010 13:38

@niels, omdat? voor/nadelen?