View file File name : subcategory-addf.php Content :<?php session_start(); include("../include/config.php"); include("../include/functions.php"); validate_admin(); $cat_id=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['cat_id']); if($_REQUEST['submitForm']=='yes'){ if($_REQUEST['id']==''){ if(count($_REQUEST['subcategory'])>0){ foreach($_REQUEST['subcategory'] as $key=>$val){ if($val!=''){ $subcat=mysqli_real_escape_string($GLOBALS['conn'],$val); $subArr=$obj->query("select * from $tbl_subcategory where cat_id='".$_REQUEST['cat_id']."' and subcategory='$subcat' "); if($obj->numRows($subArr)==0){ // echo "insert into $tbl_subcategory set cat_id='$cat_id',subcategory='$val',status=1"; $obj->query("insert into $tbl_subcategory set cat_id='".$_REQUEST['cat_id']."',subcategory='".ucfirst($subcat)."',status=1"); $subcat_id=mysql_insert_id(); generateSlug($subcat,$tbl_subcategory,$subcat_id); } } } $_SESSION['sess_msg']='Subcategory added sucessfully'; } header("location:subcategory-list.php?cat_id=".$_REQUEST['cat_id']); exit(); } } ?> <!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> <title><?php echo SITE_TITLE; ?></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="css/admin.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" language="javascript"> function validate(obj) { var fnameInput = document.getElementsByName('subcategory[]'); for (i=0; i<fnameInput.length; i++) { if (fnameInput[i].value == "") { alert('Complete all subcategory fields'); return false; } } } </script> </head> <body> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <?php include("header.php") ?> <script type="text/javascript"> $(document).ready(function(){ var counter = 1; $("#add").click(function(){ var tblid="addedfield_"+counter; $("#resultField").append('<table width="100%" border="0" cellspacing="0" cellpadding="0" id="'+tblid+'" ><tr><td align="right" class="paddBot11 paddRt14" width="275"><strong>Subcategory :</strong></td><td align="left" class="paddBot11"><input name="subcategory[]" type="text" size="36" value="" /></td></tr></table>'); counter++; }) $("#remove").click(function(){ counter=counter-1; var tblid="#addedfield_"+counter; $(tblid).remove(); }) }) </script> <tr> <td align="right" class="paddRtLt70" valign="top"> <table width="99%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="right" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="middle" class="headingbg bodr text14"> <em><img src="images/arrow2.gif" width="21" height="21" hspace="10" align="absmiddle" /></em>Admin: Add Subcategory For <?php echo getCategory($_REQUEST['cat_id']); ?> <span style="float:right; padding-right:10px;"> <input type="button" name="back" value="Back To Main Category" class="button" onclick="location.href='category-list.php'" /> <input type="button" name="add" value="View Subcategory" class="button" onclick="location.href='subcategory-list.php?cat_id=<?php echo $_REQUEST['cat_id']; ?>'" /></span> </td> </tr> <tr> <td height="100" align="left" valign="top" bgcolor="#f3f4f6" class="bodr"> <form name="frm" method="POST" enctype="multipart/form-data" action="" onsubmit="return validate(this)"> <input type="hidden" name="submitForm" value="yes" /> <input type="hidden" name="id" value="<?php echo $_REQUEST['id'];?>" /> <input type="hidden" name="cat_id" value="<?php echo $_REQUEST['cat_id'];?>" /> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td align="center" colspan="2" class="paddRt14 paddBot11"> <font color="#FF0000"><strong><?php echo $_SESSION['sess_msg']; $_SESSION['sess_msg']='';?></strong></font></td> </tr> <tr> <td width="23%" align="right" class="paddBot11 paddRt14"> </td> <td width="77%" align="left" class="paddBot11"></td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>Subcategory :</strong></td> <td align="left" class="paddBot11"><input name="subcategory[]" type="text" size="36" value="" /></td> </tr> <tr ><td colspan="2" id="resultField"></td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"> </td> <td align="left" class="paddBot11"> </td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"> </td> <td align="left" class="paddBot11"> <a href="javascript:void(0)" id="add"> <img src="images/add.png" title="Add More" border="0" /></a> <a href="javascript:void(0)" id="remove"> <img src="images/remove.png" title="Remove" border="0" /></a> </td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"> </td> <td align="left" class="paddBot11"> </td> </tr> <tr> <td width="23%" align="right" class="paddRt14 paddBot11"> </td> <td width="77%" align="left" class="paddBot11"> <input type="submit" name="submit" value="Submit" class="submit" border="0"/> <input name="Reset" type="reset" id="Reset" value="Reset" class="submit" border="0" /> </td> </tr> </table></form> </td> </tr> </table> </td> </tr> </table> </td> </tr> <?php include('footer.php'); ?> </table> </body> </html>