Need help with functions

Hi guys. Need some help with some functions. I'm using a table that lists all the records in my db table but i did a search form and i have been told that for me to do what i want i would have to call one function while i search and one while i list all records. I will show the full code of the page where the two functions are:

Expand|Select|Wrap|Line Numbers

 <?php

include_once("dbconfig.php");

?>

<?php

$output = '';
 
if(isset($_POST['search'])) {

        $searchq = $_POST['search'];

        $searchq = preg_replace("#[^0-9a-z]#i","",$searchq);
 
        $query = mysql_query("SELECT * FROM tbl_ficheiros WHERE id_ficheiro LIKE '%$searchq%' OR ficheiro LIKE '%$searchq%'") or die("Erro na procura...");

        $count = mysql_num_rows($query);

        if($count == 0){

            $output = 'Sem resultados na procura...';

        }else{

            while($row = mysql_fetch_array($query)) {

                $idficheiro = $row['id_ficheiro'];

                $nficheiro = $row['ficheiro'];

                $id = $row['id_ficheiro'];
 
                $output .= '<div>ID = '.$idficheiro.' // nome = '.$nficheiro.'</div>';

            }

        }

    }

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"

  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" >

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

<head>

    <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />

    <title>Lista de Relatórios</title>

<link rel="stylesheet" type="text/css" media="screen" href="style.css" />

<style type="text/css">

#container #intro #pageHeader h1 {

    color: #CC0000;

    font-size: 2em;

}

#container #intro #pageHeader h1 {

    font-size: 4em;

    color: #666666;

}

#body form p label {

    color: #666666;

}

body table tr th {

    color: #FFFFFF;

}

body table tr td {

    color: #FFFFFF;

}

</style>

</head>

<body>

<br/><h1>Lista de Relatórios</h1><br/>

  <form id="frm_lista" method="post">

  <div align="center">

  <table width="40%" border="1">

    <tr>

      <td width="15%">Ficheiro</td>

      <td width="12%">Tipo</td>

      <td width="19%">Tamanho(KB)</td>

      <td width="20%">Ver</td>

<?php 

    $sql="SELECT * FROM tbl_ficheiros";

    $result_set=mysql_query($sql);

    while($row=mysql_fetch_array($result_set))

    {

        ?>

  </tr>
 
    <tr>

      <td><?php echo $row['ficheiro'] ?></td>

      <td><?php echo $row['tipo'] ?></td>

      <td><?php echo $row['tamanho'] ?></td>

      <td><a href="uploads/<?php echo $row['ficheiro'] ?>" target="_blank">Ver Ficheiros</a></td>

  </tr>

    <?php

    }

    ?>

   }

</table>
 
  </div>
 
  <form action="search_teste.php" method="post">

      <input type="text" name="search" placeholder="Nome do Relatório..." />

    <input type="submit" class="btn" value=">>"  />

  </form>
 
  <?php print("$output");?>
 
  <p>&nbsp;</p>

  <p><a href="novo_relatorio.php">

  <input align="middle" name="btn_novo" type="submit" class="btn" id="button" value="Novo Relatório" />

  </a></p>

<p><a href="relatorios.php"><input align="middle" name="btn_voltar" type="submit" class="btn" id="button" value="Voltar" /></a></p>

</body>

</html>

This is the full code. Now as you see on top i have a search by filter, in this case by file name (ficheiro) and ID (id_ficheiro). And a bit below i have one that show all records. I need to wrap this into two different functions. One that runs while no search has been done and one that is called if some search has been made. Anyone can help? Any more info or detail needed just ask. Thanks in advance ;)

Jun 29 '15 #1

Subscribe Post Reply

1345

Bharat383

You can change your code like as below :

Expand|Select|Wrap|Line Numbers

 
if(isset($_POST['search'])) {

        $searchq = $_POST['search'];

        $searchq = preg_replace("#[^0-9a-z]#i","",$searchq);

        $query = mysql_query("SELECT * FROM tbl_ficheiros WHERE id_ficheiro LIKE '%$searchq%' OR ficheiro LIKE '%$searchq%'") or die("Erro na procura...");

    }else{

      $query = mysql_query("SELECT * FROM tbl_ficheiros WHERE id_ficheiro") or die("Erro na procura...");

    }
 
      $count = mysql_num_rows($query);

      if($count == 0){

          $output = 'Sem resultados na procura...';

      }else{

          while($row = mysql_fetch_array($query)) {

              $idficheiro = $row['id_ficheiro'];

              $nficheiro = $row['ficheiro'];

              $id = $row['id_ficheiro'];
 
              $output .= '<div>ID = '.$idficheiro.' // nome = '.$nficheiro.'</div>';

          }

      }

Jul 7 '15 #2

Similar topics

Working with functions

by: dx27s | last post by:

I want a function to take another function as a parameter, and execute it as a line of code. I put a simplified example below, just to illustrate the idea. Does anyone know the syntax to do this,...

Javascript

Returning recordsets with functions

by: Robert Fitzpatrick | last post by:

Can someone point me to some more information or perhaps show an example of returning a recordset from a plpgsql function. I'd like to send an argument or arguments to the function, do some queries...

PostgreSQL Database

economizing with functions that do the same thing

by: Your Uncle | last post by:

About a month ago, Heathfield posted the peudosource for random permuting from TAOCP. It was all of maybe five lines. You needed to be able to do two things: be able to get a random number in a...

C / C++

Need Help with Functions

by: swtstrawberry | last post by:

here are the directions and below the direction is what I have so far. I need help with (B) the bisect function. I've only posted part of my program, if more information is needed please let me...

C / C++

C2666 error with functions/c'tors taking variable parameters

by: John Shell | last post by:

Hello, all. The following code results in a C2666 error (2 overloads have similar conversions). class FSVec2D { public: FSVec2D() { // code omitted }

.NET Framework

Is there a real need to use keyword static with functions?

by: lcdgoncalves | last post by:

Hi everyone Is there a real need to use keyword static with functions, if we simply don't declare their prototypes in .h file? Many textbooks avoid to discuss this matter and/or discuss only...

C / C++

using delegates with functions

by: =?Utf-8?B?LnBhdWwu?= | last post by:

i'm using this method with subs + it works well, but with functions, they don't return a value. what am i doing wrong? Private Delegate Function listview_items_countCallback() As Integer ...

.NET Framework

Implementing multithreading with functions having parameters

by: Anish G | last post by:

Hi, I am new to working on threading. I need to implement multithreading for calling four functions (each functions are having parameters) in different threads so that i can improve the...

.NET Framework

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++