PHP DatabaseConnection::InsertOrUpdate方法代码示例

 /**
  * Saves the object to the database
  * @return integer $newsId
  */
 function Save()
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select `newsid` from `news` where `newsid`='" . $this->newsId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $this->pog_query = "update `news` set \n\t\t\t`heading`='" . $Database->Escape($this->heading) . "', \n\t\t\t`description`='" . $Database->Escape($this->description) . "', \n\t\t\t`link`='" . $Database->Escape($this->link) . "', \n\t\t\t`live`='" . $Database->Escape($this->live) . "', \n\t\t\t`dt_created`='" . $Database->Escape($this->dt_created) . "' where `newsid`='" . $this->newsId . "'";
     } else {
         $this->pog_query = "insert into `news` (`heading`, `description`, `link`, `live`) values (\n\t\t\t'" . $Database->Escape($this->heading) . "', \n\t\t\t'" . $Database->Escape($this->description) . "', \n\t\t\t'" . $Database->Escape($this->link) . "', \n\t\t\t'" . $Database->Escape($this->live) . "' )";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->newsId == "") {
         $this->newsId = $Database->GetCurrentId();
     }
     return $this->newsId;
 }

 /**
  * Saves the object to the database
  * @return integer $restaurantId
  */
 function Save()
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select `restaurantid` from `restaurant` where `restaurantid`='" . $this->restaurantId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $this->pog_query = "update `restaurant` set \n\t\t\t`onlineuser_onlineuserid`='" . $Database->Escape($this->onlineuser_onlineuserid) . "', \n\t\t\t`logo`='" . $Database->Escape($this->logo) . "', \n\t\t\t`name`='" . $Database->Escape($this->name) . "', \n\t\t\t`description`='" . $Database->Escape($this->description) . "', \n\t\t\t`link`='" . $Database->Escape($this->link) . "', \n\t\t\t`tel`='" . $Database->Escape($this->tel) . "', \n\t\t\t`dt_created`='" . $Database->Escape($this->dt_created) . "', \n\t\t\t`dt_expire`='" . $Database->Escape($this->dt_expire) . "', \t\t\t\n\t\t\t`restaurant_status`='" . $this->restaurant_status . "' where `restaurantid`='" . $this->restaurantId . "'";
     } else {
         $this->pog_query = "insert into `restaurant` (`onlineuser_onlineuserid`, `logo`, `name`, `description`, `link`, `tel`, `dt_expire`, `restaurant_status` ) values (\n\t\t\t'" . $Database->Escape($this->onlineuser_onlineuserid) . "', \n\t\t\t'" . $Database->Escape($this->logo) . "', \n\t\t\t'" . $Database->Escape($this->name) . "', \n\t\t\t'" . $Database->Escape($this->description) . "', \n\t\t\t'" . $Database->Escape($this->link) . "', \n\t\t\t'" . $Database->Escape($this->tel) . "', \n\t\t\t'" . $Database->Escape($this->dt_expire) . "', \n\t\t\t'" . $this->restaurant_status . "' )";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->restaurantId == "") {
         $this->restaurantId = $Database->GetCurrentId();
     }
     return $this->restaurantId;
 }

 /**
  * Saves the object to the database
  * @return integer $platinum_membershipId
  */
 function Save()
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select `spotlightid` from `spotlight` where `spotlightid`='" . $this->spotlightId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $this->pog_query = "update `spotlight` set \n\t\t\t`membershipId`='" . $Database->Escape($this->membershipId) . "', \n\t\t\t`logo`='" . $Database->Escape($this->logo) . "', \n\t\t\t`image1`='" . $Database->Escape($this->image1) . "', \n\t\t\t`image2`='" . $Database->Escape($this->image2) . "', \n\t\t\t`heading`='" . $Database->Escape($this->heading) . "', \n\t\t\t`text`='" . $Database->Escape($this->text) . "', \n\t\t\t`name`='" . $Database->Escape($this->name) . "', \n\t\t\t`address`='" . $Database->Escape($this->address) . "', \n\t\t\t`tel`='" . $Database->Escape($this->tel) . "', \n\t\t\t`fax`='" . $Database->Escape($this->fax) . "', \n\t\t\t`email`='" . $Database->Escape($this->email) . "', \n\t\t\t`link`='" . $Database->Escape($this->link) . "', \n\t\t\t`dt_created`='" . $Database->Escape($this->dt_created) . "', \n\t\t\t`spotlight_type`='" . $this->spotlight_type . "' where `spotlightid`='" . $this->spotlightId . "'";
     } else {
         $this->pog_query = "insert into `spotlight` (`membershipid`, `logo`, `image1`, `image2`, `heading`, `text`, `name`, `address`, `tel`, `fax`, `email`, `link`, `spotlight_type` ) values (\n\t\t\t'" . $Database->Escape($this->membershipId) . "', \n\t\t\t'" . $Database->Escape($this->logo) . "', \n\t\t\t'" . $Database->Escape($this->image1) . "', \n\t\t\t'" . $Database->Escape($this->image2) . "', \n\t\t\t'" . $Database->Escape($this->heading) . "', \n\t\t\t'" . $Database->Escape($this->text) . "', \n\t\t\t'" . $Database->Escape($this->name) . "', \n\t\t\t'" . $Database->Escape($this->address) . "', \n\t\t\t'" . $Database->Escape($this->tel) . "', \n\t\t\t'" . $Database->Escape($this->fax) . "', \n\t\t\t'" . $Database->Escape($this->email) . "', \n\t\t\t'" . $Database->Escape($this->link) . "', \n\t\t\t'" . $this->spotlight_type . "' )";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->spotlightId == "") {
         $this->spotlightId = $Database->GetCurrentId();
     }
     return $this->spotlightId;
 }

 /**
  * Saves the object to the database
  * @return integer $onlineuserId
  */
 function Save($updatePassword = false)
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select `onlineuserid` from `onlineuser` where `onlineuserid`='" . $this->onlineuserId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $passwordSql = "'{$this->pass_word}'";
         if ($updatePassword) {
             $passwordSql = "PASSWORD('" . $this->pass_word . "')";
         }
         $this->pog_query = "update `onlineuser` set \n\t\t\t`email`='" . $Database->Escape($this->email) . "', \n\t\t\t`first_name`='" . $Database->Escape($this->first_name) . "', \n\t\t\t`last_name`='" . $Database->Escape($this->last_name) . "',`pass_word`=" . $passwordSql . ", \n\t\t\t`address_1`='" . $Database->Escape($this->address_1) . "', \n\t\t\t`address_2`='" . $Database->Escape($this->address_2) . "', \n\t\t\t`address_3`='" . $Database->Escape($this->address_3) . "', \n\t\t\t`postcode`='" . $Database->Escape($this->postcode) . "', \n\t\t\t`tel`='" . $Database->Escape($this->tel) . "', \n\t\t\t`fax`='" . $Database->Escape($this->fax) . "', \n\t\t\t`dt_created`='" . $Database->Escape($this->dt_created) . "', \n\t\t\t`user_status`='" . $this->user_status . "' where `onlineuserid`='" . $this->onlineuserId . "'";
     } else {
         $this->pog_query = "insert into `onlineuser` (`email`, `first_name`, `last_name`, `pass_word`, `address_1`, `address_2`, `address_3`, `postcode`, `tel`, `fax`, `user_status` ) values (\n\t\t\t'" . $Database->Escape($this->email) . "', \n\t\t\t'" . $Database->Escape($this->first_name) . "', \n\t\t\t'" . $Database->Escape($this->last_name) . "', \n\t\t\tPASSWORD('" . $this->pass_word . "'), \n\t\t\t'" . $Database->Escape($this->address_1) . "', \n\t\t\t'" . $Database->Escape($this->address_2) . "', \n\t\t\t'" . $Database->Escape($this->address_3) . "', \n\t\t\t'" . $Database->Escape($this->postcode) . "', \n\t\t\t'" . $Database->Escape($this->tel) . "', \n\t\t\t'" . $Database->Escape($this->fax) . "',  \n\t\t\t'" . $this->user_status . "' )";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->onlineuserId == "") {
         $this->onlineuserId = $Database->GetCurrentId();
     }
     return $this->onlineuserId;
 }

 /**
  * Saves the object to the database
  * @return integer $userId
  */
 function Save()
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select userid from `user` where `userid`='" . $this->userId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $this->pog_query = "update `user` set \r\n\t\t\t`username`='" . $Database->Escape($this->username) . "', \r\n\t\t\t`password`='" . $Database->Escape($this->password) . "', \r\n\t\t\t`firstname`='" . $Database->Escape($this->firstname) . "', \r\n\t\t\t`lastname`='" . $Database->Escape($this->lastname) . "', \r\n\t\t\t`question`='" . $Database->Escape($this->question) . "', \r\n\t\t\t`answer`='" . $Database->Escape($this->answer) . "', \r\n\t\t\t`groupid`='" . $this->groupId . "', \r\n\t\t\t`lastlogin`='" . $Database->Escape($this->lastlogin) . "', \r\n\t\t\t`disabled`='" . $Database->Escape($this->disabled) . "' where `userid`='" . $this->userId . "'";
     } else {
         $this->pog_query = "insert into `user` (`username`, `password`, `firstname`, `lastname`, `question`, `answer`, `groupid`, `lastlogin`, `disabled` ) values (\r\n\t\t\t'" . $Database->Escape($this->username) . "', \r\n\t\t\t'" . $Database->Escape($this->password) . "', \r\n\t\t\t'" . $Database->Escape($this->firstname) . "', \r\n\t\t\t'" . $Database->Escape($this->lastname) . "', \r\n\t\t\t'" . $Database->Escape($this->question) . "', \r\n\t\t\t'" . $Database->Escape($this->answer) . "', \r\n\t\t\t'" . $this->groupId . "', \r\n\t\t\t'" . $Database->Escape($this->lastlogin) . "', \r\n\t\t\t'" . $Database->Escape($this->disabled) . "' )";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->userId == "") {
         $this->userId = $Database->GetCurrentId();
     }
     return $this->userId;
 }

 /**
  * Saves the object to the database
  * @return integer $customerId
  */
 function Save()
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select customerid from `customer` where `customerid`='" . $this->customerId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $this->pog_query = "update `customer` set \r\n\t\t\t`company`='" . $Database->Escape($this->company) . "', \r\n\t\t\t`firstname`='" . $Database->Escape($this->firstname) . "', \r\n\t\t\t`lastname`='" . $Database->Escape($this->lastname) . "', \r\n\t\t\t`address1`='" . $Database->Escape($this->address1) . "', \r\n\t\t\t`address2`='" . $Database->Escape($this->address2) . "', \r\n\t\t\t`city`='" . $Database->Escape($this->city) . "', \r\n\t\t\t`mobile`='" . $Database->Escape($this->mobile) . "', \r\n\t\t\t`landline`='" . $Database->Escape($this->landline) . "', \r\n\t\t\t`email`='" . $Database->Escape($this->email) . "', \r\n\t\t\t`limit`='" . $Database->Escape($this->limit) . "', \r\n\t\t\t`available`='" . $Database->Escape($this->available) . "', \r\n\t\t\t`deleted`='" . $Database->Escape($this->deleted) . "' where `customerid`='" . $this->customerId . "'";
     } else {
         $this->pog_query = "insert into `customer` (`company`, `firstname`, `lastname`, `address1`, `address2`, `city`, `mobile`, `landline`, `email`, `limit`, `available`, `deleted` ) values (\r\n\t\t\t'" . $Database->Escape($this->company) . "', \r\n\t\t\t'" . $Database->Escape($this->firstname) . "', \r\n\t\t\t'" . $Database->Escape($this->lastname) . "', \r\n\t\t\t'" . $Database->Escape($this->address1) . "', \r\n\t\t\t'" . $Database->Escape($this->address2) . "', \r\n\t\t\t'" . $Database->Escape($this->city) . "', \r\n\t\t\t'" . $Database->Escape($this->mobile) . "', \r\n\t\t\t'" . $Database->Escape($this->landline) . "', \r\n\t\t\t'" . $Database->Escape($this->email) . "', \r\n\t\t\t'" . $Database->Escape($this->limit) . "', \r\n\t\t\t'" . $Database->Escape($this->available) . "', \r\n\t\t\t'" . $Database->Escape($this->deleted) . "' )";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->customerId == "") {
         $this->customerId = $Database->GetCurrentId();
     }
     return $this->customerId;
 }

 /**
  * Saves the object to the database
  * @return integer $supplierId
  */
 function Save()
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select supplierid from `supplier` where `supplierid`='" . $this->supplierId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $this->pog_query = "update `supplier` set \r\n\t\t\t`company`='" . $Database->Escape($this->company) . "', \r\n\t\t\t`address1`='" . $Database->Escape($this->address1) . "', \r\n\t\t\t`address2`='" . $Database->Escape($this->address2) . "', \r\n\t\t\t`city`='" . $Database->Escape($this->city) . "', \r\n\t\t\t`phone`='" . $Database->Escape($this->phone) . "', \r\n\t\t\t`contactname`='" . $Database->Escape($this->contactname) . "', \r\n\t\t\t`contactno`='" . $Database->Escape($this->contactno) . "', \r\n\t\t\t`deleted`='" . $Database->Escape($this->deleted) . "' where `supplierid`='" . $this->supplierId . "'";
     } else {
         $this->pog_query = "insert into `supplier` (`company`, `address1`, `address2`, `city`, `phone`, `contactname`, `contactno`, `deleted` ) values (\r\n\t\t\t'" . $Database->Escape($this->company) . "', \r\n\t\t\t'" . $Database->Escape($this->address1) . "', \r\n\t\t\t'" . $Database->Escape($this->address2) . "', \r\n\t\t\t'" . $Database->Escape($this->city) . "', \r\n\t\t\t'" . $Database->Escape($this->phone) . "', \r\n\t\t\t'" . $Database->Escape($this->contactname) . "', \r\n\t\t\t'" . $Database->Escape($this->contactno) . "', \r\n\t\t\t'" . $Database->Escape($this->deleted) . "' )";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->supplierId == "") {
         $this->supplierId = $Database->GetCurrentId();
     }
     return $this->supplierId;
 }

 /**
  * Saves the object to the database
  * @return integer $statsId
  */
 function Save()
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select `statsid` from `stats` where `statsid`='" . $this->statsId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $this->pog_query = "update `stats` set \n\t\t\t`objectname`='" . $Database->Escape($this->objectname) . "', \n\t\t\t`objectid`='" . $Database->Escape($this->objectid) . "', \n\t\t\t`impressions`='" . $Database->Escape($this->impressions) . "', \n\t\t\t`clicks`='" . $Database->Escape($this->clicks) . "' where `statsid`='" . $this->statsId . "'";
     } else {
         $this->pog_query = "insert into `stats` (`objectname`, `objectid`, `impressions`, `clicks`) values (\n\t\t\t'" . $Database->Escape($this->objectname) . "', \n\t\t\t'" . $Database->Escape($this->objectid) . "', \n\t\t\t'" . $Database->Escape($this->impressions) . "', \n\t\t\t'" . $Database->Escape($this->clicks) . "' )";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->statsId == "") {
         $this->statsId = $Database->GetCurrentId();
     }
     return $this->statsId;
 }

 /**
  * Saves the object to the database
  * @return integer $groupId
  */
 function Save($deep = true)
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select groupid from `group` where `groupid`='" . $this->groupId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $this->pog_query = "update `group` set \r\n\t\t\t`name`='" . $Database->Escape($this->name) . "', \r\n\t\t\t`desc`='" . $Database->Escape($this->desc) . "'where `groupid`='" . $this->groupId . "'";
     } else {
         $this->pog_query = "insert into `group` (`name`, `desc`) values (\r\n\t\t\t'" . $Database->Escape($this->name) . "', \r\n\t\t\t'" . $Database->Escape($this->desc) . "')";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->groupId == "") {
         $this->groupId = $Database->GetCurrentId();
     }
     if ($deep) {
         $userList = $this->GetUserList();
         foreach ($this->_userList as $user) {
             $user->Save($deep);
         }
     }
     return $this->groupId;
 }

 /**
  * Saves the object to the database
  * @return integer $supplier_categoryId
  */
 function Save()
 {
     $Database = new DatabaseConnection();
     $this->pog_query = "select `supplier_category_id` from `supplier_category` where `supplier_category_id`='" . $this->supplier_categoryId . "' LIMIT 1";
     $Database->Query($this->pog_query);
     if ($Database->Rows() > 0) {
         $this->pog_query = "update `supplier_category` set \n\t\t\t`name`='" . $Database->Escape($this->name) . "' where `supplier_category_id`='" . $this->supplier_categoryId . "'";
     } else {
         $this->pog_query = "insert into `supplier_category` (`name` ) values (\n\t\t\t'" . $Database->Escape($this->name) . "' )";
     }
     $Database->InsertOrUpdate($this->pog_query);
     if ($this->supplier_categoryId == "") {
         $this->supplier_categoryId = $Database->GetCurrentId();
     }
     return $this->supplier_categoryId;
 }