I want to retrieve my image from database

Question

1.00/5 (1 vote)

See more:

$sql = "select * from oficers_tbl"; $stmt = $con->prepare($sql); $stmt->execute();

$stmt->setFetchMode(PDO::FETCH_ASSOC);
while ($row = $stmt->fetch()){

echo"";

What I have tried:

i want to retrieve an image from database and display it, the image Path stored on my folder call 'upload' Bellow is My Code

Posted 9-Aug-20 22:52pm

Ibrahim Hassan 1234

Updated 9-Aug-20 23:15pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2020-08-09T23:15:00

Solution 1

This is the same question as I want to retrieve an image from my database using PDO[^], and you still have not explained what the problem is.

Posted 9-Aug-20 23:15pm

Richard MacCutchan

Comments

Ibrahim Hassan 1234 10-Aug-20 5:21am

Sorry Sir i am trying to explain it but i dont know why it been automatically removed this is my problem.
/////////////////\\\\\\\\\\\\\\\\\\\\
$sql = "select * from oficers_tbl";
$stmt = $con->prepare($sql); $stmt->execute();

$stmt->setFetchMode(PDO::FETCH_ASSOC);
while ($row = $stmt->fetch()){
echo"";
}
/////////////////\\\\\\\\\\\\\\\\\\\

but it only show me blank image thumbnail

Ibrahim Hassan 1234 10-Aug-20 5:23am

echo""; i put something inside double queto like "upload/$row[img]" but it's not show

Richard MacCutchan 10-Aug-20 5:26am

You need to use the debugger to examine each record that you read from the database. We have no way of getting that information.

Ibrahim Hassan 1234 10-Aug-20 5:28am

thank you sir.