Documentation ^jit ia\Sql\Mysql\SqlInfo Documentation Function examples Index Examples List

class ia\Sql\Mysql\SqlInfo

• /** * SqlInfo * Provides column/field metadata on executed mysqli resultset * * @author Informatica Asociada * @copyright 2015 * @version 1.0.2 */
• namespace: ia\Sql\Mysql
• Implements: Stringable

• Public Methods
  1. __construct( IaMysqli $db ) :
     /** * SqlInfo constructor. * @param IaMysqli $db */

     ---

  2. documentDb( ) :
     

     ---

  3. tableInfo( $table, $withCache = false ) :
     

     ---

  4. queryInfo( $sql, $withUniqueIndexes = true, $queryCacheKey = false ) :
     

     ---

  5. resultFieldsInfo( $fetch_fields, $withUniqueIndexes = true, $queryCacheKey = false ) :
     

     ---

  6. type2Text( integer $type_id ) : string
     /** * return mysqli type for the field * * @param integer $type_id from $result->fetch_field()->type or $result->fetch_field_direct($i)->type * @return string mysql type for id */

     ---

  7. getEnumSet( string $table $table ) : array
     /** * Return an array with enum/set columns as their key and an array of its values * * @param string $table table from where to extract enums & sets * @return array ['fieldName'=>['value1', 'value2', ...]] */

     ---

  8. table_indexes( $table ) :
     /** __________________ Indexes _________________________ */

     ---

  9. flags2Array( integer $flags_num ) : array
     /** * Get mysqli flags * * @param integer $flags_num from $result->fetch_field()->flags or $result->fetch_field_direct($i)->flags * @return array associative array with flag names indexed by mysqli constant */

     ---

• Calls:
  1. Str
  2. \ia\DevTools\iaTimer

Index Documentation Function examples Index Examples List

ia\Sql\Mysql\SqlInfo

• 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 ^🔧

Examples by function ia\Sql\Mysql\SqlInfo Documentation Function examples Index Examples List

/**
     * SqlInfo constructor.
     * @param IaMysqli $db
     */
/*
 $sqlInfo = new SqlInfo(IaMysqli $db);
*/

$sqlInfo = new SqlInfo();