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

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[……]

发表于： 2019年2月15日 2019年2月15日
作者： Adamhuan
分类： PHP
标签： 7.3, break, continue, continue 2, error, Install, iTop, php, switch, 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, 错误
发表评论: 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

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获取数据

iTop：配置管理 – 联系人，在MySQL数据库中对应的表

在ITOP中，配置管理里面有个模块是联系人。
如下：

这部分的内容其实是存放在后端的数据库中的。

看看我们的数据库的配置：

[root@itop production]# pwd                 
/www/wwwroot/itop/conf/production
[root@itop production]# 
[root@itop production]# ls -ltr
total 12
-r--r--r-- 1 www www 9479 Feb 12 15:17 config-itop.php
[root@itop production]# 
[root@itop production]# cat config-itop.php | grep "db_"
        'db_host' => '192.168.174.128',
        'db_name' => 'itop_data',
        'db_pwd' => '你的数据库密码',
        'db_subname' => '',
        'db_user' => 'itop',
[root@itop production]#

[root@itop production]# pwd

/www/wwwroot/itop/conf/production

[root@itop production]#

[root@itop production]# ls -ltr

total 12

-r--r--r-- 1 www www 9479 Feb 12 15:17 config-itop.php

[root@itop production]#

[root@itop production]# cat config-itop.php | grep "db_"

'db_host' => '192.168.174.128',

'db_name' => 'itop_data',

'db_pwd' => '你的数据库密码',

'db_subname' => '',

'db_user' => 'itop',

[root@itop production]#

然后去数据库中查看：
[crayon-5ce59b4a53f1d82120049[……]

发表于： 2019年2月13日 2019年2月13日
作者： Adamhuan
分类：善用佳软
标签： config-itop.php, database, db, iTop, Linux, MySQL, php, view_Contact, 善用佳软, 数据库, 联系人, 配置管理
发表评论: iTop：配置管理 – 联系人，在MySQL数据库中对应的表

PHP：PDO访问MySQL的时候，返回的json数据中文乱码

问题如题所示，具体如下：

解决该问题，需要在PDO请求数据库连接的时候，就把字符集的设定声明进去。

如下修改代码就能解决中文乱码问题：

<?php

//字符集编码
//header("content-Type: text/html; charset=utf-8");

//变量声明
$servername = "localhost";
$username = "adamhuan";
$password = "***********";

//字符集处理：json
function encode_json($str) {
  return urldecode(json_encode(url_encode($str)));
}

function url_encode($str) {
  if(is_array($str)) {
    foreach($str as $key=>$value) {
      $str[urlencode($key)] = url_encode($value);
    }
  } else {
    $str = urlencode($str);
  }

  return $str;
}

//MySQLi extention
//-------------------------------
// 创建连接
//面向对象
//$conn = new mysqli($servername, $username, $password);

//面向过程
//$conn = mysqli_connect($servername, $username, $password);

// 检测连接
//if ($conn->connect_error) {
//    die("连接失败: " . $conn->connect_error);
//}
//echo "连接成功";

//PDO
//----------------------------------------
try {
    $conn = new PDO("mysql:host=$servername;", $username, $password,array(PDO::MYSQL_ATTR_INIT_COMMAND => "set names utf8"));
    //echo "连接成功<br/>";
    //echo "===================<br/>";
    //echo "";
}
catch(PDOException $e)
{
    echo "连接失败<br/>";
    echo "===================<br/>";
    echo $e->getMessage();
    echo "<br/>";
    echo "";
}

//for DataTables Coding

//SQL语句
$sql = "select * from gds_its_customer_data.people";

//SQL语句执行
$do = $conn->prepare($sql);
$do->execute();

//SQL语句，获得结果集
$row = $do->fetchAll(PDO::FETCH_ASSOC);

//--> json encoding
//$row_json_encoding = json_encode($row,JSON_UNESCAPED_UNICODE);

//输出
//echo $row;

//echo _json($row);
//echo $row_json_encoding;

echo encode_json($row);

//关闭连接
//MYSQLI
//面向对象
//$conn->close();

//面向过程
//mysqli_close($conn);

//PDO
$conn = null;

?>

<?php

//字符集编码

//header("content-Type: text/html; charset=utf-8");

//变量声明

$servername = "localhost";

$username = "adamhuan";

$password = "***********";

//字符集处理：json

function encode_json($str) {

return urldecode(json_encode(url_encode($str)));

}

function url_encode($str) {

if(is_array($str)) {

foreach($str as $key=>$value) {

$str[urlencode($key)] = url_encode($value);

}

} else {

$str = urlencode($str);

}

return $str;

}

//MySQLi extention

//-------------------------------

// 创建连接

//面向对象

//$conn = new mysqli($servername, $username, $password);

//面向过程

//$conn = mysqli_connect($servername, $username, $password);

// 检测连接

//if ($conn->connect_error) {

// die("连接失败: " . $conn->connect_error);

//}

//echo "连接成功";

//PDO

//----------------------------------------

try {

$conn = new PDO("mysql:host=$servername;", $username, $password,array(PDO::MYSQL_ATTR_INIT_COMMAND => "set names utf8"));

//echo "连接成功 ";

//echo "=================== ";

//echo "";

}

catch(PDOException $e)

{

echo "连接失败 ";

echo "=================== ";

echo $e->getMessage();

echo " ";

echo "";

}

//for DataTables Coding

//SQL语句

$sql = "select * from gds_its_customer_data.people";

//SQL语句执行

$do = $conn->prepare($sql);

$do->execute();

//SQL语句，获得结果集

$row = $do->fetchAll(PDO::FETCH_ASSOC);

//--> json encoding

//$row_json_encoding = json_encode($row,JSON_UNESCAPED_UNICODE);

//输出

//echo $row;

//echo _json($row);

//echo $row_json_encoding;

echo encode_json($row);

//关闭连接

//MYSQLI

//面向对象

//$conn->close();

//面向过程

//mysqli_close($conn);

//PDO

$conn = null;

注意，上面申请数据库连接的时候：
【array(PDO::MYSQL_[……]

发表于： 2019年1月22日 2019年1月22日
作者： Adamhuan
分类： MySQL, PHP
标签： error, exception, JSON, MySQL, PDO, php, 中文, 乱码, 异常, 错误
发表评论: PHP：PDO访问MySQL的时候，返回的json数据中文乱码