Section filter: All"; else echo "" . getSectionName ( $_GET ['section'] ) . ""; } $sql = "SELECT * FROM section order by name"; $result = mysql_query ( $sql ); echo 'All'; while ( $data = mysql_fetch_assoc ( $result ) ) { echo '' . $data ['name'] . ''; } ?>

select ( "select * from categories where id=" . $_GET ['cat'] ); $cat = $db->get_row ( $res, 'MYSQL_BOTH' ); } ?>

Category Name:

Parent Category: Top"; else echo "" . getCatName ( getParentCatId ( $_GET ['cat'] ) ) . ""; } $sql = "SELECT * FROM categories WHERE parent = '0' order by name"; $result = mysql_query ( $sql ); echo 'Top'; while ( $data = mysql_fetch_assoc ( $result ) ) { echo '' . $data ['name'] . ''; } ?>

Sorting

Section: " . getSectionName ( $cat ['section'] ) . ""; } $sql = "SELECT * FROM section order by name"; $result = mysql_query ( $sql ); echo 'Select Section'; while ( $data = mysql_fetch_assoc ( $result ) ) { echo '' . $data ['name'] . ''; } ?>

Banner:Only PNG,JPG,GIF are allowed

Brief<?=$cat ['brief']?>
"; ?> "; ?>

print_last_query(); } else { $banner = ""; } $id = $db->insert_sql ( "INSERT INTO `categories` (`name` ,`parent`,`section`,`brief`,`banner`,sorting) VALUES ('" . $_POST ['name'] . "', '" . $_POST ['parent'] . "','" . $_POST ['section'] . "','" . $_POST ['brief'] . "','" . $banner . "','" . $_POST ['sorting'] . "')" ); //$db->print_last_query(); print ""; exit (); } if (isset ( $_POST ['bt_update'] )) { if ($_FILES ['p1'] ['name'] != "") { $temp_name = $_FILES ['p1'] ['tmp_name']; $file_name = time () . "_" . $_FILES ['p1'] ['name']; $imagesFolder = "../uploads/"; $file_path = $imagesFolder . $file_name; $result = move_uploaded_file ( $temp_name, $file_path ); chmod ( $file_path, 0777 ); $banner = $file_name; //$db->print_last_query(); } else { $banner = $cat ['banner']; } $id = $db->update_sql ( "update `categories` set `name`='" . $_POST ['name'] . "' ,`parent`='" . $_POST ['parent'] . "',`section`='" . $_POST ['section'] . "',`brief`='" . $_POST ['brief'] . "',`banner`='" . $banner . "',sorting=" . $_POST ['sorting'] . " where id=" . $_GET ['cat'] ); //$db->print_last_query(); print ""; } if (isset ( $_GET ['del'] )) { $p = $db->select_one ( "select parent from categories where id=" . $_GET ['del'] ); if ($p == 0) { $res = $db->select ( "select * from categories where parent=" . $_GET ['del'] ); while ( $row = $db->get_row ( $res, 'MYSQL_BOTH' ) ) { $d = $db->delete ( "delete from categories where id=" . $row ['id'] ); //$db->print_last_query(); } } $id = $db->delete ( "delete from categories where id=" . $_GET ['del'] ); //$db->print_last_query(); print ""; } ?>