Rest api php

<?php
$con = mysqli_connect("Localhost", "root", "", "rest_api");
if (mysqli_connect_errno())
{
    echo "Connection Fail" . mysqli_connect_error();
}
header('Content-Type:application/json');
if (isset($_GET['token']))
{
    $token = mysqli_real_escape_string($con, $_GET['token']);
    $checkTokenRes = mysqli_query($con, "select * from api_token where token='$token'");
    if (mysqli_num_rows($checkTokenRes) > 0)
    {
        $checkTokenRow = mysqli_fetch_assoc($checkTokenRes);
        if ($checkTokenRow['status'] == 1)
        {
            if ($checkTokenRow['hit_limit'] <= $checkTokenRow['hit_count'])
            {
                $status = 'true';
                $data = "Api hit limit exceed";
                $code = '6';
            }
            else
            {
                mysqli_query($con, "UPDATE `api_token` SET `hit_count`= hit_count+1 WHERE `token` = '$token'");
                $sql = "select * from collected_data ";
                if (isset($_GET['id']) && $_GET['id'] > 0)
                {
                    $id = mysqli_real_escape_string($con, $_GET['id']);
                    $sql .= " where id='$id'";
                }
                $sqlRes = mysqli_query($con, $sql);
                if (mysqli_num_rows($sqlRes) > 0)
                {
                    $data = [];
                    while ($row = mysqli_fetch_assoc($sqlRes))
                    {
                        $data[] = $row;
                    }
                    $status = 'true';
                    $code = '5';
                }
                else
                {
                    $status = 'true';
                    $data = "Data not found";
                    $code = '4';
                }

            }

        }
        else
        {
            $status = 'true';
            $data = "API token deactivated";
            $code = '3';
        }
    }
    else
    {
        $status = 'true';
        $data = "Please provide valid API token";
        $code = '2';
    }

}
else
{
    $status = 'true';
    $data = "Please provide API token";
    $code = '1';
}
echo json_encode(["status" => $status, "data" => $data, "code" => $code]);
?>

Similar codes

0 vote246 views1 answer
Set character set utf8 in pdo php
PHP
2 votes276 views2 answers
Wordpress functions add to header
PHP Wordpress
14 votes255 views3 answers
Extract in php
PHP
0 vote290 views1 answer
Laravel has many limit
PHP Laravel
1 vote216 views3 answers
Fetchall php
PHP
1 vote291 views1 answer
How handle the number with k in laravel balde
PHP Laravel
0 vote236 views1 answer
Docker php-fpm-apline add imagick
PHP
0 vote299 views1 answer
Laravel migration type to store html
PHP Laravel
0 vote251 views2 answers
Notice: Trying to get property 'NAME' of non-object in
PHP
0 vote270 views1 answer
Get stock product woocommerce by id
PHP