Moose Loose WordPress & Web Desigh Tools

*** Your Title Here ***

Data Base:
UserName:
Password:
Table Name:
Create Record Form: 01.php

Connector to the database: conect/ 82
Name of Site:
Email:
Host:
Creator:
Crazy Username:
Crazy Password:
Post: post.php 197
Get: get.php 107
FearDearg.css 286
Crazy Pages Users: cz.php 2270
Authorize Net Script: Aut.php 3652

=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
######################## Create Table in Database ########
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

CREATE TABLE `` (
`id` int(11) NOT NULL auto_increment,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` varchar(250) NULL DEFAULT NULL,
`` 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`)
)

CREATE TABLE `Users` (
`id` int(11) NOT NULL auto_increment,
`FD_First` varchar(250) NULL DEFAULT NULL,
`FD_Last` varchar(250) NULL DEFAULT NULL,
`FD_Username` varchar(250) NULL DEFAULT NULL,
`FD_Password` varchar(250) NULL DEFAULT NULL,
`FD_Email` varchar(250) NULL DEFAULT NULL,
`ip` varchar(250) NULL DEFAULT NULL,
`todae` varchar(250) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
)

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
################## Crazy Pages cz.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"];
?>

<td valign=top valign="top">
<?php
if (!login()) exit;
?><div style="float: right"><span class="op02 "><a href="cz.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 class="bd" width="100%"><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"; }

/*--------------------------------------------------------------Dup B-------------------------------------------------*/

$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="cz.php" method="post">
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><b>Find</b> </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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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><input type="checkbox" name="wholeonly"<?php echo $checkstr ?>>Whole words only</td>
</td>
<td> </td>
<td><input type="submit" name="action" value="Search Now"></td>
<td><a href="cz.php?a=reset">List All Records</a></td>
</tr>
</table>
</form>

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

</tr>
<?php
for ($i = $startrec; $i < $reccount; $i++)
{
   $row = mysql_fetch_assoc($res);
   $style = "dr";
   if ($i % 2 != 0) {
     $style = "sr";
   }
?>
<tr>
<td valign=top class="<?php echo $style ?>"><span class="op03 "><a href="cz.php?a=view&recid=<?php echo $i ?>">View</a></td>
<td valign=top class="<?php echo $style ?>"><span class="op03 "><a href="cz.php?a=edit&recid=<?php echo $i ?>">Edit</a></td>
<td valign=top class="<?php echo $style ?>"><span class="op03 "><a href="cz.php?a=del&recid=<?php echo $i ?>">Delete</a></td>

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Pick one below^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

                       <?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 != "")) {
                       $conn = mysql_connect("localhost", "", "");
                       mysql_select_db("");
                       $sql = "select FD_Password from Users where FD_Username='$login'";
                       $res = mysql_query($sql, $conn) or die(mysql_error());
                       $row = mysql_fetch_assoc($res) or $row = array(0 => "");;
                       if (isset($row)) reset($row);
                       if (isset($password) && ($password == trim(current($row)))) {
                       $_SESSION["logged_in"] = true;
                       }
                       else {
                       ?>

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^or^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

                       <?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 {
                       ?>

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Pick one of the Above^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

<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="cz.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)
{
?>

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

<?php function showpagenav($page, $pagecount)
{
?>
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><span class="op02 "><a href="cz.php?a=add">Add Record</a> </td>
<?php if ($page > 1) { ?>
<td><a href="cz.php?page=<?php echo $page - 1 ?>"><< Prev</a> </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="cz.php?page=<?php echo $j ?>"><?php echo $j ?></a></td>
<?php } } } else { ?>
<td><a href="cz.php?page=<?php echo $startpage ?>"><?php echo $startpage ."..." .$count ?></a></td>
<?php } } } ?>
<?php if ($page < $pagecount) { ?>
<td> <a href="cz.php?page=<?php echo $page + 1 ?>">Next >></a> </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="cz.php">Index Page</a></td>
<?php if ($recid > 0) { ?>
<td><span class="op02 "><a href="cz.php?a=<?php echo $a ?>&recid=<?php echo $recid - 1 ?>">Prior Record</a></td>
<?php } if ($recid < $count - 1) { ?>
<td><span class="op02 "><a href="cz.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="cz.php">Index Page</a></td>
</tr>
</table>

<form name="" enctype="multipart/form-data" action="cz.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="cz.php?a=add">Add Record</a></td>
<td><span class="op02 "><a href="cz.php?a=edit&recid=<?php echo $recid ?>">Edit Record</a></td>
<td><span class="op02 "><a href="cz.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="cz.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="cz.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("localhost", "", "");
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 ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` 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 ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` like '" .$filterstr ."') or
(`` 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).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .sqlvalue(@$_POST[""], true).",
" .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).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .sqlvalue(@$_POST[""], true).",
``=" .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;
}
?>

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
######################## feardearg01.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}

/*Gray to highlight various Navigation links*/
.bd {
background-color: #FDFDDE;
color: #000000;
font-family: Arial;
font-size: 12px;
}

/*Table Border*/
.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, Lables*/
.hr {
background-color: #EAF3FA;
color: #1D507D;
font-family: Arial;
font-size: 14px;
}

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

/*Headers*/
.th01{
height:1px;
background-color: #F7F6F1;
color: #ffffff;
font-family: Arial;
font-size: 14px;
background-repeat:no-repeat;
border: 0px solid black;
}

.th02{
height:80px;
background-color: #F7F6F1;
color: #000000;

font-family: Arial;
font-size: 14px;
background: #ffffff url(headerdir.jpg) fixed 0px 0px;
background-repeat:no-repeat;
border: 0px solid black;
}

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

a.hr:active {
color: #ff0000;
font-family: Arial;
font-size: 12px;
}

a.hr:visited {
color: #1D507D;
font-family: Arial;
font-size: 12px;
}

/*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;
}

.op01
a {
color: #EAF3FA;
text-decoration: none;
float: left;
background-image: url(buta.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:150px;
height:20px;
overflow: visible;
-moz-border-radius: 50px;
-webkit-border-radius: 50px;
-khtml-border-radius: 50px;
border-radius: 50px; }

.op01
a:hover {
color: #ffffff;
text-decoration: none;
float: left;
background-image: url(butb.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:150px;
height:20px;
overflow: visible }

.op02
a {
font-family: Arial;
font-size: 12px;
color: #EAF3FA;
text-decoration: none;
float: left;
background-image: url(buta.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(butb.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 }

.op03
a {
color: #EAF3FA;
text-decoration: none;
float: left;
background-image: url(buta.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:50px;
height:18px;
overflow: visible;
overflow: visible;
-moz-border-radius: 50px;
-webkit-border-radius: 50px;
-khtml-border-radius: 50px;
border-radius: 50px;
}

.op03
a:hover {
color: #ffffff;
text-decoration: none;
float: left;
background-image: url(butb.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:50px;
height:18px;
overflow: visible }

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
######################## get.php ########################
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

<?php
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');
$code=$_GET['code'];
$id=$_GET['id'];
$page=$_GET['page'];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=$_GET[''];
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);

$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
$=preg_replace("/[^a-z \d]/i", "", $);
?>

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
######################## post.php ########################
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

<?php
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[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=strip_tags($, '<p>, <br>');
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);
$=stripslashes($);

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;}

$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);

if (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}
elseif (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
echo "<tr><td class=\"Dearg\" valign=\"top\"><H1>Oooops</H1>Please go Back and Check Your Entry";
}

else
{
include ('conect/');
$result= mysql_select_db($dbName,$conn);
$query = "insert into (todae,ip,, , , , , , , , , , , , , , , , , , , ) values ('$todae','$ip','$', '$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$')" ;
$result1 = mysql_query($query, $conn);
echo "<center>Successfully Entered!</center>";
}
}
else
{ ?>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </td>
<td class="Farm" valign="top"><input class="texta" type="text" name="" size="24" value=""> </td>
</tr>
<tr>
<td class="Fear" valign=top>: </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="image" src="submit.png" Name="submit" value="submit" alt="Please Submit"></td>
</tr>
</table>
</form>
<?php
}
?>

<?php
$host = 'localhost';
$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;
?>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
######################## Text Areas --- For New Form ######################
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
######################## Textarea with Counter ########################
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

**********SCRIPT*************

*************************************

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter1)" onmouseover="return CountThis(myCounter1)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter1>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter2)" onmouseover="return CountThis(myCounter2)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter2>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter3)" onmouseover="return CountThis(myCounter3)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter3>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter4)" onmouseover="return CountThis(myCounter4)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter4>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter5)" onmouseover="return CountThis(myCounter5)" wrap=physical maxLength="255"></textarea>
<br><font color=#666666>(255 characters max.) <strong><SPAN id=myCounter5>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter6)" onmouseover="return CountThis(myCounter6)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter6>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter7)" onmouseover="return CountThis(myCounter7)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter7>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter8)" onmouseover="return CountThis(myCounter8)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter8>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter9)" onmouseover="return CountThis(myCounter9)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter9>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter10)" onmouseover="return CountThis(myCounter10)" wrap=physical maxLength="255"></textarea>
<br><font color=#666666>(255 characters max.) <strong><SPAN id=myCounter10>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter11)" onmouseover="return CountThis(myCounter11)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter11>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter12)" onmouseover="return CountThis(myCounter12)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter12>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter13)" onmouseover="return CountThis(myCounter13)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter13>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter14)" onmouseover="return CountThis(myCounter14)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter14>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter15)" onmouseover="return CountThis(myCounter15)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter15>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter16)" onmouseover="return CountThis(myCounter16)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter16>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter17)" onmouseover="return CountThis(myCounter17)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter17>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter18)" onmouseover="return CountThis(myCounter18)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter18>255</SPAN></strong> remaining</font>

<textarea name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter19)" onmouseover="return CountThis(myCounter19)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter19>255</SPAN></strong> remaining</font>

<textarea id="styled" name="" cols="50" rows="6" id="" onkeypress="return LimitThis()" onkeypress="return LimitThis()" onkeyup="return CountThis(myCounter20)" onmouseover="return CountThis(myCounter20)" wrap=physical maxLength="255"></textarea>
<font color=#666666>(255 characters max.) <strong><SPAN id=myCounter20>255</SPAN></strong> remaining</font>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
######################## Set Cookies ########################
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<?php
$Month = 2592000 + time();
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
setcookie(, $_POST[''], $Month);
?>

@@@@@@@@@@@@@@@@@@@@@@@@
###############WORDPRESS##############
###############WORDPRESS##############
###############WORDPRESS##############
###############WORDPRESS##############
###############WORDPRESS##############
###############WORDPRESS##############
@@@@@@@@@@@@@@@@@@@@@@@@

This goes in the wp-config.php ######### REMEMBER no dashes in field names!!!!!

<?php
$todae=date ("Y/m/d");
$ip = getenv('REMOTE_ADDR');
$hostname = "localhost";
$username = "";
$password = "";
$dbName = "";
$conn = mysql_connect($hostname, $username, $password, $dbName
);
if (!$conn)
{
echo ("You are not Authorized to view this page.");
}
?>

#########################################

This goes in the page template with form

<?php
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];

include ('wp-config.php');
$result= mysql_select_db($dbName,$conn);
$query = "insert into (todae,ip,, , , , , , , , , , , , , , , , , , , ) values ('$todae','$ip','$', '$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$')";
$result1 = mysql_query($query, $conn);
echo $yourmessage;
?>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
######################## Auto Emailer ########################
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

$to = "";
$subject = "";
$from = "";
$message ="Some one submitted the following info on .
\r\n\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n $
\n\n Gary
\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);

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
######################## Date Picker ########################
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

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

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
######################## Go Back Button #####################
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

echo "<br><FORM><INPUT TYPE=\"image\" src=\"goback.png\" onClick=\"history.back()\"></FORM>";

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
################## Form Elements ############################
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

---------------Multi....Checkboxes or multiple Selects--------------

foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);
foreach ($_REQUEST[''] as $);

<select multiple name="[ ]">
<option value="coke">CocaCola</option>
<option value="popcorn">Popcorn</option>
<option value="peanuts">Peanuts</option>
</select>

foreach($ as $value);
$a = implode(',' , $);
echo $a;

-----------------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/////////////////////////////////////////////
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
/////////////////////////////// Echos for Crazy Pages////////////////////////////////////////////////////////////////
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>
<?php echo htmlspecialchars($row[""]) ?>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
/////////////////////////////// Value for Crazy Pages////////////////////////////////////////////////////////////////
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>
<?php echo str_replace('"', '"', trim($row[""])) ?>

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

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

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

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

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
/////////////////////////////// Crazy Duplicate Feature ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Goes in get.php:

$dup=$_GET['dup'];

------------------------------------------------------------------------------------Dup A-----------------------------------------------------------------------

<?
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');
$dup=$_GET['dup'];
if (isset($dup)){
include ("get.php");
include ('conect/');
$result= mysql_select_db($dbName,$conn);
$query = "insert into (, , , , , , , , , , , , , , , , , , , ) values ('$ - $dup', '$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$')" ;
$result1 = mysql_query($query, $conn);
}
?>

------------------------------------------------------------------------------------Dup B-----------------------------------------------------------------------

if(isset($dup)){
$ordtype == "desc";
$ordtypestr = "desc"; }

------------------------------------------------------------------------------------Dup C-----------------------------------------------------------------------

------------------------------------------------------------------------------------Dup D-----------------------------------------------------------------------

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
/////////////////////////////// Authorize Net Script Aut.php /////////////////
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<?PHP
$post_url = "https://test.authorize.net/gateway/transact.dll";

$post_values = array(
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",
"" => "$",

"x_card_num" => "4007000000027",
"x_exp_date" => "0115",
"x_login" => "4QU8ub75MVH",
"x_tran_key" => "5p65cnT8kwP4L46S",
"x_version" => "3.1",
"x_delim_data" => "TRUE",
"x_delim_char" => "|",
"x_relay_response" => "true",
"x_type" => "AUTH_CAPTURE",
"x_method" => "CC",

);

$post_string = "";
foreach( $post_values as $key => $value )
{ $post_string .= "$key=" . urlencode( $value ) . "&"; }
$post_string = rtrim( $post_string, "& " );
$request = curl_init($post_url); // initiate curl object
curl_setopt($request, CURLOPT_HEADER, 0);
curl_setopt($request, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($request, CURLOPT_POSTFIELDS, $post_string);
curl_setopt($request, CURLOPT_SSL_VERIFYPEER, FALSE);
$post_response = curl_exec($request);
curl_close ($request);

$response_array = explode($post_values["x_delim_char"],$post_response);
$response_code=$response_array [0];
$that=$response_array [3];

echo $that;

if ($response_code==1){
include ('conect/');
$result= mysql_select_db($dbName,$conn);
$query = "insert into (todae,ip,, , , , , , , , , , , , , , , , , , , ) values ('$todae','$ip','$', '$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$')" ;
$result1 = mysql_query($query, $conn);
echo "<br><br>Yes!</center>";

}
else
{
echo "Something went Wrong";
}
?>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
/////////////////////////////// Multi Column Results /////////////////
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<table border=1 cellspacing="3" cellpadding="3">
<?php
include ('conect/');
$result=mysql_select_db($dbName,$conn);
$query = "select * FROM ";
$result = mysql_query($query) or die("There was a problem with the SQL query: " . mysql_error());
if($result && mysql_num_rows($result) > 0)
{
   $i = 0;
   $max_columns = 2;
   while($row = mysql_fetch_array($result))
  {
      extract($row);

      if($i == 0)
         echo "<tr>";
      if($ != "" && $ != null)
         echo "<td>$<br>$</td>";
      if(++$i == $max_columns)
      {
          echo "</tr>";
          $i=0;
      }
  }
}

if($i < $max_columns)
{
for($j=$i; $j<$max_columns;$j++)
echo "<td> </td>";
}
?>
</tr>
</table>

%%%%%%%%%%%%%%%%%%%%%%%%%%
############ XML.php ###########
%%%%%%%%%%%%%%%%%%%%%%%%%

<?php
error_reporting(0);
$submit=$_POST['submit'];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];
$=$_POST[''];

if(isset($submit)){
$file = ".xml";
$ROOT = simplexml_load_file($file) or die ("Yikes!!");
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";
$ROOT->CHANNEL->ITEM-> = "$";

file_put_contents($file, $ROOT->asXML());
}
?>

<?php
$file = ".xml";
$ROOT = simplexml_load_file($file) or die ("Yikes!");
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;
$=$ROOT->CHANNEL->ITEM->;

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
##################### .xml ############
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

<?xml version="1.0"?>
<ROOT>
<CHANNEL>
<ITEM>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>
<>FDearg</>

</ITEM>
</CHANNEL>
</ROOT>

@@@@@@@@@@@@@@@@@@@@@@@@
################## XML LOOP #############
@@@@@@@@@@@@@@@@@@@@@@@@

<?php
foreach ($ROOT->CHANNEL->ITEM as $) {
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
echo "<b>" .$->."<BR>";
}
?>

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
############## Getting and placing Variables ########
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>
<?php echo $; ?>

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
############## Index.php Put this in root of wp-admin ########
create a directory in the theme root called database for contents of you
created above
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

<?php
require_once('admin.php');
require_once(ABSPATH . 'wp-admin/includes/dashboard.php');
wp_dashboard_setup();
wp_enqueue_script( 'dashboard' );
wp_enqueue_script( 'plugin-install' );
wp_enqueue_script( 'media-upload' );
wp_admin_css( 'dashboard' );
wp_admin_css( 'plugin-install' );
add_thickbox();
$title = __('Dashboard');
$parent_file = 'index.php';
require_once('admin-header.php');
$today = current_time('mysql', 1);
?>
<?php include( TEMPLATEPATH . '/database/cz.php' ); ?>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@ User Crazy Userscz.php
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<td valign=top valign="top">
<?php
if (!login()) exit;
?><div style="float: right"><span class="op02 "><a href="cz.php?a=logout">Logout</a></div>
<div style="float: right"><span class="op02 "><a href="excel.php?a=logout">Excel</a></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;
}

mysql_close($conn);
?>
</td></tr></table>
<table class="bd" width="100%"><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"; }

/*--------------------------------------------------------------Dup B-------------------------------------------------*/

$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="Userscz.php" method="post">
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><b>Find</b> </td>
<td><input type="text" name="filter" value="<?php echo $filter ?>"></td>
<td>

</td>

<td><input type="checkbox" name="wholeonly"<?php echo $checkstr ?>>Whole words only</td>
</td>
<td> </td>
<td><input type="submit" name="action" value="Search Now"></td>
<td><a href="Userscz.php?a=reset">List All Records</a></td>
</tr>
</table>
</form>

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

</tr>
<?php
for ($i = $startrec; $i < $reccount; $i++)
{
   $row = mysql_fetch_assoc($res);
   $style = "dr";
   if ($i % 2 != 0) {
     $style = "sr";
   }
?>
<tr>
<td valign=top class="<?php echo $style ?>"><span class="op03 "><a href="Userscz.php?a=view&recid=<?php echo $i ?>">View</a></td>
<td valign=top class="<?php echo $style ?>"><span class="op03 "><a href="Userscz.php?a=edit&recid=<?php echo $i ?>">Edit</a></td>
<td valign=top class="<?php echo $style ?>"><span class="op03 "><a href="Userscz.php?a=del&recid=<?php echo $i ?>">Delete</a></td>

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

<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="Userscz.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)
{
?>

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

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

if ($pagecount > 1) {

   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="Userscz.php?page=<?php echo $j ?>"><?php echo $j ?></a></td>
<?php } } } else { ?>
<td><a href="Userscz.php?page=<?php echo $startpage ?>"><?php echo $startpage ."..." .$count ?></a></td>
<?php } } } ?>
<?php if ($page < $pagecount) { ?>
<td> <a href="Userscz.php?page=<?php echo $page + 1 ?>">Next >></a> </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="Userscz.php">Index Page</a></td>
<?php if ($recid > 0) { ?>
<td><span class="op02 "><a href="Userscz.php?a=<?php echo $a ?>&recid=<?php echo $recid - 1 ?>">Prior Record</a></td>
<?php } if ($recid < $count - 1) { ?>
<td><span class="op02 "><a href="Userscz.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="Userscz.php">Index Page</a></td>
</tr>
</table>

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

<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><span class="op02 "><a href="Userscz.php?a=add">Add Record</a></td>
<td><span class="op02 "><a href="Userscz.php?a=edit&recid=<?php echo $recid ?>">Edit Record</a></td>
<td><span class="op02 "><a href="Userscz.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="Userscz.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="Userscz.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("localhost", "Users", "");
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`,
`FD_First`,
`FD_Last`,
`FD_Username`,
`FD_Password`,
`FD_Email`
FROM `Users`";
if (isset($filterstr) && $filterstr!='' && isset($filterfield) && $filterfield!='') {
$sql .= " where " .sqlstr($filterfield) ." like '" .$filterstr ."'";
} elseif (isset($filterstr) && $filterstr!='') {
$sql .= " where
(`Id` like '" .$filterstr ."') or
(`FD_First` like '" .$filterstr ."') or
(`FD_Last` like '" .$filterstr ."') or
(`FD_Username` like '" .$filterstr ."') or
(`FD_Password` like '" .$filterstr ."') or
(`FD_Email` 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;

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

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

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

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

function sql_delete()
{
global $conn;

$sql = "delete from `Users` 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;
}
?>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@ Secure Code @@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<?php session_start();
if (!login()) exit;
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 != "")) {
$conn = mysql_connect("localhost", "", "");
mysql_select_db("");

>>>>>>>>>>>>>>>>>>>>>>>>
$sql = "select txn_id from woodward_pay where payer_email='$login'";
<<<<<<<<<<<<<<<<<

$res = mysql_query($sql, $conn) or die(mysql_error());
$row = mysql_fetch_assoc($res) or $row = array(0 => "");;
if (isset($row)) reset($row);
if (isset($password) && ($password == trim(current($row)))) {
$_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"])) { ?>

<table class="FearFarm" width=400 cellspacing="1" cellpadding="4" border=1>
<tr><td class="Fear">Username<td><input type="text" name="login" value="<?php echo $login ?>"></td></tr><tr><td class="Fear">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"];
}
function connect(){
$conn = mysql_connect("localhost", "", "");
mysql_select_db("");
return $conn;
}
?>
<a href="Trim.php">Tirm</a><br>
<a href="Trim.php?a=logout">Logout</a><br>

##############################################
##############################################
##############################################
##############################################
############### conact Form #################
##############################################
##############################################
##############################################
##############################################
##############################################

<form name="" action="<?php the_permalink(); ?>" method="post">
<table class="FearFarm" border="0" cellpadding="0" cellspacing="0" width="122">
<?php
ini_set('error_reporting', E_ALL | E_STRICT);
ini_set('display_errors', 'On');
ini_set('log_errors', 'On');
ini_set('error_log', '/path/to/error_log');
include ("post.php");
$fearfarmz="go";
echo "</div></div>";
$submit=$_POST['submit'];
if (($submit=='submit') && ($fearfarmz=='em'))
{
echo "<div id=\"em\"><font color=#ff0000>Your Message has not been sent. Required fields are marked with a *.</font></div>";
}
?>
<tr>
<td class="Farm" valign=top>
<?if (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
$fearfarmz="em";
echo "<font color=#ff0000>*</font> <font color=#000000></font>";
}else{
echo "<font color=#000000></font>";}
?></td>
</tr>

<tr>
<td class="Farm" valign=top>
<?if (!$_POST[''] || $_POST[''] == " " || strlen($_POST[''])>30)
{
$fearfarmz="em";
echo "<font color=#ff0000>*</font> <font color=#000000></font>";
}else{
echo "<font color=#000000></font>";}
?></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>
<?
if ($fearfarmz=='go')
{
$fearfarmz=$_POST['fearfarmz'];
include ("post.php");
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$=addslashes($);
$result= mysql_select_db($dbName,$conn);
$query = "insert into (todae,ip,, , , , , , , , , , , , , , , , , , , ) values ('$todae','$ip','$', '$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$','$')" ;$result1 = mysql_query($query, $conn);
echo "<div id=\"go\"><font color=#ff0000>Your Message has been sent!</font></div>";

$to = "";
$subject = "Contact";
$from = "";
$message ="$FD_First,$FD_Last,$FD_Email,$FD_Subject,$FD_Message.";
$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);

$to = "$FD_Email";
$subject = "Thanks for Contacting Us";
$from = "";
$message ="Thanks for sending your message via the contact form on our website. We will be getting back to you soon.";
$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);
}
$submit=$_POST['submit'];
if (($submit=='submit') && ($fearfarmz=='em'))
{

echo "<div id=\"em\"><font color=#ff0000>Your Message has not been sent. Required fields are marked with a *.</font></div>";
}
?>
<br>

#########################################
#########################################
#########################################
#########################################
######################################### townsend set up
#########################################
#########################################
#########################################
#########################################
#########################################
#########################################

<a href="../formpage?th_sentto=MOOSESENTTO&form=">MOOSESENTTO</a>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ I Frame Code
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<?php
$th_sentto=$_GET['th_sentto'];
$form=$_GET['form'];
?>
<iframe src="../FORMSPAGES/<?php echo $;?>01.php" name="frame1" scrolling="auto" frameborder="no" align="center" height = "500px" width = "500px">
</iframe>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 02.php
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

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

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

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 01.php
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@