PHP CommonQuery Beispiele

Beispiel #1

Datei: scoreDal.php Projekt: sniperking1234/WexinPublic

function UpdateScore($scoreID, $paperID, $LScore, $HScore, $scoreInfo)
{
    include_once 'sqlQuery.php';
    //$paperID,$LScore,$HScore,$scoreID为数字，不需要加单引号
    $query = "update score\n        set PaperID = {$paperID}, LScore = {$LScore}, Hscore = {$HScore}, ScoreInfo = '{$scoreInfo}' \n        where scoreID = {$scoreID}";
    return CommonQuery($query);
}

Beispiel #2

Datei: selectResultDal.php Projekt: sniperking1234/WexinPublic

function UpdateSelectScoreByID($selectResultID, $selectScore)
{
    include_once 'sqlQuery.php';
    $query = "update selectresult\n    set SelectScore = {$selectScore}\n    where SelectResultID = {$selectResultID}";
    return CommonQuery($query);
}