PHP CommonQuery 예제들

예제 #1

파일: scoreDal.php 프로젝트: 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);
}

예제 #2

파일: selectResultDal.php 프로젝트: sniperking1234/WexinPublic

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