[PHP-DB] Using MySQL Inno DB transaction

2005-07-12 Thread Arie Nugraha
Lately i'm building a library automation application with php 5 and MySQL 4..1. For the transaction module, i'm using Inno DB engine to store the transaction data, cos i want to use MySQL transaction method which can be commit or rollback. But when i tried to rollback the transaction in the other

RE: [PHP-DB] Using MySQL Inno DB transaction

2005-07-12 Thread Bastien Koert
I would think that it all has to occur in one script since the db connection is closed with an implicit commit when the page ends bastien From: Arie Nugraha <[EMAIL PROTECTED]> Reply-To: Arie Nugraha <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Using MySQL Inno DB transaction

[PHP-DB] PDF encoded

2005-07-12 Thread Shekhar Juneja
Hi , I am trying to figure out a way how to display base64 encoded string. Basically I am getting base64 encoded string back a webservise, I was to display this PDF inlined in the browser. But instead its printing the encoded string in the browser. request help on this:) Warm regards Shekhar

RE: [PHP-DB] PDF encoded

2005-07-12 Thread Bastien Koert
http://ca3.php.net/manual/en/function.base64-decode.php bastien From: "Shekhar Juneja" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] PDF encoded Date: Tue, 12 Jul 2005 14:30:32 +0100 Hi , I am trying to figure out a way how to display base64 encoded string. Basically I am getting base64 encoded

RE: [PHP-DB] PDF encoded

2005-07-12 Thread Shekhar Juneja
Hi Bastien. Snippet of my code is header('Content-type: application/pdf'); header(" Content-Disposition: inline"); header('Content-Transfer-Encoding: base64'); echo echo base64_decode€($String); Where $string contains the encoded string. Don’t know where I am going wrong. Regards Shekhar -

Re: [PHP-DB] PDF encoded

2005-07-12 Thread Micah Stevens
Looks like you're telling the browser that the data is base64, and then decoding the data before you send it. Try sending the string without the base64_decode() statement. just echo $string Or, lose the transfer encoding header, and leave the base64_decode() in.. -Micah On Tuesday 12 July

Re: [PHP-DB] PHP Bug handling Messages from MSSQL ?

2005-07-12 Thread Frank M. Kromann
Hi Denio, The function name should say it all, mssql_get_last_message() returns the last and only the last message from the server. I'll add an item on my todo list to implement a mssql_get_server_messages() function tal will allow you to get all messages from the previous mssql_query() call. This

RE: [PHP-DB] PDF encoded

2005-07-12 Thread Shekhar Juneja
Tried both ways :( -Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 5:17 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] PDF encoded Looks like you're telling the browser that the data is base64, and then decoding the data before you sen

Re: [PHP-DB] PDF encoded

2005-07-12 Thread Micah Stevens
I didn't really read your post carefully. On second read it looks like you're trying inlide embedding? So in other words, you want an HTML page with an are that is a PDF, as if you used an Tried both ways :( > > > -Original Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent

[PHP-DB] PDO name

2005-07-12 Thread Kevin Schmeichel
Anyone know why the name PDO was chosen for what is really just a SQL abstraction layer? I actually implemented something a while back that I called PDO, which provided a means to do get/set/save/delete etc. operations, on data objects, but the persistent implementation was hidden from the

[PHP-DB] Creating an Interbase.so file

2005-07-12 Thread Todd Cary
I am running Fedora Core 3 and I want to install and integrate Interbase (Firebird 1.5) with php. To create the "so" file, I downloaded php 4.4.0 and did a ./configure --with-interbase=shared,/opt/firebird make Then I place the interbase.so into /usr/lib/php4 and make an interbase.ini in /et

[PHP-DB] Searchable/Sortable Database Fields with MySQL/PHP

2005-07-12 Thread Matt McNeil
Greetings, I need to securely store lots of sensitive contact information and notes in a (MySQL or other freely available) database that will be stored on a database server which I do not have direct access to. This database will be accessed by a PHP application that I am developing. However, I a

Re: [PHP-DB] Searchable/Sortable Database Fields with MySQL/PHP

2005-07-12 Thread Micah Stevens
Just do all your searching/sorting in PHP.. it would be slower, and if your dataset is very large (sounds like it might be the case) it would be impossible.. So that might be out of the question.. A bit of system engineering might find a solution too, consider which fields you need to search/

Re: [PHP-DB] Searchable/Sortable Database Fields with MySQL/PHP

2005-07-12 Thread Micah Stevens
Oh! Also, there's built in mysql functions for encryption, I forgot about that, so you can still search, like this: insert into table set name_field = AES_ENCRYPT('Some name', 'secret key'); select * from table where AES_DECRYPT(name_field,'secret key') LIKE '%some'; Make sense? You'll want an