路由原理与实现

主流路由解决方案：pathinfo

  1. <?php
  2. require __DIR__ . '/../helper.php';
  4. //路由
  5. //!方案一,主流路由解决方案：pathinfo
  6. $url = 'http://php.edu/0507/router/demo2.php?c=user&a=hello&id=20&name=liyufeng';
  7. p(pathinfo($url));
  8. //显示如下：
  9. // Array
  10. // (
  11. //     [dirname] => http://php.edu/0507/router
  12. //     [basename] => demo2.php?c=user&a=hello&id=20&name=liyufeng
  13. //     [extension] => php?c=user&a=hello&id=20&name=liyufeng
  14. //     [filename] => demo2
  15. // )
  16. //!获取查询字符串：键值对：c=user&a=hello
  17. $url = 'http://php.edu/0507/router/demo2.php/one/two/three?c=user&a=hello';
  18. p(pathinfo($url));
  19. // $_SERVER['PATH_INFO']
  20. //获取参数：/one/two/three
  21. // p($_SERVER['PATH_INFO']);
  23. //单入口：index.php?m=模块,例如前台home,后台admin
  24. //模块/控制器/方法
  25. //index.php/module/controller/action
  27. //多入口
  28. // 前台：index.php,不需要模块，/controller/action
  29. // 后台：admin.php,不需要模块，/controller/action
  31. $url = 'http://php.edu/0507/router/demo2.php/admin/user/index';
  32. p($_SERVER['PATH_INFO']);
  33. //explode：把“/admin/user/index”转为数组
  34. p(explode('/',$_SERVER['PATH_INFO']));
  35. //第一种方法：array_filter过滤空数组
  36. // p(array_filter(explode('/',$_SERVER['PATH_INFO'])));
  37. //第一种方法：trim
  38. // p(explode('/', trim($_SERVER['PATH_INFO'],'/')));
  39. $request = explode('/', trim($_SERVER['PATH_INFO'],'/'));
  40. //数组解构:将模块、控制器、方法都解析出来
  41. [$module,$controller,$action] = $request;
  43. //参数解析格式
  44. //按顺序传参
  45. //id = 1
  46. //name = admin
  47. $url = 'http://php.edu/0507/router/demo2.php/admin/user/index/1/admin';
  48. //按键名进行传参
  49. //id = 1
  50. //name = admin
  51. $url = 'http://php.edu/0507/router/demo2.php/admin/user/index/id/1/name/admin/qq';
  53. require __DIR__ . '/User.php';
  54. //调用: admin\User::index()
  56. //1.先获取类名
  57. $className = $module . '\\' . ucfirst($controller);
  58. p($className);
  60. //2.获取参数
  61. $params = array_splice($request,3);
  62. // //按顺序传参处理如下：
  63. // echo call_user_func_array([$className,$action],$params);
  64. //按键名进行传参还需要如下处理
  65. // p($params);
  66. //把索引数组转为关联数组
  67. //array_chunk():分组取出
  68. $arr = array_chunk($params,2);
  69. $result = [];
  70. foreach($arr as $item){
  71.     [$key,$value] = $item;
  72.     $result[$key] = $value;
  73. }
  74. p($result);
  75. //3.过滤空值
  76. $result = array_filter($result);
  77. p($result);
  78. //4.调用
  79. echo call_user_func_array([$className,$action],$result);

视图原理与实现

  1. <?php
  2. namespace phpcn;
  4. class View
  5. {
  6.     //约定：控制器方法的模板，默认控制器为目录名，方法为文件名
  7.     protected $controller;
  8.     protected $action;
  9.     protected $path;
  10.     //模板容器
  11.     protected $data = [];
  13.     //初始化创建模板的路径
  14.     public function __construct($controller,$action,$path='/view/')
  15.     {
  16.         $this->controller = $controller;
  17.         $this->action = $action;
  18.         $this->path = $path;
  19.     }
  21.     //模板赋值
  22.     public function assign($name,$value)
  23.     {
  24.         //$name 是外部变量在模板文件中的变量名
  25.         //$value 模板变量的值
  26.         $this->data[$name] = $value;
  27.     }
  29.     //模板渲染
  30.     public function render($path = '')
  31.     {
  32.         //展开模板变量数组
  33.         extract($this->data);
  34.         if(empty($path)){
  35.             //生成路径
  36.             $file = __DIR__ . $this->path . $this->controller . '/' . $this->action . '.php';
  37.         }else{
  38.             $file = $path;
  39.         }
  41.         //加载
  42.         // include $file or die('视图不存在');
  43.         file_exists($file) ? include $file : die('视图不存在');
  44.     }
  46. }
  48. //调用
  49. $controller = 'User';
  50. $action = 'hello';
  52. $view = new View($controller,$action);
  54. //模板赋值：变量
  55. $view->assign('username','李先生');
  57. //模板赋值：数组
  58. $items = [
  59.     ['name'=>'李龙','gongzi'=>5000],
  60.     ['name'=>'刘强','gongzi'=>6000],
  61.     ['name'=>'杨旭','gongzi'=>7000],
  62. ];
  63. $view->assign('items',$items);
  65. //渲染模板
  66. $view->render();

数据库操作:增删查改

  1. <?php
  3. namespace phpcn;
  5. use PDO;
  7. class Db
  8. {
  9.     protected $db;
  10.     protected $table;
  11.     protected $field;
  12.     protected $limit;
  13.     protected $opt = [];
  15.     public function __construct($dsn,$username,$password)
  16.     {
  17.         $this->db = new PDO($dsn, $username, $password);
  18.     }
  20.     public function table($table){
  21.         $this->table = $table;
  22.         return $this;
  23.     }
  25.     public function field($field){
  26.         $this->field = $field;
  27.         return $this;
  28.     }
  30.     public function limit($limit = 10){
  31.         $this->limit = $limit;
  32.         $this->opt['limit'] = " LIMIT $limit";
  33.         return $this;
  34.     }
  36.     public function page($page = 1)
  37.     {
  38.         //偏移量：offset = (page - 1) * limit
  39.         $this->opt['offset'] = ' OFFSET ' . ($page - 1) * $this->limit;
  40.         return $this;
  41.     }
  43.     //查询条件
  44.     public function where($where = '')
  45.     {
  46.         $this->opt['where'] = " WHERE $where";
  47.         return $this;
  48.     }
  50.     //查询
  51.     public function select()
  52.     {
  53.         //拼装sql
  54.         $sql = 'SELECT ' . $this->field . ' FROM ' . $this->table;
  55.         $sql .= $this->opt['where'] ?? null;
  56.         $sql .= $this->opt['limit'] ?? null;
  57.         $sql .= $this->opt['offset'] ?? null;
  59.         echo $sql . '<br>';
  60.         //预处理
  61.         $stmt = $this->db->prepare($sql);
  62.         $stmt->execute();
  63.         //清空条件
  64.         $this->opt['where'] = null;
  66.         return $stmt->fetchAll();
  68.     }
  71.     //插入
  72.     public function insert($data)
  73.     {
  74.         // [a=>1,b=2] => 'a=1,b=2'
  75.         $str ='';
  76.         foreach($data as $key=>$value){
  77.             $str .= $key . '="' . $value . '",';
  78.         }
  79.         $sql = 'INSERT ' . $this->table . ' SET ' . rtrim($str,',');
  80.         echo $sql .'<br>';
  81.         //预处理
  82.         $stmt = $this->db->prepare($sql);
  83.         $stmt->execute();
  84.         //清空条件
  85.         $this->opt['where'] = null;
  87.         return $stmt->rowCount();
  88.     }
  90.     //更新
  91.     public function update($data)
  92.     {
  93.         // [a=>1,b=2] => 'a=1,b=2'
  94.         $str ='';
  95.         foreach($data as $key=>$value){
  96.             $str .= $key . '="' . $value . '",';
  97.         }
  98.         $sql = 'UPDATE ' . $this->table . ' SET ' . rtrim($str,',');
  99.         echo $sql .'<br>';
  100.         //禁止无条件更新
  101.         $sql .= $this->opt['where'] ?? die('禁止无条件更新');
  102.         //预处理
  103.         $stmt = $this->db->prepare($sql);
  104.         $stmt->execute();
  105.         //清空条件
  106.         $this->opt['where'] = null;
  108.         return $stmt->rowCount();
  109.     }
  111.     //删除
  112.     public function delete()
  113.     {
  114.         $sql = 'DELETE FROM ' . $this->table;
  115.         echo $sql .'<br>';
  116.         //禁止无条件更新
  117.         $sql .= $this->opt['where'] ?? die('禁止无条件删除');
  118.         //预处理
  119.         $stmt = $this->db->prepare($sql);
  120.         $stmt->execute();
  121.         //清空条件
  122.         $this->opt['where'] = null;
  124.         return $stmt->rowCount();
  125.     }
  126. }
  128. //测试
  129. //查询
  130. $db = new Db('mysql:dbname=phpedu','root','phpedu');
  131. // $result = $db->table('staff')->field('id,name,email')->select();
  132. // $result = $db->table('staff')
  133. //             ->field('id,name,email')
  134. //             ->where('id > 1')
  135. //             ->limit(2)
  136. //             ->page(2)
  137. //             ->select();
  138. // require __DIR__ . '/helper.php';
  139. // p($result);
  141. //新增
  142. // $n = $db->table('staff')->insert(['name'=>'李先生','sex'=>0,'email'=>'li@qq.com']);
  143. // 打印结果：INSERT staff SET name=李先生,email=li@qq.com,sex=0,
  144. // echo $n > 0 ? '新增成功' . $n . '条<br>' : '新增失败'. $n . '条<br>';
  146. //更新
  147. // $n = $db->table('staff')->where('id = 18')->update(['name'=>'刘女士','sex'=>1]);
  148. // echo $n > 0 ? '更新成功' . $n . '条<br>' : '更新失败'. $n . '条<br>';
  150. //删除
  151. $n = $db->table('staff')->where('id = 14')->delete();
  152. echo $n > 0 ? '删除成功' . $n . '条<br>' : '删除失败'. $n . '条<br>';

更多相关文章

  1. 常用数组函数学习
  2. android java开发 第一天 之熟悉eclipse adt
  3. Android中的数据结构解析（四）SparseArray和ArrayMap
  4. 20172323 2017-2018-2《程序设计与数据结构》第十一周学习总结
  5. PHP中的extract()函数
  6. PHP中的视图基类的实例演示
  7. 5个数组函数实例演示
  8. Linux/Android——input_handler之evdev (四)
  9. 2020年20种最佳Android应用程序模板

随机推荐

  1. Android上的命令内存相关
  2. android操作xml
  3. Android内核的根文件系统
  4. Android 常用布局
  5. Android动画一
  6. Android常见错误解析
  7. android 技术
  8. Android组件的样式
  9. Android进程和线程
  10. AndroidManifest.xml - 【 manifest -> p