function login() { require 'Conn/Redirect.php'; $redirect = new Redirect(); if (isset($_POST["name"]) && isset($_POST["pwd"])) { $name = $_POST["name"]; $pwd = md5($_POST["pwd"]); require_once 'Conn/Mysql.php'; $mysql = new Mysql(); $mysql->query("select * from users where name ='{$name}';"); $row = $mysql->get_object(); if (isset($row)) { if ($row->pwd == $pwd) { session_start(); $_SESSION['user'] = $name; $redirect->go('index.php'); } else { $error = "密码错误!"; $redirect->go('index.php?page=login'); } } else { $error = "用户名不存在!"; $redirect->go('index.php?page=login'); } } else { $error = "用户名或密码不能为空!"; $redirect->go('index.php?page=login'); } }
function getSocieteDeNomEtDeVille($nom, $ville) { //echo "SELECT * FROM `societe` WHERE nom='".$nom."' AND ville='".$ville."'"; return Mysql::get_object("SELECT * FROM `societe` WHERE nom='" . $nom . "' AND ville='" . $ville . "'"); }
/** * Renvoie un objet depuis sa table et son id * @param string $table * @param int $id * @return object */ static function get_object_from_id($table, $id) { return Mysql::get_object("SELECT * FROM `%s` WHERE id = '%d'", $table, $id); }