dozc58418381 2018-10-11 22:25
浏览 36

Json php将数组链接url插入mysql

I can't insert from json -> php -> mysql data

MYSQL datatype: varchar 700 length

What is the problem?

All other data inserts correctly but this I can't add I think because it's a link. It's a problem with $thumbnails = $row['snippet']['thumbnails']['default']['url'];

Json:

"url": "https://yt3.ggpht.com/a-/AN66SAylfIkW5vNxzRmqHzN9GJPJi0CVHOsadKRMPA=s88-mo-c-c0xffffffff-rj-k-no",

Error:

Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ://yt3.ggpht.com/a-/AN66SAylfIkW5vNxzRmqHzN9GJPJi0CVHOsadKRMPA=s88-mo-c-c0xfffff at line 1

code:

$url = 'https://www.googleapis.com/youtube/v3/channels?id=' .implode(',', $allchannels).'&part=snippet%2Cstatistics&key=KEY';

    $content = file_get_contents($url);
    $json = json_decode($content, true);


    foreach($json['items'] as $row)
    {
        $channelid = $row['id'];
        $title = $row['snippet']['title'];
        $description = $row['snippet']['description'];
        $viewCount = $row['statistics']['viewCount'];
        $subscriberCount = $row['statistics']['subscriberCount'];
        $thumbnails = $row['snippet']['thumbnails']['default']['url'];
        $sql = "INSERT INTO users(channelid, title, thumbnails, description, viewCount, subscriberCount) VALUES('$channelid', '$title', $thumbnails, '$description', '$viewCount', '$subscriberCount')  
        ON DUPLICATE KEY UPDATE channelid='$channelid', title='$title', thumbnails='$thumbnails', description='$description', viewCount='$viewCount', subscriberCount='$subscriberCount';
        ";
        mysqli_query($conn, "SET NAMES utf8");
        if(!mysqli_query($conn,$sql))
        {
            die('Error : ' . mysqli_error($conn));
        }
    }
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 基于卷积神经网络的声纹识别
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
    • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
    • ¥15 CSAPPattacklab
    • ¥15 一直显示正在等待HID—ISP
    • ¥15 Python turtle 画图
    • ¥15 stm32开发clion时遇到的编译问题