rendered paste body<?php require("../dbconnect.php"); function cleanfrominput($input) { $hostname_pattern = '/^([0-9\.]+)$/'; // check the posted hostname against our regex to determine validity if (preg_match($hostname_pattern, $input)) { return $input; } else { echo '<p><h2 style="color:red;">Your input appears to be invalid.<br />Only numeric (0-9), and periods (.) are allowed.</h2></p>'; exit(); } } function listallips($cleanip) { $query = "SELECT id,assignedips,dedicatedip FROM tblhosting"; $result = mysql_query($query) or die(mysql_error()); $ipArray = array(); while ($data = mysql_fetch_array($result)) { $hostid = $data['id']; $dedicatedip = $data['dedicatedip']; $assignedips = $data['assignedips']; $ipArrayInit = explode(";", trim($assignedips)); if ($dedicatedip != "") { $ipArray[$hostid][] = $dedicatedip; } foreach ($ipArrayInit as $v) { if ($v != "") { if (stristr($v, '-')) { $ipArrayFinal = explode("-", trim($v)); foreach (range(ip2long(trim($ipArrayFinal[0])), ip2long(trim($ipArrayFinal[1]))) as $number) { $ipArray[$hostid][] = long2ip($number); } } else { $ipArray[$hostid][] = $v; } } } } //echo '<pre>'; //print_r($ipArray); //echo '</pre>'; foreach ($ipArray as $hostId => $ips) { if (array_search($cleanip, $ips)) { return $hostId; } else { return '<p style="color:red;font-weight:700;">ERROR: IP Not Found.</p>'; } } } $search4ip = $_POST['search4ip']; if (isset($search4ip)) { $cleanip = cleanfrominput($search4ip); print listallips($cleanip); } else { echo '<table><tr> <td><form action="" method="post" name="customsearch" id="customsearch"> Enter IP</td> <td><input type="text" size="16" value="" name="search4ip" id="search4ip" /></td> <td><input type="submit" value="Search" /> </form> </td> </tr></table>' . "\n"; }?>