Disclaimer: Auto generated file. Please help us setting parameters to useful values and extending the examples.

/*
 $sqlBuilder = new SqlBuilder();
*/

$sqlBuilder = new SqlBuilder();

• $sqlBuilder->quote(string $fieldName, mixed $value, array $fieldNameDontQuote = []) : string

  /**
       * Returns value protected with strit or not.
       *
       * @param string \$fieldName
       * @param mixed \$value
       * @param array \$fieldNameDontQuote fieldnames not to quote [fieldName1, fieldName2, ...]
       * @return string
       */

  1. $sqlBuilder->quote('palabra', null /* =mixed= */); -> NULL
• $sqlBuilder->where(array|string $where, array $whereDontQuoteFieldName = []) : string

  /**
       * Build a where clause from an array or string
       *
       * @example
       *
       * @param array|string \$where array('col_1'=>3,...)  col_1 = '3' AND ...  or string col_1=1
       * @param array \$whereDontQuoteFieldName array('col_2',...) col_1's value wont be quoted
       * @return string where clause
       *
       */

  1. $sqlBuilder->where(['a' => '1', 'b' => '2', 'c' => 3]); -> ( `a`='1' AND `b`='2' AND `c`='3')
• $sqlBuilder->build_sql_in(string $fieldName, array|string $whereValues, array $fieldNameDontQuote = []) : string

  /**
       * Returns \$fieldName=\$value or \$fieldName IS NULL or \$fieldName IN ( values in array)
       * Protecting \$filedNmae and \$value as required.
       *
       * @param string \$fieldName
       * @param array|string \$whereValues
       * @param array \$fieldNameDontQuote
       * @return string \$fieldName=\$value or \$fieldName IS NULL or \$fieldName IN ( values in array)
       */

  1. $sqlBuilder->build_sql_in('palabra', ['a' => '1', 'b' => '2', 'c' => 3]); -> (`palabra` IN ('1','2','3'))
• $sqlBuilder->update(string $table, array $values, string|array $where = [], array $fieldNameDontQuote = [], array $whereDontQuoteFieldName = []) : string

  /**
       * Create an Sql update query.
       *
       * @param string \$table
       * @param array \$values array('col_1'=>'value', ...)
       * @param string|array \$where array('col_1'=>'3',...)  col_1 = 3 AND ...  or string col_1=1
       * @param array \$fieldNameDontQuote  array('col_2',...) col_2's value wont be quoted in the set clause
       * @param array \$whereDontQuoteFieldName array('col_1',...) col_1's value wont be quoted in the where clause
       * @return string Sql update command
       *
       * @see \$dontQuoteValue
       * @see \$dontQuoteFieldName
       * @see where()
       */

  1. $sqlBuilder->update('palabra', ['a' => '1', 'b' => '2', 'c' => 3]); -> UPDATE /* include */ `palabra` SET `a`='1',`b`='2',`c`='3' WHERE
• $sqlBuilder->updateLastChanged(string $table, array $values, array $where = [], array $fieldsChanged = [], array $fieldNameDontQuote = [], array $whereDontQuoteFieldName = []) : array

  /**
       * SqlBuilder::updateLastChanged()
       *
       * @param string \$table
       * @param string \$values
       * @param array \$where
       * @param array \$fieldsChanged ['last_updated'=>'NOW()', 'updated_by'=>'userName']
       * @param array \$fieldNameDontQuote
       * @param array \$whereDontQuoteFieldName
       * @return array sql statemtns ['update', 'update \$fieldsChanged WHERE lastUpdated changed row' ]
       */

  1. $sqlBuilder->updateLastChanged('palabra', ['a' => '1', 'b' => '2', 'c' => 3]); -> 
     

     Array
     (
         [0] => UPDATE /* ia\Sql\Mysql\SqlBuilder::updateLastChanged */ `palabra` SET `a`='1',`b`='2',`c`='3' WHERE 
     )
     

• $sqlBuilder->insert(string $table, array $values, bool $autoOnUpdate = false, bool $autoOnUpdate true: an on duplicate key update clause will be added with $onUpdate = '', array $fieldNameDontOnUpdate = [], array $fieldNameDontQuote = []) : string

  /**
       * Create an Sql insert query
       *
       * @param string \$table
       * @param array \$values array('col_1'=>'value', ...)
       * @param bool \$autoOnUpdate true: an on duplicate key update clause will be added with \$onUpdate concateanted
       *        with all fields not in \$fieldNameDontQuote nor in \$this->dontOnUpdateFieldName
       * @param string \$onUpdate add to ON DUPLICATE KEY UPDATE  ie set last_insert_id: primary_key=LAST_INSERT_ID(primary_key)
       * @param array \$fieldNameDontOnUpdate array('col_1',...) col_1's value wont be quoted in the values clause
       * @param array \$fieldNameDontQuote  array('col_1',...) col_1's value wont be quoted in the values clause
       * @return string Sql insert command
       *
       */

  1. $sqlBuilder->insert('palabra', ['a' => '1', 'b' => '2', 'c' => 3]); -> INSERT /* include */ INTO `palabra`(`a`,`b`,`c`) VALUES('1','2','3')
• $sqlBuilder->insertInto(string $table $table, array $values) : string

  /**
       * Build an insert into clause, with the filed names from  the keys of \$values array
       *
       * @example
       *
       *
       * @param string \$table table name for query
       * @param array \$values array('col_1'=>'value', ...)
       * @return string insert into clause, with the filed names from  the keys of \$values array
       *
       * @see insertValues()
       * @see insertOnDuplicateKey()
       *
       */

  1. $sqlBuilder->insertInto('palabra', ['a' => '1', 'b' => '2', 'c' => 3]); -> INSERT INTO `palabra`(`a`,`b`,`c`)
• $sqlBuilder->insertValues(array $values, array $fieldNameDontQuote = []) : string

  /**
       * Returns a values clause for multiple inserts
       *
       *
       * @example
       *
       *
       * @param array \$values array('col_1'=>'value', ...)
       * @param array \$fieldNameDontQuote fieldnames not to quote [fieldName1, fieldName2, ...]
       * @return string
       *
       * @see \$dontQuoteValue
       * @see \$dontQuoteFieldName
       * @see insertInto()
       * @see insertOnDuplicateKey()
       */

  1. $sqlBuilder->insertValues(['a' => '1', 'b' => '2', 'c' => 3]); -> ('1','2','3')
• $sqlBuilder->insertOnDuplicateKey(array $values, bool $updateAllFields = true, string $onUpdate = '', array $fieldNameDontOnUpdate = []) : string

  /**
       * Build an ON DUPLICATE KEY UPDATE clause
       *
       * @param array \$values array('col_1'=>'value', ...)
       * @param bool \$updateAllFields true set fieldname=VALUES(fieldname) for all fields
       * @param string \$onUpdate  add to ON DUPLICATE KEY UPDATE  ie set last_insert_id: ,primary_key=LAST_INSERT_ID(primary_key)
       * @param array \$fieldNameDontOnUpdate
       * @return string an ON DUPLICATE KEY UPDATE clause
       *
       * @see \$dontOnUpdateFieldName
       * @see insertInto()
       * @see insertValues() trim
       */

  1. $sqlBuilder->insertOnDuplicateKey(['a' => '1', 'b' => '2', 'c' => 3]); ->  ON DUPLICATE KEY UPDATE ,`a`=VALUES(`a`),`b`=VALUES(`b`),`c`=VALUES(`c`)