Gecko [ 122.154.134.11 ]

Name	Size	Permission
asset.php	89.73 KB	-rw-r--r--
asset_budget_type.php	6.99 KB	-rw-r--r--
asset_building.php	7.37 KB	-rw-r--r--
asset_code_model.php	7.75 KB	-rw-r--r--
asset_company.php	9.95 KB	-rw-r--r--
asset_form_upload.php	4.74 KB	-rw-r--r--
asset_list.php	12.23 KB	-rw-r--r--
asset_method.php	6.91 KB	-rw-r--r--
asset_notification.php	38.37 KB	-rw-r--r--
asset_permission.php	13.12 KB	-rw-r--r--
asset_print.php	9.88 KB	-rw-r--r--
asset_print1.php	8.43 KB	-rw-r--r--
asset_print_lend.php	3.49 KB	-rw-r--r--
asset_print_lend1.php	9.59 KB	-rw-r--r--
asset_print_lend2.php	8.85 KB	-rw-r--r--
asset_print_lendAll.php	3.27 KB	-rw-r--r--
asset_print_lendAll1.php	9.84 KB	-rw-r--r--
asset_print_qrcode.php	10.28 KB	-rw-r--r--
asset_print_qrcode1.php	1.45 KB	-rw-r--r--
asset_report1.php	20 KB	-rw-r--r--
asset_report23.php	20.09 KB	-rw-r--r--
asset_report4.php	19.76 KB	-rw-r--r--
asset_report_to_excell.php	6.54 KB	-rw-r--r--
asset_set.php	8.43 KB	-rw-r--r--
asset_status3.php	85.25 KB	-rw-r--r--
asset_status40.php	85.27 KB	-rw-r--r--
asset_type.php	9.5 KB	-rw-r--r--
index.php	5.76 KB	-rw-r--r--
livesearch.php	2.11 KB	-rw-r--r--
livesearch_notification.php	954 B	-rw-r--r--
manual.php	1.38 KB	-rw-r--r--

Code Editor : livesearch.php

<?php
require_once("../../../amssplus_connect.php");
$q=$_GET["q"];
$livefile=$_GET["livefile"];
$response="<table width=100%>";
if(($livefile=='asset') or ($livefile=='asset_list')){
	$sql = "SELECT a.id, a.code, a.name, b.code as code_type, b.name as name_type FROM asset_list a, asset_type b WHERE a.code_type=b.code AND a.name like '%$q%' ORDER BY a.name";	//ไม่กำหนดข้อมูลการค้นหา//หรือ limit 10";  //ค้นหาได้ครั้งละ 10 คำ
	$dbquery = mysqli_query($connect,$sql);
	while($result = mysqli_fetch_array($dbquery)){
		$id = $result['id'];
		$code_type= $result['code_type'];
		$name_type= $result['name_type'];
		$name_type_dot=Strlen($name_type);
		if ( $name_type_dot > 100 ){ $dot = ".."; }else{ $dot = ""; }
		$name_type=substr($name_type,0,100)."".$dot;
		$code= $result['code'];
		$name = $result['name'];
		$name_dot=Strlen($name);
		if ( $name_dot > 100 ){ $dot = ".."; }else{ $dot = ""; }
		$name=substr($name,0,100)."".$dot;

switch ($livefile){
			case 'asset' :
				$response=$response."<tr>
					<td>$code</td>
					<td><a href=?option=asset&task=main/$livefile&index=1&code_type=$code_type&code=$code&name=".$name.">".$name."</a></td>
					<td>($code_type $name_type)</td>
				</tr>" ;
				break;
			case 'asset_list' :
				$response=$response."<tr>
					<td>$code</td>
					<td><a href=?option=asset&task=main/$livefile&index=1&code_type=$code_type&name=".$name.">".$name."</a></td>
					<td>($code_type $name_type)</td>
				</tr>";
				break;
		}
	}
	echo "</table>".$response;
}

if($livefile=='asset_company'){
	$sql = "SELECT * FROM asset_company WHERE name like '%$q%' ORDER BY name";	//ไม่กำหนดข้อมูลการค้นหา//หรือ limit 10";  //ค้นหาได้ครั้งละ 10 คำ
	$dbquery = mysqli_query($connect,$sql);
	while($result = mysqli_fetch_array($dbquery)){
		$name=$result['name'];
		$response=$response."<tr>
			<td width=50%><a href=?option=asset&task=main/$livefile&index=1&name=".$name.">".$name."</a></td>
			<td>$result[code]</td>
		</tr>" ;
	}
	echo "</table>".$response;
}
?>

${this.title}

Code Editor : livesearch.php