public function getGachaContentsData() { $db = CommonDB::connectMasterDB(); $sql = "\n\t\t\tSELECT \n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\tmaster_gacha_contents\n\t\t\t;\n\t\t\t"; $stml = $db->prepare($sql); $stml->execute(); $ret = $stml->fetchAll(PDO::FETCH_ASSOC); return $ret; }
public function getPassFromUid($uid) { $db = CommonDB::connectDB(); $sql = "\n\t\t\tSELECT\n\t\t\t\tuid\n\t\t\t\t,pass\n\t\t\t\t,name\n\t\t\tFROM\n\t\t\t\tuser_base_data\n\t\t\tWHERE\n\t\t\t\tuid = :uid\n\t\t\t;\n\t\t"; $stml = $db->prepare($sql); $stml->bindParam(':uid', $uid); $stml->execute(); $ret = $stml->fetch(PDO::FETCH_ASSOC); return $ret; }