All pastes #73234 Raw Edit

Unnamed

public php v1 · immutable
#73234 ·published 2006-06-27 16:27 UTC
rendered paste body
<?php if (!isset($_POST['cboVilla'])){        $villa_id = $_GET['villa_id'];}else{        $villa_id = $_POST['cboVilla'];} // selecteer villa uit de database$sql_villa =    "SELECT v.villa_naam,                                                        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><?php $arrVilla = array(); while ($row_villa = dbFetchArray($result_villa)){ array_push($arrVilla, $row_villa[0], $row_villa[1], $row_villa[2]);} print_r(array_values($arrVilla)); $id = 2; 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> <?php/*output:Array ( [0] => Villa Hortensias [1] => 1 [2] => 5 [3] => Villa Hortensias [4] => 1 [5] => 42 [6] => Villa Costa [7] => 1 [8] => 8 [9] => Villa Costa [10] => 1 [11] => 12 [12] => Villa Costa [13] => 1 [14] => 20 [15] => Villa Costa [16] => 1 [17] => 51 )  weeknumber: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 Villa Hortensias 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 42 0 0 0 0 0 0 0 0 0 0  */?>