Create subjects Postion and overall position

jazal · December 25, 2022

I want create subject Postion and overall class position like image below, I need assistance. Where will I start from?

ginerjm · December 25, 2022

What do you mean by 'class position' and 'subject' position? Are you saying you want to use CSS to place objects in certain places on a screen?

Barand · December 25, 2022

2 hours ago, jazal said:

Where will I start from?

What do you have so far by way of code and data?

jazal · December 25, 2022

@ginerjmi want my database to show the student that come first in each subjects and overall in class

jazal · December 25, 2022

@Baranda friend share a school result management script with me, but i am trying to add student subject rank to the view result and overall rank in class to it.

jazal · December 25, 2022

Here is the code to view result but i noticed that everything was done here, i want my sql to add result of each subject of each student then save it in total colomn and also average and grade with total percent in each term

<?php
session_start();
error_reporting(0);
include('includes/config.php');

?>
<?php include('includes/header.php');
$admint = $adminresult->term;
$admins = $adminresult->session;
?>
<style type="text/css">
.content-wrapper {
margin: 0 auto;
max-width: 1336px;
min-width: 1336px;
}

@media print {
.content-wrapper .yes_print {
margin: 0 auto;
max-width: 1100px;
min-width: 1100px;
}

.print_p {
padding-top: 0px !important;
}

.content-wrapper {
margin: 0 auto;
max-width: 100%;
min-width: 100%;
}
}
</style>
<div class="content-wrapper">
<div class="content-container">

<?php
$stmt = $dbh->query("SELECT * FROM settings");
$rowprint = $stmt->fetch(PDO::FETCH_OBJ);
?>
<?php
// code Student Data
$rollid=$_POST['studentid'];
$classid=$_POST['class'];
$_SESSION['rollid']=$rollid;
$_SESSION['classid']=$classid;
$qery = "SELECT tblstudents.StudentName,tblstudents.logo,tblstudents.Departments,tblstudents.RollId,tblstudents.RegDate,tblstudents.StudentId,tblstudents.Status,tblclasses.ClassName,tblclasses.Section from tblstudents join tblclasses on tblclasses.id=tblstudents.ClassId where tblstudents.RollId=:rollid and tblstudents.ClassId=:classid ";
$stmt = $dbh->prepare($qery);
$stmt->bindParam(':rollid',$rollid,PDO::PARAM_STR);
$stmt->bindParam(':classid',$classid,PDO::PARAM_STR);
$stmt->execute();
$resultss=$stmt->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($stmt->rowCount() > 0)
{
foreach($resultss as $row)
{ ?>
<div class="printindis" style="width: 100%;">
<img src="images/<?php echo htmlentities($rowprint->logo); ?>"
style="height: 124px;margin-left: 12%;">
<div style="float: right;margin-right: 16%;text-align: center;">
<div style="float: left;">
<h1
style="text-transform: uppercase;margin: 0px;font-size: 38px;margin-bottom: 7px;font-family: Arial Black;">
<?php echo htmlentities($rowprint->title); ?></h1>
<p
style="text-transform: uppercase;font-weight: bold;background: black;color: white;padding: 5px;text-align: left;margin-bottom: 1px;">
<b style="margin-left: 31px;">Motto:</b> <span
style="margin-left:37px; "><?php echo htmlentities($rowprint->description); ?></span>
</p>
<p style="margin:0px;padding: 0px;">
<?php echo $rowprint->address1 ?>
</p>
<p style="margin:0px;padding: 0px;">
<?php echo $rowprint->address2 ?>
</p>
</div>
<div
style="float: left;background: url('images/<?php echo htmlentities($row->logo); ?>');height: 121px;width: 144px;background-position: center top;background-size: cover;background-repeat: no-repeat;margin-left: 39px;border: 2px solid #d3d3d3;">

</div>
</div>
</div>

<div class="yes_print">
<div class="printing" style="width: 100%;margin-left: auto;margin-right: auto;">
<div style="margin-left: 207px;text-align: center;">
<div style="float: left;margin-left: -22%;">
<img src="images/<?php echo htmlentities($rowprint->logo); ?>"
style="height: 110px;margin-left: 0%;">
</div>

<div style=" float: left;margin-left: -5%;">
<h1
style="text-transform: uppercase;margin: 0px;font-size: 30px;margin-bottom: 7px;font-family: Arial Black;">
<?php echo htmlentities($rowprint->title); ?></h1>
<p
style="text-transform: uppercase;font-weight: bold;background: black;color: white;padding: 5px;text-align: left;margin-bottom: 1px;">
<b style="margin-left: 31px;">Motto:</b> <span
style="margin-left:37px; "><?php echo htmlentities($rowprint->description); ?></span>
</p>
<p style="margin:0px;padding: 0px;">
<?php echo $rowprint->address1 ?>
</p>
<p style="margin:0px;padding: 0px;">
<?php echo $rowprint->address2 ?>
</p>
</div>
<div style="float: left;">
<img src="images/<?php echo htmlentities($row->logo); ?>" style="height: 113px;
border: 2px solid #d3d3d3;
object-fit: cover;
width: 133px;
object-position: center top;
margin-left: 5px;">
</div>

</div>
<?php }

?>

</div>
</div>

</div>

<?php
// code Student Data
$rollid=$_POST['studentid'];
$classid=$_POST['class'];
$_SESSION['rollid']=$rollid;
$_SESSION['classid']=$classid;
$qery = "SELECT tblstudents.StudentName,tblstudents.Gender,tblstudents.DOB,tblstudents.Departments,tblstudents.RollId,tblstudents.RegDate,tblstudents.StudentId,tblstudents.Status,tblclasses.ClassName,tblclasses.Section from tblstudents join tblclasses on tblclasses.id=tblstudents.ClassId where tblstudents.RollId=:rollid and tblstudents.ClassId=:classid ";
$stmt = $dbh->prepare($qery);
$stmt->bindParam(':rollid',$rollid,PDO::PARAM_STR);
$stmt->bindParam(':classid',$classid,PDO::PARAM_STR);
$stmt->execute();
$resultss=$stmt->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($stmt->rowCount() > 0)
{ ?>
<h2 style="text-align: center;margin-bottom: 5px;font-family: calibri;">
Assessment Report <br>
<?php
$dpid = $row->Departments;
$squery = mysqli_query($con, "SELECT * FROM tbldepartments WHERE id = '$dpid' ");
$sqresult = mysqli_fetch_assoc($squery);
echo $sqresult['DepartmentName'] == " " ? " " : " ";
?>
</h2>
<?php
foreach($resultss as $row)
{ ?>
<div class="firsttable" style="float: left;width: 35%;">
<table class="table table-hover table-bordered"
style="width: 100%;text-align: left;">

<thead>
<tr>
<th scope="row" colspan="3" class="tst"
style="padding: 10px;text-transform: uppercase;">
<h3>Student Personal Data</h3>
</th>

</tr>
</thead>
<tbody>
<tr>
<td scope="row" colspan="2" style="font-weight: bold;">Name
<em>(Surname First)</em>
</td>
<td id="studentnameid"
style="text-align: center;text-transform: uppercase;">
<?php echo htmlentities($row->StudentName);?></td>
</tr>
<tr>
<td scope="row" colspan="2" style="font-weight: bold;">Date
of Birth</td>
<td style="text-align: center;text-transform: uppercase;">
<?php echo htmlentities(date("F j, Y", strtotime($row->DOB)));?>
</td>
</tr>
<tr>
<td scope="row" colspan="2" style="font-weight: bold;">Sex
</td>
<td style="text-align: center;text-transform: uppercase;">
<?php echo htmlentities($row->Gender);?></td>
</tr>
<tr>
<td scope="row" colspan="2" style="font-weight: bold;">Class
</td>
<td id="classname"
style="text-align: center;text-transform: uppercase;">
<?php echo htmlentities($row->ClassName);?></td>
</tr>
<tr>
<td scope="row" colspan="2" style="font-weight: bold;">
Department </td>
<td style="text-align: center;text-transform: uppercase;"><?php
$dpid = $row->Departments;
$squery = mysqli_query($con, "SELECT * FROM tbldepartments WHERE id = '$dpid' ");
$sqresult = mysqli_fetch_assoc($squery);
echo htmlentities($sqresult['DepartmentName']);
?></td>
</tr>
<tr>
<td scope="row" colspan="2" style="font-weight: bold;">
Student ID </td>
<td style="text-align: center;text-transform: lowercase;">
<code><?php echo htmlentities($row->RollId);?></code>
</td>
</tr>

</tbody>
</table>
</div>
<div class="secondtable" style="float: right;width: 64%;">
<table class="table table-hover table-bordered"
style="width: 100%;text-align: center;">

<thead>
<tr>
<th scope="row" colspan="3" class="tst"
style="padding: 10px;text-transform: uppercase;">
<h3>attendance</h3>
</th>
</tr>
</thead>
<tbody>
<tr>
<td scope="row" colspan="1"
style="text-align: center;font-weight: bold;">No. of
Days School Opened</td>
<td scope="row" colspan="1"
style="text-align: center;font-weight: bold;">No. of
Days Present</td>
<td scope="row" colspan="1"
style="text-align: center;font-weight: bold;">No. of
Days Absent</td>
</tr>
<tr>

<?php
$moreid = $row->StudentId;
$stmt = $dbh->query("SELECT * FROM tblresult WHERE StudentId = '$moreid' and term = '$admint' and year = '$admins'");
$moredata = $stmt->fetch(PDO::FETCH_OBJ);
?>
<td><?php echo htmlentities($moredata->daysschool); ?></td>
<td><?php echo htmlentities($moredata->dayspresent); ?></td>
<td><?php echo htmlentities($moredata->daysabsence); ?></td>
</tr>

</tbody>
</table>
<table class="table table-hover table-bordered"
style="width: 100%;text-align: center;">

<thead>
<tr>
<th scope="row" colspan="3" class="tst"
style="padding: 10px;text-transform: uppercase;">
<h3>terminal duration</h3>
</th>
</tr>
</thead>
<tbody>
<tr>
<td scope="row" colspan="1"
style="text-align: center;font-weight: bold;">Term
Begins</td>
<td scope="row" colspan="1"
style="text-align: center;font-weight: bold;">Term Ends
</td>
<td scope="row" colspan="1"
style="text-align: center;font-weight: bold;">Next Term
Begins</td>
</tr>
<tr>
<td><?php echo htmlentities($moredata->termbegin); ?></td>
<td><?php echo htmlentities($moredata->termends); ?></td>
<td><?php echo htmlentities($moredata->termnext); ?></td>
</tr>

</tbody>
</table>
</div>
<?php
$termid = $row->StudentId;
$query = mysqli_query($con, "SELECT term FROM tblresult WHERE StudentId='$termid' and term = '$admint' and year = '$admins'") or die();
$resultterm = mysqli_fetch_assoc($query);
?>
<?php }
}
?>
</div>
<style type="text/css">
table {
text-align: center;
}

th {
text-align: center;

}

.tst {
background: lightgrey;
}
</style>
<div class="panel-body p-20">
<table class="table table-hover table-bordered" style="text-align: center;">
<div style="padding: 10px;text-align: center;background:lightgrey;text-transform: uppercase;clear: both;"
class="print_p">
<h3>Academic Performance</h3>
</div>
<thead>
<tr>
<th></th>
<th>1st Test</th>
<th>2nd Test</th>
<th>Assignment</th>
<th>Project</th>
<th>Exam Score</th>
<th>Overall Score</th>
<th>Grade</th>
<th>Teacher's Remark</th>
</tr>
<tr>
<th class="tst">Max Obt. Mark</th>
<th class="tst">10</th>
<th class="tst">10</th>
<th class="tst">10</th>
<th class="tst">10</th>
<th class="tst">60</th>
<th class="tst">100</th>
<th class="tst"></th>
<th class="tst"></th>
</tr>
</thead>
<tbody>
<?php
// Code for result
$query ="select t.StudentName,t.RollId,t.ClassId,t.term,t.year,t.marks,t.t1marks,t.t2marks,t.t3marks,t.t4marks,SubjectId,tblsubjects.SubjectName from
(select sts.StudentName,sts.RollId,sts.ClassId,tr.term,tr.year,tr.marks,tr.t1marks,tr.t2marks,tr.t3marks,tr.t4marks,SubjectId from tblstudents as sts join tblresult as tr on tr.StudentId=sts.StudentId) as t join
tblsubjects on tblsubjects.id=t.SubjectId where t.RollId=:rollid and t.ClassId=:classid and t.term = :term and t.year = :year ";
// and t.term = :term and t.year = :year
// $bettersql = "";
$query= $dbh -> prepare($query);
$query->bindParam(':rollid',$rollid,PDO::PARAM_STR);
$query->bindParam(':classid',$classid,PDO::PARAM_STR);
$query->bindParam(':term',$admint,PDO::PARAM_STR); //I stoped here
$query->bindParam(':year',$admins,PDO::PARAM_STR);
$query-> execute();
$results = $query -> fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($countrow=$query->rowCount()>0)
{
foreach($results as $result){
?>
<?php
if($result->marks+$result->t1marks+$result->t2marks+$result->t3marks+$result->t4marks > 1){
?>
<tr>
<td><?php echo htmlentities($result->SubjectName);?></td>

<td><?php echo htmlentities($result->t1marks < 1 ? "--" : $result->t1marks);?>

<td><?php echo htmlentities($result->t2marks < 1 ? "--" : $result->t2marks);?>

<td><?php echo htmlentities($result->t3marks < 1 ? "--" : $result->t3marks);?>
<td><?php echo htmlentities($result->t4marks < 1 ? "--" : $result->t4marks);?>
</td>
<td><?php echo htmlentities($result->marks < 1 ? "--" : $result->marks);?>
</td>
<td><?php echo htmlentities($totalmarks=$result->marks + $result->t1marks + $result->t2marks + $result->t3marks + $result->t4marks < 1 ? "--" :$result->marks + $result->t1marks + $result->t2marks + $result->t3marks + $result->t4marks );?>
</td>
<td>
<?php
if ($totalmarks >= 80 ) {
echo "A";
}

elseif ($totalmarks >= 79 ) {
echo "B";
}

elseif ($totalmarks >= 69) {
echo "C";
}

elseif ($totalmarks >= 49) {
echo "D";
}

elseif ($totalmarks >= 45) {
echo "E";
}

elseif ($totalmarks < 45) {
echo $result->marks+$result->tmarks < 1 ? "--" : "F";
}

?></td>

<td>
<?php
if ($totalmarks >= 80) {
echo "Excellent";
}

elseif ($totalmarks >= 70) {
echo "Very Good";
}

elseif ($totalmarks >= 50) {
echo "Good";
}

elseif ($totalmarks >= 40) {
echo "Fair";
}
if ($totalmarks < 45) {
echo $result->marks + $result->t1marks + $result->t2marks + $result->t3marks + $result->t4marks < 1 ? "--" : "Fail";
}

?></td>
</tr>

<?php
$totlcount+=$totalmarks;
$cnt++;
}
}
?>
<tr>
<th scope="row" colspan="1" class="tst">Num Of Sub</th>
<th scope="row" colspan="2" class="tst">Total Marks</th>
<th scope="row" colspan="1" class="tst">Percentage</th>
<tr>
<th scope="row" colspan="1"><?php $nud = $cnt-1; echo $nud; ?>
</th>
<th scope="row" colspan="2"><b><?php echo htmlentities($totlcount); ?></b>
</th>
<th scope="row" colspan="1">
</b><?php
$nuc = $cnt-1;
$num = $totlcount/$nuc;
$totalnum = floatval($num);
echo htmlentities($totalnum);
?> %</b></td>

</tr>

<tr>
<th scope="row" colspan="1" class="tst">Result</th>
<td><?php
if ($num >= 45) { echo htmlentities ("Pass");
}
elseif
($num < 45) { echo "Fail";
}?> </td>
</tr>
<tr>
<th scope="row" colspan="1" class="tst">Teacher's Comment</th> <td scope="row" colspan="8" style="font-weight: bold;">
<?php
echo htmlentities($moredata->tcomment);?> </td>
</tr>
<tr>
<th scope="row" colspan="3">Print Result</th>
<td></td>
<th scope="row" colspan="3" onclick="window.print();"
style="cursor: pointer;background: lightgrey;"><i
class="fa fa-print"></i> Print Result</th>
</tr>

<?php } else { ?>
<div class="alert alert-warning left-icon-alert" role="alert">
<strong>Notice!</strong> Your result not declare yet
<?php }
?>
</div>
<?php
}
else{
?>

<div class="alert alert-danger left-icon-alert" role="alert">
<strong>Oh snap!</strong>
<?php
echo htmlentities("Wrong Student ID or Class");
echo "<a href='find-result.php' class='btn btn-primary' style='float: right;background: black;color: white;'>Check again</a>";
}
?>
</div>

</tbody>
</table>

</div>
</div>

</div>

<div class="form-group">
<div class="col-sm-6">
<a href="manage-results.php">Back to Result</a>
</div>
</div>

</div>

</div>

</div>
</section>

</div>

</div>

</div>

</div>

<?php include 'includes/credit.php'; ?>

<script src="js/prism/prism.js"></script>

<script src="js/main.js"></script>
<script>
$(function($) {
var name = $("#studentnameid").text();
var data = name.replace(/\s{2,}/g, ' ');
var className = $("#classname").text();
var classsub = className.replace(/\s{2,}/g, ' ');
document.title = data + " :: " + classsub;
});
</script>

</body>

</html>

Barand · December 25, 2022

When you post code, use the <> button.

Why have you got two almost identical queries for the student data?

You are running several queries inside the loop to process the second student query - don't do that, use joins so you have a single query

What is the point of this line from your code? ...

echo $sqresult['DepartmentName'] == " " ? " " : " ";

What are you data table structures/definitions?

jazal · December 25, 2022

Can you show me how to use join on a single query and i dont know he used it. its not mine, just trying to work on it.

echo $sqresult['DepartmentName'] == " " ? " " : " ";

jazal · December 25, 2022

@Barand i am thinking of adding the test scores together so that i can save the total score to the database and also student grade into database so that it will be easy for student rank

Kindly check this code

<?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['alogin'])=="")
    {   
    header("Location: index.php"); 
    }
    else{

$admint = isset($_GET["term"]) && !empty($_GET["term"]) ? $_GET["term"] : $adminresult->term ;
$admins = isset($_GET["session"]) && !empty($_GET["session"]) ? $_GET["session"] : $adminresult->session;

$stid=intval($_GET['stid']);
if(isset($_POST['submit']))
{

$rowid=$_POST['id'];
$marks=$_POST['marks'];
$t1marks=$_POST['t1marks']; 
$t2marks=$_POST['t2marks']; 
$t3marks=$_POST['t3marks']; 
$t4marks=$_POST['t4marks']; 
$totalmark=$_POST['totalmark']; 
$percent=$_POST['percent']; 
$subjectrank=$_POST['subjectrank']; 
$rank=$_POST['rank']; 
$daysschool=$_POST['daysschool']; 
$dayspresent=$_POST['dayspresent']; 
$daysabsence=$_POST['daysabsence']; 
$termbegin=$_POST['termbegin']; 
$termends=$_POST['termends']; 
$termnext=$_POST['termnext']; 
$tcomment=$_POST['tcomment']; 
$term = $_POST["term"];
$status_ = $_POST["status_"];
$adminstatus = $_POST["adminstatus"];
$revised = $_POST["revision"];
//Calcualte revision
$revision_ = (int)$revised + 1;

// echo $revision_;
// return;
//Loop through data
foreach($_POST['id'] as $count => $id){
$mrks=$marks[$count];
$t1mrks=$t1marks[$count];
$t2mrks=$t2marks[$count];
$t3mrks=$t3marks[$count];
$t4mrks=$t4marks[$count];
$iid=$rowid[$count];
for($i=0;$i<=$count;$i++) {
//Query data
$sql="update tblresult  set marks=:mrks, Status = :status_, t1marks=:t1mrks,t2marks=:t2mrks,t3marks=:t3mrks,t4marks=:t4mrks, tcomment=:tcomment,totalmark=:totalmark,percent=:percent,subjectrank=:subjectrank,rank=:rank, daysschool=:daysschool, dayspresent=:dayspresent, daysabsence=:daysabsence, termbegin=:termbegin, termends=:termends, termnext=:termnext, adminstatus=:adminstatus, revision_=:revision_ where id=:iid and term = :term and year = :year";
$query = $dbh->prepare($sql);
$query->bindParam(':mrks',$mrks,PDO::PARAM_STR);
$query->bindParam(':t1mrks',$t1mrks,PDO::PARAM_STR);
$query->bindParam(':t2mrks',$t2mrks,PDO::PARAM_STR);
$query->bindParam(':t3mrks',$t3mrks,PDO::PARAM_STR);
$query->bindParam(':t4mrks',$t4mrks,PDO::PARAM_STR);
$query->bindParam(':daysschool',$daysschool,PDO::PARAM_STR);
$query->bindParam(':dayspresent',$dayspresent,PDO::PARAM_STR);
$query->bindParam(':daysabsence',$daysabsence,PDO::PARAM_STR);
$query->bindParam(':termbegin',$termbegin,PDO::PARAM_STR);
$query->bindParam(':termends',$termends,PDO::PARAM_STR);
$query->bindParam(':termnext',$termnext,PDO::PARAM_STR);
$query->bindParam(':iid',$iid,PDO::PARAM_STR);
$query->bindParam(':status_',$status_,PDO::PARAM_STR);
$query->bindParam(':adminstatus',$adminstatus,PDO::PARAM_STR);
$query->bindParam(':revision_',$revision_,PDO::PARAM_STR);
$query->bindParam(':term',$admint,PDO::PARAM_STR);
$query->bindParam(':year',$admins,PDO::PARAM_STR);
$query->bindParam(':tcomment',$tcomment,PDO::PARAM_STR);
$query->bindParam(':totalmark',$totalmark,PDO::PARAM_STR);
$query->bindParam(':percent',$percent,PDO::PARAM_STR);
$query->bindParam(':subjectrank',$subjectrank,PDO::PARAM_STR);
$query->bindParam(':rank',$rank,PDO::PARAM_STR);

$query->execute();
//log message
$msg="Result info updated successfully";
}
}
}

?>
<?php include('includes/header.php');?>

<!-- ========== TOP NAVBAR ========== -->
<?php include('includes/topbar.php');?>
<!-- ========== WRAPPER FOR BOTH SIDEBARS & MAIN CONTENT ========== -->
<style>
    #selectator_studentid{
        width: 100% !important;
    }
</style>
<div class="content-wrapper">
    <div class="content-container">

        <!-- ========== LEFT SIDEBAR ========== -->
        <?php include('includes/leftbar.php');?>
        <!-- /.left-sidebar -->

        <div class="main-page">

            <div class="container-fluid">
                <div class="row page-title-div">
                    <div class="col-md-6">
                        <h2 class="title">Edit Student Result Info</h2>

                    </div>

                    <!-- /.col-md-6 text-right -->
                </div>
                <!-- /.row -->
                <div class="row breadcrumb-div">
                    <div class="col-md-6">
                        <ul class="breadcrumb">
                            <li><a href="dashboard.php"><i class="fa fa-home"></i> Home</a></li>

                            <li class="active">Edit result</li>
                        </ul>
                    </div>

                </div>
                <!-- /.row -->
            </div>
            <div class="container-fluid">

                <div class="row">
                    <div class="col-md-12">
                        <div class="row">
                            <div class="col-lg-3 col-md-1 col-sm-12">
                                
                            </div>
                            <div class="col-lg-6 col-md-9 col-sm-12">
                                          <div class="panel">
                            <!--<div class="panel-heading">-->
                            <!--    <div class="panel-title">-->
                            <!--        <h5>Update the Result info</h5>-->
                            <!--    </div>-->
                            <!--</div>-->
                            <div class="panel-body">
                                <?php if($msg){?>
                                <div class="alert alert-success left-icon-alert" role="alert">
                                    <strong>Well done!</strong> <?php echo htmlentities($msg); ?>
                                </div><?php } 
else if($error){?>
                                <div class="alert alert-danger left-icon-alert" role="alert">
                                    <strong>Oh snap!</strong> <?php echo htmlentities($error); ?>
                                </div>
                                <?php } ?>
<form class="form-horizontal" method="post" action="">

                                    <?php 

$ret = "SELECT tblstudents.StudentName,tblstudents.logo,tblclasses.ClassName from tblresult join tblstudents on tblresult.StudentId=tblresult.StudentId join tblsubjects on 
tblsubjects.id=tblresult.SubjectId join tblclasses on tblclasses.id=tblstudents.ClassId where tblstudents.StudentId=:stid 
and tblresult.term = '$admint' and tblresult.year = '$admins' limit 1";
$stmt = $dbh->prepare($ret);
$stmt->bindParam(':stid',$stid,PDO::PARAM_STR);
$stmt->execute();
$result=$stmt->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($stmt->rowCount() > 0)
{
foreach($result as $row)
{  ?>
                                    <div class="form-group">
                                        <div class="col-sm-12 col-10 text-center">
                                             <a href="images/<?php echo htmlentities($row->logo); ?>" data-fancybox="images" data-caption="<?php echo htmlentities($row->StudentName);?>">
                                                 <img src="images/loading.gif" class="lazy"
                                                  data-srcset="images/<?php echo htmlentities($row->logo); ?>"
                                                  data-src="images/<?php echo htmlentities($row->logo); ?>"
                                                  style="height: 128px;
    border-radius: 21px;
    box-shadow: 6px 8px 11px -9px;">
                                            </a>
                                        <h3 style="margin: 0px;
    margin-top: 6px;"><?php echo htmlentities($row->StudentName);?></h3>
                                        <h4 style="    margin: 0px;
    margin-top: 4px;
    color: grey;"><?php echo htmlentities($row->ClassName)?>: <?php
   $depart = $_GET['stid'];
   $query = mysqli_query($con, "SELECT Department FROM tblresult WHERE StudentId='$depart' and term = '$admint' and year = '$admins' ") or die();
   $resultde = mysqli_fetch_assoc($query);
   $dpid = $resultde["Department"];
    $squery = mysqli_query($con, "SELECT * FROM tbldepartments WHERE id = '$dpid' ");
  $sqresult = mysqli_fetch_assoc($squery);
 echo htmlentities($sqresult['DepartmentName']);
    
 ?> Dpt.</h4>
 <h5 style="    margin: 0px;
    margin-top: 3px;
    color: #adadadad;">
    SESSION: 
    <?php
   $depart = $_GET['stid'];
   $query = mysqli_query($con, "SELECT * FROM tblresult WHERE StudentId='$depart' and term = '$admint' and year = '$admins' ") or die();
   $resultde = mysqli_fetch_assoc($query);
   echo $resultde["year"];
    
 ?></h5>
                                        </div>

                                    </div>

                                <hr>
                                    <div class="form-group">
                                        <label for="default" class="col-sm-2 control-label">Term</label>
                                        <div class="col-sm-10">
                                            <?php
   $depart = $_GET['stid'];
   $query = mysqli_query($con, "SELECT * FROM tblresult WHERE StudentId='$depart' and term = '$admint' and year = '$admins' ") or die();
   $resultde = mysqli_fetch_assoc($query);
 ?>
   <select name="term" class="form-control" readonly>
       <option value="<?php echo $resultde["term"]; ?>"><?php echo $resultde["term"]; ?></option>
   </select>
                                        </div>
                                    </div>
                                    
                                    <div class="form-group">
                                        <label for="default" class="col-sm-2 control-label">No. of Days School
                                            Opened</label>
                                        <div class="col-sm-10">
                                            <input type="text" name="daysschool" class="form-control"
                                                value="<?php echo htmlentities($resultde['daysschool']); ?>">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label for="default" class="col-sm-2 control-label">No. of Days Present</label>
                                        <div class="col-sm-10">
                                            <input type="text" name="dayspresent" class="form-control"
                                                value="<?php echo htmlentities($resultde['dayspresent']); ?>">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label for="default" class="col-sm-2 control-label">No. of Days Absence</label>
                                        <div class="col-sm-10">
                                            <input type="text" name="daysabsence" class="form-control"
                                                value="<?php echo htmlentities($resultde['daysabsence']); ?>">
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label for="default" class="col-sm-2 control-label">Term Begins</label>
                                        <div class="col-sm-10">
                                            <input type="text" name="termbegin" class="form-control"
                                                value="<?php echo htmlentities($resultde['termbegin']); ?>">
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label for="default" class="col-sm-2 control-label">Term Ends</label>
                                        <div class="col-sm-10">
                                            <input type="text" name="termends" class="form-control"
                                                value="<?php echo htmlentities($resultde['termends']); ?>">
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label for="default" class="col-sm-2 control-label">Next Term Begins</label>
                                        <div class="col-sm-10">
                                            <input type="text" name="termnext" class="form-control"
                                                value="<?php echo htmlentities($resultde['termnext']); ?>">
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label for="default" class="col-sm-2 control-label">Teachers Status</label>
                                        <div class="col-sm-10">
                                            <select name="status_" class="form-control" required>
                                                <option value="<?php echo ($resultde['Status'] == 0)? "0": "1"; ?>" selected>
                                                    <?php echo ($resultde['Status'] == 0)? "Pending": "Review"; ?>
                                                </option>
                                                <option value="0">======</option>
                                                <option value="1">Review</option>
                                                <option value="0">Pending</option>
                                            </select>
                                        </div>
                                    </div>
                                    <!-- Revision -->
                                    <input type="hidden" name="revision" value="<?php echo $resultde['revision_']; ?>">
                                    <!-- Revision -->
                                    <?php
                                    if (!isset($_SESSION["teacher"])) {
                                        ?>
                                    <div class="form-group">
                                        <label for="default" class="col-sm-2 control-label bg-success">Admin
                                            Status</label>
                                        <div class="col-sm-10">
                                            <select name="adminstatus" class="form-control bg-success text-white">
                                                <option value="<?php echo $resultde['adminstatus']; ?>" selected>
                                                    <?php echo ($resultde['adminstatus'] == 0)? "On Hold": "Live"; ?>
                                                </option>
                                                <option value="0">======</option>
                                                <option value="1">Live</option>
                                                <option value="0">On Hold</option>
                                            </select>
                                        </div>
                                    </div>
                                    <?php
                                    }else{
                                        ?>
                                    <input type="hidden" name="adminstatus" value="0">
                                    
                                        <p><b>Enter Teachers Comment:</b></p>
                                            <input type="text" name="tcomment" class="form-control" id="comment"
                                                value="<?php echo htmlentities($resultde['tcomment'])?>"
                                                placeholder="Enter Teachers Comment" autocomplete="on" min="0" max="1000"> 
                                    <?php
                                    }
                                    ?>
                                    <?php } }?>

                                    <hr>

                                    <?php 
$sql = "SELECT distinct tblstudents.StudentName,tblstudents.StudentId,tblclasses.ClassName,tblclasses.Section,tblsubjects.SubjectName,tblresult.marks,tblresult.t1marks,tblresult.t2marks,tblresult.t3marks,tblresult.t4marks,tblresult.totalmark,tblresult.rank,tblresult.subjectrank,tblresult.percent,tblresult.id as resultid from tblresult join tblstudents on tblstudents.StudentId=tblresult.StudentId join tblsubjects on tblsubjects.id=tblresult.SubjectId join tblclasses on tblclasses.id=tblstudents.ClassId where tblstudents.StudentId=:stid and tblresult.term = '$admint' and tblresult.year = '$admins'";
$query = $dbh->prepare($sql);
$query->bindParam(':stid',$stid,PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{  ?>
                                    <div class="form-group">
                                        <label for="default"
                                            class="col-sm-2 control-label"><?php echo htmlentities($result->SubjectName)?></label>
                                        <div class="col-sm-10">
                                            <input type="hidden" name="id[]"
                                                value="<?php echo htmlentities($result->resultid)?>">
                                            <p><b>Result for Exam:</b></p>
                                            <input type="number" name="marks[]" class="form-control" id="marks"
                                                value="<?php echo htmlentities($result->marks)?>"
                                                placeholder="Enter marks out of 60" autocomplete="off" min="0" max="60">
                                            <p><b>Result for 1st Test:</b></p>
                                            <input type="number" name="t1marks[]" class="form-control" id="marks"
                                                value="<?php echo htmlentities($result->t1marks)?>"
                                                placeholder="Enter marks out of 10" autocomplete="off" min="0" max="10">
                                                
                                            <p><b>Result for 2nd Test:</b></p>
                                            <input type="number" name="t2marks[]" class="form-control" id="marks"
                                                value="<?php echo htmlentities($result->t2marks)?>"
                                                placeholder="Enter marks out of 10" autocomplete="off" min="0" max="10">
                                                
                                            <p><b>Result for Assignment:</b></p>
                                            <input type="number" name="t3marks[]" class="form-control" id="marks"
                                                value="<?php echo htmlentities($result->t3marks)?>"
                                                placeholder="Enter marks out of 10" autocomplete="off" min="0" max="10">
                                                
                                            <p><b>Result for Project:</b></p>
                                            <input type="number" name="t4marks[]" class="form-control" id="marks"
                                                value="<?php echo htmlentities($result->t4marks)?>"
                                                placeholder="Enter marks out of 10" autocomplete="off" min="0" max="10">
                                         
                                             
                                        </div>
                                        
                                    </div>


                                    <?php }} ?>


                                    <div class="form-group">
                                        <div class="col-sm-offset-2 col-sm-10">
                                            <button type="submit" name="submit" class="btn btn-primary">Update</button>

                                            <a href="manage-results.php" class="btn btn-primary"
                                                style="float: right;background: black;color: white;">
                                                Manage Results
                                            </a>
                                        </div>
                                    </div>
                                </form>

                            </div>
                        </div>
                            </div>
                            <div class="col-lg-3 col-md-1 col-sm-12">
                                
                            </div>
                        </div>
              
                    </div>
                    <!-- /.col-md-12 -->
                </div>
            </div>
        </div>
        <!-- /.content-container -->
    </div>
    <!-- /.content-wrapper -->
</div>
<?php include 'includes/credit.php'; ?>
<!-- /.main-wrapper -->
<!--<script src="js/jquery/jquery-2.2.4.min.js"></script>-->
<script src="js/bootstrap/bootstrap.min.js"></script>
<script src="js/pace/pace.min.js"></script>
<script src="js/lobipanel/lobipanel.min.js"></script>
<script src="js/iscroll/iscroll.js"></script>
<script src="js/prism/prism.js"></script>
<script src="js/select2/select2.min.js"></script>
<script src="js/main.js"></script>
<script>
$(function($) {
    $(".js-states").select2();
    $(".js-states-limit").select2({
        maximumSelectionLength: 2
    });
    $(".js-states-hide").select2({
        minimumResultsForSearch: Infinity
    });
});
</script>
</body>

</html>
<?PHP } ?>

Barand · December 25, 2022

25 minutes ago, jazal said:

i am thinking of adding the test scores together so that i can save the total score to the database

Don't store derived data (like totals). Calculate by query when required.

And ...

1 hour ago, Barand said:

What are you data table structures/definitions?

jazal · December 25, 2022

One-to-one relationships

Barand · December 25, 2022

Bye.

jazal · December 25, 2022

Array

ginerjm · December 25, 2022

you have lost probably your best source for help by NOT answering Barand's questions. He (and I) would like to see your table structures and the relationships (which certainly are not all one-to-one) but you won't show them.

There no arrays in a database.

Edited December 25, 2022 by ginerjm

jazal · December 25, 2022

i knew i messed up.

Thanks for the time

ginerjm · December 25, 2022

And STILL you haven't provided what is asked for. Tsk Tsk.

jazal · December 25, 2022

i just unable to do that, hmmmmmmm

ginerjm · December 25, 2022

You are not able to do that? Are you kidding? You provided 300+ lines of code you wrote and yet you can't look up your database layout for us?

jazal · December 26, 2022

i already said it that i was trying to work on someone work to make it better

Barand · December 26, 2022

If you want to make it better, start by normalizing your data.

The results table in particular is a mess. Most of the items in it have nothing to do with results, it shouldn't contain repeating fields (like the marks columns) and it shouldn't contain derived data (like totals).

It's a spreadsheet, not a relational DB table, in its present form.

Of course, when the data is normalized correctly, the code will have to be rewritten - another advantage of normalization.

ginerjm · December 26, 2022

Quote

trying to work on someone work to make it better

What you are trying to say is you want someone to do your work for you? That's another forum where you can hire someone to do that kind of 'help'. Here we help the programmer solve his issues - if it is explained clearly and the related code is shown to us so that we can modify it if necessary.

And as Barand is telling you, you are going to have to figure out how to look at and modify your database definitions. Since you couldn't show that info to us yesterday I guess today's task is going to be impossible.

jazal · December 27, 2022

Thanks @Barand

jazal · December 27, 2022

On 12/25/2022 at 7:55 PM, Barand said:

Don't store derived data (like totals). Calculate by query when required.

And ...

-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jan 05, 2021 at 09:16 AM
-- Server version: 5.7.31-log
-- PHP Version: 7.4.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `api_app`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(1000) DEFAULT NULL,
  `role` varchar(1000) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `user_token` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  `ip` varchar(255) NOT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `passport` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `fullname`, `role`, `email`, `username`, `password`, `user_token`, `date`, `ip`, `mobile`, `passport`) VALUES
(1, 'admin', 'admin', 'admin@gmail.com', 'admin', '21232f297a57a5a743894a0e4a801fc3', '', '2021-01-13 15:08:14', '', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(10000) DEFAULT NULL,
  `description` text,
  `logo` varchar(1000) DEFAULT NULL,
  `siteback` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `title`, `description`, `logo`, `siteback`) VALUES
(1, 'Resut', 'Result Management', 'p.png', 'maxfemcollege.jpg');

-- --------------------------------------------------------



--
-- Table structure for table `students_data`
--

DROP TABLE IF EXISTS `students_data`;
CREATE TABLE IF NOT EXISTS `students_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(10000) NOT NULL,
  `uiid` mediumtext NOT NULL,
  `class` varchar(255) DEFAULT NULL,
  `status` varchar(10000) NOT NULL,
  `full_name` varchar(10000) NOT NULL,
  `email` varchar(1000) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `dob` varchar(10000) NOT NULL,
  `age` varchar(1000) NOT NULL,
  `sex` varchar(1000) NOT NULL,
  `address` varchar(10000) NOT NULL,
  `nationality` varchar(150) NOT NULL,
  `state` varchar(50) NOT NULL,
  `lga` varchar(50) NOT NULL,
  `home_town` varchar(100) NOT NULL,
  `religion` varchar(100) NOT NULL,
  `prev_school` varchar(100) NOT NULL,
  `prev_school_date_attended` varchar(100) NOT NULL,
  `prev_school_class_read` varchar(100) NOT NULL,
  `prev_school_reasonforleaving` varchar(100) NOT NULL,
  `father_full_name` varchar(100) NOT NULL,
  `father_address` varchar(100) NOT NULL,
  `father_occupation` varchar(100) NOT NULL,
  `father_office_address` varchar(100) NOT NULL,
  `father_email` varchar(100) NOT NULL,
  `father_mobile` varchar(100) NOT NULL,
  `mother_full_name` varchar(100) NOT NULL,
  `mother_address` varchar(100) NOT NULL,
  `mother_occupation` varchar(100) NOT NULL,
  `mother_office_address` varchar(100) NOT NULL,
  `mother_email` varchar(100) NOT NULL,
  `mother_mobile` varchar(100) NOT NULL,
  `passport` varchar(10000) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `smsto` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tblclasses`
--

DROP TABLE IF EXISTS `tblclasses`;
CREATE TABLE IF NOT EXISTS `tblclasses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` varchar(80) DEFAULT NULL,
  `ClassNameNumeric` int(4) NOT NULL,
  `Section` varchar(10000) NOT NULL,
  `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `price` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `person_name_and_idx` (`ClassName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbldepartments`
--

DROP TABLE IF EXISTS `tbldepartments`;
CREATE TABLE IF NOT EXISTS `tbldepartments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `DepartmentName` varchar(10000) DEFAULT NULL,
  `CreationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Updationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `person_name_and_idx` (`DepartmentName`(3072))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Table structure for table `tblresult`
--

DROP TABLE IF EXISTS `tblresult`;
CREATE TABLE IF NOT EXISTS `tblresult` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `StudentId` int(11) DEFAULT NULL,
  `ClassId` int(11) DEFAULT NULL,
  `Status` varchar(1000) DEFAULT NULL,
  `SubjectId` int(11) DEFAULT NULL,
  `revision_` int(250) DEFAULT '0',
  `adminstatus` int(250) DEFAULT '0',
  `marks` int(11) DEFAULT NULL,
  `tmarks` varchar(1000) DEFAULT NULL,
  `PostingDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `term` varchar(10000) DEFAULT NULL,
  `year` varchar(10000) DEFAULT NULL,
  `Department` varchar(10000) DEFAULT NULL,
  `daysschool` varchar(1000) DEFAULT NULL,
  `dayspresent` varchar(1000) DEFAULT NULL,
  `daysabsence` varchar(1000) DEFAULT NULL,
  `termbegin` varchar(1000) DEFAULT NULL,
  `termends` varchar(1000) DEFAULT NULL,
  `termnext` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `result_StudentId_and_ClassId` (`StudentId`,`ClassId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tblstudents`
--

DROP TABLE IF EXISTS `tblstudents`;
CREATE TABLE IF NOT EXISTS `tblstudents` (
  `StudentId` int(11) NOT NULL AUTO_INCREMENT,
  `StudentName` varchar(100) NOT NULL,
  `classtype` varchar(1000) DEFAULT NULL,
  `session` varchar(1000) DEFAULT NULL,
  `logo` varchar(10000) DEFAULT NULL,
  `RollId` varchar(100) NOT NULL,
  `StudentEmail` varchar(100) NOT NULL,
  `mobile` varchar(1000) DEFAULT NULL,
  `Gender` varchar(10) NOT NULL,
  `DOB` varchar(100) NOT NULL,
  `ClassId` varchar(1000) DEFAULT NULL,
  `user_token` varchar(1000) DEFAULT NULL,
  `RegDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `Status` int(1) NOT NULL,
  `Departments` mediumtext,
  `password` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`StudentId`),
  KEY `person_StudentId_and_StudentName` (`StudentName`,`StudentId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tblsubjectcombination`
--

DROP TABLE IF EXISTS `tblsubjectcombination`;
CREATE TABLE IF NOT EXISTS `tblsubjectcombination` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ClassId` int(11) NOT NULL,
  `SubjectId` int(11) NOT NULL,
  `status` int(1) DEFAULT NULL,
  `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Updationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `person_name_and_idx` (`ClassId`,`SubjectId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tblsubjects`
--

DROP TABLE IF EXISTS `tblsubjects`;
CREATE TABLE IF NOT EXISTS `tblsubjects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `SubjectName` varchar(100) NOT NULL,
  `SubjectCode` varchar(100) NOT NULL,
  `Creationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UpdationDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `person_name_and_idx` (`SubjectName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `teacher`
--

DROP TABLE IF EXISTS `teacher`;
CREATE TABLE IF NOT EXISTS `teacher` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fullName` varchar(255) NOT NULL,
  `pic` varchar(10000) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `classid` int(100) DEFAULT NULL,
  `mobileNo` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Barand · December 27, 2022

Got this on a couple of tables when trying to load your dump. But with those ridiculous column sizes like VARCHAR(10000) for a date of birth, and others, I am not surprised.

Quote

Error Code: 1118. Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

jazal · December 28, 2022

can we change all to 150? cos it work good on my live server

Sign In

Create subjects Postion and overall position

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information