PHP MYSQLI_NUM_rows Examples

Example #1

File: sqf.php Project: HanYangERICAjucy/Jucy

function voteRESULT($length)
{
    $con = mysqli_connect("localhost", "u242089643_jucy", "gksdid1!");
    if (!$con) {
        die('연결 안됨: ' . mysqli_error());
    } else {
        mysqli_select_db($con, "u242089643_tdc");
    }
    $resultset = mysqli_query($con, "select * from diet_war where vote_count != 0 order by vote_count desc limit " . $length);
    if (MYSQLI_NUM_rows($resultset) < 1) {
        mysqli_close($con);
        return array(array("empty"));
    } else {
        $result = array();
        $row = array();
        while ($row = mysqli_fetch_array($resultset, MYSQLI_NUM)) {
            array_push($result, $row);
        }
        mysqli_close($con);
        return $result;
    }
}

Example #2

File: sqftest1.php Project: KeoSeong/project

function dietwar_status()
{
    $con = mysqli_connect("202.150.213.206", "u242089643_jucy", "gksdid1!");
    if (!$con) {
        die('연결 안됨: ' . mysqli_error());
    } else {
        mysqli_select_db($con, "u242089643_tdc");
    }
    $resultset = mysqli_query($con, "select vote from user_info where id = 'admin'");
    if (MYSQLI_NUM_rows($resultset) < 1) {
        mysqli_close($con);
        return array(array("empty"));
    } else {
        $result = array();
        $row = array();
        while ($row = mysqli_fetch_array($resultset, MYSQLI_NUM)) {
            array_push($result, $row);
        }
        mysqli_close($con);
        return $result;
    }
}