douyong8801 2016-04-28 02:27
浏览 310
已采纳

如何将提取的Json数据导入数据库

I am trying to fetch movie information from omdbapi.So far i have this code which is extracting data from imdb using omdb api.But i want import that data to my database.how do i accomplish that.

my code look like this

    <form>
<input type="text"  id="tst"/>
<input type="button" value="search"  id="btn"/>
</form>
<table class="table table-hover" id="imdb">
        <thead>
            <tr>
                <th>Poster</th>
                <th>Title</th>
                <th>Year</th>
                <th>Rated</th>
                <th>Runtime</th>
                <th>Genre</th>
                <th>Director</th>
                <th>Actors</th>
                <th>Plot</th>
            </tr>
        </thead>
        <tbody></tbody>
    </table>

This is jquery code i am using to fetch the movie information

$(document).ready(function () {
          $('#btn').click(function(){
              var imdbid=$('#tst').val();
               var url = "http://www.omdbapi.com/?i="+imdbid+"&plot=short&r=json"
        $.ajax({
        url:url,
        dataType:'json',
        success:function (json) {
            var tr;
        tr = $('<tr/>');
        tr.append("<td><img src=" + json.Poster + " width='200' height='297'></td>");
        tr.append("<td>" + json.Title + "</td>");
        tr.append("<td>" + json.Year + "</td>");
        tr.append("<td>" + json.Rated + "</td>");
        tr.append("<td>" + json.Runtime + "</td>");
        tr.append("<td>" + json.Genre + "</td>");
        tr.append("<td>" + json.Director + "</td>");
        tr.append("<td>" + json.Actors + "</td>");
        tr.append("<td>" + json.Plot + "</td>");
        $('#imdb').append(tr);
        }
        })
              })
    });
  • 写回答

1条回答 默认 最新

  • duanlongnao0028 2016-04-29 04:45
    关注

    You can create a json object from your api response(in same function where you are creating html).

     JSONData = JSON.stringify({
                "Title": Title,
                "Year": Year,
                "Rated" : Rated,
                ...........so on
    
            });
    postDataToserver(JSONData);
    

    And you can define your function to post data like -

    function postDataToserver(JSONData)
        $.ajax({
            url: "your_server_script_path",
            type:"POST",
            data:JSONData,
            dataType: "json",
            contentType: "application/json; charset=utf-8",
            success: function(response) {
            error: function (error) {
    
            }
        });
    

    If you want to send in simple post format not as JSON object then you don't need to use JSON.stringify and similarly in function remove contentype information. Hope this will help you.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 关于#java#的问题,请各位专家解答!
  • ¥15 maccms影视模板 制作影视网站失败 求
  • ¥15 stm32按键设置闹钟数进退位不正常
  • ¥15 自己写的测试驱动程序无法启动
  • ¥15 三电平逆变器中点电位平衡问题
  • ¥20 这怎么写啊 java课设
  • ¥15 用C语言完成一个复杂的游戏
  • ¥15 如何批量更改很多个文件夹里的文件名中包含文件夹名?
  • ¥50 MTK手机模拟HID鼠标出现卡顿
  • ¥20 求下下面这个数据结构代码