PHP Database::CallSP Examples

Example #1

File: Business.php Project: sasadjolic/SailOn

 public function CalculateResults($bo)
 {
     $db = new Database();
     $db->CallSP('RunSQL', 'RR_Fill', ' WHERE (rb.endtime is not null or rb.boatstatusid is not null) and r.raceid  = "' . $bo['raceid'] . '"');
     $db->CallSP('RunSQL', 'RR_Update', ' WHERE rb.raceid = "' . $bo['raceid'] . '"');
     $db->CallSP('RunSQL', 'RR_UpdateScore', ' WHERE raceid = "' . $bo['raceid'] . '"');
     $this->UpdateDNFCode($bo['raceid']);
     return JSONHelper::GetJSON(array(), 'result');
 }