P2NfWcKV

1<?php
2
3require 'config.php'; // Settings
4
5// Establish connection
6$link = mysql_connect($_sql_host, $_sql_user, $_sql_pass); 
7if (!$link) { 
8	die('Could not connect to MySQL: ' . mysql_error()); 
9} 
10// Connect to database
11mysql_select_db($_sql_db);
12
13$q = isset($_POST['item']) ? $_POST['item'] : null;
14
15$sql = "DROP VIEW IF EXISTS ITEMS_VIEW";
16$res = mysql_query($sql) OR die(mysql_error());
17
18$sql = "CREATE VIEW ITEMS_VIEW as SELECT * FROM `item_db` UNION SELECT * FROM `item_db2`";
19$res = mysql_query($sql) OR die(mysql_error());
20
21$sql   = "SELECT `name_japanese` AS `name`, `id` FROM ITEMS_VIEW ";
22$sql  .= "WHERE `name_japanese` LIKE '$q%' LIMIT 10";
23$res   = mysql_query($sql) OR die(mysql_error());
24$items =  array();
25
26while ($row = mysql_fetch_array($res)) {
27	$items[] = $row;
28}
29
30?>
31
32<?php if ($items): ?>
33	<table width="100%" cellspacing="0" cellpadding="3">
34	<?php foreach ($items as $item): ?>
35		<!--<tr class="subs" onclick="location.href='<?php echo $_base_dir . "/item/view/?id=" . $item['id'] ?>'" onmouseover="loadqry('<?php echo $item['name'] ?>', '<?php echo $item['id'] ?>')">
36			<td align="right" style="color:#777;"><?php echo $item['id'] ?></td>
37			<td><?php echo $item['name'] ?></td>
38		</tr>-->
39		<tr class="subs" onclick="loadqry('<?php echo $item['name'] ?>', '<?php echo $item['id'] ?>', '<?php echo $_base_dir . "/item/view/?id=" . $item['id'] ?>'); ">
40			<!--<td align="right" style="color:#777;"><?php echo $item['id'] ?></td>-->
41			<td><?php echo $item['name'] ?></td>
42		</tr>
43	<?php endforeach ?>
44	</table>
45<?php else: ?>
46	no items found
47<?php endif ?>