StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUndefined index PHP placing at host
text
Body
copied!<p>I have to make a site for school. It need to be linked with a database. On <code>localhost</code> everything is ok and works, but when I tried to upload it on the host of the school, I get this error: </p> <blockquote> <p>Notice: Undefined index: vragen in /mnt/studentenhomes/arnaud.gandibleux/public_html/datamanagement/index.php on line 44</p> </blockquote> <p>I can't find the solution</p> <p>index.php</p> <pre><code><div id="tekst"> <table align='center'> <?php //if (isset($_GET['vragen'])){ if ($_GET['vragen'] === 'Alleclubs') { getclubs(); } elseif ($_GET['vragen'] === 'ledenvjf') { getVJFleden(); echo "test"; } elseif ($_GET['vragen'] === 'ledenffbj') { getFFBJleden(); } elseif (isset($_GET['clubnr'])) { getLedenPerClubEnID($_GET['clubnr']); } else{ getclubs(); } // } ?> </table> </code></pre> <p>Crud.php</p> <pre><code> function getVJFleden() { global $mysqli; $result = $mysqli->query("SELECT * FROM Leden l JOIN Clubs c ON l.clubnr = c.clubnr join Bonden b ON b.ID_bond = c.ID_bond LEFT JOIN adressen a ON a.ID_adress = l.ID_adress WHERE b.naam_bond = 'VJF';"); if ($result) { if ($result->num_rows > 0) { echo"<caption>Alle leden VJF</caption>"; echo "<th>Voornaam</th><th>achternaam</th><th>leeftijd</th><th>Kye</th><th>adress</th>"; while ($leden = $result->fetch_object()) { echo "<tr><td>$leden->lid_voornaam</td> "; echo "<td>" . $leden->lid_achternaam . "</td> "; echo "<td>" . $leden->lid_leeftijd . "</td> "; echo "<td>" . $leden->kye . "</td> "; echo "<td>" . $leden->straatnaam . " " . $leden->huisnummer . " " . $leden->postcode . " " . $leden->gemeente . "</td> "; echo "<td><form id='update' action='update.php' method='POST'> <input type='hidden' name='id' value='" . $leden->ID_lid . "'/> <input type='hidden' name='clubnr' value='" . $_GET['clubnr'] . "'/> <input type='image' src='update.png' alt='Update' width='22' height='22'> </form> <form id='delete' action='deleteLid.php' method='POST'> <input type='hidden' name='id' value='" . $leden->ID_lid . "'/> <input type='image' src='delete.png' alt='detele' width='22' height='22'> </form></td> "; } } } $mysqli->close(); } function getFFBJleden() { global $mysqli; #, Adressen a #AND l.ID_adress = a.ID_adress $result = $mysqli->query("SELECT * FROM Leden l JOIN Clubs c ON l.clubnr = c.clubnr join Bonden b ON b.ID_bond = c.ID_bond LEFT JOIN adressen a ON a.ID_adress = l.ID_adress WHERE b.naam_bond = 'FFBJ';"); if ($result) { if ($result->num_rows > 0) { echo"<caption>Alle leden VJF</caption>"; echo "<th>Voornaam</th><th>achternaam</th><th>leeftijd</th><th>Kye</th><th>adress</th>"; while ($leden = $result->fetch_object()) { echo "<tr><td>$leden->lid_voornaam</td> "; echo "<td>" . $leden->lid_achternaam . "</td> "; echo "<td>" . $leden->lid_leeftijd . "</td> "; echo "<td>" . $leden->kye . "</td> "; echo "<td>" . $leden->straatnaam . " " . $leden->huisnummer . " " . $leden->postcode . " " . $leden->gemeente . "</td> "; echo "<td><form id='update' action='update.php' method='POST'> <input type='hidden' name='id' value='" . $leden->ID_lid . "'/> <input type='hidden' name='clubnr' value='" . $_GET['clubnr'] . "'/> <input type='image' src='update.png' alt='Update' width='22' height='22'> </form> <form id='delete' action='deleteLid.php' method='POST'> <input type='hidden' name='id' value='" . $leden->ID_lid . "'/> <input type='image' src='delete.png' alt='detele' width='22' height='22'> </form></td> "; } } } $mysqli->close(); } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload