Class Db1

Database Class Class Db1

Abstract
Located at easycore/EasyDb.php

Methods summary
`public static mysqli`	# `open( boolean $isDatabaseAvailable = true )` Open Database Connection Open Database Connection Parameters `$isDatabaseAvailable` Returns mysqli
`public static mixed`	# `close( )` Close Database connection Close Database connection Returns mixed
`public static`	# `exec( $query, $closeDbOnFinished = true, $isDatabaseAvailable = true, $throwError = true, $asMultipleQuery = false )`
`public static`	# `databaseCreate( )`
`public static`	# `destroyDatabase( )`
`public static`	# `tableCreate( Model1 $modelList )` Create Multiple Table at once Create Multiple Table at once Parameters `$modelList` $modelList Throws Exception
`public static`	# `tableCreateAll( )`
`public static`	# `tableReset( $modelList )`
`public static`	# `tableResetAll( )`
`public static`	# `tableDestroy( $modelList )`
`public static`	# `tableDestroyAll( )`
`public static`	# `tableSaveBackupAll( $optionalBackupFolderName = 'all' )`
`public static array`	# `tableLoadBackupAll( string $optionalBackupFolderName = 'all', boolean $clearExistingData = true )` Restore all backup. Model Backup must end with '.model.json' Restore all backup. Model Backup must end with '.model.json' Parameters `$optionalBackupFolderName` `$clearExistingData` Returns array
`public static boolean`	# `tableClearBackupAll( string $optionalBackupFolderName = 'all' )` Clear all backup, for safety Clear all backup, for safety Parameters `$optionalBackupFolderName` Returns boolean
`public static boolean`	# `createClassTable( $tableQuery )` create table with - e.g createClassTable(UserInfo::getCreateQuery()); create table with - e.g createClassTable(UserInfo::getCreateQuery()); Parameters `$tableQuery` Returns boolean Throws Exception
`public static array`	# `getTableColumnAndTypeList( string $tableName = 'users', boolean $fullType = false )` Get Existing Table Column Information. Get Existing Table Column Information. Parameters `$tableName` `$fullType` Returns array Throws Exception
`public static array`	# `getExistingTables( boolean $withModelName = true )` Get Existing Table using USE db_name; SHOW TABLES; Get Existing Table using USE db_name; SHOW TABLES; Parameters `$withModelName` Returns array
`public static array`	# `getExistingModels( )` Get Existing Table using USE db_name; SHOW TABLES; Get Existing Table using USE db_name; SHOW TABLES; Returns array

Properties summary
`public static`	`$DB_HANDLER`	# `null`