gianghl1983/account_edit

## account_edit
<?php
include ('database/connect.php');

//B1 = check ID
//B2= nap lai data
//B3= update

$errors = [];
$id = isset($_GET['id']) ? (int) $_GET['id'] : 0;

if ($id == 0) {
    header('Location: account_qltc.php');
    exit;
}

//Lay thong tin tu database theo id
$sql = sprintf("SELECT * FROM accounts WHERE id=%d LIMIT 1", $id);
$query = $db_qltc->query($sql);
if (!$query) {
     header('Location: account_qltc.php');
    exit;
}
$account = $query->fetch_array(true);//laays 1 ban ghi???


//cbi du lieu de INSERT
if (isset($_POST['submit'])) {
    if (!isset($_POST['name']) || $_POST['name'] == '') {
        $errors[] = 'Vui long nhap ten tai khoan';
    } else {
        $name = trim($_POST['name']);
    }
    if (!isset($_POST['status']) || $_POST['status'] == '') {
        $errors[] = 'Vui long chon trang thai';
    } else {
        $status = $_POST['status'];
    }

    if (!isset($_POST['type']) || $_POST['type'] == '') {
        $errors[] = 'Vui long chon loai tai khoan';
    } else {
        $type = $_POST['type'];
    }

    $note = isset($_POST['note']) ? $_POST['note'] : '';

    if (count($errors) == 0) {
        // UPDATE TenBang SET column1=value1, column2=value2,...,columnn=valuen WHERE Dieu_Kien;
        $sql = "UPDATE accounts SET name='$name', status='$status', type='$type', note='$note' WHERE id=$id";//test myPHP
        $query = $db_qltc->query($sql);
        if ($query) {
            header('Location: account_qltc.php');
            exit;
        }
    }
}

?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Thêm tài khoản mới</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
    <?php
    if (count($errors) > 0):
        for ($i = 0; $i < count($errors); $i++) :
    ?>
    <p style="color:red"><?php echo $errors[$i];?></p>
    <?php
        endfor;
    endif;
    ?>
    <form action="" method="POST">
        <input type="text" name="name" value="<?php echo $account['name'];?>"><br>
        <select name="status">
            <option value="">Chọn trạng thái</option>
            <option value="Open" <?php if ($account['status'] == 'Open') :?> selected="selected"<?php endif;?>>Mở</option>
            <option value="Close" <?php if ($account['status'] == 'Close') :?> selected="selected"<?php endif;?>>Đóng</option>
        </select><br>
        <select name="type">
            <option value="">Chọn loại tài khoản</option>
            <option value="TM" <?php if ($account['type'] == 'TM') :?> selected="selected"<?php endif;?>>Tiền mặt</option>
            <option value="VDT" <?php if ($account['type'] == 'VDT') :?> selected="selected"<?php endif;?>>Ví điện tử</option>
            <option value="TKNH" <?php if ($account['type'] == 'TKNH') :?> selected="selected"<?php endif;?>>Tài khoản ngân hàng</option>
        </select><br>
        <textarea name="note" cols="30" rows="10"><?php echo $account['note'];?></textarea>
        <input type="hidden" name="user_id" value="1">
        <button type="submit" name="submit">Cập nhật</button>
    </form>
</body>
</html>
	<?php
	include ('database/connect.php');

	//B1 = check ID
	//B2= nap lai data
	//B3= update

	$errors = [];
	$id = isset($_GET['id']) ? (int) $_GET['id'] : 0;

	if ($id == 0) {
	header('Location: account_qltc.php');
	exit;
	}

	//Lay thong tin tu database theo id
	$sql = sprintf("SELECT * FROM accounts WHERE id=%d LIMIT 1", $id);
	$query = $db_qltc->query($sql);
	if (!$query) {
	header('Location: account_qltc.php');
	exit;
	}
	$account = $query->fetch_array(true);//laays 1 ban ghi???


	//cbi du lieu de INSERT
	if (isset($_POST['submit'])) {
	if (!isset($_POST['name']) \|\| $_POST['name'] == '') {
	$errors[] = 'Vui long nhap ten tai khoan';
	} else {
	$name = trim($_POST['name']);
	}
	if (!isset($_POST['status']) \|\| $_POST['status'] == '') {
	$errors[] = 'Vui long chon trang thai';
	} else {
	$status = $_POST['status'];
	}

	if (!isset($_POST['type']) \|\| $_POST['type'] == '') {
	$errors[] = 'Vui long chon loai tai khoan';
	} else {
	$type = $_POST['type'];
	}

	$note = isset($_POST['note']) ? $_POST['note'] : '';

	if (count($errors) == 0) {
	// UPDATE TenBang SET column1=value1, column2=value2,...,columnn=valuen WHERE Dieu_Kien;
	$sql = "UPDATE accounts SET name='$name', status='$status', type='$type', note='$note' WHERE id=$id";//test myPHP
	$query = $db_qltc->query($sql);
	if ($query) {
	header('Location: account_qltc.php');
	exit;
	}
	}
	}

	?>
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8" />
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<title>Thêm tài khoản mới</title>
	<meta name="viewport" content="width=device-width, initial-scale=1">
	</head>
	<body>
	<?php
	if (count($errors) > 0):
	for ($i = 0; $i < count($errors); $i++) :
	?>
	<p style="color:red"><?php echo $errors[$i];?></p>
	<?php
	endfor;
	endif;
	?>
	<form action="" method="POST">
	<input type="text" name="name" value="<?php echo $account['name'];?>"><br>
	<select name="status">
	<option value="">Chọn trạng thái</option>
	<option value="Open" <?php if ($account['status'] == 'Open') :?> selected="selected"<?php endif;?>>Mở</option>
	<option value="Close" <?php if ($account['status'] == 'Close') :?> selected="selected"<?php endif;?>>Đóng</option>
	</select><br>
	<select name="type">
	<option value="">Chọn loại tài khoản</option>
	<option value="TM" <?php if ($account['type'] == 'TM') :?> selected="selected"<?php endif;?>>Tiền mặt</option>
	<option value="VDT" <?php if ($account['type'] == 'VDT') :?> selected="selected"<?php endif;?>>Ví điện tử</option>
	<option value="TKNH" <?php if ($account['type'] == 'TKNH') :?> selected="selected"<?php endif;?>>Tài khoản ngân hàng</option>
	</select><br>
	<textarea name="note" cols="30" rows="10"><?php echo $account['note'];?></textarea>
	<input type="hidden" name="user_id" value="1">
	<button type="submit" name="submit">Cập nhật</button>
	</form>
	</body>
	</html>