header("Content-type:text/html;charset=utf-8"); $db=new mysqli("localhost","root","","news_php100") ; if(mysqli_connect_errno()){echo "链接失败:".mysqli_connect_error(); exit(); }
- $db->query("set names utf8");
- $result=$db->query("select name from class where f_id=0");
- while($row=$result->fetch_assoc()){
- echo $row[‘name‘]."<br>";
- }
- $result=$db->query("select * from class where f_id=1");
- while($row=$result->fetch_assoc()){
- echo $row[‘name‘]."
- $result=$db->query("select * from class");
- while($row=$result->fetch_assoc()){
- $arr[]=array($row[id],$row[f_id],$row[name]);
- }
- function fenlei($f_id=0){
- global $arr;
- for($i=0;$i<count($arr);$i++){
- if($arr[$i][1]==$f_id){
- <?
- .....
- .....
- if (emptyempty($func)) $func=="showtype";
- if (emptyempty($uid)) $uid=0;
- if ($func=="save"):
- $fields = "";
- $values = "";
- if ($id!="") {
- $fields .= ",id";
- $values.=",$id";
- }
- if ($uid!="") {
- $fields .= ",uid";
- $values.=",$uid";
- }
- if ($type!="") {
- $fields .= ",type";
- $values.=","$type"";
- }
- if ($route_id=="") {
- if ($uid!=0) {
- $result = mysqlquery("select * from type where id=$uid");
- $route_id=mysql_result($result,0,"route_id");
- } else {
- $routr_id="0";
- }
- $fields .= ",route_id";
- $route_id="$route_id:$id";
- $values.=","$route_id"";
- }
- if ($route_char!="") {
- $fields .= ",route_char";
- $route_char="$route_char:$type";
- $values.=","$route_char"";
- } else {
- $fields .= ",route_char";
- $route_char=$type;
- $values.=","$route_char"";
- }
- $fields = substr($fields,1,strlen($fields)-1);
- $values = substr($values,1,strlen($values)-1);
- $result = mysqlquery("insert into type ($fields) values ($values)");
- ...
- endif;
- if ($func=="createtype"):
- $result = mysqlquery("select * from type order by
- id desc");
- $num=mysql_numrows($result);
- if (!emptyempty($num)) {
- $cat = mysql_result($result,0,"id");
- } else {
- $cat=0;
- }
- if ($uid != 0) {
- $result=mysql_query("select * from type where id=$uid");
- $type=mysql_result($result,0,"type");
- $route_char=mysql_result($result,0,"route_char");
- } else {
- $type="父分类";
- }
- echo "<FORM ACTION="$PHP_SELF?func=save" METHOD=POST>";
- echo "<table>";
- echo "<tr><td>所属类别:$type</td></tr>";
- echo "<tr><td>创建分类:<input type=text name="type" SIZE=10 MAXLENGTH=100></td></tr>";
- echo "<tr><td>";
- $cat=$cat+1;
- echo "<input type=hidden name=id value="$cat">";
- echo "<input type=hidden name=uid value="$uid">";
- echo "<input type=hidden name=route_char value="$route_char">";
- echo "<INPUT TYPE=submit NAME="Save" VALUE="保存"></td></tr>";
- echo "</table>";
- echo "</form>";
- endif;
- if ($func=="showtype"):
- echo "<table>";
- if ($uid!=0) {
- $result=mysql_query("select * from type where id=$uid");
- $type=mysql_result($result,0,"type");
- } else {
- $type="父分类";
- }
- echo "<tr><td><a href="$php_self?func=createtype&uid=$uid">创建分类</a></td></tr>";
- echo "<tr><td>$type</td></tr>";
- $result=mysql_query("select * from type where uid=$uid");
- $num=mysql_numrows($result);
- if (!emptyempty($num)) {
- for ($i=0;$i<$num;$i++) {
- $id=mysql_result($result,$i,"id");
- $type=mysql_result($result,$i,"type");
- echo "<tr><td>";
- echo "<a href="$php_self?func=showtype&uid=$id">$type</a>";
- echo "</td></tr>";
- }
- }
- echo "</table>";
- endif;
- .....
- .....
- ?>
php代码与原理
原文:https://www.cnblogs.com/ymcs/p/15150961.html