Can someone help me add a search function to this?

[TG SH4RPY]

What im trying to do it, as you can see on this code http://www.pastie.org/879737 there is a table on the bottom, i want to add a search feature, so i can search for a members name or search a status, and it will fetch it from that table, can anyone help me out? ive been trying the last few days but cant get it going.

[inversesoft123]

Infection to this site http://safeweb.norton.com/report/show?url=pastie.org

 

Moderators should block this thread

[TG SH4RPY]

there shouldnt be... all i did was went on pastie.org and copied and pasted the code

[TG SH4RPY]

Ill just copy the code into here:

 

<?php

 

if ( ! defined( 'IN_IPB' ) )

 

{

 

print "<h1>Incorrect access</h1>You cannot access this file directly. If you have recently upgraded, make sure you upgraded 'admin.php'.";

 

exit();

 

}

 

//All reports run inside the load_options ATS Form - don't setup any others unless your intention is to run outside of the ATS wrapper and security

 

class ats_mod

 

{

 

var $ipsclass; //store the IPB super class object for use

 

var $funct; //load the common functions object (had to be an object so we can pass it to other class objects later)

 

 

 

function run_me()

 

{

 

$query_where = "d_name LIKE '%'";

 

$id_remember = "";

 

if ($this->ipsclass->input['show'] != Null)

 

{

 

$g_showa = explode(" ", $this->ipsclass->input['show']);

 

 

 

$id_remember = "&show=" . $this->ipsclass->input['show'];

 

$query_where = "";

 

$show_count = count($g_showa);

 

foreach ($g_showa as $key => $value)

 

{

 

$query_where .= "d_id = $value";

 

if ($show_count > 1)

 

{

 

$query_where .= " OR ";

 

}

 

$show_count--;

 

}

 

 

 

}

 

switch ($this->ipsclass->input['sort'])

 

{

 

case 'name' :

 

$sort_string = "d_name ASC, d_date ASC";

 

break;

 

case 'date' :

 

$sort_string = "d_date DESC, d_name ASC";

 

break;

 

case 'ip' :

 

$sort_string = "d_ip ASC, d_name ASC";

 

break;

 

case 'type' :

 

default :

 

$sort_string = "d_status ASC, d_name ASC";

 

break;

 

}

 

 

 

$this->ipsclass->DB->simple_construct( array( 'select' => '*',

 

'from'  => 'members_discharges',

 

'where' => $query_where,

 

'order'  => $sort_string ));

 

$this->ipsclass->DB->simple_exec();

 

 

 

print ("<TABLE BORDER CELLPADDING=4>

 

<TR ALIGN=CENTER VALIGN=TOP>

 

<TH ALIGN=CENTER VALIGN=TOP COLSPAN='7'>{$this->funct->board_name} Discharges and Rejected Validations</TH>

 

</TR>

 

<TR ALIGN=CENTER VALIGN=TOP>

 

<TH><a href='http://{$this->funct->board_site}/index.php?autocom=ats&code=wrapper&ats=run_option&atsmodule={$this->mod_number}&sort=type$id_remember'>Type</a></TH>

 

<TH><a href='http://{$this->funct->board_site}/index.php?autocom=ats&code=wrapper&ats=run_option&atsmodule={$this->mod_number}&sort=name$id_remember'>Member Name</a></TH>

 

<TH><a href='http://{$this->funct->board_site}/index.php?autocom=ats&code=wrapper&ats=run_option&atsmodule={$this->mod_number}&sort=ip$id_remember'>IP Address</a></TH>

 

<TH>Other Known Names</TH>

 

<TH NOWRAP><a href='http://{$this->funct->board_site}/index.php?autocom=ats&code=wrapper&ats=run_option&atsmodule={$this->mod_number}&sort=date$id_remember'>Discharge Date</a></TH>

 

<TH>Reason(s)</TH>

 

<TH>Comments/Details</TH>

 

</TR>

 

");

 

 

 

 

 

while ( $r = $this->ipsclass->DB->fetch_row() )

 

{

 

$ddate = date("Y-m-d", $r['d_date']);

 

$onames = implode(",<BR>\n",explode(",", $r['d_other_names']));

 

$reason = implode(",<BR>\n",explode(",", $r['d_reason']));

 

if ($r['d_bday_year'] != NULL)

 

{

 

$reason .= "<BR>\nBirthday:<BR>\n" . $r['d_bday_year'] . "-" . $r['d_bday_month'] . "-" . $r['d_bday_day'];

 

}

 

$comments = str_replace(array("\r\n", "\n", "\r"), "<br />", $r['d_comments']);

 

 

 

print ("<tr>

 

<td>{$r['d_status']}</td>

 

<td>{$r['d_name']}</td>

 

<td>{$r['d_ip']}</td>

 

<td>{$onames}</td>

 

<td>{$ddate}</td>

 

<td>{$reason}</td>

 

<td>{$comments}</td>

 

</tr>

 

");

 

}

 

print("</table>");

 

}

 

}

 

?>