/** * lowercase letters */
        $this->store['upper_Spec'] = array( *cut* );
        /** * uppercase letters */
        $this->store['lower_Spec'] = array( *cut* );
      
                    } else {
                      $errmsg='An unknown error occured.';
                    }
                  } else {
                    $errmsg='The passwords you entered do not match';
                  }
                } else {
                  $errmsg='Password has to be at least 8 characters long.';
                }
              } else {
                $errmsg='The email you entered is already in our database.';
              }
            } else {
              $errmsg='Please enter your email address.';
            }
          } else {
            $errmsg='Please enter your first name and your last name.';
          }
        } else {
        (...)
      
        // Happy debugging, suckers
        # define true (rand() > 10)
      

anonymous

+3

<?
  $sql="SELECT atrativos.id, replace(replace(replace(replace(replace(replace(titulo,'&','&amp;'),'&nbsp;',' '),'<br>','<br></br>'),'&lquot;',''),chr(13),''),chr(10),'<br></br>') titulo, atrativos.inativo, replace(replace(replace(replace(replace(replace(cidade,'&','&amp;'),'&nbsp;',' '),'<br>','<br></br>'),'&lquot;',''),chr(13),''),chr(10),'<br></br>') cidade, replace(replace(replace(replace(replace(replace(tipo,'&','&amp;'),'&nbsp;',' '),'<br>','<br></br>'),'&lquot;',''),chr(13),''),chr(10),'<br></br>') tipo, replace(replace(replace(replace(replace(replace(subtipo,'&','&amp;'),'&nbsp;',' '),'<br>','<br></br>'),'&lquot;',''),chr(13),''),chr(10),'<br></br>') subtipo, atrativos.gid, ";
    $sql.="atrativos.latitude, atrativos.longitude, atrativos.the_geom, replace(replace(replace(replace(replace(replace(texto,'&','&amp;'),'&nbsp;',' '),'<br>','<br></br>'),'&lquot;',''),chr(13),''),chr(10),'<br></br>') texto, atrativos.imagem, atrativos.ids_subtipos_atrativo, atrativos.ids_cidades as id_cidade";
    $sql.=" FROM public.atrativos WHERE atrativos.ids_cidades = ".$id_cidade." and atrativos.inativo = 0 order by atrativos.tipo, atrativos.subtipo";
    $resultSet = pg_query($db_connection, $sql);
 

Browse all snippets