StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POData is not being inserted into second table (MYSQLi)
text
Body
copied!<p>I am using the code below that uploads a file and inserts data into the "Image" table using mysqli:</p> <pre><code><?php session_start(); $username="xxx"; $password="xxx"; $database="mobile_app"; $mysqli = new mysqli("localhost", $username, $password, $database); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); die(); } $result = 0; //UPLOAD IMAGE FILE move_uploaded_file($_FILES["fileImage"]["tmp_name"], "ImageFiles/" . $_FILES["fileImage"]["name"]); $result = 1; //INSERT INTO IMAGE DATABASE TABLE $imagesql = "INSERT INTO Image (ImageFile) VALUES (?)"; if (!$insert = $mysqli->prepare($imagesql)) { // Handle errors with prepare operation here } //Dont pass data directly to bind_param store it in a variable $insert->bind_param("s", $img); //Assign the variable $img = 'ImageFiles/' . $_FILES['fileImage']['name']; $insert->execute(); //RETRIEVE IMAGEID FROM IMAGE TABLE $lastID = $mysqli->insert_id; //INSERT INTO IMAGE_QUESTION DATABASE TABLE $imagequestionsql = "INSERT INTO Image_Question (ImageId, SessionId, QuestionId) VALUES (?, ?, ?)"; if (!$insertimagequestion = $mysqli->prepare($imagequestionsql)) { // Handle errors with prepare operation here } $sessid = $_SESSION['id'] . ($_SESSION['initial_count'] > 1 ? $_SESSION['sessionCount'] : ''); $insertimagequestion->bind_param("sss", $lastID, $sessid, $_POST['numQuestion'][$i]); $insertimagequestion->execute(); //IF ANY ERROR WHILE INSERTING DATA INTO EITHER OF THE TABLES if ($insert->errno) { // Handle query error here } $insert->close(); if ($insertimagequestion->errno) { // Handle query error here } $insertimagequestion->close(); } } ?> </code></pre> <p>So for example if I insert 2 images "cat.png" and "dog.png" into "Image" Database table, it will insert it like this:</p> <pre><code>ImageId ImageFile 220 cat.png 221 dog.png </code></pre> <p>(ImageId is an auto increment)</p> <p>Anyway what I want to do is that when a file is uploaded, not only is the data inserted into the table above, but I want to also be able to retrieve the ImageId that was inserted above and place it in the "Image_Question" table below so it would be like this:</p> <pre><code> ImageId SessionId QuestionId 220 cat.png 1 221 dog.png 4 </code></pre> <p>The problem is that it is not inserting any data into the second table "Image_Question", does anyone know why it is not inserting any data? There is no errors in the php file.</p> <p>To upload a file, the user selects a file for the ajax uploader in the "QandATable.php" page, when the user clicks on upload, using AJAX it will go onto the imageupload.php page and does the uploading there. So the problem I have is that no errors will appear as they are on seperate pages.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload