Busca em bd Mysql com link no resultado

Outubro 22, 2008

Sou novo em php e estou com muitas dificuldades para fazer um sistema de busca no bd em que o resultado mostrado contenha link para exibir os dados completos que estão cadastrados.

<?php require_once('Connections/autor.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Recordset1 = 5;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$search_Recordset1 = "*.*";
if (isset($_GET['search'])) {
  $search_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['search'] : addslashes($_GET['search']);
}
mysql_select_db($database_autor, $autor);
$query_Recordset1 = sprintf("SELECT * FROM cadastro WHERE cadastro.nome LIKE '%%%s%%'", $search_Recordset1);
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $autor) 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>Untitled Document</title>
</head>

<body>
<?php if ($totalRows_Recordset1 == 0) { // Show if recordset not empty ?>
Não foram encontrados resultados para sua busca... 
<?php }?>
<?php if ($totalRows_Recordset1 > 0) {?>

  <table width="1145" border="1">
    <tr>
      <td width="122">nome</td>
      <td width="160">responsavel</td>
      <td width="136">telefone</td>
      <td width="128">celular</td>
      <td width="147">descricao</td>
      <td width="127">outros</td>
      <td width="115">data</td>
      <td width="158">autorizacao</td>
    </tr>
    
    <?php do { ?>
      <tr>
        <td><?php echo $row_Recordset1['nome']; ?></td>
        <td><?php echo $row_Recordset1['responsavel']; ?></td>
        <td><?php echo $row_Recordset1['telefone']; ?></td>
        <td><?php echo $row_Recordset1['celular']; ?></td>
        <td><?php echo $row_Recordset1['descricao']; ?></td>
        <td><?php echo $row_Recordset1['outros']; ?></td>
        <td><?php echo $row_Recordset1['data']; ?></td>
        <td><?php echo $row_Recordset1['id']; ?></td>
      </tr>
      <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
      </table>
  <?php } // Show if recordset not empty ?>
  <p align="center">
  <?php if ($totalRows_Recordset1 > 5) { // Show if recordset not empty ?>
    &nbsp;<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>">First</a>    <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>"> Previous</a>
    <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Next</a> &nbsp;<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1); ?>">Last</a>
    <?php } // Show if recordset not empty ?></p>
</body>
</html>

<?php
mysql_free_result($Recordset1);
?>

Entrar

Busca em bd Mysql com link no resultado

Pergunta

Guest --Daniel --

Link para o comentário

Compartilhar em outros sites

0 respostass a esta questão

Posts Recomendados

Participe da discussão

Estatísticas dos Fóruns

Navegação

Atividades