My ERROR [$errno] $errstr
\n";
echo " Fatal error in line $errline of file $errfile";
echo ", PHP " . PHP_VERSION . " (" . PHP_OS . ")
\n";
echo "Aborting...
\n";
exit(1);
break;
case E_USER_WARNING:
echo "My WARNING [$errno] $errstr
\n";
break;
case E_USER_NOTICE:
echo "My NOTICE [$errno] $errstr
\n";
break;
default:
echo "Unknown error type: [$errno] $errstr
\n";
echo "Line " . $errline . " in " . $errfile . "
";
break;
}
}
// set to the user defined error handler
// $old_error_handler = set_error_handler("myErrorHandler");
if (strpos($REQUEST_URI, "?") > 0) {
$main_split = explode("?", $REQUEST_URI);
$main_url = $main_split[0];
} else {
$main_url = $REQUEST_URI;
}
$url_array=explode("/",$main_url); //BREAK UP THE URL PATH
// USING '/' as delimiter
// [1] == script directory, so ignore it
// [2] == script itself, so ignore it
//echo count($url_array);
if (isset($url_array[3])) {
$Category=$url_array[3]+0; //Category
} else {
$Category=0;
}
$pagetitle = "CanQuote | Links | $Category";
require_once($DOCUMENT_ROOT . "/header.php");
$_uid="canquote";
$_pwd="ate2much";
$connTemp=mysql_connect("localhost",$_uid,$_pwd);
if (!mysql_select_db("canquote",$connTemp))
{
$output= "connection to canquote db failed with " . mysql_error() . "\r\n";
$output_type="";
require($DOCUMENT_ROOT . "/footer.php");
exit;
}
// var_dump($url_array);
echo "CanQuote - Links
\n";
if ($Category==0) {
echo "Link Categories
";
$sql="select distinct link_id, link_cat from link_categories inner join link_links on link_id = ll_cat order by link_cat";
$result = mysql_db_query("canquote",$sql);
if (!$result) {
echo mysql_error();
} else {
while ($row = mysql_fetch_array($result)) {
echo "".$row["link_cat"]."
\n";
}
}
} else {
echo "Back to Top of Directory
\n";
$sql="select * from link_categories inner join link_links on link_id = ll_cat where ll_cat=".$Category;
$result = mysql_db_query("canquote",$sql);
$header_printed = false;
if (!$result) {
echo mysql_error();
} else {
while ($row = mysql_fetch_array($result)) {
if ($header_printed == false) {
echo "".$row["link_cat"]."
";
$header_printed = true;
}
echo "".$row["ll_title"]."
\n".$row["ll_text"]."
\n";
}
}
echo "
Back to Top of Directory
\n";
}
$remote_addr = $_SERVER["REMOTE_ADDR"];
$me = gethostbyname("cpe00e029139bb7-cm000f9fad473c.cpe.net.cable.rogers.com");
if ($remote_addr == $me) {
if ($_POST["insertme"] == "yes") {
$sqlinsert = "insert into link_links (ll_cat,ll_title,ll_text,ll_link) values(".
$_POST["category"] . "," .
"\"" . $_POST["title"] . "\"," .
"\"" . $_POST["desc"] . "\"," .
"\"" . $_POST["link"] . "\")";
echo $sqlinsert;
if( mysql_db_query("canquote", $sqlinsert) ) {
echo "insert occured without error
\n";
} else {
echo "insert returned false -- error on insert
\n";
}
}
echo "\n";
}
require_once($DOCUMENT_ROOT . "/footer.php");
?>