public function ILike($id) { $db = new DBHelper(); $sql = "update mydairy set Likers=Likers+1 where id=" . $id; $db->query($sql); return "ok"; }
function retrieve_relationships($table, $values, $select_id) { $query = "SELECT {$select_id} FROM {$table} WHERE deleted = 0 "; foreach ($values as $name => $value) { $query .= " AND {$name} = '{$value}' "; } $query .= " ORDER BY {$select_id} "; $result = $this->db->query($query, false, "Retrieving Relationship:" . $query); $ids = array(); while ($row = $this->db->fetchByAssoc($result)) { $ids[] = $row; } return $ids; }
public function filterLinks() { $filter = array("gift", "feedback", "login", "register", "kaidian", "sitemap"); $db = new DBHelper(); $db->selectDB("FoodOrder"); for ($i = 0, $len = count($this->links[0][0]); $i < $len; $i++) { if ($this->links[0][2][$i] == "" || in_array($this->links[0][1][$i], $filter)) { unset($this->links[0][0][$i]); unset($this->links[0][1][$i]); unset($this->links[0][2][$i]); } else { $this->links[0][1][$i] = "http://" . $this->links[0][1][$i] . ".ele.me/"; $sql = "insert into site (sitename,siteurl) values ('" . $this->links[0][2][$i] . "','" . $this->links[0][1][$i] . "')"; $db->query($sql); } } }
<?php $gPageTitle = "主卧"; include "../include/templateHeader.php"; include "../include/utils.php"; ?> <a href="../index.php" data-role="button" data-icon="arrow-l">返回</a> <a href="masterBed.php" data-role="button" data-icon="refresh" data-ajax="false">更新</a> <ul data-role="listview" data-inset="true" > <li data-role="list-divider">实况</li> <?php $db = new DBHelper(); $query = "select * from tabDataHistory where fldNodeID2=15 order by fldID desc limit 1"; $results = $db->query($query); if ($row = $results->fetchArray()) { printf("<li>室温 %d.%d度 <span class='ui-li-count'>%s</span></li>", $row["fldData3"], $row["fldData4"], $row["fldCreatedOn"]); printf("<li>亮度 %d相对值 <span class='ui-li-count'>%s</span></li>", $row["fldData1"], $row["fldCreatedOn"]); } $db->close(); ?> </ul> <?php include "../include/templateFooter.php";
else { $.post("/api/sendData.php", { nodeID1: "100", nodeID2: "3", data1: "0" } ); } }); }); </script> <a href="../index.php" data-role="button" data-icon="arrow-l">返回</a> <a href="dining.php" data-role="button" data-icon="refresh" data-ajax="false">更新</a> <ul data-role="listview" data-inset="true" > <?php $db = new DBHelper(); $sql = "select fldNodeID1, fldNodeID2, fldData1, fldUpdatedOn, fldUpdatedBy from tabDataToNode "; $results = $db->query($sql); while ($row = $results->fetchArray()) { // 客厅灯 if ($row["fldNodeID1"] == 100 and $row["fldNodeID2"] == 3) { ?> <li data-role="list-divider">控制</li> <li data-role="fieldcontain"> <label for="flipDiningLight">射灯</label> <select name="flipDiningLight" id="flipDiningLight" data-role="slider"> <?php if ($row["fldData1"] == 0) { //当前灯是关的 echo "<option value='off' selected>关</option><option value='on'>开</option>"; } else { echo "<option value='off'>关</option><option value='on' selected>开</option>"; }
/** * can also issue a unique randomly generated token/code instead of a sequential code... * * @param array $rcnum Databases Row * @param DBHelper $db */ private static function ittap_issue_token($rcnum, $db) { if ($rcnum['check_unique'] == 0) { return self::ittap_make_token($rcnum['value_min_length']); } $code_unique = false; while (!$code_unique) { $token = self::ittap_make_token($rcnum['value_min_length']); $sql = "SELECT `{$rcnum['field_name']}` FROM `{$rcnum['module_id_name']}` WHERE `{$rcnum['field_name']}` = '{$token}';"; $result = $db->query($sql); $row = $db->fetchByAssoc($result); if (empty($row[$rcnum['field_name']])) { $code_unique = true; } } return $token; }