Google

Edit File: view_all_menu.php

<?php
include 'session.php';
ini_set("display_errors", 0);
include 'reader.php';
//$dbl = new ConDB();
$sessionQuery = "select username from admin_pass";

//$sessionResult = mysql_query($accQry, $db1->conn);

if(!$sessionResult = $db1->db->query($sessionQuery)){
 die('There was an error running the query [' . $db1->db->error . ']');
}
$row = $sessionResult->fetch_assoc();

//$row = mysql_fetch_assoc($sessionResult);
//if ($row['session'] == $_SESSION["keys"]) {
//} else {
//$row = $sessionResult->fetch_assoc();
if ($row['username'] == $_SESSION["keys"]) {
} else {

// header("Location: login.php");
}

$event_id1 = $_GET['event_id'];
$brand_id1 = $_GET['brand_id'];
?>
<?php

if (isset($_POST["submit_brand"])) //('".$checkbox1[$i]."')";

{  
     
	$checkbox1=$_POST["chk1"];

$removeMap = "delete from event_menu_map where event_id='$event_id1' and brand_id='$brand_id1' ";	
        if(!$result_new = $db1->db->query($removeMap)){
             die('There was an error running the query [' . $dbl->db->error . ']');  }

foreach($_POST["chk1"] as $chk2)

{                  // var_dump($_POST);
			//$chk = $chk2;

// 	$removeMap = "delete from event_vendor_map where event_id='$event_id1' ";
			// 	if(!$result_new = $db1->db->query($removeMap)){
			//                         die('There was an error running the query [' . $dbl->db->error . ']');

//                                          }
      
                      $in_ch= "insert into event_menu_map(event_id,menu_id,brand_id) values ('$event_id1','$chk2','$brand_id1')"; 
                       if(!$result_new1 = $db1->db->query($in_ch)){
                                     die('There was an error running the query [' . $dbl->db->error . ']');
                                                                       }

}
     // $result2 = mysql_query($in_ch, $db1->conn) or die  (mysql_error()) ;	
    
   
 // $in_ch= "insert into event(event_logo) values ('$chk')";  	
   //	 $result2 = mysql_query($in_ch, $db1->conn) or die  (mysql_error()) ;

//header("Location:events.php");
header("location: view_brands.php?event_id=$event_id1");

}

<html lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>Event Brands  </title>
	<link type="text/css" href="css/bootstrap.min.css" rel="stylesheet">
	<link type="text/css" href="css/bootstrap-responsive.min.css" rel="stylesheet">
	<link type="text/css" href="css/theme.css" rel="stylesheet">
	<link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet">
	<link type="text/css" href='http://fonts.googleapis.com/css?family=Open+Sans:400italic,600italic,400,600' rel='stylesheet'>
        <link type="text/css" href="css/admin_menu_edit.css" rel="stylesheet">
	<link type="text/css" href="css/switch.css" rel="stylesheet">
        <style type="text/css">
          #events_id  {
                color:#fff;
            }a:focus,a:hover{
	    	color:black;
		text-decoration:none; 
	   }
	   .dropdown-menu>li{ float:none; }
       
	 </style>
</head>
<body>

<div class="navbar navbar-fixed-top">
		<div class="navbar-inner">
			<div class="container" style="min-height: 50px;">
				
                            <a class="brand" href="merchant.php">
			  	 Pinnacle
			  	</a>
		
                          <ul style="list-style-type: none;text-decoration:none;color:black;float:right;padding-top:10px;">
        <li class="dropdown" style="padding-top:10px;">
          <a class="dropdown-toggle" role="button" data-toggle="dropdown" href="#" style="color:black;">
            <b><?php echo $login_session; ?></b><span class="caret"></span></a>
          <ul id="g-account-menu" class="dropdown-menu" role="menu">
            <li><a href="logout.php">Logout</a></li>
          </ul>
        </li>
      </ul>

</div>
		</div>
	</div>

<?php include ('menu.php'); ?>

</div>
                        </div><br />
                                <div class="row">
				<div>
					<div class="content">

<div class="module">
							<div class="module-head">
								<h3>Choose Item Name</h3>
                                                  
							</div>

<div class="module">
<div class="module-head">
								
							</div>
<div id="myModal" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
                        <div class="modal-header">
                            <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                            <h3 id="myModalLabel"></h3>
                        </div>
                        <div class="form-group col-sm-10 col-sm-offset-2" align="center">
			   <form  action="" method ="post">
	 	   
    <div class="form-group" id ="form1">
      <label class="control-label" for="name">Event Name:</label>
      <input type="text" class="form-control" id="email" placeholder="Name" name="event_name1" >
    </div>
    
    
   <br>
  
    <button type="submit" name="event_add" class="btn btn-default col-sm-12" style="width:50%;">Add</button>
	<br><br><br><br><br><br>
	
	
  </form>
  </div>
   </div>
   
  <div id="myModal1" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
                        <div class="modal-header">
                            <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                            <h3 id="myModalLabel"></h3>
                        </div>
                        <div class="form-group col-sm-10 col-sm-offset-2" align="center">
			   <form  action="" method ="post">
	 <div class="form-group" id ="form1">
      <label class="control-label" for="name">Event Id:</label>
      <input type="text" class="form-control" id="event_id" placeholder="Id" name="event_nameid" >
    </div>		   
    <div class="form-group" id ="form1">
      <label class="control-label" for="name">Event Name:</label>
      <input type="text" class="form-control" id="name_id" placeholder="Name" name="event_name" >
    </div>
  
    
   <br>
  
    <button type="submit" name="event_edit" class="btn btn-default col-sm-12" style="width:50%;">Submit</button>
	<br><br><br><br><br><br>
	
	
  </form>
  </div>
   </div>
   
   
   <div class="module-body table" >
   
					 
					<div class ="col-md-offset-3 col-md-3" > 
					 <form  action="" method ="post" enctype="multipart/form-data" align="">
			         <div class="checkbox"  >	   
     
   			<?php             
                              
                                  $qry = "select brand_id,event_id,menu_id from event_menu_map where event_id = '$event_id1' and brand_id='$brand_id1' ";
                              //    $result1 = mysql_query($qry, $db1->conn) ;
                                 
                         if(!$result2 = $db1->db->query($qry)){
                                    die('There was an error running the query [' . $dbl->db->error . ']');
                                                                       }

$accQry = "select name,id,price  from menu_items where brand_id='$brand_id1' ORDER BY name ASC";
                        
                        if(!$result3 = $db1->db->query($accQry)){
                                    die('There was an error running the query [' . $dbl->db->error . ']');
                                                                       }

$c=0 ;  $id =1 ;
								 
			                 		$mysearch = 1;			
					
				$i=1;		
			 $array_id = array();
			  while ($row = $result2->fetch_assoc())
			 { 
			 	//$id = $row['brand_id'];
			 	//$movies_id[$row['event_id']] = $row['brand_id'];
			 	 $array_id[] = $row['menu_id'];
			 	$i++;
			 }
			//  print_r($array_id);
       
        
						 
                    
                         
               
                     	 while ($row = $result3->fetch_assoc())
                     	{
                     	      // $row['brand_id']; 
                     	
                     	          foreach($array_id as $x => $x_value)
                     		 {    
                     	            $x_value; 	 
                     		    if($x_value == $row['id'])
                     		    {  
                     		    	$checked ="checked";
                     		 
                     		    	break;
                     		      
                     		      }
                   
                                 else 
                                
                                {  
                                      $checked ="";   
                     		
                                }
                        
                          
                             }
                     	      ?>
                     	        <label class="checkboxlists">  <input type="checkbox" value="<?php echo $row['id'] ;  ?>" name="chk1[]" <?php echo $checked; ?>  ><?php echo $row['name'] .' - (Rs. ' .$row['price'] .')';  ?></label>

<?php    
                      }   
                             
                      ?>      
                             
                        
                             
						 
						
						   					
						   				    	 	
        
					      
					
					
					
				  	               
   </div>
   <br><br><br><br><br><br>
    <button type="submit" name="submit_brand" class="btn btn-default col-sm-12" style="width:20%;margin-left: 2%;">Submit</button>
	
	
	
  </form>		
							
</div>

</div>
						</div>

<?php

// $deletequery = "delete from event_vendor_map where event_id = '$event_id1'";
 // $deleteresult = mysql_query($deletequery, $db1->conn) ; //or die  (mysql_error()) ;

?>
	
    
  
    <script src="scripts/jquery-1.9.1.min.js"></script>
	<script src="scripts/jquery-ui-1.10.1.custom.min.js"></script>
	<script src="js/bootstrap.min.js"></script>
	<script src="scripts/datatables/jquery.dataTables.js"></script>
	<script>
	$(document).ready(function() {
		$('.datatable-1').dataTable();
		$('.dataTables_paginate').addClass("btn-group datatable-pagination");
		$('.dataTables_paginate > a').wrapInner('<span />');
		$('.dataTables_paginate > a:first-child').append('<i class="icon-chevron-left shaded"></i>');
		$('.dataTables_paginate > a:last-child').append('<i class="icon-chevron-right shaded"></i>');
	} );
	  $('#myModal').on('show', function() {
var tit = $('.confirm-delete').data('title');

$('#myModal .modal-body p').html("Desea eliminar al usuario " + '<b>' + tit +'</b>' + ' ?');
var id = $(this).data('id'),
removeBtn = $(this).find('.danger');
})

$('.confirm-delete').on('click', function(e) {
e.preventDefault();

var id = $(this).data('id');
$('#myModal').data('id', id).modal('show');

});

function myFunction(event_id,event_name)

{
	  	  
	   	document.getElementById("event_id").value=event_id;
	      document.getElementById("name_id").value=event_name;
	      
	      $('#myModal1').modal('show');
	    // document.getElementById("merchant_id").style.display="none";
	     // document.getElementById("form2").style.display="none";
	      
   }

</script>
</body>