WordPress.org
Get WordPress

Plugin Directory

Changeset 3265421


Ignore:
Timestamp:
04/02/2025 05:25:28 AM (12 months ago)
Author:
rohitashv
Message:

updated

Location:
emarksheet
Files:
41 added
9 edited

Legend:

Unmodified
Added
Removed

  • emarksheet/trunk/emarksheet.php

    r3265232 r3265421  
    55Description: This is a simple and unique wordpress plugin to create a simple marksheet using wordpress. You can also give a link to your users to see the result and print it.
    66Author: rohitashv
    7 Version: 5.4.1
     7Version: 5.4.2
    88License:           GPL v2 or later
    99License URI:       https://www.gnu.org/licenses/gpl-2.0.html

  • emarksheet/trunk/menu-pages/emark_add_class.php

    r3265232 r3265421  
    88{
    99    $subname = strip_tags($_POST['name']);
    10     $insert_query="insert into `emarksheet_class`(`id`,`class_name`) values('','$subname')";
     10    $insert_query=$wpdb->prepare("insert into `emarksheet_class`(`id`,`class_name`) values('','$subname')");
    1111    $wpdb->query($insert_query);
    1212    echo "<div class='alert alert-success'>Class Name Added Successfully</div>";
    … …  
    1616    $up_su_n = strip_tags($_POST['up_su_n']);
    1717    $up_su_id = strip_tags($_POST['up_id']);
    18     $update_query = "update `emarksheet_class` set `class_name`='$up_su_n' where `id`='$up_su_id'";
     18    $update_query = $wpdb->prepare("update `emarksheet_class` set `class_name`='$up_su_n' where `id`='$up_su_id'");
    1919    $wpdb->query($update_query);
    2020    echo "<div class='alert alert-success'>Class Name Updated Successfully</div>";
    … …  
    2525    {
    2626        $iddelt = esc_html($_GET['id']);
    27         $delete_query = "delete from `emarksheet_class` where `id`='$iddelt'";
     27        $delete_query = $wpdb->prepare("delete from `emarksheet_class` where `id`='$iddelt'");
    2828        $wpdb->query($delete_query);
    2929        echo "<div class='alert alert-success'>Class Name Deleted Successfully</div>";
    … …  
    3333{
    3434    $idd = esc_html($_GET['id']);
    35     $selectd_query = "select * from `emarksheet_class` where `id`='$idd'";
     35    $selectd_query = $wpdb->prepare("select * from `emarksheet_class` where `id`='$idd'");
    3636    $selectd_row =  $wpdb->get_results($selectd_query);
    3737    $su_n = $selectd_row[0]->class_name;
    … …  
    5454</script>
    5555<?php
    56     $select_query = "select * from `emarksheet_class`";
     56    $select_query = $wpdb->prepare("select * from `emarksheet_class`");
    5757    $select_row =  $wpdb->get_results($select_query);
    5858?>
    … …  
    7272    foreach($select_row as $select_row)
    7373    {
    74         echo "<tr><td>$i</td><td>".$select_row->class_name."</td><td> &nbsp;&nbsp;&nbsp;&nbsp;<a href='".admin_url("admin.php?page=eMarksheet-main&action=update&id=$select_row->id")."' rel='tooltip' title='update' class='update'><i class='icon-pencil'></i></a> &nbsp;&nbsp; <a href='".admin_url("admin.php?page=eMarksheet-main&action=delete&id=$select_row->id")."' onclick='return show_confirm();' rel='tooltip' title='Delete' class='delete'><i class='icon-trash'></i></a></td></tr>";
     74        echo "<tr><td>$i</td><td>".esc_html($select_row->class_name)."</td><td> &nbsp;&nbsp;&nbsp;&nbsp;<a href='".admin_url("admin.php?page=eMarksheet-main&action=update&id=$select_row->id")."' rel='tooltip' title='update' class='update'><i class='icon-pencil'></i></a> &nbsp;&nbsp; <a href='".admin_url("admin.php?page=eMarksheet-main&action=delete&id=$select_row->id")."' onclick='return show_confirm();' rel='tooltip' title='Delete' class='delete'><i class='icon-trash'></i></a></td></tr>";
    7575        $i++;
    7676    }

  • emarksheet/trunk/menu-pages/emark_add_marks.php

    r3265232 r3265421  
    77{
    88    $id = esc_html($_GET['id']);
    9     $selectd_query = "select * from `emarksheet_student` where `id`='$id'";
     9    $selectd_query = $wpdb->prepare("select * from `emarksheet_student` where `id`='$id'");
    1010    $selectd_row =  $wpdb->get_results($selectd_query);
    1111    $su_n = $selectd_row[0]->class_id;
    1212
    13     $selectd_query1 = "select * from `emarksheet_subject` where `class`='$su_n'";
     13    $selectd_query1 = $wpdb->prepare("select * from `emarksheet_subject` where `class`='$su_n'");
    1414    $selectd_row1 =  $wpdb->get_results($selectd_query1);
    1515    ?>
    … …  
    3838        $student_id = esc_html($_POST['st_id']);
    3939        $data = serialize($_POST);
    40         $gt_old = "select * from `emarksheet_marks` where `student_id`='$student_id' AND `class_id`='$class_n'";
     40        $gt_old = $wpdb->prepare("select * from `emarksheet_marks` where `student_id`='$student_id' AND `class_id`='$class_n'");
    4141        $gt_old = $wpdb->get_results($gt_old);
    4242        if($gt_old)
    4343        {
    4444            $mk_id = $gt_old[0]->id;
    45             $upds = "update `emarksheet_marks` set `marks`='$data' where `id`='$mk_id'";
     45            $upds = $wpdb->prepare("update `emarksheet_marks` set `marks`='$data' where `id`='$mk_id'");
    4646            $wpdb->query($upds);
    4747            //echo $wpdb->last_error;
    … …  
    5050        else
    5151        {
    52             $insert_st = "insert into `emarksheet_marks`(`id`,`student_id`,`class_id`,`marks`) values('','$student_id','$class_n','$data')";
     52            $insert_st = $wpdb->prepare("insert into `emarksheet_marks`(`id`,`student_id`,`class_id`,`marks`) values('','$student_id','$class_n','$data')");
    5353            $wpdb->query($insert_st);
    5454            echo "<div class='alert alert-success'> Marks Added Successfully !!! </div>";
    … …  
    6565<tr><th>Sr No</th><th>Roll No</th><th>Student Name</th><th>Father's Name</th><th>Mother's Name</th><th>Date Of Birth</th><th>Action</th></tr>
    6666<?php
    67 $select_qury2 = "select * from `emarksheet_student` where `class_id`='$class_n'";
     67$select_qury2 = $wpdb->prepare("select * from `emarksheet_student` where `class_id`='$class_n'");
    6868$select_data2 = $wpdb->get_results($select_qury2);
    6969$i = 1;
    … …  
    8989See the list of Enrolled Students for each Class. First Select the class :
    9090<?php
    91 $select_qury = "select * from `emarksheet_class`";
     91$select_qury = $wpdb->prepare("select * from `emarksheet_class`");
    9292$select_data = $wpdb->get_results($select_qury);
    9393?>

  • emarksheet/trunk/menu-pages/emark_add_student.php

    r3265232 r3265421  
    44<?php
    55global $wpdb;
    6 $select_qury = "select * from `emarksheet_class`";
     6$select_qury = $wpdb->prepare("select * from `emarksheet_class`");
    77$select_data = $wpdb->get_results($select_qury);
    88if(isset($_POST['enroll']))
    … …  
    1717    $dob_m= strip_tags($_POST['dob_month']);
    1818    $dob_y = strip_tags($_POST['dob_year']);
    19     $insert_query="insert into `emarksheet_student`(`id`,`class_id`,`roll_no`,`first_n`,`last_n`,`father_n`,`mother_n`,`dob_date` ,`dob_month`,`dob_year`) values('','$class','$roll_n','$first_n','$last_n','$father_n','$mother_n','$dob_date','$dob_m','$dob_y')";
     19    $insert_query= $wpdb->prepare("insert into `emarksheet_student`(`id`,`class_id`,`roll_no`,`first_n`,`last_n`,`father_n`,`mother_n`,`dob_date` ,`dob_month`,`dob_year`) values('','$class','$roll_n','$first_n','$last_n','$father_n','$mother_n','$dob_date','$dob_m','$dob_y')");
    2020    $wpdb->query($insert_query);
    2121    echo "<div class='alert alert-success'>New Student Enrolled Successfully !!!</div>";

  • emarksheet/trunk/menu-pages/emark_add_student_list.php

    r3265232 r3265421  
    2121    $dob_m= esc_html($_POST['dob_month']);
    2222    $dob_y = esc_html($_POST['dob_year']);
    23     $update_query = "update `emarksheet_student` set `class_id`='$class',
     23    $update_query = $wpdb->prepare("update `emarksheet_student` set `class_id`='$class',
    2424    `roll_no`='$roll_n',`first_n`='$first_n',`last_n`='$last_n',`father_n`='$father_n',`mother_n`='$mother_n',
    25     `dob_date`='$dob_date',`dob_month`='$dob_m',`dob_year`='$dob_y' where `id`='$up_id'";
     25    `dob_date`='$dob_date',`dob_month`='$dob_m',`dob_year`='$dob_y' where `id`='$up_id'");
    2626    $wpdb->query($update_query);
    2727    echo "<div class='alert alert-success'>Student Name Updated Successfully</div>";
    … …  
    3333{
    3434    $iddelt = $_GET['id'];
    35     $delete_query = "delete from `emarksheet_student` where `id`='$iddelt'";
     35    $delete_query = $wpdb->prepare("delete from `emarksheet_student` where `id`='$iddelt'");
    3636    $wpdb->query($delete_query);
    3737    echo "<div class='alert alert-success'>Student Name Deleted Successfully</div>";
    … …  
    4141{
    4242    $idd = $_GET['id'];
    43     $selectd_query = "select * from `emarksheet_student` where `id`='$idd'";
     43    $selectd_query = $wpdb->prepare("select * from `emarksheet_student` where `id`='$idd'");
    4444    $selectd_row =  $wpdb->get_results($selectd_query);
    4545    $class_ida = $selectd_row[0]->class_id;
    … …  
    5252    $dob_m = $selectd_row[0]->dob_month;
    5353    $dob_y = $selectd_row[0]->dob_year;
    54     $select_dd = "select * from `emarksheet_class`";
     54    $select_dd = $wpdb->prepare("select * from `emarksheet_class`");
    5555    $select_data =  $wpdb->get_results($select_dd);
    5656    ?>
    … …  
    148148{
    149149    $class_n = $_POST['class_n'];
    150     $select_qury1 = "select * from `emarksheet_class` where `id`='$class_n'";
     150    $select_qury1 = $wpdb->prepare("select * from `emarksheet_class` where `id`='$class_n'");
    151151    $select_data1 = $wpdb->get_results($select_qury1);
    152152    $class_name = $select_data1[0]->class_name;
    … …  
    158158<tr><th>Sr No</th><th>Roll No</th><th>Student Name</th><th>Father's Name</th><th>Mother's Name</th><th>Date Of Birth</th><th>Action</th></tr>
    159159<?php
    160 $select_qury2 = "select * from `emarksheet_student` where `class_id`='$class_n'";
     160$select_qury2 = $wpdb->prepare("select * from `emarksheet_student` where `class_id`='$class_n'");
    161161$select_data2 = $wpdb->get_results($select_qury2);
    162162$i = 1;
    … …  
    182182See the list of Enrolled Students for each Class. First Select the class :
    183183<?php
    184 $select_qury = "select * from `emarksheet_class`";
     184$select_qury = $wpdb->prepare("select * from `emarksheet_class`");
    185185$select_data = $wpdb->get_results($select_qury);
    186186?>
    … …  
    201201}}
    202202?>
    203 

  • emarksheet/trunk/menu-pages/emark_add_sub.php

    r3265232 r3265421  
    1212    $tot_m = strip_tags($_POST['tot_m']);
    1313    $min_pass = strip_tags($_POST['min_pass']);
    14     $insert_queryr = "insert into `emarksheet_subject`(`id`,`class`,`sub_name`,`min_pass`,`total_marks`) values('','$sub_id','$quiz_n','$min_pass','$tot_m')";
     14    $insert_queryr = $wpdb->prepare("insert into `emarksheet_subject`(`id`,`class`,`sub_name`,`min_pass`,`total_marks`) values('','$sub_id','$quiz_n','$min_pass','$tot_m')");
    1515    $wpdb->query($insert_queryr);
    1616    echo "<div class='alert alert-success'>Subject Name Added Successfully</div>";
    … …  
    2424    $up_su_tm = strip_tags($_POST['tot_m']);
    2525    $up_su_mp = strip_tags($_POST['min_pass']);
    26     $update_query = "update `emarksheet_subject` set `sub_name`='$up_su_n',`class`='$up_su_ss',`total_marks`='$up_su_tm',`min_pass`='$up_su_mp' where `id`='$up_su_id'";
     26    $update_query = $wpdb->prepare("update `emarksheet_subject` set `sub_name`='$up_su_n',`class`='$up_su_ss',`total_marks`='$up_su_tm',`min_pass`='$up_su_mp' where `id`='$up_su_id'");
    2727    $wpdb->query($update_query);
    2828    echo "<div class='alert alert-success'>Subject Name Updated Successfully</div>";
    … …  
    3939    {
    4040        $iddelt = esc_html($_GET['id']);
    41         $delete_query = "delete from `emarksheet_subject` where `id`='$iddelt'";
     41        $delete_query = $wpdb->prepare("delete from `emarksheet_subject` where `id`='$iddelt'");
    4242        $wpdb->query($delete_query);
    4343        echo "<div class='alert alert-success'>subject Name Deleted Successfully</div>";
    … …  
    4747    {
    4848        $idd = $_GET['id'];
    49         $selectd_query = "select * from `emarksheet_subject` where `id`='$idd'";
     49        $selectd_query = $wpdb->prepare("select * from `emarksheet_subject` where `id`='$idd'");
    5050        $selectd_row =  $wpdb->get_results($selectd_query);
    5151        $su_n = $selectd_row[0]->sub_name;
    … …  
    121121    foreach($select_data_quiz as $select_data_quiz)
    122122    {
    123         $select_sub = "select * from `emarksheet_class` where `id`='$select_data_quiz->class'";
     123        $select_sub = $wpdb->prepare("select * from `emarksheet_class` where `id`='$select_data_quiz->class'");
    124124        $select_sub_quiz = $wpdb->get_results($select_sub);
    125125        echo "<tr><td>$i</td><td>".ucfirst($select_sub_quiz[0]->class_name)."</td><td>".ucfirst($select_data_quiz->sub_name)."</td><td>".$select_data_quiz->total_marks."</td><td>".$select_data_quiz->min_pass."</td><td> &nbsp;&nbsp;&nbsp;&nbsp;<a href='".admin_url("admin.php?page=eMarksheet-subject&action=update&id=$select_data_quiz->id")."' rel='tooltip' title='update' class='update'><i class='icon-pencil'></i></a> &nbsp;&nbsp; <a href='".admin_url("admin.php?page=eMarksheet-subject&action=delete&id=$select_data_quiz->id")."' onclick='return show_confirm();' rel='tooltip' title='Delete' class='delete'><i class='icon-trash'></i></a></td></tr>";

  • emarksheet/trunk/menu-pages/print.php

    r3265232 r3265421  
    2727if(isset($_GET['action']))
    2828{
    29     $sett = "select * from `emarksheet_setting`";
     29    $sett = $wpdb->prepare("select * from `emarksheet_setting`");
    3030    $get_s = $wpdb->get_results($sett);
    3131   
    3232    $sid = $_GET['id'];
    33     $get_m = "select * from `emarksheet_marks` where `student_id` = '$sid'";
     33    $get_m = $wpdb->prepare("select * from `emarksheet_marks` where `student_id` = '$sid'");
    3434    $get_st_l = $wpdb->get_results($get_m);
    3535    $gee_cl = $get_st_l[0]->class_id;
    … …  
    4040    $count = count($marks)/2;
    4141
    42     $select_qury5 = "select * from `emarksheet_student` where `id`='$sid'";
     42    $select_qury5 = $wpdb->prepare("select * from `emarksheet_student` where `id`='$sid'");
    4343    $select_data5 = $wpdb->get_results($select_qury5);
    4444
    45     $get_class_l = "select * from `emarksheet_subject` where `class` = '$gee_cl'";
     45    $get_class_l = $wpdb->prepare("select * from `emarksheet_subject` where `class` = '$gee_cl'");
    4646    $get_cl_l = $wpdb->get_results($get_class_l);
    4747
    48     $get_class_li = "select * from `emarksheet_class` where `id` = '$gee_cl'";
     48    $get_class_li = $wpdb->prepare("select * from `emarksheet_class` where `id` = '$gee_cl'");
    4949    $get_cl_li = $wpdb->get_results($get_class_li);
    5050   

  • emarksheet/trunk/menu-pages/settings.php

    r3265232 r3265421  
    1212    $phone_n  = strip_tags($_POST['phone_n']);
    1313    $principal = strip_tags($_POST['principle']);
    14     $insert_q = "insert into `emarksheet_setting`(`id`,`school_name`,`address`,`district`,`state`,`phone`,`name_of_principal`) values('','$name_sc','$address','$district','$state','$phone_n','$principal')";
     14    $insert_q = $wpdb->prepare("insert into `emarksheet_setting`(`id`,`school_name`,`address`,`district`,`state`,`phone`,`name_of_principal`) values('','$name_sc','$address','$district','$state','$phone_n','$principal')");
    1515    $wpdb->query($insert_q);
    1616    echo "<div class='alert alert-success'>Settins Saved Successfully !!! </div>";
    1717}
    18 $select = "select * from `emarksheet_setting`";
     18$select = $wpdb->prepare("select * from `emarksheet_setting`");
    1919$get_r = $wpdb->get_results($select);
    2020?>

  • emarksheet/trunk/readme.txt

    r3265232 r3265421  
    55Requires at least: 4.1
    66Tested up to: 6.7.2
    7 Stable tag: 5.4.1
     7Stable tag: 5.4.2
    88
    99This is a simple and unique wordpress plugin to create a simple marksheet using wordpress. You can also give a link to your users to see the result and print it.
Note: See TracChangeset for help on using the changeset viewer.