PHP s_fetch Examples

Example #1

File: menumain.php Project: BGCX261/zlskytakeorder-svn-to-git

<?php

session_start();
//include_once './inc/page.inc.php';
include_once './inc/init.php';
if ($_POST['id'] != '') {
    $sql = "update main set no='{$_POST['no']}',itemname='{$_POST['itemname']}',price='{$_POST['price']}',qty='{$_POST['qty']}',disc='{$_POST['disc']}',lineamt='{$_POST['lineamt']}',tax='{$_POST['tax']}',r='{$_POST['r']}',customize='{$_POST['customize']}',totalqty='{$_POST['totalqty']}',grossamt='{$_POST['grossamt']}',normal='{$_POST['normal']}',discount='{$_POST['discount']}',addin='{$_POST['addin']}',netamount='{$_POST['netamount']}',importer='{$_POST['importer']}',salesman='{$_POST['salesman']}',customer='{$_POST['customer']}',name='{$_POST['name']}',class='{$_POST['class']}',`delete`='{$_POST['delete']}',single='{$_POST['single']}',b='{$_POST['b']}',c='{$_POST['c']}',customeerno='{$_POST['customeerno']}',hold='{$_POST['hold']}',rethold='{$_POST['rethold']}',reprint='{$_POST['reprint']}',remark='{$_POST['remark']}',function='{$_POST['function']}',payment='{$_POST['payment']}',`exit`='{$_POST['exit']}' where id='{$_POST['id']}'";
    m_query($sql);
    echo "successful";
}
$sql = "select * from main";
$result = s_fetch($sql);
$smarty->assign('rows', $result);
$smarty->display("menumain.htm");
?>

Example #2

File: itemself.php Project: BGCX261/zlskytakeorder-svn-to-git

<?php

session_start();
include_once './inc/init.php';
require 'inc/ajax_order_page.inc.php';
$id = $_GET['id'];
$no = $_GET['no'];
$customize = $_GET['customize'];
$sql = "select sortname from takeorder_item where id='{$id}'";
$res = s_fetch($sql);
$sortname = $res[0]['sortname'];
$sql_itemself = "select * from takeorder_item where sortname='{$sortname}' and itemname!=''";
$query_itemself = m_query($sql_itemself);
$num = mysql_num_rows($query_itemself);
$p = new show_page();
$p->pvar = "p";
$p->setvar(array("id" => $_GET['id'], "no" => $no, "customize" => $customize));
$p->set(3, $num, "", "itemself");
$sql_itemself .= " limit " . $p->limit();
$itemsort_result = m_query($sql_itemself);
while ($row_itemself = m_fetch($itemsort_result)) {
    $itemselflist[] = $row_itemself;
}
//print_rr($itemselflist);
/*
$i =0;
while($row=m_fetch($itemsort_result)){
	$sortlist[]=$row;
	if($i==0){
        $sql_itemself = "select sortname from item where id='$id'";
        $query_itemself = m_query($sql_itemself);

Example #3

File: setitemnum.php Project: BGCX261/zlskytakeorder-svn-to-git

<?php

session_start();
include_once './inc/init.php';
$id = $_GET['id'];
$sql = "select * from item where id='{$id}' order by id desc";
$arritem = s_fetch($sql);
$no = $_GET['no'];
$customize = $_GET['customize'];
$smarty->assign('no', $no);
$smarty->assign('customize', $customize);
$smarty->assign('items', $arritem);
$smarty->display("setitemnum.htm");