1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
<?php
include 'config.php';
// Check if the user is logged in
if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1'))
{
header("Location: login.php");
exit;
}
require("configure.php");
$procatid = $_GET['procatid'];
?>
<!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">
<head>
<meta http-equiv="x-ua-compatible" content="ie=7"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Content Management System (CMS)</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<!-- Main Menu -->
<link rel="stylesheet" type="text/css" href="css/menu.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="js/ddaccordion.js"></script>
<script type="text/javascript" src="js/menuddaccordion.js"></script>
<!-- End Main Menu -->
<script type="text/javascript">
function Deletepdcategory(procatid,prosubid)
{
if (confirm("Are you sure you want to delete?"))
{
window.location.href = 'product_cat_delete.php?procatid='+procatid+'&prosubid='+prosubid;
}
}
</script>
<script type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<table width="1000" height="600" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" align="left" valign="top"><table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="left" valign="middle"> </td>
</tr>
<tr>
<td width="200" align="left" valign="top"><!-- Main Menu --><?php require("menu.php");?><!-- End Main Menu --></td>
</tr>
</table></td>
<td width="800" align="left" valign="top"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> </td>
<td width="100" align="center" class="icontxt"><a href="product_cat_addform.php?procatid=<?=$procatid?>"><img src="images/iconNew.png" alt="Add" width="32" height="32" border="0" /><br /> Add Category </a></td>
</tr>
</table></td>
</tr>
<tr>
<td class="pagetitletxt"> <b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle" /> Product Category </b></td>
</tr>
<tr>
<td><select name="procatid" onChange="MM_jumpMenu('self',this,0)">
<option value="product_cat_index.php?procatid=0" <? if (($procatid=='0') || ($procatid=='')) echo 'selected'; ?>>All</option>
<?php
$sql = "SELECT * from procat order by procattype ASC, procatsort ASC, procatid DESC ";
$result1 = mysql_query($sql) or die(mysql_error());
while ($row1 = mysql_fetch_array($result1,MYSQL_ASSOC))
{
?>
<option value="product_cat_index.php?procatid=<?=$row1{'procatid'}?>" <? if ($procatid==$row1{'procatid'}) echo 'selected'; ?> ><?=$row1{'procatname'}?></option>
<? } ?>
</select></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" class="msg"><?php echo $_GET['msg']; ?></td>
</tr>
<tr>
<td align="left" valign="middle"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="600" class="listtitletxt">Brand</td>
<td width="600" class="listtitletxt">Product Category</td>
<td width="600" class="listtitletxt">Sort</td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
</tr>
<?php
if (($procatid <> "0") && ($procatid <> "")) {
$sql = "SELECT * FROM prosub inner join procat on prosub.procatid = procat.procatid where procat.procatid = $procatid order by procat.procattype ASC, procat.procatsort ASC, procat.procatid DESC, prosub.prosubsort ASC, prosub.prosubid DESC ";
$result = mysql_query($sql);
} else {
$result = mysql_query("SELECT * FROM prosub inner join procat on prosub.procatid = procat.procatid order by procat.procattype ASC, procat.procatsort ASC, procat.procatid DESC, prosub.prosubsort ASC, prosub.prosubid DESC ");
}
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
print "<tr>";
print "<td class='listtxt' style='padding-left:5'> </td>";
print "<td class='listtxt' style='padding-left:5'>".$row{'procatname'}."</td>";
print "<td class='listtxt' style='padding-left:5'>".$row{'prosubtype'}."</td>";
print "<td class='listtxt' style='padding-left:5'>".$row{'prosubsort'}."</td>";
// Modify
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='product_cat_modifyform.php?procatid=".$row{'procatid'}."&prosubid=".$row{'prosubid'}."'\"><img src='images/btnModify.png' title='Modify' alt='Modify' hspace='2' border='0'></a></td>";
// Delete
print "<td class='listtxt' align='center'><a href='#' onClick=\"Deletepdcategory(".$row{'procatid'}.", ".$row{'prosubid'}.")\"><img src='images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";
print "<td class='listtxt' align='center'></td>";
print "</tr>";
}
//mysql_close($dbh);
?>
</table></td>
</tr>
</table>
</td></tr>
</table>
</body>
</html>
|