master

分支 (2)

标签 (8)

管理

管理

master

2.1

v2.7

v2.6

v2.5

v2.4

v2.3

v2.2

v2.1

v1.1

PHP-MySQLi-Database-Class
/
index.php

<?php
require_once('MysqliDb.php');
error_reporting(E_ALL);
$action = 'adddb';
$data = array();

function printUsers () {
    global $db;

    $users = $db->get ("users");
    if ($db->count == 0) {
        echo "<td align=center colspan=4>No users found</td>";
        return;
    }
    foreach ($users as $u) {
        echo "<tr>
            <td>{$u['id']}</td>
            <td>{$u['login']}</td>
            <td>{$u['firstName']} {$u['lastName']}</td>
            <td>
                <a href='index.php?action=rm&id={$u['id']}'>rm</a> ::
                <a href='index.php?action=mod&id={$u['id']}'>ed</a>
            </td>
        </tr>";
    }
}

function action_adddb () {
    global $db;

    $data = Array(
        'login' => $_POST['login'],
        'customerId' => 1,
        'firstName' => $_POST['firstName'],
        'lastName' => $_POST['lastName'],
        'password' => $db->func('SHA1(?)',Array ($_POST['password'] . 'salt123')),
        'createdAt' => $db->now(),
        'expires' => $db->now('+1Y')
    );
    $id = $db->insert ('users', $data);
    header ("Location: index.php");
    exit;
}

function action_moddb () {
    global $db;

    $data = Array(
        'login' => $_POST['login'],
        'customerId' => 1,
        'firstName' => $_POST['firstName'],
        'lastName' => $_POST['lastName'],
    );
    $id = (int)$_POST['id'];
    $db->where ("customerId",1);
    $db->where ("id", $id);
    $db->update ('users', $data);
    header ("Location: index.php");
    exit;

}
function action_rm () {
    global $db;
    $id = (int)$_GET['id'];
    $db->where ("customerId",1);
    $db->where ("id", $id);
    $db->delete ('users');
    header ("Location: index.php");
    exit;

}
function action_mod () {
    global $db;
    global $data;
    global $action;

    $action = 'moddb';
    $id = (int)$_GET['id'];
    $db->where ("id", $id);
    $data = $db->getOne ("users");
}

$db = new Mysqlidb ('localhost', 'root', '', 'testdb');
if ($_GET) {
    $f = "action_".$_GET['action'];
    if (function_exists ($f)) {
        $f();
    }
}

?>
<!DOCTYPE html>

<html lang="en">
<head>
	<meta charset="utf-8">
	<title>Users</title>
</head>
<body>

<center>
<h3>Users:</h3>
<table width='50%'>
    <tr bgcolor='#cccccc'>
        <th>ID</th>
        <th>Login</th>
        <th>Name</th>
        <th>Action</th>
    </tr>
    <?php printUsers();?>

</table>
<hr width=50%>
<form action='index.php?action=<?php echo $action?>' method=post>
    <input type=hidden name='id' value='<?php echo $data['id']?>'>
    <input type=text name='login' required placeholder='Login' value='<?php echo $data['login']?>'>
    <input type=text name='firstName' required placeholder='First Name' value='<?php echo $data['firstName']?>'>
    <input type=text name='lastName' required placeholder='Last Name' value='<?php echo $data['lastName']?>'>
    <input type=password name='password' placeholder='Password'>
    <input type=submit value='New User'></td>
</form>
</table>
</center>
</body>
</html>