Example #1
0
			<div class="container">
				<div class="row main-row">
					<div class="12u">

<?php 
if (isset($_SESSION["username"])) {
    echo "<h2 style='text-align:center;'>Welcome to your Pokemon Party<br> PokeMaster {$_SESSION["username"]}</h2>";
    $trainer_info = executePlainSQL("SELECT * FROM party WHERE partyid = '{$_SESSION["username"]}'");
    $row = OCI_Fetch_Array($trainer_info, OCI_BOTH);
    $party = explode(",", $row[1]);
    echo "<div class='Pokeguide'>";
    //================LIST OF POKEMON
    for ($i = 0; $i < count($party); $i++) {
        echo "<table>";
        $result = executePlainSQL("SELECT * FROM pokemon WHERE pid = '{$party[$i]}'");
        printPoke($result);
        echo "<td>";
        echo "<form action='deletePoke.php' method='get'>";
        echo "<button name='submit' value='{$party[$i]}'>Remove Pokemon</button></form>";
        echo "</td>";
        echo "</tr>";
        //========================================
    }
    echo "<tr>";
    echo "<td colspan='2'>";
    //DELETE USER BUTTON
    echo "<form action='deleteUser.php'>";
    echo "<button name='delete'>DELETE USER</button></form>";
    echo "</td>";
    echo "</tr>";
    echo "</table>";
Example #2
0
function legendary()
{
    $legendary = executePlainSQL("SELECT pid,tname,picture FROM legendary ");
    //Uses views
    printPoke($legendary);
}