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;
}
