[ selector @ 17.05.2004. 11:25 ] @
ima li neko primer za citanje BLOB podataka iz Oracle-a. u principu blob je karakternog tipa(text file), i koji bi po pozivu (odredjenog file) bio ispisan CELI SADRZAJ (tog file-a). thanx |
[ selector @ 17.05.2004. 11:25 ] @
[ selector @ 17.05.2004. 14:35 ] @
probam sa:
fbsql_read_blob ali imam problema sa konekcijom sa fbsql_pconnect: $link = fbsql_pconnect ("localhost", "_SYSTEM", "mojpass") or die ("Could not connect"); dobijam gresku: Fatal error: Call to undefined function: fbsql_pconnect() in /usr/local/apache/htdocs/test.php on line 10 zna li neko u cemu je problem [ Jbyn4e @ 17.05.2004. 14:42 ] @
fbsql funkicje koliko vidim sluze za povezaivanje sa FrontBase bazom (http://www.frontbase.com), a za oracle funkcije pogedati:
http://www.php.net/oracle , odnosno za novije varijante oracle-ta (>=7): http://www.php.net/manual/en/ref.oci8.php [ Dejan Topalovic @ 17.05.2004. 14:58 ] @
Da li ti moze pomoci ovaj dio u kojem se radi o prikazivanju PDF datoteke:
Code: $query = 'SELECT BLOBDATA FROM BTAB WHERE BLOBID = '.MYBLOBID; $stmt = OCIParse ($conn, $query); OCIExecute($stmt, OCI_DEFAULT); OCIFetchInto($stmt, $arr, OCI_ASSOC+OCI_RETURN_LOBS); $result = $arr['BLOBDATA']; // If any text (or whitespace!) is printed before this header is sent, // the text won't be displayed and the PDF won't be loaded correctly. // Comment out this line to see the text and debug such a problem. header("Content-Type: application/pdf"); // http://www.php.net/header has some interesting comments on // sending a "Content-Disposition" header // It will force IE to give a "save" window instead of opening it. //header("Content-Disposition: attachment; filename=suggestedfilename.pdf"); //header("Content-Length: " . strlen($result)); echo $result; OCIFreeStatement($stmt); OCILogoff($conn); [ dr ZiDoo @ 17.05.2004. 15:51 ] @
Citat: selector: ... dobijam gresku: Fatal error: Call to undefined function: fbsql_pconnect() in /usr/local/apache/htdocs/test.php on line 10 ... Ako dobijas tu gresku prekompajliraj PHP sa podrskom za fbsq i to je to. [ selector @ 17.05.2004. 16:06 ] @
hvala vam
probacu sa OCI-jem nego StRiPy sta treba da bude $arr niz u ovom slucaju $conn sam spremio. [ Dejan Topalovic @ 17.05.2004. 16:27 ] @
$arr je array u koji spremas rezultate upita
![]() [ selector @ 18.05.2004. 10:26 ] @
totalno sam nov u php-u, ali zar nije trebalo da $arr bude negde pre definisano kao $stmt.
[ Dejan Topalovic @ 18.05.2004. 11:18 ] @
Ne, ne. $arr je niz u koji spremas rezultate pretrage. $stmt je parsovani izraz kojeg izvrsava Oracle server kao SQL komandu.
[ selector @ 18.05.2004. 14:16 ] @
fino sto nema deklarisanja kao u pl/sql-u. dobijao sam gresku zbog gluposti, stavio sam duple";"
nego cestitam, vidim da si postao OCP-welcome to the club Copyright (C) 2001-2025 by www.elitesecurity.org. All rights reserved.
|