[PHP-DB] Re: can PHP handle the new mysql-4.1.1 authentication method?
Oh, my god - I am so embarrassed. I thought I tried that, too; but obviously I didn't ;-/ Now, anybody knows about the plans to retrofit mysql_ functions to support 4.1, so we don't have to rewrite all mysql code? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 17, 2004 5:40 PM Subject: Re: [PHP-DB] can PHP handle the new mysql-4.1.1 authentication method? In a message dated 4/17/2004 12:11:35 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: Was anybody successful in connecting from PHP to MySQL with new (41-character) password authentication? All I am getting is "Client does not support authentication protocol requested by server. Consider upgrading MySQL client". I assume PHP needs to be recompiled with new MySQL client binaries. Is there a binary version? There is nothing mentioned in PHP 4.3.6 or in PHP 5. Anybody solved this? In order to use MySQL 4.1, you need to use the mysqli extension, rather than mysql functions. You need PHP 5 in order to use mysqli. PHP 5 RC 1 has the necessary support. In PHP 5, MySQL is not compiled in by default. You need to enable MySQLi. Look up MySQLi in the PHP online manual for the function syntax. Janet "Felix Rabinovich" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Was anybody successful in connecting from PHP to MySQL with new > (41-character) password authentication? All I am getting is "Client does not > support authentication protocol requested by server. Consider upgrading > MySQL client". I assume PHP needs to be recompiled with new MySQL client > binaries. Is there a binary version? > > There is nothing mentioned in PHP 4.3.6 or in PHP 5. > > Anybody solved this? > Thx > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Double Submission into DB if Hit Refresh
Hi Add a hidden field into the form with a unique transaction ID. When the data is submitted first time save the transaction ID to a table. Before you do anything check to see if the transaction ID exists in the table, if not then you are ok to save the transaction ID and then add/update the data. If the ID is already there, then do not add/update and send the user a message to say they have submitted the same transaction twice. HTH Peter > -Original Message- > From: Craig Hoffman [mailto:[EMAIL PROTECTED] > Sent: 18 April 2004 01:30 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Double Submission into DB if Hit Refresh > > > What is the best way to avoid data being resubmitted (entered twice) to > DB (mysql) if the user hits refresh after POSTING data via a form? > __ > Craig Hoffman - eClimb Media > > v: (847) 644 - 8914 > f: (847) 866 - 1946 > e: [EMAIL PROTECTED] > w: www.eclimb.net > _ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Double Submission into DB if Hit Refresh
What is the best way to avoid data being resubmitted (entered twice) to DB (mysql) if the user hits refresh after POSTING data via a form? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] can PHP handle the new mysql-4.1.1 authentication method?
Was anybody successful in connecting from PHP to MySQL with new (41-character) password authentication? All I am getting is "Client does not support authentication protocol requested by server. Consider upgrading MySQL client". I assume PHP needs to be recompiled with new MySQL client binaries. Is there a binary version? There is nothing mentioned in PHP 4.3.6 or in PHP 5. Anybody solved this? Thx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] New To PHP
Thanks again for all of your help. Not having any programming background makes for a lot of fun with PHP. T At 01:59 PM 4/15/04 +0100, Mikael Grön wrote: What I did to learn PHP was to surf to http://www.hotscripts.com/ and look at other peoples code. Writing it yourself looking at the hotscript codes also helps you understand the logic of it. Mike On Apr 15, 2004, at 12:53, Tom Cloyes wrote: I ma trying to learn PHP and am having difficulty with understanding it. Is there a good PHP creator that will create PHP which will let me specify what all I need to have done so that I can go back and try to figure out just how it all fits together? Thanks, Tom KI8IZ http://www.wooster-isp.net Tom KI8IZ http://www.wooster-isp.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Basic Doubts
There is a program that I've found that will write the code for you from what you have set up in your MySQL database. It's called PHPMaker, and it is free to download a trial version which is good for 30 days. http://www.hkvstore.com/ is the URL. Being a newbie to PHP, this thing really helps. T At 08:21 PM 4/16/04 -0700, andy amol wrote: hi, I want to know the following things. 1. How can we maintain referential integrity (rather check) using PHP Any example code will be helpful. 2. I want to display the column of the tables, how to do that. 3. I want to align the text and the text box on the page. 4. I also want to check the validation of text(numerical or text) Any example script would be helpful. thanks in advance. - Do you Yahoo!? Yahoo! Tax Center - File online by April 15th Tom KI8IZ http://www.wooster-isp.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problems switching from MySQL 3.23 -> 4.0
Bump? [EMAIL PROTECTED] wrote: Hi, I have a page that grabs some data from a MySQL 3.23.58 database on a RedHat 9 box. I'm trying to migrate the db to a Suse box running MySQL 4.0.15. When I connect to the MySQL 4.0 DB, I get strange results. For example, there's a certain query that just returns the number of records in one of the tables: $c = $db->getOne("SELECT count(*) FROM tle"); print("$c"); Against the 3.23 DB, this works fine. Against the 4.0 DB this prints out "Object". Other queries return the same thing. What gives?? Some more details: Webserver Box: RedHat 9 Apache 2.0.40 PHP 4.2.2 The MySQL 3.2.3 DB also runs on this box. The MySQL 4.0 DB runs on a seperate Suse box. The Database structure & data is identical on both systems. Ideas? Thanks Eric - This message was sent using Endymion MailMan. http://www.endymion.com/products/mailman/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Fatal error: Call to undefined function: mysql_connect()
[EMAIL PROTECTED] (Tim) wrote in news:[EMAIL PROTECTED]: > Setup: > 2 servers, one with PHP 4.1.2 and no MySQL installed, the other has > MySQL and PHP 4.1.2 > > Problem: > I am attempting to connect to the MySQL server from the server without > MySQL, but I get the error that shows in the subject. > > Fatal error: Call to undefined function: mysql_connect() in > /folder/index.php on line 11 > > I was told that maybe the extension for MySQL was not setup in PHP. I > thought that maybe it was just because MySQL wasnt installed on the > system I am working on, but it makes sense that I am not trying to > access a database on the system I am working from, but trying to > access one on a different server all together. > > What do you think? I think the error message tells it all - there is no mysql support in the php you are using. You'll need to recompile with php support, or load a mysql extension library. Cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Create subdomain using php in a linux machine
Hi, I like to know how to create subdomain using php in a linux machine. Thank You Dhanya Yahoo! India Matrimony: Find your partner online.