And how to withdraw with any conditions or restrictions?

Closed due to the fact that the issue is too general for the participants Kirill Korushkin , Vanya Avchyan , Alex , Kromster , AK ♦ 13 Mar '18 at 7:41 .

Please correct the question so that it describes the specific problem with sufficient detail to determine the appropriate answer. Do not ask a few questions at once. See “How to ask a good question?” For clarification. If the question can be reformulated according to the rules set out in the certificate , edit it .

    1 answer 1

    Good evening. The request may look like this

    $results = $mysqli->query('SELECT COUNT(`username`) FROM `users`'); $rows = $results->fetch_array(); print_r($rows); $mysqli->close();

    What restrictions do you want to write? You can add a selection condition to the query using where

     'SELECT COUNT( * ) AS `user_count` FROM `user` WHERE `status` = 1'
    • Kind. Yes, something like this 'SELECT COUNT (*) AS user_count FROM user WHERE status = 1' then just echo $ user_count; ? - Retarded Developer