I insert image to the product but i can't display it in ejs..each product has 2 images..the productImageName should by the image and it's blob type in DB
app.get('/product', getProductPage);
getProductPage: (req,res) => {
let query = "SELECT p.*,i.* FROM `product` AS p INNER JOIN `productimage` AS i ON p.productId = i.productId ";
getConnection().query(query , (err, result) => {
if (err) {
return res.status(500).send(err);
}else {
console.log(result);
res.render('product.ejs',{
product:result
});
}
})
my ejs :
<% product.forEach((product) =>{ %>
<tr>
<td> <img id="productImage" src="data:image/png;base64,.base64_encode(<%= product.productImageNAme %>)"></td>
<td ><%= product.productName %></td>
<td><%= product.price %></td>
<td><a href="/editProduct/<%= product.productId %>" id="edit" id="edit"> Edit</a></td>
</tr>
<% }) %>
I got this in console:
> RowDataPacket {
> productId: 29,
> productName: 'er',
> price: '3',
> productImageId: 8,
> productImageName:
> <Buffer 75 6e 64 65 66 69 6e 65 64 2d 31 35 36 33 36 32 30 30 34 35 38 35 36> } ]