[ MAINHACK ]

HOME

Viewing / Editing File: add_expense_group.php

<?php

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

?>

<script src="tinymce/tinymce.min.js"></script>
  <script>tinymce.init({ selector:'textarea' });</script>
		
        
          <div id="page-wrapper">
            <div class="row">
                <div class="col-lg-6">
                    
                    <div class="panel panel-default">
                        <div class="panel-heading">
						Add Expense Group                        
						</div>
                        <div class="panel-body">
                            <div class="row">
                                <div class="col-lg-6">
                                    <form role="form" method="post">
                                        <div class="form-group">
                                         <label>Expense Group</label>
                       
					<input type="text" name="ep_group" class="form-control" placeholder="Expense Group" required>
                     </div>
						<input type="submit" class="btn btn-primary" name="sub" value="submit">
						<button type="reset" class="btn btn-success">Reset Button</button>
					</form>
                      </div>
                       </div>
                        </div>
                    </div>
                     
                </div>
                <div class="col-lg-6">         <div class="tables">
                    
               <h3 class="title1">All Expense Group</h3>
					<div class="panel-body widget-shadow">
		<table class="table" id="example">
			<thead>
				<tr>
				<th>ID</th>
				<th>Expense Head</th>
				<th>Delete</th>
                                            
				</tr>
			</thead>
			<tbody>
	<?php
			
$count=1;
$sr='expense_group';
$stmt =$show->readAll($sr);
$num = $stmt->rowCount();
     
     if($num>0){
 
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];

echo "<tr>
		<td>$count</td>
		<td>".$row['ep_group']."</td>	
		<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_group";
	$col="ep_group";
	$category=htmlentities(strip_tags($_POST['ep_group']));
    $r=$show->readwithdata($table,$col,$category);
    $num=$r->rowCount();
    if($num>0){
	
echo "<script>sweetAlert('Oops','Expense Group Exists','error');</script>";

}else{
	$data=array(
    'ep_group'=>htmlentities(strip_tags($_POST['ep_group'])),
	);
	$r1=$show->insert('expense_group',$data);
echo "<script>sweetAlert('Ok','Expense Group 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');
?>

Server Info

Hostname: server05.hostinghome.co.in
Server IP: 192.168.74.40
PHP Version: 7.4.33
Server Software: Apache
System: Linux server05.hostinghome.co.in 3.10.0-962.3.2.lve1.5.81.el7.x86_64 #1 SMP Wed May 31 10:36:47 UTC 2023 x86_64
HDD Total: 1.95 TB
HDD Free: 677.64 GB
Domains on IP: N/A (Requires external lookup)

System Features

Safe Mode: Off
disable_functions: None
allow_url_fopen: On
allow_url_include: Off
magic_quotes_gpc: Off
register_globals: Off
open_basedir: None
cURL: Enabled
ZipArchive: Disabled
MySQLi: Enabled
PDO: Enabled
wget: Yes
curl (cmd): Yes
perl: Yes
python: Yes
gcc: Yes
pkexec: No
git: Yes

User Info

Username: itsweb
User ID (UID): 1619
Group ID (GID): 1621
Script Owner UID: 1619
Current Dir Owner: 1619