👁 View: search_results.php
Path: /home/thiqat5/admincrud.thiqatech.com/sql/modules/views/search_results.php
Size: 1.34 KB · Modified: 2023-08-20 10:31:19 · Perm: 0644 · Writable
<link href='cache.php?css=theme,default,grid,alerts,editor' rel="stylesheet" />

<div id="popup_wrapper">
	<div id="popup_contents">
		<div class="ui-state-highlight padded">{{MESSAGE}}</div>
		<table width="95%" border="0" cellspacing="1" cellpadding="2" id="table_grid"><tbody>
			<tr id='fhead'>
				<th style="width:40%"><?php echo __('Table'); ?></th>
				<th style="width:60%"><?php echo __('Number of matches'); ?></th>
			</tr>
			<?php foreach($data['results'] as $table => $info) { ?>
				<tr>
					<td><?php echo $table; ?></td>
					<td><?php 
						if ($info['matches'] == 0)
							echo $info['matches'];
						else {
							$txt = str_replace('{{NUM}}', $info['matches'], __('{{NUM}} match(es)'));
							$txt .= '&nbsp;[' . __('Copy query to editor') . ']';
							echo '<a href="#">'.$txt.'</a><div style="display:none">'.htmlspecialchars($data['queries'][$table]).'</div>';
						}
					?></td>
				</tr>
			<?php } ?>
		</tbody></table>
	</div>
</div>

<script type="text/javascript" language='javascript' src="cache.php?script=common,jquery,ui,position,query"></script>
<script type="text/javascript" language="javascript">
window.title = "<?php echo __('Search Results'); ?>";
$(function() {
	$('#table_grid a').click(function() {
		sql = $(this).siblings('div').eq(0).text();
		parent.setSqlCode(parent.sql_delimiter + sql, 1);
	});
});
</script>