jsfrmwkdb.php

<?php
    $conn = new mysqli('127.0.0.1','','','');
    if($conn->connect_error){
        die("Connection failed: ".$conn->connect_error);
    }

    switch($_POST['action']){
        case "refresh":
            refresh();
            break;
        case "datain":
            datain();
            break;
        default:
            echo "Error";
            break;
    }

    function refresh(){
        global $conn;
        $stmt = $conn->prepare('SELECT `vue`,`react`,`angular`, DATE_FORMAT(`date`, "%m/%e") d, `date` x FROM `web` ORDER BY x ASC
        ');
        if (!$stmt->execute()) {
            echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
        }
        $arr = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);

        $stmt->close();
        $conn->close();
        echo json_encode($arr);
    }

    function datain(){
        $content = htmlspecialchars(file_get_contents("https://www.104.com.tw/jobs/search/?keyword=vue"));
        preg_match('/－(.*?)個工作機會/', $content, $vue);
        $content = htmlspecialchars(file_get_contents("https://www.104.com.tw/jobs/search/?keyword=react"));
        preg_match('/－(.*?)個工作機會/', $content, $react);
        $content = htmlspecialchars(file_get_contents("https://www.104.com.tw/jobs/search/?keyword=angular"));
        preg_match('/－(.*?)個工作機會/', $content, $angular);

        global $conn;
        $stmt = $conn->prepare('INSERT INTO `web` 
                                        (`vue`, 
                                        `react`, 
                                        `angular`) 
                                SELECT ?,?,?
                                FROM   DUAL 
                                WHERE  NOT EXISTS (SELECT * 
                                            FROM   `web` 
                                            WHERE  CURDATE() = 
                                                    Date_format(`date`, "%Y/%m/%e")) ');

        $stmt->bind_param("iii", $vue[1], $react[1], $angular[1]);
        if (!$stmt->execute()) {
            $err = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
        }
        
        $stmt->close();
        $conn->close();

        echo json_encode(mysqli_affected_rows($conn));
    }

?>