Documentation ^jit ia\Sql\Mysql\MultipleInsert Documentation Usage sample Index Examples List

class ia\Sql\Mysql\MultipleInsert

• namespace: ia\Sql\Mysql
• Implements: Stringable

• Public Methods
  1. __construct( IaMysqli $db, string $insertIntoClause, string $onDuplicateClause = '', integer $maxLength = 5000, bool $simulate = false ) :
     /** * MultipleInsert::__construct() * * @param IaMysqli $db * @param string $insertIntoClause * @param string $onDuplicateClause * @param integer $maxLength * @param bool $simulate * @return */

     ---

  2. valuesArray( array $values, array $fieldNameDontQuote = [] ) : bool
     /** * Add 1 value clause from an array ['fieldName'=>value] * * @param array $values * @param array $fieldNameDontQuote * @return bool */

     ---

  3. insertAllArrayOfValues( array $array, array $fieldNameDontQuote = [] ) : bool
     /** * An array of values to insert [[field1=>1,field2=>2,...],[field1=>11,field2=>12,...],...] * * @param array $array * @param array $fieldNameDontQuote * @return bool */

     ---

  4. valuesString( string $valueString ) : bool
     /** * MultipleInsert::valuesString() * * @param string $valueString * @return bool */

     ---

  5. insertNow( ) :
     /** * Inserts all values received * * @return */

     ---

  6. get_valuesClauseNum( ) : int
     /** * MultipleInsert::get_valuesClauseNum() * * @return int */

     ---

  7. get_valuesCurrentNum( ) : int
     /** * MultipleInsert::get_valuesCurrentNum() * * @return int */

     ---

  8. get_insertsOkNum( ) : int
     /** * MultipleInsert::get_insertsOkNum() * * @return int */

     ---

  9. get_insertsErrorsNum( ) : int
     /** * MultipleInsert::get_insertsErrorsNum() * * @return int */

     ---

  10. get_insertLast( ) : string
      /** * MultipleInsert::get_insertLast() * * @return string */

      ---

  11. get_insertLastOk( ) : string
      /** * MultipleInsert::get_insertLastOk() * * @return string */

      ---

  12. get_currentLength( ) : int
      /** * MultipleInsert::get_currentLength() * * @return int */

      ---

  13. get_insertIntoLength( ) : int
      /** * MultipleInsert::get_insertIntoLength() * * @return int */

      ---

  14. get_simulate( ) : bool
      /** * MultipleInsert::get_simulate() * * @return bool */

      ---

  15. set_simulate( bool $simulate ) : bool
      /** * MultipleInsert::set_simulate() * * @param bool $simulate * @return bool */

      ---

  16. get_allInserts( ) : array
      /** * MultipleInsert::get_allInserts() * * @return array */

      ---

• Calls:
  1. SqlBuilder

Index Documentation Usage sample Index Examples List

ia\Sql\Mysql\MultipleInsert

• AesCipher ^🔧
• iaLibAutoLoader ^🔧
• iaSqlite ^🔧
• ia
  • Data
    • MexicoEstados ^🔧
  • Date
    • DateFormatter ^🔧
    • DateUtil ^🔧
    • YearMonth ^🔧
  • DevTools
    • iaTimer ^🔧
  • DocumentIt
    • DocumentIt ^🔧
    • PerfilExample ^🔧
  • JqGrid
    • Filter2where ^🔧
    • JqGridRead ^🔧
  • Lib
    • iaArray ^🔧
    • iaFileUploader ^🔧
    • iaFiller ^🔧
    • iaLib ^🔧
    • iaPalabra ^🔧
    • iaParametros ^🔧
    • iaPwd ^🔧
    • iaRanger ^🔧
    • iaReMapKeys ^🔧
    • iaTableIt ^🔧
    • iaUploadFile ^🔧
    • Synonyms ^🔧
  • Math
    • BcMath ^🔧
    • Combination ^🔧
    • Math ^🔧
    • Permutation ^🔧
    • Stats ^🔧
    • StatsTotalIt ^🔧
  • Sql
    • Mysql
      • CommonQueries ^🔧
      • IaMysqli ^🔧
      • MultipleInsert ^🔧
      • QueryInfo ^🔧
      • SqlBuilder ^🔧
      • SqlInfo ^🔧
      • SqlTable ^🔧
  • Util
    • FileIt ^🔧
    • FormatIt ^🔧
    • Str ^🔧
    • XlsxUtil ^🔧
  • Work
    • WorkDay
      • WorkDay ^🔧
      • WorkDayCalculator ^🔧
      • WorkHourCalculator ^🔧
    • Workflow
      • wfx ^🔧
      • WF_dateIt ^🔧
      • WF_DisplayTable ^🔧
      • WF_template ^🔧
• PushId ^🔧
• URLify ^🔧
• XLSXWriter ^🔧

Usage sample ia\Sql\Mysql\MultipleInsert Documentation Usage sample Index Examples List

ia\Sql\Mysql\IacSqlException: No such file or directory in /lamp/www/iaLib/inc_ia/Sql/src/mysql/IaMysqli.php:497
Stack trace:
#0 /lamp/www/iaLib/inc_ia/Sql/src/mysql/IaMysqli.php(465): ia\Sql\Mysql\IaMysqli->connect_real('Connect to DB')
#1 /lamp/www/iaLib/ia_examples/usage/ia/Sql/Mysql/MultipleInsert_usage.php(35): ia\Sql\Mysql\IaMysqli->connect()
#2 /lamp/www/iaLib/ia_examples/template/ia_example_class.php(100): include('/lamp/www/iaLib...')
#3 /lamp/www/iaLib/ia_examples/ia/Sql/Mysql/MultipleInsert_example.php(10): include('/lamp/www/iaLib...')
#4 /lamp/www/iaLib/ia_examples/showDoc.php(24): include('/lamp/www/iaLib...')
#5 {main}

End: ia\Sql\Mysql\MultipleInsert Documentation Usage sample Index Examples List