find.php

开源的 库存管理系统 www.minierp.cn php+ mysql

<?php
 include ("../inc/db.php");
 include ("../inc/phpmkrfn.php");
 include ('../inc/xtpl.php');
 include ("../inc/pageft.php");
 include ("../inc/nocache.php");

	$t_find=$_GET['x_find'];

	$xtpl=new XTemplate ("find.html");

	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);

//总页数
$sSql ="select jhdmast.*,gongyins.ACC01,jhddelt.JHD02,jhddelt.JHD07 from jhdmast LEFT JOIN jhddelt ON jhdmast.JHMID=jhddelt.JHDID  LEFT JOIN gongyins ON jhdmast.JHM02 = gongyins.ID WHERE ".BasicSearchSQL($t_find);
$result=phpmkr_query($sSql,$conn)or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);
$total=phpmkr_num_rows($result);
//调用pageft()，每页显示10条信息（使用默认的20时，可以省略此参数），使用本页URL（默认，所以省略掉）。
pageft($total);	

	$sSql ="select jhdmast.*,gongyins.ACC01,jhddelt.JHD02,jhddelt.JHD07 from jhdmast LEFT JOIN jhddelt ON jhdmast.JHMID=jhddelt.JHDID  LEFT JOIN gongyins ON jhdmast.JHM02 = gongyins.ID WHERE ".BasicSearchSQL($t_find)."   ORDER BY JHMID limit $firstcount,$displaypg";

	$rs  = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);


    while ($row = mysql_fetch_array($rs, MYSQL_ASSOC)) {
		$xtpl->assign("DATA",$row);		/* assign array data */
		$xtpl->parse("main.table.row");			/* parse a row */
	}
	
	$xtpl->parse("main.table");					/* parse the table */
	$xtpl->assign("PAGEINFO",$pagenav);   //分页	
	$xtpl->parse("main");
	$xtpl->out("main");

function BasicSearchSQL($Keyword)
{
	$sKeyword = (!get_magic_quotes_gpc()) ? addslashes($Keyword) : $Keyword;
	$BasicSearchSQL = "";
	$BasicSearchSQL.= "`JHMID` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`CLIID` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`ACC01` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`JHM01` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`JHM02` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`JHM03` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`JHM04` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`JHM05` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`JHM08` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`JHM09` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`JHD02` LIKE '%" . $sKeyword . "%' OR ";
	$BasicSearchSQL.= "`JHD07` LIKE '%" . $sKeyword . "%' OR ";

	if (substr($BasicSearchSQL, -4) == " OR ") { $BasicSearchSQL = substr($BasicSearchSQL, 0, strlen($BasicSearchSQL)-4); }
	return $BasicSearchSQL;
}
?>