mysql - PHP PDO MS Access how to read blob images? -


i have images blob's in ms access database. have far used them odbc acces php , works fine. here comes simplified program:

code: <?php ini_set("odbc.defaultlrl", "5m"); $dbname = $_server["document_root"]."\\..\db\\teknofo.mdb"; $con = odbc_connect("driver={microsoft access driver (*.mdb)};dbq=".$dbname,'','') or die('ups'); ob_clean(); header('content-type: image/*'); $sql = "select photo medlemmer id=17"; $rd = odbc_exec($con, $sql); if (odbc_fetch_row($rd)) { echo odbc_result($rd,"photo"); } odbc_close($con); ob_end_flush(); ?>

i in process of converting mysql have use ms access timg: therefor making new code using pdo, not able read data correct.

here comes new 

<?php $dbname = $_server["document_root"]."\\..\db\\teknofo.mdb"; $con = new pdo("odbc:driver={microsoft access driver (*.mdb)}; dbq=$dbname; uid=; pwd=;"); $sql = "select photo medlemmer id=?"; $st = $con->prepare($sql); $st->execute(array(17)); $st->bindcolumn('photo', $photo, pdo::param_lob); $st->fetch(pdo::fetch_bound); odbc_longreadlen($st, 131072);         odbc_binmode($st,odbc_binmode_convert);                             ob_clean(); header('content-type: image/*'); if ($rd = $st->fetch(pdo::fetch_bound)) { echo $rd['photo']; ob_end_flush(); $con = null; ?>

the last code works fin mysql (changed connection string) not ms access.

i have searced net long time have not been able find solution.

can pleasse?

i use first code, need able handle blob's other purposes well.

php , access odbc driver have never been best of friends, , apparently continues case pdo_odbc , access odbc driver. 2 wrinkles here were

  1. the blob returned ascii string representing hex values of image data (e.g., '424d7ac000...'), and

  2. that string contains spurious null character every 255 characters.

the code managed working is:

<?php $dbname = $_server["document_root"]."\\test.mdb"; $con = new pdo("odbc:driver={microsoft access driver (*.mdb)}; dbq=$dbname; uid=; pwd=;"); $sql = "select photo clients id=?"; $st = $con->prepare($sql); $st->execute(array(1)); $st->bindcolumn(1, $photochars, pdo::param_lob); $st->fetch(pdo::fetch_bound);  // $photochars long string of hex, e.g., '424d7a...'  // pdo+access_odbc apparently injects null every 255 characters,  //     remove them first $photochars = str_replace("\0", "", $photochars);  // create array of character pairs (e.g.: '42', '4d', '7a', ...) $photoarray = str_split($photochars, 2);  // convert numeric values ($i = 0; $i < sizeof($photoarray); $i++) {     $photoarray[$i] = hexdec($photoarray[$i]); }  // pack binary string //     ref: http://stackoverflow.com/a/5473057/2144390 $photodata = call_user_func_array("pack", array_merge(array("c*"), $photoarray));  header('content-type: ' . image_type_to_mime_type(imagetype_png)); header('content-disposition: attachment; filename="untitled.bmp"'); echo $photodata;

Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more