摘要: ---情景--- 关系:角色N-N区域 基础表:角色表、区域表 关系表:主键-角色id-区域id集 ---需求--- 实现“单个区域勾选角色”且不借助与非SQL脚本(php etc)遍历 ---疑惑--- 之前我的处理是: 组合数据--先更新temporary table--借助临时表更新原关系表, 可以实现需求,页面已可渲染,程序已自测通过。 但今天虎哥、冬哥不让用临时表 目前(mysql ... 阅读全文
posted @ 2016-09-06 00:13 papering 阅读(200) 评论(0) 推荐(0) 编辑
摘要: PHP Advanced and Object-Oriented Programming Larry Ullman The standard solution in these situations is to use the Apache Web server’s mod_rewrite modu 阅读全文
posted @ 2016-09-05 23:17 papering 阅读(446) 评论(0) 推荐(0) 编辑
摘要: Discuz! 数据库字典_Discuz! 资料库 https://www.dz7.com.cn/library/database/x25_index.html pre_forum_forum 版块表 主键fid 全局字段fid mediumint(8) unsigned 版块ID、论坛id pre 阅读全文
posted @ 2016-09-05 03:29 papering 阅读(267) 评论(0) 推荐(0) 编辑
摘要: 1 $db = new mysqli('localhost', 'root', '', 'w'); 2 if($db->connect_error){ 3 die('Connect Error ( '.$db->connect_errno.' )'.$db->connect_error); 4 } 5 echo 'Connect OK.'; 6 $wtab = 'w'.ra... 阅读全文
posted @ 2016-09-05 00:15 papering 阅读(866) 评论(0) 推荐(0) 编辑
摘要: C:\>php D:\cmd\amzapi\amzapitest_com\MarketplaceWebServiceOrders\Samples\wd_learn.phpstring(2) "w1"string(3) "ww1"string(2) "w2"string(3) "ww2"string( 阅读全文
posted @ 2016-09-04 03:10 papering 阅读(265) 评论(0) 推荐(0) 编辑
摘要: JavaScript: The Definitive Guide, Sixth Edition by David Flanagan Property access expressions do not always return or set a value. This section explai 阅读全文
posted @ 2016-09-04 02:18 papering 阅读(269) 评论(0) 推荐(0) 编辑
摘要: High Performance MySQL, Third Edition by Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko 1 <?php 2 3 $db = new mysqli('localhost', 'root', '', 'w') 阅读全文
posted @ 2016-09-04 01:17 papering 阅读(1643) 评论(0) 推荐(0) 编辑
摘要: High Performance MySQL, Third Editionby Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko Settings for client/server communication When the server an 阅读全文
posted @ 2016-09-04 00:34 papering 阅读(404) 评论(0) 推荐(0) 编辑
摘要: High Performance MySQL, Third Edition by Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko There are two kinds of numbers: whole numbers and real num 阅读全文
posted @ 2016-09-04 00:28 papering 阅读(191) 评论(0) 推荐(0) 编辑
摘要: High Performance MySQL, Third Edition by Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko http://dev.mysql.com/doc/refman/5.7/en/charset-general.htm 阅读全文
posted @ 2016-09-03 23:34 papering 阅读(338) 评论(0) 推荐(0) 编辑
摘要: http://dev.mysql.com/doc/refman/5.7/en/view-updatability.html Some views are updatable and references to them can be used to specify tables to be upda 阅读全文
posted @ 2016-09-03 23:02 papering 阅读(231) 评论(0) 推荐(0) 编辑
摘要: 1 abd2 werg5 rthbg数字1和字母a b d 有关, 数字2和字母w e r g 有关 ,数字5和、、、、、、,字母a和数字1有关,字母b和数字1、5有关 求算法:和各个字母相关的各个数字 阅读全文
posted @ 2016-09-03 17:46 papering 阅读(180) 评论(0) 推荐(0) 编辑
摘要: #总结 角色表-关系表-区域表 N-N 关系表 结构 主键id-角色id-区域id集 现在要处理为单个区域分配角色#处理办法 ; 如果为单个角色分配区域,即可直接更新关系表某行或新增行(命名为w顺向关系表操作w);当前问题;将w逆向向关系表操作w转化为顺向关系表操作#转化办法;该关系表打散成单行,形 阅读全文
posted @ 2016-09-03 16:26 papering 阅读(232) 评论(0) 推荐(0) 编辑
摘要: 小结: 1、向一个程序输入一段随机比特流 provide invalid, unexpected, or random data as inputs to a computer program Fuzzing - Wikipedia https://en.wikipedia.org/wiki/Fuz 阅读全文
posted @ 2016-09-02 22:56 papering 阅读(372) 评论(0) 推荐(0) 编辑
摘要: CONCAT GROUP_CONCAT 阅读全文
posted @ 2016-09-02 16:34 papering 阅读(148) 评论(0) 推荐(0) 编辑
摘要: MySQL 超时时间timeout介绍 – 碎言碎语 https://johng.cn/mysql-timeout/ 2017-04-10 by John MySQL 超时时间timeout介绍 文章目录 1、timeout变量 2、分析 2.1 connect_timeout 2.2 intera 阅读全文
posted @ 2016-09-02 16:32 papering 阅读(656) 评论(0) 推荐(0) 编辑
摘要: GUI 阅读全文
posted @ 2016-09-02 16:30 papering 阅读(133) 评论(0) 推荐(0) 编辑
摘要: SET FOREIGN_KEY_CHECKS=0 阅读全文
posted @ 2016-09-01 18:52 papering 阅读(366) 评论(0) 推荐(0) 编辑
摘要: GO语言heap剖析及利用heap实现优先级队列 - 随风飘雪012 - 博客园 https://www.cnblogs.com/huxianglin/p/6925119.html 数据结构STL——golang实现优先队列priority_queue - 知乎 https://zhuanlan.z 阅读全文
posted @ 2016-09-01 14:37 papering 阅读(463) 评论(0) 推荐(0) 编辑
摘要: PHP Advanced and Object-Oriented Programming Larry Ullman The first thing that you must understand about OOP is that it presents not just new syntax b 阅读全文
posted @ 2016-09-01 13:27 papering 阅读(166) 评论(0) 推荐(0) 编辑
摘要: php.net $this is defined (A) $this is not defined. $this is defined (B) $this is not defined. /* The pseudo-variable $this is available when a method 阅读全文
posted @ 2016-09-01 00:50 papering 阅读(200) 评论(0) 推荐(0) 编辑
摘要: https://en.wikipedia.org/wiki/Unified_Modeling_Language 阅读全文
posted @ 2016-08-31 23:55 papering 阅读(168) 评论(0) 推荐(0) 编辑
摘要: route 阅读全文
posted @ 2016-08-30 00:57 papering 阅读(179) 评论(0) 推荐(0) 编辑
摘要: Computer Science An Overview 11th Edition Queues are often used as the underlying structure of a buffer, which as intro-duced in Chapter 1, is a stora 阅读全文
posted @ 2016-08-30 00:39 papering 阅读(188) 评论(0) 推荐(0) 编辑
摘要: https://en.wikipedia.org/wiki/First_normal_form https://en.wikipedia.org/wiki/Second_normal_form A relation is in first normal form if and only if the 阅读全文
posted @ 2016-08-30 00:10 papering 阅读(307) 评论(0) 推荐(0) 编辑
摘要: DATABASESYSTEM CONCEPTS SIXTH EDITION Abraham Silberschatz Yale University Henry F. KorthLehigh University S. SudarshanIndian Institute of Technology, 阅读全文
posted @ 2016-08-29 23:27 papering 阅读(472) 评论(0) 推荐(0) 编辑
摘要: PHP Advanced and Object-OrientedProgrammingVisual Quickpro GuideLarry Ullman //11 In PHP 5, when you create a copy of an object, PHP actually creates 阅读全文
posted @ 2016-08-29 09:03 papering 阅读(167) 评论(0) 推荐(0) 编辑
摘要: https://docs.python.org/3/reference/datamodel.html#object.__init__ 阅读全文
posted @ 2016-08-28 21:38 papering 阅读(181) 评论(0) 推荐(0) 编辑
摘要: Redis in Action JOSIAH L. CARLSON MANNING Shelter Island ZSETs offer the ability to store a mapping of members to scores (similar to the keys and valu 阅读全文
posted @ 2016-08-28 20:58 papering 阅读(178) 评论(0) 推荐(0) 编辑
摘要: int array_unshift ( array &$array , mixed $value1 [, mixed $... ] ) array_unshift() prepends passed elements to the front of the array. Note that the 阅读全文
posted @ 2016-08-28 19:46 papering 阅读(267) 评论(0) 推荐(0) 编辑
摘要: yield PEP 492 – Coroutines with async and await syntax | peps.python.org https://peps.python.org/pep-0492/ Abstract The growth of Internet and general 阅读全文
posted @ 2016-08-28 13:57 papering 阅读(425) 评论(0) 推荐(0) 编辑
摘要: PHP: 引用计数基本知识 - Manual https://php.net/manual/zh/features.gc.refcounting-basics.php 阅读全文
posted @ 2016-08-27 18:46 papering 阅读(173) 评论(0) 推荐(0) 编辑
摘要: 【前端精英群】去哪儿网司徒正美:avalon及通用MVVM的设计原理分析 https://mp.weixin.qq.com/s?src=3&timestamp=1640654265&ver=1&signature=YfS7PgVR0SjjLt4KwIQ297t4SDiLrrJu5C7uuMXpkCt 阅读全文
posted @ 2016-08-26 19:11 papering 阅读(260) 评论(0) 推荐(0) 编辑
摘要: PhpStorm 10.0.2 php interpreter 填入php.exe 暂且不用填写 Listen 63342 阅读全文
posted @ 2016-08-26 14:29 papering 阅读(163) 评论(0) 推荐(0) 编辑
摘要: PhpStorm 10.0.2 http://stackoverflow.com/questions/22572861/error-cant-use-subversion-command-line-client-svn-when-opening-android-proj The installer 阅读全文
posted @ 2016-08-26 13:46 papering 阅读(198) 评论(0) 推荐(0) 编辑
摘要: https://laravel.com/docs/5.2/queues 阅读全文
posted @ 2016-08-25 23:59 papering 阅读(168) 评论(0) 推荐(0) 编辑
摘要: JavaScript: The Definitive Guide, Sixth Edition by David Flanagan As explained above, the following two JavaScript expressions have the same value:obj 阅读全文
posted @ 2016-08-25 05:54 papering 阅读(161) 评论(0) 推荐(0) 编辑
摘要: 内部排序 外部排序 https://baike.baidu.com/item/内部排序 内部排序是指待排序列完全存放在内存中所进行的排序过程,适合不太大的元素序列。 排序是计算机程序设计中的一种重要操作,其功能是对一个数据元素集合或序列重新排列成一个按数据元素某个相知有序的序列。排序分为两类:内排序 阅读全文
posted @ 2016-08-24 22:22 papering 阅读(303) 评论(0) 推荐(0) 编辑
摘要: Introduction to algorithms / Thomas H. Cormen...[etal.].—3rded. If we attempt to pop an empty stack, we say the stack underflows, which is normally an 阅读全文
posted @ 2016-08-24 22:17 papering 阅读(486) 评论(0) 推荐(0) 编辑
摘要: https://en.wikipedia.org/wiki/HTTP_referer https://zh.wikipedia.org/wiki/HTTP参照位址 inline linking, offsite image grabs 高并发 反盗链 Most web servers maintai 阅读全文
posted @ 2016-08-24 21:03 papering 阅读(269) 评论(0) 推荐(0) 编辑