| 인천 | | 전남 | | 전북 | | 제주 | | 충남 | | 충북 | */ R::setup( 'mysql:host=localhost;dbname=smartqna', 'root', 'denters0318' ); $region= R::dispense('region'); $region->lv0='string'; $region->lv1='string'; setUnique($region, array('lv0', 'lv1')); safeStore($region); function safeStore($obj) { try { $id = R::store($obj); echo "saved id [$id]"; } catch (RedBeanPHP\RedException\SQL $e) { echo "failed: $e<br><br>"; } } function setUnique($bean, $arr) { $bean->setMeta("buildcommand.unique" , array($arr));
$book->name = 'EBS수2미분과적분'; $book->publisher = 'EBS'; //setUnique($book, array('name')); safeStore($book); //mentor $mentor = R::dispense('mentor'); $mentor->name = '곽동녘'; $mentor->dept = '연세대'; $mentor->imgurl = 'http://venusproject.co.kr/smartqna/data/img/mentor/001.jpg'; $mentor->motto = 'be the best'; $mentor->msg = 'fighting!'; safeStore($mentor); $map = R::dispense('mentor2book'); $map->mentorid = 1; $map->bookid = 4; setUnique($map, array('mentorId', 'bookId')); safeStore($map); }); $app->post('/login', function () use($app) { $body = $app->request->getBody(); $json = json_decode($body); $uid = $json->{'uid'}; $pass = $json->{'pass'}; $user = R::findOne('user', "uid = '{$uid}' AND pass = PASSWORD('{$pass}')"); if (isset($user)) { success(R::exportAll($user)); } else { fail("id/pass mismatch, body:{$body}"); } }); $app->post('/signup', function () use($app) {