function getLocation($status, $data) { $DB = new conn(); $DB->connect(); $location = ""; if ($status == 1) { // Get Office Location $sql = "select storagelocation_name from storagelocations where storagelocation_id = " . $data; $location = $DB->query_scalar($sql) . "<br /><br />"; } if ($status == 2) { // Get Employee Address $sql = "select Username from users where user_id = " . $data; $location = $DB->query_scalar($sql) . "<br /><br />"; } if ($status == 3) { $location = "Transferred<br/>"; } if ($status == 4 || $status == 5) { // Get customer address $sql = "select contacts.* from orders join contacts on orders.contact_id = contacts.contact_id where orders.order_id = " . $data; $result = $DB->query($sql); if ($result) { $row = mysql_fetch_assoc($result); $location = $row["contact_address"] . "<br />" . $row["contact_city"] . " " . $row["contact_state"] . ", " . $row["contact_zipcode"]; } } return $location; }
public function LoadData() { $DB = new conn(); $DB->connect(); $sql = "SELECT * FROM finance_options"; $result = $DB->query($sql); while ($row = mysql_fetch_assoc($result)) { $financeDetails[] = $row; } $DB->close(); return $financeDetails; }
<?php include "./findconfig.php"; include $_SERVER['DOCUMENT_ROOT'] . "/" . $ROOTPATH . "/Includes/Top.php"; $DB = new conn(); $DB->connect(); $sql = "Select * from StorageLocations"; $result = $DB->query($sql); if ($result) { ?> <TABLE class="data"> <th>id</th> <th>Location Name</th> <th>Commands</th> <?php while ($row = mysql_fetch_assoc($result)) { ?> <TR><TD><?php echo $row["storagelocation_id"]; ?> </TD> <TD><?php echo $row["storagelocation_name"]; ?> </TD> <TD><a href="#">Edit</a></TD> </TR> <?php } ?> </TABLE> <?php
</div> </div> <script src="//cdn.bootcss.com/jquery/1.11.3/jquery.min.js"></script> <script src="//cdn.bootcss.com/bootstrap/3.3.5/js/bootstrap.min.js"></script> <script type="text/javascript" src = './js/ptweixin.js'></script> <script type="text/javascript"> <?php require_once './config.php'; require_once './class/conn.class.php'; include './include/function.php'; $user_openid = $_GET['openid']; $user_ptid = -1; $con = new conn(); if (bind_check()) { $sql = "SELECT `username` FROM `users` WHERE `id` = {$user_ptid} "; $result = $con->query($sql); $username = $result[0]['username']; ?> $('#bind-success').html('成功绑定账号:'+<?php echo "'{$username}'"; ?> ); $('#bind-success').show(); $('#bind-button').attr('disabled','disabled'); <?php } ?> </script> </body>
<?php /** * @author qbuer * 建立依赖表 */ require_once './config.php'; require_once './class/conn.class.php'; $con = new conn(); $sql = "CREATE TABLE IF NOT EXISTS `weixin` (\n\t\t\t`ptid` int(10) \tNOT NULL COMMENT '同users表的id' ,\n\t\t\t`openid` varchar(128) NOT NULL COMMENT '微信用户id' ,\n\t\t\tPRIMARY KEY (`ptid`)\n\t\t) DEFAULT CHARSET=utf8 COMMENT='用户表';"; $con->query($sql); $con->disconnect();
<?php include "./findconfig.php"; include $_SERVER['DOCUMENT_ROOT'] . "/" . $ROOTPATH . "/Includes/Top.php"; ?> <?php $DB = new conn(); $DB->connect(); $sql = "Select * from products where product_type = 'Product' and status != 'deleted'"; ?> <?php $result = $DB->query($sql); if ($result) { ?> <TABLE class="data"> <th>product_id</th> <th>Product Model</th> <th>Product Name</th> <th style="width:350px">Product Description</th> <th>Status</th> <th style="width:150px">Commands</th> <?php while ($row = mysql_fetch_assoc($result)) { // Subquery for Accessories $sql2 = "select a.product_name from relproducts_accessories r join products a on r.accessory_id = a.product_id where r.product_id = " . $row["product_id"]; $acc = $DB->query($sql2); ?> <TR><TD><?php
require './class/conn.class.php'; require_once './config.php'; include './include/function.php'; require_once '../classes/class_cache.php'; $Cache = new CACHE(); $con = new conn(); if (isset($_GET['openid']) && $_GET['openid'] != '') { $user_openid = $con->mres($_GET['openid']); } else { exit; } if (isset($_GET['torrent'])) { $torrent = $con->mres($_GET['torrent']) * 1; } else { exit; } if (bind_check()) { $sql = "SELECT * FROM `bookmarks` WHERE `torrentid` = {$torrent} AND `userid` = {$user_ptid}"; $res = $con->query($sql); if (empty($res)) { $sql = "INSERT INTO bookmarks (torrentid, userid) VALUES ( {$torrent} , {$user_ptid} )"; if ($con->query($sql)) { echo json_encode(array('status' => 'success')); $Cache->delete_value('user_' . $user_ptid . '_bookmark_array'); } else { echo json_encode(array('status' => 'fail', 'errmsg' => '远程下载失败')); } } else { echo json_encode(array('status' => 'fail', 'errmsg' => '已经下载过了!')); } }
<?php require_once './config.php'; require_once './class/conn.class.php'; include './include/function.php'; $con = new conn(); if (!mkglobal('user:password:openid')) { exit(json_encode(array('status' => 'fail', 'errmsg' => '非法操作'))); } $sql = "SELECT * FROM `weixin` WHERE `openid` = '{$openid}'"; $result = $con->query($sql); if (!empty($result)) { exit(json_encode(array('status' => 'fail', 'errmsg' => '已绑定账户!'))); } $sql = "SELECT * FROM `users` WHERE `username` = '{$user}' "; $result = $con->query($sql); if ($result != NULL) { $rs = $result[0]; if ($rs['status'] == 'pending') { echo json_encode(array('status' => 'fail', 'errmsg' => '账户未激活')); exit; } if ($rs['passhash'] != md5($rs['secret'] . $password . $rs['secret'])) { var_dump($rs); echo md5($rs['secret'] . $password . $rs['secret']); echo json_encode(array('status' => 'fail', 'errmsg' => '密码错误!')); exit; } $sql = "INSERT INTO `weixin` (`ptid` , `openid` ) VALUES ('{$rs['id']}','{$openid}')"; if ($con->query($sql)) { echo json_encode(array('status' => 'success', 'errmsg' => '成功!'));
if ($action == "add") { // ALL FORM INPUTS MUST BE SANITIZED $ProductID = $DB->sanitize($_REQUEST["hProduct_ID"]); $AccessoryID = $DB->sanitize($_REQUEST["Accessory_ID"]); $sql = "DELETE from relproducts_accessories WHERE Product_ID = " . $ProductID . " AND Accessory_ID = " . $AccessoryID; $result = $DB->execute_nonquery($sql); if ($result > 0) { ?> <font color="red">Accessory already associated with this product.</font><br /><br /> <?php } $sql = "INSERT into relproducts_accessories (Product_ID, Accessory_ID) VALUES (" . $ProductID . ", " . $AccessoryID . ")"; $DB->execute_nonquery($sql); } } $sql = "select * from relproducts_accessories r join products on r.accessory_id = products.product_id where r.product_id = " . $product_id; $result = $DB->query($sql); $sql = "select * from products where product_id = " . $product_id; $prodInfo = $DB->query($sql); $sql = "select * from products where product_type = 'Accessory' and status = 'Active'"; $accessories = $DB->query($sql); if ($prodInfo) { while ($row = mysql_fetch_assoc($prodInfo)) { ?> Product: <b><?php echo $row["product_name"]; ?> </b><?php } } if (!$result) { echo "<br /><br />No accessories for product yet.";