Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.216.186 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/../lib/../home/u926327694/domains/nargundles.com/public_html/adminweb/ |
[ Home ] | [ C0mmand ] | [ Upload File ] |
---|
<?php $page_title = 'Import Result'; include 'header.php'; ?> <div class="content-wrapper"> <section class="content mt-4"> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <?php include('alert-msg.php'); ?> <div class="card card-primary"> <div class="card-header"> <h3 class="card-title"><?php echo $page_title; ?></h3> </div> <form action="" method="POST" enctype="multipart/form-data"> <div class="card-body"> <div class="row"> <div class="col-md-6"> <div class="form-group"> <label for="exampleInputFile">Upload Excel File</label> <a href="downloads/marks_upload.csv" download="marks_upload.csv">CSV Format File Format</a> <div class="input-group"> <div class="custom-file"> <input type="file" class="custom-file-input fileUpload_allow_csv" name="upload_format" accept=".csv" id="exampleInputFile" required> <label class="custom-file-label" for="exampleInputFile">Choose file</label> </div> </div> </div> </div> </div> <button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button> </div> </form> </div> <div class="card card-primary"> <div class="card-header"> <h3 class="card-title">Student Result</h3> </div> <form action="" method="POST" enctype="multipart/form-data"> <div class="card-body"> <table class="table table-bordered table-striped main_datatables"> <thead> <tr> <th>Sr. No.</th> <th>Student Name</th> <th>Roll Number</th> <th>Reg. No.</th> <th>Class</th> <th>Division</th> <th>Subject</th> <th>Exam</th> <th>Theory Marks</th> <th>Practical Marks</th> <th>Action</th> </tr> </thead> <tbody> <?php $sel_students=mysqli_query($con,'select * from student_result as sr inner join students as s on sr.reg_no = s.reg_no order by class,division,roll_number asc'); $i=1; while($row_students=mysqli_fetch_array($sel_students)) { ?> <tr> <td><?php echo $i; ?></td> <td><?php echo $row_students['name']; ?></td> <td><?php echo $row_students['roll_number']; ?></td> <td><?php echo $row_students['reg_no']; ?></td> <td><?php echo $row_students['class']; ?></td> <td><?php echo $row_students['division']; ?></td> <td><?php echo $row_students['subject']; ?></td> <td><?php echo $row_students['exam']; ?></td> <td><?php echo $row_students['theory_marks']; ?></td> <td><?php echo $row_students['practical_marks']; ?></td> <td> <a href="student-result-delete.php?id=<?php echo $row_students['id']; ?>" onclick="return confirm('Are you sure you want to delete ?');" class="btn btn-sm btn-danger"><i class="fas fa-trash"></i></a> </td> </tr> <?php $i=$i+1; } ?> </tbody> </table> </div> </form> </div> </div> </div> </div> </section> </div> <?php include 'footer.php'; ?> <?php if(isset($_POST['btnSubmit'])) { $filename=$_FILES["upload_format"]["tmp_name"]; if($_FILES["upload_format"]["size"] > 0) { $file = fopen($filename, "r"); $students=0; $row_count=0; while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE) { if($row_count>0) { $reg_no = $emapData[0]; $subject = $emapData[1]; $exam = $emapData[2]; $theory_marks = $emapData[3]; $practical_marks = $emapData[4]; $ins = mysqli_query($con,"INSERT INTO `student_result` (`reg_no`, `subject`, `exam`, `theory_marks`, `practical_marks`) VALUES ('$reg_no', '$subject', '$exam', '$theory_marks', '$practical_marks')"); if($ins) { $students=$students+1; } } $row_count = $row_count + 1; } if($students>0) { $_SESSION['success_msg'] = $students.' students result are imported...'; echo"<script>window.location='import-result.php';</script>"; } else { $_SESSION['error_msg'] = 'Unable to import students result...'; echo"<script>window.location='import-result.php';</script>"; } } else { $_SESSION['error_msg'] = 'Have not data in uploaded file...'; echo"<script>window.location='import-result.php';</script>"; } } ?>