php 寫資料庫更新記錄

echo "open data base，and select records/n";
$dmsDbInfo = CMSDbInfoConfig();
$infoPro = new CInfoProvider;
$infoPro->SetAdoConnectionPtr($dmsDbInfo);

//
$searchMd5 = "select ";
$searchMd5 .= "*";
$searchMd5 .= " from ";
$searchMd5 .= FUN2_POST_XML_MAP_TBL;
$searchMd5 .= " where ";
$searchMd5 .= "(";
$searchMd5 .= FUN2_PXM_MD5;
$searchMd5 .= " = '";
$searchMd5 .= $md5;
$searchMd5 .= "'";
$searchMd5 .= ")";
$searchMd5 .= "AND";
$searchMd5 .= "(";
$searchMd5 .= FUN2_PXM_STATE;
$searchMd5 .= " = ";
$searchMd5 .= FUN2_PXM_STATE_ENABLE_QUERY;
$searchMd5 .= ")";

if( FUN2_ERR_SUCCESS != $infoPro->Search($searchMd5) )
{
    echo "DB failed/n";
    $strRet.= FUN2_ERR_FAILED;
}
else
{
    if( $infoPro->MoveFirst() )
    {
        $record = $infoPro->GetRecordsetPtr();
        if( NULL != $record )
        {
           echo $record."=>md5-find it/n";
            $strRet .=1;
        }
        else
        {
            $strRet.=FUN2_ERR_PARAM;
        }
    }
    else
    {
        $strRet.= FUN2_ERR_FAILED;
    }
}

 

//update records if you have known primary key

   

    $sqlCommand = "UPDATE ";
    $sqlCommand .= FUN2_UEVT_VEH_MAP_TABLE;
    $sqlCommand .= " SET ";
    $sqlCommand .= FUN2_UEV_STATUS;
    $sqlCommand .= "='";
    $sqlCommand .= $handleRes;
    $sqlCommand .= "'";
    $sqlCommand .= " where ";
    $sqlCommand .= FUN2_UEV_VHC_ID;
    $sqlCommand .= " IN (";
    foreach($carIds AS $carId )
    {
        $sqlCommand .= "'";
        $sqlCommand .= $carId;
        $sqlCommand .= "',";
    }
    $sqlCommand = substr($sqlCommand,0,strlen($sqlCommand)-1);
    $sqlCommand .= ")";
    $sqlCommand .= " and ";
    $sqlCommand .= FUN2_UEV_EVT;
    $sqlCommand .= "='";
    $sqlCommand .= $eventId;
    $sqlCommand .= "'";
    $sqlCommand .= " and ";
    $sqlCommand .= FUN2_UEV_STATUS;
    $sqlCommand .= "='";
    $sqlCommand .= FUN2_UEV_STATUS_ACKNOWLEDGED;
    $sqlCommand .= "'";

    $cmsDbInfo = CMSDbInfoConfig();
    $db = new CMysqlConnect;
    $db->SetDbInfo($cmsDbInfo);
    $ret = $db->Connent();
    if(!$ret)
    {
        $strRet.=FUN2_ERR_FAILED;
        goto Err;
    }

    $result = mysql_query($sqlCommand);
    if( FALSE == $result )
    {
        $strRet.=FUN2_ERR_FAILED;
        goto Err;
    }
    else
    {
        $strRet.=FUN2_ERR_SUCCESS;
    }