MYSQL插入提交按钮PHP [英] MYSQL Insert Submit Button PHP

问题描述

我正在生成图像列表，并希望根据是否在图像旁边按下了提交按钮来插入特定图像.

I am generating a list of images and looking to insert a specific image based on wether or not a submit button has been pressed alongside my image.

这是我的代码，用于生成图像列表.图片旁边是提交按钮，例如计数和其他数据:

Here is my code to generate a list of images. Alongside the images is the submit button, like count and other data:

// Display results
foreach ($media->data as $data) {
echo "<a href=\"{$data->link}\"</a>";
echo "<h4>Photo by: {$data->user->username}</h6>";
echo $pictureImage = "<img src=\"{$data->images->thumbnail->url}\">";
echo "<h5>Like Count for Photo: {$data->likes->count}</h5>";
echo "<form>";
echo '<input type="submit" onClick=post()>';
echo "</form>";
}

然后我尝试将图片插入数据库中

I am then trying to insert that picture into my database:

InstagramImages(DB)-图像(字段)

function post() {

        $hostname = "redacted";
        $username = "redacted";
        $dbname = "redacted";

        //These variable values need to be changed by you before deploying
        $password = "redacted";
        $usertable = "InstagramImages";

        //Connecting to your database
        mysql_connect($hostname, $username, $password) OR DIE ("Unable to 
        connect to database! Please try again later.");
        mysql_select_db($dbname);

        $sql="INSERT INTO $usertable (image) VALUES ('$pictureImage')";

        if (!mysqli_query($con,$sql)) {
            die('Error: ' . mysqli_error($con));
        }

        echo "1 record added";

        mysqli_close($con);
}

任何帮助将不胜感激.我需要帮助来为php变量$ pictureImage创建正确的INSERT查询.

Any help would be appreciated. I need help creating the right INSERT query for the php variable $pictureImage.

推荐答案

echo '<input type="submit" onClick=post()>';

onClick = post()-这是一个javascript事件，仅用于javascript，但您已使用php代码编写了post()函数，因此无法将其插入到tatabase表中.

onClick=post() - This is a javascript event used only for javascript but the post() function you have written in php code so it cannot insert into your tatabase table.

这篇关于MYSQL插入提交按钮PHP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！