Formulario de order by

oscarios · #1 (**permalink**) 23/10/2010, 15:26

hola a todos buenas tardes, acudo a ustedes en este caso, tengo una pagina en php que muestra unos registros mysql ahi todo bien, arriba puse un formulario orderby para seleccionar por que campos ordenar la consulta pero no me ha querido funcionar,,,,,les muestro el codigo a ver si me pueden dar una manito, MIL GRACIAS

Código PHP:

Ver original<?php require_once('Connections/conbanca.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$currentPage = $_SERVER["PHP_SELF"];
 
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
 
$colname_Recordset1 = "-1";
if (isset($_GET['busca'])) {
  $colname_Recordset1 = $_GET['busca'];
}
$colname2_Recordset1 = "-1";
if (isset($_GET['busca2'])) {
  $colname2_Recordset1 = $_GET['busca2'];
}
$colname3_Recordset1 = "-1";
if (isset($_GET['busca3'])) {
  $colname3_Recordset1 = $_GET['busca3'];
}
$colname4_Recordset1 = "-1";
if (isset($_GET['campo'])) {
  $colname4_Recordset1 = $_GET['campo'];
}
$colname5_Recordset1 = "-1";
if (isset($_GET['orden'])) {
  $colname5_Recordset1 = $_GET['orden'];
}
mysql_select_db($database_conbanca, $conbanca);
$query_Recordset1 = sprintf("SELECT * FROM inmuebles WHERE ciudad LIKE %s AND zona LIKE %s AND tipo LIKE %s ORDER BY %s  %s", GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname2_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname3_Recordset1 . "%", "text"),GetSQLValueString($colname4_Recordset1, "text"),GetSQLValueString($colname5_Recordset1, "text"));
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $conbanca) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
 
if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
 
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Documento sin t&iacute;tulo</title>
</head>
 
<body>
<table width="90%" border="0" cellspacing="0" cellpadding="2">
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
      <tr>
        <td> Registros <?php echo ($startRow_Recordset1 + 1) ?> a <?php echo min($startRow_Recordset1 + $maxRows_Recordset1, $totalRows_Recordset1) ?> de <?php echo $totalRows_Recordset1 ?></td>
        <td><form id="form1" name="form1" method="get" action="result2b.php">
          <select name="campo" id="campo">
            <option value="barrio">Seleccione un campo</option>
            <option value="barrio">Barrio</option>
            <option value="valor">Valor</option>
            <option value="area">Area</option>
            <option value="habitaciones">Habitaciones</option>
            <option value="codigo_inm">Codigo</option>
          </select>
          <select name="orden" id="orden" method="get">
            <option value="ASC" selected="selected">Orden</option>
            <option value="ASC">Ascendente</option>
            <option value="DESC">Descendente</option>
          </select>
          <input name="busca" type="hidden" id="busca" value="<?php echo $row_Recordset1['ciudad']; ?>" />
          <input name="busca2" type="hidden" id="busca2" value="<?php echo $row_Recordset1['zona']; ?>" />
          <input name="busca3" type="hidden" id="busca3" value="<?php echo $row_Recordset1['tipo']; ?>" />
          <label for="button"></label>
          <input type="submit" name="button" id="button" value="Enviar" />
        </form></td>
        <td><table border="0">
          <tr>
            <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
                <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>"><img src="First.gif" border="0" /></a>
                <?php } // Show if not first page ?></td>
            <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
                <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>"><img src="Previous.gif" border="0" /></a>
                <?php } // Show if not first page ?></td>
            <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
                <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>"><img src="Next.gif" border="0" /></a>
                <?php } // Show if not last page ?></td>
            <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
                <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1); ?>"><img src="Last.gif" border="0" /></a>
                <?php } // Show if not last page ?></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><?php do { ?>
        <table width="100%" border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td rowspan="3"><img src="photos/<?php echo $row_Recordset1['foto_a']; ?>" width="150" height="112" /></td>
            <td align="center">Barrio</td>
            <td align="center">Valor Venta</td>
            <td align="center">Area</td>
            <td align="center">Habit.</td>
            <td align="center">Codigo</td>
            <td rowspan="3">&nbsp;</td>
          </tr>
          <tr>
            <td align="center"><?php echo $row_Recordset1['barrio']; ?></td>
            <td align="center"><?php echo $row_Recordset1['valor']; ?></td>
            <td align="center"><?php echo $row_Recordset1['area']; ?></td>
            <td align="center"><?php echo $row_Recordset1['habitaciones']; ?></td>
            <td align="center"><?php echo $row_Recordset1['codigo_inm']; ?></td>
          </tr>
          <tr>
            <td colspan="5"><?php echo $row_Recordset1['masinfo']; ?></td>
          </tr>
        </table>
        <br />
        <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></td>
  </tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

repara2 · #2 (**permalink**) 24/10/2010, 11:48

Hola oscarios, no te funciona porque la sentencia order by no se ejecuta nunca, el problema está aquí:

Código PHP:

  $query_Recordset1 = sprintf("SELECT * FROM inmuebles WHERE ciudad LIKE %s AND zona LIKE %s AND tipo LIKE %s ORDER BY %s  %s", GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname2_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname3_Recordset1 . "%", "text"),GetSQLValueString($colname4_Recordset1, "text"),GetSQLValueString($colname5_Recordset1, "text"));

En este punto la función GetSQLValueString() no funciona. Es una función de Dreamweaver al igual que la aplicación que estás adaptando. Sobre esa función puedes leer aquí:

http://www.forosdelweb.com/f17/funci...weaver-446588/

El código casi ilegible, te recomiendo que lo reescribas más fácil y más depurable, lo que quieres se puede resolver en 20 líneas de código.
Si no logras la solución postea más codigo para ver qué pasa, saludos

oscarios · #3 (**permalink**) 25/10/2010, 07:00

ok repara2 entiendo, pero sigo sin saber solucionar mi problema, como vez el codigo es dreamweaver yo no lo hice porque casi no se de php. agradezco tu colavoracion.

oscarios · #4 (**permalink**) 26/10/2010, 16:55

YA ME FUNCIONAAAAA,,,,,,,,,,,pero si organizo campo1 ascendente ,,,,,perfecto y si de una le doy campo1 descendente no lo hace, tengo que organizar por otro campo para poder volver, osea no me organiza por el mismo campo dos veces seguidas..... les muestro el codigo,,,,,agradesco sus comentarios

oscarios · #5 (**permalink**) 26/10/2010, 16:57

PARTE 1

Código PHP:

Ver original<?php
if(!isset($_GET['field'])){
 $_GET['field']='Id';
}
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }
  if(!isset($_GET['field'])){
 $_GET['field']='Id';
}
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }
  
if(!isset($_GET['field'])){
 $_GET['field']='Id';
}
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$currentPage = $_SERVER["PHP_SELF"];
 
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
 
$colname_Recordset1 = "-1";
if (isset($_GET['busca'])) {
  $colname_Recordset1 = $_GET['busca'];
}
$colpara_Recordset1 = "-1";
if (isset($_GET['busca2'])) {
  $colpara_Recordset1 = $_GET['busca2'];
}
$coltype_Recordset1 = "-1";
if (isset($_GET['busca3'])) {
  $coltype_Recordset1 = $_GET['busca3'];
}
mysql_select_db($database_conbanca, $conbanca);
$query_Recordset1 = sprintf("SELECT * FROM inmuebles WHERE ciudad LIKE %s AND zona LIKE %s AND tipo LIKE %s order by ".$_GET['field']." ".$_GET['order'], GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colpara_Recordset1 . "%", "text"),GetSQLValueString("%" . $coltype_Recordset1 . "%", "text"));
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $conbanca) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
 
if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
 
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>

oscarios · #6 (**permalink**) 26/10/2010, 16:58

PARTE 2

Código PHP:

Ver original<!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>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Documento sin t&iacute;tulo</title>
</head>
 
<body>
<table width="90%" border="0" cellspacing="0" cellpadding="2">
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
      <tr>
        <td><img src="imgs/tit_busque.jpg" width="218" height="33" /></td>
        <td colspan="2" align="right"><span class="textoN">Usted encontr&oacute;&nbsp;</span><span class="encabN"><?php echo $totalRows_Recordset1 ?>&nbsp;&nbsp;<?php echo $row_Recordset1['tipo']; ?></span></td>
        </tr>
      <tr>
        <td> Registros <?php echo ($startRow_Recordset1 + 1) ?> a <?php echo min($startRow_Recordset1 + $maxRows_Recordset1, $totalRows_Recordset1) ?> de <?php echo $totalRows_Recordset1 ?><br />
          <a href="javascript:history.back(1)"><img src="imgs/volver.png" width="94" height="19" border="0" /></a></td>
        <td><form id="form1" name="form1" method="get" action="result2b.php">
          <select name="field" id="field">
            <option value="barrio">Seleccione un campo</option>
            <option value="barrio">Barrio</option>
            <option value="valor">Valor</option>
            <option value="area">Area</option>
            <option value="habitaciones">Habitaciones</option>
            <option value="codigo_inm">Codigo</option>
          </select>
          <select name="orden" id="orden" method="get">
            <option value="ASC" selected="selected">Orden</option>
            <option value="ASC">Ascendente</option>
            <option value="DESC">Descendente</option>
          </select>
          <input name="busca" type="hidden" id="busca" value="<?php echo $row_Recordset1['ciudad']; ?>" />
          <input name="busca2" type="hidden" id="busca2" value="<?php echo $row_Recordset1['zona']; ?>" />
          <input name="busca3" type="hidden" id="busca3" value="<?php echo $row_Recordset1['tipo']; ?>" />
          <label for="button"></label>
          <input type="submit" name="button" id="button" value="Enviar" />
        </form></td>
        <td><table border="0">
          <tr>
            <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
                <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>"><img src="First.gif" border="0" /></a>
                <?php } // Show if not first page ?></td>
            <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
                <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>"><img src="Previous.gif" border="0" /></a>
                <?php } // Show if not first page ?></td>
            <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
                <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>"><img src="Next.gif" border="0" /></a>
                <?php } // Show if not last page ?></td>
            <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
                <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1); ?>"><img src="Last.gif" border="0" /></a>
                <?php } // Show if not last page ?></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><?php do { ?>
        <table width="100%" border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td width="192" rowspan="3"><a href="result3.php?id=<?php echo $row_Recordset1['id']; ?>"><img src="photos/<?php echo $row_Recordset1['foto_a']; ?>" width="150" height="112" /></a></td>
            <td width="126" align="center" nowrap="nowrap">Barrio</td>
            <td width="157" align="center" nowrap="nowrap">Valor Venta</td>
            <td width="101" align="center" nowrap="nowrap">Area</td>
            <td width="72" align="center" nowrap="nowrap">Habit.</td>
            <td width="86" align="center" nowrap="nowrap">Codigo</td>
            <td width="120" rowspan="3"><a href="result3.php?id=<?php echo $row_Recordset1['id']; ?>"><img src="imgs/ingresar.png" width="100" height="25" border="0" /></a></td>
          </tr>
          <tr>
            <td align="center"><?php echo $row_Recordset1['barrio']; ?></td>
            <td align="center">$ <?php echo number_format($row_Recordset1['valor']); ?></td>
            <td align="center"><?php echo $row_Recordset1['area']; ?></td>
            <td align="center"><?php echo $row_Recordset1['habitaciones']; ?></td>
            <td align="center"><?php echo $row_Recordset1['codigo_inm']; ?></td>
          </tr>
          <tr>
            <td colspan="5"><?php echo $row_Recordset1['masinfo']; ?></td>
          </tr>
        </table>
        <br />
        <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></td>
  </tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>