MAINHACK

Viewing / Editing File: add_expense_head.php

<?php

include('header.php');
$show=new Oops($db);

echo "<tr>
		<td>$count</td>
		<td>".$row['category']."</td>";
        ?>
        <td>
        <select name="exp_group" id="exp_group<?=$count?>" class="">
		<option value="">Choose</option>
	  <?php 
		 $stmt1=$show->readAll('expense_group');
		 $r1=$stmt1->rowCount();
		 if($r1>0){
         while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)){
	    	echo "<option value='".$row1['ep_group']."'";if($row['exp_group']==$row1['ep_group']) echo "selected"; echo ">".$row1['ep_group']."</option>";

}
			}
		?> 
		</select>
		<input type="hidden" id="id<?=$count?>" value="<?=$row['id']?>">
		</td>
  <script type="text/javascript">
   $(document).on("change", "#exp_group<?=$count;?>", function () {
   var exp_group=$('#exp_group<?=$count;?>').val();
   var id=$('#id<?=$count;?>').val();
    $.ajax({
    type: "POST",
    url: "ajax_check.php", // Name of the php files
    data: "exp_group="+exp_group+"&id="+id,
    async: false,
    global: false,
    success: function(result)
    {
    window.location.reload();
    }
    });

});

</script>
<?php 	echo "<td><a href='delete.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='label label-danger' onclick='return send();'>Delete</a>
		</td>
		</tr>";

++$count;
 }
}

?>						
			</tbody>
		</table>
                     </div>
                    </div>
</div>
            </div>
        </div>
<?php
if(isset($_POST['sub'])){

$table="expense_head";
	$col="category";
	$category=htmlentities(strip_tags($_POST['expense_head']));
    $r=$show->readwithdata($table,$col,$category);
    $num=$r->rowCount();
    if($num>0){
	
echo "<script>sweetAlert('Oops','Expense head Exists','error');</script>";

}else{
	$data=array(
    'category'=>htmlentities(strip_tags($_POST['expense_head'])),
    'exp_group'=>htmlentities(strip_tags($_POST['exp_group'])),
	);
	$r1=$show->insert('expense_head',$data);
echo "<script>sweetAlert('Ok','Expense head Added','success');window.location.href='".$_SERVER['request_uri']."'</script>";

}
}
?>	
<script src="js/bootstrap-datepicker.js"></script>
<script type="text/javascript">
            // When the document is ready
             $(document).ready(function(){
       $("#date").datepicker({
	   format: 'dd-mm-yyyy',
	   
	   });
	  
	 
       });
</script>
		
<?php

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: add_expense_head.php

Server Info

System Features

User Info