[PHP-DB] How to stop the server timing out

2006-10-03 Thread David Skyers
Hi,I have written a php page and every time I run it, it causes the server to times-out. Is there anything I can do, to get the page to run completely or speed up how the page works. Please note I do not have any control over the server.The page does a select from a table and inserts the

[PHP-DB] Re: Unicode error with PostgreSQL

2006-10-03 Thread Nisse Engström
On Tue, 26 Sep 2006 12:05:56 -0600, Tony Grimes wrote: 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)

[PHP-DB] Test

2006-10-03 Thread brian . kejser
Hi Sorry for sending this test message but I haven't received a response from the list daemon. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql_error function

2006-10-03 Thread Honza Spurny
Hello, let me ask you something. I have a problem with mysql_error() function after using mysql_connect(). Please look at thiese two examples: Example 1 $link = mysql_connect($host, $user, $pswd) or die(Could not connect to $host because: . mysql_error()); /Example 1 Example 2 $link1 =

Re: [PHP-DB] How to stop the server timing out

2006-10-03 Thread Niel Archer
Hi, when you say the 'server' times out, do you mean the script reaches it's execution limit (usually around 60 seconds). If that is the case and you have no control over the PHP environment, then there is little you can do to help. The only thing you can do in this situation is to improve the

Re: [PHP-DB] mysql_error function

2006-10-03 Thread Niel Archer
Hi The error message for second connection request is not given back to the PHP. Or as I suppose, mysql_error takes last error message from last used ESTABLISHED connection (it means from $link1) and since in this connection was everything ok, it puts empty string as a result of mysql_error

[PHP-DB] PHP-MySQL CMS Generator

2006-10-03 Thread Ted Weatherly
Does anyone know of a program that can generate a good Content Management System? For example, it would ask which fields to add to a database table, the types of the fields, etc and create the database in MySQL and php's to manage the data. I did find a few such programs already (AppGini,

[PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread brian . kejser
Hi I setup Php as follows: 1. Download the php zip file (not the installer) 2. Unzip the files to c:\Php 3. Add c:\php to the path 4. Copy php.ini-dist to php.ini 5. Add and enable the web extension php5isapi.dll 6. Add the .php extension mapping to php5isapi.dll at the the web sites folder 7.

re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread brian . kejser
Hey Thanks but that didn't help. Do you have any other suggestions? By the way, I'm using php 5.1.6 and mysql 5.0.24a. -Original Message- From: [EMAIL PROTECTED] Sent: Tue, October 3, 2006 11:52 To: [EMAIL PROTECTED], php-db@lists.php.net Subject: re: [PHP-DB] Php 5 and Mysql on

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread brian . kejser
Hey I'm using IIS on W2K3 SP1, php 5.1.6 and mysql 5.0.24a. -Original Message- From: Alejandro Tesone [EMAIL PROTECTED] Sent: Tue, October 3, 2006 12:25 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Php 5 and Mysql on Windows Which server you will use? Apache or Microsoft? On

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread Stut
[EMAIL PROTECTED] wrote: I setup Mysql as follows: 1. Download the 5.x installer 2. Run the installer 3. Run the configuration tool ater the installer When I run the following script, the error Fatal error: Call to undefined function mysql_connect() in Test.php on line 3 is returned.

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread brian . kejser
Hey I did that already. Step (8) of setting up php. Do I need to move any files around or add anything else to the path? -Original Message- From: Stut [EMAIL PROTECTED] Sent: Tue, October 3, 2006 14:12 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Php 5 and

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread Dave W
You might want to try php.ini-recommended instead of php.ini-dist. On 10/3/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hey I did that already. Step (8) of setting up php. Do I need to move any files around or add anything else to the path? -Original Message- From: Stut [EMAIL

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread Niel Archer
Hi Make sure that the php.ini file being used is the one you thinkit is. I keep mine in the php directory, so I have to be very careful that I don't accidentally let one get into the Windows folder, becuase that is search first The manual lists the search order. It also has some notes on

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread brian . kejser
Hey I tried that but I still get the error. -Original Message- From: Dave W [EMAIL PROTECTED] Sent: Tue, October 3, 2006 14:33 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Php 5 and Mysql on Windows You might want to try php.ini-recommended instead of

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread Frank M. Kromann
IIRC: When you are using ISAPI you must have php,ini in the windows directory. If you are using CGI you can have it in the same directory as all other PHP files. - Frank Hi Make sure that the php.ini file being used is the one you thinkit is. I keep mine in the php directory, so I have

RE: [PHP-DB] How to stop the server timing out

2006-10-03 Thread Bastien Koert
You need to just start adding echo statements to the code to see where the hang up is Bastien From: David Skyers [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] How to stop the server timing out Date: Tue, 3 Oct 2006 11:51:30 +0100 Hi, I have written a php page and every time

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread brian . kejser
Wow That solved it. Awesome. Thanks you so much. -Original Message- From: Frank M. Kromann [EMAIL PROTECTED] Sent: Tue, October 3, 2006 19:20 To: php-db@lists.php.net Subject: Re: [PHP-DB] Php 5 and Mysql on Windows IIRC: When you are using ISAPI you must have php,ini in the windows