function checkShuffle() { global $db; $sql = 'select * from users'; $n = getNum(); $ret = $db->query($sql); while ($row = $ret->fetchArray(SQLITE3_ASSOC)) { $tab[intval($row['id'])] = intval($row['target']); } for ($i = 1; $i <= $n; $i++) { if ($tab[$i] < 1 || $tab[$i] > $n) { //echo $tab[$i].'pas entier'; return false; } else { if ($tab[$i] == $i) { //echo 'pas dérangement'; return false; } } } for ($i = 1; $i <= $n; $i++) { for ($j = 1; $j < $i; $j++) { if ($tab[$i] == $tab[$j]) { //echo 'pas permutation'; return false; } } } return true; }
function update($tab) { global $db; $n = getNum(); for ($i = 1; $i <= $n; $i++) { $statement = $db->prepare('UPDATE users SET target=:target WHERE id=:id;'); $statement->bindValue(':target', $tab[$i]); $statement->bindValue(':id', $i); $statement->execute(); } header('Location: admin.php?shuffled=1'); }
function result($a, $b) { if ($a < $b) { $tem = $a; $a = $b; $b = $tem; } $i = getNum($a + $b); $j = getNum($a); $k = getNum($b); return $a . "个黄球 " . $b . "个红球共有 " . $i / ($j * $k) . " 种组合方式"; }
function getWire($string, &$array) { $action = $array[$string]['action']; $start = $array[$string]['start']; $second = $array[$string]['second']; $endwire = $array[$string]['endwire']; switch ($action) { case 'AND': $start = getNum($start, $wires); $second = getNum($second, $wires); $wires[$endwire] = $start & $second; break; case 'OR': $start = getNum($start, $wires); $second = getNum($second, $wires); $wires[$endwire] = $start | $second; break; case 'RSHIFT': $start = getNum($start, $wires); $second = getNum($second, $wires); $wires[$endwire] = $start >> $second; break; case 'LSHIFT': $start = getNum($start, $wires); $second = getNum($second, $wires); $wires[$endwire] = $start << $second; break; case 'NOT': $second = getNum($second, $wires); $bin = substr(decbin(~$second), 16); $bindec = bindec($bin); $wires[$endwire] = $bindec; break; case '': $second = getNum($second, $wires); $wires[$endwire] = $second; break; } }
$j = 1; } $starttime = strtotime($year . "-" . $month . "-1"); $endtime = strtotime($year . "-" . $j . "-1"); if ($starttime < time()) { $Quartersendordersql = "SELECT sum( Insurancefee + totalfee ) FROM {$tablepre}sendorder WHERE addtime BETWEEN " . $starttime . " AND " . $endtime; $Quarterordersql = "SELECT sum(goodsprice+sendprice) FROM {$tablepre}order WHERE addtime BETWEEN " . $starttime . " AND " . $endtime; $Quartersendorderdata = $db->result_first($Quartersendordersql); $Quarterorderdata = $db->result_first($Quarterordersql); $Quarterdata = $Quartersendorderdata + $Quarterorderdata; $serverfeesql = "select sum(serverfee) from {$tablepre}sendorder WHERE addtime BETWEEN " . $starttime . " AND " . $endtime; $serverfeedata = $db->result_first($serverfeesql); $dataarray[$month]['allmoney'] = getNum($Quarterdata); $dataarray[$month]['sendorderdata'] = getNum($Quartersendorderdata); $dataarray[$month]['orderdata'] = getNum($Quarterorderdata); $dataarray[$month]['servermoney'] = getNum($serverfeedata); } } //$orderway=$orderway=="asc"?"asc":"desc"; //if(!empty($orderby))$orderstr="{$orderby} {$orderway}"; //获取当前页码 //$total=$Table->getcount($wheresql); //总信息数 //$pagesize=15; //一页显示信息数 //$page = isset($page) ? max(1, intval($page)) : 1; //处理页码变量 //$offset=($page-1)*$pagesize; //偏移量 //$dataarray=$Table->getdata("$offset,$pagesize",$wheresql,$orderstr); //获取团购数据 //包含后台模板文件 include "tpl/fs_list.htm"; } else { showmsg("未知请求", "-1"); //出错!
} else { echo "<script type='text/javascript'> alert('Already existing')</script>"; } } if (isset($_GET['did'])) { $delete = mysql_query("delete from cri_uo_financeteam where id='" . $_GET['did'] . "'"); } function getNum() { $sql = "select count(user_name) from cri_uo_financeteam where status=1"; $result = mysql_query($sql); $total = mysql_fetch_array($result); return $total[0]; } if (isset($_POST['update'])) { $num_uoms = getNum(); $id = $_POST['edit_id']; foreach ($id as $val) { $user_name = $_POST['user_name'][$val]; $sql = "UPDATE cri_uo_financeteam SET is_head='1',user_name='" . $user_name . "' WHERE id='" . $val . "'"; mysql_query($sql); $sql1 = "UPDATE cri_uo_financeteam SET is_head='0' WHERE id='" . $val . "'"; mysql_query($sql1); } $sql1 = "UPDATE cri_uo_financeteam SET is_head='1' WHERE id='" . $_POST['is_head'] . "'"; mysql_query($sql1); } ?> <!DOCTYPE html> <html>
PS:如果你觉得以上写法需要在脑海里二次翻译,太过于麻烦,那么可以用以下的格式写法:{: 普通php写法 }<br/> <?php echo md5(mb_substr($user, 0, 3, 'UTF-8')); ?> <br/><br/> 当传递过来的变量如果没有值的时候,模版提供了默认值输出功能。<br/> <?php echo isset($nodate) && $nodate !== "" ? $nodate : '没有数据!'; ?> <br/><br/> 我们可以在模版中使用运算符,包括对“+” 、 “-” 、 “*” 、 “/” 、 “%” 、 “--”和“++” 的支持。<br/> <?php echo $num + 10; ?> <br/> <?php echo $num + getNum(); ?> getNum函数在Weibo/Common/Common/function.php中<br/><br/> 模版还支持三元运算符: <?php echo $withdata ? '$withdata有值' : '$withdata无值'; ?> <br/> </div> </body> </html>
<html> <head> <title>Player</title> </head> <body> <?php require "DB.php"; require "util.php"; error_reporting(E_ERROR | E_WARNING | E_PARSE); $db = DB::connect("mysql://*****:*****@localhost/games"); $name = $_GET['name']; $name = mysql_real_escape_string($name); echo "<h1>{$name}</h1>"; echo "<h3>Attendance: " . getNum($db, "select count(*) as num from scores inner join games on games.gameid = scores.gameid where games.number = 1 and scores.name = '{$name}'") . "</h3>"; echo "<h3>Games Played: " . getNum($db, "select count(*) as num from scores where name = '{$name}'") . "</h3>"; echo "<h3>Games Won: " . getNum($db, "select count(*) as num from scores where name = '{$name}' and position=1") . "</h3>"; echo "<h3>ELO: " . getNum($db, "select elo from elo where name = '{$name}' order by eloid desc limit 1") . "</h3>"; echo "<img src=\"graphs/elo.php?name={$name}\">"; doTable("Besties", $db, "select opp, concat(round(p / t * 100,0),'%') as pct from (select scores.name,s.name as opp,count(*) as p from scores inner join scores as s on scores.gameid = s.gameid where scores.name = '{$name}' and s.name <> '{$name}' group by s.name order by p desc) as plays join (select scores.name,count(*) as t from scores where scores.name = '{$name}') as total using (name) order by p/t desc limit 10"); doTable("Wins", $db, "select games.name,count(*) as num from games inner join scores on games.gameid=scores.gameid where scores.name='{$name}' and scores.position=1 group by games.name order by count(*) desc"); doTable("Games Played", $db, "select games.name,count(*) as num from games inner join scores on games.gameid = scores.gameid where scores.name = '{$name}' group by games.name order by num desc"); doPositionTable("Play History", $db, "select games.date,games.name,scores.position from games inner join scores on scores.gameid=games.gameid where scores.name = '{$name}' order by games.date asc, games.number asc"); ?> </body> </html>
</div> --> <div id="fixed_bag" class="clear_f" style="border:none"> <?php if (is_array($folder)) { $i = 0; $__LIST__ = $folder; if (count($__LIST__) == 0) { echo ""; } else { foreach ($__LIST__ as $key => $vo) { $mod = $i % 2; ++$i; ?> <div class="fixed_bag_pic"> <a href="javascript:void(0);" class="pic_icon"><?php echo getNum($vo['id'], $vo['fileid']); ?> </a> <input type="hidden" name="id" class="id" value="<?php echo $vo["id"]; ?> " /> <input type="hidden" name="type" class="type" value="<?php echo $vo["type"]; ?> " /></li> <p class="fixed_bag_text"><?php echo $vo["name"]; ?> </p> </div><?php
} for ($i = 0; $i < 6; $i++) { echo getACNum($recentDates[$i]) . ","; } echo getACNum($recentDates[6]); ?> ], color: '#66CC66' }, { name: '总提交', data: [<?php function getNum($d) { $res = mysql_query("SELECT COUNT(*) FROM `submit` WHERE LEFT(`submit_time`, 10) = '{$d}' "); $a = mysql_fetch_array($res); mysql_free_result($res); return $a[0]; } for ($i = 0; $i < 6; $i++) { echo getNum($recentDates[$i]) . ","; } echo getNum($recentDates[6]); ?> ], color: '#FFFF66' }] }); </script> </body> </html>
if (!isset($line[1])) { continue; } $line = array_map("getValue", $line); $etab = new CEtabExterne(); $etab->finess = getNum($line[0]); if ($etab->loadMatchingObject()) { continue; } $etab->siret = getNum($line[1]); $etab->ape = $line[2]; $etab->nom = $line[3]; $etab->raison_sociale = $line[3]; $etab->adresse = "{$line['4']}\n{$line['5']}\n{$line['6']}"; $etab->cp = $line[7]; $etab->ville = $line[8]; $etab->tel = getNum($line[9]); $etab->fax = getNum($line[10]); $etab->repair(); $type = $etab->_id ? "modify" : "create"; if ($msg = $etab->store()) { CAppUI::setMsg($msg, UI_MSG_WARNING); } else { CAppUI::setMsg("CEtabExterne-msg-{$type}", UI_MSG_OK); } } fclose($fp); unlink($_file); } CAppUI::callbackAjax('window.parent.$("systemMsg").show().insert', CAppUI::getMsg()); CApp::rip();
<html> <head> <title>Game</title> </head> <body> <?php require "DB.php"; require "util.php"; error_reporting(E_ERROR | E_WARNING | E_PARSE); $db = DB::connect("mysql://*****:*****@localhost/games"); $name = $_GET['name']; echo "<h1>{$name}</h1>"; $name = mysql_real_escape_string($name); echo "<h3>Times Played: " . getNum($db, "select count(*) as num from games where name = '{$name}'") . "</h3>"; doTable("Plays", $db, "select scores.name,count(*) as num from scores inner join games on games.gameid = scores.gameid where games.name = '{$name}' group by scores.name order by num desc"); doTable("Wins", $db, "select scores.name,count(*) as num from games inner join scores on games.gameid = scores.gameid where games.name='{$name}' and scores.position=1 group by scores.name order by num desc"); doTable("Win %", $db, "SELECT name, w / p * 100 AS win_pct FROM (SELECT scores.name, count(*) w FROM scores inner join games on games.gameid = scores.gameid WHERE position=1 and games.name = '{$name}' GROUP BY scores.name) AS wins JOIN (SELECT scores.name, count(*) p FROM scores inner join games on games.gameid = scores.gameid where games.name = '{$name}' GROUP BY scores.name) AS plays USING (name) ORDER BY win_pct DESC"); echo "<p>"; $sql = "select date,number,name,owner,gameid from games where name='{$name}' order by date asc, number asc"; $q = $db->query($sql); echo "<table border=1>"; echo "<tr><th>#<th>Date<th>#<th>Player<th>Score<th>Player<th>Score<th>Player<th>Score<th>Player<th>Score<th>Player<th>Score<th>Player<th>Score<th>Player<th>Score"; $idx = 1; while ($q->fetchInto($r1)) { echo "<tr><td>{$idx}<td>{$r1['0']}<td>{$r1['1']}"; $idx++; $gameid = $r1[4]; $sql = "select name, points from scores where gameid = {$gameid} order by position asc"; $q2 = $db->query($sql); while ($q2->fetchInto($r2)) {
case 'OR': $wires[$out] = $num | $num2; break; case 'LSHIFT': $wires[$out] = $num << $num2; break; case 'RSHIFT': $wires[$out] = $num >> $num2; break; } } elseif ($op == 'NOT') { $num = getNum($a); if ($num === false) { $queue[] = $line; continue; } $wires[$out] = ~$num & 0xffff; } elseif ($op == 'ASSIGN') { $num = getNum($a); if ($num === false) { $queue[] = $line; continue; } // part 2: override value of b from input file with result from wire a in part 1 if ($out == 'b') { $num = 956; } $wires[$out] = $num; } } echo "wire a: " . $wires['a'] . "\n";
<?php function getNum($action) { while (1) { $num = rand(1000, 9999); $stored = $action->send($num); if ($stored > 500) { break; } } } function storage() { $r = 0; while (1) { $num = (yield $r); if ($num) { echo $num . "\n"; file_put_contents("./car.txt", $num . "\n", FILE_APPEND); $r++; } } } $S = storage(); getNum($S);
<body style="overflow: auto;"> <div id="body"> <div id="top"> <h2><b><?php echo $test_type . " >> " . $test_title; ?> </b></h2> </div> <div id="bottom"> <?php $conn = db_connect(); if (!conn) { echo "<script>alert(\"连接数据库失败,请联系管理员!\")</script>"; } $chapter_id = getNum($test_title); //获取章节数(数字) 第1章练习->1 $query = "select * from tb_question where type='" . $test_type . "' and chapter_id='" . $chapter_id . "'"; $result = $conn->query($query); $num = $result->num_rows; if (!$result) { echo "<script>alert(\"查询数据库失败,请联系管理员!\")</script>"; } else { if ($num == 0 && !$test_title != '') { //-----------这里判断有误----------- echo "<p>该章节没有测试题</p>"; } else { $list = array(); while ($settings = $result->fetch_assoc()) { //读取为关联数组,读取一次指针向前移动一位 array_push($list, $settings);