时间戳

首页 > 解决方案 > 将mysql数据获取到javascript变量中

javascript - 将mysql数据获取到javascript变量中

问题描述

变种事件 = [
        {"id":"1","title":"pending","start":"","end":"2020-04-27 10:25:34","url":"","allDay ":"1"},
        {"id":"2","title":"22","start":"2013-12-15 10:25:47","end":"2013-12-16 10:25:39" ,"url":"","allDay":"1"},
        {"id":"3","title":"33","start":"2013-12-26 10:25:50","end":"2013-12-27 10:25:42" ,"url":"","allDay":"false"},
        {"id":"4","title":"2-12","start":"2020-04-20 10:26:28","end":"2020-04-20 10:26: 28","url":"","allDay":"false"},
        {"id":"6","title":"test nay","start":"2013-12-09 00:00:00","end":"2013-12-11 00:00:00 ","url":"event","allDay":"false"}
        ]

我想将我的数据库中的数据检索到这个 JavaScript 变量中，请任何人简单地解释一下如何做到这一点？

标签： javascripthtmlcss

解决方案

您必须使用任何后端技术（Java/Python/php/Node JS 等）将 json 数组保存到 DB。这是因为 javascript 不能直接处理或连接到数据库。

从 javascript 方面，您可以使用 jQuery ajax 将数据发送到您的后端 api，如下所示。

$.ajax({

    type: "post",
    url: "",            //your backend API endpoint
    data: {data: events},

    success: function(responseData){

        //If backend api runs successfully, control comes to this method with responseData as return from api
    },

    error: function(responseData){

        // If api call does not run properly, control comes in this method.
    }
});

您的后端 API 获取数据，连接到数据库并运行 SQL 来存储数据。所以基于后端技术，你必须开发代码。

推荐阅读