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(); }