try { $this->db = new PDO($sPdoHost, $sPdoUser, $sPdoPasswd); $this->db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); } catch (Throwable $e) { echo "Connection Error: " . $e->getMessage(); die; }
// $sAttrName is a string & $value is a mixed value, a float in this example public function addToAttr($sAttrName, $value) { $value = $this->db->quote($value); $sql = "BEGIN CLIENT_SYS.Add_To_Attr('".$sAttrName."', ".$value.", :attr_);END;"; $oStmt = $this->db->prepare($sql); $oStmt->bindParam(':attr_', $this->aData['attr'], PDO:ARAM_STR, 32000); return $oStmt->execute(); }
public function new__($sApi) { $sSql = 'BEGIN '.$sApi.".NEW__(:result_, :attr_); END;"; $oStmt = $this->db->prepare($sSql); $oStmt->bindParam(':result_', $this->aData['result'], PDO:ARAM_STR, 4000); $oStmt->bindParam(':attr_', $this->aData['attr'], PDO:ARAM_STR, 4000); return $oStmt->execute(); }