duanchen7401 2019-03-31 08:35
浏览 130
已采纳

无法在php中将json数据插入mysql数据库

I have a json format data without key value pair. when i insert data my table only the 1st data is inserted(of the array). how i insert the all data into my databse table?

<?php

$mysqli = new mysqli('localhost','root','','user');
$my_json_data = file_get_contents('./jason_data.txt');
$my_data = json_decode($my_json_data,true);


foreach($my_data as $data){

    $sql = "INSERT INTO demo_table (data) VALUES ('$data');";
    $mysqli->query($sql);
}

echo "done...";

?>

my database table name is 'demo_table' and json data fromat like this

["hello-world","sample-page","privacy-policy","2-revision-v1","the-banner-title"]

which is a .txt format in the same directory of my workspace

my table schema is like this

CREATE TABLE `demo_table` (
 `id` int(5) NOT NULL,
 `data` varchar(255) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
  • 写回答

1条回答 默认 最新

  • doupinge9055 2019-03-31 09:02
    关注

    Seems you have not a proper primary key.

    Try create in the demo_table a proper primary key based on auto increment column

    based on your schema add autoincrement

    CREATE TABLE `demo_table` (
      `id` int(5) NOT NULL  AUTO_INCREMENT,
      `data` varchar(255) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    

    in this each row inserted have a automatic different primary key .. otherwise the first insertion create an id = 0 and the second try to do the same ..but 0 already exist

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

报告相同问题?

悬赏问题

  • ¥15 Bibtex4Word 引用中文文献
  • ¥20 用opencv c/c++ 转换成灰度图,然后做一下直方图均衡,输出mp4文件
  • ¥20 matlab中的双层数值积分
  • ¥50 服务器打印水晶报表问题
  • ¥30 gradle环境下javafx项目如何使用druid连接池
  • ¥15 服务器打印水晶报表问题
  • ¥18 深度学习tensorflow1,ssdv1,coco数据集训练一个模型
  • ¥100 关于注册表摄像头和麦克风的问题
  • ¥30 代码本地运行正常,但是TOMCAT部署时闪退
  • ¥15 关于#python#的问题