$thisID = MYSQL_RESULT($result, $i, "ID"); $thisUSER = MYSQL_RESULT($result, $i, "USER"); $thisHOST = MYSQL_RESULT($result, $i, "HOST"); $thisDB = MYSQL_RESULT($result, $i, "DB"); $thisCOMMAND = MYSQL_RESULT($result, $i, "COMMAND"); $thisTIME = MYSQL_RESULT($result, $i, "TIME"); $thisSTATE = MYSQL_RESULT($result, $i, "STATE"); $thisINFO = MYSQL_RESULT($result, $i, "INFO"); $thisID = highlightSearchTerms($thisID, $thisKeyword, $highlightColor); $thisUSER = highlightSearchTerms($thisUSER, $thisKeyword, $highlightColor); $thisHOST = highlightSearchTerms($thisHOST, $thisKeyword, $highlightColor); $thisDB = highlightSearchTerms($thisDB, $thisKeyword, $highlightColor); $thisCOMMAND = highlightSearchTerms($thisCOMMAND, $thisKeyword, $highlightColor); $thisTIME = highlightSearchTerms($thisTIME, $thisKeyword, $highlightColor); $thisSTATE = highlightSearchTerms($thisSTATE, $thisKeyword, $highlightColor); $thisINFO = highlightSearchTerms($thisINFO, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisID; ?> </TD> <TD><?php echo $thisUSER; ?> </TD> <TD><?php echo $thisHOST;
$bgColor = "#C0C0C0"; } $thisGRANTEE = MYSQL_RESULT($result, $i, "GRANTEE"); $thisTABLE_CATALOG = MYSQL_RESULT($result, $i, "TABLE_CATALOG"); $thisTABLE_SCHEMA = MYSQL_RESULT($result, $i, "TABLE_SCHEMA"); $thisTABLE_NAME = MYSQL_RESULT($result, $i, "TABLE_NAME"); $thisCOLUMN_NAME = MYSQL_RESULT($result, $i, "COLUMN_NAME"); $thisPRIVILEGE_TYPE = MYSQL_RESULT($result, $i, "PRIVILEGE_TYPE"); $thisIS_GRANTABLE = MYSQL_RESULT($result, $i, "IS_GRANTABLE"); $thisGRANTEE = highlightSearchTerms($thisGRANTEE, $thisKeyword, $highlightColor); $thisTABLE_CATALOG = highlightSearchTerms($thisTABLE_CATALOG, $thisKeyword, $highlightColor); $thisTABLE_SCHEMA = highlightSearchTerms($thisTABLE_SCHEMA, $thisKeyword, $highlightColor); $thisTABLE_NAME = highlightSearchTerms($thisTABLE_NAME, $thisKeyword, $highlightColor); $thisCOLUMN_NAME = highlightSearchTerms($thisCOLUMN_NAME, $thisKeyword, $highlightColor); $thisPRIVILEGE_TYPE = highlightSearchTerms($thisPRIVILEGE_TYPE, $thisKeyword, $highlightColor); $thisIS_GRANTABLE = highlightSearchTerms($thisIS_GRANTABLE, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisGRANTEE; ?> </TD> <TD><?php echo $thisTABLE_CATALOG; ?> </TD> <TD><?php echo $thisTABLE_SCHEMA;
while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisID = MYSQL_RESULT($result, $i, "ID"); $thisALIAS_MODE = MYSQL_RESULT($result, $i, "ALIAS_MODE"); $thisPATTERN = MYSQL_RESULT($result, $i, "PATTERN"); $thisREPLACEMENT = MYSQL_RESULT($result, $i, "REPLACEMENT"); $thisSITE_ROOT = MYSQL_RESULT($result, $i, "SITE_ROOT"); $thisID = highlightSearchTerms($thisID, $thisKeyword, $highlightColor); $thisALIAS_MODE = highlightSearchTerms($thisALIAS_MODE, $thisKeyword, $highlightColor); $thisPATTERN = highlightSearchTerms($thisPATTERN, $thisKeyword, $highlightColor); $thisREPLACEMENT = highlightSearchTerms($thisREPLACEMENT, $thisKeyword, $highlightColor); $thisSITE_ROOT = highlightSearchTerms($thisSITE_ROOT, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisID; ?> </TD> <TD><?php echo $thisALIAS_MODE; ?> </TD> <TD><?php echo $thisPATTERN;
while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisPROPERTY_ID = MYSQL_RESULT($result, $i, "PROPERTY_ID"); $thisPROPERTYDEF_ID = MYSQL_RESULT($result, $i, "PROPERTYDEF_ID"); $thisPROPERTY_MAPPING_ID = MYSQL_RESULT($result, $i, "PROPERTY_MAPPING_ID"); $thisPROPERTY_MAPPING_TYPE = MYSQL_RESULT($result, $i, "PROPERTY_MAPPING_TYPE"); $thisPROPERTY_VALUE = MYSQL_RESULT($result, $i, "PROPERTY_VALUE"); $thisPROPERTY_ID = highlightSearchTerms($thisPROPERTY_ID, $thisKeyword, $highlightColor); $thisPROPERTYDEF_ID = highlightSearchTerms($thisPROPERTYDEF_ID, $thisKeyword, $highlightColor); $thisPROPERTY_MAPPING_ID = highlightSearchTerms($thisPROPERTY_MAPPING_ID, $thisKeyword, $highlightColor); $thisPROPERTY_MAPPING_TYPE = highlightSearchTerms($thisPROPERTY_MAPPING_TYPE, $thisKeyword, $highlightColor); $thisPROPERTY_VALUE = highlightSearchTerms($thisPROPERTY_VALUE, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisPROPERTY_ID; ?> </TD> <TD><?php echo $thisPROPERTYDEF_ID; ?> </TD> <TD><?php echo $thisPROPERTY_MAPPING_ID;
$thisCHECK_OPTION = MYSQL_RESULT($result, $i, "CHECK_OPTION"); $thisIS_UPDATABLE = MYSQL_RESULT($result, $i, "IS_UPDATABLE"); $thisDEFINER = MYSQL_RESULT($result, $i, "DEFINER"); $thisSECURITY_TYPE = MYSQL_RESULT($result, $i, "SECURITY_TYPE"); $thisCHARACTER_SET_CLIENT = MYSQL_RESULT($result, $i, "CHARACTER_SET_CLIENT"); $thisCOLLATION_CONNECTION = MYSQL_RESULT($result, $i, "COLLATION_CONNECTION"); $thisTABLE_CATALOG = highlightSearchTerms($thisTABLE_CATALOG, $thisKeyword, $highlightColor); $thisTABLE_SCHEMA = highlightSearchTerms($thisTABLE_SCHEMA, $thisKeyword, $highlightColor); $thisTABLE_NAME = highlightSearchTerms($thisTABLE_NAME, $thisKeyword, $highlightColor); $thisVIEW_DEFINITION = highlightSearchTerms($thisVIEW_DEFINITION, $thisKeyword, $highlightColor); $thisCHECK_OPTION = highlightSearchTerms($thisCHECK_OPTION, $thisKeyword, $highlightColor); $thisIS_UPDATABLE = highlightSearchTerms($thisIS_UPDATABLE, $thisKeyword, $highlightColor); $thisDEFINER = highlightSearchTerms($thisDEFINER, $thisKeyword, $highlightColor); $thisSECURITY_TYPE = highlightSearchTerms($thisSECURITY_TYPE, $thisKeyword, $highlightColor); $thisCHARACTER_SET_CLIENT = highlightSearchTerms($thisCHARACTER_SET_CLIENT, $thisKeyword, $highlightColor); $thisCOLLATION_CONNECTION = highlightSearchTerms($thisCOLLATION_CONNECTION, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisTABLE_CATALOG; ?> </TD> <TD><?php echo $thisTABLE_SCHEMA; ?> </TD> <TD><?php echo $thisTABLE_NAME;
while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisRELATION_SOURCE_ID = MYSQL_RESULT($result, $i, "RELATION_SOURCE_ID"); $thisRELATION_SOURCE_PATH = MYSQL_RESULT($result, $i, "RELATION_SOURCE_PATH"); $thisRELATION_TARGET_ID = MYSQL_RESULT($result, $i, "RELATION_TARGET_ID"); $thisRELATION_TARGET_PATH = MYSQL_RESULT($result, $i, "RELATION_TARGET_PATH"); $thisRELATION_TYPE = MYSQL_RESULT($result, $i, "RELATION_TYPE"); $thisRELATION_SOURCE_ID = highlightSearchTerms($thisRELATION_SOURCE_ID, $thisKeyword, $highlightColor); $thisRELATION_SOURCE_PATH = highlightSearchTerms($thisRELATION_SOURCE_PATH, $thisKeyword, $highlightColor); $thisRELATION_TARGET_ID = highlightSearchTerms($thisRELATION_TARGET_ID, $thisKeyword, $highlightColor); $thisRELATION_TARGET_PATH = highlightSearchTerms($thisRELATION_TARGET_PATH, $thisKeyword, $highlightColor); $thisRELATION_TYPE = highlightSearchTerms($thisRELATION_TYPE, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisRELATION_SOURCE_ID; ?> </TD> <TD><?php echo $thisRELATION_SOURCE_PATH; ?> </TD> <TD><?php echo $thisRELATION_TARGET_ID;
<B>VARIABLE_VALUE</B> </a> </TD> </TR> <?php $highlightColor = "#FFFF99"; while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisVARIABLE_NAME = MYSQL_RESULT($result, $i, "VARIABLE_NAME"); $thisVARIABLE_VALUE = MYSQL_RESULT($result, $i, "VARIABLE_VALUE"); $thisVARIABLE_NAME = highlightSearchTerms($thisVARIABLE_NAME, $thisKeyword, $highlightColor); $thisVARIABLE_VALUE = highlightSearchTerms($thisVARIABLE_VALUE, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisVARIABLE_NAME; ?> </TD> <TD><?php echo $thisVARIABLE_VALUE; ?> </TD> <TD><a href="editSESSION_VARIABLES.php?VARIABLE_NAMEField=<?php echo $thisVARIABLE_NAME;
<?php $highlightColor = "#FFFF99"; while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisPath = MYSQL_RESULT($result, $i, "path"); $thisSite_root = MYSQL_RESULT($result, $i, "site_root"); $thisAlias_mode = MYSQL_RESULT($result, $i, "alias_mode"); $thisStructure_id = MYSQL_RESULT($result, $i, "structure_id"); $thisPath = highlightSearchTerms($thisPath, $thisKeyword, $highlightColor); $thisSite_root = highlightSearchTerms($thisSite_root, $thisKeyword, $highlightColor); $thisAlias_mode = highlightSearchTerms($thisAlias_mode, $thisKeyword, $highlightColor); $thisStructure_id = highlightSearchTerms($thisStructure_id, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisPath; ?> </TD> <TD><?php echo $thisSite_root; ?> </TD> <TD><?php echo $thisAlias_mode;
$thisNUMBER_PAGES_WRITTEN = highlightSearchTerms($thisNUMBER_PAGES_WRITTEN, $thisKeyword, $highlightColor); $thisPAGES_READ_RATE = highlightSearchTerms($thisPAGES_READ_RATE, $thisKeyword, $highlightColor); $thisPAGES_CREATE_RATE = highlightSearchTerms($thisPAGES_CREATE_RATE, $thisKeyword, $highlightColor); $thisPAGES_WRITTEN_RATE = highlightSearchTerms($thisPAGES_WRITTEN_RATE, $thisKeyword, $highlightColor); $thisNUMBER_PAGES_GET = highlightSearchTerms($thisNUMBER_PAGES_GET, $thisKeyword, $highlightColor); $thisHIT_RATE = highlightSearchTerms($thisHIT_RATE, $thisKeyword, $highlightColor); $thisYOUNG_MAKE_PER_THOUSAND_GETS = highlightSearchTerms($thisYOUNG_MAKE_PER_THOUSAND_GETS, $thisKeyword, $highlightColor); $thisNOT_YOUNG_MAKE_PER_THOUSAND_GETS = highlightSearchTerms($thisNOT_YOUNG_MAKE_PER_THOUSAND_GETS, $thisKeyword, $highlightColor); $thisNUMBER_PAGES_READ_AHEAD = highlightSearchTerms($thisNUMBER_PAGES_READ_AHEAD, $thisKeyword, $highlightColor); $thisNUMBER_READ_AHEAD_EVICTED = highlightSearchTerms($thisNUMBER_READ_AHEAD_EVICTED, $thisKeyword, $highlightColor); $thisREAD_AHEAD_RATE = highlightSearchTerms($thisREAD_AHEAD_RATE, $thisKeyword, $highlightColor); $thisREAD_AHEAD_EVICTED_RATE = highlightSearchTerms($thisREAD_AHEAD_EVICTED_RATE, $thisKeyword, $highlightColor); $thisLRU_IO_TOTAL = highlightSearchTerms($thisLRU_IO_TOTAL, $thisKeyword, $highlightColor); $thisLRU_IO_CURRENT = highlightSearchTerms($thisLRU_IO_CURRENT, $thisKeyword, $highlightColor); $thisUNCOMPRESS_TOTAL = highlightSearchTerms($thisUNCOMPRESS_TOTAL, $thisKeyword, $highlightColor); $thisUNCOMPRESS_CURRENT = highlightSearchTerms($thisUNCOMPRESS_CURRENT, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisPOOL_ID; ?> </TD> <TD><?php echo $thisPOOL_SIZE; ?> </TD> <TD><?php echo $thisFREE_BUFFERS;
$bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisPage_size = MYSQL_RESULT($result, $i, "page_size"); $thisCompress_ops = MYSQL_RESULT($result, $i, "compress_ops"); $thisCompress_ops_ok = MYSQL_RESULT($result, $i, "compress_ops_ok"); $thisCompress_time = MYSQL_RESULT($result, $i, "compress_time"); $thisUncompress_ops = MYSQL_RESULT($result, $i, "uncompress_ops"); $thisUncompress_time = MYSQL_RESULT($result, $i, "uncompress_time"); $thisPage_size = highlightSearchTerms($thisPage_size, $thisKeyword, $highlightColor); $thisCompress_ops = highlightSearchTerms($thisCompress_ops, $thisKeyword, $highlightColor); $thisCompress_ops_ok = highlightSearchTerms($thisCompress_ops_ok, $thisKeyword, $highlightColor); $thisCompress_time = highlightSearchTerms($thisCompress_time, $thisKeyword, $highlightColor); $thisUncompress_ops = highlightSearchTerms($thisUncompress_ops, $thisKeyword, $highlightColor); $thisUncompress_time = highlightSearchTerms($thisUncompress_time, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisPage_size; ?> </TD> <TD><?php echo $thisCompress_ops; ?> </TD> <TD><?php echo $thisCompress_ops_ok;
$thisUSER_LASTMODIFIED = MYSQL_RESULT($result, $i, "USER_LASTMODIFIED"); $thisPROJECT_LASTMODIFIED = MYSQL_RESULT($result, $i, "PROJECT_LASTMODIFIED"); $thisRESOURCE_VERSION = MYSQL_RESULT($result, $i, "RESOURCE_VERSION"); $thisRESOURCE_ID = highlightSearchTerms($thisRESOURCE_ID, $thisKeyword, $highlightColor); $thisRESOURCE_TYPE = highlightSearchTerms($thisRESOURCE_TYPE, $thisKeyword, $highlightColor); $thisRESOURCE_FLAGS = highlightSearchTerms($thisRESOURCE_FLAGS, $thisKeyword, $highlightColor); $thisRESOURCE_STATE = highlightSearchTerms($thisRESOURCE_STATE, $thisKeyword, $highlightColor); $thisRESOURCE_SIZE = highlightSearchTerms($thisRESOURCE_SIZE, $thisKeyword, $highlightColor); $thisDATE_CONTENT = highlightSearchTerms($thisDATE_CONTENT, $thisKeyword, $highlightColor); $thisSIBLING_COUNT = highlightSearchTerms($thisSIBLING_COUNT, $thisKeyword, $highlightColor); $thisDATE_CREATED = highlightSearchTerms($thisDATE_CREATED, $thisKeyword, $highlightColor); $thisDATE_LASTMODIFIED = highlightSearchTerms($thisDATE_LASTMODIFIED, $thisKeyword, $highlightColor); $thisUSER_CREATED = highlightSearchTerms($thisUSER_CREATED, $thisKeyword, $highlightColor); $thisUSER_LASTMODIFIED = highlightSearchTerms($thisUSER_LASTMODIFIED, $thisKeyword, $highlightColor); $thisPROJECT_LASTMODIFIED = highlightSearchTerms($thisPROJECT_LASTMODIFIED, $thisKeyword, $highlightColor); $thisRESOURCE_VERSION = highlightSearchTerms($thisRESOURCE_VERSION, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisRESOURCE_ID; ?> </TD> <TD><?php echo $thisRESOURCE_TYPE; ?> </TD> <TD><?php echo $thisRESOURCE_FLAGS;
$thisRECOVER_TIME = highlightSearchTerms($thisRECOVER_TIME, $thisKeyword, $highlightColor); $thisTRANSACTION_COUNTER = highlightSearchTerms($thisTRANSACTION_COUNTER, $thisKeyword, $highlightColor); $thisVERSION = highlightSearchTerms($thisVERSION, $thisKeyword, $highlightColor); $thisROW_FORMAT = highlightSearchTerms($thisROW_FORMAT, $thisKeyword, $highlightColor); $thisTABLE_ROWS = highlightSearchTerms($thisTABLE_ROWS, $thisKeyword, $highlightColor); $thisAVG_ROW_LENGTH = highlightSearchTerms($thisAVG_ROW_LENGTH, $thisKeyword, $highlightColor); $thisDATA_LENGTH = highlightSearchTerms($thisDATA_LENGTH, $thisKeyword, $highlightColor); $thisMAX_DATA_LENGTH = highlightSearchTerms($thisMAX_DATA_LENGTH, $thisKeyword, $highlightColor); $thisINDEX_LENGTH = highlightSearchTerms($thisINDEX_LENGTH, $thisKeyword, $highlightColor); $thisDATA_FREE = highlightSearchTerms($thisDATA_FREE, $thisKeyword, $highlightColor); $thisCREATE_TIME = highlightSearchTerms($thisCREATE_TIME, $thisKeyword, $highlightColor); $thisUPDATE_TIME = highlightSearchTerms($thisUPDATE_TIME, $thisKeyword, $highlightColor); $thisCHECK_TIME = highlightSearchTerms($thisCHECK_TIME, $thisKeyword, $highlightColor); $thisCHECKSUM = highlightSearchTerms($thisCHECKSUM, $thisKeyword, $highlightColor); $thisSTATUS = highlightSearchTerms($thisSTATUS, $thisKeyword, $highlightColor); $thisEXTRA = highlightSearchTerms($thisEXTRA, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisFILE_ID; ?> </TD> <TD><?php echo $thisFILE_NAME; ?> </TD> <TD><?php echo $thisFILE_TYPE;
$bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisCOLLATION_NAME = MYSQL_RESULT($result, $i, "COLLATION_NAME"); $thisCHARACTER_SET_NAME = MYSQL_RESULT($result, $i, "CHARACTER_SET_NAME"); $thisID = MYSQL_RESULT($result, $i, "ID"); $thisIS_DEFAULT = MYSQL_RESULT($result, $i, "IS_DEFAULT"); $thisIS_COMPILED = MYSQL_RESULT($result, $i, "IS_COMPILED"); $thisSORTLEN = MYSQL_RESULT($result, $i, "SORTLEN"); $thisCOLLATION_NAME = highlightSearchTerms($thisCOLLATION_NAME, $thisKeyword, $highlightColor); $thisCHARACTER_SET_NAME = highlightSearchTerms($thisCHARACTER_SET_NAME, $thisKeyword, $highlightColor); $thisID = highlightSearchTerms($thisID, $thisKeyword, $highlightColor); $thisIS_DEFAULT = highlightSearchTerms($thisIS_DEFAULT, $thisKeyword, $highlightColor); $thisIS_COMPILED = highlightSearchTerms($thisIS_COMPILED, $thisKeyword, $highlightColor); $thisSORTLEN = highlightSearchTerms($thisSORTLEN, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisCOLLATION_NAME; ?> </TD> <TD><?php echo $thisCHARACTER_SET_NAME; ?> </TD> <TD><?php echo $thisID;
$bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisPage_size = MYSQL_RESULT($result, $i, "page_size"); $thisBuffer_pool_instance = MYSQL_RESULT($result, $i, "buffer_pool_instance"); $thisPages_used = MYSQL_RESULT($result, $i, "pages_used"); $thisPages_free = MYSQL_RESULT($result, $i, "pages_free"); $thisRelocation_ops = MYSQL_RESULT($result, $i, "relocation_ops"); $thisRelocation_time = MYSQL_RESULT($result, $i, "relocation_time"); $thisPage_size = highlightSearchTerms($thisPage_size, $thisKeyword, $highlightColor); $thisBuffer_pool_instance = highlightSearchTerms($thisBuffer_pool_instance, $thisKeyword, $highlightColor); $thisPages_used = highlightSearchTerms($thisPages_used, $thisKeyword, $highlightColor); $thisPages_free = highlightSearchTerms($thisPages_free, $thisKeyword, $highlightColor); $thisRelocation_ops = highlightSearchTerms($thisRelocation_ops, $thisKeyword, $highlightColor); $thisRelocation_time = highlightSearchTerms($thisRelocation_time, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisPage_size; ?> </TD> <TD><?php echo $thisBuffer_pool_instance; ?> </TD> <TD><?php echo $thisPages_used;
$thisDC_Hostname = highlightSearchTerms($thisDC_Hostname, $thisKeyword, $highlightColor); $thisMedu_Hostname = highlightSearchTerms($thisMedu_Hostname, $thisKeyword, $highlightColor); $thisDomain_Name = highlightSearchTerms($thisDomain_Name, $thisKeyword, $highlightColor); $thisCNAME = highlightSearchTerms($thisCNAME, $thisKeyword, $highlightColor); $thisPublic_IP = highlightSearchTerms($thisPublic_IP, $thisKeyword, $highlightColor); $thisNetwork = highlightSearchTerms($thisNetwork, $thisKeyword, $highlightColor); $thisDMZ_IP = highlightSearchTerms($thisDMZ_IP, $thisKeyword, $highlightColor); $thisMgmt_IP = highlightSearchTerms($thisMgmt_IP, $thisKeyword, $highlightColor); $thisPublic_MAC = highlightSearchTerms($thisPublic_MAC, $thisKeyword, $highlightColor); $thisDMZ_MAC = highlightSearchTerms($thisDMZ_MAC, $thisKeyword, $highlightColor); $thisMGMT_MAC = highlightSearchTerms($thisMGMT_MAC, $thisKeyword, $highlightColor); $thisDescription = highlightSearchTerms($thisDescription, $thisKeyword, $highlightColor); $thisServiceTag = highlightSearchTerms($thisServiceTag, $thisKeyword, $highlightColor); $thisRow = highlightSearchTerms($thisRow, $thisKeyword, $highlightColor); $thisRack = highlightSearchTerms($thisRack, $thisKeyword, $highlightColor); $thisSlot = highlightSearchTerms($thisSlot, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisDatacenter; ?> </TD> <TD><?php echo $thisDC_Hostname; ?> </TD> <TD><?php echo $thisMedu_Hostname;
$thisPRINCIPAL_ID = MYSQL_RESULT($result, $i, "PRINCIPAL_ID"); $thisPRINCIPAL_NAME = MYSQL_RESULT($result, $i, "PRINCIPAL_NAME"); $thisPRINCIPAL_DESCRIPTION = MYSQL_RESULT($result, $i, "PRINCIPAL_DESCRIPTION"); $thisPRINCIPAL_OU = MYSQL_RESULT($result, $i, "PRINCIPAL_OU"); $thisPRINCIPAL_EMAIL = MYSQL_RESULT($result, $i, "PRINCIPAL_EMAIL"); $thisPRINCIPAL_TYPE = MYSQL_RESULT($result, $i, "PRINCIPAL_TYPE"); $thisPRINCIPAL_USERDELETED = MYSQL_RESULT($result, $i, "PRINCIPAL_USERDELETED"); $thisPRINCIPAL_DATEDELETED = MYSQL_RESULT($result, $i, "PRINCIPAL_DATEDELETED"); $thisPRINCIPAL_ID = highlightSearchTerms($thisPRINCIPAL_ID, $thisKeyword, $highlightColor); $thisPRINCIPAL_NAME = highlightSearchTerms($thisPRINCIPAL_NAME, $thisKeyword, $highlightColor); $thisPRINCIPAL_DESCRIPTION = highlightSearchTerms($thisPRINCIPAL_DESCRIPTION, $thisKeyword, $highlightColor); $thisPRINCIPAL_OU = highlightSearchTerms($thisPRINCIPAL_OU, $thisKeyword, $highlightColor); $thisPRINCIPAL_EMAIL = highlightSearchTerms($thisPRINCIPAL_EMAIL, $thisKeyword, $highlightColor); $thisPRINCIPAL_TYPE = highlightSearchTerms($thisPRINCIPAL_TYPE, $thisKeyword, $highlightColor); $thisPRINCIPAL_USERDELETED = highlightSearchTerms($thisPRINCIPAL_USERDELETED, $thisKeyword, $highlightColor); $thisPRINCIPAL_DATEDELETED = highlightSearchTerms($thisPRINCIPAL_DATEDELETED, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisPRINCIPAL_ID; ?> </TD> <TD><?php echo $thisPRINCIPAL_NAME; ?> </TD> <TD><?php echo $thisPRINCIPAL_DESCRIPTION;
while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisRESOURCE_ID = MYSQL_RESULT($result, $i, "RESOURCE_ID"); $thisFILE_CONTENT = MYSQL_RESULT($result, $i, "FILE_CONTENT"); $thisPUBLISH_TAG_FROM = MYSQL_RESULT($result, $i, "PUBLISH_TAG_FROM"); $thisPUBLISH_TAG_TO = MYSQL_RESULT($result, $i, "PUBLISH_TAG_TO"); $thisONLINE_FLAG = MYSQL_RESULT($result, $i, "ONLINE_FLAG"); $thisRESOURCE_ID = highlightSearchTerms($thisRESOURCE_ID, $thisKeyword, $highlightColor); $thisFILE_CONTENT = highlightSearchTerms($thisFILE_CONTENT, $thisKeyword, $highlightColor); $thisPUBLISH_TAG_FROM = highlightSearchTerms($thisPUBLISH_TAG_FROM, $thisKeyword, $highlightColor); $thisPUBLISH_TAG_TO = highlightSearchTerms($thisPUBLISH_TAG_TO, $thisKeyword, $highlightColor); $thisONLINE_FLAG = highlightSearchTerms($thisONLINE_FLAG, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisRESOURCE_ID; ?> </TD> <TD><?php echo $thisFILE_CONTENT; ?> </TD> <TD><?php echo $thisPUBLISH_TAG_FROM;
$thisSTRUCTURE_ID = MYSQL_RESULT($result, $i, "STRUCTURE_ID"); $thisRESOURCE_ID = MYSQL_RESULT($result, $i, "RESOURCE_ID"); $thisPARENT_ID = MYSQL_RESULT($result, $i, "PARENT_ID"); $thisRESOURCE_PATH = MYSQL_RESULT($result, $i, "RESOURCE_PATH"); $thisSTRUCTURE_STATE = MYSQL_RESULT($result, $i, "STRUCTURE_STATE"); $thisDATE_RELEASED = MYSQL_RESULT($result, $i, "DATE_RELEASED"); $thisDATE_EXPIRED = MYSQL_RESULT($result, $i, "DATE_EXPIRED"); $thisSTRUCTURE_VERSION = MYSQL_RESULT($result, $i, "STRUCTURE_VERSION"); $thisSTRUCTURE_ID = highlightSearchTerms($thisSTRUCTURE_ID, $thisKeyword, $highlightColor); $thisRESOURCE_ID = highlightSearchTerms($thisRESOURCE_ID, $thisKeyword, $highlightColor); $thisPARENT_ID = highlightSearchTerms($thisPARENT_ID, $thisKeyword, $highlightColor); $thisRESOURCE_PATH = highlightSearchTerms($thisRESOURCE_PATH, $thisKeyword, $highlightColor); $thisSTRUCTURE_STATE = highlightSearchTerms($thisSTRUCTURE_STATE, $thisKeyword, $highlightColor); $thisDATE_RELEASED = highlightSearchTerms($thisDATE_RELEASED, $thisKeyword, $highlightColor); $thisDATE_EXPIRED = highlightSearchTerms($thisDATE_EXPIRED, $thisKeyword, $highlightColor); $thisSTRUCTURE_VERSION = highlightSearchTerms($thisSTRUCTURE_VERSION, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisSTRUCTURE_ID; ?> </TD> <TD><?php echo $thisRESOURCE_ID; ?> </TD> <TD><?php echo $thisPARENT_ID;
while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisUSER_ID = MYSQL_RESULT($result, $i, "USER_ID"); $thisLOG_DATE = MYSQL_RESULT($result, $i, "LOG_DATE"); $thisSTRUCTURE_ID = MYSQL_RESULT($result, $i, "STRUCTURE_ID"); $thisLOG_TYPE = MYSQL_RESULT($result, $i, "LOG_TYPE"); $thisLOG_DATA = MYSQL_RESULT($result, $i, "LOG_DATA"); $thisUSER_ID = highlightSearchTerms($thisUSER_ID, $thisKeyword, $highlightColor); $thisLOG_DATE = highlightSearchTerms($thisLOG_DATE, $thisKeyword, $highlightColor); $thisSTRUCTURE_ID = highlightSearchTerms($thisSTRUCTURE_ID, $thisKeyword, $highlightColor); $thisLOG_TYPE = highlightSearchTerms($thisLOG_TYPE, $thisKeyword, $highlightColor); $thisLOG_DATA = highlightSearchTerms($thisLOG_DATA, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisUSER_ID; ?> </TD> <TD><?php echo $thisLOG_DATE; ?> </TD> <TD><?php echo $thisSTRUCTURE_ID;
$thisTABLE_CATALOG = highlightSearchTerms($thisTABLE_CATALOG, $thisKeyword, $highlightColor); $thisTABLE_SCHEMA = highlightSearchTerms($thisTABLE_SCHEMA, $thisKeyword, $highlightColor); $thisTABLE_NAME = highlightSearchTerms($thisTABLE_NAME, $thisKeyword, $highlightColor); $thisNON_UNIQUE = highlightSearchTerms($thisNON_UNIQUE, $thisKeyword, $highlightColor); $thisINDEX_SCHEMA = highlightSearchTerms($thisINDEX_SCHEMA, $thisKeyword, $highlightColor); $thisINDEX_NAME = highlightSearchTerms($thisINDEX_NAME, $thisKeyword, $highlightColor); $thisSEQ_IN_INDEX = highlightSearchTerms($thisSEQ_IN_INDEX, $thisKeyword, $highlightColor); $thisCOLUMN_NAME = highlightSearchTerms($thisCOLUMN_NAME, $thisKeyword, $highlightColor); $thisCOLLATION = highlightSearchTerms($thisCOLLATION, $thisKeyword, $highlightColor); $thisCARDINALITY = highlightSearchTerms($thisCARDINALITY, $thisKeyword, $highlightColor); $thisSUB_PART = highlightSearchTerms($thisSUB_PART, $thisKeyword, $highlightColor); $thisPACKED = highlightSearchTerms($thisPACKED, $thisKeyword, $highlightColor); $thisNULLABLE = highlightSearchTerms($thisNULLABLE, $thisKeyword, $highlightColor); $thisINDEX_TYPE = highlightSearchTerms($thisINDEX_TYPE, $thisKeyword, $highlightColor); $thisCOMMENT = highlightSearchTerms($thisCOMMENT, $thisKeyword, $highlightColor); $thisINDEX_COMMENT = highlightSearchTerms($thisINDEX_COMMENT, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisTABLE_CATALOG; ?> </TD> <TD><?php echo $thisTABLE_SCHEMA; ?> </TD> <TD><?php echo $thisTABLE_NAME;
$thisSTATE = highlightSearchTerms($thisSTATE, $thisKeyword, $highlightColor); $thisDURATION = highlightSearchTerms($thisDURATION, $thisKeyword, $highlightColor); $thisCPU_USER = highlightSearchTerms($thisCPU_USER, $thisKeyword, $highlightColor); $thisCPU_SYSTEM = highlightSearchTerms($thisCPU_SYSTEM, $thisKeyword, $highlightColor); $thisCONTEXT_VOLUNTARY = highlightSearchTerms($thisCONTEXT_VOLUNTARY, $thisKeyword, $highlightColor); $thisCONTEXT_INVOLUNTARY = highlightSearchTerms($thisCONTEXT_INVOLUNTARY, $thisKeyword, $highlightColor); $thisBLOCK_OPS_IN = highlightSearchTerms($thisBLOCK_OPS_IN, $thisKeyword, $highlightColor); $thisBLOCK_OPS_OUT = highlightSearchTerms($thisBLOCK_OPS_OUT, $thisKeyword, $highlightColor); $thisMESSAGES_SENT = highlightSearchTerms($thisMESSAGES_SENT, $thisKeyword, $highlightColor); $thisMESSAGES_RECEIVED = highlightSearchTerms($thisMESSAGES_RECEIVED, $thisKeyword, $highlightColor); $thisPAGE_FAULTS_MAJOR = highlightSearchTerms($thisPAGE_FAULTS_MAJOR, $thisKeyword, $highlightColor); $thisPAGE_FAULTS_MINOR = highlightSearchTerms($thisPAGE_FAULTS_MINOR, $thisKeyword, $highlightColor); $thisSWAPS = highlightSearchTerms($thisSWAPS, $thisKeyword, $highlightColor); $thisSOURCE_FUNCTION = highlightSearchTerms($thisSOURCE_FUNCTION, $thisKeyword, $highlightColor); $thisSOURCE_FILE = highlightSearchTerms($thisSOURCE_FILE, $thisKeyword, $highlightColor); $thisSOURCE_LINE = highlightSearchTerms($thisSOURCE_LINE, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisQUERY_ID; ?> </TD> <TD><?php echo $thisSEQ; ?> </TD> <TD><?php echo $thisSTATE;
<?php $highlightColor = "#FFFF99"; while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisUSER_ID = MYSQL_RESULT($result, $i, "USER_ID"); $thisDATA_KEY = MYSQL_RESULT($result, $i, "DATA_KEY"); $thisDATA_VALUE = MYSQL_RESULT($result, $i, "DATA_VALUE"); $thisDATA_TYPE = MYSQL_RESULT($result, $i, "DATA_TYPE"); $thisUSER_ID = highlightSearchTerms($thisUSER_ID, $thisKeyword, $highlightColor); $thisDATA_KEY = highlightSearchTerms($thisDATA_KEY, $thisKeyword, $highlightColor); $thisDATA_VALUE = highlightSearchTerms($thisDATA_VALUE, $thisKeyword, $highlightColor); $thisDATA_TYPE = highlightSearchTerms($thisDATA_TYPE, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisUSER_ID; ?> </TD> <TD><?php echo $thisDATA_KEY; ?> </TD> <TD><?php echo $thisDATA_VALUE;
while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisNAME = MYSQL_RESULT($result, $i, "NAME"); $thisSTRUCTURE_ID = MYSQL_RESULT($result, $i, "STRUCTURE_ID"); $thisSTATE = MYSQL_RESULT($result, $i, "STATE"); $thisDATE_CHANGED = MYSQL_RESULT($result, $i, "DATE_CHANGED"); $thisLOCALE = MYSQL_RESULT($result, $i, "LOCALE"); $thisNAME = highlightSearchTerms($thisNAME, $thisKeyword, $highlightColor); $thisSTRUCTURE_ID = highlightSearchTerms($thisSTRUCTURE_ID, $thisKeyword, $highlightColor); $thisSTATE = highlightSearchTerms($thisSTATE, $thisKeyword, $highlightColor); $thisDATE_CHANGED = highlightSearchTerms($thisDATE_CHANGED, $thisKeyword, $highlightColor); $thisLOCALE = highlightSearchTerms($thisLOCALE, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisNAME; ?> </TD> <TD><?php echo $thisSTRUCTURE_ID; ?> </TD> <TD><?php echo $thisSTATE;
$thisMATCH_OPTION = MYSQL_RESULT($result, $i, "MATCH_OPTION"); $thisUPDATE_RULE = MYSQL_RESULT($result, $i, "UPDATE_RULE"); $thisDELETE_RULE = MYSQL_RESULT($result, $i, "DELETE_RULE"); $thisTABLE_NAME = MYSQL_RESULT($result, $i, "TABLE_NAME"); $thisREFERENCED_TABLE_NAME = MYSQL_RESULT($result, $i, "REFERENCED_TABLE_NAME"); $thisCONSTRAINT_CATALOG = highlightSearchTerms($thisCONSTRAINT_CATALOG, $thisKeyword, $highlightColor); $thisCONSTRAINT_SCHEMA = highlightSearchTerms($thisCONSTRAINT_SCHEMA, $thisKeyword, $highlightColor); $thisCONSTRAINT_NAME = highlightSearchTerms($thisCONSTRAINT_NAME, $thisKeyword, $highlightColor); $thisUNIQUE_CONSTRAINT_CATALOG = highlightSearchTerms($thisUNIQUE_CONSTRAINT_CATALOG, $thisKeyword, $highlightColor); $thisUNIQUE_CONSTRAINT_SCHEMA = highlightSearchTerms($thisUNIQUE_CONSTRAINT_SCHEMA, $thisKeyword, $highlightColor); $thisUNIQUE_CONSTRAINT_NAME = highlightSearchTerms($thisUNIQUE_CONSTRAINT_NAME, $thisKeyword, $highlightColor); $thisMATCH_OPTION = highlightSearchTerms($thisMATCH_OPTION, $thisKeyword, $highlightColor); $thisUPDATE_RULE = highlightSearchTerms($thisUPDATE_RULE, $thisKeyword, $highlightColor); $thisDELETE_RULE = highlightSearchTerms($thisDELETE_RULE, $thisKeyword, $highlightColor); $thisTABLE_NAME = highlightSearchTerms($thisTABLE_NAME, $thisKeyword, $highlightColor); $thisREFERENCED_TABLE_NAME = highlightSearchTerms($thisREFERENCED_TABLE_NAME, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisCONSTRAINT_CATALOG; ?> </TD> <TD><?php echo $thisCONSTRAINT_SCHEMA; ?> </TD> <TD><?php echo $thisCONSTRAINT_NAME;
$thisPAGE_TYPE = highlightSearchTerms($thisPAGE_TYPE, $thisKeyword, $highlightColor); $thisFLUSH_TYPE = highlightSearchTerms($thisFLUSH_TYPE, $thisKeyword, $highlightColor); $thisFIX_COUNT = highlightSearchTerms($thisFIX_COUNT, $thisKeyword, $highlightColor); $thisIS_HASHED = highlightSearchTerms($thisIS_HASHED, $thisKeyword, $highlightColor); $thisNEWEST_MODIFICATION = highlightSearchTerms($thisNEWEST_MODIFICATION, $thisKeyword, $highlightColor); $thisOLDEST_MODIFICATION = highlightSearchTerms($thisOLDEST_MODIFICATION, $thisKeyword, $highlightColor); $thisACCESS_TIME = highlightSearchTerms($thisACCESS_TIME, $thisKeyword, $highlightColor); $thisTABLE_NAME = highlightSearchTerms($thisTABLE_NAME, $thisKeyword, $highlightColor); $thisINDEX_NAME = highlightSearchTerms($thisINDEX_NAME, $thisKeyword, $highlightColor); $thisNUMBER_RECORDS = highlightSearchTerms($thisNUMBER_RECORDS, $thisKeyword, $highlightColor); $thisDATA_SIZE = highlightSearchTerms($thisDATA_SIZE, $thisKeyword, $highlightColor); $thisCOMPRESSED_SIZE = highlightSearchTerms($thisCOMPRESSED_SIZE, $thisKeyword, $highlightColor); $thisPAGE_STATE = highlightSearchTerms($thisPAGE_STATE, $thisKeyword, $highlightColor); $thisIO_FIX = highlightSearchTerms($thisIO_FIX, $thisKeyword, $highlightColor); $thisIS_OLD = highlightSearchTerms($thisIS_OLD, $thisKeyword, $highlightColor); $thisFREE_PAGE_CLOCK = highlightSearchTerms($thisFREE_PAGE_CLOCK, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisPOOL_ID; ?> </TD> <TD><?php echo $thisBLOCK_ID; ?> </TD> <TD><?php echo $thisSPACE;
$bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisSTRUCTURE_ID = MYSQL_RESULT($result, $i, "STRUCTURE_ID"); $thisPROPERTYDEF_ID = MYSQL_RESULT($result, $i, "PROPERTYDEF_ID"); $thisPROPERTY_MAPPING_ID = MYSQL_RESULT($result, $i, "PROPERTY_MAPPING_ID"); $thisPROPERTY_MAPPING_TYPE = MYSQL_RESULT($result, $i, "PROPERTY_MAPPING_TYPE"); $thisPROPERTY_VALUE = MYSQL_RESULT($result, $i, "PROPERTY_VALUE"); $thisPUBLISH_TAG = MYSQL_RESULT($result, $i, "PUBLISH_TAG"); $thisSTRUCTURE_ID = highlightSearchTerms($thisSTRUCTURE_ID, $thisKeyword, $highlightColor); $thisPROPERTYDEF_ID = highlightSearchTerms($thisPROPERTYDEF_ID, $thisKeyword, $highlightColor); $thisPROPERTY_MAPPING_ID = highlightSearchTerms($thisPROPERTY_MAPPING_ID, $thisKeyword, $highlightColor); $thisPROPERTY_MAPPING_TYPE = highlightSearchTerms($thisPROPERTY_MAPPING_TYPE, $thisKeyword, $highlightColor); $thisPROPERTY_VALUE = highlightSearchTerms($thisPROPERTY_VALUE, $thisKeyword, $highlightColor); $thisPUBLISH_TAG = highlightSearchTerms($thisPUBLISH_TAG, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisSTRUCTURE_ID; ?> </TD> <TD><?php echo $thisPROPERTYDEF_ID; ?> </TD> <TD><?php echo $thisPROPERTY_MAPPING_ID;
$thisRESOURCE_COUNT = MYSQL_RESULT($result, $i, "RESOURCE_COUNT"); $thisENQUEUE_TIME = MYSQL_RESULT($result, $i, "ENQUEUE_TIME"); $thisSTART_TIME = MYSQL_RESULT($result, $i, "START_TIME"); $thisFINISH_TIME = MYSQL_RESULT($result, $i, "FINISH_TIME"); $thisHISTORY_ID = highlightSearchTerms($thisHISTORY_ID, $thisKeyword, $highlightColor); $thisPROJECT_ID = highlightSearchTerms($thisPROJECT_ID, $thisKeyword, $highlightColor); $thisPROJECT_NAME = highlightSearchTerms($thisPROJECT_NAME, $thisKeyword, $highlightColor); $thisUSER_ID = highlightSearchTerms($thisUSER_ID, $thisKeyword, $highlightColor); $thisPUBLISH_LOCALE = highlightSearchTerms($thisPUBLISH_LOCALE, $thisKeyword, $highlightColor); $thisPUBLISH_FLAGS = highlightSearchTerms($thisPUBLISH_FLAGS, $thisKeyword, $highlightColor); $thisPUBLISH_LIST = highlightSearchTerms($thisPUBLISH_LIST, $thisKeyword, $highlightColor); $thisPUBLISH_REPORT = highlightSearchTerms($thisPUBLISH_REPORT, $thisKeyword, $highlightColor); $thisRESOURCE_COUNT = highlightSearchTerms($thisRESOURCE_COUNT, $thisKeyword, $highlightColor); $thisENQUEUE_TIME = highlightSearchTerms($thisENQUEUE_TIME, $thisKeyword, $highlightColor); $thisSTART_TIME = highlightSearchTerms($thisSTART_TIME, $thisKeyword, $highlightColor); $thisFINISH_TIME = highlightSearchTerms($thisFINISH_TIME, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisHISTORY_ID; ?> </TD> <TD><?php echo $thisPROJECT_ID; ?> </TD> <TD><?php echo $thisPROJECT_NAME;
<?php $highlightColor = "#FFFF99"; while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisRequesting_trx_id = MYSQL_RESULT($result, $i, "requesting_trx_id"); $thisRequested_lock_id = MYSQL_RESULT($result, $i, "requested_lock_id"); $thisBlocking_trx_id = MYSQL_RESULT($result, $i, "blocking_trx_id"); $thisBlocking_lock_id = MYSQL_RESULT($result, $i, "blocking_lock_id"); $thisRequesting_trx_id = highlightSearchTerms($thisRequesting_trx_id, $thisKeyword, $highlightColor); $thisRequested_lock_id = highlightSearchTerms($thisRequested_lock_id, $thisKeyword, $highlightColor); $thisBlocking_trx_id = highlightSearchTerms($thisBlocking_trx_id, $thisKeyword, $highlightColor); $thisBlocking_lock_id = highlightSearchTerms($thisBlocking_lock_id, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisRequesting_trx_id; ?> </TD> <TD><?php echo $thisRequested_lock_id; ?> </TD> <TD><?php echo $thisBlocking_trx_id;
$thisCOLUMN_NAME = highlightSearchTerms($thisCOLUMN_NAME, $thisKeyword, $highlightColor); $thisORDINAL_POSITION = highlightSearchTerms($thisORDINAL_POSITION, $thisKeyword, $highlightColor); $thisCOLUMN_DEFAULT = highlightSearchTerms($thisCOLUMN_DEFAULT, $thisKeyword, $highlightColor); $thisIS_NULLABLE = highlightSearchTerms($thisIS_NULLABLE, $thisKeyword, $highlightColor); $thisDATA_TYPE = highlightSearchTerms($thisDATA_TYPE, $thisKeyword, $highlightColor); $thisCHARACTER_MAXIMUM_LENGTH = highlightSearchTerms($thisCHARACTER_MAXIMUM_LENGTH, $thisKeyword, $highlightColor); $thisCHARACTER_OCTET_LENGTH = highlightSearchTerms($thisCHARACTER_OCTET_LENGTH, $thisKeyword, $highlightColor); $thisNUMERIC_PRECISION = highlightSearchTerms($thisNUMERIC_PRECISION, $thisKeyword, $highlightColor); $thisNUMERIC_SCALE = highlightSearchTerms($thisNUMERIC_SCALE, $thisKeyword, $highlightColor); $thisCHARACTER_SET_NAME = highlightSearchTerms($thisCHARACTER_SET_NAME, $thisKeyword, $highlightColor); $thisCOLLATION_NAME = highlightSearchTerms($thisCOLLATION_NAME, $thisKeyword, $highlightColor); $thisCOLUMN_TYPE = highlightSearchTerms($thisCOLUMN_TYPE, $thisKeyword, $highlightColor); $thisCOLUMN_KEY = highlightSearchTerms($thisCOLUMN_KEY, $thisKeyword, $highlightColor); $thisEXTRA = highlightSearchTerms($thisEXTRA, $thisKeyword, $highlightColor); $thisPRIVILEGES = highlightSearchTerms($thisPRIVILEGES, $thisKeyword, $highlightColor); $thisCOLUMN_COMMENT = highlightSearchTerms($thisCOLUMN_COMMENT, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisTABLE_CATALOG; ?> </TD> <TD><?php echo $thisTABLE_SCHEMA; ?> </TD> <TD><?php echo $thisTABLE_NAME;
while ($i < $numberOfRows) { if ($i % 2 == 0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C0C0C0"; } $thisRESOURCE_ID = MYSQL_RESULT($result, $i, "RESOURCE_ID"); $thisPRINCIPAL_ID = MYSQL_RESULT($result, $i, "PRINCIPAL_ID"); $thisACCESS_ALLOWED = MYSQL_RESULT($result, $i, "ACCESS_ALLOWED"); $thisACCESS_DENIED = MYSQL_RESULT($result, $i, "ACCESS_DENIED"); $thisACCESS_FLAGS = MYSQL_RESULT($result, $i, "ACCESS_FLAGS"); $thisRESOURCE_ID = highlightSearchTerms($thisRESOURCE_ID, $thisKeyword, $highlightColor); $thisPRINCIPAL_ID = highlightSearchTerms($thisPRINCIPAL_ID, $thisKeyword, $highlightColor); $thisACCESS_ALLOWED = highlightSearchTerms($thisACCESS_ALLOWED, $thisKeyword, $highlightColor); $thisACCESS_DENIED = highlightSearchTerms($thisACCESS_DENIED, $thisKeyword, $highlightColor); $thisACCESS_FLAGS = highlightSearchTerms($thisACCESS_FLAGS, $thisKeyword, $highlightColor); ?> <TR BGCOLOR="<?php echo $bgColor; ?> "> <TD><?php echo $thisRESOURCE_ID; ?> </TD> <TD><?php echo $thisPRINCIPAL_ID; ?> </TD> <TD><?php echo $thisACCESS_ALLOWED;