Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Database O/RM
<?php
/*
* KDB database wrapper by Keiya Chinen <keiya_21@yahoo.co.jp>
*/
class KDB {
public function __construct ($user,$pass,$db,$host) {
$this->mysqli = new mysqli($host, $user, $pass, $db);
if ($this->mysqli->connect_error) {
error_log('mysqli:(could not connect to database) '.$this->mysqli->connect_error());
die('FATAL');
}
$this->mysqli->set_charset('utf8');
}
// overload
public function __get($table) {
$this->table = $table;
return $this;
}
public function query() {
$res = $this->mysqli->query($this->sql);
if ($res === true) {
}
else if ($res === false) {
error_log('mysqli:(query failed) '.$this->mysqli->error);
return false;
}
else {
$array = array();
while ($row = $res->fetch_assoc()) {
$array[] = $row;
}
return $array;
}
}
public function raw_query($placehold,$args) {
foreach ($args as $k => $v) {
$args[$k] = $this->mysqli->real_escape_string($v);
}
$this->sql = str_replace(
'?',
$args,
$placehold
);
return $this->query();
}
public function update($assoc) {
$this->sql = "UPDATE {$this->table} SET ";
foreach ($assoc as $k => $v) {
$this->sql .= "`{$k}`='".$this->mysqli->real_escape_string($v).'\',';
}
$this->sql = substr($this->sql, 0, -1);
return $this;
}
public function insert($assoc) {
$this->sql = "INSERT INTO {$this->table} SET ";
foreach ($assoc as $k => $v) {
$this->sql .= "`{$k}`='".$this->mysqli->real_escape_string($v).'\',';
}
$this->sql = substr($this->sql, 0, -1);
return $this;
}
}
<?php
/*
* User register with KDB O/RM sample
*/
require_once 'KDB.php';
$key = 'as8uhjnkjasdfb';
// 16 chars
$profile['username'] = $POST_['username'];
// password will be hashed
$profile['password'] = hash_hmac('sha512',$POST_['password'],$key,true);
// Y-m-d form
$profile['birthdate'] = $POST_['birthdate'];
$db = new KDB('root','','sso_cp','localhost');
$db->users->insert($profile)->query();
Owner

keiya commented Aug 1, 2012

KDBっていうデータベースラッパーと、それをつかってユーザ登録をするサンプル。
ユーザ登録でのパスワードは鍵付きSHA512ハッシュ関数(HMAC SHA)によりハッシュ化で、バイナリで格納。

スキーマは以下の通り
id int(10)
username varchar(16)
password binary(64)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment