Ledenlijst pagina

YVMdesign · 30 Januari 2010

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 · 30 Januari 2010

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 · 30 Januari 2010

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 · 30 Januari 2010

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 · 30 Januari 2010

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 · 30 Januari 2010

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 · 30 Januari 2010

Waar laat je de query nou?

Zo haalt hij toch geen gegevens uit de db?

cp2 · 30 Januari 2010

ow iets te ijverig geweest met deleten moment

YVMdesign · 30 Januari 2010

Haha ik ken niet werken met array's

Dus je zou het zelf moeten doen

cp2 · 30 Januari 2010

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..

DNS update Directadmin

Graag advies voor mijn website

Ik wil op afstand studeren, kennen jullie Tech?

PC probleem

Let op Vimexx klanten

wie kan mij helpen met Security aanscherpen voor nmijn website

Ik ben op zoek naar een goede hosting

App bouwer gezocht

Dating software

250 Nieuwe domeinnamen April 2024

Xenforo buckaroo plugin

Ledenlijst pagina

Participate now!

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Het Belang van Standaardisatie

De Revolutionaire Rol van IT in Alzheimeronderzoek

Functioneel ontwerp

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

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

Delen