Web开发笔记

• LAMP
• Apache/Nginx
• MySQL
• PHP
  • 安装
  • 语言特性
  • 用过的变量
  • 用过的函数
  • 遇到过的问题
  • 简历模块开发问题记录
  • Composer
• HTML
  • HTML4
  • HTML5
• 相关框架
  • thinkcmf
• 相关工具
  • phpMyAdmin
• sqlite3
• 修订记录

LAMP

• Linux

• Apache/Nginx

• MySQL

• PHP

Apache/Nginx

MySQL

书籍：《数据库系统概论》

• 下载地址：数据库系统概论(第5版) (王珊/萨师煊著) 完整pdf扫描版[67MB] 电子书 下载-脚本之家

• 本地版本：数据库系统概论 第5版 带书签目录.pdf

遇到过的问题：

• database - Maximum length for MySQL type text - Stack Overflow

• java - SQL replace vs. doing an insert or update statement - Stack Overflow

• sql - Insert into a MySQL table or update if exists - Stack Overflow

• php - group_concat MYSQL new line - Stack Overflow

• how to concat two columns into one with the existing column name in mysql? - Stack Overflow

• How to Join 3 Tables (or More) in SQL | LearnSQL.com

• foreign keys - MySQL RESTRICT and NO ACTION - Stack Overflow

• linux file name length - Google Search

• MySQL :: MySQL 8.0 Reference Manual :: 8.4.7 Limits on Table Column Count and Row Size

• 邮箱地址长度 - Google Search

• MySQL :: MySQL 8.0 Reference Manual :: 4.2.4 Connecting to the MySQL Server Using Command Options

• MySQL Error Code 1215: “Cannot add foreign key constraint” - Percona Database Performance Blog

• sql - INNER JOIN ON vs WHERE clause - Stack Overflow

PHP

安装

• Install PHP 7 on CentOS 7 | Linuxize

语言特性

• PHP: Static Keyword - Manual

• PHP: Properties - Manual

• PHP: include - Manual

用过的变量

PHP: $_SERVER - Manual

用过的函数

• date

• count

• rename

• preg_replace

• preg_split

• str_replace

• urldecode

• array_push

• array_column

• array_merge

• join

• in_array

• substr

• strrpos

• unlink

• is_int

• implode

• explode

• trim

• sscanf

• basename

• dirname

• strtolower

遇到过的问题

• php - laravel collection to array - Stack Overflow

• datetime - How do I get the current date and time in PHP? - Stack Overflow

• php array to string - Google Search

• Convert a PHP object to an associative array - Stack Overflow

• php - How do I declare a two dimensional array? - Stack Overflow

• PHP, add a newline with implode - Stack Overflow

• How to add elements to an empty array in PHP? - Stack Overflow

• variables - What is the PHP syntax to check “is not null” or an empty string? - Stack Overflow

• PHP: Fix “Array to string conversion” error.

• php - Compile Error: Cannot use isset() on the result of an expression - Stack Overflow

• How to echo or print an array in PHP? - Stack Overflow

简历模块开发问题记录

1. TP5 where多条件查询和 ThinkPHP运算符 与 SQL运算符 对照表_liuxin_0725的专栏-CSDN博客_tp 大于: https://blog.csdn.net/liuxin_0725/article/details/79881325

2. php - Converting string to Date and DateTime - Stack Overflow: https://stackoverflow.com/questions/6238992/converting-string-to-date-and-datetime

3. php上传图片完整代码_蔡先生的专栏-CSDN博客_php上传图片代码: https://blog.csdn.net/caiandyong/article/details/48030487

4. <input type=”file”> - HTML（超文本标记语言） | MDN: https://developer.mozilla.org/zh-CN/docs/Web/HTML/Element/Input/file

5. php上传图片到远程服务器并返回图片地址到本地显示 - Corwien - SegmentFault 思否: https://segmentfault.com/a/1190000006861633

6. types - What is the benefit of zerofill in MySQL? - Stack Overflow: https://stackoverflow.com/questions/5256469/what-is-the-benefit-of-zerofill-in-mysql

7. datetime - Convert number to date in PHP and format to YYYYMMDD - Stack Overflow: https://stackoverflow.com/questions/41140301/convert-number-to-date-in-php-and-format-to-yyyymmdd/41140367

8. php - <select> dropdown default value - Stack Overflow: https://stackoverflow.com/questions/12293939/select-dropdown-default-value

9. PHP Get name of current directory - Stack Overflow: https://stackoverflow.com/questions/9997391/php-get-name-of-current-directory

10. function - In php, is 0 treated as empty? - Stack Overflow: https://stackoverflow.com/questions/2220519/in-php-is-0-treated-as-empty

11. php - How can I force an Image download in the browser? - Stack Overflow: https://stackoverflow.com/questions/11090272/how-can-i-force-an-image-download-in-the-browser

12. How to Force Download Files Using PHP - Tutorial Republic: https://www.tutorialrepublic.com/php-tutorial/php-file-download.php

13. php批量下载文件 - yikai.shao - 博客园: https://www.cnblogs.com/shaoyikai/p/3755079.html

14. PHP: 比较运算符 - Manual: https://www.php.net/manual/zh/language.operators.comparison.php

Composer

• 下载与安装：How to Install and Use PHP Composer on CentOS 7 | Linuxize

HTML

HTML4

HTML5

• HTML input type=”hidden”

• - HTML: HyperText Markup Language | MDN

• - HTML: HyperText Markup Language | MDN

相关框架

thinkcmf

重要链接：

• 序言 · ThinkCMF FAQ · 看云

• thinkcmf/demos: repository for ThinkCMF5.1 app, api, theme, plugin demos

• top-think/framework: ThinkPHP Framework

• thinkcmf/thinkcmf: ThinkCMF是一款支持Swoole的开源内容管理框架，基于ThinkPHP开发，同时支持PHP-FPM和Swoole双模式，让WEB开发更快!

遇到过的问题

• ThinkCMF a simple way to modify the login password of the background admin - Programmer Sought

• 处理问题：topthink/framework[v6.0.0, …, v6.0.8] require ext-mbstring - 知乎

相关工具

phpMyAdmin

• Creating and editing views in phpMyAdmin - 404 Tech Support

sqlite3

由于它和MySQL很像，所以也放到这里

遇到过的问题：

• change sqlite file size after “DELETE FROM table” - Stack Overflow

• SQLite table disk usage - Stack Overflow

修订记录

修订时间	修订人	版本	说明
TODO	wsxq2	1.0	初稿

---

• ← Previous Post
• Next Post →