php - How to show images from my database (BLOB type data)? -


this table upload

create table `upload` (   `id` int(10) unsigned not null auto_increment,   `deskripsi` text,   `filetype` varchar(200) default null,   `filedata` longblob,   `filename` varchar(200) default null,   `filesize` bigint(20) default null,   primary key  (`id`) ) engine=myisam  default charset=latin1 auto_increment=49 ;

this table article

create table `info` (   `id_info` int(10) not null auto_increment,   `judul_info` varchar(50) collate latin1_general_ci not null,   `konten` varchar(50000) collate latin1_general_ci not null,   `diubah_oleh` varchar(20) collate latin1_general_ci not null,   `id_kategori` int(10) not null,   `tgl_buat` timestamp not null default '0000-00-00 00:00:00',   `tgl_ubah` timestamp not null default current_timestamp on update current_timestamp,   `dibuat_oleh` varchar(20) collate latin1_general_ci not null,   `id` int(10) not null,   primary key  (`id_info`),   key `id_kategori` (`id_kategori`),   key `id` (`id`) ) engine=myisam  default charset=latin1 collate=latin1_general_ci auto_increment=5 ;

this source code index.php

<?php include "config.php"; $query= "select upload.filetype, upload.filename, upload.filedata, info.judul_info, info.konten, info.diubah_oleh, info.id_info, info.tgl_buat, info.tgl_ubah, info.dibuat_oleh, info.id  info  join  upload  on info.id = upload.id id_info='4'"; $runquery = mysql_query($query);  while($result = mysql_fetch_array($runquery)) { $id = $result['id']; echo "<img src=get_image.php?id=$id>"; ?>  <div class="caption"> <?php $id_info = $result['id_info']; $judul = $result['judul_info']; $konten = $result['konten']; echo "<h3>$judul</h3>"; echo "<p>".substr($result['konten'], 0, 100)."...</p>"; echo "<a href=detail_info.php?page_detil=$id_info>selengkapnya</a><br><br>"; } ?>

and, source code get_image.php

<?php include "config.php":  $id = addslashes($_request['id']);  $image = mysql_query("select * upload id=$id"); $image = mysql_fetch_assoc($image); $image = $image['filedata'];  header("content-type: image/jpeg"); echo $image; ?>

i want images shown article, can show title , content of article images won't showed up. can me?

first: please avoid pass user input query directly! should switch mysqli or pdo: http://code.tutsplus.com/tutorials/pdo-vs-mysqli-which-should-you-use--net-24059

to solve problem, should quote image href:

echo "<img src='get_image.php?id=$id'>";

if not help, open get_image.php in browser. image show up? if not, check query's result (just comment header line see output).


Comments

Post a Comment

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

i have button on website when clicked, reveals map. button can seen when page first loads up, when clicked, section holding map slides open , goes out of screen since page loads @ top (normal). want page scroll down bottom of div select when button pushed, if map out of screen. if page scrolled down, , clicks show map button, don't want page jump bottom of map. i tried figure out myself, no luck. seasoned jquery coders able give me guidance? many thanks! map = mapdiv.gmap3("get"); infobox = new infobox({ pixeloffset: new google.maps.size(-220, -310), closeboxurl: '', enableeventpropagation: true }); mapdiv.delegate('.infobox .close','click',function () { infobox.close(); }); jquery(".slidingdiv").hide(); jquery(".show_hide").show(); jquery('.show_hide').click(function(){ lastcenter=map.getcenter(); jquery(".slidingdiv&quo
Read more

javascript - Highcharts multi-color line -

Image
i looking create highchart multi-colored line. if goes down under value, become red, , when comes on value, become green . here picture example: or maybe highcharts have other charts models differentiate high or low level color? you can achieve coloring using lineargradient coloring: color: { lineargradient: { x1: 0, x2: 0, y1: 0, y2: 1 }, stops: [ [0, 'red'], [0.25, 'yellow'], [0.50, 'green'], [0.75, 'yellow'], [1, 'red'] ] } here 0 in stops relates minimum value of series , 1 maximum value, , in between percentages between values. if find percentages according values prior creating chart use correct stops values make relate specific values in data (at least approximately). see this jsfiddle example .
Read more

javascript - Enter key does not work in search box -

tried search guys sorry. input in search box doesnt work (or search) when hit enter when user clicks search button. doing wrong? here code. thanks. <script type="text/javascript"> $(document).ready(function() { $("#submit").click(function() { var url = "http://asla.org/awardssearch.html"; url += "?s=" + $('#googlecse').val(); window.location = url; }); $('#googlecse').keydown(function(event) { if (event.keycode == '13') { $("#submit").click(); } else { //do nothing :) } }); }); </script> <form class="navbar-form navbar-right" role="search"> <div class="search"> <input id="googlecse" type="text" onblur="if(this.value=='')this.value=this.defaultvalue;" onfocus="if(this.value==this.defaultvalue)t
Read more