41 lines
1.9 KiB
PHP
41 lines
1.9 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include ('includes/functions.php');
|
|
include ('log_entry.php');
|
|
error_log ( "Start Printing Request Attributes" );
|
|
$requestStr="";
|
|
foreach ( $_REQUEST as $key => $value ) {
|
|
$requestStr.=$key . " : " . $value . "\n";
|
|
error_log ( $key . " : " . $value . "<br />\r\n" );
|
|
}
|
|
error_log ( "End Printing Request Attributes" );
|
|
save_log($requestStr,'Menu','SAVE','save_menu.php');
|
|
$menu_id = $_POST['menu_id'];
|
|
$menu_name =$_POST['menu_name'];
|
|
$menu_description = $_POST['menu_description'];
|
|
$menu_url = strtolower($_POST['menu_url']);
|
|
$parent_id = $_POST['parent_id'];
|
|
$disp_seq = $_POST['disp_seq'];
|
|
$icon_text = strtolower($_POST['icon_text']);
|
|
|
|
$does_exist = "select * from menu_master where menu_id = '".$menu_id."' ";
|
|
$result = @mysqli_query($conn,$does_exist);
|
|
|
|
if(mysqli_num_rows($result) > 0){
|
|
$query = "update menu_master set menu_name = '$menu_name',menu_description = '$menu_description',menu_url = LOWER('$menu_url'),parent_id = '$parent_id', disp_seq = '$disp_seq',icon_text = '$icon_text',modified_by = '".$_SESSION['user_id']."', last_modified= 'CURRENT_TIMESTAMP' where menu_id = '".$menu_id."' ";
|
|
|
|
}
|
|
else {
|
|
|
|
$query = "insert into menu_master set menu_id='$menu_id', menu_name = '$menu_name',menu_description = '$menu_description',menu_url = LOWER('$menu_url'),parent_id = '$parent_id', disp_seq = '$disp_seq',icon_text = '$icon_text',modified_by = '".$_SESSION['user_id']."', last_modified= 'CURRENT_TIMESTAMP' ";
|
|
error_log("MENU INSERTION QUERY::" .$query);
|
|
}
|
|
// INSERT INTO `menu_master`(`menu_id`, `menu_name`, `menu_description`, `menu_url`, `parent_id`, `disp_seq`, `icon_text`, `modified_by`, `last_modified`) VALUES ('3.3568','wert','wertyu','qwert',0.00,'','',1,CURRENT_TIMESTAMP )
|
|
if (!$result = @mysqli_query($conn,$query)) {
|
|
exit(mysqli_error($conn));
|
|
}
|
|
?>
|
|
|
|
<tr>
|
|
<td><input type="hidden" name="menu_id" id="menu_id" value="<?php echo $menu_id?>" /></td>
|
|
</tr>
|