$value ) {
$requestStr.=$key . " : " . $value . "\n";
error_log ( $key . " : " . $value . "
\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));
}
?>
|