Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
css	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
photocopy	[ DIR ]	drwxrwxr-x
plugins	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
Registrationpage.html	5.54 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
barcode_test.php	1.8 KB	-rwxr-xr-x
cconfig.php	1.51 KB	-rwxr-xr-x
getdata.php	3.25 KB	-rwxr-xr-x
index.html	17.62 KB	-rwxr-xr-x
index_old.html	4.82 KB	-rwxr-xr-x
resume_det.php	2.59 KB	-rwxr-xr-x
resume_det_old.php	2.95 KB	-rwxr-xr-x
resume_det_old1.php	1.73 KB	-rwxr-xr-x
update.php	740 B	-rwxr-xr-x
upload_file.php	763 B	-rwxr-xr-x

Code Editor : getdata.php

<?php

$loc=$_POST['location'];
$stat=$_POST['status'];
$mdate=$_POST['mdate'];
$txtrem=$_POST['txtrem'];

//var_dump($mdate);
//die();

$servername = "logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com";
$username   = "admin";
$password  = "Logisys2104";

$conn = new  mysqli($servername,$username,$password);
if(!$conn) 
{
    die("Connection failed: " . mysqli_connect_error());
}

$db = "logisys3_comexam";

error_reporting(E_ALL);
ini_set('display_errors', 'on');

if($mdate=='')
{
    $cnd="";
}
else
{
    $cnd="and date_format(fintdate,'%d/%m/%Y')='$mdate'";
}

$query  = "SELECT * FROM {$db}.jobdet
WHERE ifnull(fdeleted,'')  <> 'T' and fpreferloc like '$loc%' and  fstatus like '$stat%' and ifnull(fremarks,'') like '%$txtrem%' $cnd
group by  fmobile
order by fintdate desc";

$result = mysqli_query($conn, $query);
$count = mysqli_num_rows($result);

$table = '
    <table style="margin-left:2px;text-align: left;width: 100%;font-size:14px;margin: auto;" align-self="middle" cellspacing="1" cellpadding="5" border="0" align="center" bgcolor="#505151">

<th width="8%"><center>Sl. No.</center></th>
             <th ><center style="width: 100px">Name</center></th>
             <th><center>Mobile No.</center></th>
             <th><center>Email Id</center></th>
             <th width="30%"><center>Preferred Location</center></th>
             <th ><center style="width: 100px">Applied Date</center></th>
             <th width="25%"><center>Resume</center></th>
             <th width="25%"><center> Status </center></th>
             <th width="25%"><center> Remarks </center></th>
             <th width="25%"><center> Action </center></th>
			</tr>
        
            </thead>';	
$i = 0;

if($count > 0)
{
    $Statarr=array('Pending','Not Interested','1st Round','2nd Round','3rd Round','Selected','Rejected');

while($row = mysqli_fetch_assoc($result))
    {
        $table .= "<tr bgcolor='#ffffff' >";
        $table .= "<td><center>".++$i."</center></td>";
        $table .= "<td>".$row['fname']."</td>";
        $table .= "<td>".$row['fmobile']."</td>";
        $table .= "<td>".$row['femail']."</td>";
        $table .= "<td>".$row['fpreferloc']."</td>";
        $table .= "<td>".$row['fintdate']."</td>";
        $table .= "<td><a href='resumes/".$row['frespath']."' target = 'blank'>Resume</a></td>";
        $table .= "<td><center><select id='status_{$row['fmobile']}'>";
        
        foreach($Statarr as $value)
        {
            $Selected=($row['fstatus']==$value) ? "selected" : "";
            $table .= "<option ".$Selected." value='".$value."'>".$value."</option>";    
        }

$table .= "</select></center></td>";
        $table .= "<td><input type='text' value='".$row['fremarks']."' id='remarks_{$row['fmobile']}'></td>";
        $table .= "<td><button onclick='updatedata(".$row['fmobile'].")'>Update</button></td>";
        $table .= "</tr>";
    }
}
else
{
    $table .= "<tr bgcolor='#ffffff' >";
    $table .= "<td colspan='4'><center>No data found</center></td>";
}

// $subject = "{$row['funivname']} Statistics as on ".$row['fdate'];
echo $table;

${this.title}

Code Editor : getdata.php