<?php
header("Content-type:text/html;charset=utf-8");
require_once '../medoo/medoo.php';
// 初始化配置
$database = new medoo([
'database_type' => 'mssql',
'database_name' => '',
'server' => '**.***.**.**',
'username' => '*',
'password' => '*******',
'charset' => 'utf8',
'port'=>'1433'//不写端口可能连接不上
]);//执行有中文字段的sql
$page=$_POST['page'];
$pagesize=15;
$offset=($page-1)*$pagesize;
//这个是mssql分页查询的sql
$sql="SELECT top {$pagesize} 领料字号 as llid ,仓库名称 as ckmc,领料申请审核状态 as shzt ,领料单位 as lldw ,制单日期 as zdrq FROM 设备仓库出库主表 WHERE 领料字号 NOT IN(SELECT TOP {$offset} 领料字号 FROM 设备仓库出库主表 where 领料人='{$llr}' {$mytype} ORDER BY 领料字号 DESC) and 领料人='{$llr}' {$mytype} ORDER BY 领料字号 DESC";
// $sql=iconv( "gb2312", "UTF-8" , $sql);
$data=$database->query($sql)->fetchAll(PDO::FETCH_ASSOC);
var_dump($data);