extra tekst vakje door mail

ecross · 21 aug 2009

hallo,

ik heb een tabel gemaakt voor wanneer in welke boot een schipper zit
ik heb daarin ook een mail mij dit knop
hij gebruikt dan file_get_contents($site);
alleen in het mailtje krijg ik bovenaan een tekst vakje een een van de verander knoppen (submit) zie je dan in html (zie bijlage)

script:

PHP:

<?php

function show_select($row, $result_schippers){
extract($row);

$query_boten = "SELECT * from bootrooster where id='$id'"
						 or die("query_boten");
$result_boten = mysql_query($query_boten)
							or die("result_boten");
$row_boten = mysql_fetch_array($result_boten)
					 	 or die("row_boten");
						 
$query_dag_week = "SELECT DAYNAME('$datum')";
$result_dag_week = mysql_query($query_dag_week);
$row_dag_week = mysql_fetch_array($result_dag_week);
			
echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>";
echo "<input type='hidden' name='doe' value='verander'>";
echo "<input type='hidden' name='id' value='$id'>";
if ($_GET['alles'] == "alles"){echo "<input type='hidden' name='alles' value='alles'>";}
	
if (isset($_GET['doe'])){echo "<input type='hidden' name='doe_na' value='$_GET[doe]'>";}
if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value='$_GET[dag_maand]'>";}
if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value='$_GET[maand]'>";}
if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value='$_GET[hoe]'>";}
if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value='$_GET[dag]'>";}
if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value='$_GET[schipper]'>";}

echo '<tr>';
echo "<td>" . $datum . "</td>";
echo "<td>" . $row_dag_week['0'] . "</td>";

		mysql_data_seek ( $result_schippers, 0 );	
		echo "<td><select name='valk_ochtend'>";
		if ($row_boten['valk_ochtend'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['valk_ochtend'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='valk_middag'>";
		if ($row_boten['valk_middag'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['valk_middag'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='valk_avond'>";
		if ($row_boten['valk_avond'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['valk_avond'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='rm_ochtend'>";
		if ($row_boten['rm_ochtend'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['rm_ochtend'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='rm_middag'>";
		if ($row_boten['rm_middag'] == '0')
			{echo "<option selected>vrij</option>";}
			else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['rm_middag'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		echo "</select></td>";
		
		mysql_data_seek ( $result_schippers, 0 );
		echo "<td><select name='rm_avond'>";
		if ($row_boten['rm_avond'] == '0')
			{echo "<option selected>vrij</option>";}
		else
			{echo "<option>vrij</option>";}
		while ($row_schippers = mysql_fetch_array($result_schippers))
			{
			if ($row_schippers['schippers_id'] == $row_boten['rm_avond'])
				{echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
			else 
				{echo "<option>" . $row_schippers['voornaam'] . "</option>";}
			}
		
		echo "</select></td>";
		
		echo "<td><input type='text' id='lengte' value='$opm_schip' name='opm_schip'></td>";
		echo "<td><input type='text' id='lengte' value='$opm_bestuur' name='opm_bestuur'></td>";
		echo "<td><input type='submit' value='ok'></td>";
		echo "</form>";
}
######################################################################################################
function show_normaal($row){
extract($row);

$query_dag_week = "SELECT DAYNAME('$datum')";
$result_dag_week = mysql_query($query_dag_week);
$row_dag_week = mysql_fetch_array($result_dag_week);
			
echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>";
echo "<input type='hidden' name='show' value='select'>";
echo "<input type='hidden' name='id' value='$id'>";

if (isset($_GET['doe'])){echo "<input type='hidden' name='doe' value='$_GET[doe]'>";}
if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value='$_GET[dag_maand]'>";}
if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value='$_GET[maand]'>";}
if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value='$_GET[hoe]'>";}
if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value='$_GET[dag]'>";}
if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value='$_GET[schipper]'>";}

if ($_GET['alles'] == "alles"){echo "<input type='hidden' name='alles' value='alles'>";}	
	if ($valk_ochtend == "0"){$valk_ochtend['voornaam'] = "vrij";}
	else {$valk_ochtend = mysql_query("select voornaam from schippers where schippers_id = '$valk_ochtend'");
	$valk_ochtend = mysql_fetch_array($valk_ochtend);}

	if ($valk_middag == "0"){$valk_middag['voornaam'] = "vrij";}
	else {$valk_middag = mysql_query("select voornaam from schippers where schippers_id = '$valk_middag'");
	$valk_middag = mysql_fetch_array($valk_middag);}
		
	if ($valk_avond == "0"){$valk_avond['voornaam'] = "vrij";}
	else {$valk_avond = mysql_query("select voornaam from schippers where schippers_id = '$valk_avond'");
	$valk_avond = mysql_fetch_array($valk_avond);}
		
	if ($rm_ochtend == "0"){$rm_ochtend['voornaam'] = "vrij";}
	else {$rm_ochtend = mysql_query("select voornaam from schippers where schippers_id = '$rm_ochtend'");
	$rm_ochtend = mysql_fetch_array($rm_ochtend);}
		
	if ($rm_middag == "0"){$rm_middag['voornaam'] = "vrij";}
	else {$rm_middag = mysql_query("select voornaam from schippers where schippers_id = '$rm_middag'");
	$rm_middag = mysql_fetch_array($rm_middag);}
	
	if ($rm_avond == "0"){$rm_avond['voornaam'] = "vrij";}
	else {$rm_avond = mysql_query("select voornaam from schippers where schippers_id = '$rm_avond'");
	$rm_avond = mysql_fetch_array($rm_avond);}

$vandaag = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d"),date("Y")));
$gister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
$eergister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-2,date("Y")));
$morgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+1,date("Y")));
$overmorgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+2,date("Y")));
		
echo '<tr>';
echo "<td>" . $datum . "</td>";
echo "<td>" . $row_dag_week['0'] . "</td>";
echo "<td>" . $valk_ochtend['voornaam'] . "</td>";
echo "<td>" . $valk_middag['voornaam'] . "</td>";
echo "<td>" . $valk_avond['voornaam'] . "</td>";
echo "<td>" . $rm_ochtend['voornaam'] . "</td>";
echo "<td>" . $rm_middag['voornaam'] . "</td>";
echo "<td>" . $rm_avond['voornaam'] . "</td>";
echo "<td>" . $opm_schip . "</td>";
echo "<td>" . $opm_bestuur . "</td>";
echo "<td><input type='submit' value='wijzig'></td>";
echo '</tr>';
echo "</form>";
}
#######################################################################################################
function head(){
echo "<tr>";
echo "<td colspan='11' align='center'><b>botenrooster van Gooimeerzeilen</b><br>";
echo "<a href='" . $_SERVER['PHP_SELF'] . "'>toon vandaag</a></td>";
echo "</tr>";
echo "<tr>";

	echo "<tr>
		<td align='center'>zoek op exacte datum</td>
		<td align='center'>zoek op dag</td>
		<td align='center'>zoek op schipper</td>";
	echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' name='doe' value='mail'>";
		if (isset($_GET['doe'])){echo "<input type='hidden' name='doe_na' value='$_GET[doe]'>";}
		if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value='$_GET[dag_maand]'>";}
		if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value='$_GET[maand]'>";}
		if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value='$_GET[hoe]'>";}
		if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value='$_GET[dag]'>";}
		if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value='$_GET[schipper]'>";}
	echo "<td rowspan='2'>
		<input type='text' align='center' name='email' value='email' style='width:8em;'>
		<input type='submit' align='center' value='mail' id='lengte'></td>
		</form>
		<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' value='zoek' name='doe'>
		<input type='hidden' value='exact' name='hoe'>
		
		<td colspan='7' rowspan='2' align='center'>de kolom opm_schippers wordt ook zichtbaar voor de schippers.</td>
		</tr>
		<tr>
		<td align='center'><select name='dag_maand' value='$_GET[dag_maand]'>";
		$dag = date("d");
		
		for ($i = 1; $i <= 31; $i++) {
		if ($i == $_GET['dag_maand']){echo "<option selected>" . $i . "</option>";}
		elseif ($i == $dag){echo "<option selected>" . $i . "</option>";}
		else{echo "<option>" . $i . "</option>";}
		}
  echo "</select>
		<select name='maand'>";
		$maand = date("M");
		$month_names = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
		foreach($month_names as $key => $value){
		if ($value == $_GET['maand']){echo "<option selected>".$value."</option>";}
		elseif ($value == $maand){echo "<option selected>".$value."</option>";}
		else {echo "<option>$value</option>";}}

  echo "</select>
		<input type='submit' value='zoek'></td>
		</form>
		
		<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' value='zoek' name='doe'>
		<input type='hidden' value='dag_week' name='hoe'>
		
		<td align='center'><select name='dag'>";
		$dag = date("D");
		$day_translate = array("Mon"=>"Monday", "Tue"=>"Tuesday", "Wed"=>"Wednesday", "Fri"=>"Friday", "Sat"=>"Saturday", "Sun"=>"Sunday");
		foreach($day_translate as $key => $value){
		if ($dag == $key){$dag = $value;}}
		
		$day_names = array(1=>'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday');
		foreach($day_names as $key => $value){
		if ($value == $_GET['dag']){echo "<option selected>".$value."</option>"; $t="1";}
		elseif ($value == $dag and $t != "1"){echo "<option selected>".$value."</option>";}
		else {echo "<option>".$value."</option>";}}
  echo "</select>
		<input type='submit' value='zoek'></td>
		
		</form>
		<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
		<input type='hidden' value='zoek' name='doe'>
		<input type='hidden' value='schipper' name='hoe'>
		
		<td align='center'><select name='schipper'>";
		$query = "select voornaam from schippers";
		$result = mysql_query($query);
		while ($row = mysql_fetch_array($result)){
		if ($row['voornaam'] == $_GET['schipper']){echo "<option selected>".$row['voornaam']."</option>";}
		else {echo "<option>".$row['voornaam']."</option>";}}
	echo "</select>
		<input type='submit' value='zoek'></td>
		</form></tr>";
echo "<td>datum<td>dag_week<td>valk_ochtend<td>valk_middag<td>valk_avond<td>rm_ochtend<td>rm_middag<td>rm_avond<td>opm_schip<td>opm_bestuur<td>wijzig";
echo "</tr>";			
}

?>
<html>
<head><title>Bootrooster Gooimeerzeilen</title></head>
</html>
<style type="text/css"> 

input#lengte {
	width:  5em;
	  }
</style>
<?php

$user="";
$host="";
$password="";

$database = "";
$tabel_bootrooster = "";
$tabel_schippers = "";

$connection = mysql_connect($host,$user,$password)
       or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
		or die ("Couldn't select database");


echo "<table border='1' align='center' width='100%'>";

switch (@$_GET['doe'])
  {
  case "zoek":
	
		if ($_GET['hoe'] == "exact")
			{
			    if ($_GET['maand'] == "Jan"){$maand = "01";}
			elseif ($_GET['maand'] == "Feb"){$maand = "02";}
			elseif ($_GET['maand'] == "Mar"){$maand = "03";}
			elseif ($_GET['maand'] == "Apr"){$maand = "04";}
			elseif ($_GET['maand'] == "May"){$maand = "05";}
			elseif ($_GET['maand'] == "Jun"){$maand = "06";}
			elseif ($_GET['maand'] == "Jul"){$maand = "07";}
			elseif ($_GET['maand'] == "Aug"){$maand = "08";}
			elseif ($_GET['maand'] == "Sep"){$maand = "09";}
			elseif ($_GET['maand'] == "Oct"){$maand = "10";}
			elseif ($_GET['maand'] == "Nov"){$maand = "11";}
			elseif ($_GET['maand'] == "Dec"){$maand = "12";}
			
				$datum = "2009-" . $maand . "-" . $_GET['dag_maand'];
				$query = "select * from $tabel_bootrooster where datum = '$datum'";
				$result = mysql_query($query);
				
				head();
				
				$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
					or die("query_schippers");
				$result_schippers = mysql_query($query_schippers)
					or die("result_schippers");
				
				if (@$_GET['show'] == "select")
				{
				while($row = mysql_fetch_array($result)) 
					{
					if ($row['id'] < $_GET['id'])
						{show_normaal($row);}
					elseif ($row['id'] == $_GET['id'])
						{show_select($row, $result_schippers);}
					elseif ($row['id'] > $_GET['id'])
						{show_normaal($row);}
					}
				}
				else 
				{
				while($row = mysql_fetch_array($result)) 
					{
					show_normaal($row);
					}
				}
				

			}
		elseif ($_GET['hoe'] == "dag_week")
			{
			head();

			$query = "select * from bootrooster"
				or die("298");
			$result = mysql_query($query)
				or die("wrong2");

			$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
				or die("query_schippers");
			$result_schippers = mysql_query($query_schippers)
				or die("result_schippers");
				if (@$_GET['show'] == "select")
				{
				while($row = mysql_fetch_array($result)) 
					{
					extract($row);
					$query_dagweek = "SELECT DAYNAME('$datum')";
					$result_dagweek = mysql_query($query_dagweek);
					$row_dagweek = mysql_fetch_array($result_dagweek);
					if ($row_dagweek['0'] == $_GET['dag'])
						{
						if ($row['id'] < $_GET['id'])
							{show_normaal($row);}
						elseif ($row['id'] == $_GET['id'])
							{show_select($row, $result_schippers);}
						elseif ($row['id'] > $_GET['id'])
							{show_normaal($row);}
						}
					}
				}
				else 
				{
				while($row = mysql_fetch_array($result)) 
					{
					extract($row);
					$query_dagweek = "SELECT DAYNAME('$datum')";
					$result_dagweek = mysql_query($query_dagweek);
					$row_dagweek = mysql_fetch_array($result_dagweek);
					if ($row_dagweek['0'] == $_GET['dag'])
						{show_normaal($row);}
					}
				}
			}
		elseif ($_GET['hoe'] == "schipper")
			{
			if ($_GET['schipper'] == "vrij"){$schipper['schippers_id'] = "0";}
			else {$schipper = mysql_query("select schippers_id from schippers where voornaam = '$_GET[schipper]'");
			$schipper = mysql_fetch_array($schipper);}
			
			$query = "select * from bootrooster where valk_ochtend='$schipper[schippers_id]' or valk_middag='$schipper[schippers_id]' or valk_avond='$schipper[schippers_id]' or rm_ochtend='$schipper[schippers_id]' or rm_middag='$schipper[schippers_id]' or rm_avond='$schipper[schippers_id]'";
			$result = mysql_query($query);
			head();
			$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
					or die("query_schippers");
			$result_schippers = mysql_query($query_schippers)
					or die("result_schippers");
					
			if (@$_GET['show'] == "select")
				{
				while($row = mysql_fetch_array($result)) 
					{
					if ($row['id'] < $_GET['id'])
						{show_normaal($row);}
					elseif ($row['id'] == $_GET['id'])
						{show_select($row, $result_schippers);}
					elseif ($row['id'] > $_GET['id'])
						{show_normaal($row);}
					}
				}
			else 
				{
				while($row = mysql_fetch_array($result)) 
					{
					show_normaal($row);
					}
				}
			$query_schippers = "SELECT * from schippers where schippers_id = '$schipper[schippers_id]'";
			$result_schippers = mysql_query($query_schippers);
			$row_schippers = mysql_fetch_assoc($result_schippers);
			extract($row_schippers);
			echo "</table>
			<br><p>
				<table border='1'><tr>";
			echo "<td>actief</td>
					 <td>voornaam</td>
					 <td>achternaam</td>
					 <td>t-vast</td>
					 <td>t-mobiel</td>
					 <td>straat</td>
					 <td>huis-nr</td>
					 <td>p-code</td>
					 <td>woonplaats</td>
					 <td>email</td>
					 <td>voorkeurzeilen</td>";
			if (isset($opmerkingen1)){echo"<td>opmerkingen 1</td>";}
			if (isset($opmerkingen2)){echo"<td>opmerkingen 2</td>";}
			if (isset($laatstewijz)){echo"<td>laatste wijz</td>";}
			if (isset($reserve1)){echo"<td>reserve1</td>";}
			if (isset($reserve2)){echo"<td>reserve2</td>";}
			if (isset($reserve3)){echo"<td>reserve3</td>";}

			
			echo "</tr><tr>";
			echo "<td>";
			if($actief == "0"){echo "nee";}
			else{echo "ja";}
			echo "</td>
				 <td>".$voornaam."</td>
				 <td>".$achternaam."</td>
				 <td>".$tvast."</td>
				 <td>".$tmobiel."</td>
				 <td>".$straat."</td>
				 <td>".$huisnr."</td>
				 <td>".$pcode."</td>
				 <td>".$woonplaats."</td>
				 <td>".$email."</td>
				 <td>".$voorkeurzeilen."</td>";
			if (isset($opmerkingen1)){echo"<td>".$opmerkingen1."</td>";} 
			if (isset($opmerkingen2)){echo"<td>".$opmerkingen2."</td>";}
			if (isset($laatstewijz)){echo"<td>".$laatstewijz."</td>";}
			if (isset($reserve1)){echo"<td>".$reserve1."</td>";}
			if (isset($reserve2)){echo"<td>".$reserve2."</td>";}
			if (isset($reserve3)){echo"<td>".$reserve3."</td>";}				 
			echo "</tr></table></p>";
			}
	
  break;
  case "verander":

		if ($_GET['valk_ochtend'] == "vrij"){$row_valk_ochtend['schippers_id'] = "0";}
		else{$result_valk_ochtend = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_ochtend]'");
		$row_valk_ochtend = mysql_fetch_array($result_valk_ochtend);}
		
		if ($_GET['valk_middag'] == "vrij"){$row_valk_middag['schippers_id'] = "0";}
		else {$result_valk_middag = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_middag]'");
		$row_valk_middag = mysql_fetch_array($result_valk_middag);}
		
		if ($_GET['valk_avond'] == "vrij"){$row_valk_avond['schippers_id'] = "0";}
		else {$result_valk_avond = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_avond]'");
		$row_valk_avond = mysql_fetch_array($result_valk_avond);}
		
		if ($_GET['rm_ochtend'] == "vrij"){$row_rm_ochtend['schippers_id'] = "0";}
		else {$result_rm_ochtend = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_ochtend]'");
		$row_rm_ochtend = mysql_fetch_array($result_rm_ochtend);}
		
		if ($_GET['rm_middag'] == "vrij"){$row_rm_middag['schippers_id'] = "0";}
		else {$result_rm_middag = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_middag]'");
		$row_rm_middag = mysql_fetch_array($result_rm_middag);}
		
		if ($_GET['rm_avond'] == "vrij"){$row_rm_avond['schippers_id'] = "0";}
		else {$result_rm_avond = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_avond]'");
		$row_rm_avond = mysql_fetch_array($result_rm_avond);}
		
		$query_verander = "UPDATE bootrooster SET valk_ochtend='$row_valk_ochtend[schippers_id]', valk_middag='$row_valk_middag[schippers_id]', valk_avond='$row_valk_avond[schippers_id]', rm_ochtend='$row_rm_ochtend[schippers_id]', rm_middag='$row_rm_middag[schippers_id]', rm_avond='$row_rm_avond[schippers_id]', opm_schip='$_GET[opm_schip]', opm_bestuur='$_GET[opm_bestuur]' WHERE id='$_GET[id]'";
		$result_verander = mysql_query($query_verander);
		
		echo "<script language='javascript'>";
		echo "window.location = '".$_server['php_self']."?";
		if(isset($_GET['doe_na'])){ echo "doe=".$_GET['doe_na'];} 
		if(isset($_GET['dag_maand'])){echo"&dag_maand=".$_GET['dag_maand'];} 
		if (isset($_GET['schipper'])){echo"&schipper=".$_GET['schipper'];}  
		if(isset($_GET['maand'])){echo"&maand=".$_GET['maand'];} 
		if (isset($_GET['dag'])){echo"&dag=".$_GET['dag'];} 
		if(isset($_GET['hoe'])){echo"&hoe=".$_GET['hoe'];}
		echo"'";		
		echo "</script>";

  break;
  case "mail":
  
		$site = $_SERVER["HTTP_HOST"] . $_SERVER["PHP_SELF"] . "?";
		foreach ($_GET as $sleutel => $waarde)
		{if ($sleutel != "doe" and $sleutel != "email")
			{
			if ($sleutel == "doe_na")
				{$site .= "doe=".$waarde; $count="1";}
			else{
				if (!isset($count)){$site .= $sleutel . "=" . $waarde; $count="1";}
				else {$site .= "&" . $sleutel . "=" . $waarde;}
				}
			}
		}
		
		$to = $_GET['email'];
		$message = file_get_contents("http://".$site);
		$subject = "subject";
		$headers  = 'MIME-Version: 1.0' . "\r\n";
		$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
		$headers .= 'From: van' . "\r\n";
		mail($to, $subject, $message, $headers);
		
		echo "<script language='javascript'>";
		echo "window.location = '".$_server['php_self']."?";
		if(isset($_GET['doe_na'])){ echo "doe=".$_GET['doe_na'];} 
		if(isset($_GET['dag_maand'])){echo"&dag_maand=".$_GET['dag_maand'];} 
		if (isset($_GET['schipper'])){echo"&schipper=".$_GET['schipper'];}  
		if(isset($_GET['maand'])){echo"&maand=".$_GET['maand'];} 
		if (isset($_GET['dag'])){echo"&dag=".$_GET['dag'];} 
		if(isset($_GET['hoe'])){echo"&hoe=".$_GET['hoe'];}
		$zEind = microtime(true);
		$zVerschil = $zEind - $zStart;
		echo"&tijd=".$zVerschil;
		echo"'";		
		echo "</script>";
  break;
  default:
		$vandaag = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d"),date("Y")));
		$gister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
		$eergister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-2,date("Y")));
		$morgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+1,date("Y")));
		$overmorgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+2,date("Y")));
		
		if ($_GET['alles'] != "alles"){
		$query = "SELECT * FROM $tabel_bootrooster where datum='$vandaag' or datum='$morgen' or datum='$overmorgen' or datum='$gister' or datum='$eergister'"
			or die("query");}
		elseif ($_GET['alles'] == "alles"){
		$query = "SELECT * FROM $tabel_bootrooster";}
		$result = mysql_query($query)
		or die("result");
		
   
		$query_schippers = "SELECT schippers_id, voornaam FROM $tabel_schippers"
			or die("query_schippers");
		$result_schippers = mysql_query($query_schippers)
			or die("result_schippers");
		head();
		if (@$_GET['show'] == "select")
		{
			
		while($row = mysql_fetch_array($result)) 
			{
			if ($row['id'] < $_GET['id'])
				{show_normaal($row);}
			elseif ($row['id'] == $_GET['id'])
				{show_select($row, $result_schippers);}
			elseif ($row['id'] > $_GET['id'])
				{show_normaal($row);}
			}
		}
		else 
		{
		while($row = mysql_fetch_array($result)) 
			{
			show_normaal($row);
			}
		}
	break;
   }
	?>

ecross · 24 aug 2009

iemand een iedee?

flitsflitsflits · 24 aug 2009

Het zal wel aan mij liggen, maar ik snap niet wat de vraag is.

ecross · 24 aug 2009

op mijn site heb ik een knop met "mail mij dit"
dan word er een mail gestuurd met de pagina

alleen komt er in de mail ook een tekst vakje en een andere knop niet die wel in de website zit
hoe komt dat ?

ecross · 4 sep 2009

iemand anders?

ecross · 9 sep 2009

ik snap er ook niks van hoor

mm misschien is het heel ingewikkeld

Frats · 9 sep 2009

Dat script is enorm en ik heb niet zo'n zin om het helemaal uit te pluizen

'

Misschien als je het probleem kunt traceren tot een stukje van een regel of 50?

ecross · 10 sep 2009

ik snap er zelf ook niks van
Dat was zegmaar het moment waar ik een berichtje hier zette

maar het zal niet zitten in function show_select, case "zoek" en case "verander"

wat over is:

function show_noormaal
function head
case "mail"
default (van de switch)

misschien dat je me nu kan helpen?

eeyk · 10 sep 2009

ik heb deze avond toch niks te doen ik bekijk het script voor je na !

Even geduld :thumb:

flitsflitsflits · 10 sep 2009

In dit geval lijkt het me verstandig om in de html code (dus in de email) te kijken wat er mis is en aan de hand daarvan de fout op te sporen in de php code.

In het screenshot lijkt het erop dat er een spatie zit tussen < en input terwijl dit in de php code niet zo is.

eeyk · 10 sep 2009

heb je script vlink aangepakt
alles met `` gezet en ". $array ."
en {$array}
en natuurlijk ook de inputs na gekeken!

een een nieuw functie toegevoegd
date_default_timezone_set("Europe/Berlin");

dit is toch handiger als een Werk lid je site bijkt uit een ander land

kan zelf niet testen Http://crime-ware.nl/transport.php
heb geen SQL gegevens

PHP:

<?php
session_start();
date_default_timezone_set("Europe/Berlin");

function show_select($row, $result_schippers){
extract($row);
 
$query_boten = "SELECT * from `bootrooster` where `id`='$id'"
                         or die("query_boten");
$result_boten = mysql_query($query_boten)
                            or die("result_boten");
$row_boten = mysql_fetch_array($result_boten)
                         or die("row_boten");
												         
$query_dag_week = "SELECT DAYNAME('$datum')";
$result_dag_week = mysql_query($query_dag_week);
$row_dag_week = mysql_fetch_array($result_dag_week);
            
echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>";
echo "<input type='hidden' name='doe' value='verander'>";
echo "<input type='hidden' name='id' value='$id'>";
if ($_GET['alles'] == "alles"){echo "<input type='hidden' name='alles' value='alles'>";}
    
if (isset($_GET['doe'])){echo "<input type='hidden' name='doe_na' value=". $_GET['doe'] .">";}
if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value=". $_GET['dag_maand'] .">";}
if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value=". $_GET['maand'] .">";}
if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value=". $_GET['hoe'] .">";}
if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value=". $_GET['dag'] .">";}
if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value=". $_GET['schipper'] .">";}
 
echo '<tr>';
echo "<td>" . $datum . "</td>";
echo "<td>" . $row_dag_week['0'] . "</td>";
 
        mysql_data_seek ($result_schippers, 0);   
        echo "<td><select name='valk_ochtend'>";
        if ($row_boten['valk_ochtend'] == '0')
            {echo "<option selected>vrij</option>";}
        else
            {echo "<option>vrij</option>";}
        while ($row_schippers = mysql_fetch_array($result_schippers))
            {
            if ($row_schippers['schippers_id'] == $row_boten['valk_ochtend'])
                {echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
            else 
                {echo "<option>" . $row_schippers['voornaam'] . "</option>";}
            }
        echo "</select></td>";
        
        mysql_data_seek ($result_schippers, 0);
        echo "<td><select name='valk_middag'>";
        if ($row_boten['valk_middag'] == '0')
            {echo "<option selected>vrij</option>";}
        else
            {echo "<option>vrij</option>";}
        while ($row_schippers = mysql_fetch_array($result_schippers))
            {
            if ($row_schippers['schippers_id'] == $row_boten['valk_middag'])
                {echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
            else 
                {echo "<option>" . $row_schippers['voornaam'] . "</option>";}
            }
        echo "</select></td>";
        
        mysql_data_seek ( $result_schippers, 0 );
        echo "<td><select name='valk_avond'>";
        if ($row_boten['valk_avond'] == '0')
            {echo "<option selected>vrij</option>";}
        else
            {echo "<option>vrij</option>";}
        while ($row_schippers = mysql_fetch_array($result_schippers))
            {
            if ($row_schippers['schippers_id'] == $row_boten['valk_avond'])
                {echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
            else 
                {echo "<option>" . $row_schippers['voornaam'] . "</option>";}
            }
        echo "</select></td>";
        
        mysql_data_seek ( $result_schippers, 0 );
        echo "<td><select name='rm_ochtend'>";
        if ($row_boten['rm_ochtend'] == '0')
            {echo "<option selected>vrij</option>";}
        else
            {echo "<option>vrij</option>";}
        while ($row_schippers = mysql_fetch_array($result_schippers))
            {
            if ($row_schippers['schippers_id'] == $row_boten['rm_ochtend'])
                {echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
            else 
                {echo "<option>" . $row_schippers['voornaam'] . "</option>";}
            }
        echo "</select></td>";
        
        mysql_data_seek ( $result_schippers, 0 );
        echo "<td><select name='rm_middag'>";
        if ($row_boten['rm_middag'] == '0')
            {echo "<option selected>vrij</option>";}
            else
            {echo "<option>vrij</option>";}
        while ($row_schippers = mysql_fetch_array($result_schippers))
            {
            if ($row_schippers['schippers_id'] == $row_boten['rm_middag'])
                {echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
            else 
                {echo "<option>" . $row_schippers['voornaam'] . "</option>";}
            }
        echo "</select></td>";
        
        mysql_data_seek ( $result_schippers, 0 );
        echo "<td><select name='rm_avond'>";
        if ($row_boten['rm_avond'] == '0')
            {echo "<option selected>vrij</option>";}
        else
            {echo "<option>vrij</option>";}
        while ($row_schippers = mysql_fetch_array($result_schippers))
            {
            if ($row_schippers['schippers_id'] == $row_boten['rm_avond'])
                {echo "<option selected>" . $row_schippers['voornaam'] . "</option>";}
            else 
                {echo "<option>" . $row_schippers['voornaam'] . "</option>";}
            }
        
        echo "</select></td>";
        
        echo "<td><input type='text' id='lengte' value='$opm_schip' name='opm_schip'></td>";
        echo "<td><input type='text' id='lengte' value='$opm_bestuur' name='opm_bestuur'></td>";
        echo "<td><input type='submit' value='ok'></td>";
        echo "</form>";
}
######################################################################################################
function show_normaal($row){
extract($row);
 
$query_dag_week = "SELECT DAYNAME('$datum')";
$result_dag_week = mysql_query($query_dag_week);
$row_dag_week = mysql_fetch_array($result_dag_week);
            
echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>";
echo "<input type='hidden' name='show' value='select'>";
echo "<input type='hidden' name='id' value='$id'>";
 
if (isset($_GET['doe'])){echo "<input type='hidden' name='doe_na' value=". $_GET['doe'] .">";}
if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value=". $_GET['dag_maand'] .">";}
if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value=". $_GET['maand'] .">";}
if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value=". $_GET['hoe'] .">";}
if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value=". $_GET['dag'] .">";}
if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value=". $_GET['schipper'] .">";}
 
if ($_GET['alles'] == "alles"){echo "<input type='hidden' name='alles' value='alles'>";}    
    if ($valk_ochtend == "0"){$valk_ochtend['voornaam'] = "vrij";}
    else {$valk_ochtend = mysql_query("select voornaam from schippers where schippers_id = '$valk_ochtend'");
    $valk_ochtend = mysql_fetch_array($valk_ochtend);}
 
    if ($valk_middag == "0"){$valk_middag['voornaam'] = "vrij";}
    else {$valk_middag = mysql_query("select voornaam from schippers where schippers_id = '$valk_middag'");
    $valk_middag = mysql_fetch_array($valk_middag);}
        
    if ($valk_avond == "0"){$valk_avond['voornaam'] = "vrij";}
    else {$valk_avond = mysql_query("select voornaam from schippers where schippers_id = '$valk_avond'");
    $valk_avond = mysql_fetch_array($valk_avond);}
        
    if ($rm_ochtend == "0"){$rm_ochtend['voornaam'] = "vrij";}
    else {$rm_ochtend = mysql_query("select voornaam from schippers where schippers_id = '$rm_ochtend'");
    $rm_ochtend = mysql_fetch_array($rm_ochtend);}
        
    if ($rm_middag == "0"){$rm_middag['voornaam'] = "vrij";}
    else {$rm_middag = mysql_query("select voornaam from schippers where schippers_id = '$rm_middag'");
    $rm_middag = mysql_fetch_array($rm_middag);}
    
    if ($rm_avond == "0"){$rm_avond['voornaam'] = "vrij";}
    else {$rm_avond = mysql_query("select voornaam from schippers where schippers_id = '$rm_avond'");
    $rm_avond = mysql_fetch_array($rm_avond);}
 
$vandaag = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d"),date("Y")));
$gister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
$eergister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-2,date("Y")));
$morgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+1,date("Y")));
$overmorgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+2,date("Y")));
        
echo '<tr>';
echo "<td>" . $datum . "</td>";
echo "<td>" . $row_dag_week['0'] . "</td>";
echo "<td>" . $valk_ochtend['voornaam'] . "</td>";
echo "<td>" . $valk_middag['voornaam'] . "</td>";
echo "<td>" . $valk_avond['voornaam'] . "</td>";
echo "<td>" . $rm_ochtend['voornaam'] . "</td>";
echo "<td>" . $rm_middag['voornaam'] . "</td>";
echo "<td>" . $rm_avond['voornaam'] . "</td>";
echo "<td>" . $opm_schip . "</td>";
echo "<td>" . $opm_bestuur . "</td>";
echo "<td><input type=\"submit\" value=\"wijzig\"></td>";
echo '</tr>';
echo "</form>";
}
#######################################################################################################
function head(){
echo "<tr>";
echo "<td colspan='11' align='center'><b>botenrooster van Gooimeerzeilen</b><br>";
echo "<a href='" . $_SERVER['PHP_SELF'] . "'>toon vandaag</a></td>";
echo "</tr>";
echo "<tr>";
 
    echo "<tr>
        <td align='center'>zoek op exacte datum</td>
        <td align='center'>zoek op dag</td>
        <td align='center'>zoek op schipper</td>";
    echo "<form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
        <input type='hidden' name='doe' value='mail'>";
if (isset($_GET['doe'])){echo "<input type='hidden' name='doe_na' value=". $_GET['doe'] .">";}
if (isset($_GET['dag_maand'])){echo "<input type='hidden' name='dag_maand' value=". $_GET['dag_maand'] .">";}
if (isset($_GET['maand'])){echo "<input type='hidden' name='maand' value=". $_GET['maand'] .">";}
if (isset($_GET['hoe'])){echo "<input type='hidden' name='hoe' value=". $_GET['hoe'] .">";}
if (isset($_GET['dag'])){echo "<input type='hidden' name='dag' value=". $_GET['dag'] .">";}
if (isset($_GET['schipper'])){echo "<input type='hidden' name='schipper' value=". $_GET['schipper'] .">";}
    echo "<td rowspan='2'>
        <input type='text' align='center' name='email' value='email' style='width:8em;'>
        <input type='submit' align='center' value='mail' id='lengte'></td>
        </form>
        <form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
        <input type='hidden' value='zoek' name='doe'>
        <input type='hidden' value='exact' name='hoe'>
        
        <td colspan='7' rowspan='2' align='center'>de kolom opm_schippers wordt ook zichtbaar voor de schippers.</td>
        </tr>
        <tr>
        <td align='center'><select name='dag_maand' value='$_GET[dag_maand]'>";
        $dag = date("d");
        
        for ($i = 1; $i <= 31; $i++) {
        if ($i == $_GET['dag_maand']){echo "<option selected>" . $i . "</option>";}
        elseif ($i == $dag){echo "<option selected>" . $i . "</option>";}
        else{echo "<option>" . $i . "</option>";}
        }
  echo "</select>
        <select name='maand'>";
        $maand = date("M");
        $month_names = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
        foreach($month_names as $key => $value){
        if ($value == $_GET['maand']){echo "<option selected>".$value."</option>";}
        elseif ($value == $maand){echo "<option selected>".$value."</option>";}
        else {echo "<option>$value</option>";}}
 
  echo "</select>
        <input type='submit' value='zoek'></td>
        </form>
        
        <form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
        <input type='hidden' value='zoek' name='doe'>
        <input type='hidden' value='dag_week' name='hoe'>
        
        <td align='center'><select name='dag'>";
        $dag = date("D");
        $day_translate = array("Mon"=>"Monday", "Tue"=>"Tuesday", "Wed"=>"Wednesday", "Fri"=>"Friday", "Sat"=>"Saturday", "Sun"=>"Sunday");
        foreach($day_translate as $key => $value){
        if ($dag == $key){$dag = $value;}}
        
        $day_names = array(1=>'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday');
        foreach($day_names as $key => $value){
        if ($value == $_GET['dag']){echo "<option selected>".$value."</option>"; $t="1";}
        elseif ($value == $dag and $t != "1"){echo "<option selected>".$value."</option>";}
        else {echo "<option>".$value."</option>";}}
  echo "</select>
        <input type='submit' value='zoek'></td>
        
        </form>
        <form action='" . $_SERVER['PHP_SELF'] . "' method='GET'>
        <input type='hidden' value='zoek' name='doe'>
        <input type='hidden' value='schipper' name='hoe'>
        
        <td align='center'><select name='schipper'>";
        $query = "select voornaam from schippers";
        $result = mysql_query($query);
        while ($row = mysql_fetch_array($result)){
        if ($row['voornaam'] == $_GET['schipper']){echo "<option selected>".$row['voornaam']."</option>";}
        else {echo "<option>".$row['voornaam']."</option>";}}
    echo "</select>
        <input type='submit' value='zoek'></td>
        </form></tr>";
echo "<td>datum<td>dag_week<td>valk_ochtend<td>valk_middag<td>valk_avond<td>rm_ochtend<td>rm_middag<td>rm_avond<td>opm_schip<td>opm_bestuur<td>wijzig";
echo "</tr>";           
}
 
?>
<html>
<head><title>Bootrooster Gooimeerzeilen</title></head>
</html>
<style type="text/css"> 
 
input#lengte {
    width:  5em;
      }
</style>
<?php
 
$user="";
$host="";
$password="";
 
$database = "";
$tabel_bootrooster = "";
$tabel_schippers = "";
 
$connection = @mysql_connect($host,$user,$password)
       or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");
 
 
echo "<table border='1' align='center' width='100%'>";
 
switch (@$_GET['doe'])
  {
  case "zoek":
    
        if ($_GET['hoe'] == "exact")
            {
                if ($_GET['maand'] == "Jan"){$maand = "01";}
            elseif ($_GET['maand'] == "Feb"){$maand = "02";}
            elseif ($_GET['maand'] == "Mar"){$maand = "03";}
            elseif ($_GET['maand'] == "Apr"){$maand = "04";}
            elseif ($_GET['maand'] == "May"){$maand = "05";}
            elseif ($_GET['maand'] == "Jun"){$maand = "06";}
            elseif ($_GET['maand'] == "Jul"){$maand = "07";}
            elseif ($_GET['maand'] == "Aug"){$maand = "08";}
            elseif ($_GET['maand'] == "Sep"){$maand = "09";}
            elseif ($_GET['maand'] == "Oct"){$maand = "10";}
            elseif ($_GET['maand'] == "Nov"){$maand = "11";}
            elseif ($_GET['maand'] == "Dec"){$maand = "12";}
            
                $datum = "2009-" . $maand . "-" . $_GET['dag_maand'];
                $query = "select * from '{$tabel_bootrooster}' where `datum`='$datum'";
                $result = mysql_query($query);
                
                head();
                
                $query_schippers = "SELECT `schippers_id`, `voornaam` FROM '{$tabel_schippers}'"
                    or die("query_schippers");
                $result_schippers = mysql_query($query_schippers)
                    or die("result_schippers");
                
                if (@$_GET['show'] == "select")
                {
                while($row = mysql_fetch_array($result)) 
                    {
                    if ($row['id'] < $_GET['id'])
                        {show_normaal($row);}
                    elseif ($row['id'] == $_GET['id'])
                        {show_select($row, $result_schippers);}
                    elseif ($row['id'] > $_GET['id'])
                        {show_normaal($row);}
                    }
                }
                else 
                {
                while($row = mysql_fetch_array($result)) 
                    {
                    show_normaal($row);
                    }
                }
                
 
            }
        elseif ($_GET['hoe'] == "dag_week")
            {
            head();
 
            $query = "select * from `bootrooster`"
                or die("298");
            $result = mysql_query($query)
                or die("wrong2");
 
            $query_schippers = "SELECT `schippers_id`, `voornaam` FROM '{$tabel_schippers}'"
                or die("query_schippers");
            $result_schippers = mysql_query($query_schippers)
                or die("result_schippers");
                if (@$_GET['show'] == "select")
                {
                while($row = mysql_fetch_array($result)) 
                    {
                    extract($row);
                    $query_dagweek = "SELECT DAYNAME('$datum')";
                    $result_dagweek = mysql_query($query_dagweek);
                    $row_dagweek = mysql_fetch_array($result_dagweek);
                    if ($row_dagweek['0'] == $_GET['dag'])
                        {
                        if ($row['id'] < $_GET['id'])
                            {show_normaal($row);}
                        elseif ($row['id'] == $_GET['id'])
                            {show_select($row, $result_schippers);}
                        elseif ($row['id'] > $_GET['id'])
                            {show_normaal($row);}
                        }
                    }
                }
                else 
                {
                while($row = mysql_fetch_array($result)) 
                    {
                    extract($row);
                    $query_dagweek = "SELECT DAYNAME('$datum')";
                    $result_dagweek = mysql_query($query_dagweek);
                    $row_dagweek = mysql_fetch_array($result_dagweek);
                    if ($row_dagweek['0'] == $_GET['dag'])
                        {show_normaal($row);}
                    }
                }
            }
        elseif ($_GET['hoe'] == "schipper")
            {
            if ($_GET['schipper'] == "vrij"){$schipper['schippers_id'] = "0";}
            else {$schipper = mysql_query("select schippers_id from schippers where voornaam = '$_GET[schipper]'");
            $schipper = mysql_fetch_array($schipper);}
            
            $query = "select * from `bootrooster` where `valk_ochtend`='$schipper[schippers_id]' or `valk_middag`='$schipper[schippers_id]' or `valk_avond`='$schipper[schippers_id]' or `rm_ochtend`='$schipper[schippers_id]' or `rm_middag`='$schipper[schippers_id]' or `rm_avond`='$schipper[schippers_id]'";
            $result = mysql_query($query);
            head();
            $query_schippers = "SELECT` schippers_id`, voornaam FROM '{$tabel_schippers}'"
                    or die("query_schippers");
            $result_schippers = mysql_query($query_schippers)
                    or die("result_schippers");
                    
            if (@$_GET['show'] == "select")
                {
                while($row = mysql_fetch_array($result)) 
                    {
                    if ($row['id'] < $_GET['id'])
                        {show_normaal($row);}
                    elseif ($row['id'] == $_GET['id'])
                        {show_select($row, $result_schippers);}
                    elseif ($row['id'] > $_GET['id'])
                        {show_normaal($row);}
                    }
                }
            else 
                {
                while($row = mysql_fetch_array($result)) 
                    {
                    show_normaal($row);
                    }
                }
            $query_schippers = "SELECT * from `schippers` where `schippers_id`='{$schipper[schippers_id]}'";
            $result_schippers = mysql_query($query_schippers);
            $row_schippers = mysql_fetch_assoc($result_schippers);
            extract($row_schippers);
            echo "</table>
            <br><p>
                <table border='1'><tr>";
            echo "<td>actief</td>
                     <td>voornaam</td>
                     <td>achternaam</td>
                     <td>t-vast</td>
                     <td>t-mobiel</td>
                     <td>straat</td>
                     <td>huis-nr</td>
                     <td>p-code</td>
                     <td>woonplaats</td>
                     <td>email</td>
                     <td>voorkeurzeilen</td>";
            if (isset($opmerkingen1)){echo"<td>opmerkingen 1</td>";}
            if (isset($opmerkingen2)){echo"<td>opmerkingen 2</td>";}
            if (isset($laatstewijz)){echo"<td>laatste wijz</td>";}
            if (isset($reserve1)){echo"<td>reserve1</td>";}
            if (isset($reserve2)){echo"<td>reserve2</td>";}
            if (isset($reserve3)){echo"<td>reserve3</td>";}
 
            
            echo "</tr><tr>";
            echo "<td>";
            if($actief == "0"){echo "nee";}
            else{echo "ja";}
            echo "</td>
                 <td>".$voornaam."</td>
                 <td>".$achternaam."</td>
                 <td>".$tvast."</td>
                 <td>".$tmobiel."</td>
                 <td>".$straat."</td>
                 <td>".$huisnr."</td>
                 <td>".$pcode."</td>
                 <td>".$woonplaats."</td>
                 <td>".$email."</td>
                 <td>".$voorkeurzeilen."</td>";
            if (isset($opmerkingen1)){echo"<td>".$opmerkingen1."</td>";} 
            if (isset($opmerkingen2)){echo"<td>".$opmerkingen2."</td>";}
            if (isset($laatstewijz)){echo"<td>".$laatstewijz."</td>";}
            if (isset($reserve1)){echo"<td>".$reserve1."</td>";}
            if (isset($reserve2)){echo"<td>".$reserve2."</td>";}
            if (isset($reserve3)){echo"<td>".$reserve3."</td>";}                 
            echo "</tr></table></p>";
            }
    
  break;
  case "verander":
 
        if ($_GET['valk_ochtend'] == "vrij"){$row_valk_ochtend['schippers_id'] = "0";}
        else{$result_valk_ochtend = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_ochtend]'");
        $row_valk_ochtend = mysql_fetch_array($result_valk_ochtend);}
        
        if ($_GET['valk_middag'] == "vrij"){$row_valk_middag['schippers_id'] = "0";}
        else {$result_valk_middag = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_middag]'");
        $row_valk_middag = mysql_fetch_array($result_valk_middag);}
        
        if ($_GET['valk_avond'] == "vrij"){$row_valk_avond['schippers_id'] = "0";}
        else {$result_valk_avond = mysql_query("select schippers_id from schippers where voornaam = '$_GET[valk_avond]'");
        $row_valk_avond = mysql_fetch_array($result_valk_avond);}
        
        if ($_GET['rm_ochtend'] == "vrij"){$row_rm_ochtend['schippers_id'] = "0";}
        else {$result_rm_ochtend = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_ochtend]'");
        $row_rm_ochtend = mysql_fetch_array($result_rm_ochtend);}
        
        if ($_GET['rm_middag'] == "vrij"){$row_rm_middag['schippers_id'] = "0";}
        else {$result_rm_middag = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_middag]'");
        $row_rm_middag = mysql_fetch_array($result_rm_middag);}
        
        if ($_GET['rm_avond'] == "vrij"){$row_rm_avond['schippers_id'] = "0";}
        else {$result_rm_avond = mysql_query("select schippers_id from schippers where voornaam = '$_GET[rm_avond]'");
        $row_rm_avond = mysql_fetch_array($result_rm_avond);}
        
        $query_verander = "UPDATE `bootrooster` SET `valk_ochtend`='$row_valk_ochtend[schippers_id]', `valk_middag`='$row_valk_middag[schippers_id]', `valk_avond`='$row_valk_avond[schippers_id]', `rm_ochtend`='$row_rm_ochtend[schippers_id]', `rm_middag`='$row_rm_middag[schippers_id]', `rm_avond`='$row_rm_avond[schippers_id]', `opm_schip`='$_GET[opm_schip]', `opm_bestuur`='$_GET[opm_bestuur]' WHERE id='{$_GET[id]}'";
        $result_verander = mysql_query($query_verander);
        
        echo "<script language='javascript'>";
        echo "window.location = '".$_server['php_self']."?";
        if(isset($_GET['doe_na'])){ echo "doe=".$_GET['doe_na'];} 
        if(isset($_GET['dag_maand'])){echo"&dag_maand=".$_GET['dag_maand'];} 
        if (isset($_GET['schipper'])){echo"&schipper=".$_GET['schipper'];}  
        if(isset($_GET['maand'])){echo"&maand=".$_GET['maand'];} 
        if (isset($_GET['dag'])){echo"&dag=".$_GET['dag'];} 
        if(isset($_GET['hoe'])){echo"&hoe=".$_GET['hoe'];}
        echo"'";        
        echo "</script>";
 
  break;
  case "mail":
  
        $site = $_SERVER["HTTP_HOST"] . $_SERVER["PHP_SELF"] . "?";
        foreach ($_GET as $sleutel => $waarde)
        {if ($sleutel != "doe" and $sleutel != "email")
            {
            if ($sleutel == "doe_na")
                {$site .= "doe=".$waarde; $count="1";}
            else{
                if (!isset($count)){$site .= $sleutel . "=" . $waarde; $count="1";}
                else {$site .= "&" . $sleutel . "=" . $waarde;}
                }
            }
        }
        
        $to = $_GET['email']; 
        $message = file_get_contents("http://".$site);
				
        $subject = "subject";
        $headers  = 'MIME-Version: 1.0' . "\r\n";
        $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
        $headers .= 'From: van' . "\r\n";
        mail($to, $subject, $message, $headers);
        
        echo "<script language='javascript'>";
        echo "window.location = '".$_server['php_self']."?";
        if(isset($_GET['doe_na'])){ echo "doe=".$_GET['doe_na'];} 
        if(isset($_GET['dag_maand'])){echo"&dag_maand=".$_GET['dag_maand'];} 
        if (isset($_GET['schipper'])){echo"&schipper=".$_GET['schipper'];}  
        if(isset($_GET['maand'])){echo"&maand=".$_GET['maand'];} 
        if (isset($_GET['dag'])){echo"&dag=".$_GET['dag'];} 
        if(isset($_GET['hoe'])){echo"&hoe=".$_GET['hoe'];}
        $zEind = microtime(true);
        $zVerschil = $zEind - $zStart;
        echo"&tijd=".$zVerschil;
        echo"'";        
        echo "</script>";
  break;
  default:
        $vandaag = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d"),date("Y")));
        $gister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
        $eergister = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")-2,date("Y")));
        $morgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+1,date("Y")));
        $overmorgen = date("Y-m-d",mktime(0, 0, 0, date("m"),date("d")+2,date("Y")));
        
        if ($_GET['alles'] != "alles"){
        $query = "SELECT * FROM $tabel_bootrooster where `datum`='$vandaag' or `datum`='$morgen' or `datum=`'$overmorgen' or `datum`='$gister' or `datum`='$eergister'"
            or die("query");}
        elseif ($_GET['alles'] == "alles"){
        $query = "SELECT * FROM $tabel_bootrooster";}
        $result = mysql_query($query)
        or die("result");
        
   
        $query_schippers = "SELECT `schippers_id`, `voornaam` FROM '{$tabel_schippers}'"
            or die("query_schippers");
        $result_schippers = mysql_query($query_schippers)
            or die("result_schippers");
        head();
        if (@$_GET['show'] == "select")
        {
            
        while($row = mysql_fetch_array($result)) 
            {
            if ($row['id'] < $_GET['id'])
                {show_normaal($row);}
            elseif ($row['id'] == $_GET['id'])
                {show_select($row, $result_schippers);}
            elseif ($row['id'] > $_GET['id'])
                {show_normaal($row);}
            }
        }
        else 
        {
        while($row = mysql_fetch_array($result)) 
            {
            show_normaal($row);
            }
        }
    break;
   }
// Rapair by Eeyk Van der noot  AT Home
    ?>

ecross · 13 sep 2009

hij geeft:

result

wat slaat op fout afhandeling van regel 585

regel 579 t/m 585

PHP:

if ($_GET['alles'] != "alles"){
        $query = "SELECT * FROM $tabel_bootrooster where `datum`='$vandaag' or `datum`='$morgen' or `datum=`'$overmorgen' or `datum`='$gister' or `datum`='$eergister'"
            or die("query");}
        elseif ($_GET['alles'] == "alles"){
        $query = "SELECT * FROM $tabel_bootrooster";}
$result = mysql_query($query)
        or die("result");

bedankt voor je moeite van het uitpluizen van mijn script

eeyk · 13 sep 2009

PHP:

if ($_GET['alles'] != "alles"){
        $query = "SELECT * FROM '{$tabel_bootrooster}' where `datum`='{$vandaag}' or `datum`='{$morgen}' or `datum`='{$overmorgen}' or `datum`='{$gister}' or `datum`='{$eergister}'"
            or die("query");}
        elseif ($_GET['alles'] == "alles"){
        $query = "SELECT * FROM '{$tabel_bootrooster}'";}
$result = mysql_query($query)
        or die("result");

Zat paar `` foutjes in

ecross · 14 sep 2009

nog steeds de zelfde fout melding

eeyk · 14 sep 2009

Welke fout krijg je?

Tha Devil · 14 sep 2009

Regel 7 van de laatste code eens wijzigen naar

PHP:

or die(mysql_error());

Dan krijg je tenminste een fatsoenlijke foutmelding.
Grote kans dat je query voor problemen zorgt

ecross · 15 sep 2009

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''bootrooster' where `datum`='2009-09-15' or `datum`='2009-09-16' or `datum`='200' at line 1]

extra tekst vakje door mail

ecross

Gebruiker

Bijlagen

ecross

Gebruiker

flitsflitsflits

Gebruiker

ecross

Gebruiker

ecross

Gebruiker

ecross

Gebruiker

Frats

Terugkerende gebruiker

ecross

Gebruiker

eeyk

Terugkerende gebruiker

flitsflitsflits

Gebruiker

eeyk

Terugkerende gebruiker

ecross

Gebruiker

eeyk

Terugkerende gebruiker

ecross

Gebruiker

eeyk

Terugkerende gebruiker

Tha Devil

Moderator

ecross

Gebruiker

Nieuwste berichten

Wij waarderen jouw privacy