public function ChangePassword($username, $oldPassword, $newPassword) { $result = false; $sql = "select password from t_admin where username='******'"; //创建一个SqlHelper对象 $sqlHelper = new SqlHelper(); $res = $sqlHelper->execute_dql($sql); if ($row = mysql_fetch_assoc($res)) { //比对密码 if (md5($oldPassword) == $row['password']) { $sql = "update t_admin set password='******' where username='******'"; if ($sqlHelper->execute_dml($sql) != 0) { $result = true; } else { $this->errMessage = "更新失败!"; } } else { $this->errMessage = "原始密码不正确"; } } //资源 mysql_free_result($res); //关闭链接 $sqlHelper->close_connect(); return $result; }
function getEmpListByPage($pageNow, $pageSize) { $strNum = ($pageNow - 1) * $pageSize; $sql = "select * from emp limit {$strNum},{$pageSize}"; $sqlHelper = new SqlHelper(); $re = $sqlHelper->execute_dql($sql); // $sqlHelper->close_conn(); return $re; }
public function getPageCount($pageSize) { $sql = "select count(id) from student"; $sqlHelper = new SqlHelper(); $res = $sqlHelper->execute_dql($sql); //calcute if ($row = mysql_fetch_row($res)) { $pageCount = ceil($row[0] / $pageSize); } //free return $pageCount; }
public function checkAdmin($id, $password) { $sql = "select password,name from admin where id={$id}"; $sqlhelper = new SqlHelper(); $res = $sqlhelper->execute_dql($sql); if ($row = mysqli_fetch_assoc($res)) { if (md5($password) == $row['password']) { return true; } } mysqli_free_result($res); $sqlhelper->close_conn(); return false; }
public function getPagecount($pagesize) { $sql = "select count(id) from emp"; $sqlHelper = new SqlHelper(); $res = $sqlHelper->execute_dql($sql); if ($row = mysql_fetch_row($res)) { $pagecount = ceil($row[0] / $pagesize); } //关闭资源 mysql_free_result($res); //关闭连接 $sqlHelper->close_connect(); return $pagecount; }
function getPageCount($pageSize) { //查询rowcout $sql = "select count(id) from brand_wyeth_customer"; $sqlhelper = new SqlHelper(); $res = $sqlhelper->execute_dql($sql); //计算pagecount if ($row = mysql_fetch_row()) { $pagecount = ceil($row[0] / $pageSize); } //释放资源关闭链接 mysql_free_result($res); mysql_close(); return $pagecount; }
function getPageCount($pageSize) { //需要查询$rowCount $sql = "select count(id) from emp"; $sqlHelper = new SqlHelper(); $res = $sqlHelper->execute_dql($sql); //这样就可以计算$pageCount if ($row = mysql_fetch_row($res)) { $pageCount = ceil($row[0] / $pageSize); } //释放资源关闭链接 mysql_fetch_row($res); $sqlHelper->close_connect(); return $pageCount; }
public function checkAdmin($id, $password) { $sql = "select password,name from userlogin where id={$id}"; $sqlHelper = new SqlHelper(); $res = $sqlHelper->execute_dql($sql); if ($row = mysql_fetch_assoc($res)) { if (md5($password) == $row['password']) { return $row['name']; } } //关闭资源 mysql_free_result($res); //关闭连接 $sqlHelper->close_connect(); return ""; }
public function chekcAdimn($id, $password) { $sql = "select password,name from admin where id={$id}"; //创建一个SqlHelper对象 $sqlHelper = new SqlHelper(); $res = $sqlHelper->execute_dql($sql); if ($row = mysql_fetch_assoc($res)) { //比对密码 if (md5($password) == $row['password']) { return $row['name']; } } //释放资源 mysql_free_result($res); //关闭链接 $sqlHelper->close_connect(); return ""; }
public function checkAdmin($id, $password) { $sql = "select password,name from admin where id={$id}"; //????SqlHelper?? $sqlHelper = new SqlHelper(); $res = $sqlHelper->execute_dql($sql); if ($row = mysql_fetch_assoc($res)) { //???? if (md5($password) == $row['password']) { return $row['name']; } } //???? mysql_free_result($free); //???? $sqlHelper->close_connect(); return false; }
function getMessage($getter, $sender) { $sql = "select * from messages where getter='{$getter}' and sender='{$sender}' and isGet=0"; //注意此处的sql语句中sender=“$getter”;是加引号的 //file_put_contents("C:/wamp/www/testinfo.log","sql=".$sql."\r\n", FILE_APPEND); $sqlhelper = new SqlHelper(); $array = $sqlhelper->execute_dql($sql); //dql返回的是数组 $mesInfo = "<mes>"; for ($i = 0; $i < count($array); $i++) { $row = $array[$i]; $mesInfo .= " <mesId>{$row['id']}</mesId>\n\t\t\t\t\t\t <sender>{$row['sender']}</sender>\n\t\t\t\t\t\t <getter>{$row['getter']}</getter>\n\t\t\t\t\t\t <content>{$row['content']}</content>\n\t\t\t\t\t\t <sendTime>{$row['sendTime']}</sendTime>"; } $mesInfo .= "</mes>"; $sqll = "update messages set isGet=1 where getter='{$getter}' and sender='{$sender}'"; // file_put_contents("C:/wamp/www/testinfo.log","sql=".$sql."\r\n", FILE_APPEND); $sqlhelper->execute_dml($sqll); //file_put_contents("C:/wamp/www/testinfo.log", $mesInfo."\r\n",FILE_APPEND); $sqlhelper->close_connect(); return $mesInfo; }
$sqlHelper = new SqlHelper(); echo '<div class="header" style="height: 50px; position: absolute; background-color: black; width: 100%;"> <a href="javascript:" class="user" target="contentFrame" style="float:right; margin-right:20px; margin-top:-1px; "><img src="images/user.png" title="用户设置" ></a> <a href="api/search.php" target="contentFrame" style="float:right; margin-right:10px; "><img src="images/search15.png" title="搜索"></a> <span style="float:right; font-size:13px; margin-top:25px; margin-right:25px;">欢迎,'; echo $username; echo '!</span> </div> <div class="container demo-1"> <div class="column">'; for ($j = 1; $j <= 6; $j++) { for ($m = 1; $m <= 6; $m++) { $sql = "select id,name from sys where jizu={$j} and mainsys={$m}"; $res[$j][$m] = $sqlHelper->execute_dql($sql); $row_cnt[$j][$m] = $res[$j][$m]->num_rows; $height[$j][$m] = ($row_cnt[$j][$m] / 4 + 2) * 50; } } for ($m = 7; $m <= 9; $m++) { $sql = "select id,name from sys where jizu=7 and mainsys={$m}"; $res[7][$m] = $sqlHelper->execute_dql($sql); $row_cnt[7][$m] = $res[7][$m]->num_rows; $height[7][$m] = ($row_cnt[7][$m] / 4 + 2) * 50; } echo "<div id='dl-menu' class='dl-menuwrapper'>\n\t\t\t\t<button class='dl-trigger'>Open Menu</button>\n\t\t\t\t<ul class='dl-menu'>"; //1号机 echo "<li>\n\t\t\t\t\t\t<a href='#'>1号机</a>\n\t\t\t\t\t\t<ul class='dl-submenu'>\n\t\t\t\t\t\t\t<li>\n\t\t\t\t\t\t\t\t<a href='#'>1号锅炉</a>\n\t\t\t\t\t\t\t\t<ul class='dl-submenu' style='width:1000px; height:"; print $height[1][1]; echo "px;'>";
<body> <?php $file_to_require = realpath('api/SqlHelper.class.php'); //require "api/SqlHelper.class.php"; require_once $file_to_require; //header("content-type:text/html;charset=utf-8"); $eid = $_GET['eid']; //echo $e_sys; $sqlHelper = new SqlHelper(); $sql_bp = "select * from beipin where eid={$eid}"; $sql_title = "select * from equipments where id={$eid}"; $sql_sg = "select * from shigu where eid={$eid}"; //$sql_lbj="select * from lingbujian where eid=$eid"; $res = $sqlHelper->execute_dql($sql_bp); $res_title = $sqlHelper->execute_dql($sql_title); $res_sg = $sqlHelper->execute_dql($sql_sg); //$res_lbj= $sqlHelper->execute_dql($sql_lbj); $title = $res_title->fetch_row(); echo ' <div> <a href="equipment.php?sys=' . $title[2] . '" style="font-size:10px; " ><<返回列表</a> <h2>'; echo $title[1]; echo '</h2> </div> <div class="nTab"> <!-- 标题开始 --> <div class="TabTitle">
$eid = $xls->sheets[0]['cells'][$i][4]; $data_values .= "('{$name}','{$type}',{$num},{$eid}),"; } $data_values = substr($data_values, 0, -1); //去掉最后一个逗号 $query = $sqlHelper->execute_dml("insert into beipin (name,type,num,eid) values {$data_values}"); //批量插入数据表中 if ($query) { echo '导入成功!'; } else { echo '导入失败!'; } } } elseif ($action == 'export') { //导出XLS $result = $sqlHelper->execute_dql("select * from student"); $str = "姓名\t性别\t年龄\t\n"; $str = iconv('utf-8', 'gb2312', $str); while ($row = $result->fetch_array()) { $name = iconv('utf-8', 'gb2312', $row['name']); $sex = iconv('utf-8', 'gb2312', $row['sex']); $str .= $name . "\t" . $sex . "\t" . $row['age'] . "\t\n"; } $filename = date('Ymd') . '.xls'; exportExcel($filename, $str); } function exportExcel($filename, $content) { header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/vnd.ms-execl"); header("Content-Type: application/force-download");
<table class="sTab" style="margin:20 auto;" > <tr> <td> <select name="catalog" style="line-height:30px; font-size:20px;"> <option>请选择</option> <option value="4">设备</option> <option value="1">备品备件</option> <option value="2">异动单</option> <option value="3">模拟单</option> </select> </td> <td><input type="text" name="name" size="50" style="line-height:30px; font-size:20px;" /></td> <td><input type="submit" value="搜索" class="searchBtn" style="line-height:30px; font-size:20px;"></td></tr>'; $sqlrecent = "SELECT * FROM recentsearch ORDER BY id DESC LIMIT 5"; $res = $sqlHelper->execute_dql($sqlrecent); $row_cnt = $res->num_rows; if ($row_cnt != 0) { echo "<tr><td colspan='3'>最近搜索:"; while ($row = $res->fetch_array()) { echo "<a href='searchpages.php?name=" . $row['name'] . "&catalog=" . $row['catalog'] . "'>" . $row['name'] . "</a> "; } echo "</td></tr>"; } echo '</table> </div> </form>'; /* if(isset($_POST['name'])){ $name=$_POST['name'];
$e_sys = $_GET['sys']; $sqlHelper = new SqlHelper(); echo "<h2 style='text-align:center;'>设备管理</h2>"; echo '<form action="" method="post" class="addForm"> <div > <h4 class="add" style="text-align:center;">添加</h4> <table class="addTab" style="margin:0 auto; " > <tr> <td>名称:</td><td><input type="text" name="name" size="40" /><span style="color:red">*</span></td> <td><input type="submit" value="确定" class="addBtn"></td></tr> </table> </div> </form>'; $sqls = "select * from equipments where e_sys={$e_sys}"; $ress = $sqlHelper->execute_dql($sqls); //设备编辑 $i = 1; echo "<h4 style='text-align:center;' class='show'>编辑</h4>"; echo "<table class='gridtable' style='margin:20px auto;'><tr>"; while ($rows = $ress->fetch_row()) { echo "<td><input type='checkbox' name='gid[]' value='{$rows['0']}' ></td><td class='editrow' id='{$rows['0']}'>"; echo $rows[1]; echo "</td>"; if ($i % 5 == 0) { echo "</tr><tr>"; } $i++; } $ress->free(); //删除按钮
echo "名称不能为空"; } else { $sqladd = "insert into sys (name,jizu,mainsys) values ('{$name}','{$addjizu}','{$addm_sys}')"; $b = $sqlHelper->execute_dml($sqladd); if ($b == 1) { echo "添加成功"; } else { echo "添加失败"; } } } else { if (isset($_POST['edit'])) { $jizu = $_POST['jizu']; $m_sys = $_POST['sys']; $sql = "select * from sys where jizu={$jizu} and mainsys={$m_sys}"; $res = $sqlHelper->execute_dql($sql); //$row_cnt=$res->num_rows ; $i = 1; //$row_cnt = $res -> num_rows; echo "<table class='gridtable' style='margin-left:50px;'><tr>"; while ($row = $res->fetch_row()) { echo "<td><input type='checkbox' name='gid[]' value='{$row['0']}' ></td><td class='editrow' id='{$row['0']}'>"; echo $row[1]; echo "</td>"; if ($i % 4 == 0) { echo "</tr><tr>"; } $i++; } $res->free(); echo "</tr><tr><td colspan='4'>";
}) </script> </head> <body> <?php $file_to_require = realpath('api/SqlHelper.class.php'); require_once $file_to_require; //header("content-type:text/html;charset=utf-8"); //require_once('api/valiuser.php'); //checkUserValidate(); $eid = $_GET['eid']; $sqlHelper = new SqlHelper(); $sql_title = "select * from equipments where id={$eid}"; $res_title = $sqlHelper->execute_dql($sql_title); $title = $res_title->fetch_row(); echo ' <div style="text-align: center;"> <a href="equipment.php?sys=' . $title[2] . '" style="font-size:10px; " ><<返回列表</a> <h2 style="font-size:2.5em;">'; echo $title[1]; $res_title->free(); echo '</h2> </div> <div class="nTab"> <!-- 标题开始 --> <div class="TabTitle"> <ul id="myTab0"> <li class="active" onclick="nTabs(this,0);">技术资料</li>
} elseif ($_REQUEST['act'] == 'separate') { include_once ROOT_PATH . 'includes/lib_order.php'; require_once 'SqlHelper.php'; $sqlhelper = new SqlHelper(); $affiliate = unserialize($GLOBALS['_CFG']['affiliate']); empty($affiliate) && ($affiliate = array()); $separate_by = $affiliate['config']['separate_by']; $oid = (int) $_REQUEST['oid']; $order_id = $oid; //根据订单Id求买家id $user_id = $sqlhelper->execute_dql1("select user_id from ydcom_order_info where order_id={$order_id}"); //第1步查询出该笔订单的能产生的佣金 $fencheng1 = 0; $fencheng2 = 0; //根据order_id查表ydcom_order_goods中的goods_id $res0 = $sqlhelper->execute_dql("select goods_id,goods_price from ydcom_order_goods where order_id={$order_id} "); while ($row0 = mysql_fetch_array($res0)) { $goods_id = $row0[0]; $goods_price = $row0[1]; //根据goods_id查ydcom_goods中的fengcheng1,和fengcheng2; $res02 = $sqlhelper->execute_dql("select fencheng1,fencheng2 from ydcom_goods where goods_id={$goods_id} "); while ($row02 = mysql_fetch_array($res02)) { $fencheng1 += $row02[0] * $goods_price; $fencheng2 += $row02[1] * $goods_price; } } //模式一分成 $i = 0; $b1 = $sqlhelper->execute_dql1("select parent_id from ydcom_users where user_id={$user_id}"); //b1就是上家id for (; $b1 > 0;) {
<?php $file_to_require = realpath('api/SqlHelper.class.php'); //require "api/SqlHelper.class.php"; require_once $file_to_require; require_once 'api/valiread.php'; //验证用户 checkUserValidate(); $grade = $_SESSION['tzgrade']; header("content-type:text/html;charset=utf-8"); $e_sys = $_GET['sys']; //echo $e_sys; $sqlHelper = new SqlHelper(); $sql = "select * from equipments where e_sys={$e_sys}"; $sqltitle = "select name from sys where id={$e_sys}"; $res = $sqlHelper->execute_dql($sql); $res1 = $sqlHelper->execute_dql($sqltitle); //$row_cnt=$res->num_rows ; $row1 = $res1->fetch_row(); $title = $row1[0]; $i = 1; echo "<h2 style='text-align:center; margin-top:50px;'>{$title}</h2>"; echo "<table class='gridtable'><tr>"; while ($row = $res->fetch_row()) { if ($grade == 1) { echo "<td><a href=content.php?eid={$row['0']}>"; } else { if ($grade == 2) { echo "<td><a href=contentread.php?eid={$row['0']}>"; } }
<?php require_once 'SqlHelper.class.php'; header("content-type:text/html;charset=utf-8"); $eid = $_POST['eid']; $page = intval($_POST['pageNum']); $sqlHelper = new SqlHelper(); $sql_bp = "select * from dxjl where eid={$eid}"; $result = $sqlHelper->execute_dql($sql_bp); $total = $result->num_rows; //总记录数 $pageSize = 12; //每页显示数 $totalPage = ceil($total / $pageSize); //总页数 $startPage = $page * $pageSize; $arr['total'] = $total; $arr['pageSize'] = $pageSize; $arr['totalPage'] = $totalPage; $firstPage = "select id,dxtime,jilu,file_name from dxjl where eid={$eid} order by id asc limit {$startPage},{$pageSize}"; $query = $sqlHelper->execute_dql($firstPage); while ($row = $query->fetch_array()) { $arr['list'][] = array('id' => $row['id'], 'dxtime' => $row['dxtime'], 'jilu' => $row['jilu'], 'file_name' => $row['file_name']); } //print_r($arr); echo json_encode($arr);
$sqlinsert = "insert into recentsearch (name,catalog) values ('{$name}','{$c}')"; $b = $sqlHelper->execute_dml($sqlinsert); if ($c == 1) { //查找备品 if (isset($_GET['page'])) { $page = intval($_GET['page']); } else { $page = 1; } //获取分页 $offset = $pageSize * ($page - 1); $prepage = $page - 1; $nextpage = $page + 1; //获得所有结果列数 $sqlcnt1 = "select count(*) from beipin where name like '%{$name}%'"; $rescnt1 = $sqlHelper->execute_dql($sqlcnt1); $cntrow1 = $rescnt1->fetch_array(); $numrow1 = $cntrow1[0]; //分页取出 $sql1 = "select * from beipin where name like '%{$name}%' limit {$offset},{$pageSize}"; $res1 = $sqlHelper->execute_dql($sql1); //总页数 $totalpage = ceil($numrow1 / $pageSize); if ($numrow1 == 0) { echo "<div style='text-align:center; margin-top:30px; color:red;'>找不到该结果</div>"; } else { $i = 1; echo "<table class='gridtable' style='margin:0 auto; line-height:30px;'>\n\t\t\t\t\t\t <tr><th width='60px;'>序号</th><th width='600px;'>名称</th><th width='200px;'>型号</th><th width='100px;'>数量</th><th width='100px;'>在装数量</th><th width='100px;'>所属设备</th></tr>\n\t\t\t\t\t\t "; while ($row1 = $res1->fetch_array()) { $eid1 = $row1['eid']; $sqle1 = "select e_name from equipments where id={$eid1}";