Code: Select all
<?php
include "iprange.inc";
include "error.inc";
include "paths.inc";
include "functions2.php";
if ( !empty($_GET["offset"]) )
{
// initialize browse3() params
$scriptName = "search_unavailable.php";
$offset = $_GET['offset'];
// HTML <TABLE> column headers
$header[0]["header"] = "Id";
$header[1]["header"] = "Network";
$header[2]["header"] = "Mask";
$header[3]["header"] = "Size";
$header[4]["header"] = "Type";
$header[5]["header"] = "Router Info";
$header[6]["header"] = "Description";
$header[7]["header"] = "Member Id";
$header[8]["header"] = "User";
$header[9]["header"] = "Assigned";
// query attributes to display in <TABLE> columns
$header[0]["attrib"] = "id";
$header[1]["attrib"] = "network";
$header[2]["attrib"] = "mask";
$header[3]["attrib"] = "size";
$header[4]["attrib"] = "type";
$header[5]["attrib"] = "router_info";
$header[6]["attrib"] = "description";
$header[7]["attrib"] = "member_id";
$header[8]["attrib"] = "user";
$header[9]["attrib"] = "assigned";
// (1) Open the database connection
$connection = mysql_connect($hostName,$username,$password);
// (2) Select the database
mysql_select_db($databaseName, $connection);
// use the browse3() function
browse3( $scriptName, $connection, $offset, $query, $header );
// choose to browse more or go to main menu
echo '<form name="browse_options" method="post" action="search_unavailable.php"><p>' .
'<input type="button" value="Browse More Networks"
onclick="window.location.href=\'search_unavailable.php\'"><p>' .
'<input type="button" value="Main Menu"
onclick="window.location.href=\'interface.php\'" ><br><p>';
echo '</form><p>';
// close the connection
if (!(mysql_close($connection)))
showerror();
}
elseif ( !empty($_POST["descr"]) || !empty($_POST["network"]) || !empty($_POST["size_dropdown"]) )
{
// initialize browse3() params
$scriptName = "search_unavailable.php";
// set $offset to zero if not previously set
if ( empty($offset) )
$offset = 0;
// $offset = $_GET['offset'];
// HTML <TABLE> column headers
$header[0]["header"] = "Id";
$header[1]["header"] = "Network";
$header[2]["header"] = "Mask";
$header[3]["header"] = "Size";
$header[4]["header"] = "Type";
$header[5]["header"] = "Router Info";
$header[6]["header"] = "Description";
$header[7]["header"] = "Member Id";
$header[8]["header"] = "User";
$header[9]["header"] = "Assigned";
// query attributes to display in <TABLE> columns
$header[0]["attrib"] = "id";
$header[1]["attrib"] = "network";
$header[2]["attrib"] = "mask";
$header[3]["attrib"] = "size";
$header[4]["attrib"] = "type";
$header[5]["attrib"] = "router_info";
$header[6]["attrib"] = "description";
$header[7]["attrib"] = "member_id";
$header[8]["attrib"] = "user";
$header[9]["attrib"] = "assigned";
// (1) Open the database connection
$connection = mysql_connect($hostName,$username,$password);
// (2) Select the database
mysql_select_db($databaseName, $connection);
// start beginning of query to build on
$query = "SELECT * FROM subnets WHERE ";
// build a query for just a description search
if ( !empty($_POST["descr"]) && empty($_POST["network"]) )
{
$query .= "description = '" . $_POST['descr'] . "'";
//$description = $_POST['descr'];
//global_session('description');
}
// build a query for just a network search
if ( !empty($_POST["network"]) )
{
// build a query for a search on description AND network
if ( !empty($_POST["description"]) )
{
$query .= "description = '" . $_POST['descr'] .
"' AND network = '" . $_POST['network'] . "'";
//$description = $_POST['descr'];
//$network = $_POST['network'];
//global_session('description');
//global_session('network');
}
else
{
$query .= "network = '" . $_POST['network'] . "'";
//$network = $_POST['network'];
//global_session('network');
}
}
// build a query for just a size search
if ( empty($_POST["descr"]) && empty($_POST["network"]) )
{
$query .= "size = '" . $_POST['size_dropdown'] . "'";
//$size = $_POST['size_dropdown'];
//global_session('size');
}
$query .= " AND (assigned = 1 OR assigned = 2) ORDER BY network";
// store the query for later use
//global_session('query');
global $query;
// use the browse3() function
browse3( $scriptName, $connection, $offset, $query, $header );
/*
// run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();
// display the results
displayIPtable($result);
*/
// choose to browse more or go to main menu
echo '<form name="browse_options" method="post" action="search_unavailable.php"><p>' .
'<input type="button" value="Browse More Networks"
onclick="window.location.href=\'search_unavailable.php\'"><p>' .
'<input type="button" value="Main Menu"
onclick="window.location.href=\'interface.php\'" ><br><p>';
echo '</form><p>';
// close the connection
if (!(mysql_close($connection)))
showerror();
}
else
{
echo 'Search networks by description, network, or size. <br><p>';
//~~~~~~~~~~~~~~~ CREATE FORM TO SUBMIT DESIRED NETWORK DESCRIPTION OR NETWORK ~~~~~~~~~~~~~~~~~~~~~~~
echo '<form name="search_unavailable" method="post" action="search_unavailable.php">
Description: ' .
'<input type="text" name="descr" value="" size="55"><br>' .
'Network: <input type="text" name="network" value="" size="35"><br><p>' .
'Size: <select name="size_dropdown"><br>' .
'<option value="">Choose one</option>' .
'<option value="2">2</option>' .
'<option value="6">6</option>' .
'<option value="14">14</option>' .
'<option value="30">30</option>' .
'<option value="62">62</option>' .
'<option value="126">126</option>' .
'<option value="254">254</option>' .
'<option value="1022">1022</option>' .
'<option value="65534">65534</option>' .
'</select><p>' .
'<input type="submit" name="submit_all" value="Submit"><p>';
echo '</form><p>';
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
}
?>