PHP曹师傅的类和函数

# PHP曹师傅的类和函数

## 目录

[TOC]

## MYSQL类

### sqlLoading连接mysql

```php
<?php
class sqlLoading
{
    private $servername = "localhost";
    private $username = "ipld";
    private $password = "LYWeGdSJKEtWJCjR";
    private $database = "ipld";

/**
     * @return string
     */
    public function getServername()
    {
        return $this->servername;
    }

/**
     * @return string
     */
    public function getUsername()
    {
        return $this->username;
    }

/**
     * @return string
     */
    public function getPassword()
    {
        return $this->password;
    }

/**
     * @return string
     */
    public function getDatabase()
    {
        return $this->database;
    }

#连接sql
    public function loadingSql(){
        #实例化sql参数
        $sqlLoading = new sqlLoading();
        #建立连接
        $conn = mysqli_connect($sqlLoading->getServername(), $sqlLoading->getUsername(), $sqlLoading->getPassword(), $sqlLoading->getDatabase());
        return $conn;
    }
}
```

### 插入一条数据

```php
$servername = "localhost";
$username = "cs_caozhexxgweb_";
$password = "CCakR25RsWCYABjY";
$database = "cs_caozhexxgweb_";
$name = $_POST["name"];
$iphon = $_POST["iphon"];
$del = $_POST["del"];

echo "添加:".$name.$iphon;
echo "<br >";
// 创建连接
$conn = mysqli_connect($servername, $username, $password,$database);

if ($name != null && $iphon != null){
    $sql = "INSERT INTO `info` (name,iphon) VALUES ('$name', '$iphon')";
    if (mysqli_query($conn,$sql)){
        echo "<br >ok";
    }else{
        echo "no";
    }
}
```

### 删除一条数据

```php
if ($del=="del"){
    $sql = "DELETE FROM `info` LIMIT 1;";
    if (mysqli_query($conn,$sql)){
        echo "ok";
    }else{
        echo "no";
    }
}
```

### 查询一些数据并且列出

```php
// 创建连接
$conn = mysqli_connect($servername, $username, $password,$database);

$comd = "select * from info";
$sql = mysqli_query($conn,$comd);

echo "<table>";
while ($row = mysqli_fetch_object($sql)){
    echo $row->name."------".$row->iphon;
    echo "<br >";
}
echo "</table>";
```

### 更新一列属性

```php
$sql = "UPDATE `ipld`.`host` SET `survival` = '$filg',`detection` = '$time',`survivaltime` = '$time' WHERE `host`.`ip` = '$ip';";
mysqli_query($conn, $sql);
```

## DINGDING类

```php
<?php
/**钉钉机器人API**/

class dingDing
{
    function request_by_curl($remote_server, $post_string)
    {
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $remote_server);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5);
        curl_setopt($ch, CURLOPT_HTTPHEADER,
            ['Content-Type: application/json;charset=utf-8']);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $post_string);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        // 线下环境不用开启curl证书验证, 未调通情况可尝试添加该代码
        // curl_setopt ($ch, CURLOPT_SSL_VERIFYHOST, 0);
        // curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, 0);
        $data = curl_exec($ch);
        curl_close($ch);

return $data;
    }
    function run($message)
    {
        // 机器人hook地址
        $webhook = "https://oapi.dingtalk.com/robot/send?access_token=2a7795251c10893355e1249896e739049ffb973b7a959c90cf92e6ee0ac06fd3";
        // @给谁的手机号
        $atMobile = ['13736871933'];
        $isAtAll = false;
        $data = [
            'msgtype' => 'text',
            'text' =>
                ['content' => $message],
            'at' => [
                'atMobiles' => $atMobile,
                'isAtAll' => $isAtAll,
            ],

];
        $data_string = json_encode($data);

$result = $this->request_by_curl($webhook, $data_string);
        echo $result;
    }
}
```