Adding a new column to already made script

[Mekaboo]

Hey☺️

I implemented a script into my site to upload images. I added a Comment Column within the script's already made table so users can add words with the images.  Here is my code:

DB connect(don't know if I added comment correctly)

<?php

require_once "db.php";

if(isset($_GET['image_id'])) {

$sql = "SELECT imageType,imageData,comment FROM output_images WHERE imageId=" . $_GET['image_id'];

$result = mysqli_query($conn, $sql) or die("<b>Error:</b> Problem on Retrieving Image BLOB<br/>" . mysqli_error($conn));

$row = mysqli_fetch_array($result);

header("Content-type: " . $row["imageType"]);

echo $row["imageData"];

echo $row["comment"];

}

mysqli_close($conn);

?>

 

Form:
 

<form name="frmImage" enctype="multipart/form-data" action="" method="post" class="frmImageUpload">

<label>Upload Image File:</label><br/>

<input name="userImage" type="file" class="inputFile" /><br>

Write: <input type="text" name="comment"><br>

<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>

<input type="submit" value="Submit" name="submit">

</form>

Question is: how do I attach "comment" column within the DB connect so content will store as well as display?

Thank ya❤️

Edited November 14, 2021 by Mekaboo

[Barand]

If you are outputting an image from a DB blob field, then here's an example...

// EMULATE DATA FROM THE DATABASE
    $type = 'image/png';
    $comments = 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas porttitor congue massa. Fusce    posuere, magna sed pulvinar ultricies, purus lectus malesuada libero, sit amet commodo magna eros quis urna.';
    $image_data = file_get_contents('images/snowman.PNG');

// OUTPUT THE DATA
    echo "<div style='width:396;'>
    <img src='data:{$type};base64," . base64_encode( $image_data ) . "' width='394' height='393'>
    <p>$comments</p>
    ";

RESULT

[Mekaboo]

@Barand☺️

 

Thank ya for the response but I have this already set  up. I want to add a column within this code:

<?php require_once "db.php"; if(isset($_GET['image_id'])) { $sql = "SELECT imageType,imageData,comment FROM output_images WHERE imageId=" . $_GET['image_id']; $result = mysqli_query($conn, $sql) or die("<b>Error:</b> Problem on Retrieving Image BLOB<br/>" . mysqli_error($conn)); $row = mysqli_fetch_array($result); header("Content-type: " . $row["imageType"]); echo $row["imageData"]; echo $row["comment"]; } mysqli_close($conn); ?>

so that the output you gave me works. As of now the image output works but not the comment

[ginerjm]

OK - when I rearranged your code to read thru it I see this:

require_once "db.php"; 
if(isset($_GET['image_id'])) 
{ 
	$sql = "SELECT imageType,imageData,comment FROM output_images 
			WHERE imageId=" . $_GET['image_id']; 
	$result = mysqli_query($conn, $sql) or 
			die("<b>Error:</b> Problem on Retrieving Image BLOB<br/>" . mysqli_error($conn)); 
	$row = mysqli_fetch_array($result); 
	header("Content-type: " . $row["imageType"]); 
	echo $row["imageData"]; 
	echo $row["comment"]; 
} 
mysqli_close($conn); 

which looks like you are outputting the  comment field.  If you are not seeing anything perhaps it is not in the db.  Have you taken a look at your table with phpmyadmin to see if it is actually there?