" Dit profiel bestaat niet! "

Gestart doorChristopher4 okt 201014 reacties56 weergaven

15 berichten · pagina 1 van 1

Lid · Topicstarter

Berichten: 7.757
Reputatie: 0
Punten: 0,00

Lid sinds: 2010
Laatst gezien: 12 jun 2025

4 okt 2010, 17:38

Fout: Dit profiel bestaat niet!
Terwijl er de profiel moet staan!
Mijn tabellen zijn: USERS
- ID - USERNAME - EMAIL - ..

Code:

[COLOR= #0000BB]<?[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]settings.php[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/session_is_registered"]session_is_registered[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]memberid[/COLOR][COLOR= #007700])){[/COLOR]
    [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"<a href="#">Niet ingelogd</a>"[/COLOR][COLOR= #007700]);
}[/COLOR]
?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <title>
      IP hone S
    </title>
    <link href="../stijl/stijl.css" rel="stylesheet" type="text/css" />
  </head>
  <body>

  <div class="menu">
         &nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;<a href="advstats.php" class="link">Beginpagina</a>&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;<a href="productt.php" class="link">Product toevoegen</a>&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;
      <a href="pm.php" class="link">Privberichten</a>&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="nieuwsbrief.php" class="link">Nieuwsbrief versturen</a>&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="index3.php" class="link">Eerder toegevoegde Producten</a>nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;<a href="profiel.php" class="link">Mijn Profiel</a>&&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="uitloggen.php" class="link">Uitloggen</a>
    </div>
    <div class="border"></div>
    <div class="gradient">
      <div class="container">

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"settings.php"[/COLOR][COLOR= #007700]);[/COLOR]
                                
            [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users  WHERE id = "[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" LIMIT 1"[/COLOR][COLOR= #007700])[/COLOR]or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
            [COLOR= #0000BB]$sql_aantal[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_aantal[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Dit profiel bestaat niet![/COLOR][COLOR= #007700];
            }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700])){[/COLOR]
            ?>
           <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
           <tr>
           <td width="100%" align="center" bgcolor="#00BFFF"><font color="white">Profiel:</font></td>
           </tr>
           </table>
           <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
           <tr>
           <td><b>Gebruikersnaam:</b></font></td>
           <td><?=htmlspecialchars($show[gebruikersnaam])?></td>
           </tr>
           <tr>
           <td><b>Naam:</b></font></td>
           <td><?=htmlspecialchars($show[naam])?></td>
           </tr>
           <tr>
           <td><b>E-mail:</b></font></td>
           <td><?=htmlspecialchars($show[email])?></td>
           </tr>
           <tr>
           <td><b>Status:</b></font></td>
           <td>
            [COLOR= #0000BB]<?[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<FONT COLOR="#FF0000">[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Verbannen<br />[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]</FONT>[/COLOR][COLOR= #007700];
            }[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<FONT COLOR="#000000">[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Normaal Lid<br />[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]</FONT>[/COLOR][COLOR= #007700];
            }[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<FONT COLOR="#3399FF">[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Admin<br />[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]</FONT>[/COLOR][COLOR= #007700];
            }[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700]){


    }[/COLOR]
           [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]</td>[/COLOR][COLOR= #007700];[/COLOR]
           ?>
         <tr>
         <td><b>Avatar:</b></font></td>
         <td>
         <img src="plaatjes/<?=$show[avatar]?>" sm:iepng="true" />
         </td>
         </tr>
         </table>
         <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
         <tr>
         <td width="80%" align="left">
         <table>
         <tr>
         <td>
         [COLOR= #0000BB]<?[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]){[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<img src="img/instel.png" sm:iepng="true" />
         <a href="index.php?p=profiel&wijzigen=profiel" class="content">Profiel Wijzigen</a><br />[/COLOR][COLOR= #007700];
         }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]])){[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<img src="img/rechts.png" sm:iepng="true" />
         <a href="index.php?p=leden&actie=aanmelden" class="content">Meld je nu ook aan op Ridderwar!</a><br />[/COLOR][COLOR= #007700];
         }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<img src="img/rechts.png" sm:iepng="true" />
         <a href="index.php?p=pm_sturen&naam=[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" class="content">Stuur een PM naar [/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]</a><br />[/COLOR][COLOR= #007700];
         }[/COLOR]
         ?>
         </td>
         </tr>
         </table>
         </tr>
         </table>
           [COLOR= #0000BB]<?[/COLOR]
        [COLOR= #007700]}
    }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]wijzigen[/COLOR][COLOR= #007700]]) && ([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]wijzigen[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]profiel[/COLOR][COLOR= #007700])){
          function[/COLOR] email_validator[COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/eregi"]eregi[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\.[a-z]{2,4}$"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700]))
               {[/COLOR][COLOR= #0000BB]$geldig[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]ja[/COLOR][COLOR= #007700];   }[/COLOR]
           [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR][COLOR= #0000BB]$geldig[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]nee[/COLOR][COLOR= #007700];}[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$geldig[/COLOR][COLOR= #007700];
        }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR] [COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REQUEST_METHOD[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]POST[/COLOR][COLOR= #007700]){[/COLOR]
         [COLOR= #0000BB]$naam[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]];[/COLOR]
         [COLOR= #0000BB]$email[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]];[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$naam[/COLOR][COLOR= #007700])){[/COLOR]
         [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR][COLOR= #DD0000]Je moet wel een naam invullen![/COLOR][COLOR= #007700];
         }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700])){[/COLOR]
         [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR][COLOR= #DD0000]"Je moet wel een E-mail adres opgeven"[/COLOR][COLOR= #007700];
         }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR]email_validator[COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #DD0000]nee[/COLOR][COLOR= #007700]){[/COLOR]
         [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Het ingevulde emailadres is niet geldig<br />"[/COLOR][COLOR= #007700];
         }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$error[/COLOR][COLOR= #007700])){[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<h2>Er is een fout opgetreden</h2>"[/COLOR][COLOR= #007700];[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<p>"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"</p>"[/COLOR][COLOR= #007700];
         }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
         [COLOR= #0000BB]$wijzigen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET naam = "[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$naam[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]", email = "[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR]
         or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
         [URL="http://www.php.net/header"]header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: index.php?p=profiel&id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]log_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);
         }
         }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
          [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
           <tr>
           <td width="100%" align="center" bgcolor="#00BFFF"><font color="white">Profielwijzigen:</font></td>
           </tr>
           </table>[/COLOR][COLOR= #007700];[/COLOR]
         [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]log_id[/COLOR][COLOR= #007700]])) {[/COLOR]
        [COLOR= #0000BB]$ophalen[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM leden WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]log_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$verzenden[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$ophalen[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$verzenden[/COLOR][COLOR= #007700])){[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"<form action= method=POST>
        <table>
        <tr>
        <td>Gebruikersnaam:</td>
        <td><input type=test value="[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" READONLY></td>
        </tr>
        <tr>
        <td>Naam:</td>
        <td><input type=text name=naam value="[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" maxlength=30></td>
        </tr>
        <tr>
        <td>E-mail:</td>
        <td><input type=text name=email value="[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" maxlength=30></td>
        </tr>
        <tr>
        <td><input name=submit value=Wijzigen type=submit></td>
        </tr>
        </table>"[/COLOR][COLOR= #007700];
        }
    }
  }
}[/COLOR]    
?>

     </div>
    </div>
  </body>
</html>

Reins

Lid

Berichten: 14.363
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 12 jun 2025

4 okt 2010, 17:44

Huh, dus je wilt gewoon "Dit" in "De" veranderen?
Anders begrijp ik je niet..

Regel 32..

echoDit profiel bestaat niet!;

Christopher

Lid · Topicstarter

Berichten: 7.757
Reputatie: 0
Punten: 0,00

Lid sinds: 2010
Laatst gezien: 12 jun 2025

4 okt 2010, 17:46

Er moet een profiel staan gewoon avatar enz..
Niet de tekst lol kan ik ook

Jeffreyy

Lid

Berichten: 6.144
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 16 jul 2024

4 okt 2010, 18:00

[COLOR= #0000BB]<?[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]settings.php[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/session_is_registered"]session_is_registered[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]memberid[/COLOR][COLOR= #007700])){[/COLOR]
    [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"<a href="#">Niet ingelogd</a>"[/COLOR][COLOR= #007700]);
}[/COLOR]
?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <title>
      IP hone S
    </title>
    <link href="../stijl/stijl.css" rel="stylesheet" type="text/css" />
  </head>
  <body>

  <div class="menu">
         &nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;<a href="advstats.php" class="link">Beginpagina</a>&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;<a href="productt.php" class="link">Product toevoegen</a>&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;
      <a href="pm.php" class="link">Privberichten</a>&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="nieuwsbrief.php" class="link">Nieuwsbrief versturen</a>&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="index3.php" class="link">Eerder toegevoegde Producten</a>nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;<a href="profiel.php" class="link">Mijn Profiel</a>&&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="uitloggen.php" class="link">Uitloggen</a>
    </div>
    <div class="border"></div>
    <div class="gradient">
      <div class="container">

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"settings.php"[/COLOR][COLOR= #007700]);[/COLOR]
                                
            [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users  WHERE id = "[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" LIMIT 1"[/COLOR][COLOR= #007700])[/COLOR]or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
            [COLOR= #0000BB]$sql_aantal[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_aantal[/COLOR] [COLOR= #007700]===[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Dit profiel bestaat niet![/COLOR][COLOR= #007700];
            }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700])){[/COLOR]
            ?>
           <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
           <tr>
           <td width="100%" align="center" bgcolor="#00BFFF"><font color="white">Profiel:</font></td>
           </tr>
           </table>
           <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
           <tr>
           <td><b>Gebruikersnaam:</b></font></td>
           <td><?=htmlspecialchars($show[gebruikersnaam])?></td>
           </tr>
           <tr>
           <td><b>Naam:</b></font></td>
           <td><?=htmlspecialchars($show[naam])?></td>
           </tr>
           <tr>
           <td><b>E-mail:</b></font></td>
           <td><?=htmlspecialchars($show[email])?></td>
           </tr>
           <tr>
           <td><b>Status:</b></font></td>
           <td>
            [COLOR= #0000BB]<?[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<FONT COLOR="#FF0000">[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Verbannen<br />[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]</FONT>[/COLOR][COLOR= #007700];
            }[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<FONT COLOR="#000000">[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Normaal Lid<br />[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]</FONT>[/COLOR][COLOR= #007700];
            }[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<FONT COLOR="#3399FF">[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Admin<br />[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]</FONT>[/COLOR][COLOR= #007700];
            }[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700]){


    }[/COLOR]
           [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]</td>[/COLOR][COLOR= #007700];[/COLOR]
           ?>
         <tr>
         <td><b>Avatar:</b></font></td>
         <td>
         <img src="plaatjes/<?=$show[avatar]?>" sm:iepng="true" />
         </td>
         </tr>
         </table>
         <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
         <tr>
         <td width="80%" align="left">
         <table>
         <tr>
         <td>
         [COLOR= #0000BB]<?[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]){[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<img src="img/instel.png" sm:iepng="true" />
         <a href="index.php?p=profiel&wijzigen=profiel" class="content">Profiel Wijzigen</a><br />[/COLOR][COLOR= #007700];
         }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]])){[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<img src="img/rechts.png" sm:iepng="true" />
         <a href="index.php?p=leden&actie=aanmelden" class="content">Meld je nu ook aan op Ridderwar!</a><br />[/COLOR][COLOR= #007700];
         }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<img src="img/rechts.png" sm:iepng="true" />
         <a href="index.php?p=pm_sturen&naam=[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" class="content">Stuur een PM naar [/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]</a><br />[/COLOR][COLOR= #007700];
         }[/COLOR]
         ?>
         </td>
         </tr>
         </table>
         </tr>
         </table>
           [COLOR= #0000BB]<?[/COLOR]
        [COLOR= #007700]}
    }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]wijzigen[/COLOR][COLOR= #007700]]) && ([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]wijzigen[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]profiel[/COLOR][COLOR= #007700])){
          function[/COLOR] email_validator[COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/eregi"]eregi[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*.[a-z]{2,4}$"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700]))
               {[/COLOR][COLOR= #0000BB]$geldig[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]ja[/COLOR][COLOR= #007700];   }[/COLOR]
           [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR][COLOR= #0000BB]$geldig[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]nee[/COLOR][COLOR= #007700];}[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$geldig[/COLOR][COLOR= #007700];
        }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR] [COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REQUEST_METHOD[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]POST[/COLOR][COLOR= #007700]){[/COLOR]
         [COLOR= #0000BB]$naam[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]];[/COLOR]
         [COLOR= #0000BB]$email[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]];[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$naam[/COLOR][COLOR= #007700])){[/COLOR]
         [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR][COLOR= #DD0000]Je moet wel een naam invullen![/COLOR][COLOR= #007700];
         }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700])){[/COLOR]
         [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR][COLOR= #DD0000]"Je moet wel een E-mail adres opgeven"[/COLOR][COLOR= #007700];
         }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR]email_validator[COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #DD0000]nee[/COLOR][COLOR= #007700]){[/COLOR]
         [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Het ingevulde emailadres is niet geldig<br />"[/COLOR][COLOR= #007700];
         }[/COLOR]
         [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$error[/COLOR][COLOR= #007700])){[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<h2>Er is een fout opgetreden</h2>"[/COLOR][COLOR= #007700];[/COLOR]
         [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<p>"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"</p>"[/COLOR][COLOR= #007700];
         }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
         [COLOR= #0000BB]$wijzigen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET naam = "[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$naam[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]", email = "[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR]
         or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
         [URL="http://www.php.net/header"]header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: index.php?p=profiel&id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]log_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);
         }
         }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
          [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
           <tr>
           <td width="100%" align="center" bgcolor="#00BFFF"><font color="white">Profielwijzigen:</font></td>
           </tr>
           </table>[/COLOR][COLOR= #007700];[/COLOR]
         [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]log_id[/COLOR][COLOR= #007700]])) {[/COLOR]
        [COLOR= #0000BB]$ophalen[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM leden WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]log_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$verzenden[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$ophalen[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$verzenden[/COLOR][COLOR= #007700])){[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"<form action= method=POST>
        <table>
        <tr>
        <td>Gebruikersnaam:</td>
        <td><input type=test value="[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" READONLY></td>
        </tr>
        <tr>
        <td>Naam:</td>
        <td><input type=text name=naam value="[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" maxlength=30></td>
        </tr>
        <tr>
        <td>E-mail:</td>
        <td><input type=text name=email value="[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$show[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" maxlength=30></td>
        </tr>
        <tr>
        <td><input name=submit value=Wijzigen type=submit></td>
        </tr>
        </table>"[/COLOR][COLOR= #007700];
        }
    }
  }
}[/COLOR]    
?>

     </div>
    </div>
  </body>
</html>

Geen idee of dit werkt, maar volgens mij moest het === zijn ipv ==.

One2xs

Bot

Berichten: 93.699
Reputatie: 0
Punten: 1,27

Lid sinds: 2025
Laatst gezien: 29 jun 2025

4 okt 2010, 19:28

settings is denk config?

Waarom 2 keer includen?

Sjoerd

Lid

Berichten: 13.482
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 20 okt 2025

4 okt 2010, 19:30

verander

$sql = mysql_query("SELECT * FROM users  WHERE id = ".htmlspecialchars($_GET[user])." LIMIT 1")or die(mysql_error());

$sql = mysql_query("SELECT * FROM users  WHERE naam= ".htmlspecialchars($_GET[user])." LIMIT 1")or die(mysql_error());

Simon

Lid

Berichten: 262
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 12 jun 2025

4 okt 2010, 20:29

dit moet zekker een stukje zijn van jouw IPS??

1.dan eerste advies. maak van 2. als * in query opvraagt wordt de query trager van als je grootte database gebruikt.
daar voor kun je better volledige qeury uit typen

Christopher

Lid · Topicstarter

Berichten: 7.757
Reputatie: 0
Punten: 0,00

Lid sinds: 2010
Laatst gezien: 12 jun 2025

4 okt 2010, 20:30

Sjoerd schreef:
verander

$sql = mysql_query("SELECT * FROM users  WHERE id = ".htmlspecialchars($_GET[user])." LIMIT 1")or die(mysql_error());

$sql = mysql_query("SELECT * FROM users  WHERE naam= ".htmlspecialchars($_GET[user])." LIMIT 1")or die(mysql_error());

Unknown column naam in where clause

Jeffreyy

Lid

Berichten: 6.144
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 16 jul 2024

4 okt 2010, 20:34

$sql = mysql_query("SELECT * FROM users  WHERE id = ".htmlspecialchars($_GET[user])." LIMIT 1")or die(mysql_error());

$sql = mysql_query("SELECT * FROM users  WHERE username= ".htmlspecialchars($_GET[user])." LIMIT 1")or die(mysql_error());

Heb even naam in username veranderd, nu hoort ie te werken.

Simon

Lid

Berichten: 262
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 12 jun 2025

4 okt 2010, 20:35

#10

Simon schreef:
dit moet zekker een stukje zijn van jouw IPS??

1.dan eerste advies. maak van 2. als * in query opvraagt wordt de query trager van als je grootte database gebruikt.
daar voor kun je better volledige qeury uit typen

$user = htmlspecialchars($_GET[user])                 
$sql = mysql_query("SELECT * FROM users  WHERE id = ".$user." LIMIT 1")or die(mysql_error());

Christopher

Lid · Topicstarter

Berichten: 7.757
Reputatie: 0
Punten: 0,00

Lid sinds: 2010
Laatst gezien: 12 jun 2025

5 okt 2010, 15:13

#11

Er is door simon nu een hele fout Namelijk: Parse error: syntax error, unexpected T_VARIABLE in /home/thomlamp/domains/projecta.one2xs.com/public_html/adverteerders/profiel.php on line 28

edit; $user = htmlspecialchars($_GET[user]) weggehaald, staat echt voor niks?

Sjoerd

Lid

Berichten: 13.482
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 20 okt 2025

5 okt 2010, 16:56

#12

Iphone schreef:

Eerdere citaten tonen

Sjoerd schreef:
verander

$sql = mysql_query("SELECT * FROM users  WHERE id = ".htmlspecialchars($_GET[user])." LIMIT 1")or die(mysql_error());

$sql = mysql_query("SELECT * FROM users  WHERE naam= ".htmlspecialchars($_GET[user])." LIMIT 1")or die(mysql_error());

Unknown column naam in where clause

dan is dat zeker een combi van 10 gejatte scripts die niet goed in elkaar gezet is zeker? want later gebruik je $show[naam], en als naam niet in die tabel staat, kan $show[naam] ook niet bestaan

Christopher

Lid · Topicstarter

Berichten: 7.757
Reputatie: 0
Punten: 0,00

Lid sinds: 2010
Laatst gezien: 12 jun 2025

5 okt 2010, 17:02

#13

Nope niet gejat..
Maar omdat het tabellen werk in het nederlands iri is dan in engels, heb ik besloten van gebruikersnaam users enzovoort te maken

Climax

Lid

Berichten: 289
Reputatie: 0
Punten: 0,00

Lid sinds: 2010
Laatst gezien: 12 jun 2025

6 okt 2010, 14:12

#14

Dat zou ik dus ook kunnen vertellen, maar dit script is zwz gejat en die layout is ook gejat. Dus hoe kan je bewijzen dat het script echt van jou is ^^? Ik heb toevallig het systeem gekocht op die ene site waar die (zogenaamde) layout van jou komt, qua coding is alles precies hetzelfde? Hé, iPhone of kan ik beter zeggen iPhone 2G

Christopher

Lid · Topicstarter

Berichten: 7.757
Reputatie: 0
Punten: 0,00

Lid sinds: 2010
Laatst gezien: 12 jun 2025

6 okt 2010, 19:27

#15

Layout is niet gejat. En is gratis,
Ten tweede precies hetzelfde? Laat is zien..
En bewijs het aub.. Want als jij zo stoer doet moeten we ook bewijs

Oja en lol, spreek ik tegen een kleuter? CliNUL
Wees niet jaloers het is niet mijn schuld dat je de iphone 2G niet kan kopen LOL.

Dit topic mag dicht als je verdere bewijs hebt hoor ik het graag

edit: lolled en er praat een onbeschofte kut kind van 16 jaar tegen een ouder persoon.
Ik weet niet in welke familie jij bent opgevoed maar het is nog ergen dan mongolië..

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.