本文整理汇总了PHP中common::noSqlInject方法的典型用法代码示例。如果您正苦于以下问题:PHP common::noSqlInject方法的具体用法?PHP common::noSqlInject怎么用?PHP common::noSqlInject使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类common
的用法示例。
在下文中一共展示了common::noSqlInject方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: update
public static function update($obj_Agriculture)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Agriculture SET " . "AgricultureId=" . common::noSqlInject($obj_Agriculture->AgricultureId) . "," . "AgricultureName=" . "'" . common::noSqlInject($obj_Agriculture->AgricultureName) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Agriculture->Description) . "'" . " WHERE AgricultureId=" . $obj_Agriculture->AgricultureId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Agriculture;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例2: update
public static function update($obj_Person_workingexperiance)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person_workingexperiance SET " . "WorkExpId=" . common::noSqlInject($obj_Person_workingexperiance->WorkExpId) . "," . "CompanyId=" . common::noSqlInject($obj_Person_workingexperiance->CompanyId) . "," . "StartDate=" . "'" . common::noSqlInject($obj_Person_workingexperiance->StartDate) . "'" . "," . "EndDate=" . "'" . common::noSqlInject($obj_Person_workingexperiance->EndDate) . "'" . "," . "Position=" . "'" . common::noSqlInject($obj_Person_workingexperiance->Position) . "'" . "," . "PersonId=" . common::noSqlInject($obj_Person_workingexperiance->PersonId) . " WHERE WorkExpId=" . $obj_Person_workingexperiance->WorkExpId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person_workingexperiance;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例3: update
public static function update($obj_Village_organization)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_village_organization SET " . "OrganizationId=" . common::noSqlInject($obj_Village_organization->OrganizationId) . "," . "VillageId=" . common::noSqlInject($obj_Village_organization->VillageId) . " WHERE VillageId=" . $obj_Village_organization->VillageId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Village_organization;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例4: update
public static function update($obj_Group)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_group SET " . "GroupId=" . common::noSqlInject($obj_Group->GroupId) . "," . "GroupName=" . "'" . common::noSqlInject($obj_Group->GroupName) . "'" . "," . "GroupPrimaryType=" . common::noSqlInject($obj_Group->GroupPrimaryType) . "," . "GroupMissionTypeId=" . common::noSqlInject($obj_Group->GroupMissionTypeId) . "," . "GroupAddress=" . "'" . common::noSqlInject($obj_Group->GroupAddress) . "'" . " WHERE GroupId=" . $obj_Group->GroupId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Group;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例5: update
public static function update($obj_Group_member)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_group_member SET " . "GroupId=" . common::noSqlInject($obj_Group_member->GroupId) . "," . "MemberId=" . common::noSqlInject($obj_Group_member->MemberId) . "," . "MemberType=" . "'" . common::noSqlInject($obj_Group_member->MemberType) . "'" . "," . "MemberDate=" . "'" . common::noSqlInject($obj_Group_member->MemberDate) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Group_member->Description) . "'" . " WHERE MemberId=" . $obj_Group_member->MemberId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Group_member;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例6: update
public static function update($obj_Society)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Society SET " . "SocietyId=" . common::noSqlInject($obj_Society->SocietyId) . "," . "Name=" . "'" . common::noSqlInject($obj_Society->Name) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Society->Description) . "'" . "," . "Mission=" . "'" . common::noSqlInject($obj_Society->Mission) . "'" . "," . "SocietyTypeId=" . common::noSqlInject($obj_Society->SocietyTypeId) . "," . "SocietyAddress=" . "'" . common::noSqlInject($obj_Society->SocietyAddress) . "'" . " WHERE SocietyId=" . $obj_Society->SocietyId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Society;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例7: update
public static function update($obj_User)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_user SET " . "userId=" . common::noSqlInject($obj_User->userId) . "," . "userName=" . "'" . common::noSqlInject($obj_User->userName) . "'" . "," . "password=" . "'" . common::noSqlInject($obj_User->password) . "'" . "," . "personId=" . common::noSqlInject($obj_User->personId) . "," . "userType=" . common::noSqlInject($obj_User->userType) . "," . "userOptCode=" . "'" . common::noSqlInject($obj_User->userOptCode) . "'" . "," . "userMetadata=" . "'" . common::noSqlInject($obj_User->userMetadata) . "'" . "," . "userStatus=" . common::noSqlInject($obj_User->userStatus) . " WHERE userId=" . $obj_User->userId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_User;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例8: update
public static function update($obj_Person_property)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person_property SET " . "PropertyId=" . common::noSqlInject($obj_Person_property->PropertyId) . "," . "PropertyName=" . "'" . common::noSqlInject($obj_Person_property->PropertyName) . "'" . "," . "PropertyType=" . common::noSqlInject($obj_Person_property->PropertyType) . "," . "AssessValue=" . common::noSqlInject($obj_Person_property->AssessValue) . "," . "Description=" . "'" . common::noSqlInject($obj_Person_property->Description) . "'" . " WHERE PropertyId=" . $obj_Person_property->PropertyId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person_property;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例9: update
public static function update($obj_Errorlog)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Errorlog SET " . "_id=" . common::noSqlInject($obj_Errorlog->_id) . "," . "LoggedTime=" . "'" . common::noSqlInject($obj_Errorlog->LoggedTime) . "'" . "," . "Tag=" . "'" . common::noSqlInject($obj_Errorlog->Tag) . "'" . "," . "Place=" . "'" . common::noSqlInject($obj_Errorlog->Place) . "'" . "," . "Event=" . "'" . common::noSqlInject($obj_Errorlog->Event) . "'" . "," . "Message=" . "'" . common::noSqlInject($obj_Errorlog->Message) . "'" . "," . "metadata=" . "'" . common::noSqlInject($obj_Errorlog->metadata) . "'" . "," . "Status=" . common::noSqlInject($obj_Errorlog->Status) . " WHERE _id=" . $obj_Errorlog->_id;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Errorlog;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例10: update
public static function update($obj_Village_climate)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_village_climate SET " . "ClimateId=" . common::noSqlInject($obj_Village_climate->ClimateId) . "," . "VillageId=" . common::noSqlInject($obj_Village_climate->VillageId) . "," . "ClimateReagion=" . "'" . common::noSqlInject($obj_Village_climate->ClimateReagion) . "'" . "," . "RainFall=" . common::noSqlInject($obj_Village_climate->RainFall) . "," . "Temparature=" . common::noSqlInject($obj_Village_climate->Temparature) . "," . "Humidity=" . common::noSqlInject($obj_Village_climate->Humidity) . " WHERE ClimateId=" . $obj_Village_climate->ClimateId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Village_climate;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例11: update
public static function update($obj_Business_product)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_business_product SET " . "BusinessId=" . common::noSqlInject($obj_Business_product->BusinessId) . "," . "ProductId=" . common::noSqlInject($obj_Business_product->ProductId) . " WHERE ProductId=" . $obj_Business_product->ProductId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Business_product;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例12: update
public static function update($obj_Person)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person SET " . "PersonId=" . common::noSqlInject($obj_Person->PersonId) . "," . "FullName=" . "'" . common::noSqlInject($obj_Person->FullName) . "'" . "," . "NickName=" . "'" . common::noSqlInject($obj_Person->NickName) . "'" . "," . "OtherNames=" . "'" . common::noSqlInject($obj_Person->OtherNames) . "'" . "," . "DrivingLicenceNo=" . "'" . common::noSqlInject($obj_Person->DrivingLicenceNo) . "'" . "," . "PassportNo=" . "'" . common::noSqlInject($obj_Person->PassportNo) . "'" . "," . "PermanentAddress=" . "'" . common::noSqlInject($obj_Person->PermanentAddress) . "'" . "," . "Email=" . "'" . common::noSqlInject($obj_Person->Email) . "'" . "," . "Website=" . "'" . common::noSqlInject($obj_Person->Website) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Person->Description) . "'" . "," . "Gender=" . common::noSqlInject($obj_Person->Gender) . "," . "DOB=" . "'" . common::noSqlInject($obj_Person->DOB) . "'" . "," . "Height=" . common::noSqlInject($obj_Person->Height) . "," . "Weight=" . common::noSqlInject($obj_Person->Weight) . "," . "HairColor=" . "'" . common::noSqlInject($obj_Person->HairColor) . "'" . "," . "EyeColor=" . "'" . common::noSqlInject($obj_Person->EyeColor) . "'" . "," . "BloodType=" . "'" . common::noSqlInject($obj_Person->BloodType) . "'" . "," . "Occupation=" . "'" . common::noSqlInject($obj_Person->Occupation) . "'" . "," . "MonthlyIncome=" . common::noSqlInject($obj_Person->MonthlyIncome) . "," . "FutureTargets=" . "'" . common::noSqlInject($obj_Person->FutureTargets) . "'" . "," . "FutureNeeds=" . "'" . common::noSqlInject($obj_Person->FutureNeeds) . "'" . "," . "DOD=" . "'" . common::noSqlInject($obj_Person->DOD) . "'" . "," . "Picture=" . "'" . common::noSqlInject($obj_Person->Picture) . "'" . "," . "NIC=" . "'" . common::noSqlInject($obj_Person->NIC) . "'" . "," . "Status=" . common::noSqlInject($obj_Person->Status) . " WHERE PersonId=" . $obj_Person->PersonId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例13: update
public static function update($obj_Application_forms)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Application_forms SET " . "_id=" . common::noSqlInject($obj_Application_forms->_id) . "," . "ref_no=" . common::noSqlInject($obj_Application_forms->ref_no) . "," . "mobile_no=" . "'" . common::noSqlInject($obj_Application_forms->mobile_no) . "'" . "," . "mic_no=" . common::noSqlInject($obj_Application_forms->mic_no) . "," . "cus_title=" . "'" . common::noSqlInject($obj_Application_forms->cus_title) . "'" . "," . "nic_code=" . "'" . common::noSqlInject($obj_Application_forms->nic_code) . "'" . "," . "nic_no=" . "'" . common::noSqlInject($obj_Application_forms->nic_no) . "'" . "," . "cus_name=" . "'" . common::noSqlInject($obj_Application_forms->cus_name) . "'" . "," . "cus_name_other=" . "'" . common::noSqlInject($obj_Application_forms->cus_name_other) . "'" . "," . "cus_country=" . "'" . common::noSqlInject($obj_Application_forms->cus_country) . "'" . "," . "cus_company=" . "'" . common::noSqlInject($obj_Application_forms->cus_company) . "'" . "," . "cus_address1=" . "'" . common::noSqlInject($obj_Application_forms->cus_address1) . "'" . "," . "cus_address2=" . "'" . common::noSqlInject($obj_Application_forms->cus_address2) . "'" . "," . "district=" . "'" . common::noSqlInject($obj_Application_forms->district) . "'" . "," . "cus_telephone=" . common::noSqlInject($obj_Application_forms->cus_telephone) . "," . "cus_occupation=" . "'" . common::noSqlInject($obj_Application_forms->cus_occupation) . "'" . "," . "other=" . "'" . common::noSqlInject($obj_Application_forms->other) . "'" . "," . "amount_spend=" . common::noSqlInject($obj_Application_forms->amount_spend) . "," . "no_of_family1=" . common::noSqlInject($obj_Application_forms->no_of_family1) . "," . "no_of_family2=" . common::noSqlInject($obj_Application_forms->no_of_family2) . "," . "cus_language=" . common::noSqlInject($obj_Application_forms->cus_language) . "," . "cus_email=" . "'" . common::noSqlInject($obj_Application_forms->cus_email) . "'" . "," . "sim_no=" . "'" . common::noSqlInject($obj_Application_forms->sim_no) . "'" . "," . "added_date=" . "'" . common::noSqlInject($obj_Application_forms->added_date) . "'" . "," . "img_name=" . "'" . common::noSqlInject($obj_Application_forms->img_name) . "'" . "," . "doc_path=" . "'" . common::noSqlInject($obj_Application_forms->doc_path) . "'" . "," . "folder_path=" . "'" . common::noSqlInject($obj_Application_forms->folder_path) . "'" . "," . "job_id=" . common::noSqlInject($obj_Application_forms->job_id) . "," . "meta=" . "'" . common::noSqlInject($obj_Application_forms->meta) . "'" . "," . "status=" . common::noSqlInject($obj_Application_forms->status) . " WHERE _id=" . $obj_Application_forms->_id;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Application_forms;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例14: update
public static function update($obj_Job_meta)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Job_meta SET " . "_id=" . common::noSqlInject($obj_Job_meta->_id) . "," . "LoggedTime=" . "'" . common::noSqlInject($obj_Job_meta->LoggedTime) . "'" . "," . "JobID=" . "'" . common::noSqlInject($obj_Job_meta->JobID) . "'" . "," . "JobType=" . "'" . common::noSqlInject($obj_Job_meta->JobType) . "'" . "," . "JobData=" . "'" . common::noSqlInject($obj_Job_meta->JobData) . "'" . "," . "Status=" . common::noSqlInject($obj_Job_meta->Status) . "," . "client_name=" . "'" . common::noSqlInject($obj_Job_meta->client_name) . "'" . "," . "client_mobile=" . "'" . common::noSqlInject($obj_Job_meta->client_mobile) . "'" . "," . "client_simid=" . "'" . common::noSqlInject($obj_Job_meta->client_simid) . "'" . "," . "client_nic=" . "'" . common::noSqlInject($obj_Job_meta->client_nic) . "'" . " WHERE _id=" . $obj_Job_meta->_id;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Job_meta;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
示例15: update
public static function update($obj_Business)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_business SET " . "BusinessId=" . common::noSqlInject($obj_Business->BusinessId) . "," . "Name=" . "'" . common::noSqlInject($obj_Business->Name) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Business->Description) . "'" . "," . "Address=" . "'" . common::noSqlInject($obj_Business->Address) . "'" . "," . "telephone=" . "'" . common::noSqlInject($obj_Business->telephone) . "'" . "," . "fax=" . "'" . common::noSqlInject($obj_Business->fax) . "'" . "," . "website=" . "'" . common::noSqlInject($obj_Business->website) . "'" . "," . "email=" . "'" . common::noSqlInject($obj_Business->email) . "'" . "," . "BusinessTypeId=" . common::noSqlInject($obj_Business->BusinessTypeId) . "," . "BusinessSubTypeId=" . common::noSqlInject($obj_Business->BusinessSubTypeId) . " WHERE BusinessId=" . $obj_Business->BusinessId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Business;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}