/** * 获取条码信息 * * @param $code */ public function getInfoByCode($code, $dbconfig) { try { $sql = "select * from jk_dnb_hgk_send where fc_tm='" . $code . "'"; $dao = new Dao('', 'jk_dnb_hgk_send', '', false, $dbconfig); $rtn = $dao->query($sql)->toArray(); $unicode = $dbconfig['unicode']; if (!$unicode) { $unicode = 'gb2312'; } if ($rtn) { $rtn = $this->auto_charset($rtn, $unicode, 'utf8'); $rtn = $rtn[0]; $codeinfo['code'] = $rtn['fc_tm']; $codeinfo['factoryNo'] = $rtn['fvc_zzh']; $codeinfo['goodsName'] = $rtn['fvc_mc']; $codeinfo['spec'] = $rtn['fc_xs']; $codeinfo['current1'] = $rtn['fc_dl']; $codeinfo['voltage1'] = $rtn['fc_dy']; $codeinfo['direct'] = $rtn['fn_fx']; $codeinfo['constant'] = $rtn['fn_cs'] . '/' . $rtn['fn_cs_wg']; $codeinfo['grade'] = $rtn['fc_dj'] . '/' . $rtn['fc_dj_wg']; $codeinfo['madeIn'] = $rtn['fvc_zzc']; $codeinfo['madeDate'] = $rtn['fsd_ccrq']; $codeinfo['memo'] = '电能表'; return $codeinfo; } else { $sql = "select * from jk_hgq_hgk_send where fc_tm='" . $code . "'"; $rtn = $dao->query($sql)->toArray(); if ($rtn) { $rtn = $this->auto_charset($rtn, $unicode, 'utf8'); $rtn = $rtn[0]; $codeinfo['code'] = $rtn['fc_tm']; $codeinfo['factoryNo'] = $rtn['fvc_zzh']; $codeinfo['goodsName'] = $rtn['fvc_mc']; $codeinfo['spec'] = $rtn['fc_xs']; $codeinfo['current1'] = $rtn['fc_dl']; $codeinfo['voltage1'] = $rtn['fc_dy']; $codeinfo['direct'] = $rtn['fn_fx']; $codeinfo['constant'] = $rtn['fn_cs']; $codeinfo['grade'] = $rtn['fc_dj']; $codeinfo['madeIn'] = $rtn['fvc_zzc']; $codeinfo['madeDate'] = $rtn['fsd_ccrq']; $codeinfo['memo'] = '互感器'; return $codeinfo; } } return false; } catch (Exception $e) { throw new Exception($e); } }
public function exec($sql, $dbconfig, $unicode = 'gb2312') { $dao = new Dao('', 'jk_dnb_hgk_send', '', false, $dbconfig); $sql = $this->auto_charset($sql, 'utf8', $unicode); if (strpos($sql, 'select') !== false) { $result = $dao->query($sql)->toArray(); if ($result) { $result = $this->auto_charset($result, $unicode, 'utf8'); for ($i = 0; $i < count($result); $i++) { for ($j = count($result[$i]); $j >= 0; $j--) { unset($result[$i][$j]); } } $rtn["result"] = true; $rtn["value"] = $result; } else { $rtn["result"] = false; } } else { $result = $dao->execute($sql); if ($result) { $rtn["result"] = true; $rtn["value"] = $result; } else { $rtn["result"] = false; } } return $rtn; }
<?php /** * User: Deliang Yang * Version: 0.1.0.0 * Date: 14-9-12 * Time: 下午8:37 */ include "../Dao/Dao.class.php"; if (isset($_POST["doo"])) { $dao = new Dao("blog"); $sql = "DELETE FROM comment WHERE id = {$_POST['doo']}"; //$dao->close(); $dao->query($sql); $dao->error(); }
<?php session_start(); if (!isset($_SESSION['acceso'])) { header('Location: login.php'); } include "clases/Dao.php"; $db; $db = new Dao(array('server_ip' => 'localhost', 'server_user' => 'root', 'server_password' => '', 'server_db' => 'inventario_telematica')); $valor = $_POST['pr_id']; $pr_codigo = $_POST['pr_codigo']; $pr_nombre = $_POST['pr_nombre']; $pr_categoria = $_POST['pr_categoria']; $pr_preciocompra = $_POST['pr_preciocompra']; $pr_precioventa = $_POST['pr_precioventa']; $db->query("update productos set pr_codigo='{$pr_codigo}', pr_nombre = '{$pr_nombre}', pr_categoria = '{$pr_categoria}',pr_preciocompra = '{$pr_preciocompra}', pr_precioventa = '{$pr_precioventa}' where pr_id = {$valor}"); header("location: listado.php");
<?php session_start(); if (!isset($_SESSION['acceso'])) { header('Location: login.php'); } include "clases/Dao.php"; $db; $db = new Dao(array('server_ip' => 'localhost', 'server_user' => 'root', 'server_password' => '', 'server_db' => 'inventario_telematica')); $valor = $_GET['pr_id']; $borrar = $db->query("delete from productos where pr_id={$valor}"); header("location: listado.php");