Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.git	[ DIR ]	drwxr-xr-x
PHPExcel	[ DIR ]	drwxr-xr-x
PaymentReports	[ DIR ]	drwxr-xr-x
Paytm	[ DIR ]	drwxr-xr-x
Reports	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
html_modules	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
maya-pdf	[ DIR ]	drwxr-xr-x
photocopy	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
src_12	[ DIR ]	drwxr-xr-x
tarka_pdf_latest	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
uapp	[ DIR ]	drwxr-xr-x
unilite	[ DIR ]	drwxr-xr-x
upload	[ DIR ]	drwxrwxrwx
.gitignore	42 B	-rwxr-xr-x
DbConnect.php	478 B	-rwxr-xr-x
MENU_BNU.php	2.52 KB	-rwxr-xr-x
admin-Copy.html	5.68 KB	-rwxr-xr-x
admin.html	9.87 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
appNotification.php	1.76 KB	-rwxr-xr-x
appdownlaodsum.php	5.53 KB	-rwxr-xr-x
barcode_test.php	2.99 KB	-rwxr-xr-x
bnu-menu.php	2.52 KB	-rwxr-xr-x
cconfig.php	1.51 KB	-rwxr-xr-x
cron_sendnotif.php	1.8 KB	-rwxr-xr-x
cronjob_sendnotif.php	2.25 KB	-rwxr-xr-x
cronjob_sendnotif_bcu.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_bnu.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_dud.php	1.74 KB	-rwxr-xr-x
cronjob_sendnotif_kus.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_rcu.php	2.11 KB	-rwxr-xr-x
database.php	444 B	-rwxr-xr-x
downloadbkp.php	527 B	-rwxr-xr-x
index.html	3.87 KB	-rwxr-xr-x
jpgtobase64.php	173 B	-rwxr-xr-x
menu.php	3.85 KB	-rwxr-xr-x
phpinfo.php	21 B	-rwxr-xr-x
rcub_cronjob_sendsms.php	554 B	-rwxr-xr-x
rcub_smspush.php	4.43 KB	-rwxr-xr-x
rcub_smspush_ra.php	2.14 KB	-rwxr-xr-x
re_cronjob_sendsms_rcu.php	5.24 KB	-rwxr-xr-x
result_sms_push_kus.php	4.68 KB	-rwxr-xr-x
rv_sendnotif_bcu.php	1.76 KB	-rwxr-xr-x
saveBarcodeDeatils.php	2.56 KB	-rwxr-xr-x
sendGridMail.php	1.29 KB	-rwxr-xr-x
send_result_kus.php	358 B	-rwxr-xr-x
sendnotif.php	1.25 KB	-rwxr-xr-x
sendnotif_dud.php	1.76 KB	-rwxr-xr-x
sendsms_05092020.php	4.34 KB	-rwxr-xr-x
sendsmsapi.php	814 B	-rwxr-xr-x
sendsmsbulk.php	845 B	-rwxr-xr-x
sendsmsmanual.php	367 B	-rwxr-xr-x
sendsmsroot.php	634 B	-rwxr-xr-x
signin.php	1.71 KB	-rwxr-xr-x
test.php	23 B	-rwxr-xr-x
upload-message-attachments.php	1.79 KB	-rwxr-xr-x
upload_file.php	1.11 KB	-rwxr-xr-x
upload_mc.php	1.62 KB	-rwxr-xr-x
upload_pc.php	3.39 KB	-rwxr-xr-x

Code Editor : upload_pc.php

<?php
require_once("/var/www/html/aws/aws-autoloader.php");
use Aws\S3\S3Client;

ini_set('max_input_time', 300);
ini_set('max_execution_time', 300);
include ("database.php");
$databse = "logisys3_comexam";

// $conn = new  mysqli(SERVERNAME,USERNAME,PASSWORD,$databse);
// if(!$conn) 
// {        
//     die("Connection failed: " . mysqli_connect_error());
// }

$get_data = "select * from dbname where ifnull(fdeleted,'') <> 'T'";

$result1=$conn->query($get_data);

if (mysqli_num_rows($result1) > 0) 
{
    // output data of each row
    $dbnames = array();
    while($row = mysqli_fetch_assoc($result1)) 
    {
        $dbnames[$row['FUNIVCODE']] = $row['FDBNAME'];
        $univname = $row['FUNIVNAME'];
        $ffolder = $row['FFOLDER'];
    }
}

mysqli_close($conn);

// var_dump($_POST['univcode']);

$user = json_decode($_POST['univcode'],true);

$univcode = $user['fcuruniv'];

$dbname = $dbnames[$univcode];

$pconn = new mysqli($servername, $username, $password, $dbname);

header("Access-Control-Allow-Origin: *");
header('Content-Type: multipart/form-data');
header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With, x-auth-origin, x-auth-token, x-auth-type");
$ds = DIRECTORY_SEPARATOR;
$date = date("dmYhis");
$file_resp = "";

if($_SERVER['REQUEST_METHOD'] == 'OPTIONS') { 
    die();
}
// var_dump($_FILES);
if (0 < $_FILES['fileField']['error']) {
    http_response_code(409);
    echo 'Error: ' . $_FILES['file']['error'] . '<br>';
    $file_resp = "Failed to upload file!";
} else {

$name = pathinfo($_FILES['fileField']['name'], PATHINFO_FILENAME);

$file_arr = explode('-', $name);
    $regcode = $file_arr[0].'-'.$file_arr[1].'-'.$file_arr[2];

$get_data = "select fregno,fqpcode, d.fmeyear, d.fmeexamtyp, r.fexamno  from res_stud r 
    inner join degree d on r.fdegree = d.fdegree and d.fexamno = r.fexamno 
    where fregcode = '{$regcode}' and fcorrtype = 'PC' and ifnull(r.fpaymentstatus,'') = 'success'";

$result1=$pconn->query($get_data);

if (mysqli_num_rows($result1) > 0) 
    {
        $row = mysqli_fetch_assoc($result1);
        
        $filename = $univcode.'_'.$row['fmeyear'].'_'.$row['fmeexamtyp'].'_'.$row['fregno'].'_'.$row['fqpcode'].'.pdf';
    
        $path = realpath(__DIR__) . $ds . 'photocopy' . $ds . $filename;

if(move_uploaded_file($_FILES['fileField']['tmp_name'], $path)){

$s3 = S3Client::factory(
                array(
                    'credentials' => array(
                        'key' => IAM_KEY,
                        'secret' => IAM_SECRET
                    ),
                    'version' => "latest",
                    'region'  => 'ap-south-1'
                )
            );

$test = $s3->putObject(['Bucket' => "university-photocopy", 'Key' => $filename, 'SourceFile' => $path]);

$update = "update res_stud set fxrpath = '{$filename}', fpcuser = '{$user['fuserid']}', fpcdate = now() 
            where fregcode = '{$regcode}' and fcorrtype = 'PC' and ifnull(fpaymentstatus,'') = 'success'";
            $result = $pconn->query($update);

$update = "update res_fee set fcorrtype = 'XR'
            where fregno = '{$row['fregno']}' and fexamno = '{$row['fexamno']}'";
            $result = $pconn->query($update);
        }
    }
}

mysqli_close($pconn);
echo $filename;

${this.title}

Code Editor : upload_pc.php