php – Adamhuan's Data Center – 【逻辑驱动数据】

Linux + Nginx + PHP: File not found

如题所示，在使用Linux上的Nginx+PHP的架构的时候，访问服务器端的PHP页面，前端返回了错误【file not found】；
具体情况如下：

当前：PHP与Nginx服务是运行的：

服务器上的页面文件也是存在的：

但是，前端访问页面却有问题：

其实，出现[……]

发表于： 2019年11月13日 2019年11月13日
作者： Adamhuan
分类： Nginx, PHP
标签： -, -h, -p, ，, :, ?, ", /, $, 10, 1024, 11, 12, 127.0.0.1, 18, 2, 2019, 21, 22, 26, 3, 30, 4, 5, 50, 6, 7, 8, 80, 9, Apache, auto, b, cal, cat, CG, client, cp, error, file not found, GI, grep, group, HP, http, https, if, index, IP, Linux, list, listen, load, master, net, netstat, nginx, nobody, php, pid, pre, proc, process, prototype, ps, rap, RAW, root, s, SC, src, ST, stat, theme, tr, upload, 使用, 前端, 加载, 当前, 得到, 情, 我, 改, 文件, 新, 服务, 服务器, 架构, 查, 查看, 解决, 访问, 运行, 配置, 配置文件, 锁, 错, 错误, 问题, 页面, 默认
发表评论: Linux + Nginx + PHP: File not found

PHP：随机呈现【一句话】

在做技术前，包括现在，自己都是一个很喜欢文字的人。

很多时候，在【电影 / 小说 / 动漫 / 游戏 / 歌曲 / …etc】中，我们都能邂逅一些让我们感到振奋或者回响的话语或段落。

我希望记录它们；
因此，我在自己的这个网站（d-prototype.com）中开设了一个单独的页面，记[……]

PHP error：Warning: “continue” targeting switch is equivalent to “break”. Did you mean to use “continue 2”? in D:\xampp\htdocs\php_project\itop\web\application\cmdbabstract.class.inc.php on line 3291

错误发生在以下环境：
1. PHP 7.3
2. 安装iTop，进度40%的时候出错。

具体如下：

错误详情如下：
Warning: “continue” targeting switch is equivalent to “break”. Did you mean to u[……]

Warning: mysqli::real_connect(): php_network_getaddresses: getaddrinfo failed

在安装iTOP的时候你可能会遇到如题所示的警告，具体如下：

解法：
在上面设置MySQL服务器地址的时候，将【localhost】，改成【127.0.0.1】

可以看到，已经没有警告了。
————————————————————
Done。[……]

发表于： 2019年2月15日 2019年2月15日
作者： Adamhuan
分类：善用佳软
标签： 127.0.0.1, DNS, error, iTop, localhost, MySQL, php, warning, Warning: mysqli::real_connect(): php_network_getaddresses: getaddrinfo failed, 善用佳软, 警告, 错误
发表评论: Warning: mysqli::real_connect(): php_network_getaddresses: getaddrinfo failed

DataTables：从MySQL获取数据

前提：
DataTables的环境的搭建不在描述，前面的文档中都已经写了。

本文主要有以下部分：
1. PHP代码的编写：两个PHP文件
2. 数据库的数据表的准备：MySQL

先看看数据库的部分：

[root@itop ~]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 8.0.13-3 Percona Server (GPL), Release 3, Revision a920dd6

Copyright (c) 2009-2018 Percona LLC and/or its affiliates
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
mysql> select c.id,c.name as contact_name,o.name as org_name,c.email,c.phone,c.notify from itop_data.contact c,itop_data.organization o where c.org_id = o.id order by c.id;
+----+------------------------------+-----------------------+----------------------+-----------------+--------+
| id | contact_name                 | org_name              | email                | phone           | notify |
+----+------------------------------+-----------------------+----------------------+-----------------+--------+
|  1 | My last name                 | My Company/Department | my.email@foo.org     | +00 000 000 000 | yes    |
|  2 | Picasso                      | Demo                  | pablo@demo.com       |                 | yes    |
|  3 | Dali                         | Demo                  | dali@demo.com        |                 | yes    |
|  4 | Rousseau                     | IT Department         | rousseau@it.com      |                 | yes    |
|  5 | Delacroix                    | Demo                  | delacroix@demo.com   |                 | yes    |
|  6 | Monet                        | Demo                  | monet@demo.com       |                 | yes    |
|  7 | Hugo                         | IT Department         | hugo@it.com          |                 | yes    |
|  8 | Kahlo                        | Demo                  | frida.kahlo@demo.com |                 | yes    |
|  9 | Verne                        | IT Department         | vernes@it.com        |                 | yes    |
| 10 | Flaubert                     | IT Department         | flaubert@it.com      |                 | yes    |
| 11 | Cocteau                      | IT Department         | cocteau@it.com       |                 | yes    |
| 12 | Gavalda                      | IT Department         | gavalda@it.com       |                 | yes    |
| 13 | Duras                        | IT Department         | duras@it.com         |                 | yes    |
| 14 | Sartre                       | IT Department         | sartre@it.com        |                 | yes    |
| 15 | Christie                     | Demo                  | christie@demo.com    |                 | yes    |
| 16 | Vian                         | IT Department         | vian@it.com          |                 | yes    |
| 17 | Parker                       | IT Department         | parker@it.com        |                 | yes    |
| 18 | De Luca                      | Demo                  | deluca@demo.com      |                 | yes    |
| 19 | Kubrick                      | IT Department         | kubrick@it.com       |                 | yes    |
| 20 | King                         | IT Department         | king@it.com          |                 | yes    |
| 21 | de Beauvoir                  | IT Department         | simone@it.com        |                 | yes    |
| 22 | Hardware support             | IT Department         | hw@test.com          |                 | yes    |
| 23 | Helpdesk                     | IT Department         |                      |                 | yes    |
| 24 | Network support              | IT Department         | nw@test.com          |                 | yes    |
| 25 | System & application support | IT Department         |                      |                 | yes    |
| 26 | 王宝强                       | IT Department         | wangbaoqiang@me.com  |                 | yes    |
+----+------------------------------+-----------------------+----------------------+-----------------+--------+
26 rows in set (0.01 sec)

mysql>

[root@itop ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 62

Server version: 8.0.13-3 Percona Server (GPL), Release 3, Revision a920dd6

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> select c.id,c.name as contact_name,o.name as org_name,c.email,c.phone,c.notify from itop_data.contact c,itop_data.organization o where c.org_id = o.id order by c.id;

+----+------------------------------+-----------------------+----------------------+-----------------+--------+

+----+------------------------------+-----------------------+----------------------+-----------------+--------+

| 1 | My last name | My Company/Department | my.email@foo.org | +00 000 000 000 | yes |

| 23 | Helpdesk | IT Department | | | yes |

| 25 | System & application support | IT Department | | | yes |

| 26 | 王宝强 | IT Department | wangbaoqiang@me.com | | yes |

+----+------------------------------+-----------------------+----------------------+-----------------+--------+

26 rows in set (0.01 sec)

mysql>

为了验证中[……]

发表于： 2019年2月14日 2019年2月14日
作者： Adamhuan
分类： MySQL
标签： DataTables, MySQL, php, 善用佳软, 数据库, 数据源, 李一桐
发表评论: DataTables：从MySQL获取数据