Building a search function?? :: Zikula Community

sunadmn [17]

Rank: Helper

Registered: 07.10.04

last visit: 27.06.09

Posts: 436
[18] Posted: 11.01.2005, 16:48

Hey all I have my module just about done now ( all the standard functions work ) and now I need to add a search function to the pnuser & pnuserapi.php files and I am not quite sure how to do it, so I was wondering if you all could give me some pointers on the matter. Here is what I have built thus far:

pnuser.php search function:

Code
function pnDiagram_user_search()
{

if (!pnSecAuthAction(0, 'pnDiagram::', '::', ACCESS_OVERVIEW)) {
return pnVarPrepHTMLDisplay(_MODULENOAUTH);
}

$pnRender =& new pnRender('pnDiagram');

$pnRender->caching = false;

return $pnRender->fetch('pnDiagram_user_search.htm');

}

The above is called to from a link in the users menu.

this is what I have in my template file now:

Code


<br /><br />
<div class="pn-title"></div>
<br /><br />
<form action="" method="post" enctype="application/x-www-form-urlencoded">
<div>
<input type="hidden" name="authid" value="" />
<input type="hidden" name="tid" value="" />
<table border="1" cellpadding="5" cellspacing="1"><tbody>
<tr>
<td><label for="pnDiagram_name"></label></td>
<td><input id="pnDiagram_name" name="itemname" type="text" size="32" maxlength="32" /></td>
</tr>
<tr>
<td><label for="pnDiagram_site_type"></label></td>
<td><select name="Tsite" size="1" tabindex="3"><option value=""></option><option value="Master Headend">Master Headend</option><option value="Hub">Hub</option><option value="CoLocation">CoLocation</option><option value="Central Office">Central Office</option><option value="Aggregation Point">Aggregation Point</option></select></td>
</tr>
<tr>
<td><label for="pnDiagram_city"></label></td>
<td><input id="pnDiagram_city" name="city" type="text" size="32" maxlength="32" /></td>
</tr>
<tr>
<td><label for="pnDiagram_state"></label></td>
<td><input id="pnDiagram_state" name="state" type="text" size="32" maxlength="32" /></td>
</tr>
<tr>
<td><label for="pnDiagram_technology"></label></td>
<td><label><input type="radio" name="tech1" value="PowerLink">PowerLink</label></td>
</tr>
<tr>
<td><label for="pnDiagram_technology"></label></td>
<td><label><input type="radio" name="tech2" value="Digital TV">Digital TV</label></td>
</tr>
<tr>
<td><label for="pnDiagram_technology"></label></td>
<td><label><input type="radio" name="tech3" value="Video on Demand">Video on Demand</label></td>
</tr>
<tr>
<td><label for="pnDiagram_status"></label></td>
<td><select name="status" size="1" tabindex="13"><option value=""></option><option value="Verified">Verified</option><option value="Unverified">Unverified</option><option value="Proposed">Proposed</option><option value="Acquisition">Acquisition</option></select></td>
</tr>
<tr>
<td><label for="pnDiagram_diagram"></label></td>
<td><select name="diagram" size="1" tabindex="11"><option value=""></option><option value="Port">Port</option><option value="Rack">Rack</option><option value="Vlan">Vlan</option><option value="Connectivity">Connectivity</option><option value="Overview">Overview</option></select></td>
</tr>
<tr>
<td><label for="pnDiagram_author"></label></td>
<td><input id="pnDiagram_author" name="author" type="text" size="32" maxlength="32" /></td>
</tr>
<tr>
<td><label for="pnDiagram_category"></label></td>
<td><select name="category" size="1" tabindex="11"><option value=""></option><option value="NorthEast">NorthEast</option><option value="SouthEast">SouthEast</option><option value="SoutherCal">SoutherCal</option><option value="Western">Western</option><option value="Central">Central</option></select></td>
</tr>
</table>
<input name="submit" type="submit" value="" />
</div>
</form>

Now from this file I will call to a pnuser.php query function to run the API function to do the search, this is where I am having a bit of trouble I am not 100% sure what this function should look like since the Example module doesn't have a search function and every module I have loaded on my system does not make use of the pnrender engine.

Any pointers anyone could provide would be awesome.

Thanks
-SUNADMN
[21]

[22]
sunadmn [24]

Rank: Helper

Registered: 07.10.04

last visit: 27.06.09

Posts: 436
[25] Posted: 11.01.2005, 21:25

Ok so I have reached the point of trying to call to the API function but for some reason I have an issue with my SQL and am not sure how to adjust it to work correctly can anyone give me some advice please. Below is my API function:

Code
function pnDiagram_userapi_query()
{

$dbconn =& pnDBGetConn(true);
$pntable =& pnDBGetTables();

$pnDiagramtable = &$pntable['pnDiagram_data'];
$pnDiagramcolumn = &$pntable['pnDiagram_data_column'];

$sql = "SELECT $pnDiagramcolumn[site_name] LIKE '".$itemname."'
OR $pnDiagramcolumn[site_type] LIKE '".$Tsite."'
OR $pnDiagramcolumn[city] LIKE '".$city."'
OR $pnDiagramcolumn[state] LIKE '".$state."'
OR $pnDiagramcolumn[tech1] LIKE '".$tech1."'
OR $pnDiagramcolumn[tech2] LIKE '".$tech2."'
OR $pnDiagramcolumn[tech3] LIKE '".$tech3."'
OR $pnDiagramcolumn[status] LIKE '".$status."'
OR $pnDiagramcolumn[diagram_type] LIKE '".$diagram."'
OR $pnDiagramcolumn[author] LIKE '".$author."'
OR $pnDiagramcolumn[category] LIKE '".$category."');

print_r($sql);
die;

}

Thanks
-SUNADMN
[26]

[27]
jediping [29]

Rank: Helper

Registered: 15.11.04

last visit: 12.03.07

Posts: 387
[30] Posted: 11.01.2005, 23:09

I think you need something like SELECT * FROM table WHERE ...
[31]

[32]
cyber_wolf [34]

Rank: Helper

Registered: 03.06.02

last visit: 23.04.09

Posts: 292
[35] Posted: 12.01.2005, 13:25

jediping is correct.

You need to use either SELECT * FROM $pnDiagramtable WHERE ( {your LIKE statements from above} )

or

SELECT $pnDiagramcolumn[column1],$pnDiagramcolumn[column2],$pnDiagramcolumn[column3]... FROM $pnDiagramtable WHERE ( {your LIKE statements from above} )

--
cyber_wolf
www.bkbsolutions.com - My Zikula module development site.
[36]

[37]
sunadmn [39]

Rank: Helper

Registered: 07.10.04

last visit: 27.06.09

Posts: 436
[40] Posted: 12.01.2005, 14:17

Ok so I have changed that up a bit and the statement looks ok but for some reason my vars are empty and I am not getting the form fields passed to the SQL statement. I will post some code here to have you guys look at it to see if you guys see an issue.

this is the pnuser.php search function:

Code
function pnDiagram_user_search()
{

if (!pnSecAuthAction(0, 'pnDiagram::', '::', ACCESS_OVERVIEW)) {
return pnVarPrepHTMLDisplay(_MODULENOAUTH);
}

$pnRender =& new pnRender('pnDiagram');

$pnRender->caching = false;

return $pnRender->fetch('pnDiagram_user_search.htm');

}

Which calls to this pnrender template:

Code


<br /><br />
<div class="pn-title"></div>
<br /><br />
<form action="" method="post" enctype="application/x-www-form-urlencoded">
<div>
<input type="hidden" name="authid" value="" />
<input type="hidden" name="tid" value="" />
<table border="1" cellpadding="5" cellspacing="1"><tbody>
<tr>
<td><label for="pnDiagram_name"></label></td>
<td><input id="pnDiagram_name" name="itemname" type="text" size="32" maxlength="32" /></td>
</tr>
<tr>
<td><label for="pnDiagram_site_type"></label></td>
<td><select name="Tsite" size="1" tabindex="3"><option value=""></option><option value="Master Headend">Master Headend</option><option value="Hub">Hub</option><option value="CoLocation">CoLocation</option><option value="Central Office">Central Office</option><option value="Aggregation Point">Aggregation Point</option></select></td>
</tr>
<tr>
<td><label for="pnDiagram_city"></label></td>
<td><input id="pnDiagram_city" name="city" type="text" size="32" maxlength="32" /></td>
</tr>
<tr>
<td><label for="pnDiagram_state"></label></td>
<td><input id="pnDiagram_state" name="state" type="text" size="32" maxlength="32" /></td>
</tr>
<tr>
<td><label for="pnDiagram_technology"></label></td>
<td><label><input type="radio" name="tech1" value="PowerLink">PowerLink</label></td>
</tr>
<tr>
<td><label for="pnDiagram_technology"></label></td>
<td><label><input type="radio" name="tech2" value="Digital TV">Digital TV</label></td>
</tr>
<tr>
<td><label for="pnDiagram_technology"></label></td>
<td><label><input type="radio" name="tech3" value="Video on Demand">Video on Demand</label></td>
</tr>
<tr>
<td><label for="pnDiagram_status"></label></td>
<td><select name="status" size="1" tabindex="13"><option value=""></option><option value="Verified">Verified</option><option value="Unverified">Unverified</option><option value="Proposed">Proposed</option><option value="Acquisition">Acquisition</option></select></td>
</tr>
<tr>
<td><label for="pnDiagram_diagram"></label></td>
<td><select name="diagram" size="1" tabindex="11"><option value=""></option><option value="Port">Port</option><option value="Rack">Rack</option><option value="Vlan">Vlan</option><option value="Connectivity">Connectivity</option><option value="Overview">Overview</option></select></td>
</tr>
<tr>
<td><label for="pnDiagram_author"></label></td>
<td><input id="pnDiagram_author" name="author" type="text" size="32" maxlength="32" /></td>
</tr>
<tr>
<td><label for="pnDiagram_category"></label></td>
<td><select name="category" size="1" tabindex="11"><option value=""></option><option value="NorthEast">NorthEast</option><option value="SouthEast">SouthEast</option><option value="SoutherCal">SoutherCal</option><option value="Western">Western</option><option value="Central">Central</option></select></td>
</tr>
</table>
<input name="submit" type="submit" value="" />
</div>
</form>

And that submits the data to my pnuser.php query function:

Code
function pnDiagram_user_query($args)
{

//print_r($args);
//die;

list [43]($itemname,
$Tsite,
$city,
$state,
$tech1,
$tech2,
$tech3,
$status,
$diagram,
$author,
$category) = pnVarCleanFromInput('itemname',
'Tsite',
'city',
'state',
'tech1',
'tech2',
'tech3',
'status',
'diagram',
'author',
'category');

extract [44]($args);

if (!pnSecConfirmAuthKey()) {
pnSessionSetVar('errormsg', pnVarPrepHTMLDisplay(_BADAUTHKEY));
pnRedirect(pnModURL('pnDiagram', 'user', 'view'));
return true;
}

if (!pnModAPILoad('pnDiagram', 'user')) {
pnSessionSetVar('errormsg', pnVarPrepHTMLDisplay(_LOADFAILED));
pnRedirect(pnModURL('pnDiagram', 'user', 'view'));
return true;
}

pnModAPIFunc('pnDiagram',
'user',
'query',
array [45]('itemname' => $itemname,
'Tsite' => $Tsite,
'address' => $address,
'city' => $city,
'state' => $state,
'zip' => $zip,
'tech1' => $tech1,
'tech2' => $tech2,
'tech3' => $tech3,
'status' => $status,
'diagram' => $diagram,
'date' => $date,
'author' => $author,
'rev' => $rev,
'version' => $version,
'file' => $file,
'category' => $category));

pnRedirect(pnModURL('pnDiagram', 'user', 'view'));

// Return
return true;

}

This then calls the API function to do the search on the DB:

Code
function pnDiagram_userapi_query()
{

$dbconn =& pnDBGetConn(true);
$pntable =& pnDBGetTables();

$pnDiagramtable = &$pntable['pnDiagram_data'];
$pnDiagramcolumn = &$pntable['pnDiagram_data_column'];

$sql = "SELECT * FROM $pnDiagramtable WHERE(
$pnDiagramcolumn[site_name] LIKE '".$itemname."'
OR $pnDiagramcolumn[site_type] LIKE '".$Tsite."'
OR $pnDiagramcolumn[city] LIKE '".$city."'
OR $pnDiagramcolumn[state] LIKE '".$state."'
OR $pnDiagramcolumn[tech1] LIKE '".$tech1."'
OR $pnDiagramcolumn[tech2] LIKE '".$tech2."'
OR $pnDiagramcolumn[tech3] LIKE '".$tech3."'
OR $pnDiagramcolumn[status] LIKE '".$status."'
OR $pnDiagramcolumn[diagram_type] LIKE '".$diagram."'
OR $pnDiagramcolumn[author] LIKE '".$author."'
OR $pnDiagramcolumn[category] LIKE '".$category."')";

print_r [46]($sql);
die [47];

}

As you can see right now I am just testing the SQL statement to ensure I have data being passed from the user functions to the API and for some reason I am not any ideas you all might have would be great.

Thanks
-SUNADMN
[48]

[49]
jediping [51]

Rank: Helper

Registered: 15.11.04

last visit: 12.03.07

Posts: 387
[52] Posted: 12.01.2005, 15:04

It looks like you're not passing any args to your query, as in function pnDiagram_userapi_query($args). :)

A question on the design of this search thing, though. Might it not be easier for the user to just enter one term in one box and then have the search function check that one term against all the columns? Or am I thinking too simplistically? Guess it depends on what you anticipating them searching for. The planning stages of programming always intrigue me. :D
[53]

[54]
sunadmn [56]

Rank: Helper

Registered: 07.10.04

last visit: 27.06.09

Posts: 436
[57] Posted: 12.01.2005, 15:07

Yeah I just caught that myself about a minute ago, so now it's on to testiing.
[58]

[59]
sunadmn [61]

Rank: Helper

Registered: 07.10.04

last visit: 27.06.09

Posts: 436
[62] Posted: 12.01.2005, 15:41

OK so I get my args passed now but for some stupid reason I am not getting any data in the vars in the SQL statement. Here is what I have now:

API function:

Code
function pnDiagram_userapi_query($args)
{

//print_r($args);
//die;

$dbconn =& pnDBGetConn(true);
$pntable =& pnDBGetTables();

$pnDiagramtable = &$pntable['pnDiagram_data'];
$pnDiagramcolumn = &$pntable['pnDiagram_data_column'];

$sql = "SELECT * FROM $pnDiagramtable WHERE(
$pnDiagramcolumn[site_name] LIKE '%$itemname%'
OR $pnDiagramcolumn[site_type] LIKE '%$Tsite%'
OR $pnDiagramcolumn[city] LIKE '%$city%'
OR $pnDiagramcolumn[state] LIKE '%$state%'
OR $pnDiagramcolumn[tech1] LIKE '%$tech1%'
OR $pnDiagramcolumn[tech2] LIKE '%$tech2%'
OR $pnDiagramcolumn[tech3] LIKE '%$tech3%'
OR $pnDiagramcolumn[status] LIKE '%$status%'
OR $pnDiagramcolumn[diagram_type] LIKE '%$diagram%'
OR $pnDiagramcolumn[author] LIKE '%$author%'
OR $pnDiagramcolumn[category] LIKE '%$category%')";

print_r [63]($sql);
die [64];

}

and when I print the SQL out I get this:

Code
SELECT * FROM nuke_pnDiagram_data WHERE( nuke_pnDiagram_data.site_name LIKE '%%' OR nuke_pnDiagram_data.site_type LIKE '%%' OR nuke_pnDiagram_data.city LIKE '%%' OR nuke_pnDiagram_data.state LIKE '%%' OR nuke_pnDiagram_data.tech1 LIKE '%%' OR nuke_pnDiagram_data.tech2 LIKE '%%' OR nuke_pnDiagram_data.tech3 LIKE '%%' OR nuke_pnDiagram_data.status LIKE '%%' OR nuke_pnDiagram_data.diagram_type LIKE '%%' OR nuke_pnDiagram_data.author LIKE '%%' OR nuke_pnDiagram_data.category LIKE '%%')

I have tried building the vars in the statement in the above method and like this:

Code
'".$itemname."',

Neither of these work, am I building this incorrectly???

Thanks
-SUNADMN
[65]

[66]
jediping [68]

Rank: Helper

Registered: 15.11.04

last visit: 12.03.07

Posts: 387
[69] Posted: 12.01.2005, 16:11

I think you just need to do extract($args) and you should be okay.
[70]

[71]
sunadmn [73]

Rank: Helper

Registered: 07.10.04

last visit: 27.06.09

Posts: 436
[74] Posted: 12.01.2005, 16:20

Yup jess that was it I keep overlooking the obvious here all the darn time. Ok so now I will work the rest.

Thanks jedi

-SUNADMN
[75]

[76]
sunadmn [78]

Rank: Helper

Registered: 07.10.04

last visit: 27.06.09

Posts: 436
[79] Posted: 12.01.2005, 16:33

Ok so jedi do you have any idea how I would use the render engine to produce results from that quewry and I run the SQL??? I am a little lost here as this is a stand alone function and nothing in the module really looks like anything I would use her.

Thanks
-SUNADMN
[80]

[81]
jediping [83]

Rank: Helper

Registered: 15.11.04

last visit: 12.03.07

Posts: 387
[84] Posted: 12.01.2005, 17:01

I think your best bet would be to use a similar function to the view/display combo. Print out a list of the sites as links to where they can see all the information about it.
[85]

[86]
sunadmn [88]

Rank: Helper

Registered: 07.10.04

last visit: 27.06.09

Posts: 436
[89] Posted: 12.01.2005, 17:19

Ok kewl I will take a look there and get back with you and let you know my results.

Thanks man
-SUNADMN
[90]

[91]
sunadmn [93]

Rank: Helper

Registered: 07.10.04

last visit: 27.06.09

Posts: 436
[94] Posted: 12.01.2005, 19:59

Ok so it has to be back to basics here as I can't figure out how to port the logic of the view/dispaly function to port to a search as the view/display functions dont really return a single item for a given match rather produce all items in the DB.

So I am going to make a list here of what is needed and hope for some insite on what else I am missing:

1st) a Menu link to a user function that produces a pntemplate file for a seach form ( done I have this part working )
2nd) a query function for the pntemplate file to call to that will run the pnuserapi function to get the data ( for the most part this is done but I think I am missing some logic here )
3rd) a userapi function that takes the form data from the pntemplate and runs a SQL query to produce a data set ( I believe I have this done, the part I am hung on is the display portion of code how do I translate the data returned from the API function to a pntemplate )

I know this may sound trivial to some, but for the life of me I just can't grasp the logic behind it please please I need some help.

Thanks
-SUNADMN
[95]

[96]
jediping [98]

Rank: Helper

Registered: 15.11.04

last visit: 12.03.07

Posts: 387
[99] Posted: 12.01.2005, 20:46

Are you sure the search function will return only one result? It seems possible that there would be more than one result, yes? For example, there's going to (probably) be more than one person with tech1, yes? The SQL result will be all the details about everyone who has tech1.

Now you need to get the SQL result into something you can use. This is similar to what you use in the main view function, by putting the results into an $items variable, sending it to the pnuser file, which then gets it ready for display.

Does that help?
[100]

[101]

Building a search function?? [8]

Code

Code

Code

Code

Code

Code

Code

Code

Code

Code

Users online