我在排序到表主要ID值时遇到问题,该值从phpmyadmin自动递增,并将它们从最近到最新(从最大到最小)添加到表中,我可以获得一些帮助吗?我正在使用json将php转换为JavaScript。此代码仅显示从最新到最新的表格。

$app->get('/proyects/all', function () use($servername, $dbname, $dbuser, $dbpassword)
{

$response = array();

try
{
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $dbuser, $dbpassword);

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $conn->prepare("SELECT * FROM proyectos");

    if ($stmt->execute())    {
        $result = $stmt->fetchAll();
    }


    $conn = null;

    if(!empty($result))
    {
        $response['proyects'] = array();
        foreach ($result as $key => $value)
        {
            $response['proyects'][$key] = $value;

        }
        $response['success'] = true;

        echo json_encode($response);
        return;
    }
    else
    {
        $response['success'] = false;
        $response['message'] = "Proyects not found";

        echo json_encode($response);
        return;
    }

}
catch(PDOException $e)
{
    $response['success'] = false;
    $response['message'] = $e->getMessage();

    echo json_encode($response);
    return;
}
});

<script type="text/javascript">
     $(document).ready(function()
     {
        $.ajax(
        {
            url: path+'/proyects/all',
            type: 'get',
            dataType: "json",
            success: function(json)
            {
                console.log(json);

                if (json.success)
                {
                    $.each(json.proyects, function( index, value ) {

                      $('#proyecs').append('<tr><td>'+value.idproyect+'</td><td>'+value.pdescription+'</td><td>'+value.presponsible+'</td><td>'+value.pdateini+'</td><td>'+value.pdatefin+'</td><td>'+value.pstatus+'&#37</td><td><button type="button" class="btn btn-default">Details</button></td></tr>');
                    });
                }
                else
                {
                    Materialize.toast(json.message, 5000, 'red accent-4');
                }
            },
            error : function(e, settings, exception)
            {
                Materialize.toast("Oops! an error has ocurred", 5000, 'red accent-4');
            }
        });
    });
</script>


@sesonrario @rex对不起,忘记了密码

最佳答案

可以

    $stmt = $conn->prepare("SELECT * FROM proyectos order by id");


解决你的问题?

关于javascript - PHP,phpmyadmin,html,javascript,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/44174550/

10-11 20:43
查看更多