$price = $app->request->post('price'); $date_start = $app->request->post('date_start'); $date_end = $app->request->post('date_end'); if ($aid == null) { fail("aid is null"); } try { $contract = R::dispense('contract'); $contract->id = $id; $contract->sid = $sid; $contract->aid = $aid; $contract->price = $price; $contract->date_start = $date_start; $contract->date_end = $date_end; $contract->approved = "미승인"; safeStore($contract); success(''); } catch (RedBeanPHP\RedException\SQL $e) { fail($e); } }); $app->get('/agent', function () use($app) { $agent = R::findAll('agent'); success(R::exportAll($agent)); }); $app->post('/agent', function () use($app) { $json = $app->request->getBody(); $obj = json_decode($json); $aid = $obj->{'aid'}; $fee = $obj->{'fee'}; $sql = "UPDATE agent SET fee = '{$fee}' WHERE aid = '{$aid}'";
| 전남 | | 전북 | | 제주 | | 충남 | | 충북 | */ 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)); }
$school->year='string'; $school->sch_grade='string'; $school->sch_type='string'; $school->lv0='string'; $school->edu_dept='string'; $school->lv1='string'; $school->name='string'; $school->origin='string'; $school->status='string'; $school->establish='string'; $school->postal='string'; $school->address='string'; $school->phone='string'; $school->fax='string'; $school->homepage ='string'; safeStore($school); function safeStore($obj) { try { $id = R::store($obj); echo "saved id [$id]"; } catch (RedBeanPHP\RedException\SQL $e) { echo "failed: $e<br><br>"; } } ?>