Display BLOB content from PHP

db , php South Africa
  • 13 years ago
    I have a Firebird 2.0 Database with a BLOB field that contains the history of buildings.
    How can I display the text(Building history) from the BLOB executing a query from PHP. Here is an extract of the sql query :
         $congregationName =  $address1 = $address2  = $autobiography = "";

              doConnect($con);

              // Execute query
              $stmt   = "SELECT DISTINCT C.CONGREGATIONNAME,
                                         C.ADDRESS1,
                                         C.ADDRESS2,
                                         C.AUTOBIOGRAPHY
                                                      
                         FROM   MEMBERS   M
                         JOIN   CONGREGATIONS      C   ON M.CONGREGATIONNO  = C.CONGREGATIONNO
                         JOIN   DISTRICTAREA       D   ON D.DISTRICTAREANO  = C.DistrictAreaNo
                         JOIN   BISHOPAREA         B   ON B.BISHOPAREANO    = C.BishopAreaNo
                         JOIN   APOSTLEAREA        A   ON A.APOSTLEAREANO   = C.APOSTLEAREANO
                         $areaCon
                         ORDER BY C.CONGREGATIONNAME";
              $result = ibase_query($stmt);

    This is the result :

    Congregation Name Address1 Address2 Cronicle


    DURBANVILLE DE VILLIERS AVENUE DURBANVILLE 0x00003a3a00000099

    Please HELP

























Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Nine people can't make a baby in a month.” - Fred Brooks