public function create_image_table($table)
{
if ($table == "") {
return NULL;
}
// PDO接続
$pdo = pdoSESSION();
try {
$pdo->beginTransaction();
$sql_image_table = 'CREATE TABLE IF NOT EXISTS ' . $table . ' (
id int(10) unsigned NOT NULL auto_increment COMMENT "ID",
name varchar(255) NOT NULL COMMENT "ファイル名",
date datetime NOT NULL COMMENT "日付",
flag tinyint(2) NOT NULL COMMENT "使用:1 不使用:0",
type tinyint(2) NOT NULL COMMENT "IMAGETYPE定数",
raw_data mediumblob NOT NULL COMMENT "原寸大データ",
thumb_data blob NOT NULL COMMENT "サムネイルデータ",
primary key(id)
) CHARSET=utf8 ;';
$res_image_table = $pdo->prepare($sql_image_table);
$res_image_table->execute();
$pdo->commit();
} catch (Exception $e) {
$pdo->rollBack();
echo "接続に失敗しました。" . $e->getMessage();
}
}
public function AdminTableInsert($name, $email, $pass)
{
//引数判定
if ($name == "" || $email == "" || $pass == "") {
return NULL;
}
// PDO接続
$pdo = pdoSESSION();
//SQL
$sql = $pdo->prepare('INSERT INTO tofuUser(name,password,email,flag,createdate) VALUES(:name , :pass , :email , 1 , NOW());');
$sql->bindParam(':name', $name, PDO::PARAM_STR);
$sql->bindParam(':email', $email, PDO::PARAM_STR);
$sql->bindParam(':pass', $pass, PDO::PARAM_STR);
$sql->execute();
}
