- TS TS
- #61
cge paps waitthenSQL:ALTER TABLE users DROP COLUMN type;
SQL:ALTER TABLE `users` ADD COLUMN `type` INT(10) NOT NULL AFTER `last_login`;
done na papsthenSQL:ALTER TABLE users DROP COLUMN type;
SQL:ALTER TABLE `users` ADD COLUMN `type` INT(10) NOT NULL AFTER `last_login`;
awit paps ayaw parinsuccess pareho?
try mo ulet mag submit ng form
patingin nga po ng classes/Users.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;
}
ito ba?hahaha kita niyo na po problema?
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;
}
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; }
public function save_users(){
if(!isset($_POST['status']) && $this->settings->userdata('login_type') == 1){
$_POST['status'] = 1;
// $_POST['type'] = 2; icomment mo to
ahh ito?haha hindi yan paps.
public function save_users(){
if(!isset($_POST['status']) && $this->settings->userdata('login_type') == 1){
$_POST['status'] = 1;
$_POST['type'] = 2;
}
naku pano na tonow try
why po ano po ba nangyari.naku pano na to
wala kong idea kng ano gawin kowhy po ano po ba nangyari.
dapat alam mo kung anong babaguhin jan or "tatanggalin".ahh ito?
PHP:public function save_users(){ if(!isset($_POST['status']) && $this->settings->userdata('login_type') == 1){ $_POST['status'] = 1; $_POST['type'] = 2; }
if(!isset($_POST['status']) && $this->settings->userdata('login_type') == 1){
$_POST['status'] = 1;
$_POST['type'] = 2;
$_POST['type'] = 3;
$_POST['type'] = 4;
$_POST['type'] = 5;
$_POST['type'] = 6;
$_POST['type'] = 7;
$_POST['type'] = 8;
}
anu yan sir, 8 lang kalalabasan nyanPHP:if(!isset($_POST['status']) && $this->settings->userdata('login_type') == 1){ $_POST['status'] = 1; $_POST['type'] = 2; $_POST['type'] = 3; $_POST['type'] = 4; $_POST['type'] = 5; $_POST['type'] = 6; $_POST['type'] = 7; $_POST['type'] = 8; }
andito na po yung sagot sa problema niyo po.PHP:public function save_users(){ if(!isset($_POST['status']) && $this->settings->userdata('login_type') == 1){ $_POST['status'] = 1; // $_POST['type'] = 2; icomment mo to
oo sir 8 lumabasanu yan sir, 8 lang kalalabasan nyan
andito na po yung sagot sa problema niyo po.
cge try koanu yan sir, 8 lang kalalabasan nyan
andito na po yung sagot sa problema niyo po.
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?