Changeset 3265800
- Timestamp:
- 04/02/2025 05:04:47 PM (12 months ago)
- Location:
- emarksheet
- Files:
-
- 2 edited
-
tags/5.4.4/menu-pages/emark_add_class.php (modified) (3 diffs)
-
trunk/menu-pages/emark_add_class.php (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
emarksheet/tags/5.4.4/menu-pages/emark_add_class.php
r3265798 r3265800 15 15 { 16 16 $subname = wp_unslash($_POST['name']); 17 $wpdb->query($wpdb->prepare("insert into `emarksheet_class`(`id`,`class_name`) values('', '$subname')"));17 $wpdb->query($wpdb->prepare("insert into `emarksheet_class`(`id`,`class_name`) values('',%s)",$subname)); 18 18 echo "<div class='alert alert-success'>Class Name Added Successfully</div>"; 19 19 } … … 26 26 $up_su_n = wp_unslash($_POST['up_su_n']); 27 27 $up_su_id = wp_unslash($_POST['up_id']); 28 $wpdb->query($wpdb->prepare("update `emarksheet_class` set `class_name`= '$up_su_n' where `id`='$up_su_id'"));28 $wpdb->query($wpdb->prepare("update `emarksheet_class` set `class_name`=%s where `id`=%s",$up_su_n,$up_su_id)); 29 29 echo "<div class='alert alert-success'>Class Name Updated Successfully</div>"; 30 30 } … … 41 41 { 42 42 $idd = esc_html($_GET['id']); 43 $selectd_row = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_class` where `id`= '$idd'"));43 $selectd_row = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_class` where `id`=%s",$idd)); 44 44 $su_n = $selectd_row[0]->class_name; 45 45 ?> -
emarksheet/trunk/menu-pages/emark_add_class.php
r3265798 r3265800 15 15 { 16 16 $subname = wp_unslash($_POST['name']); 17 $wpdb->query($wpdb->prepare("insert into `emarksheet_class`(`id`,`class_name`) values('', '$subname')"));17 $wpdb->query($wpdb->prepare("insert into `emarksheet_class`(`id`,`class_name`) values('',%s)",$subname)); 18 18 echo "<div class='alert alert-success'>Class Name Added Successfully</div>"; 19 19 } … … 26 26 $up_su_n = wp_unslash($_POST['up_su_n']); 27 27 $up_su_id = wp_unslash($_POST['up_id']); 28 $wpdb->query($wpdb->prepare("update `emarksheet_class` set `class_name`= '$up_su_n' where `id`='$up_su_id'"));28 $wpdb->query($wpdb->prepare("update `emarksheet_class` set `class_name`=%s where `id`=%s",$up_su_n,$up_su_id)); 29 29 echo "<div class='alert alert-success'>Class Name Updated Successfully</div>"; 30 30 } … … 41 41 { 42 42 $idd = esc_html($_GET['id']); 43 $selectd_row = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_class` where `id`= '$idd'"));43 $selectd_row = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_class` where `id`=%s",$idd)); 44 44 $su_n = $selectd_row[0]->class_name; 45 45 ?>
Note: See TracChangeset
for help on using the changeset viewer.