login  Naam:   Wachtwoord: 
Registreer je!
 Forum

Id selecteren?

Offline tomk - 12/07/2005 09:49
Avatar van tomkASP interesse Beste mensen,

Ik heb een vraag. Kijk ik heb dit: http://www.carriere-manager.nl/top15.php . Als je dan op een team klikt moet hij info van dat team weergeven. MAar hij geeft dan van alle team weer. dit zijn de scripts:

top15.php
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?
  4. include("functies.php");
  5.  
  6. $var = "iedereen";
  7. $toegang = beveiliging($var);
  8. $ban = ban();
  9.  
  10. if(!$toegang == 0) {
  11. 	if(!$ban == 1) {
  12. ?>
  13. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  14. <html>
  15. <head>
  16. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  17. <title>Carriere-Manager :: Top 15</title>
  18. </head>
  19.  
  20. <body>
  21. <font size="2"><strong>Top 15 teams</strong></font> 
  22. <table width="336" cellspacing="0" cellpadding="0">
  23.   <tr>
  24.     <td width="36"><font size="2"><strong>Land</strong></font></td>
  25.     <td width="133"><font size="2"><strong>Naam</strong></font></td>
  26.     <td width="100"><font size="2"><strong>Punten
  27.       <?
  28. $tp_sql = "SELECT id, clubnaam, punten, land FROM leden ORDER BY punten DESC LIMIT 15";
  29. $tp_res = mysql_query($tp_sql);
  30.  
  31. while($tp = mysql_fetch_assoc($tp_res)) {
  32. ?>
  33.       </strong></font></td>
  34.     <td width="65"><font size="2"><strong> </strong></font></td>
  35.   </tr>
  36. </table>
  37. <table width="334" height="18" cellpadding="0" cellspacing="0">
  38.   <tr> 
  39.     <td width="36"><strong><font size="2"><strong><img src="<? echo $tp['land']; ?>" alt="image" name="button" width="18" height="12" /></strong></font> 
  40.       </strong></td>
  41.     <td width="132"><font size="2"><strong><a href="team.php?teamnr=<? echo $tp['id']; ?>"><? echo $tp['clubnaam']; ?></strong></font></td>
  42.     <td width="99"><font size="2"><strong><? echo $tp['punten']; ?>
  43.       <?
  44. }
  45. ?>
  46.       </strong></font></td>
  47.     <td width="65"><font size="2"><strong> </strong></font></td>
  48.   </tr>
  49. </table>
  50. <p>&nbsp; </p>
  51. <p>&nbsp;</p><p>&nbsp;</p></body>
  52. </html>
  53. <?
  54. 	} else {
  55. 		$sql = "SELECT * FROM ban WHERE ip='".$_SERVER['REMOTE_ADDR']."'";
  56. 		$res = mysql_query($sql);
  57. 		$fet = mysql_fetch_assoc($res);
  58. 		$mes = $fet['mes'];
  59. 		echo $mes;
  60. 	}
  61. } else {
  62. echo "U bent niet bevoegd om deze pagina te bekijken";
  63. }
  65. ?>


team.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?
  4. include("functies.php");
  5.  
  6. $var = "iedereen";
  7. $toegang = beveiliging($var);
  8. $ban = ban();
  9.  
  10. if(!$toegang == 0) {
  11. 	if(!$ban == 1) {
  12. ?>
  13. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  14. <html>
  15. <head>
  16. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  17. <title>Carriere-Manager :: Team <? echo $tp['clubnaam']; ?></title>
  18. </head>
  19.  
  20. <body>
  21. <p><font size="2"><strong>
  22.   <?
  23. $tp_sql = "SELECT  id, clubnaam, land FROM leden";
  24. $tp_res = mysql_query($tp_sql);
  25.  
  26. while($tp = mysql_fetch_assoc($tp_res)) {
  27. ?>
  28.   </strong></font></p>
  29. <table width="329" height="70" cellpadding="0" cellspacing="0">
  30.   <tr>
  31.     <td width="43"><strong><font size="2"> Team:</font></strong></td>
  32.     <td width="24"><strong><font size="2"><strong><img src="<? echo $tp['land']; ?>" alt="image" name="button" width="18" height="12" /> 
  33.       </strong></font></strong></td>
  34.     <td width="175"><strong><? echo $tp['clubnaam']; ?></strong></td>
  35.     <td width="85">&nbsp;</td>
  36.   </tr>
  37.   <tr>
  38.     <td>&nbsp;</td>
  39.     <td>&nbsp;</td>
  40.     <td>&nbsp;</td>
  41.     <td>&nbsp;</td>
  42.   </tr>
  43.   <tr>
  44.     <td><strong><font size="2">Spelers:</font></strong></td>
  45.     <td>&nbsp;</td>
  46.     <td><font size="2"><strong>Dit team heeft nog geen spelers
  47.       <?
  48. }
  49. ?>
  50.       </strong></font></td>
  51.     <td>&nbsp;</td>
  52.   </tr>
  53. </table>
  54. <p>&nbsp;</p>
  55. <p>&nbsp;</p></body>
  56. </html>
  57. <?
  58. 	} else {
  59. 		$sql = "SELECT * FROM ban WHERE ip='".$_SERVER['REMOTE_ADDR']."'";
  60. 		$res = mysql_query($sql);
  61. 		$fet = mysql_fetch_assoc($res);
  62. 		$mes = $fet['mes'];
  63. 		echo $mes;
  64. 	}
  65. } else {
  66. echo "U bent niet bevoegd om deze pagina te bekijken";
  67. }
  69. ?>


Bedankt voor de hulp:cool:

5 antwoorden

Gesponsorde links
Offline MechaVore - 12/07/2005 10:06 (laatste wijziging 12/07/2005 10:07)
Avatar van MechaVore Gouden medaille

PHP gevorderde
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?
  2. $tp_sql = "SELECT  id, clubnaam, land FROM leden WHERE id='".(is_numeric($_GET['teamnr'])) ? $_GET['teamnr'] : ""."'";
  3. ?>
Offline tomk - 12/07/2005 10:10
Avatar van tomk ASP interesse Nu krijg ik een error:'( . Deze error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/carriere-manager.nl/www/team.php on line 27


Hier script met dat erin:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?
  4. include("functies.php");
  5.  
  6. $var = "iedereen";
  7. $toegang = beveiliging($var);
  8. $ban = ban();
  9.  
  10. if(!$toegang == 0) {
  11. 	if(!$ban == 1) {
  12. ?>
  13. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  14. <html>
  15. <head>
  16. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  17. <title>Carriere-Manager :: Team <? echo $tp['clubnaam']; ?></title>
  18. </head>
  19.  
  20. <body>
  21. <p><font size="2"><strong>
  22.   <?
  23. $tp_sql = "SELECT id, clubnaam, land FROM leden WHERE
  24. id='".(is_numeric($_GET['teamnr'])) ? $_GET['teamnr'] : ""."'";
  25. $tp_res = mysql_query($tp_sql);
  26. while($tp = mysql_fetch_assoc($tp_res)) {
  27. ?>
  28.   </strong></font></p>
  29. <table width="329" height="70" cellpadding="0" cellspacing="0">
  30.   <tr>
  31.     <td width="43"><strong><font size="2"> Team:</font></strong></td>
  32.     <td width="24"><strong><font size="2"><strong><img src="<? echo $tp['land']; ?>" alt="image" name="button" width="18" height="12" /> 
  33.       </strong></font></strong></td>
  34.     <td width="175"><strong><? echo $tp['clubnaam']; ?></strong></td>
  35.     <td width="85">&nbsp;</td>
  36.   </tr>
  37.   <tr>
  38.     <td>&nbsp;</td>
  39.     <td>&nbsp;</td>
  40.     <td>&nbsp;</td>
  41.     <td>&nbsp;</td>
  42.   </tr>
  43.   <tr>
  44.     <td><strong><font size="2">Spelers:</font></strong></td>
  45.     <td>&nbsp;</td>
  46.     <td><font size="2"><strong>Dit team heeft nog geen spelers
  47.       <?
  48. }
  49. ?>
  50.       </strong></font></td>
  51.     <td>&nbsp;</td>
  52.   </tr>
  53. </table>
  54. <p>&nbsp;</p>
  55. <p>&nbsp;</p></body>
  56. </html>
  57. <?
  58. 	} else {
  59. 		$sql = "SELECT * FROM ban WHERE ip='".$_SERVER['REMOTE_ADDR']."'";
  60. 		$res = mysql_query($sql);
  61. 		$fet = mysql_fetch_assoc($res);
  62. 		$mes = $fet['mes'];
  63. 		echo $mes;
  64. 	}
  65. } else {
  66. echo "U bent niet bevoegd om deze pagina te bekijken";
  67. }
  69. ?>
Offline MechaVore - 12/07/2005 10:12
Avatar van MechaVore Gouden medaille

PHP gevorderde
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?
  2. $tp_sql = "SELECT id, clubnaam, land FROM leden WHERE
  3. id='".$_GET['teamnr']."'";
  4. ?>

Dit moet je nog wel beveiligen, maar probeer het zo is.
Offline tomk - 12/07/2005 10:16
Avatar van tomk ASP interesse Bedankt^^ Nu werkt hij wel:D. Echt bedankt(#kusje)
Offline MechaVore - 12/07/2005 10:18
Avatar van MechaVore Gouden medaille

PHP gevorderde		 graag gedaan, maar ik zal het toch ff beveiligen, zet gewoon ff if(is_numeric($_GET['teamnr'])){
erbij
Gesponsorde links
Dit onderwerp is gesloten.
Actieve forumberichten
© 2002-2025 Sitemasters.be - Regels - Laadtijd: 0.213s