[PHP-DB] mysql_connect(): Lost connection to MySQL server during query

2008-08-12 Thread Manoj Singh
Hello all, I am getting this error when connecting to the database through mysql_connect function. Error: mysql_connect() [a href='function.mysql-connect'function.mysql-connect/a]: Lost connection to MySQL server during query I am getting this error when the db server has the high load. Please

Re: [PHP-DB] mysql_connect(): Lost connection to MySQL server during query

2008-08-12 Thread Evert Lammerts
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html should get you started. Good luck! On Tue, Aug 12, 2008 at 8:27 AM, Manoj Singh [EMAIL PROTECTED] wrote: Hello all, I am getting this error when connecting to the database through mysql_connect function. Error: mysql_connect() [a

Re: [PHP-DB] mysql_connect() Help

2008-03-08 Thread Jon L.
Since you seem to want to handle the errors yourself, you may try using the @ operator on the mysql functions. It'll silence any errors or warning that the functions might usually generate; but, of course, you'll be left to test for errors yourself. $link =

Re: [PHP-DB] mysql_connect() Help

2008-03-08 Thread Manysh
Thanks for your input, Jon. Few more observations... Yes, I have PHP+Apache+MySQL installed for private use. I am just trying to connect to the database successfully first and will create other users when I make a successful connection. I made the changes as below and still cannot connect to the

Re: [PHP-DB] mysql_connect() Help

2008-03-08 Thread Matt Anderton
Manysh -- maybe you missed the MySQL extension installation? 2nd or 3rd screen in the setup process there is a list of extensions -- none of them are installed by default. Your manual method of creating the 'ext' directory is a step in the right direction, but you probably have a missing

Re: [PHP-DB] mysql_connect() Help

2008-03-08 Thread Jon L.
Sorry. I can't really help you with server and PHP installation and configuration issues. I use XAMPP w/ a separate installation of MySQL. http://www.apachefriends.org/en/xampp.html But, find the following in your php.ini: extension_dir=... extension=php_mysql.dll You may already have an ext/

Re: [PHP-DB] mysql_connect() Help

2008-03-08 Thread Manysh
Matt - you're right! I did the manual install and its partially working now. I say partially because it works fine when I run it from the command window however when I run it from the web browser I get a blank page. I restarted Apache but that didn't help. The script is pasted below. Am I missing

Re: [PHP-DB] mysql_connect() Help

2008-03-08 Thread Matt Anderton
httpd.conf should have something like this: PHPIniDir C:/Program Files/PHP/ LoadModule php5_module C:/Program Files/PHP/php5apache2.dll AddType application/x-httpd-php .php ... but all that should have been taken care of by the PHP installer. -- matt On Sat, Mar 8, 2008 at 9:16 PM, Manysh

Re: [PHP-DB] mysql_connect() Help

2008-03-08 Thread Manysh
Awesome... that worked! The PHPIniDir was pointing to my earlier installation. Thanks Matt and Jon! Your help is much appreciated. Jon, thanks for sending the script. Manysh On Sat, Mar 8, 2008 at 9:57 PM, Matt Anderton [EMAIL PROTECTED] wrote: httpd.conf should have something like this:

[PHP-DB] mysql_connect problem

2006-12-09 Thread Ted Fines
Hi, I've setup an Apache 2.2.3, PHP 5.2.0, MySQL 5.0.27 on a Solaris 9 system. The install appeared to go well. To test the Apache/PHP/MySQL integration, I added a simple test.php to the Apache document folder, consisting of: ?php phpinfo(); ? When I access the URL/test.php, it displays as

[PHP-DB] MYSQL_CONNECT vs MYSQL_PCONNECT

2006-06-20 Thread Juanjo Pascual
How can i know which of both is better to use each time? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql_connect($server,$user,$password);

2005-07-27 Thread Chuck Han
Much of the password discussion I've seen revolves around encrypting the user-supplied password, but what about the user/password used to make the initial connection? In other words, I'm assuming that the .php file has the initial user and password right in the text in order to make the

RE: [PHP-DB] mysql_connect($server,$user,$password);

2005-07-27 Thread Miguel Guirao
there is no problem with those parameters used to connect to the DB Chicolinux -Original Message- From: Chuck Han [mailto:[EMAIL PROTECTED] Sent: MiƩrcoles, 27 de Julio de 2005 03:41 p.m. To: php-db@lists.php.net Subject: [PHP-DB] mysql_connect($server,$user,$password); Much of the password discussion

[PHP-DB] mysql_connect() with a multi-file format

2005-06-22 Thread Doug Hernandez
I'm new to PHP, due to having been all hard-nosed and obtuse about using Perl/CGI. I've been looking for a good way to pick up php tricks and what-nots, so I joined the list. That said, I have an immediate question. I have a multi-file script: main.php requires_once config.php, and so on. I'd

Re: [PHP-DB] mysql_connect() with a multi-file format

2005-06-22 Thread Chris Ramsay
I read in the php.net manual that the connection closes automatically when the script exits. Does this mean I can't open a db connection in one file and pass the link around from function to function? No, the script you include becomes part of the main script calling the inclusion, therefore

Re: [PHP-DB] mysql_connect dies silently

2004-09-14 Thread Mulo Emmanuel
Did not see any attachment...? The upgrade might have been the problem. You might need to recompile or reinstall php... Christian Schlaefcke wrote: This looks like it is enabled. I recently upgraded mysql to version 4.1.4. Maybe this causes the problem. Do I have to reinstall PHP it is still

[PHP-DB] mysql_connect dies silently

2004-09-13 Thread Christian Schlaefcke
Hi Folks, I have a problem getting a php script running. It seems that the script just dies when calling the function mysql_connect(host, username, passwd). I put two debugging echoes (one in front and one afterwards) in the script but only the first one appears. There are no errormessages. How

Re: [PHP-DB] mysql_connect dies silently

2004-09-13 Thread Mark Boyle
If you have access to your php.ini file, take a look for the Error Reporting settings. It may be set to none, to to log the errors to syslogd or a file. Mark On Mon, 13 Sep 2004 12:48:33 +0200, Christian Schlaefcke [EMAIL PROTECTED] wrote: Hi Folks, I have a problem getting a php script

Re: [PHP-DB] mysql_connect dies silently

2004-09-13 Thread Christian Schlaefcke
This is what I have in my php.ini error_reporting = E_ALL display_errors = On display_startup_errors = On log_errors = On log_errors_max_len = 1024 ignore_repeated_errors = Off ignore_repeated_source = Off report_memleaks = On track_errors = On html_errors = On Tried both: error_log =

Re: [PHP-DB] mysql_connect dies silently

2004-09-13 Thread John Holmes
From: Christian Schlaefcke [EMAIL PROTECTED] This is what I have in my php.ini error_reporting = E_ALL display_errors = On Have you looked at a phpinfo() page to ensure you're editing the correct php.ini? ?php phpinfo(); ? In the first block, it tells you what php.ini file PHP is using. If it

Re: [PHP-DB] mysql_connect dies silently

2004-09-13 Thread Christian Schlaefcke
Am Mo, den 13.09.2004 um 9:27 Uhr -0400 schrieb John Holmes: From: Christian Schlaefcke [EMAIL PROTECTED] This is what I have in my php.ini error_reporting = E_ALL display_errors = On Have you looked at a phpinfo() page to ensure you're editing the correct php.ini? ?php

Re: [PHP-DB] mysql_connect dies silently

2004-09-13 Thread Mulo Emmanuel
Look at the phpinfo() page and see whether you find a section with information on MySQL. If it isnt there, it is likely to do with the way you compiled AMP. Christian Schlaefcke wrote: Am Mo, den 13.09.2004 um 9:27 Uhr -0400 schrieb John Holmes: From: Christian Schlaefcke [EMAIL PROTECTED]

Re: [PHP-DB] mysql_connect dies silently

2004-09-13 Thread Christian Schlaefcke
This looks like it is enabled. I recently upgraded mysql to version 4.1.4. Maybe this causes the problem. Do I have to reinstall PHP it is still the version I got with the installation of my distro (Fedora Core 2). I attached what phpinfo produced... Am Mo, den 13.09.2004 um 17:20 Uhr +0300

[PHP-DB] mysql_connect problem

2004-02-02 Thread DiZEM PGC
I try connecting to an existing mysql DB. The first time I directly called mysql_connect with all required params (Path/Database,User,Password) and established a connection without problems. Second time I have used a script that includes a self-written class containing a few Database functions.

Re: [PHP-DB] mysql_connect problem

2004-02-02 Thread Miles Thompson
At 03:42 PM 2/2/2004 +0100, DiZEM PGC wrote: I try connecting to an existing mysql DB. The first time I directly called mysql_connect with all required params (Path/Database,User,Password) and established a connection without problems. Second time I have used a script that includes a self-written

[PHP-DB] @mysql_connect freezes

2004-01-22 Thread Jim Deas
Hi, I am trying to find a problem with my sql connection now that I have split my sql server from the apache server. (Chain of Events) 1. Copied working web page with php sql commands to a new web server 2. Added apache server/username to new sql servers database auth. 3. Made sure that server,

[PHP-DB] mysql_connect error

2003-06-10 Thread Sparky Kopetzky
Good afternoon! I have Apache w/php installed on one server. I have mysql installed on a windows machine. I keep getting this error 'Call to undefined function: mysql_connect()' in my php script. Now, according to what the Redhat RPM is telling me about php-mysql is that I have to have mysql

Re: [PHP-DB] mysql_connect error

2003-06-10 Thread CPT John W. Holmes
PHP was not compiled with MySQL support. Re-compile. ---John Holmes... - Original Message - From: Sparky Kopetzky [EMAIL PROTECTED] To: PHP DB Group [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:35 PM Subject: [PHP-DB] mysql_connect error Good afternoon! I have Apache w/php

Re: [PHP-DB] mysql_connect error

2003-06-10 Thread Sparky Kopetzky
Subject: Re: [PHP-DB] mysql_connect error PHP was not compiled with MySQL support. Re-compile. ---John Holmes... - Original Message - From: Sparky Kopetzky [EMAIL PROTECTED] To: PHP DB Group [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:35 PM Subject: [PHP-DB] mysql_connect error

Re: [PHP-DB] mysql_connect error

2003-06-10 Thread Rasmus Lerdorf
You have to load the extension in your php.ini file. eg. extension=mysql.so -Rasmus On Tue, 10 Jun 2003, Sparky Kopetzky wrote: Good afternoon! I have Apache w/php installed on one server. I have mysql installed on a windows machine. I keep getting this error 'Call to undefined

[PHP-DB] mysql_connect() -- flags

2003-06-01 Thread Armand Turpel
Hi, Is there any body who have experience with the flags in mysql_connect() in php = 4.3 . Especially the MYSQL_CLIENT_COMPRESS flag. I dont know if it works or not. I cant make any difference in performance tests on localhost. Should php must be compiled with a special flag to get work this?

[PHP-DB] mysql_connect() problem

2003-03-17 Thread Indrajit Paul
Hi, I am using Apache 2 in Linux 8 .Whenever in my php script I want to connect to mysql through mysql_connect() function a error occured. My script is like that $linlid=mysql_connect(localhost,user1,user1)or die(Connections failed); print Connected successfully; The script writes

Re: [PHP-DB] mysql_connect() problem

2003-03-17 Thread David Smith
You need to install the php-mysql rpm. You can get this on your RedHat CD, or through apt-get: apt-get install php-mysql Get apt here: http://apt.freshrpms.net/ Does the PHP project ever plan to do something as impressive as CPAN so users won't have to reinstall or recompile just to extend its

Re: [PHP-DB] mysql_connect problem rh7.3

2002-11-03 Thread Wouter
Thanks! I was able to get native mysql support by adding extension=mysql.so to php.ini. So now mysql_connect() works John Coder wrote: While Micah is correct, you do have mysql support on php but as a dbs not the built in php fuctions. Therefore you must use the dbx functions instead.

[PHP-DB] mysql_connect problem rh7.3

2002-11-02 Thread Wouter
Hello, I've a rather complete php install on redhat 7.3, yet I cant't get php to connect to mysql. I get: Fatal error: Call to undefined function: mysql_connect() in ... It seems that the necessary packages are installed: [root@axon ~]# rpm -qa | grep php php-4.1.2-7.3.4

Re: [PHP-DB] mysql_connect problem rh7.3

2002-11-02 Thread Micah Stevens
It doesn't appear you have the PHP MySQL functions installed. When you run phpinfo() you should get something like: mysql MySQL Supportenabled Active Persistent Links1 Active Links1 Client API version3.23.39 MYSQL_MODULE_TYPEbuiltin MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_INCLUDE MYSQL_LIBS

Re: [PHP-DB] mysql_connect problem rh7.3

2002-11-02 Thread John Coder
While Micah is correct, you do have mysql support on php but as a dbs not the built in php fuctions. Therefore you must use the dbx functions instead. John Coder On Sat, 2002-11-02 at 14:35, Micah Stevens wrote: It doesn't appear you have the PHP MySQL functions installed. When you run

[PHP-DB] mysql_connect

2002-09-03 Thread Bryan McLemore
I'm trying to connect using the sample code in the php documentation. IT however dies every time. If someone could please help me? Thanks. Bryan

Re: [PHP-DB] MySQL_connect

2002-03-06 Thread Josh Trutwin
On Wednesday 06 March 2002 15:53, [EMAIL PROTECTED] wrote: Hi, I'm new to MySql, when I try to connect my PHP-script with mysql_connect($host, $user, $pass) my script returns the error Fatal error: Call to undefined function: mysql_connect() I have given the user all rights in MySQL,

[PHP-DB] mysql_connect()

2002-02-12 Thread Martin Allan Jensen
Hi all. once again i need help... I tried a lot of stuff but my server (linux) (php 4.0.6) won't use the mysql_connect() command..?? Anyone else have an solution for the problem..?? Kind regards Martin Allan Jensen

RE: [PHP-DB] mysql_connect()

2002-02-12 Thread Rick Emery
)? What is your web server? -Original Message- From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 10:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql_connect() Hi all. once again i need help... I tried a lot of stuff but my server (linux) (php 4.0.6

[PHP-DB] mysql_connect()

2002-02-12 Thread Martin Allan Jensen
Sorry folks, last time i wrote it to fast! Well here is the hole story We got an organisation to install a new version of phpmyadmin, mySQL and PHP 4.0.6 on our Cobalt Raq 4r server (Linux) They got it installed and phpmyadmin is working finebut when i call fro a script souch as

RE: [PHP-DB] mysql_connect()

2002-02-12 Thread Rick Emery
, February 12, 2002 10:26 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql_connect() Sorry folks, last time i wrote it to fast! Well here is the hole story We got an organisation to install a new version of phpmyadmin, mySQL and PHP 4.0.6 on our Cobalt Raq 4r server (Linux) They got

Re: [PHP-DB] mysql_connect()

2002-02-12 Thread Sharif Islam
Check your php install:test.php : ? phpinfo(); ? ) (( ||-. | :|/' -`--'- On Tue, 12 Feb 2002, Martin Allan Jensen wrote: Sorry folks, last time i wrote it to fast! Well here is the hole story We got an organisation to install a new version of phpmyadmin, mySQL and PHP

[PHP-DB] mysql_connect() and phpmyadmin

2002-02-12 Thread Martin Allan Jensen
: Tuesday, February 12, 2002 10:44 AM To: Rick Emery Subject: Re: [PHP-DB] mysql_connect() It wasen't me hwo did it! but why do phpmyadmin work fine then?? Martin - Original Message - From: Rick Emery [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 12, 2002 5:29 PM

[PHP-DB] mysql_connect() fails on redhat!

2001-05-01 Thread Siamak Amirghodsi
Hello, I am using RedHat 7.0 I installed PHP 4 as RPM I installed Mysql as RPM I installed php-mysql.rpm as as RMP When I try to connect to db with mysql_connect(,-,) I get undefined function : mysql_connect Do I have to include any other call for redhat 7.0 and RPM on top of

[PHP-DB] mysql_connect() error

2001-03-25 Thread Chad Schmidt
I'm having problems getting php to interface with mysql on a linux server. I have a Linux Redhat setup and everything has been rpm'ed. Here is the error I get "Fatal error: Call to undefined function: mysql_connect() in /var/www/html/secure/index.php4 on line 4" Thanks in advance, -- PHP

Re: [PHP-DB] mysql_connect() error

2001-03-25 Thread Chad Schmidt
Never mind I figured it out! ""Chad Schmidt"" [EMAIL PROTECTED] wrote in message 99lqi8$u00$[EMAIL PROTECTED]">news:99lqi8$u00$[EMAIL PROTECTED]... I'm having problems getting php to interface with mysql on a linux server. I have a Linux Redhat setup and everything has been rpm'ed. Here is