Tema: Problemas con $_GET
Ver Mensaje Individual
  #1 (permalink)  
Antiguo 06/08/2012, 13:54
WinderJerter
 
Fecha de Ingreso: agosto-2009
Mensajes: 292
Antigüedad: 14 años, 8 meses
Puntos: 5
Problemas con $_GET
Hola que tal, lo que pasa es que estoy utilizando el $_GET, para que, dependiendo de los valores del $_GET muestre distinto contenido y lo estoy haciendo de la siguiente manera

Código PHP: 
Ver original
  1. <?php
  2.  
  3. $sql_select_folders_public = "SELECT f_NAME FROM FOLDERS WHERE IUID = '".$_SESSION['iuid']."'";
  4. $result_sql_select_folders_public = mysql_query($sql_select_folders_public);
  5. $images_folder_public = mysql_fetch_assoc($result_sql_select_folders_public);
  6.  
  7. if($_GET['index'] == "images" && $_GET['folder'] == "public" && $_GET['set'] == $images_folder_public['F_NAME']) {
  8.     
  9.     //MOSTRAR IMAGENES DENTRO DE CARPETAS PUBLICAS
  10.     $winderjester = "SELECT * FROM IMAGES I INNER JOIN THUMBNAILS T ON I.ID = T.ID INNER JOIN FOLDERS F ON I.ID_FOLDER = F.ID_FOLDER WHERE F.F_NAME = '".$images_folder_public['F_NAME']."' AND F.PARENT = 'PUBLIC' AND I.IUID = '".$_SESSION['iuid']."'";
  11.     $result_winderjester = mysql_query($winderjester);
  12.     
  13.     while($hjtm = mysql_fetch_assoc($result_winderjester)) {
  14.         echo '<div class="more-upload">'."\n";
  15.         echo '<div class="options-thumbnails">'."\n";
  16.         echo '<a href="http://web.com/preview.php?id='.$hjtm['ID'].'" target="_blank"><div class="options-preview"></div></a>'."\n";
  17.         echo '<a href="#"><div class="options-share"></div></a>'."\n";
  18.         echo '<a href="http://web.com/web/functions/private.php?id='.$hjtm['ID'].'"><div class="options-private"></div></a>'."\n";
  19.         echo '<a href="http://web.com/web/functions/delete.php?id='.$hjtm['ID'].'&pin='.$hjtm['PIN'].'"><div class="options-delete"></div></a>'."\n";
  20.         echo '</div>'."\n";
  21.         echo '<div class="thumbnail"><img src="'.$hjtm['SQUARE_75'].'" height="75" width="75"></div>'."\n";
  22.         echo '</div>'."\n\n";
  23.     }
  24. } 
  25.  
  26. elseif($_GET['index'] == "images" && $_GET['folder'] == "private" && $_GET['set'] == $images_folder_public['F_NAME']) {
  27.     
  28.     //MOSTRAR IMAGENES DENTRO DE CARPETAS PRIVADAS
  29.     $winderjester2 = "SELECT * FROM IMAGES I INNER JOIN THUMBNAILS T ON I.ID = T.ID INNER JOIN FOLDERS F ON I.ID_FOLDER = F.ID_FOLDER WHERE F.F_NAME = '".$images_folder_public['F_NAME']."' AND F.PARENT = 'PRIVATE' AND I.IUID = '".$_SESSION['iuid']."'";
  30.     $result_winderjester2 = mysql_query($winderjester2);
  31.     
  32.     while($hjtm2 = mysql_fetch_assoc($result_winderjester2)) {
  33.         echo '<div class="more-upload">'."\n";
  34.         echo '<div class="options-thumbnails">'."\n";
  35.         echo '<a href="http://web.com/preview.php?id='.$hjtm2['ID'].'" target="_blank"><div class="options-preview"></div></a>'."\n";
  36.         echo '<a href="#"><div class="options-share"></div></a>'."\n";
  37.         echo '<a href="http://web.com/web/functions/private.php?id='.$hjtm2['ID'].'"><div class="options-private"></div></a>'."\n";
  38.         echo '<a href="http://web.com/web/functions/delete.php?id='.$hjtm2['ID'].'&pin='.$hjtm2['PIN'].'"><div class="options-delete"></div></a>'."\n";
  39.         echo '</div>'."\n";
  40.         echo '<div class="thumbnail"><img src="'.$hjtm2['SQUARE_75'].'" height="75" width="75"></div>'."\n";
  41.         echo '</div>'."\n\n";
  42.     }
  43. }
  44.  
  45. elseif($_GET['index'] == "images" && $_GET['folder'] == "private") {
  46.     
  47.     //MOSTRAR CARPETAS PRIVADAS
  48.     $sql_folders_private = "SELECT * FROM FOLDERS WHERE IUID = '".$_SESSION['iuid']."' AND PARENT = 'PRIVATE'";
  49.     $result_sql_folders_private = mysql_query($sql_folders_private);
  50.     
  51.     while($folder_private = mysql_fetch_assoc($result_sql_folders_private)) {
  52.         if(strlen($folder_private['F_NAME']) > 10) {
  53.             $name_folder_private = substr($folder_private['F_NAME'], 0, 7)."...";
  54.         } else {
  55.             $name_folder_private = $folder_private['F_NAME'];
  56.         }
  57.         
  58.         echo '<div class="more-upload" style="padding-top: 0; padding-bottom: 0; height: 103px;padding: 0;width: 103px;text-align: center;">'."\n";
  59.         echo '<a href="?index=images&folder='.$folder_private['F_NAME'].'" title="'.$folder_private['F_NAME'].'">'."\n";
  60.         echo '<img src="images/folder.png" height="75" width="75">'."\n";
  61.         echo '<div style="text-align: center; line-height: 0;font-size: 12px;">'.$name_folder_private.'</div>'."\n";
  62.         echo '</a>'."\n";
  63.         echo '</div>'."\n\n";
  64.     }
  65.     
  66.     //MOSTRAR IMAGENES PRIVADAS
  67.     $sql_private = "SELECT * FROM IMAGES I INNER JOIN THUMBNAILS T ON I.ID = T.ID WHERE IUID = '".$_SESSION['iuid']."' AND I.ID IN(SELECT * FROM PRIVATE) ORDER BY DATE DESC";
  68.     $result_private = mysql_query($sql_private);
  69.     
  70.     while($private = mysql_fetch_assoc($result_private)) {
  71.         echo "<div class=\"more-upload\"><a href=\"http://web.com/preview.php?id=".$private['ID']."\"><img src=\"".$private['SQUARE_75']."\" height=\"75\" width=\"75\"></a></div>\n";
  72.     }
  73. }
  74.  
  75. elseif($_GET['index'] == "images") {
  76.     $sql_more = "SELECT * FROM IMAGES I INNER JOIN THUMBNAILS T ON I.ID = T.ID WHERE IUID = '".$_SESSION['iuid']."' AND ID_FOLDER = '' AND I.ID NOT IN(SELECT * FROM PRIVATE) ORDER BY ".$row_pref['SORT_BY']." + 0 ".$row_pref['ORDER_BY']."";
  77.     $result_more = mysql_query($sql_more);
  78.     
  79.     //MOSTRAR ENLACE CARPETA PRIVADA
  80.     echo '<div class="more-upload" style="padding-top: 0; padding-bottom: 0; height: 103px;padding: 0;width: 103px;text-align: center;">'."\n";
  81.     echo '<a href="?index=images&folder=private" title="Private">'."\n";
  82.     echo '<img src="images/private-folder.png" height="75" width="75">'."\n";
  83.     echo '<div style="text-align: center; line-height: 0;font-size: 12px;">Private</div>'."\n";
  84.     echo '</a>'."\n";
  85.     echo '</div>'."\n\n";
  86.     
  87.     //MOSTRAR CARPETAS PUBLICAS
  88.     $sql_folders_public = "SELECT * FROM FOLDERS WHERE IUID = '".$_SESSION['iuid']."' AND PARENT = 'PUBLIC'";
  89.     $result_sql_folders_public = mysql_query($sql_folders_public);
  90.     
  91.     while($folder_public = mysql_fetch_assoc($result_sql_folders_public)) {
  92.         if(strlen($folder_public['F_NAME']) > 10) {
  93.             $name_folder_public = substr($folder_public['F_NAME'], 0, 7)."...";
  94.         } else {
  95.             $name_folder_public = $folder_public['F_NAME'];
  96.         }
  97.         
  98.         echo '<div class="more-upload" style="padding-top: 0; padding-bottom: 0; height: 103px;padding: 0;width: 103px;text-align: center;">'."\n";
  99.         echo '<a href="?index=images&folder=public&set='.$folder_public['F_NAME'].'" title="'.$folder_public['F_NAME'].'">'."\n";
  100.         echo '<img src="images/folder.png" height="75" width="75">'."\n";
  101.         echo '<div style="text-align: center; line-height: 0;font-size: 12px;">'.$name_folder_public.'</div>'."\n";
  102.         echo '</a>'."\n";
  103.         echo '</div>'."\n\n";
  104.     }
  105.     
  106.     //MOSTRAR IMAGENES PUBLICAS
  107.     while($more = mysql_fetch_assoc($result_more)) {
  108.         echo '<div class="more-upload">'."\n";
  109.         echo '<div class="options-thumbnails">'."\n";
  110.         echo '<a href="http://web.com/preview.php?id='.$more['ID'].'" target="_blank"><div class="options-preview"></div></a>'."\n";
  111.         echo '<a href="#"><div class="options-share"></div></a>'."\n";
  112.         echo '<a href="http://web.com/web/functions/private.php?id='.$more['ID'].'"><div class="options-private"></div></a>'."\n";
  113.         echo '<a href="http://web.com/web/functions/delete.php?id='.$more['ID'].'&pin='.$more['PIN'].'"><div class="options-delete"></div></a>'."\n";
  114.         echo '</div>'."\n";
  115.         echo '<div class="thumbnail"><img src="'.$more['SQUARE_75'].'" height="75" width="75"></div>'."\n";
  116.         echo '</div>'."\n\n";
  117.     }
  118. }
  119.  
  120. ?>

El código funciona a la mitad porque muestra todas las imágenes y las carpetas publicas y también las carpetas e imágenes privadas, y si se accede a la primera carpeta publica creada muestra las imágenes de esa carpeta, pero si se quiere ver las demás carpetas publicas muestra todas las imágenes y carpetas publicas creadas.

Alguien que me puede ayudar a resolver este problema?

Saludos y gracias de antemano