Re: [PHP-DB] Page refresh and database updation

2006-09-26 Thread Sancar Saran
On Tuesday 26 September 2006 15:31, Tamkhane, Pravin wrote: Hi All, I am a PHP newbie. I am using HTTP POST request to send some data to Apache and then using MySql to store that information. Once information is stored in MySql DB successfully, I display a result page. But the problem I am

[PHP-DB] Page refresh and database updation

2006-09-26 Thread Tamkhane, Pravin
Hi All, I am a PHP newbie. I am using HTTP POST request to send some data to Apache and then using MySql to store that information. Once information is stored in MySql DB successfully, I display a result page. But the problem I am facing is that, if I refresh the result page displayed after

[PHP-DB] Re: Page refresh and database updation

2006-09-26 Thread Chuck Stearns
Tamkhane, Pravin wrote: Hi All, I am a PHP newbie. I am using HTTP POST request to send some data to Apache and then using MySql to store that information. Once information is stored in MySql DB successfully, I display a result page. But the problem I am facing is that, if I refresh the

Re: [PHP-DB] Page refresh and database updation

2006-09-26 Thread Brad Bonkoski
I'm sure there are many ways... a few off the top of my head. a). if there is some field or combination of fields that guarantee uniqueness then you can test for their existence before you insert. b). When you insert the first time set some session variable to something, and then don't insert

Re: [PHP-DB] Page refresh and database updation

2006-09-26 Thread RaJeSh VeNkAtA
Hi, one thing u can do is u can have a primary key the table you are inserting so that duplication wont be done. If thats not possible redirect the page to the results page after updating the post data than showing him the results in the action page ( action i mean where the form action has

RE: [PHP-DB] Re: Page refresh and database updation

2006-09-26 Thread php
You can redirect the page to the result page after the data is saved, using header(Location: successpage.php). I've used this on several sites. It's a little extra work but does prevent the reposting of data. Another option is to use AJAX to send the data to the webserver and then have the

[PHP-DB] Unicode error with PostgreSQL

2006-09-26 Thread Tony Grimes
I'm getting the following error when PHP tries to insert a Unicode character (the problem word is resume with the accents) into a PostgreSQL database: pg_exec(): Query failed: ERROR: Invalid UNICODE character sequence found (0xe97375) I can't figure out why I'm getting the error. The HTML form

[PHP-DB] Error when trying to connecting to an Oracle database

2006-09-26 Thread Janet Smith
I am trying to use a program written in PHP but connect to an Oracle database. We have a function as follows: function dbconnect($db, $username, $password) { global $siteadmin; global $db; // $bob = @mysql_connect($db, $username, $password);

Re: [PHP-DB] Error when trying to connecting to an Oracle database

2006-09-26 Thread Tony Grimes
Hi Janet, This is a PHP 5 only function. Are you running PHP 5? If not, try using ocilogon() instead. If you are running 5, then maybe the Oracle library wasn't included when PHP was compiled. HTH, Tony On 9/26/06 2:13 PM, Janet Smith [EMAIL PROTECTED] wrote: I am trying to use a program

Re: [PHP-DB] Unicode error with PostgreSQL

2006-09-26 Thread Tony Grimes
So does that mean I will always get that error? There's got to be a way around that. Is there at least a way to detect invalid characters before I try to insert? Tony On 9/26/06 1:17 PM, Niel Archer [EMAIL PROTECTED] wrote: PHP isn't multibyte aware by default. Niel -- PHP Database

Re: [PHP-DB] Unicode error with PostgreSQL

2006-09-26 Thread Niel Archer
Hi Tony You can use the multibyte aware string functions for processing. There is also a way to make it use UTF-8 encoding, but I forget how just now. I had the same problem with a MySQL db a while back. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Error when trying to connecting to an Oracle database

2006-09-26 Thread Tony Grimes
Hi Janet, This is a PHP 5 only function. Are you running PHP 5? If not, try using ocilogon() instead. If you are running 5, then maybe the Oracle library wasn't included when PHP was compiled. HTH, Tony On 9/26/06 2:13 PM, Janet Smith [EMAIL PROTECTED] wrote: I am trying to use a program

Re: [PHP-DB] Unicode error with PostgreSQL

2006-09-26 Thread Tony Grimes
So does that mean I will always get that error? There's got to be a way around that. Is there at least a way to detect invalid characters before I try to insert? Tony On 9/26/06 1:17 PM, Niel Archer [EMAIL PROTECTED] wrote: PHP isn't multibyte aware by default. Niel -- PHP Database

[PHP-DB] list field from .dbf

2006-09-26 Thread Rafael Ramdhani
Dear All, i need convert my data from .dbf ( visual foxpro ) to mysql database first at all i open .dbf and list the field some error with function dbase_get_record it's not support list field ( memo type ) my list data have lost where field type is memo may help me to get field (memo)