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:

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

2005-07-27 Thread Miguel Guirao
Remember that PHP is a server-side scripting language, so all PHP code is parsed at the server side and you will never see the code but the results, second, the .php files should have permissions that do not allow direct acces to them, but thru the web browser!! So, basically there is no

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

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

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

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

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.

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

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,

RE: [PHP-DB] mysql_connect()

2002-02-12 Thread Rick Emery
What is the exact error you are getting? I'm going to guess something along the lines of unidentified function mysql_connect(). If that's the case, that means you do not have mysql functionality compiled into your web server. Speaking of which: what is your Linux system (RedHat SuSe, etc)?

RE: [PHP-DB] mysql_connect()

2002-02-12 Thread Rick Emery
Re-read my previous email. You do not have mysql functionality compiled into PHP and you web server. The clue is the phrase undefined function: mysql_connect(). How did you load PHP, MYSQL, etc? -Original Message- From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

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

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