php写记录,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;

}