Results 1 to 7 of 7

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User Airfan's Avatar
    Join Date: Dec:2001
    Location: Plovdiv
    Posts: 89

    PHP Interbase/Firebird BLOB

    ,
    , .
    .
    image.php, :
    <?
    include('connection.php');
    if(!isset($_GET['id']) || $_GET['id']=='' || $_GET['id']=='false'){
    $statement='select dValue from DEF_PICTURES where id=1';
    $pointer='DVALUE';
    }
    else {
    $id=$_GET['id'];
    $statement="select poster from films where films.id=$id";
    $pointer='POSTER';
    }
    header('Content-Type: image/jpeg');
    $result=ibase_query($statement);
    $data=ibase_fetch_object($result);
    $blob_data = ibase_blob_info($data->$pointer);
    $blob_hndl = ibase_blob_open($data->$pointer);
    if(!$blob_hndl){
    header("Location: image.php?id=false");
    exit;
    }
    else {
    echo $data= ibase_blob_get($blob_hndl, $blob_data[0]);
    }
    ibase_blob_close($blob_hndl);
    ?>

    - id, , ( ), . html <img src=image.php?id=23> .
    -, , . ? ?

    ,
    Airfan
    I7-4770K@GA-Z97X-UD3H + CM Hyper 212 Evo + CM N500 + 4 x 4GB Geil Enhance Corca 1600MHz + Sapphire HD 5850 (Game edition)

  2. #2
    Android 4.1 User Athlonio's Avatar
    Join Date: Oct:2005
    Location: 90
    Posts: 288
    , .

    ... , ?
    comp: GB B85M-D3H /1150 | Pentium G3420 3.2GHZ/3M/1150 | 2 X 4 GB DDR3 Kingston HyperX 1600 | 500GB WD BLUE SATA2 | Asus nVidia 9600GT | LG 8.5GB DVDRW Black GSA-4163-B retail | FOXCONN 3GTH002//FSP 400W PFC | Phillips 190X6FB | Logitech X-530

  3. #3
    relative dude Skydive's Avatar
    Join Date: Nov:2002
    Location: /
    Posts: 2,863
    Quote Originally Posted by Airfan
    html <img src=image.php?id=23> .
    ,
    Firebird/Interbase , . . ?

    : Sky IS the limit.....
    Last edited by Skydive; 19th June 2006 at 17:26.

  4. #4
    Registered User Airfan's Avatar
    Join Date: Dec:2001
    Location: Plovdiv
    Posts: 89
    ,

    Athlonio - , , , , .

    Skydive - -, , . The sky IS NOT the limit, , .......

    . -
    I7-4770K@GA-Z97X-UD3H + CM Hyper 212 Evo + CM N500 + 4 x 4GB Geil Enhance Corca 1600MHz + Sapphire HD 5850 (Game edition)

  5. #5
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    :
    ID- ( mysql- ID int, text )
    default , ..

    $statement='select dValue from DEF_PICTURES where id=1';

    $statement="select poster from films where films.id=1";
    , 100%

  6. #6
    Registered User Airfan's Avatar
    Join Date: Dec:2001
    Location: Plovdiv
    Posts: 89
    Quote Originally Posted by Pa3KaTaH
    :
    ID- ( mysql- ID int, text )
    default , ..

    $statement='select dValue from DEF_PICTURES where id=1';

    $statement="select poster from films where films.id=1";
    , 100%

    !
    ! $statement='select dValue from DEF_PICTURES where id=1'; $statement="select dValue from DEF_PICTURES where id=1";, .. ! , .
    !
    I7-4770K@GA-Z97X-UD3H + CM Hyper 212 Evo + CM N500 + 4 x 4GB Geil Enhance Corca 1600MHz + Sapphire HD 5850 (Game edition)

  7. #7
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |