PHP Sql_Select Examples

Example #1

File: test.php Project: hendrik-weiler/PHP-Worker-Environment-Lite

 function add()
 {
     $select = new Sql_Select(new PWEL_SQL());
     $select->from("accounts");
     $add = new Sql_Add($select);
     $add->addValues(array("ID" => 2, "username" => "hallo", "passwort" => "abc123"))->add();
 }

Example #2

File: Sql_Delete.php Project: hendrik-weiler/PHP-Worker-Environment-Lite

 /**
  * delete line from database
  * @return bool
  */
 public function delete()
 {
     if (!preg_match("/(.*)WHERE(.*)/i", $this->generateQuery())) {
         return false;
     }
     if ($this->selectClass->queryString($this->generateQuery()) == false) {
         return false;
     }
 }

Example #3

File: Sql_Update.php Project: hendrik-weiler/PHP-Worker-Environment-Lite

 /**
  * Update the database
  * @return bool
  */
 public function update()
 {
     if ($this->selectClass->queryString($this->generateQuery()) == false) {
         return false;
     }
 }

Example #4

File: Sql_Login.php Project: hendrik-weiler/PHP-Worker-Environment-Lite

 /**
  * Returns the account data from current user
  *
  * @param string $session
  * @return resource/bool
  */
 public function GetUserData($session)
 {
     $sql = new Sql_Select($this->connectorClass);
     $result = $sql->from($this->table_name)->where(array($this->column_session => $session))->query();
     return $result;
 }