Showing the data from mysql data to php page using select

Question

I am using JQuery Line Control Plugin for textbox, which include both images links text(which can be styled in either format) and it is proving me the html code for that which saves in MySQL database.

For Example :

If in Line Control Textbox I insert an image and a paragraph it saves in MySQL the below result

    <img src="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/4RDgRXhpZgAATU0AKgAAAAgABAE7AAIAAAAHAAAISodpAAQAAAABAAAIUpydAAEAAAAOAAAQyuocAAcAAAgMAAAAPgAAAAAc6gAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA...and a lonbg garbage text like this" alt="" height="151" width="139"/>
<br><br>Summis cernantur possumus, sunt arbitror ea comprehenderit, ne multos quibusdam &lt;br&gt;distinguantur de multos est cernantur e e laborum arbitrantur do dolor e &lt;br&gt;excepteur iis laborum fugiat fabulas si nescius quem nostrud vidisse. Labore &lt;br&gt;pariatur in praetermissum qui laborum quem nam <br>

How can I show it in php page with the image ?

I know JQuery also so the solution with jquery will also accepted.

it is an image encoded to base64. you can simply echo the string or convert to real image with php. — Nico, Jul 28 '16 at 10:13
take a look to [this](http://stackoverflow.com/a/15153931/2418529) — Nico, Jul 28 '16 at 10:18

Titanoboa · Answer 1 · 2016-07-28T10:46:23.147

0

You may need to change this according to your filetype.

header("Content-Type: image/jpeg");
$data = "/9j/4AADADJdjw8A........and so on"; // Get this from somewhere
echo '<img src="data:image/jpeg;base64,' . $data . '" />'; // To Display the image

EDIT: Your Base64 image code is probably damaged. I ran your code in JSFiddle with another image and it works just fine. Maybe you should check whether your Base64 data is being truncated by the database.

edited Jul 28 '16 at 10:46

answered Jul 28 '16 at 10:18

Titanoboa

355
1
9

Thanks for the Answer. If you drag the code to your right you will see that the image is followed by paragraph and the image itself is in `` tag – Ankit Sharma Jul 28 '16 at 10:20
In that case you could just echo the entire query result into the page using PHP, right? – Titanoboa Jul 28 '16 at 10:25
Yes exactly. Please Help – Ankit Sharma Jul 28 '16 at 10:26
I am trying to display it by `echo` but it gives me the text correct but image is broken – Ankit Sharma Jul 28 '16 at 10:27
Can you show us the exact output of the echo statement without any truncations. – Titanoboa Jul 28 '16 at 10:32
Sorry, I Will not be able to give us you a screenshot. It is showing me the paragraph which is below the image tag `` and the image shows me a broken link icon that's it. – Ankit Sharma Jul 28 '16 at 10:38
Your code runs fine with another image as seen here https://jsfiddle.net/tcgh4kwh/ . Your Base64 image code is probably damaged. – Titanoboa Jul 28 '16 at 10:43

Showing the data from mysql data to php page using select

1 Answers1