Top
Home
cz.php

install.php

<?php
$con=mysqli_connect("","","","");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
} $sql="
CREATE TABLE `` (
`id` int(11) NOT NULL auto_increment,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`ip` varchar(250) NULL DEFAULT NULL,
`todae` varchar(250) NULL DEFAULT NULL,
PRIMARY KEY  (`id`)
)
";
if (mysqli_query($con,$sql))
{
echo "<Center> created successfully! Yee Haa!!<br><br> <img src=\"http://www.mooseloose.com/images/0002.jpg\">";
}
else
{
echo "Error creating table: " . mysqli_error($con);
}



?>

ML.php

<?php session_start();
 if (isset($_GET["order"])) $order = @$_GET["order"];
 if (isset($_GET["type"])) $ordtype = @$_GET["type"];
 if (isset($_POST["filter"])) $filter = @$_POST["filter"];
 if (isset($_POST["filter_field"])) $filterfield = @$_POST["filter_field"];
 $wholeonly = false;
 if (isset($_POST["wholeonly"])) $wholeonly = @$_POST["wholeonly"];
 if (!isset($order) && isset($_SESSION["order"])) $order = $_SESSION["order"];
 if (!isset($ordtype) && isset($_SESSION["type"])) $ordtype = $_SESSION["type"];
 if (!isset($filter) && isset($_SESSION["filter"])) $filter = $_SESSION["filter"];
 if (!isset($filterfield) && isset($_SESSION["filter_field"])) $filterfield = $_SESSION["filter_field"];
ini_set('error_reporting', E_ALL | E_STRICT);
ini_set('display_errors', 'Off'); ?>



<html>
<head>
<title></title>
<meta name="generator" http-equiv="content-type" content="text/html">


<style type="text/css">

a:link { color: #000000; text-decoration: none}
a:vlink { color: #000000; text-decoration: none}
a:hover { color:Red; text-decoration: underline}
a:active { color: 000000; text-decoration: none;  }
a { color: #000000; text-decoration: none;  }
body {background: #F7F6F1}
CITE { font-size: 14px; color: #ff0000; text-decoration: none}



/*background color behind buttons and links*/
.bd {
  background-color: #FDFDDE;
  color: #000000;
  font-family: Arial;
  font-size: 12px;
  text-align:left;
}



td{color: #1D507D; font-family: Arial; font-size: 18px;}



/*Table Border around the information*/
.tbl {
border-left: 1px solid #ffffff;
border-top: 1px solid #ffffff;
border-bottom: 1px solid #dddddd;
border-right: 1px solid #dddddd;
  background-color: #F7F6F1;
}



/*Footer background and TH*/
.hr {
  background-color: #EAF3FA;
  color: #1D507D;
  font-family: Arial;
  font-size: 14px;
}



/*Links in the TH*/


.hr a:link{
  background-color: transparent;
  color: #1D507D;
  font-family: Arial;
  font-size: 14px;
}



/*Header*/
.th01{
background-image:url(http://mooseloose.com/header.png);
height:107px;
  background-color: #F7F6F1;
background-repeat:no-repeat;
border: 0px solid black;
}



/*Links in th main page*/
a.hr:link {
  color: #1D507D;
  font-family: Arial;
  font-size: 12px;
}



a.hr:visited {
  color: #1D507D;
}



a.hr:hover {
  color: #0000ff;
}



a.hr:active {
  color: #ff0000;
}



/*odd and bg of record details*/
.dr {
  background-color: #F7F6F1;
  color: #000000;
  font-family: Arial;
  font-size: 12px;
}



/*even*/
.sr {
  background-color: #FDFDDE;
  color: #000000;
  font-family: Arial;
  font-size: 12px;
}



.detaillabels{width:100px;
text-align:right;
font-family: Arial;
font-size: 14px;
background-color: #EAF3FA;
}



.op02
a {
font-family: Arial;
 font-size: 12px;
color: #EAF3FA;
text-decoration: none;
float: left;
background-image: url(butaX.jpg);
background-color: #21759B;
text-align: center;
vertical-align: middle;
border-style: solid;
border-width: 1px;
border-color: white #C7C7C7 #C7C7C7 white;
top: 10px;
left: 10px;
width:100px;
height:18px;
overflow: visible;
-moz-border-radius: 50px;
-webkit-border-radius: 50px;
-khtml-border-radius: 50px;
border-radius: 50px; }



.op02
a:hover {
color: #ffffff;
text-decoration: none;
float: left;
background-image: url(butbX.jpg);
background-color: #073447;
text-align: center;
vertical-align: middle;
border-style: solid;
border-width: 1px;
border-color: #C7C7C7 white white #C7C7C7;
top: 10px;
left: 10px;
width:100px;
height:18px;
overflow: visible }



table{width:960px;}



.search{width:500px}



.success{ font-family: Arial;
font-size: 14px;
}

</style> </head>
<body>
<center><table border=0><tr><td valign=top class="th01"></table>
<table>
<tr>



<td valign=top valign="top">
<?php
 if (!login()) exit;
?><div style="float: right"><span class="op02 "><a href="ML.php?a=logout">Logout</a></span></div>
<div style="float: right"><span class="op02 "><a href="excel.php?a=logout">Excel</a></span></div>
<br>
<?php
 $conn = connect();
 $showrecs = 20;
 $pagerange = 10;



 $a = @$_GET["a"];
 $recid = @$_GET["recid"];
 $page = @$_GET["page"];
 if (!isset($page)) $page = 1;



 $sql = @$_POST["sql"];



 switch ($sql) {
   case "insert":
     sql_insert();
     break;
   case "update":
     sql_update();
     break;
   case "delete":
     sql_delete();
     break;
 }



 switch ($a) {
   case "add":
     addrec();
     break;
   case "view":
     viewrec($recid);
     break;
   case "edit":
     editrec($recid);
     break;
   case "del":
     deleterec($recid);
     break;
   default:
     select();
     break;
 }



 if (isset($order)) $_SESSION["order"] = $order;
 if (isset($ordtype)) $_SESSION["type"] = $ordtype;
 if (isset($filter)) $_SESSION["filter"] = $filter;
 if (isset($filterfield)) $_SESSION["filter_field"] = $filterfield;
 if (isset($wholeonly)) $_SESSION["wholeonly"] = $wholeonly;



 mysql_close($conn);
?>
</td></tr></table>
<table ><tr><td valign=top class="hr">
</td></tr></table>
</body>
</html>



<?php function select()
 {
 global $a;
 global $showrecs;
 global $page;
 global $filter;
 global $filterfield;
 global $wholeonly;
 global $order;
 global $ordtype;



 if ($a == "reset") {
   $filter = "";
   $filterfield = "";
   $wholeonly = "";
   $order = "";
   $ordtype = "";
 }



 $checkstr = "";
 if ($wholeonly) $checkstr = " checked";
 if ($ordtype == "asc") { $ordtypestr = "desc"; } else { $ordtypestr = "asc"; }



 $res = sql_select();
 $count = sql_getrecordcount();
 if ($count % $showrecs != 0) {
   $pagecount = intval($count / $showrecs) + 1;
 }
 else {
   $pagecount = intval($count / $showrecs);
 }
 $startrec = $showrecs * ($page - 1);
 if ($startrec < $count) {mysql_data_seek($res, $startrec);}
 $reccount = min($showrecs * $page, $count);
?>
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr><td>Records shown <?php echo $startrec + 1 ?> - <?php echo $reccount ?> of <?php echo $count ?></td></tr>
</table>
<form name="" action="ML.php" method="post">
<table class="search" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><b>Find</b>&nbsp;</td>
<td><input type="text" name="filter" value="<?php echo $filter ?>"></td>
<td>




<select name="filter_field">
<option value="">All Fields</option>
<option value="<?php echo "Id" ?>"<?php if ($filterfield == "Id") { echo "selected"; } ?>><?php echo htmlspecialchars("Id") ?></option>
<option value="<?php echo "" ?>"<?php if ($filterfield == "") { echo "selected"; } ?>><?php echo htmlspecialchars("") ?></option>
<option value="<?php echo "" ?>"<?php if ($filterfield == "") { echo "selected"; } ?>><?php echo htmlspecialchars("") ?></option>
</select>



</td>



<td><nobr><input type="checkbox" name="wholeonly"<?php echo $checkstr ?>>Whole words only</td>
</td>
<td>&nbsp;</td>
<td><input type="submit" name="action" value="Search Now"></td>
<td></td>
</tr>
</table>
</form>



<?php showpagenav($page, $pagecount); ?>
<br>



<!--------------------------------------------------------------------------view all table--------------------------------------------------->




<table class="tbl" border="0" cellspacing="1" cellpadding="5">
<tr>
<td valign=top class="hr">&nbsp;</td>
<td valign=top class="hr">&nbsp;</td>
<td valign=top class="hr">&nbsp;</td>
<td valign=top class="hr"><a class="hr" href="ML.php?order=<?php echo "Id" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Id") ?></a></td>



<td valign=top class="hr">
<a class="hr" href="ML.php?order=<?php echo "" ?>&type=<?php echo $ordtypestr ?>">
<?php echo htmlspecialchars("") ?></a></td>
<td valign=top class="hr">
<a class="hr" href="ML.php?order=<?php echo "" ?>&type=<?php echo $ordtypestr ?>">
<?php echo htmlspecialchars("") ?></a></td>




</tr>
<?php
 for ($i = $startrec; $i < $reccount; $i++)
 {
   $row = mysql_fetch_assoc($res);
   $style = "dr";
   if ($i % 2 != 0) {
     $style = "sr";
   }
?>
<tr>


<td width=10 valign=top class="<?php echo $style ?>"><a href="ML.php?a=view&recid=<?php echo $i ?>"><img src="http://mooseloose.com/view.png" border=0 width=20 height=20></a></td>
<td width=10 valign=top class="<?php echo $style ?>"><a href="ML.php?a=edit&recid=<?php echo $i ?>"><img src="http://mooseloose.com/edit.png" border=0 width=20 height=20></a></td>
<td width=10 valign=top class="<?php echo $style ?>"><a href="ML.php?a=del&recid=<?php echo $i ?>"><img src="http://mooseloose.com/delete.png" border=0 width=20 height=20></a></td>



<td valign=top class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Id"]) ?></td>
<td valign=top class="<?php echo $style ?>"><?php echo htmlspecialchars($row[""]) ?></td>
<td valign=top class="<?php echo $style ?>"><?php echo htmlspecialchars($row[""]) ?></td>
</tr>
<?php
 }
 mysql_free_result($res);
?>
</table>
<br>
<?php showpagenav($page, $pagecount); ?>
<?php } ?>



                       <?php function login()
                       {
                       global $_POST;
                       global $_SESSION;



                       global $_GET;
                       if (isset($_GET["a"]) && ($_GET["a"] == 'logout')) $_SESSION["logged_in"] = false;
                       if (!isset($_SESSION["logged_in"])) $_SESSION["logged_in"] = false;
                       if (!$_SESSION["logged_in"]) {
                       $login = "";
                       $password = "";
                       if (isset($_POST["login"])) $login = @$_POST["login"];
                       if (isset($_POST["password"])) $password = @$_POST["password"];



                       if (($login != "") && ($password != "")) {
                       if (($login == "") && ($password == "")) {
                       $_SESSION["logged_in"] = true;
                       }
                       else {
                       ?>



<p><b><font color="-1">Sorry, the login/password combination you've entered is invalid</font></b></p>
<?php } } }if (isset($_SESSION["logged_in"]) && (!$_SESSION["logged_in"])) { ?>
<form name= action="ML.php" method="post">
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td>Username</td>
<td><input type="text" name="login" value="<?php echo $login ?>"></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password" value="<?php echo $password ?>"></td>
</tr>
<tr>
<td><input type="submit" name="action" value="Login"></td>
</tr>
</table>
</form>
<?php
 }
 if (!isset($_SESSION["logged_in"])) $_SESSION["logged_in"] = false;
 return $_SESSION["logged_in"];
} ?>



<?php function showrow($row, $recid)
 {
?>



<!--------------------------------------------------------------------------View Record Detail------------------>



<table class="tbl" border="0" cellspacing="1" cellpadding="5">
<tr>
<td valign=top class="detaillabels"><nobr><?php echo htmlspecialchars("Id")."&nbsp;" ?></td>
<td valign=top class="dr"><?php echo htmlspecialchars($row["Id"]) ?></td>
</tr>
<tr>
<td valign=top class="detaillabels"><nobr><?php echo htmlspecialchars("")."&nbsp;" ?></td>
<td valign=top class="dr"><?php echo htmlspecialchars($row[""]) ?></td>
</tr>
<tr>
<td valign=top class="detaillabels"><nobr><?php echo htmlspecialchars("")."&nbsp;" ?></td>
<td valign=top class="dr"><?php echo htmlspecialchars($row[""]) ?></td>
</tr>
</table>
<?php } ?>



<?php function showroweditor($row, $iseditmode)
 {
 global $conn;
?>



<!--------------------------------------------Add and Edit Page------------------------------------------------------------->



<table class="tbl" border="0" cellspacing="1" cellpadding="5"width="50%">

<input type="hidden" name="Id"  size="55" value="<?php echo str_replace('"', '&quot;', trim($row["Id"])) ?>">

<tr>
<td valign=top class="detaillabels"><nobr><?php echo htmlspecialchars("")."&nbsp;" ?></td>
<td valign=top class="dr"><input type="text" name="" maxlength="250" size="55" value="<?php echo str_replace('"', '&quot;', trim($row[""])) ?>"></td>
</tr>
<tr>
<td valign=top class="detaillabels"><nobr><?php echo htmlspecialchars("")."&nbsp;" ?></td>
<td valign=top class="dr"><input type="text" name="" maxlength="250" size="55" value="<?php echo str_replace('"', '&quot;', trim($row[""])) ?>"></td>
</tr>
</table>
<?php } ?>



<?php function showpagenav($page, $pagecount)
{
?>
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><span class="op02 "><a href="ML.php?a=add">Add Record</a>&nbsp;<span class="op02"><a href="ML.php?a=reset">List All Records</a></span></td>
<?php if ($page > 1) { ?>
<td><a href="ML.php?page=<?php echo $page - 1 ?>">&lt;&lt;&nbsp;Prev</a>&nbsp;</td>
<?php } ?>
<?php
 global $pagerange;



 if ($pagecount > 1) {



 if ($pagecount % $pagerange != 0) {
   $rangecount = intval($pagecount / $pagerange) + 1;
 }
 else {
   $rangecount = intval($pagecount / $pagerange);
 }
 for ($i = 1; $i < $rangecount + 1; $i++) {
   $startpage = (($i - 1) * $pagerange) + 1;
   $count = min($i * $pagerange, $pagecount);



   if ((($page >= $startpage) && ($page <= ($i * $pagerange)))) {
     for ($j = $startpage; $j < $count + 1; $j++) {
       if ($j == $page) {
?>
<td><b><?php echo $j ?></b></td>
<?php } else { ?>
<td><a href="ML.php?page=<?php echo $j ?>"><?php echo $j ?></a></td>
<?php } } } else { ?>
<td><a href="ML.php?page=<?php echo $startpage ?>"><?php echo $startpage ."..." .$count ?></a></td>
<?php } } } ?>
<?php if ($page < $pagecount) { ?>
<td>&nbsp;<a href="ML.php?page=<?php echo $page + 1 ?>">Next&nbsp;&gt;&gt;</a>&nbsp;</td>
<?php } ?>
</tr>
</table>
<?php } ?>



<?php function showrecnav($a, $recid, $count)
{
?>
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><span class="op02 "><a href="ML.php">Index Page</a>
<?php if ($recid > 0) { ?>
<span class="op02 "><a href="ML.php?a=<?php echo $a ?>&recid=<?php echo $recid - 1 ?>">Prior Record</a>
<?php } if ($recid < $count - 1) { ?>
<span class="op02 "><a href="ML.php?a=<?php echo $a ?>&recid=<?php echo $recid + 1 ?>">Next Record</a></td>
<?php } ?>
</tr>
</table>



<?php } ?>



<?php function addrec()
{
?>





<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><span class="op02 "><a href="ML.php">Index Page</a></td>
</tr>
</table>



<form name="" enctype="multipart/form-data" action="ML.php" method="post">
<p><input type="hidden" name="sql" value="insert"></p>
<?php
$row = array(
 "Id" => "",
 "" => "",
"" => ""
);
showroweditor($row, false);
?>
<p><input type="submit" name="action" value="Post"></p>
</form>
<?php } ?>



<?php function viewrec($recid)
{
 $res = sql_select();
 $count = sql_getrecordcount();
 mysql_data_seek($res, $recid);
 $row = mysql_fetch_assoc($res);
 showrecnav("view", $recid, $count);
?>
<br>
<?php showrow($row, $recid) ?>
<br>



<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><span class="op02 "><a href="ML.php?a=add">Add Record</a>
<span class="op02 "><a href="ML.php?a=edit&recid=<?php echo $recid ?>">Edit Record</a></td>
<td><span class="op02 "><a href="ML.php?a=del&recid=<?php echo $recid ?>">Delete Record</a></td>
</tr>
</table>
<?php
 mysql_free_result($res);
} ?>



<?php function editrec($recid)
{
 $res = sql_select();
 $count = sql_getrecordcount();
 mysql_data_seek($res, $recid);
 $row = mysql_fetch_assoc($res);
 showrecnav("edit", $recid, $count);
?>
<br>
<form name="" enctype="multipart/form-data" action="ML.php" method="post">
<input type="hidden" name="sql" value="update">
<input type="hidden" name="xId" value="<?php echo $row["Id"] ?>">
<?php showroweditor($row, true); ?>
<p><input type="submit" name="action" value="Post"></p>
</form>
<?php
 mysql_free_result($res);
} ?>



<?php function deleterec($recid)
{
 $res = sql_select();
 $count = sql_getrecordcount();
 mysql_data_seek($res, $recid);
 $row = mysql_fetch_assoc($res);
 showrecnav("del", $recid, $count);
?>
<br>
<form name="" action="ML.php" method="post">
<input type="hidden" name="sql" value="delete">
<input type="hidden" name="xId" value="<?php echo $row["Id"] ?>">
<?php showrow($row, $recid) ?>
<p><input type="submit" name="action" value="Confirm"></p>
</form>
<?php
 mysql_free_result($res);
} ?>



<?php function connect()
{
 $conn = mysql_connect("", "", "");
 mysql_select_db("");
 return $conn;
}



function sqlvalue($val, $quote)
{
 if ($quote)
   $tmp = sqlstr($val);
 else
   $tmp = $val;
 if ($tmp == "")
   $tmp = "NULL";
 elseif ($quote)
   $tmp = "'".$tmp."'";
 return $tmp;
}



function sqlstr($val)
{
 return str_replace("'", "'", $val);
}



function sql_select()
{
 global $conn;
 global $order;
 global $ordtype;
 global $filter;
 global $filterfield;
 global $wholeonly;



 $filterstr = sqlstr($filter);
 if (!$wholeonly && isset($wholeonly) && $filterstr!='') $filterstr = "%" .$filterstr ."%";
 $sql = "SELECT `Id`,
``,
``
FROM ``";
 if (isset($filterstr) && $filterstr!='' && isset($filterfield) && $filterfield!='') {
   $sql .= " where " .sqlstr($filterfield) ." like '" .$filterstr ."'";
 } elseif (isset($filterstr) && $filterstr!='') {
   $sql .= " where
(`Id` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."')
";
 }
 if (isset($order) && $order!='') $sql .= " order by `" .sqlstr($order) ."`";
 if (isset($ordtype) && $ordtype!='') $sql .= " " .sqlstr($ordtype);
 $res = mysql_query($sql, $conn) or die(mysql_error());
 return $res;
}



function sql_getrecordcount()
{
 global $conn;
 global $order;
 global $ordtype;
 global $filter;
 global $filterfield;
 global $wholeonly;



 $filterstr = sqlstr($filter);
 if (!$wholeonly && isset($wholeonly) && $filterstr!='') $filterstr = "%" .$filterstr ."%";
 $sql = "SELECT COUNT(*) FROM ``";
 if (isset($filterstr) && $filterstr!='' && isset($filterfield) && $filterfield!='') {
   $sql .= " where " .sqlstr($filterfield) ." like '" .$filterstr ."'";
 } elseif (isset($filterstr) && $filterstr!='') {
   $sql .= " where
(`Id` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."')
";
 }
 $res = mysql_query($sql, $conn) or die(mysql_error());
 $row = mysql_fetch_assoc($res);
 reset($row);
 return current($row);
}



function sql_insert()
{
 global $conn;
 global $_POST;



 $sql = "insert into ``
(`Id`,
``,
``
) values (
" .sqlvalue(@$_POST["Id"], false).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true)."
)";
 mysql_query($sql, $conn) or die(mysql_error());
}



function sql_update()
{
 global $conn;
 global $_POST;



 $sql = "update `` set
`Id`=" .sqlvalue(@$_POST["Id"], false).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true)."
where " .primarykeycondition();
 mysql_query($sql, $conn) or die(mysql_error());
}



function sql_delete()
{
 global $conn;



 $sql = "delete from `` where " .primarykeycondition();
 mysql_query($sql, $conn) or die(mysql_error());
}
function primarykeycondition()
{
 global $_POST;
 $pk = "";
 $pk .= "(`Id`";
 if (@$_POST["xId"] == "") {
   $pk .= " IS NULL";
 }else{
 $pk .= " = " .sqlvalue(@$_POST["xId"], false);
 };
 $pk .= ")";
 return $pk;
}
?>



01.php

<style type="text/css">
table.FearFarm {
   text-align: center;
   font-family: Verdana;
   font-weight: normal;
   font-size: 14px;
   color: #ffffff;
   width: auto;
   border: thin solid black;
   background-color: transparent;
   border-collapse: collapse;
   border-spacing: 0px;
   padding: 3px}
.Fear {
   border: 0px solid #000;
   background-color: transparent;
   text-align: right;
   font-family: Verdana;
   font-weight: bold;
   font-size: 11px;
   white-space: nowrap;
   color: #404040;
   padding: 3px}
.Farm {
   border-bottom: 0px solid #d79900;
   border: 0px solid #000;
   background-color: transparent;
   text-align: left;
   padding: 3px}
.texta {
   background-color: #dddddd;
   border: 0px solid #008000;
   width: 150px;
   padding: 3px}
.submit {
   background-color: #db6600;
   padding-left: 6px;
   padding-right: 6px;
   padding-top: 3px;
   padding-bottom: 3px;
   color: #ffffff;
   border: 1px solid #db6600;
   background-image: url(images/button_bg.jpg);
}
.submit:hover {
   background-color: #000000;
   border: 1px solid #000000;
   background-image: url(images/button_bg_over.jpg);
}
</style>

<form name="" action="02.php" method="post">
<table class="FearFarm" border="0" cellpadding="5" cellspacing="2" width="600">
<tr>
<td class="Fear" valign=top><font color="red">*</font> </td>
<td class="Farm" valign="top"><input class="texta"  type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top><font color="red">*</font> </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Farm" valign="top" colspan=4><center><input class="submit" type="submit" Name="submit" value="submit" alt="Please Submit"></td>
</tr>
</table>
</form>



02.php

<style type="text/css">
table.FearFarm {
   text-align: center;
   font-family: Verdana;
   font-weight: normal;
   font-size: 14px;
   color: #ffffff;
   width: auto;
   border: thin solid black;
   background-color: transparent;
   border-collapse: collapse;
   border-spacing: 0px;
   padding: 3px}
.Fear {
   border: 0px solid #000;
   background-color: transparent;
   text-align: right;
   font-family: Verdana;
   font-weight: bold;
   font-size: 11px;
   white-space: nowrap;
   color: #404040;
   padding: 3px}
.Farm {
   border-bottom: 0px solid #d79900;
   border: 0px solid #000;
   background-color: transparent;
   text-align: left;
   padding: 3px}
.texta {
   background-color: #dddddd;
   border: 0px solid #008000;
   width: 150px;
   padding: 3px}
.submit {
   background-color: #db6600;
   padding-left: 6px;
   padding-right: 6px;
   padding-top: 3px;
   padding-bottom: 3px;
   color: #ffffff;
   border: 1px solid #db6600;
   background-image: url(images/button_bg.jpg);
}
.submit:hover {
   background-color: #000000;
   border: 1px solid #000000;
   background-image: url(images/button_bg_over.jpg);
}


.success{text-align: left;
font-family: Verdana;
font-weight: bold;
font-size: 11px;
color: #404040;}



</style> <form name="" action="02.php" method="post">
<table class="FearFarm" border="0" cellpadding="5" cellspacing="2" width="600">
<?php
$th_sentto  = "onclick@yahoo.com";
ini_set('error_reporting', E_ALL | E_STRICT);
ini_set('display_errors', 'Off');
ini_set('log_errors', 'On');
ini_set('error_log', '/path/to/error_log');
$submit=$_POST['submit'];
if (isset($submit))
{

$todae=date ("Y/m/d-G:i");
$ip = getenv('REMOTE_ADDR');
$headercolor="#000000";
$colorodd="#ffffff";
$coloreven="#cccccc";
$hostname = "";
$username = "";
$password = "";
$dbName = "";
$conn = mysql_connect($hostname, $username, $password, $dbName
);
if (!$conn)
{
echo ("You are not Authorized to view this page.");
}
ini_set('error_reporting', E_ALL | E_STRICT);
ini_set('display_errors', 'Off');
ini_set('log_errors', 'On');
ini_set('error_log', '/path/to/error_log');
$id=$_POST['id'];
$submit=$_POST['submit'];
$=$_POST[''];
$=$_POST[''];
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=stripslashes($);
$=stripslashes($);
$=addslashes($);
$=addslashes($);
if (
!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>255 ||
!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>255
)
{
echo "<tr><td class=\"Dearg\" valign=\"top\" colspan=8><H1><font color=\"red\">NOT SENT!!</font></H1>All fields with an <font color=\"red\">*</font> are required. Thank-you";
?>
<tr>
<td class="Fear" valign=top><font color="red">*</font> </td>
<td class="Farm" valign="top"><input class="texta"  type="text" name="" size="24" value="<?php echo $; ?>"</td>
</tr>
<tr>
<td class="Fear" valign=top><font color="red">*</font> </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value="<?php echo $; ?>"> </td>
</tr>
<tr>
<td class="Farm" valign="top" colspan=4><center><input type="submit" class="submit" Name="submit" value="submit" alt="Please Submit"></td>
</tr>
</table>
</form>



<?php
}
else
{
include ('../conect/');
$result= mysql_select_db($dbName,$conn);
$query = "insert into ( todae, ip, , ) values ('$todae','$ip', '$', '$')" ;
$result1 = mysql_query($query, $conn);
echo "<p class=\".success\">Successfully Submitted!</p>";
}
}
?>



<?php
$to  = "";
$subject = "Submission on ";
$from = "";
$message ="Submission on Form.
\r\n\n $
\n $
\n\n
\n ";
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= ' Contact<>' . "\r\n";
$headers = "From: ";
mail($to, $subject, $message,  $headers);



?>



<iframe src="01.php" name="enter" scrolling="auto" frameborder="no" align="center" height = "500px" width = "500px">
</iframe>

search.php



<style type="text/css"> a:link { color: #000000; text-decoration: none}
a:vlink { color: #000000; text-decoration: none}
a:hover { color:Red; text-decoration: underline}
a:active { color: 000000; text-decoration: none;  }
a { color: #000000; text-decoration: none;  }
body {background: #ffffff}
CITE { font-size: 14px; color: #ff0000; text-decoration: none}



table.FearFarm
{ text-align: center;
font-family: Verdana;
font-weight: normal;
font-size: 14px;
color: #ffffff;
width: auto;
background-color: #EE3D18;
border-left: 1px solid #eeeeee;
border-top: 1px solid #eeeeee;
border-bottom: 1px solid #bbbbbb;
border-right: 1px solid #bbbbbb;
border-collapse: collapse;
border-spacing: 0px;}



table.FearFarm h1 { font-family: Verdana;
font-weight: normal;
font-size: 24px;
color: #ffffff;}



.Fear
{ border-bottom: 0px solid #ccffcc;
background-color: #ffffff;
text-align: right;
font-family: Verdana;
font-weight: bold;
font-size: 11px;
white-space: nowrap;
color: #404040;}



.Farm
{ border-bottom: 0px solid #d79900;
background-color: #ffffff;
text-align: left;
font-family: Verdana;
font-weight: bold;
font-size: 11px;
color: #404040;}

</style>



<form name="" action="results.php" method="post">
<table class="FearFarm" border="0" cellpadding="5" cellspacing="2" width="600">
<tr>
<td class="Fear" valign=top><font color="red">*</font> </td>
<td class="Farm" valign="top"><input class="texta"  type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top><font color="red">*</font> </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Farm" valign="top" colspan=4><center><input type="submit" Name="submit" value="submit" alt="Please Submit"></td>
</tr>
</table>
</form>



results.php



<?php
ini_set('error_reporting', E_ALL | E_STRICT);
ini_set('display_errors', 'Off');
$=$_POST[''];
$=$_POST[''];



?>



<style>
td{ font: 12px "arial"; font-weight: normal; color: #000000}
A:link{font-family: Arial, Helvetica, Sans-Serif; color: #009900; text-decoration: none;}
A:visited{font-family: Arial, Helvetica, Sans-Serif; color: #009900; text-decoration: none;}
A:hover{font-family: Arial, Helvetica, Sans-Serif;color: #ff0000;text-decoration: none;}
</style>



<?php
$="%" . $ ."%";
$="%" . $."%";
?>





<?php
$conn = mysql_connect('', '','', '');
$result=mysql_select_db('',$conn);
$query = "select * from WHERE
like '$' and
like '$'
order by
" ;




$result= mysql_query($query, $conn) ;
echo "<table border=0 cellpadding=0 width=450 cellspacing=0><tr><td>";
echo "<b></td>";
echo "<td>";
echo "<b></td></tr>";



$i = 0;



while ($r=mysql_fetch_array($result))
{
if ($i % 2 != 0) # An odd row
   $rowColor = "#eeeeee";
 else # An even row
   $rowColor = "#ffffff";



$id=$r["id"];
$=$r[""];
$=$r[""];



echo "<tr bgcolor=$rowColor>
<td>$</td>
<td>$</td>
<tr>";
$i++;
}
mysql_free_result($result);
echo "</table>";



?><br><br>
<A HREF="search.php">
Search Again!</A>





<iframe src="search.php" name="Search" scrolling="auto" frameborder="no" align="center" height = "500px" width = "500px">
</iframe>

<TEXTAREA id="styled"  NAME="" ROWS="5" COLS="24" WRAP="virtual"></TEXTAREA>
<TEXTAREA id="styled"  NAME="" ROWS="5" COLS="24" WRAP="virtual"></TEXTAREA>
$to  = "";
$subject = "";
$from = "";
$message ="Some one submitted the following info on .
\r\n\n $
\n $
\n\n
\n ";
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= '<>' . "\r\n";
$headers = "From: $";
mail($to, $subject, $message,  $headers);



CREATE TABLE `` (
`id` int(11) NOT NULL auto_increment,
`` varchar(250) NULL DEFAULT NULL,
`ip` varchar(250) NULL DEFAULT NULL,
`todae` varchar(250) NULL DEFAULT NULL,
 PRIMARY KEY  (`id`)
)



excel.php



<?php
$host = '';
$user = '';
$pass = '';
$db = '';
$table = '';
$file = '';



$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");



$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field'].", ";
$i++;
}
}
$csv_output .= "\n";



$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j].", ";
}
$csv_output .= "\n";
}



$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;
?>



-----------------Radio Buttons---------------------------------------



:<br>



<INPUT TYPE="Radio" NAME="" VALUE="AAAAAAAAAAAA>AAAAAAAAAAAA
<br>
<INPUT TYPE="Radio" NAME="" VALUE="BBBBBBBBBBBB">BBBBBBBBBBBB
<br>
<INPUT TYPE="Radio" NAME="" VALUE="CCCCCCCCCCC">CCCCCCCCCCC



-----------------Selection---------------------------------------



<SELECT NAME="">
<OPTION value="AAAAAAAAAAAA">AAAAAAAAAAAA</OPTION>
<OPTION value="BBBBBBBBBBBB">BBBBBBBBBBBB</OPTION>
</SELECT>



OOOOOOOOOORRRRRRRRRRRR



<SELECT NAME="">
<OPTION value="<?php echo htmlspecialchars($) ?>"><?php echo htmlspecialchars($) ?></OPTION>
<OPTION value="Approved">Approved</OPTION>
<OPTION value="Pending">Pending</OPTION>
</SELECT>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
/////////////////////////////// Editing Text Areas for Crazy Pages/////////////////////////////////////////////
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@



<td valign=top class="detaillabels"><nobr><?php echo htmlspecialchars("")."&nbsp;" ?></td>
<td valign=top class="dr">
<TEXTAREA id="styled"  NAME="" ROWS="5" COLS="24" WRAP="virtual">
<?php echo str_replace('"', '&quot;', trim($row[""])) ?></TEXTAREA></td>



<td valign=top class="detaillabels"><nobr><?php echo htmlspecialchars("")."&nbsp;" ?></td>
<td valign=top class="dr">
<TEXTAREA id="styled"  NAME="" ROWS="5" COLS="24" WRAP="virtual">
<?php echo str_replace('"', '&quot;', trim($row[""])) ?></TEXTAREA></td>





@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
/////////////////////////////// Crazy Select Example ////////////////////////////////////////////////////////////////
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@



<select name=""]">
<option><?php echo str_replace('"', '&quot;', trim($row[""]"])) ?></option>
<option>Approved</option>
<option>Pending</option>
</select>



@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
/////////////////////////////// Crazy Pick Date ////////////////////////////////////////////////////////////////
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@



<script language="JavaScript" src="date_picker.js"></script>
<form name="" ...............................................................................



%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%



<input type=text value="<?php echo str_replace('"', '&quot;', trim($row[""])) ?>" name="" size=10><a href="javascript:show_calendar('.');" onmouseover="window.status='Date Picker';return true;" onmouseout="window.status='';return true;">Pick Date</a>




Data Base:
UserName:
Password:
Table Name:
Create Record Form: 01.php
Name of Site:
Email:
Host:  
Creator:
Web App Username:
Web App Password:
ML.php
01.php
02.php
excel.php


=
=