douyi6168 2019-08-18 15:16
浏览 35

“如何使用user_id上传每个会话的图像”[复制]

"I want to images with user_id using session so user can display each picture which are display by them"

"I tried to $_SESSION[user_id] but it says Undefined index: user_id in E:\xampp\htdocs\photo\upload.php on line 195 Cannot add or update a child row: a foreign key constraint fails (photo.user_images, CONSTRAINT FK_user FOREIGN KEY (user_id) REFERENCES user (id))"

<?php
session_start();
if(isset($_SESSION['username']))

{
?>
<?php
 if(isset($_POST['btn']))
 {

 require_once("connection.php");


 $r = rand(111,999);

    $imgUrl = "images/".$r."_".$_FILES['img']['name'];
 move_uploaded_file($_FILES['img']['tmp_name'],$imgUrl);

 $query = "insert into user_images(`imagename`,`category`,`user_id`,`image`) values('".$_POST['imgname']."','".$_POST['category']."','".$_SESSION['user_id']."','".$imgUrl."')";

$result =  mysqli_query($con,$query) or die(mysqli_error($con));
if($result)
{
    echo '<p class="text-success">New Pic Information inserted';
}
 }

 ?>

"Cannot add or update a child row: a foreign key constraint fails (photo.user_images, CONSTRAINT FK_user FOREIGN KEY (user_id) REFERENCES user (id))"

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Mac系统vs code使用phpstudy如何配置debug来调试php
    • ¥15 目前主流的音乐软件,像网易云音乐,QQ音乐他们的前端和后台部分是用的什么技术实现的?求解!
    • ¥60 pb数据库修改与连接
    • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
    • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
    • ¥20 神经网络Sequential name=sequential, built=False
    • ¥16 Qphython 用xlrd读取excel报错
    • ¥15 单片机学习顺序问题!!
    • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
    • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)