$(element).removeClass(errorClass);
}
});
});
</script>
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$email = loadVariable("email", "");
$password = loadVariable("password", "");
$username = loadVariable("username", "");
$firstname = loadVariable("firstname", "");
?>
<style>
div.authError {
color: #FF0000;
float: right;
margin-bottom: 10px;
margin-right: -18px;
padding-left: 56px;
vertical-align: top;
}
</style>
<form action="manage.php" method="post" name="login" id="login">
<input type="hidden" name="p" id="p" value="login" />
<div id="login-error">
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$email = loadVariable("email", "");
$password = loadVariable("password2", "");
if ($email != "" || $password != "") {
$sql = "SELECT * FROM user WHERE email='{$email}' and password='******' and Status='1'";
$getLogin = $objDB->select($sql);
if (!empty($getLogin) && count($getLogin) > 0) {
$_SESSION["email"] = $getLogin[0]["email"];
$_SESSION["username"] = $getLogin[0]["firstname"];
$_SESSION["userid"] = $getLogin[0]["UserId"];
$sql = "update user set LastLogin = '******'Y-m-d H:i:s') . "' where UserId = '" . $_SESSION["userid"] . "'";
$update = $objDB->sql_query($sql);
$sql3 = "select * from shoppingcart where UserId='" . $_COOKIE['PHPSESSID'] . "'";
$rscart = $objDB->select($sql3);
$result2 = mysql_query($sql3);
for ($c = 0; $c < count($rscart); $c++) {
$cartid = $rscart[$c]['CartId'];
$sql1 = "update shoppingcart set UserId='" . $_SESSION["userid"] . "' where CartId='" . $cartid . "'";
mysql_query($sql1);
}
//$_SESSION["email"]=$email;
header("Location:index.php?p=SetExpressCheckout");
exit;
} else {
$_SESSION['nologin'] = "******";
$_SESSION['email'] = $email;
$_SESSION['password3'] = $password;
header("Location:" . $AbsoluteURL . "index.php?p=checkout");
<?php
$a = loadVariable("a", '');
$v = loadVariable("v", "");
$page_type = loadVariable("page_type", "");
$id = loadVariable("id", "0");
if ($a != '') {
switch ($a) {
case "get_link_content":
echo get_link_content($v);
break;
case 'delete':
delete_row($page_type, $id);
break;
case 'status':
status_change($page_type, $id);
break;
default:
echo "Error";
}
}
function delete_row($page_type, $id)
{
if (empty($page_type)) {
die(json_encode(array("error" => "Page Type not declared!!!")));
} else {
//Table information declaration
$table_info['site menu']['tbl'] = "site_menu";
$table_info['site menu']['key'] = "menu_id";
$table_info['site content']['tbl'] = "site_content";
$table_info['site content']['key'] = "content_id";
$content_excerpt = $rsAdmin[0]["content_excerpt"];
$seo_introductory_text = $rsAdmin[0]["seo_introductory_text"];
$seo_text = $rsAdmin[0]["seo_text"];
$content = $rsAdmin[0]["content"];
$content_orderr = $rsAdmin[0]["content_orderr"];
$content_uri = $rsAdmin[0]["content_uri"];
$status = $rsAdmin[0]["status"];
}
}
}
if ($a == "list") {
$SQL = "select * from site_content order by content_title";
$rsAdmin = $objDB->select($SQL);
$numPerPage = 10;
$iCount = count($rsAdmin);
$page = loadVariable("page", 1);
$totalPages = ceil($iCount / $numPerPage);
$start = $page * $numPerPage - $numPerPage;
$end = $numPerPage;
if ($end > count($rsAdmin)) {
$end = $iCount;
}
$SQL .= " LIMIT " . $start . " , " . $end;
$rsAdmin = $objDB->select($SQL);
}
?>
<style>
label {
display: inline-block;
width: 80px;
}
// no cookie is found
$varValue = $defaultValue;
// use the default value
}
}
setcookie($varName, $varValue, time() + $cookieLifetime);
// sets a cookie
return $varValue;
// returns the result
}
// initilize all variables
$distance = loadVariable("distance", 60);
$tension = loadVariable("tension", 10);
$mass = loadVariable("mass", 100);
$sag = loadVariable("sag", 1.5);
$angle = loadVariable("angle", 5.6);
?>
<html>
<head>
<title>Slackline Tension</title>
<link rel="manifest" href="manifest.json">
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<br>
<table id="input">
<form>
<tr>
<td><label for="tension">tension:</label></td>
<td><input id="tension" name="tension" type="number" step="0.1"
<?php
$p = loadvariable('p', '');
$a = loadvariable('a', '');
$AdminID = loadvariable('AdminID', '0');
$UserName = loadvariable('UserName', '');
$Password = loadvariable('Password', '');
$FirstName = loadvariable('FirstName', '');
$LastName = loadvariable('LastName', '');
$Email = loadvariable('Email', '');
$AdminRole = loadVariable("AdminRole", "");
$Status = loadvariable('Status', '');
$submit = loadvariable('submit', '');
$s = loadvariable('s', '');
if ($p == 'admin') {
if ($submit == 'Save') {
if ($a == 'add' && $AdminID == '0') {
$SQL = "select UserName from admin where UserName='******'";
$rsAdmin = $objDB->select($SQL);
if (count($rsAdmin) > 0) {
$error = "The supplied UserName already exists.Please select a unique UserName.";
?>
<html>
<head></head>
<body>
<form name="frm" id="frm" method="post" action="index.php">
<?
foreach($_POST as $Key=>$Value){
if($Key!="submit"){
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$PID = loadVariable("PID", "");
$id = loadVariable("id", "");
$value = loadVariable("value", "");
$DB = loadVariable("DB", "");
$FIELDSHOW = loadVariable("FIELDSHOW", "");
$sql = "UPDATE " . PROPERTY . " SET " . $id . "='" . inserttext($value) . "' where ID='" . $PID . "'";
$rsUpd = $objDB->sql_query($sql);
$SQL = "select " . $FIELDSHOW . " from " . $DB . " where " . $id . "='" . viewtext($value) . "'";
$rsDB = $objDB->select($SQL);
if ($id == "Status") {
if ($rsDB[0][$FIELDSHOW] == 0) {
echo "Inactive";
} elseif ($rsDB[0][$FIELDSHOW] == 1) {
echo "Active";
} elseif ($rsDB[0][$FIELDSHOW] == 2) {
echo "Postpond";
} elseif ($rsDB[0][$FIELDSHOW] == 3) {
echo "Canclled";
} elseif ($rsDB[0][$FIELDSHOW] == 4) {
echo "Sold to 3rd";
} elseif ($rsDB[0][$FIELDSHOW] == 5) {
echo "Sold to Bank";
}
} else {
echo $rsDB[0][$FIELDSHOW];
}
exit;
<script src="<?php
echo $AbsoluteURL;
?>
js/jquery.ui.core.js"></script>
<script src="<?php
echo $AbsoluteURL;
?>
js/jquery.ui.widget.js"></script>
<link href="css/jquery.fancybox.css?v=2.1.4" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="js/jquery.fancybox.pack.js?v=2.1.4"></script>
<script type="text/javascript" src="<?php
echo $AbsoluteURL;
?>
js/jquery.validate.js"></script>
<?php
$category_id = loadVariable("c", "");
?>
<div class="main-container holder">
<!-- grid-cols -->
<div class="grid-cols">
<!-- col67 -->
<div style="width:100%;" class="col67">
<div class="col-holder">
<?php
if ($category_id != '') {
global $objDB;
$where = "";
$result = $objDB->getDataArray('site_menu', 'menu_id', 'menu_name', 'menu_id');
echo "<h3>" . $result[$category_id] . "</h3>";
} else {
echo "<h3>All Products</h3>";
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$report = loadVariable("report", "");
$db = loadVariable("db", "");
$sql = "select * from " . $db;
$user = $objDB->select($sql);
?>
<script type="application/javascript" >
function getname(tablename)
{
location.href="index.php?p=report&db="+tablename;
}
</script>
<style type="text/css">
.hastable table a.btn span.ui-icon {
left:0.2em;
}
</style>
<div id="sub-nav"><div class="page-title" style="margin-left:520px;">
<?php
if (isset($val) && $val != '') {
$header = $val;
} else {
$header = 'Manage Reports';
}
?>
<h1><?php
<?php
$SubcategoryId = loadVariable("SubcategoryId", "");
$SizeId = loadVariable("SizeId", "");
$SQL = "select * from product where SubCategoryId='" . $SubcategoryId . "'";
$rsUser = $objDB->select($SQL);
for ($p = 0; $p < count($rsUser); $p++) {
$CategoryId = $rsUser[0]["CategoryId"];
if ($CategoryId == 1) {
$CategoryId = "Men";
} else {
$CategoryId = "Female";
}
}
echo "getbrand^_^";
?>
<div class="contain">
<?php
include "include/sidebar.php";
?>
<div class="contain_right" ">
<div class="h_line1"></div>
<div class="heading">
<?php
$SQL1 = "select * from subcategory where SubCategoryId =" . $SubcategoryId . "";
$rsUser1 = $objDB->select($SQL1);
$SQL1 = "select * from product_size where SizeId =" . $SizeId . "";
$rsUser2 = $objDB->select($SQL1);
$sql1 = "select * from product_qty where SizeId='" . $SizeId . "' and SubCategoryId =" . $SubcategoryId . "";
$rsp = $objDB->select($sql1);
echo "We found" . "  " . count($rsp) . "  " . "Products for" . "  " . $CategoryId . "  " . "Apparels" . "  " . $rsUser1[0]['SubCategory'] . "" . "  " . $rsUser2[0]['Size'];
<?php
$p = loadvariable('p', '');
$a = loadvariable('a', '');
$review_Id = loadvariable('review_Id', '');
$ProductId = loadvariable('ProductId', '');
$review_name = loadvariable('review_name', '');
$review_title = loadVariable('review_title', '');
$review_description = loadvariable('review_description', '');
$add_date = date('Y-m-d');
$status = loadvariable('status', '0');
if ($a == 'add') {
// add
$SQL = "insert product_review set ProductId ='" . inserttext($ProductId) . "',review_name ='" . inserttext($review_name) . "',review_title='" . inserttext($review_title) . "',review_description= '" . inserttext($review_description) . "',add_date='" . inserttext($add_date) . "',status= '" . inserttext($status) . "'";
$insert = $objDB->insert($SQL);
echo '1';
//header("Location:" . $AbsoluteURLAdmin . "index.php?p=manage_site_menu&a=edit&id=$lastid");
exit;
}
$pg = loadVariable("pg", "");
$bLoggedIn = loadVariable("bLoggedIn", "");
if ($bLoggedIn == 1) {
$pg = "home";
$_SESSION["session_adminID"] = $rsUser[0]['AdminID'];
header("location:index.php?pg='" . $pg . "'");
} else {
switch ($p) {
case 'login':
$heading = "Login";
switch ($a) {
case "login":
if (loadVariable("UserName", "") != "" && loadVariable("Password", "") != "") {
// Get user details
$SQL = "Select * from admin where UserName = '******' and Password = '******'";
$rsUser = $objDB->select($SQL);
if (count($rsUser) <= 0) {
$error .= "Your username or password is invalid, please try again.<br>";
} elseif ($rsUser[0]["Status"] != 1) {
$error .= "Your account is Inactive.<br>";
} else {
if ($rsUser[0]['Status'] == '1') {
$_SESSION["session_adminID"] = $rsUser[0]['AdminID'];
$sql = "update admin set LastLogin = '******'Y-m-d H:i:s') . "' where AdminID = '" . $_SESSION["session_adminID"] . "'";
$update = $objDB->sql_query($sql);
header("Location: index.php?p=home");
} else {
$error .= "Somthing Wrong.<br>";
}
}
<?php
$SubcategoryId = loadVariable("SubcategoryId", "");
$ColorId = loadVariable("ColorId", "");
$SQL = "select * from product where SubCategoryId='" . $SubcategoryId . "'";
$rsUser = $objDB->select($SQL);
for ($p = 0; $p < count($rsUser); $p++) {
$CategoryId = $rsUser[0]["CategoryId"];
if ($CategoryId == 1) {
$CategoryId = "Men";
} else {
$CategoryId = "Female";
}
}
echo "getbrand^_^";
?>
<div class="contain">
<?php
include "include/sidebar.php";
?>
<div class="contain_right" ">
<div class="h_line1"></div>
<div class="heading">
<?php
$SQL1 = "select * from subcategory where SubCategoryId =" . $SubcategoryId . "";
$rsUser1 = $objDB->select($SQL1);
$SQL1 = "select * from product_color where ColorId =" . $ColorId . "";
$rsUser2 = $objDB->select($SQL1);
$sql1 = "select * from product_qty where ColorId='" . $ColorId . "' and SubCategoryId =" . $SubcategoryId . "";
$rsp = $objDB->select($sql1);
echo "We found" . "  " . count($rsp) . "  " . "Products for" . "  " . $CategoryId . "  " . "Apparels" . "  " . $rsUser1[0]['SubCategory'] . "" . "  " . $rsUser2[0]['ColorName'];
require_once "utils/functions.php";
$objDB = new MySQLCN();
if (empty($_REQUEST['p'])) {
$page = "home.php";
} else {
if (isset($_REQUEST['p'])) {
$page = $_REQUEST['p'] . ".php";
} else {
$page = "home.php";
}
}
$p = loadVariable("p", "home");
if ($p == 'home') {
$a = loadVariable("a", "home");
} else {
$a = loadVariable("a", "");
}
$includeDir = "include/";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<title>X-Store Online Shop</title>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="<?php
echo $AbsoluteURL;
?>
images/x1.jpg" type="image/jpeg">
<link href="<?php
echo $AbsoluteURL;
?>
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$sz = loadVariable("Size", '');
$ProductId = loadVariable("ProductId", 0);
$maincategory = loadVariable('maincategory', '');
$brand = loadVariable('brand', '');
$product_type = loadVariable('product_type', '');
$price = loadVariable('price', '');
$productname = loadVariable('productname', '');
$file = loadvariable("file", "");
$description = loadVariable('description', '');
$priview = loadVariable('preview_audio', '');
$submit = loadvariable('submit', '');
$quantity = loadVariable('quantity', '');
if ($p == "product") {
if ($submit == 'Save') {
if ($a == "add") {
$product_str = "";
$audio_str = "";
$priview_str = "";
$product_image = upload("product_image", "images/Product_Image/", "jpg,png,bmp,gif");
$audio = upload("audio", "images/Product_audio", "mp3,amr,wav");
$priview = upload("priview", "images/Product_audio", "mp3,amr,wav");
$product_str = 'UNSET1.jpg';
if ($product_image[1] == "") {
$product_str = $product_image[0];
}
if ($audio[1] == "") {
$audio_str = $audio[0];
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$report = loadVariable("report", "");
?>
<style type="text/css">
.hastable table a.btn span.ui-icon {
left:0.2em;
}
</style>
<div id="sub-nav"><div class="page-title" >
<?php
if (isset($val) && $val != '') {
$header = $val;
} else {
$header = 'Category Inventory';
}
?>
<h1><?php
echo $header;
?>
</h1>
</div>
</div>
<div id="page-layout">
<div id="page-content">
<div id="page-content-wrapper" style="width:100%; margin-left:-10px;"> <div style="margin-top:20px;">
<b style="font-size:20px;">Gents Category Inventory:</b>
$paypal_email = '*****@*****.**';
//$paypal_email = '*****@*****.**';
//$return_url = 'http://boom-tools.in/missednotes/Paypal/payment-successful.php';
//$cancel_url = 'http://boom-tools.in/missednotes/Paypal/payment-cancelled.htm';
if (!isset($_POST['item_number']) && $_POST['item_number'] == 0) {
header("Location:index.php?err=ProductId required");
exit;
}
$sql = "SELECT * FROM `product` where ProductId='{$_POST['item_number']}' LIMIT 0 , 1";
$productDetails = $objDB->select($sql);
$productDetails = isset($productDetails[0]) ? $productDetails[0] : $productDetails;
//mark all pending status incomplete
$sql = "UPDATE `pd_transaction` SET `pd_transaction_status`='I' WHERE `pd_transaction_status`='P' AND pd_transaction_date < CURDATE()";
$objDB->edit($sql);
$email = loadVariable("pd_email", "");
$product_id = loadVariable("item_number", "");
$date = date('Y-m-d H:i:s');
$sql = "INSERT INTO `pd_transaction`(`pd_email`, `ProductId`, `pd_transaction_status`,`pd_transaction_date`) VALUES ('{$email}',{$product_id},'P','{$date}')";
$transactonid = $objDB->insert($sql);
//setting up pending transaction
//getItemDetail and make a entry with pending status!!!
$item_name = $productDetails['ProductName'];
$item_amount = $productDetails['ProductPrice'];
$return_url = 'http://localhost/choosy_kids/manage.php?p=postpayment&mode=' . base64_encode('c') . '&id=' . base64_encode($transactonid);
$cancel_url = 'http://localhost/choosy_kids/manage.php?p=postpayment&mode=' . base64_encode('i') . '&id=' . base64_encode($transactonid);
//$return_url = 'http://localhost/missednotes/manage.php?p=postpayment&mode=' . base64_encode('c') . '&id=' . base64_encode($transactonid);
//$cancel_url = 'http://localhost/missednotes/manage.php?p=postpayment&mode=' . base64_encode('i') . '&id=' . base64_encode($transactonid);
//$notify_url = 'http://localhost/missednote/Paypal/payments.php';
//$notify_url = 'http://boom-tools.in/missednotes/Paypal/payments.php';
//$paypal_url = "https://www.paypal.com";
$paypal_url = "https://www.sandbox.paypal.com";
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$CollarId = loadVariable("CollarId", 0);
$CollarName = loadVariable('CollarName', '');
$SQL = "SELECT * FROM admin WHERE AdminID='" . $_SESSION['session_adminID'] . "'";
$rsAdmin = $objDB->select($SQL);
if ($a == "") {
$a = 'list';
}
if ($a == "edit") {
if ($CollarId != 0) {
$SQL = "select * from product_collar where CollarId =" . $CollarId;
$rsUser = $objDB->select($SQL);
if (count($rsUser) > 0) {
$CollarId = $rsUser[0]["CollarId"];
$CollarName = $rsUser[0]["CollarName"];
}
}
}
if ($a == "list") {
$SQL = "select * from product_collar";
$rsUser = $objDB->select($SQL);
?>
<style type="text/css">
.hastable table a.btn span.ui-icon {
left:0.2em;
}
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$MaterialId = loadVariable("MaterialId", 0);
$MaterialName = loadVariable('MaterialName', '');
$SQL = "SELECT * FROM admin WHERE AdminID='" . $_SESSION['session_adminID'] . "'";
$rsAdmin = $objDB->select($SQL);
if ($a == "") {
$a = 'list';
}
if ($a == "edit") {
if ($MaterialId != 0) {
$SQL = "select * from product_material where MaterialId =" . $MaterialId;
$rsUser = $objDB->select($SQL);
if (count($rsUser) > 0) {
$MaterialId = $rsUser[0]["MaterialId"];
$MaterialName = $rsUser[0]["MaterialName"];
}
}
}
if ($a == "list") {
$SQL = "select * from product_material";
$rsUser = $objDB->select($SQL);
?>
<style type="text/css">
.hastable table a.btn span.ui-icon {
left:0.2em;
}
<?php
$ProductId = loadVariable("ProductId", "");
$a = loadVariable("a", "");
if ($a == 'delete') {
$No = loadVariable("No", "");
$sql1 = "delete from shoppingcart where ProductId='" . $ProductId . "' AND Size='" . $_REQUEST['sz'] . "'";
mysql_query($sql1);
$sql = "select * from shoppingcart";
$rspro = $objDB->select($sql);
echo "DELETE^_^" . $No . "^_^" . $_REQUEST['totid'] . "^_^" . count($rspro);
} elseif ($a == 'update') {
$Qyt = loadVariable("Qyt", "");
$sql = "UPDATE shoppingcart SET Quantity='" . $Qyt . "' where ProductId='" . $ProductId . "'";
mysql_query($sql);
}
?>
<?php
$a = loadVariable("a", '');
$p = loadVariable("p", "");
$email = loadVariable("email", "");
switch ($a) {
case 'check':
$query = "SELECT * FROM `user` WHERE `email` = '{$email}'";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
if ($num_rows > 0) {
$valid = "false";
} else {
$valid = "true";
}
echo $valid;
break;
}
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$TestimonialsID = loadVariable("TestimonialsID", 0);
$AutherName = loadVariable('AutherName', '');
$CompanyName = loadVariable('CompanyName', '');
$Testimonials = loadVariable('Testimonials', '');
$SQL = "SELECT * FROM admin WHERE AdminID='" . $_SESSION['session_adminID'] . "'";
$rsAdmin = $objDB->select($SQL);
if ($a == "") {
$a = 'list';
}
if ($a == "edit") {
if ($TestimonialsID != 0) {
$SQL = "select * from testimonials where TestimonialsID =" . $TestimonialsID;
$rsUser = $objDB->select($SQL);
if (count($rsUser) > 0) {
$TestimonialsID = $rsUser[0]["TestimonialsID"];
$AutherName = $rsUser[0]["AutherName"];
$CompanyName = $rsUser[0]["CompanyName"];
$Testimonials = $rsUser[0]["Testimonials"];
}
}
}
if ($a == "list") {
$SQL = "select * from testimonials Where 1=1 order by TestimonialsID DESC";
$rsUser = $objDB->select($SQL);
?>
<script type="text/javascript">
<?php
$SubcategoryId = loadVariable("SubcategoryId", "");
$BrandId = loadVariable("BrandId", "");
$SQL = "select * from product where SubCategoryId='" . $SubcategoryId . "'";
$rsUser = $objDB->select($SQL);
for ($p = 0; $p < count($rsUser); $p++) {
$CategoryId = $rsUser[0]["CategoryId"];
if ($CategoryId == 1) {
$CategoryId = "Men";
} else {
$CategoryId = "Female";
}
}
echo "getbrand^_^";
?>
<div class="contain">
<?php
include "include/sidebar.php";
?>
<div class="contain_right" ">
<div class="h_line1"></div>
<div class="heading">
<?php
$SQL1 = "select * from subcategory where SubCategoryId =" . $SubcategoryId . "";
$rsUser1 = $objDB->select($SQL1);
$SQL1 = "select * from product_brand where BrandId =" . $BrandId . "";
$rsUser2 = $objDB->select($SQL1);
$sql1 = "select * from product where BrandId='" . $BrandId . "' and SubCategoryId =" . $SubcategoryId . "";
$rsp = $objDB->select($sql1);
echo "We found" . "  " . count($rsp) . "  " . "Products for" . "  " . $CategoryId . "  " . "Apparels" . "  " . $rsUser1[0]['SubCategory'] . "" . "  " . $rsUser2[0]['BrandName'];
$a = loadVariable("a", "");
$ProductId = loadVariable("ProductId", 0);
$sz = loadVariable("Size", '0');
$CategoryId = loadVariable("CategoryId", '');
$SubCategoryId = loadVariable('SubCategoryId', '');
$offer = loadVariable('offer', '');
$brand = loadVariable('brand', '');
$size = loadVariable('size', '');
$color = loadVariable('color', '');
$design = loadVariable('design', '');
$material = loadVariable('material', '');
$collar = loadVariable('collar', '');
$file = loadVariable('file', '');
$quantity = loadVariable('quantity', '');
$price = loadVariable('price', '');
$productname = loadVariable('productname', '');
if ($a == "") {
$a = 'list';
}
if ($a == "edit") {
if ($ProductId != 0) {
$SQL = "select * from product where ProductId =" . $ProductId;
$rsUser = $objDB->select($SQL);
if (count($rsUser) > 0) {
$ProductId = $rsUser[0]["ProductId"];
$productname = $rsUser[0]["ProductName"];
$SubCategoryId = $rsUser[0]["SubCategoryId"];
$CategoryId = $rsUser[0]["CategoryId"];
$BrandId = $rsUser[0]["BrandId"];
$MaterialId = $rsUser[0]["MaterialId"];
$DesignId = $rsUser[0]["DesignId"];
<?php
$AdminID = loadVariable("AdminID", 0);
$UserName = loadVariable("UserName", "");
$Password = loadVariable("Password", "");
$FirstName = loadVariable("FirstName", "");
$LastName = loadVariable("LastName", "");
$Email = loadVariable("Email", "");
$AdminRole = loadVariable("AdminRole", "");
$IsAdmin = loadVariable("IsAdmin", "");
$Status = loadVariable("Status", 1);
$searchName = loadVariable("searchName", "");
$SearchAdminRole = loadVariable("SearchAdminRole", "");
$role = 'Super Admin';
$role_admin = 'Admin';
if ($a == "") {
$a = 'list';
}
if ($a == "list") {
$SQL = "select * from admin where ";
if ($searchName != '') {
$SQL .= "(FirstName LIKE '%" . $searchName . "%' OR LastName LIKE '%" . $searchName . "%' OR UserName LIKE '%" . $searchName . "%') and ";
}
$SQL .= " 1=1 order by AdminID ASC";
$rsAdmin = $objDB->select($SQL);
}
?>
<script type="text/javascript">
$(document).ready(function() {
/* Table Sorter */
$("#sort-table")
<?php
$ProductName = loadVariable("ProductName", "");
echo "result^_^";
$sql1 = "select * from product where ProductName LIKE '%" . $ProductName . "%'";
$rscat = $objDB->select($sql1);
?>
<div class="contain">
<?php
include "include/sidebar.php";
?>
<div class="contain_right" ">
<div class="h_line1"></div>
<div class="heading">
<?php
echo "We found" . "  " . count($rscat) . "  " . "Products for Apparels" . "  " . $ProductName;
?>
</div>
<div class="gallery_box" style="padding-bottom:5px;">
<div><?php
$sql = "select * from product_brand";
$rsbrand = $objDB->select($sql);
?>
Brand:<br /><select name="brand" onChange="funGetBrand(this.value,<?php
echo $rscat[$i]['SubCategoryId'];
?>
)" style="width:85px;">
<option value="">--select--</option>
<?php
for ($i = 0; $i < count($rsbrand); $i++) {
?>
<?php
$SubcategoryId = loadVariable("SubcategoryId", "");
$DesignId = loadVariable("DesignId", "");
$SQL = "select * from product where SubCategoryId='" . $SubcategoryId . "'";
$rsUser = $objDB->select($SQL);
for ($p = 0; $p < count($rsUser); $p++) {
$CategoryId = $rsUser[0]["CategoryId"];
if ($CategoryId == 1) {
$CategoryId = "Men";
} else {
$CategoryId = "Female";
}
}
echo "getbrand^_^";
?>
<div class="contain">
<?php
include "include/sidebar.php";
?>
<div class="contain_right" ">
<div class="h_line1"></div>
<div class="heading">
<?php
$SQL1 = "select * from subcategory where SubCategoryId =" . $SubcategoryId . "";
$rsUser1 = $objDB->select($SQL1);
$SQL1 = "select * from product_design where DesignId =" . $DesignId . "";
$rsUser2 = $objDB->select($SQL1);
$sql1 = "select * from product where DesignId='" . $DesignId . "' and SubCategoryId =" . $SubcategoryId . "";
$rsp = $objDB->select($sql1);
echo "We found" . "  " . count($rsp) . "  " . "Products for" . "  " . $CategoryId . "  " . "Apparels" . "  " . $rsUser1[0]['SubCategory'] . "" . "  " . $rsUser2[0]['DesignName'];
<?php
$a = loadVariable("a", "");
$UserName = loadVariable("q", "");
$UserName = trim($UserName);
$ScreenName = loadVariable("r", "");
$ScreenName = trim($ScreenName);
$CityName = loadVariable("s", "");
$CityName = trim($CityName);
$CategoryName = loadVariable("w", "");
$CategoryName = trim($CategoryName);
$DealSourceName = loadVariable("t", "");
$DealSourceName = trim($DealSourceName);
if ($a == "checkuser") {
if ($UserName != '') {
$SQL = "SELECT AdminID from admin WHERE UserName='******'";
$rsRes = $objDB->select($SQL);
if (count($rsRes) == 0) {
echo "CHK_USER^_^<span style='color:#00CC00'>Available</span>";
exit;
} else {
echo "CHK_USER^_^<span style='color:#FF0000'>Not Available</span>^_^1";
exit;
}
} else {
echo "CHK_USER^_^";
exit;
}
}
if ($a == "checkscreen") {
if ($ScreenName != '') {
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$CategoryId = loadVariable("CategoryId", 0);
$Category = loadVariable('Category', '');
$s = loadVariable("s", "");
if ($p == "category") {
if ($a == "add") {
$SQL = "INSERT INTO category SET Category='" . inserttext($Category) . "'";
$inserttextproperty = $objDB->insert($SQL);
$success = "Category Added SuccessFully";
$_SESSION['success'] = $success;
$_SESSION['check'] = 'add';
header("Location:" . $AbsoluteURLAdmin . "index.php?p=" . $p);
exit;
} elseif ($a == "update") {
$SQL = "UPDATE category SET Category='" . inserttext($Category) . "' where CategoryId ='" . $CategoryId . "'";
$updatetextproperty = $objDB->sql_query($SQL);
$success = "Category Updated SuccessFully";
$_SESSION['success'] = $success;
$_SESSION['check'] = 'add';
header("Location:" . $AbsoluteURLAdmin . "index.php?p=" . $p);
exit;
}
if ($a == "delete") {
$SQL = "delete from category where CategoryId='" . $CategoryId . "'";
$rspropertydel = $objDB->sql_query($SQL);
$success = "Category Deleted SuccessFully";
$_SESSION['success'] = $success;
$_SESSION['check'] = 'add';
<?php
$p = loadVariable("p", "");
$a = loadVariable("a", "");
$SubCategoryId = loadVariable("SubCategoryId", 0);
$CategoryId = loadVariable("CategoryId", '');
$SubCategory = loadVariable('SubCategory', '');
$maincategory = loadVariable('maincategory', '');
$SQL = "SELECT * FROM admin WHERE AdminID='" . $_SESSION['session_adminID'] . "'";
$rsAdmin = $objDB->select($SQL);
if ($a == "") {
$a = 'list';
}
if ($a == "edit") {
if ($SubCategoryId != 0) {
$SQL = "select * from subcategory where SubCategoryId =" . $SubCategoryId;
$rsUser = $objDB->select($SQL);
if (count($rsUser) > 0) {
$SubCategoryId = $rsUser[0]["SubCategoryId"];
$SubCategory = $rsUser[0]["SubCategory"];
$CategoryId = $rsUser[0]["CategoryId"];
}
}
}
if ($a == "list") {
$SQL = "select * from subcategory";
$rsUser = $objDB->select($SQL);
?>
<style type="text/css">
