- TS TS
- #81
papi gumana na pero may error kapag mag upload ako ng avatar nya ganyan lumabas pero pag hindi ako mag upload ng avatar nya ok namanmahirap po yan sir, need nyo po muna palang intindihin ung logic ng language pag ganyan
ano po errorpapi gumana na pero may error
grabi ka sir IT GODS spottedOverall: wala po sa mismong post niyo po yung problema, wala rin po sa database. Nasa backend po yung problema, actually hindi po problema, naka assign lang po yung $_POST['type'] sa specific na value kaya automatically nag seset siya into STAFF or usertype = 2.
delete mo po lahat ng data sa tablepapi gumana na pero may error kapag mag upload ako ng avatar nya ganyan lumabas pero pag hindi ako mag upload ng avatar nya ok naman
View attachment 1997753
yan paps mag error pag mag upload ng avatar tpos kung hindi naman mag upload avatar ok syaano po error
dito paps?delete mo po lahat ng data sa table
JavaScript:$(function(){ $('.select2').select2({ width:'resolve' }) }) function displayImg(input,_this) { if (input.files && input.files[0]) { var reader = new FileReader(); reader.onload = function (e) { $('#cimg').attr('src', e.target.result); } reader.readAsDataURL(input.files[0]); } } $('#manage-user').submit(function(e){ e.preventDefault(); var _this = $(this) start_loader() $.ajax({ url:_base_url_+'classes/Users.php?f=save', data: new FormData($(this)[0]), cache: false, contentType: false, processData: false, method: 'POST', type: 'POST', success:function(resp){ if(resp ==1){ location.href = './?page=user/list'; }else{ $('#msg').html('<div class="alert alert-danger">Username already exist</div>') $("html, body").animate({ scrollTop: 0 }, "fast"); } end_loader() } }) })
so dito po, hahanapin niyo yung dahilan kung bakit nagiging '2' yung $resp['status']PHP:<?php require_once('../config.php'); Class Users extends DBConnection { private $settings; public function __construct(){ global $_settings; $this->settings = $_settings; parent::__construct(); } public function __destruct(){ parent::__destruct(); } public function save_users(){ if(!isset($_POST['status']) && $this->settings->userdata('login_type') == 1){ $_POST['status'] = 1; $_POST['type'] = 2; } extract($_POST); $oid = $id; $data = ''; if(isset($oldpassword)){ if(md5($oldpassword) != $this->settings->userdata('password')){ return 4; } } $chk = $this->conn->query("SELECT * FROM `users` where username ='{$username}' ".($id>0? " and id!= '{$id}' " : ""))->num_rows; if($chk > 0){ return 3; exit; } foreach($_POST as $k => $v){ if(in_array($k,array('firstname','middlename','lastname','username','type'))){ if(!empty($data)) $data .=" , "; $data .= " {$k} = '{$v}' "; } } if(!empty($password)){ $password = md5($password); if(!empty($data)) $data .=" , "; $data .= " `password` = '{$password}' "; } if(empty($id)){ $qry = $this->conn->query("INSERT INTO users set {$data}"); if($qry){ $id = $this->conn->insert_id; $this->settings->set_flashdata('success','User Details successfully saved.'); $resp['status'] = 1; }else{ $resp['status'] = 2; } }else{ $qry = $this->conn->query("UPDATE users set $data where id = {$id}"); if($qry){ $this->settings->set_flashdata('success','User Details successfully updated.'); if($id == $this->settings->userdata('id')){ foreach($_POST as $k => $v){ if($k != 'id'){ if(!empty($data)) $data .=" , "; $this->settings->set_userdata($k,$v); } } } $resp['status'] = 1; }else{ $resp['status'] = 2; } } if(isset($_FILES['img']) && $_FILES['img']['tmp_name'] != ''){ $fname = 'uploads/avatar-'.$id.'.png'; $dir_path =base_app. $fname; $upload = $_FILES['img']['tmp_name']; $type = mime_content_type($upload); $allowed = array('image/png','image/jpeg'); if(!in_array($type,$allowed)){ $resp['msg'].=" But Image failed to upload due to invalid file type."; }else{ $new_height = 200; $new_width = 200; list($width, $height) = getimagesize($upload); $t_image = imagecreatetruecolor($new_width, $new_height); imagealphablending( $t_image, false ); imagesavealpha( $t_image, true ); $gdImg = ($type == 'image/png')? imagecreatefrompng($upload) : imagecreatefromjpeg($upload); imagecopyresampled($t_image, $gdImg, 0, 0, 0, 0, $new_width, $new_height, $width, $height); if($gdImg){ if(is_file($dir_path)) unlink($dir_path); $uploaded_img = imagepng($t_image,$dir_path); imagedestroy($gdImg); imagedestroy($t_image); }else{ $resp['msg'].=" But Image failed to upload due to unkown reason."; } } if(isset($uploaded_img)){ $this->conn->query("UPDATE users set `avatar` = CONCAT('{$fname}','?v=',unix_timestamp(CURRENT_TIMESTAMP)) where id = '{$id}' "); if($id == $this->settings->userdata('id')){ $this->settings->set_userdata('avatar',$fname); } } } if(isset($resp['msg'])) $this->settings->set_flashdata('success',$resp['msg']); return $resp['status']; } public function delete_users(){ extract($_POST); $avatar = $this->conn->query("SELECT avatar FROM users where id = '{$id}'")->fetch_array()['avatar']; $qry = $this->conn->query("DELETE FROM users where id = $id"); if($qry){ $avatar = explode("?",$avatar)[0]; $this->settings->set_flashdata('success','User Details successfully deleted.'); if(is_file(base_app.$avatar)) unlink(base_app.$avatar); $resp['status'] = 'success'; }else{ $resp['status'] = 'failed'; } return json_encode($resp); } public function save_student(){ extract($_POST); $data = ''; if(isset($oldpassword)){ if(md5($oldpassword) != $this->settings->userdata('password')){ return json_encode(array("status"=>'failed', "msg"=>'Old Password is Incorrect')); } } $chk = $this->conn->query("SELECT * FROM `personnel` where email ='{$email}' ".($id>0? " and id!= '{$id}' " : ""))->num_rows; if($chk > 0){ return 3; exit; } foreach($_POST as $k => $v){ if(!in_array($k,array('id','oldpassword','cpassword','password'))){ if(!empty($data)) $data .=" , "; $data .= " {$k} = '{$v}' "; } } if(!empty($password)){ $password = md5($password); if(!empty($data)) $data .=" , "; $data .= " `password` = '{$password}' "; } if(empty($id)){ $qry = $this->conn->query("INSERT INTO personnel set {$data}"); if($qry){ $id = $this->conn->insert_id; $this->settings->set_flashdata('success',' User Details successfully saved.'); $resp['status'] = "success"; }else{ $resp['status'] = "failed"; $resp['msg'] = "An error occurred while saving the data. Error: ". $this->conn->error; } }else{ $qry = $this->conn->query("UPDATE personnel set $data where id = {$id}"); if($qry){ $this->settings->set_flashdata('success','User Details successfully updated.'); if($id == $this->settings->userdata('id')){ foreach($_POST as $k => $v){ if($k != 'id'){ if(!empty($data)) $data .=" , "; $this->settings->set_userdata($k,$v); } } } $resp['status'] = "success"; }else{ $resp['status'] = "failed"; $resp['msg'] = "An error occurred while saving the data. Error: ". $this->conn->error; } } if(isset($_FILES['img']) && $_FILES['img']['tmp_name'] != ''){ $fname = 'uploads/student-'.$id.'.png'; $dir_path =base_app. $fname; $upload = $_FILES['img']['tmp_name']; $type = mime_content_type($upload); $allowed = array('image/png','image/jpeg'); if(!in_array($type,$allowed)){ $resp['msg'].=" But Image failed to upload due to invalid file type."; }else{ $new_height = 200; $new_width = 200; list($width, $height) = getimagesize($upload); $t_image = imagecreatetruecolor($new_width, $new_height); imagealphablending( $t_image, false ); imagesavealpha( $t_image, true ); $gdImg = ($type == 'image/png')? imagecreatefrompng($upload) : imagecreatefromjpeg($upload); imagecopyresampled($t_image, $gdImg, 0, 0, 0, 0, $new_width, $new_height, $width, $height); if($gdImg){ if(is_file($dir_path)) unlink($dir_path); $uploaded_img = imagepng($t_image,$dir_path); imagedestroy($gdImg); imagedestroy($t_image); }else{ $resp['msg'].=" But Image failed to upload due to unkown reason."; } } if(isset($uploaded_img)){ $this->conn->query("UPDATE personnel set `avatar` = CONCAT('{$fname}','?v=',unix_timestamp(CURRENT_TIMESTAMP)) where id = '{$id}' "); if($id == $this->settings->userdata('id')){ $this->settings->set_userdata('avatar',$fname); } } } return json_encode($resp); } public function delete_student(){ extract($_POST); $avatar = $this->conn->query("SELECT avatar FROM personnel where id = '{$id}'")->fetch_array()['avatar']; $qry = $this->conn->query("DELETE FROM personnel where id = $id"); if($qry){ $avatar = explode("?",$avatar)[0]; $this->settings->set_flashdata('success',' User Details successfully deleted.'); if(is_file(base_app.$avatar)) unlink(base_app.$avatar); $resp['status'] = 'success'; }else{ $resp['status'] = 'failed'; } return json_encode($resp); } public function verify_student(){ extract($_POST); $update = $this->conn->query("UPDATE `personnel` set `status` = 1 where id = $id"); if($update){ $this->settings->set_flashdata('success',' User Account has verified successfully.'); $resp['status'] = 'success'; }else{ $resp['status'] = 'failed'; } return json_encode($resp); } } $users = new users(); $action = !isset($_GET['f']) ? 'none' : strtolower($_GET['f']); switch ($action) { case 'save': echo $users->save_users(); break; case 'delete': echo $users->delete_users(); break; case 'save_student': echo $users->save_student(); break; case 'delete_student': echo $users->delete_student(); break; case 'verify_student': echo $users->verify_student(); break; default: // echo $sysset->index(); break; }
hala ka hahahahapaps denelete ko lahat ng data sa tabale hindi ko na ma access admin panel
naku lagothala ka hahahaha
eto lang ba lahat ng columns mopaps ma edit pa bo ba yung value nya naka set sa 1 and 2? {type attribute?} feel ko dyan yung problema
View attachment 1997711
ok na ata dyan papseto lang ba lahat ng columns mo
yung ano nlng paps hindi na maka upload ng avtar each userok na ata dyan paps
yes papsnakaka access ka na ba sa admin
nakaka access ka na ba sa admin
press f12 sa chrome tapos punta ka sa network tab tapos try mo mag upload ng image tapos patingin ako ng request at response
cge waitpress f12 sa chrome tapos punta ka sa network tab tapos try mo mag upload ng image tapos patingin ako ng request at response
saaan dyanpress f12 sa chrome tapos punta ka sa network tab tapos try mo mag upload ng image tapos patingin ako ng request at response
nahanap kona networkhgaha tae ang komplikado talaga. need mo ng guide jan e
mag upload ka image wag mo tatanggalin yan
oo yan ginawa ko yan lng lumabsmag upload ka image wag mo tatanggalin yan
tapos may lalabas jan
click mo yon
yung lalabas
nakikita mo yung "All"
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?