痞客興的部落格

<?php
        $servername = "localhost";
        $username = "user";
        $password = "pass";
        $dbname = "dbname";
        // Create connection
        $conn = new mysqli($servername, $username, $password, $dbname);
        // Check connection
        if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
        }

        $sql = "SELECT field FROM table where field = '1'";
        $result = $conn->query($sql);
        if($result->num_rows > 0){
                echo "0";
        }else{
                echo "1";
        }
?>