All pastes #73298 Raw Edit

Something

public php v1 · immutable
#73298 ·published 2006-06-27 18:04 UTC
rendered paste body
<?phpif (!isset($_POST['cboVilla'])){	$villa_id = $_GET['villa_id'];}else{	$villa_id = $_POST['cboVilla'];}// selecteer villa uit de database$sql_villa =	"SELECT v.villa_naam, v.villa_id,							vb.beschikbaarheid, vb.week_nummer							FROM villa_beschikbaarheid vb, villa v							WHERE vb.villa_id = v.villa_id						 ";$result_villa = dbQuery($sql_villa);//WHERE vb.villa_id = $villa_id//AND vb.villa_id = v.villa_id?><div id="add_afstandvilla"><a href="<?php echo WEB_ROOT_ADMIN; ?>afstandvilla/index.php?view=toevoegen&amp;villa_id=<?php echo $villa_id; ?>">Afstand tot op deze villa toevoegen</a></div><div id="list_afstandvilla"><?phpif (!isset($_GET['villa_id'])){	echo '<h2>Weergeven</h2>' . NEW_LINE;}?><table width="100%" border="1" align="center"><tr><?phpwhile ($row_villa = dbFetchArray($result_villa)){ $arrAll_villas[] = $row_villa; //array_push($arrVilla, $row_villa[0], $row_villa[1], $row_villa[2]);}echo '<pre>'.print_r( $arrAll_villas).'</pre>';//print_r(array_values($arrVilla));foreach($arrAll_villas as $ids){  $arrAll_ids[] = $ids[1];}  // $arrAll_ids heeft nu de voorkomende id's// hierin gooien we alles weg wat niet uniek is// dus 1,1,3,3,3 moet alleen 1,3 van over blijven $arrAll_unique_ids = array_unique($arrAll_ids);  // nu gaan we deze id's gebruiken om in de// db resultaten van net de data te sorteren $output = '';  //print_r($arrAll_unique_ids);exit;//echo $arrAll_villas[2][0];exit; foreach($arrAll_unique_ids as $key=>$table_villa){       $tdrow = '';     $villaname = '';         $villaname = $arrAll_villas[$key][0];          for($i=1;$i<=52;$i++){                          if(!empty($arrAll_villas[$i][3])){                 $tdrow .= '<td>'.$arrAll_villas[$key][3].'</td>';                 }                 else {                 $tdrow .= '<td></td>';                 }              }                   $output = '<table>';     $output .= '<tr><td colspan="20">'.$villaname.'</td></tr>';     $output .= '<tr>'.$tdrow.'</tr>';     $table = $output;     $table .= '</table><br><br>'; //echo 'key= '.$key.'<br>table_villa= '.$table_villa.'<br><br>';} echo $table;/*if (array_key_exists($id, $arrVilla)){echo'<table border=1><tr><td>weeknumber:</td><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td><td>6</td><td>7</td><td>8</td><td>9</td><td>10</td><td>11</td><td>12</td><td>13</td><td>14</td><td>15</td><td>16</td><td>17</td><td>18</td><td>19</td><td>20</td><td>21</td><td>22</td><td>23</td><td>24</td><td>25</td><td>26</td><td>27</td><td>28</td><td>29</td><td>30</td><td>31</td><td>32</td><td>33</td><td>34</td><td>35</td><td>36</td><td>37</td><td>38</td><td>39</td><td>40</td><td>41</td><td>42</td><td>43</td><td>44</td><td>45</td><td>46</td><td>47</td><td>48</td><td>49</td><td>50</td><td>51</td><td>52</td></tr>';	echo '<tr>';	echo '<td>' . $arrVilla[0] . '</td>';	for ($weekId = 1; $weekId <= 52; $weekId++)	{		if ($weekId == $arrVilla[$id])		{			echo '<td>' . $arrVilla[$id] . '</td>';			$id = $id + 3;			if (!array_key_exists($id, $arrVilla))			{				for ($weekId = $weekId; $weekId <= 51; $weekId++)				{					echo '<td>0</td>';				}			}		}		else		{			echo '<td>0</td>';		}	}echo'</tr>';echo'</table>';}else{echo'geen beschikbaarheid aanwezig';}*/?></tr></table></div>