typo3/ext/phpmyadmin/modsub/phpmyadmin-2.6.2/db_search.php File Reference

Go to the source code of this file.

Variables
	$url_query = '&goto=db_search.php'
	$tables = PMA_DBI_get_tables($db)
	$num_tables = count($tables)
	$sub_part = ''
	$current ['Field'] = PMA_backquote($current['Field'])
	$tblfields [] = $current
	$tblfields_cnt = count($tblfields)
	$sqlstr_from = ' FROM ' . PMA_backquote($GLOBALS['db']) . '.' . PMA_backquote($table)
	$sqlstr_where = ' WHERE'
	$search_words = (($search_option > 2) ? array($search_str) : explode(' ', $search_str))
	$search_wds_cnt = count($search_words)
	$like_or_regex = (($search_option == 4) ? 'REGEXP' : 'LIKE')
	$automatic_wildcard = (($search_option <3) ? '%' : '')
	$implode_str = ($search_option == 1 ? ' OR ' : ' AND ')
	$sql ['select_fields'] = $sqlstr_select . ' * ' . $sqlstr_from . $sqlstr_where
	goto
	pos
	is_js_confirmed
	sql_query
< selectname="table_select[]"size="6"multiple="multiple">	selected
&	nbsp

---

Variable Documentation

$automatic_wildcard = (($search_option <3) ? '%' : '')

Definition at line 82 of file db_search.php.

$current['Field'] = PMA_backquote($current['Field'])

Definition at line 65 of file db_search.php. Referenced by SC_mod_tools_em_index::findMD5ArrayDiff(), SC_wizard_add::main(), PMA_DBI_get_tables(), and PMA_displayPrivTable().

$implode_str = ($search_option == 1 ? ' OR ' : ' AND ')

Definition at line 111 of file db_search.php.

$like_or_regex = (($search_option == 4) ? 'REGEXP' : 'LIKE')

Definition at line 81 of file db_search.php.

$num_tables = count($tables)

Definition at line 24 of file db_search.php.

$search_wds_cnt = count($search_words)

Definition at line 79 of file db_search.php.

$search_words = (($search_option > 2) ? array($search_str) : explode(' ', $search_str))

Definition at line 78 of file db_search.php.

return $sql = $sqlstr_select . ' * ' . $sqlstr_from . $sqlstr_where

Definition at line 120 of file db_search.php. Referenced by PMA_splitSqlFile().

$sqlstr_from = ' FROM ' . PMA_backquote($GLOBALS['db']) . '.' . PMA_backquote($table)

Definition at line 73 of file db_search.php.

$sqlstr_where = ' WHERE'

Definition at line 112 of file db_search.php.

$sub_part = ''

Displays top links Definition at line 30 of file db_search.php.

$tables = PMA_DBI_get_tables($db)

Get the list of tables from the current database Definition at line 23 of file db_search.php.

$tblfields[] = $current

Definition at line 66 of file db_search.php.

$tblfields_cnt = count($tblfields)

Definition at line 70 of file db_search.php.

$url_query = '&goto=db_search.php'

Definition at line 17 of file db_search.php.

goto

Initial value: db_details.php' . '&amp Definition at line 178 of file db_search.php.

is_js_confirmed

Initial value: 0'; // Only one table defined in an variable $onetable if (isset($onetable)) { // Displays search string echo ' ' . sprintf($strSearchResultsFor, htmlspecialchars($original_search_str), $option_str) . "\n"; echo ' <br />' . "\n"; // Gets the SQL statements $newsearchsqls = PMA_getSearchSqls($onetable, $search_str, $search_option); // Executes the "COUNT" statement $res = PMA_DBI_query($newsearchsqls['select_count']); $res_cnt = PMA_DBI_fetch_assoc($res); $res_cnt = $res_cnt['count']; PMA_DBI_free_result($res); $num_search_result_total = $res_cnt; echo ' <!-- Search results in table ' . $onetable . ' (' . $res_cnt . ') -->' . "\n" . ' <br />' . "\n" . ' <table><tr><td>' . sprintf($strNumSearchResultsInTable, $res_cnt, htmlspecialchars($onetable)) . "</td>\n"; if ($res_cnt > 0) { echo '<td>' . PMA_linkOrButton('sql.php?' . $url_sql_query . '&amp Definition at line 180 of file db_search.php.

& nbsp

Definition at line 338 of file db_search.php.

pos

Initial value: 0' . '&amp Definition at line 179 of file db_search.php.

<selectname="table_select[]"size="6"multiple="multiple"> selected

Initial value: "selected"'; } else { $is_selected = ''; } echo ' <option value="' . htmlspecialchars($tables[$i]) . '"' . $is_selected . '>' . htmlspecialchars($tables[$i]) . '</option>' . "\n"; $i++; } // end while echo ' </select>' . "\n"; $strDoSelectAll = '<a href="db_search.php?' . $url_query . '&amp;selectall=1#db_search"' . ' onclick="setSelectOptions(\'db_search\', \'table_select[]\', true); return false;">' . $strSelectAll . '</a>' . '&nbsp Definition at line 326 of file db_search.php. Referenced by tx_install::checkTheDatabase(), SC_wizard_colorpicker::colorList(), tslib_fe::connectToDB(), freesite_admin::displayDataForms(), SC_mod_web_perm_index::doEdit(), SC_alt_shortcut::editLoadedFunc(), SC_mod_tools_log_index::extensionSelector(), t3lib_tsfeBeUserAuth::extGetCategory_cache(), t3lib_tsfeBeUserAuth::extGetCategory_preview(), t3lib_tsfeBeUserAuth::extGetCategory_publish(), localRecordList::fieldSelectBox(), tslib_cObj::FORM(), SC_wizard_forms::getFormHTML(), t3lib_BEfunc::getFuncMenu(), recordList::getSearchBox(), t3lib_TCEforms::getSingleField_typeFlex_langMenu(), t3lib_TCEforms::getSingleField_typeSelect_single(), t3lib_TCEforms::getSingleField_typeSelect_singlebox(), template::getVersionSelector(), SC_mod_tools_em_index::importExtInfo(), SC_file_upload::main(), SC_file_newfolder::main(), SC_mod_user_setup_index::main(), SC_mod_tools_em_index::main(), t3lib_BEfunc::makeConfigForm(), SC_alt_doc::makeDocSel(), t3lib_queryGenerator::mkCompSelect(), t3lib_queryGenerator::mkFieldToInputSelect(), mailSelect::mkMailSelect(), t3lib_queryGenerator::mkOperatorSelect(), mailSelect::mkTableSelect(), t3lib_queryGenerator::mkTableSelect(), t3lib_queryGenerator::mkTypeSelect(), PMA_displayLoginInformationFields(), PMA_displayPrivTable(), PMA_displayTableNavigation(), PMA_foreignDropdown(), PMA_generate_dropdown(), PMA_generateCharsetDropdownBox(), t3lib_clipboard::printClipboard(), SC_mod_tools_log_index::processPresets(), SC_db_layout::renderQuickEdit(), tx_indexedsearch::renderSelectBox(), tx_impexp::renderSelectBox(), SC_mod_tools_log_index::renderSelectBox(), SC_mod_user_setup_index::simulateUser(), tx_install::stepOutput(), SC_mod_tools_log_index::tableSelector(), and t3lib_TCEmain::version_swap().

sql_query

Initial value: ' .urlencode($newsearchsqls['select_fields']), $strBrowse, '') . "</td>\n"; echo '<td>' . PMA_linkOrButton('sql.php?' . $url_sql_query . '&amp Definition at line 244 of file db_search.php. Referenced by PMA_displayPrivTable(), PMA_displayTableNavigation(), PMA_exportData(), PMA_generateEngineDetails(), PMA_getDbCollation(), PMA_mysqlDie(), PMA_setDisplayMode(), PMA_table_move_copy(), and tx_sysaction::renderActions().

---