pub rstoetter cSmartSqlStatement cSmartSqlStatement::AddWhereClause() - rstoetter/csmartsqlstatement-php GitHub Wiki

Method AddWhereClause( ) - of API Reference pub

 public   mixed rstoetter\cSmartSqlStatement\cSmartSqlStatement::AddWhereClause(string $str_clause)
  • Namespace : rstoetter\cSmartSqlStatement
  • Class name: cSmartSqlStatement
  • This method is defined by the class rstoetter\cSmartSqlStatement\cSmartSqlStatement

The method AddWhereClause( ) adds a new WHERE clause to the existing WHERE with the operator AND The whole statement will be rescanned

Example: $obj_sql_statement = new cSmartSqlStatement('select'); $query = "select * from tbl where x= 5 and z = sqrt( v ) "; $obj_sql_statement->ScanStatement( $query ); $obj_sql_statement->AddWhereClause( '( c = "123" OR d = 25 OR h = gf) ' ); *

Arguments

  • $str_clause string - <p>the WHERE elements to add</p>