Ledenlijst pagina

YVMdesign

Ik heb een ledenlijst pagina gemaakt.

Heeft iemand nog iets toe te voegen, of een opmerking, alles is welkom.

Ook kritiek is welkom :cheer:

PHP

<?php
include ("includes/config.php");


Login();


echo "<html>
<head>
    <title>Crimini</title>
    <link href=\"static/layout/css/menu.css\" rel=\"stylesheet\" type=\"text/css\">
</head>
<body>";


if ($_GET['sort'] == "alive")
{
    $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='alive'");
}
elseif ($_GET['sort'] == "dead")
{
    $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='dead'");
}
elseif ($_GET['sort'] == "nickname")
{
    $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `nickname` ASC");
}
elseif ($_GET['sort'] == "xp")
{
    $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `xp` ASC");
}
else {
    $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `regtime` ASC");
}


$iRow = mysql_num_rows($sQuery);


if ($iRow == 0)
{
    echo "Geen gebruikers";
}
else
{
    
    echo "<table>
    <tr>
        <td>Nicknaam</td>
        <td>Familie</td>
        <td>Rang</td>
    </tr>";
    
    while($sResult = mysql_fetch_assoc($sQuery))
    {     
        $sQueryUser = mysql_query("SELECT * FROM `Members` WHERE `nickname`='" .$sResult['nickname']. "'");
        $sUser = mysql_fetch_assoc($sQueryUser);
        
        if (empty($sResult['family']))
        {
            $sFamily = "Geen";
        }
        else
        {
            $sQueryFam = mysql_query("SELECT * FROM `Family` WHERE `name`='" .$sResult['family']. "'");
            $sFam = mysql_fetch_assoc($sQueryFam);
            $sFamily = "<a href=\"family-profile.php?id=" .$sFam['id']. "\">" .$sResult['family']. "</a>";
        }
        
        if ($sResult['xp'] < 10)
        {
            $sRang = "Empty-suit";
        }
        elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "male")
        {
            $sRang = "Deliveryboy";
        }
        elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "female")
        {
            $sRang = "Delivery Girl";
        }
        elseif ($sResult['xp'] < 50)
        {
            $sRang = "Picciotto";
        }
        // komen nog meer rangen erbij
        
        $sNickname = "<a href=\"user-profile.php?id=" .$sUser['id']. "\">" .$sResult['nickname']. "</a>";
        
        echo "  <tr>
        <td>" .$sNickname. "</td>
        <td>" .$sFamily. "</td>
        <td>" .$sRang. "</td>
    </tr>";
    }
}


echo "</body>
</html>";


mysql_close();
?>

Toon Meer

cp2

PHP

if ($_GET['sort'] == "alive")
{
    $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='alive'");
}
elseif ($_GET['sort'] == "dead")
{
    $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='dead'");
}
elseif ($_GET['sort'] == "nickname")
{
    $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `nickname` ASC");
}
elseif ($_GET['sort'] == "xp")
{
    $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `xp` ASC");
}
else {
    $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `regtime` ASC");
}

Toon Meer

dit kan toch ook een stuk korter?

bijv

PHP

$sQuery = mysql_query("SELECT * FROM `Members` ORDER BY '".$_GET['sort']."' ASC");

wel even checken natuurlijk of de SORT bestaat,

YVMdesign

Dat kan, maar ik doe het liever zo, dan kan je ook niet een pagina krijgen waarbij je een error krijgt.

Bedankt voor de reactie, wie nog meer.

cp2

ik zeg ook een check inbouwen of die wel in de lijst zit dit kun je d.m.v. een array makkelijk doen

PHP

if (in array($_GET['sort']) { ja hoor je krijgt hem te zien } else { deze pagina bestaat niet }

YVMdesign

Kan ook

Hier een update.

PHP

<?php
include ("includes/config.php");


Login();


echo "<html>
<head>
    <title>Crimini</title>
    <link href=\"static/layout/css/menu.css\" rel=\"stylesheet\" type=\"text/css\">
</head>
<body>";


$sMaxpage = 10;
$sBegin = ($_GET['n'] >= 0) ? $_GET['n'] * $sMaxpage : 0;


if ($_GET['sort'] == "alive")
{
    $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='alive' LIMIT $sBegin, $sMaxpage");
}
elseif ($_GET['sort'] == "dead")
{
    $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='dead' LIMIT $sBegin, $sMaxpage");
}
elseif ($_GET['sort'] == "nickname")
{
    $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `nickname` ASC LIMIT $sBegin, $sMaxpage");
}
elseif ($_GET['sort'] == "xp")
{
    $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `xp` ASC LIMIT $sBegin, $sMaxpage");
}
else {
    $sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `regtime` ASC LIMIT $sBegin, $sMaxpage");
}


$iRow = mysql_num_rows($sQuery);


if ($iRow == 0)
{
    echo "Geen gebruikers";
}
else
{
    
    echo "<table>
    <tr>
        <td>Nicknaam</td>
        <td>Familie</td>
        <td>Rang</td>
    </tr>";
    
    while($sResult = mysql_fetch_assoc($sQuery))
    {     
        $sQueryUser = mysql_query("SELECT * FROM `Members` WHERE `nickname`='" .$sResult['nickname']. "'");
        $sUser = mysql_fetch_assoc($sQueryUser);
        
        if (empty($sResult['family']))
        {
            $sFamily = "Geen";
        }
        else
        {
            $sQueryFam = mysql_query("SELECT * FROM `Family` WHERE `name`='" .$sResult['family']. "'");
            $sFam = mysql_fetch_assoc($sQueryFam);
            $sFamily = "<a href=\"family-profile.php?id=" .$sFam['id']. "\">" .$sResult['family']. "</a>";
        }
        
        if ($sResult['xp'] < 10)
        {
            $sRang = "Empty-suit";
        }
        elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "male")
        {
            $sRang = "Deliveryboy";
        }
        elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "female")
        {
            $sRang = "Delivery Girl";
        }
        elseif ($sResult['xp'] < 50)
        {
            $sRang = "Picciotto";
        }
        // komen nog meer rangen erbij
        
        $sNickname = "<a href=\"user-profile.php?id=" .$sUser['id']. "\">" .$sResult['nickname']. "</a>";
        
        echo "  <tr>
        <td>" .$sNickname. "</td>
        <td>" .$sFamily. "</td>
        <td>" .$sRang. "</td>
    </tr>";
    }
    
    echo "  <tr>
        <td colspan=\"3\">Pagina</td>
        <td colspan=\"3\">";
    
    foreach(range(1, ceil($iRow / $sMaxpage)) AS $i)
    {
        $i--;
        echo "<a href=\"?page=" .$i. "\">" .($i+1). "</a>";
    }
    echo "      </td>
    </tr>";
}


echo "</body>
</html>";


mysql_close();
?>

Toon Meer

cp2

tsja.. eigenwijs? nee valt best mee;)
ik zou het persoonlijk zo doen

PHP

<?php
include ("includes/config.php");


Login();


echo "<html>
<head>
    <title>Crimini</title>
    <link href=\"static/layout/css/menu.css\" rel=\"stylesheet\" type=\"text/css\">
</head>
<body>";
$sortArray = ('alive','dead','nickname','xp','regtime');
if (in_array($_GET['sort'],$sortArray)) 
{ 
$sMaxpage = 10;
$sBegin = ($_GET['n'] >= 0) ? $_GET['n'] * $sMaxpage : 0;




$iRow = mysql_num_rows($sQuery);


if ($iRow == 0)
{
    echo "Geen gebruikers";
}
else
{
    
    echo "<table>
    <tr>
        <td>Nicknaam</td>
        <td>Familie</td>
        <td>Rang</td>
    </tr>";
    
    while($sResult = mysql_fetch_assoc($sQuery))
    {     
        $sQueryUser = mysql_query("SELECT * FROM `Members` WHERE `nickname`='" .$sResult['nickname']. "'");
        $sUser = mysql_fetch_assoc($sQueryUser);
        
        if (empty($sResult['family']))
        {
            $sFamily = "Geen";
        }
        else
        {
            $sQueryFam = mysql_query("SELECT * FROM `Family` WHERE `name`='" .$sResult['family']. "'");
            $sFam = mysql_fetch_assoc($sQueryFam);
            $sFamily = "<a href=\"family-profile.php?id=" .$sFam['id']. "\">" .$sResult['family']. "</a>";
        }
        
        if ($sResult['xp'] < 10)
        {
            $sRang = "Empty-suit";
        }
        elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "male")
        {
            $sRang = "Deliveryboy";
        }
        elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "female")
        {
            $sRang = "Delivery Girl";
        }
        elseif ($sResult['xp'] < 50)
        {
            $sRang = "Picciotto";
        }
        // komen nog meer rangen erbij
        
        $sNickname = "<a href=\"user-profile.php?id=" .$sUser['id']. "\">" .$sResult['nickname']. "</a>";
        
        echo "  <tr>
        <td>" .$sNickname. "</td>
        <td>" .$sFamily. "</td>
        <td>" .$sRang. "</td>
    </tr>";
    }
    
    echo "  <tr>
        <td colspan=\"3\">Pagina</td>
        <td colspan=\"3\">";
    
    foreach(range(1, ceil($iRow / $sMaxpage)) AS $i)
    {
        $i--;
        echo "<a href=\"?page=" .$i. "\">" .($i+1). "</a>";
    }
    echo "      </td>
    </tr>";
}
}
else 
{
echo "deze functie bestaat niet";
}


echo "</body>
</html>";


mysql_close();
?>

Toon Meer

YVMdesign

Waar laat je de query nou?

Zo haalt hij toch geen gegevens uit de db?

cp2

ow iets te ijverig geweest met deleten moment

YVMdesign

Haha ik ken niet werken met array's

Dus je zou het zelf moeten doen

cp2

alstu

PHP

<?php
include ("includes/config.php");


Login();


echo "<html>
<head>
    <title>Crimini</title>
    <link href="static/layout/css/menu.css" rel="stylesheet" type="text/css">
</head>
<body>";
$sortArray = ('alive','dead','nickname','xp','regtime');
if (in_array($_GET['sort'],$sortArray)) 
{ 
$sMaxpage = 10;
$sBegin = ($_GET['n'] >= 0) ? $_GET['n'] * $sMaxpage : 0;




if (isset($_GET['sort'])
{
    $sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='".$_GET['sort']."' LIMIT $sBegin, $sMaxpage");




$iRow = mysql_num_rows($sQuery);


if ($iRow == 0)
{
    echo "Geen gebruikers";
}
else
{
    
    echo "<table>
    <tr>
        <td>Nicknaam</td>
        <td>Familie</td>
        <td>Rang</td>
    </tr>";
    
    while($sResult = mysql_fetch_assoc($sQuery))
    {     
        $sQueryUser = mysql_query("SELECT * FROM `Members` WHERE `nickname`='" .$sResult['nickname']. "'");
        $sUser = mysql_fetch_assoc($sQueryUser);
        
        if (empty($sResult['family']))
        {
            $sFamily = "Geen";
        }
        else
        {
            $sQueryFam = mysql_query("SELECT * FROM `Family` WHERE `name`='" .$sResult['family']. "'");
            $sFam = mysql_fetch_assoc($sQueryFam);
            $sFamily = "<a href="family-profile.php?id=" .$sFam['id']. "">" .$sResult['family']. "</a>";
        }
        
        if ($sResult['xp'] < 10)
        {
            $sRang = "Empty-suit";
        }
        elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "male")
        {
            $sRang = "Deliveryboy";
        }
        elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "female")
        {
            $sRang = "Delivery Girl";
        }
        elseif ($sResult['xp'] < 50)
        {
            $sRang = "Picciotto";
        }
        // komen nog meer rangen erbij
        
        $sNickname = "<a href="user-profile.php?id=" .$sUser['id']. "">" .$sResult['nickname']. "</a>";
        
        echo "  <tr>
        <td>" .$sNickname. "</td>
        <td>" .$sFamily. "</td>
        <td>" .$sRang. "</td>
    </tr>";
    }
    
    echo "  <tr>
        <td colspan="3">Pagina</td>
        <td colspan="3">";
    
    foreach(range(1, ceil($iRow / $sMaxpage)) AS $i)
    {
        $i--;
        echo "<a href="?page=" .$i. "">" .($i+1). "</a>";
    }
    echo "      </td>
    </tr>";
	}
}
}
else 
{
echo "deze functie bestaat niet";
}


echo "</body>
</html>";


mysql_close();
?>

Toon Meer

Nieuwe reactie samengevoegd met originele reactie op 31.01.10 00:36:50:
Ik zou overigens voor die rangen een functie maken ofz... beetje onnodig om die op elke pagina opnieuw aan te vragen..

ICTscripters

Dé plek voor IT

Dé plek voor IT

Beta-testers gezocht voor Crypto-oefenplatform

Na 15 jaar terug van weggeweest: iCriminals.nl is terug (BETA)!

Developer Gezocht

Op zoek naar de legends

[FREE] WeFact Hosting module

Help testers nodig voor android app Urgent

Versio vervanger

Afspraken systeem met planbeperking

350 Nieuwe Domeinnamen Januari 2026

321 Nieuwe Domeinnamen December 2025

Meerdere mafia game template te koop

Ledenlijst pagina

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2