[PHP-DB] mysql_connect(): Lost connection to MySQL server during query
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 help me out to fix this error. Best Regards, Manoj Kumar SIngh
Re: [PHP-DB] mysql_connect(): Lost connection to MySQL server during query
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 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 help me out to fix this error. Best Regards, Manoj Kumar SIngh -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect() Help
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 = @mysql_connect($hostname,$mysql_login,$mysql_password);
@mysql_select_db($dbname);
With that, the following statement should return any errors that MySQL would
otherwise generate:
if (!$link) {
die (mysql_error());
}
Now, I don't see any reason for the 2nd echo (i.e., echo After connecting
to the database...;) to not be called.
Is it in an if statement or other structure/scope in your actual script?
However, I do see a reason for another to never be called:
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
Once you call die, script execution discontinues.
The echo after it will never be called, either by !$link returning false to
if or by die being called first.
On another note...
This sounds like you have PHP MySQL installed for private use.
But, even if that's the case, I don't recommend connecting to the admin
account unless you really need to.
You should check out the following page on adding users:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
And read up on the following commands:
CREATE USER: http://dev.mysql.com/doc/refman/5.0/en/create-user.html
GRANT: http://dev.mysql.com/doc/refman/5.0/en/grant.html
- Jon L.
On Sat, Mar 8, 2008 at 1:36 PM, Manysh [EMAIL PROTECTED] wrote:
Hi,
I am trying to make a connection to the MySQL database from PHP but it
seems like I am missing a step or something and hence cannot connect
to the database. I have tried everything but I can't figure out why.
Please suggest/help (I am a beginner in PHP/MySQL/Apache).
I am using MySQL 5.0.51a-community-nt on my Windows XP machine. PHP
version used is 5.2 and Apache version is 2.2.
Code Snippet:
$hostname=localhost;
$mysql_login=admin;
$mysql_password=admin;
//$database=sampleapp;
echo Print this...; // THIS MESSAGE IS PRINTED
$link = mysql_connect($hostname,$mysql_login,$mysql_password);
echo After connecting to the database...; // THIS DOES NOT PRINT
if (!$link) {
die (mysql_error()); // NOR THIS ONE
}
$dbname = 'sampleapp';
mysql_select_db($dbname);
echo $link;
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
//echo 'Connected successfully';
mysql_close($link);
?
Any help is appreciated.
Thanks,
Manysh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect() Help
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 database. The echo After
connecting to the database... is not in an if statement. I modified
the script to make it real simple for me
I found this document:
http://www.artfulsoftware.com/php_mysql_win.html which outlines
installation and configuration steps for MySQL and PHP. Unfortunately,
I can't get it to work. One thing I noticed is that my PHP
inatallation didn't have any ext directory so I manually created one
and copied php_mysqli.dll to this directory and restarted my computer.
It didn't work still. Any comments/ideas?
?php
/*- DATABASE CONNECTION INFO-*/
$hostname=localhost;
$mysql_login=admin;
$mysql_password=admin;
echo Connected successfully yet? Probably not.;
$link = @mysql_connect($hostname,$mysql_login,$mysql_password);
if (!$link) {
//die('Could not connect: ' . mysql_error());
echo Some problem here;
}
else
echo Connected?;
$dbname = 'sampleapp';
$dbselect = @mysql_select_db($dbname);
if ($dbselect)
echo Connected to the database;
else
echo Still not connected to the database;
mysql_close($link);
?
On Sat, Mar 8, 2008 at 3:07 PM, Jon L. [EMAIL PROTECTED] wrote:
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 = @mysql_connect($hostname,$mysql_login,$mysql_password);
@mysql_select_db($dbname);
With that, the following statement should return any errors that MySQL would
otherwise generate:
if (!$link) {
die (mysql_error());
}
Now, I don't see any reason for the 2nd echo (i.e., echo After connecting
to the database...;) to not be called.
Is it in an if statement or other structure/scope in your actual script?
However, I do see a reason for another to never be called:
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
Once you call die, script execution discontinues.
The echo after it will never be called, either by !$link returning false to
if or by die being called first.
On another note...
This sounds like you have PHP MySQL installed for private use.
But, even if that's the case, I don't recommend connecting to the admin
account unless you really need to.
You should check out the following page on adding users:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
And read up on the following commands:
CREATE USER: http://dev.mysql.com/doc/refman/5.0/en/create-user.html
GRANT: http://dev.mysql.com/doc/refman/5.0/en/grant.html
- Jon L.
On Sat, Mar 8, 2008 at 1:36 PM, Manysh [EMAIL PROTECTED] wrote:
Hi,
I am trying to make a connection to the MySQL database from PHP but it
seems like I am missing a step or something and hence cannot connect
to the database. I have tried everything but I can't figure out why.
Please suggest/help (I am a beginner in PHP/MySQL/Apache).
I am using MySQL 5.0.51a-community-nt on my Windows XP machine. PHP
version used is 5.2 and Apache version is 2.2.
Code Snippet:
$hostname=localhost;
$mysql_login=admin;
$mysql_password=admin;
//$database=sampleapp;
echo Print this...; // THIS MESSAGE IS PRINTED
$link = mysql_connect($hostname,$mysql_login,$mysql_password);
echo After connecting to the database...; // THIS DOES NOT PRINT
if (!$link) {
die (mysql_error()); // NOR THIS ONE
}
$dbname = 'sampleapp';
mysql_select_db($dbname);
echo $link;
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
//echo 'Connected successfully';
mysql_close($link);
?
Any help is appreciated.
Thanks,
Manysh
--
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
Re: [PHP-DB] mysql_connect() Help
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 directive or two in your php.ini.
something like...
[PHP_MYSQL]
extension=php_mysql.dll
but there may be some other directives you are missing - port numbers, etc.
best to just reinstall.
-- matt
On Sat, Mar 8, 2008 at 5:53 PM, Manysh [EMAIL PROTECTED] wrote:
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 database. The echo After
connecting to the database... is not in an if statement. I modified
the script to make it real simple for me
I found this document:
http://www.artfulsoftware.com/php_mysql_win.html which outlines
installation and configuration steps for MySQL and PHP. Unfortunately,
I can't get it to work. One thing I noticed is that my PHP
inatallation didn't have any ext directory so I manually created one
and copied php_mysqli.dll to this directory and restarted my computer.
It didn't work still. Any comments/ideas?
?php
/*- DATABASE CONNECTION INFO-*/
$hostname=localhost;
$mysql_login=admin;
$mysql_password=admin;
echo Connected successfully yet? Probably not.;
$link = @mysql_connect($hostname,$mysql_login,$mysql_password);
if (!$link) {
//die('Could not connect: ' . mysql_error());
echo Some problem here;
}
else
echo Connected?;
$dbname = 'sampleapp';
$dbselect = @mysql_select_db($dbname);
if ($dbselect)
echo Connected to the database;
else
echo Still not connected to the database;
mysql_close($link);
?
On Sat, Mar 8, 2008 at 3:07 PM, Jon L. [EMAIL PROTECTED] wrote:
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 = @mysql_connect($hostname,$mysql_login,$mysql_password);
@mysql_select_db($dbname);
With that, the following statement should return any errors that MySQL
would
otherwise generate:
if (!$link) {
die (mysql_error());
}
Now, I don't see any reason for the 2nd echo (i.e., echo After
connecting
to the database...;) to not be called.
Is it in an if statement or other structure/scope in your actual script?
However, I do see a reason for another to never be called:
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
Once you call die, script execution discontinues.
The echo after it will never be called, either by !$link returning false
to
if or by die being called first.
On another note...
This sounds like you have PHP MySQL installed for private use.
But, even if that's the case, I don't recommend connecting to the admin
account unless you really need to.
You should check out the following page on adding users:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
And read up on the following commands:
CREATE USER: http://dev.mysql.com/doc/refman/5.0/en/create-user.html
GRANT: http://dev.mysql.com/doc/refman/5.0/en/grant.html
- Jon L.
On Sat, Mar 8, 2008 at 1:36 PM, Manysh [EMAIL PROTECTED] wrote:
Hi,
I am trying to make a connection to the MySQL database from PHP but it
seems like I am missing a step or something and hence cannot connect
to the database. I have tried everything but I can't figure out why.
Please suggest/help (I am a beginner in PHP/MySQL/Apache).
I am using MySQL 5.0.51a-community-nt on my Windows XP machine. PHP
version used is 5.2 and Apache version is 2.2.
Code Snippet:
$hostname=localhost;
$mysql_login=admin;
$mysql_password=admin;
//$database=sampleapp;
echo Print this...; // THIS MESSAGE IS PRINTED
$link = mysql_connect($hostname,$mysql_login,$mysql_password);
echo After connecting to the database...; // THIS DOES NOT PRINT
if (!$link) {
die (mysql_error()); // NOR THIS ONE
}
$dbname = 'sampleapp';
mysql_select_db($dbname);
echo $link;
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
//echo 'Connected successfully';
mysql_close($link);
?
Any help is appreciated.
Thanks,
Manysh
--
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
Re: [PHP-DB] mysql_connect() Help
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/ folder, just not where you were thinking it'd
be.
And, the extension may be commented out (semicolon at the beginning of the
line).
Theoretically, you should've recieved an undefined function error if it
was commented.
If the folder that extension_dir points to is empty or undefined, then I'd
say go download the Windows ZIP and rebuild the folder.
As for the script, do you have an example output?
If you're up for it, I wrote test script that outputs a few more details.
?php
header('Content-type: text/plain');
$hostname = 'localhost';
$mysql_login = 'admin';
$mysql_password = 'admin';
$dbname = 'sampleapp';
echo PHP: . phpversion() . \n\n;
echo Connecting to (MySQL) $hostname (user: $mysql_login)\n;
$link = @mysql_connect($hostname, $mysql_login, $mysql_password);
echo \n;
echo Status: . serialize($link) . ($link)\n;
echo Error : ' . mysql_error() . ' ( . mysql_errno() . )\n;
echo \n;
echo Server: . @mysql_get_server_info() . \n;
echo Host : . @mysql_get_host_info() . \n;
echo \n;
echo Select database `$dbname`\n;
$dbselect = @mysql_select_db($dbname);
echo \n;
echo Status: . serialize($dbselect) . ($dbselect)\n;
echo Error : ' . mysql_error() . ' ( . mysql_errno() . )\n;
echo \n;
echo Closing connection\n;
$dbclose = @mysql_close($link);
echo \n;
echo Status: . serialize($dbclose) . ($dbclose)\n;
echo Error : ' . mysql_error() . ' ( . mysql_errno() . )\n;
?
The output should be something like this:
PHP: 5.2.5
Connecting to (MySQL) localhost (user: admin)
Status: i:0; (Resource id #2)
Error : '' (0)
Server: 5.0.45-community-nt
Host : localhost via TCP/IP
Select database `sampleapp`
Status: b:1; (1)
Error : '' (0)
Closing connection
Status: b:1; (1)
Error : '' ()
- Jon L.
On Sat, Mar 8, 2008 at 5:53 PM, Manysh [EMAIL PROTECTED] wrote:
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 database. The echo After
connecting to the database... is not in an if statement. I modified
the script to make it real simple for me
I found this document:
http://www.artfulsoftware.com/php_mysql_win.html which outlines
installation and configuration steps for MySQL and PHP. Unfortunately,
I can't get it to work. One thing I noticed is that my PHP
inatallation didn't have any ext directory so I manually created one
and copied php_mysqli.dll to this directory and restarted my computer.
It didn't work still. Any comments/ideas?
?php
/*- DATABASE CONNECTION INFO-*/
$hostname=localhost;
$mysql_login=admin;
$mysql_password=admin;
echo Connected successfully yet? Probably not.;
$link = @mysql_connect($hostname,$mysql_login,$mysql_password);
if (!$link) {
//die('Could not connect: ' . mysql_error());
echo Some problem here;
}
else
echo Connected?;
$dbname = 'sampleapp';
$dbselect = @mysql_select_db($dbname);
if ($dbselect)
echo Connected to the database;
else
echo Still not connected to the database;
mysql_close($link);
?
On Sat, Mar 8, 2008 at 3:07 PM, Jon L. [EMAIL PROTECTED] wrote:
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 = @mysql_connect($hostname,$mysql_login,$mysql_password);
@mysql_select_db($dbname);
With that, the following statement should return any errors that MySQL
would
otherwise generate:
if (!$link) {
die (mysql_error());
}
Now, I don't see any reason for the 2nd echo (i.e., echo After
connecting
to the database...;) to not be called.
Is it in an if statement or other structure/scope in your actual script?
However, I do see a reason for another to never be called:
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
Once you call die, script execution discontinues.
The echo after it will never be called, either by !$link returning false
to
if or by die being called first.
On another note...
This sounds like you have PHP MySQL installed for private use.
But, even if that's the case, I don't recommend
Re: [PHP-DB] mysql_connect() Help
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 from the Apache side now? I have configured
http.conf too... is there anything else I need to take care of?
Thanks
?php
/*- DATABASE CONNECTION INFO-*/
$hostname=localhost;
$mysql_login=testuser;
$mysql_password=testuser;
echo Connected successfully yet? Probably not.;
$link = @mysql_connect($hostname,$mysql_login,$mysql_password);
if (!$link) {
//die('Could not connect: ' . mysql_error());
echo Some problem here;
}
else
echo Connected?;
$dbname = 'sampleapp';
$dbselect = @mysql_select_db($dbname);
if ($dbselect)
echo Connected to the database;
else
echo Still not connected to the database;
mysql_close($link);
?
On Sat, Mar 8, 2008 at 7:22 PM, Matt Anderton [EMAIL PROTECTED] wrote:
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 directive or two in your php.ini.
something like...
[PHP_MYSQL]
extension=php_mysql.dll
but there may be some other directives you are missing - port numbers, etc.
best to just reinstall.
-- matt
On Sat, Mar 8, 2008 at 5:53 PM, Manysh [EMAIL PROTECTED] wrote:
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 database. The echo After
connecting to the database... is not in an if statement. I modified
the script to make it real simple for me
I found this document:
http://www.artfulsoftware.com/php_mysql_win.html which outlines
installation and configuration steps for MySQL and PHP. Unfortunately,
I can't get it to work. One thing I noticed is that my PHP
inatallation didn't have any ext directory so I manually created one
and copied php_mysqli.dll to this directory and restarted my computer.
It didn't work still. Any comments/ideas?
?php
/*- DATABASE CONNECTION INFO-*/
$hostname=localhost;
$mysql_login=admin;
$mysql_password=admin;
echo Connected successfully yet? Probably not.;
$link = @mysql_connect($hostname,$mysql_login,$mysql_password);
if (!$link) {
//die('Could not connect: ' . mysql_error());
echo Some problem here;
}
else
echo Connected?;
$dbname = 'sampleapp';
$dbselect = @mysql_select_db($dbname);
if ($dbselect)
echo Connected to the database;
else
echo Still not connected to the database;
mysql_close($link);
?
On Sat, Mar 8, 2008 at 3:07 PM, Jon L. [EMAIL PROTECTED] wrote:
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 = @mysql_connect($hostname,$mysql_login,$mysql_password);
@mysql_select_db($dbname);
With that, the following statement should return any errors that MySQL
would
otherwise generate:
if (!$link) {
die (mysql_error());
}
Now, I don't see any reason for the 2nd echo (i.e., echo After
connecting
to the database...;) to not be called.
Is it in an if statement or other structure/scope in your actual script?
However, I do see a reason for another to never be called:
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
Once you call die, script execution discontinues.
The echo after it will never be called, either by !$link returning false
to
if or by die being called first.
On another note...
This sounds like you have PHP MySQL installed for private use.
But, even if that's the case, I don't recommend connecting to the admin
account unless you really need to.
You should check out the following page on adding users:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
And read up on the following commands:
CREATE USER: http://dev.mysql.com/doc/refman/5.0/en/create-user.html
GRANT: http://dev.mysql.com/doc/refman/5.0/en/grant.html
- Jon L.
On Sat, Mar 8, 2008 at 1:36 PM, Manysh [EMAIL PROTECTED] wrote:
Hi,
I am trying to make a connection to the MySQL database from PHP but it
seems like I am
Re: [PHP-DB] mysql_connect() Help
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 [EMAIL PROTECTED] wrote:
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 from the Apache side now? I have configured
http.conf too... is there anything else I need to take care of?
Thanks
?php
/*- DATABASE CONNECTION INFO-*/
$hostname=localhost;
$mysql_login=testuser;
$mysql_password=testuser;
echo Connected successfully yet? Probably not.;
$link = @mysql_connect($hostname,$mysql_login,$mysql_password);
if (!$link) {
//die('Could not connect: ' . mysql_error());
echo Some problem here;
}
else
echo Connected?;
$dbname = 'sampleapp';
$dbselect = @mysql_select_db($dbname);
if ($dbselect)
echo Connected to the database;
else
echo Still not connected to the database;
mysql_close($link);
?
On Sat, Mar 8, 2008 at 7:22 PM, Matt Anderton [EMAIL PROTECTED]
wrote:
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 directive or two in your
php.ini.
something like...
[PHP_MYSQL]
extension=php_mysql.dll
but there may be some other directives you are missing - port numbers,
etc.
best to just reinstall.
-- matt
On Sat, Mar 8, 2008 at 5:53 PM, Manysh [EMAIL PROTECTED] wrote:
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 database. The echo After
connecting to the database... is not in an if statement. I modified
the script to make it real simple for me
I found this document:
http://www.artfulsoftware.com/php_mysql_win.html which outlines
installation and configuration steps for MySQL and PHP. Unfortunately,
I can't get it to work. One thing I noticed is that my PHP
inatallation didn't have any ext directory so I manually created one
and copied php_mysqli.dll to this directory and restarted my computer.
It didn't work still. Any comments/ideas?
?php
/*- DATABASE CONNECTION INFO-*/
$hostname=localhost;
$mysql_login=admin;
$mysql_password=admin;
echo Connected successfully yet? Probably not.;
$link = @mysql_connect($hostname,$mysql_login,$mysql_password);
if (!$link) {
//die('Could not connect: ' . mysql_error());
echo Some problem here;
}
else
echo Connected?;
$dbname = 'sampleapp';
$dbselect = @mysql_select_db($dbname);
if ($dbselect)
echo Connected to the database;
else
echo Still not connected to the database;
mysql_close($link);
?
On Sat, Mar 8, 2008 at 3:07 PM, Jon L. [EMAIL PROTECTED] wrote:
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 = @mysql_connect($hostname,$mysql_login,$mysql_password);
@mysql_select_db($dbname);
With that, the following statement should return any errors that
MySQL
would
otherwise generate:
if (!$link) {
die (mysql_error());
}
Now, I don't see any reason for the 2nd echo (i.e., echo After
connecting
to the database...;) to not be called.
Is it in an if statement or other structure/scope in your actual
script?
However, I do see a reason for another to never be called:
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
Once you call die, script execution discontinues.
The echo after it will never be called, either by !$link returning
false
to
if or by die being called first.
On another note...
This sounds like you have PHP MySQL installed for private use.
But, even if that's the case, I don't recommend connecting to the
admin
account unless you really need to.
You should check out the
Re: [PHP-DB] mysql_connect() Help
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:
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 [EMAIL PROTECTED] wrote:
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 from the Apache side now? I have configured
http.conf too... is there anything else I need to take care of?
Thanks
?php
/*- DATABASE CONNECTION INFO-*/
$hostname=localhost;
$mysql_login=testuser;
$mysql_password=testuser;
echo Connected successfully yet? Probably not.;
$link = @mysql_connect($hostname,$mysql_login,$mysql_password);
if (!$link) {
//die('Could not connect: ' . mysql_error());
echo Some problem here;
}
else
echo Connected?;
$dbname = 'sampleapp';
$dbselect = @mysql_select_db($dbname);
if ($dbselect)
echo Connected to the database;
else
echo Still not connected to the database;
mysql_close($link);
?
On Sat, Mar 8, 2008 at 7:22 PM, Matt Anderton [EMAIL PROTECTED] wrote:
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 directive or two in your
php.ini.
something like...
[PHP_MYSQL]
extension=php_mysql.dll
but there may be some other directives you are missing - port numbers,
etc.
best to just reinstall.
-- matt
On Sat, Mar 8, 2008 at 5:53 PM, Manysh [EMAIL PROTECTED] wrote:
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 database. The echo After
connecting to the database... is not in an if statement. I modified
the script to make it real simple for me
I found this document:
http://www.artfulsoftware.com/php_mysql_win.html which outlines
installation and configuration steps for MySQL and PHP. Unfortunately,
I can't get it to work. One thing I noticed is that my PHP
inatallation didn't have any ext directory so I manually created one
and copied php_mysqli.dll to this directory and restarted my computer.
It didn't work still. Any comments/ideas?
?php
/*- DATABASE CONNECTION INFO-*/
$hostname=localhost;
$mysql_login=admin;
$mysql_password=admin;
echo Connected successfully yet? Probably not.;
$link = @mysql_connect($hostname,$mysql_login,$mysql_password);
if (!$link) {
//die('Could not connect: ' . mysql_error());
echo Some problem here;
}
else
echo Connected?;
$dbname = 'sampleapp';
$dbselect = @mysql_select_db($dbname);
if ($dbselect)
echo Connected to the database;
else
echo Still not connected to the database;
mysql_close($link);
?
On Sat, Mar 8, 2008 at 3:07 PM, Jon L. [EMAIL PROTECTED] wrote:
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 = @mysql_connect($hostname,$mysql_login,$mysql_password);
@mysql_select_db($dbname);
With that, the following statement should return any errors that
MySQL
would
otherwise generate:
if (!$link) {
die (mysql_error());
}
Now, I don't see any reason for the 2nd echo (i.e., echo After
connecting
to the database...;) to not be called.
Is it in an if statement or other structure/scope in your actual
script?
However, I do see a reason for another to never be called:
if (!$link) {
die('Could not connect: ' . mysql_error());
echo Some problem here;
}
Once you call die,
[PHP-DB] mysql_connect problem
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 expected. That is, I see the
PHP version, date, configure command and detail about all of the modules,
including curl, gd, IMAP, and MySQL. Looks like a perfectly normal
rendition of phpinfo(). So it looks great, like everything works.
But then I try to load a web app on the server, like SMF or phpBB, they both
tell me that I don't have MySQL configured.
I don't understand why the phpinfo() command would show the MySQL config
info, yet the web apps would think that MySQL was not configured.
So I created another test php file, mysqltest.php, with these lines:
?php
$link = mysql_connect('localhost', 'testuser', '***');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?
Now, as testuser, I can login to the database using the command line mysql
-u testuser -p and entering the password.
But when I try accessing the above file, I get no output in the browser, but
in the apache errlog file, I get:
PHP Fatal error: Call to undefined function: mysql_connect() in
/opt/apache-php/apache/htdocs/mysqltest.php on line 2
So it looks like my PHP install just doesn't even know about the
'mysql_connect' function.
extensions_dir = /opt/apache-php/php4/lib/php/extensions, and that dir does
contain the mysql.so file. If I move it out of that folder and rerun
phpinfo(), it displays without showing any MySQL config data.
Any help? I'm just stuck! My directive for MySQL inclusion for the PHP
./configure command was:
--with-mysql=shared,$BLIB/mysql
...where $BLIB was set to /opt/apache-php/libs
Thanks,
Ted
[PHP-DB] MYSQL_CONNECT vs MYSQL_PCONNECT
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);
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 connection. Is there a way around this, because it seems very insecure to me that these parameters would be in the .php source. Or is the .php source supposedly not readable? thanks, Chuck -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql_connect($server,$user,$password);
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 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 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 connection. Is there a way around this, because it seems very insecure to me that these parameters would be in the .php source. Or is the .php source supposedly not readable? thanks, Chuck -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion estrictamente confidencial y legalmente protegida, cuya divulgacion es sancionada por la ley. Si el lector de este mensaje no es a quien esta dirigido, ni se trata del empleado o agente responsable de esta informacion, se le notifica por medio del presente, que su reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio este comunicado por error, favor de notificarlo inmediatamente al remitente y destruir el mensaje. Todas las opiniones contenidas en este mail son propias del autor del mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos. This message is for the sole use of the person or entity to whom it is being sent. Therefore, it contains strictly confidential and legally protected material whose disclosure is subject to penalty by law. If the person reading this message is not the one to whom it is being sent and/or is not an employee or the responsible agent for this information, this person is herein notified that any unauthorized dissemination, distribution or copying of the materials included in this facsimile is strictly prohibited. If you received this document by mistake please notify immediately to the subscriber and destroy the message. Any opinions contained in this e-mail are those of the author of the message and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries companies. No part of this message or attachments may be used or reproduced in any manner whatsoever. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql_connect() with a multi-file format
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 like to have a data.php file that handles function wrappers for database and also establishes a connection to the db. 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? ie: require_once 'data.php'; // data.php contains a mysql_connect() // after this line, is my link closed? require_once 'blah.php' ; OR: require_once 'data.php'; // with wrapper data_connection() $save_this_link = data_connection() ; // will this work? some_function( $save_this_link ) ; //etc. -- Douglas Hernandez (612) 229-9684 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect() with a multi-file format
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 the connection stays open 'til you explicitly close it, or your main script exits. cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect dies silently
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 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 schrieb 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] 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 just lists a directory, then that's where PHP expects to find the php.ini file. ---John Holmes... Yupp! And its 'is' the correct one. -- 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] mysql_connect dies silently
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 can I debug this problem? PHP Version 4.3.8 Option --with-mysql=shared,/usr is set. Thanks Regards, Christian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect dies silently
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 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 can I debug this problem? PHP Version 4.3.8 Option --with-mysql=shared,/usr is set. Thanks Regards, Christian -- 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
Re: [PHP-DB] mysql_connect dies silently
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 = /var/log/php_err.log error_log = syslog Nothing appears in /var/log/messages (Yes Im using Linux) nor in /var/ log/php_err.log Even on the page still no errors get displayed. Regards, Chris Am Mo, den 13.09.2004 um 13:29 Uhr +0100 schrieb 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 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 can I debug this problem? PHP Version 4.3.8 Option --with-mysql=shared,/usr is set. Thanks Regards, Christian -- 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
Re: [PHP-DB] mysql_connect dies silently
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 just lists a directory, then that's where PHP expects to find the php.ini file. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect dies silently
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 phpinfo(); ? In the first block, it tells you what php.ini file PHP is using. If it just lists a directory, then that's where PHP expects to find the php.ini file. ---John Holmes... Yupp! And its 'is' the correct one. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect dies silently
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] 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 just lists a directory, then that's where PHP expects to find the php.ini file. ---John Holmes... Yupp! And its 'is' the correct one. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect dies silently
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 schrieb 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] 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 just lists a directory, then that's where PHP expects to find the php.ini file. ---John Holmes... Yupp! And its 'is' the correct one. -- 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] mysql_connect problem
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. One of these functions, named 'db_login', does exactly the same as mysql_connect (w. the same params). First case (directly calling) works fine. The second case doesn't report any error and doesn't establish a connection. What could be the reason for this strange behavior ? DiZEM -- GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...) jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ http://www.gmx.net/derspiegel +++ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect problem
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 class containing a few Database functions. One of these functions, named 'db_login', does exactly the same as mysql_connect (w. the same params). First case (directly calling) works fine. The second case doesn't report any error and doesn't establish a connection. What could be the reason for this strange behavior ? DiZEM promo crap snipped Echo the mysql_error and mysql_errno as found here: http://www.php.ca/mysql_error Also echo the connect string so you can see exactly what's being sent. I'd bet on a misplaced quotation mark. Cheers - Miles -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] @mysql_connect freezes
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, username, and password work by using mysqlcc on that web server and was able to connect to the database on the sql server. When I try to run the following command $dbcnx = @mysql_connect( new_sqlserver,user_name,passwd) or die(Could not connect: . mysql_error()); php does not get past this line! No errors on the web page it just stops processing the php script.No further output from the script or the web page after this line is processed or sent I enabled syslog in the /etc/php.ini but no messages there. Where else can I check for clues? -- Jim Deas [EMAIL PROTECTED] JAD Systems -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql_connect error
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 RUNNING on the web server just so I can talk to the other windows server. That doesn't make any darned sense!!! PHP runs perfectly on the web server until it hits the mysql code. What am I missing here as I'm REALLY dumb when it comes to Linux. Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net
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 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 RUNNING on the web server just so I can talk to the other windows server. That doesn't make any darned sense!!! PHP runs perfectly on the web server until it hits the mysql code. What am I missing here as I'm REALLY dumb when it comes to Linux. Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect error
Says right here from phpinfo under configure command: '--with-mysql=shared,/usr' So it HAS to be in there... Robin - Original Message - From: CPT John W. Holmes [EMAIL PROTECTED] To: Sparky Kopetzky [EMAIL PROTECTED]; PHP DB Group [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 13:48 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 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 RUNNING on the web server just so I can talk to the other windows server. That doesn't make any darned sense!!! PHP runs perfectly on the web server until it hits the mysql code. What am I missing here as I'm REALLY dumb when it comes to Linux. Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect error
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 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 RUNNING on the web server just so I can talk to the other windows server. That doesn't make any darned sense!!! PHP runs perfectly on the web server until it hits the mysql code. What am I missing here as I'm REALLY dumb when it comes to Linux. Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql_connect() -- flags
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? Thanks Armand -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql_connect() problem
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 this. % Fatal error: Call to undefined function: mysql_connect() Please help me.I have installed Apache and php through RPM. Anybody can help me. Indrajit _ Get more buddies in your list. Win prizes http://messenger.msn.co.in/promo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect() problem
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 functionality? --Dave quote who=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 this. % Fatal error: Call to undefined function: mysql_connect() Please help me.I have installed Apache and php through RPM. Anybody can help me. Indrajit _ Get more buddies in your list. Win prizes http://messenger.msn.co.in/promo -- 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
Re: [PHP-DB] mysql_connect problem rh7.3
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. 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 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 The command I've always used for this during compile time is --with-mysql without any options. I'm not sure what =shared, /tmp does, but apparently it's not doing the trick. -Micah At 03:32 PM 11/2/2002 +0100, Wouter wrote: 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: [rootaxon ~]# rpm -qa | grep php php-4.1.2-7.3.4 php-mysql-4.1.2-7.3.4 asp2php-0.76.2-1 php-devel-4.1.2-7.3.4 php-ldap-4.1.2-7.3.4 php-imap-4.1.2-7.3.4 [rootaxon ~]# rpm -qa | gi mysql mysql-3.23.49-3 mysql-server-3.23.49-3 php-mysql-4.1.2-7.3.4 mysql-devel-3.23.49-3 mysqlclient9-3.23.22-6 I've attached the start of phpinfo() at the end... Any ideas? Maybe php.ini needs some change, but I can't figure which one.. Thanks, Wouter PHP Version 4.1.2 System Linux stripples.devel.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 06:41:59 EDT 2002 i686 unknown Build Date Aug 21 2002 Configure Command './configure' 'i386-redhat-linux' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--prefix=/usr' '--with-config-file-path=/etc' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-mm' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-debugger' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mbstring' '--enable-mbstr-enc-trans' '--with-apxs=/usr/sbin/apxs' snip dbx dbx support enabled dbx version 1.0.0 supported databases MySQLbr /ODBCbr /PostgreSQLbr /Microsoft SQL Serverbr /FrontBase -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql_connect problem rh7.3
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 php-mysql-4.1.2-7.3.4 asp2php-0.76.2-1 php-devel-4.1.2-7.3.4 php-ldap-4.1.2-7.3.4 php-imap-4.1.2-7.3.4 [root@axon ~]# rpm -qa | gi mysql mysql-3.23.49-3 mysql-server-3.23.49-3 php-mysql-4.1.2-7.3.4 mysql-devel-3.23.49-3 mysqlclient9-3.23.22-6 I've attached the start of phpinfo() at the end... Any ideas? Maybe php.ini needs some change, but I can't figure which one.. Thanks, Wouter PHP Version 4.1.2 System Linux stripples.devel.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 06:41:59 EDT 2002 i686 unknown Build Date Aug 21 2002 Configure Command './configure' 'i386-redhat-linux' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--prefix=/usr' '--with-config-file-path=/etc' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-mm' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-debugger' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mbstring' '--enable-mbstr-enc-trans' '--with-apxs=/usr/sbin/apxs' Server API Apache Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php.ini ZEND_DEBUG disabled Thread Safety disabled Zend logo This program makes use of the Zend Scripting Language Engine: Zend Engine v1.1.1, Copyright (c) 1998-2001 Zend Technologies PHP 4.0 Credits Configuration PHP Core Directive Local Value Master Value allow_call_time_pass_reference On On allow_url_fopen 1 1 always_populate_raw_post_data 0 0 arg_separator.input arg_separator.output asp_tags Off Off auto_append_file no value no value auto_prepend_file no value no value browscap no value no value default_charset no value no value default_mimetype text/html text/html define_syslog_variables Off Off disable_functions no value no value display_errors On On display_startup_errors Off Off doc_root no value no value enable_dl On On error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting 2039 2039 expose_php On On extension_dir /usr/lib/php4 /usr/lib/php4 file_uploads no value no value gpc_order GPC GPC highlight.bg #FF #FF highlight.comment #FF9900 #FF9900 highlight.default #CC #CC highlight.html #00 #00 highlight.keyword #006600 #006600 highlight.string #CC #CC html_errors On On ignore_user_abort Off Off implicit_flush Off Off include_path .:/usr/share/pear .:/usr/share/pear log_errors Off Off magic_quotes_gpc On On magic_quotes_runtime Off Off magic_quotes_sybase Off Off max_execution_time 30 30 memory_limit 8M 8M open_basedir no value no value output_buffering no value no value output_handler no value no value post_max_size 8M 8M precision 14 14 register_argc_argv On On register_globals On On safe_mode Off Off safe_mode_exec_dir no value no value safe_mode_gid Off Off safe_mode_include_dir no value no value sendmail_from [EMAIL PROTECTED] [EMAIL PROTECTED] sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i short_open_tag On On SMTP localhost localhost sql.safe_mode Off Off track_errors Off Off upload_max_filesize 2M 2M upload_tmp_dir no value no value user_dir no value no value variables_order EGPCS EGPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance Off Off yp YP Support enabled xml XML Support active XML Namespace Support active EXPAT Version expat_1.95.2 wddx WDDX Support enabled WDDX Session Serializer enabled standard Regex Library System library enabled Dynamic Library Support enabled Path to sendmail
Re: [PHP-DB] mysql_connect problem rh7.3
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 The command I've always used for this during compile time is --with-mysql without any options. I'm not sure what =shared, /tmp does, but apparently it's not doing the trick. -Micah At 03:32 PM 11/2/2002 +0100, Wouter wrote: 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 php-mysql-4.1.2-7.3.4 asp2php-0.76.2-1 php-devel-4.1.2-7.3.4 php-ldap-4.1.2-7.3.4 php-imap-4.1.2-7.3.4 [root@axon ~]# rpm -qa | gi mysql mysql-3.23.49-3 mysql-server-3.23.49-3 php-mysql-4.1.2-7.3.4 mysql-devel-3.23.49-3 mysqlclient9-3.23.22-6 I've attached the start of phpinfo() at the end... Any ideas? Maybe php.ini needs some change, but I can't figure which one.. Thanks, Wouter PHP Version 4.1.2 System Linux stripples.devel.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 06:41:59 EDT 2002 i686 unknown Build Date Aug 21 2002 Configure Command './configure' 'i386-redhat-linux' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--prefix=/usr' '--with-config-file-path=/etc' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-mm' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-debugger' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mbstring' '--enable-mbstr-enc-trans' '--with-apxs=/usr/sbin/apxs' Server API Apache Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php.ini ZEND_DEBUG disabled Thread Safety disabled Zend logo This program makes use of the Zend Scripting Language Engine: Zend Engine v1.1.1, Copyright (c) 1998-2001 Zend Technologies PHP 4.0 Credits Configuration PHP Core Directive Local Value Master Value allow_call_time_pass_reference On On allow_url_fopen 1 1 always_populate_raw_post_data 0 0 arg_separator.input arg_separator.output asp_tags Off Off auto_append_file no value no value auto_prepend_file no value no value browscap no value no value default_charset no value no value default_mimetype text/html text/html define_syslog_variables Off Off disable_functions no value no value display_errors On On display_startup_errors Off Off doc_root no value no value enable_dl On On error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting 2039 2039 expose_php On On extension_dir /usr/lib/php4 /usr/lib/php4 file_uploads no value no value gpc_order GPC GPC highlight.bg #FF #FF highlight.comment #FF9900 #FF9900 highlight.default #CC #CC highlight.html #00 #00 highlight.keyword #006600 #006600 highlight.string #CC #CC html_errors On On ignore_user_abort Off Off implicit_flush Off Off include_path .:/usr/share/pear .:/usr/share/pear log_errors Off Off magic_quotes_gpc On On magic_quotes_runtime Off Off magic_quotes_sybase Off Off max_execution_time 30 30 memory_limit 8M 8M open_basedir no value no value output_buffering no value no value output_handler no value no value post_max_size 8M 8M precision 14 14 register_argc_argv On On register_globals On On safe_mode Off Off safe_mode_exec_dir no value no value safe_mode_gid Off Off safe_mode_include_dir no value no value sendmail_from [EMAIL PROTECTED] [EMAIL PROTECTED] sendmail_path /usr/sbin/sendmail -t -i
Re: [PHP-DB] mysql_connect problem rh7.3
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 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 The command I've always used for this during compile time is --with-mysql without any options. I'm not sure what =shared, /tmp does, but apparently it's not doing the trick. -Micah At 03:32 PM 11/2/2002 +0100, Wouter wrote: 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: [rootaxon ~]# rpm -qa | grep php php-4.1.2-7.3.4 php-mysql-4.1.2-7.3.4 asp2php-0.76.2-1 php-devel-4.1.2-7.3.4 php-ldap-4.1.2-7.3.4 php-imap-4.1.2-7.3.4 [rootaxon ~]# rpm -qa | gi mysql mysql-3.23.49-3 mysql-server-3.23.49-3 php-mysql-4.1.2-7.3.4 mysql-devel-3.23.49-3 mysqlclient9-3.23.22-6 I've attached the start of phpinfo() at the end... Any ideas? Maybe php.ini needs some change, but I can't figure which one.. Thanks, Wouter PHP Version 4.1.2 System Linux stripples.devel.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 06:41:59 EDT 2002 i686 unknown Build Date Aug 21 2002 Configure Command './configure' 'i386-redhat-linux' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--prefix=/usr' '--with-config-file-path=/etc' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-mm' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-debugger' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mbstring' '--enable-mbstr-enc-trans' '--with-apxs=/usr/sbin/apxs' snip dbx dbx support enabled dbx version 1.0.0 supported databases MySQLbr /ODBCbr /PostgreSQLbr /Microsoft SQL Serverbr /FrontBase -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql_connect
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
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, both on host, DB, tables, and fields This might be easy for you, but I'm stuck..any help / comments are appreciated It means you do not have mysql support in PHP. If you compiled PHP yourself, recompile it to include mysql support. If you installed it via RPM then look for the appropriate RPMs from distro vendor. A great way to check this is to create a simple script called phpinfo.php with just this line in it, place it in your top level web directory: ? phpinfo(); ? Point your browser to http://localhost/phpinfo.php (assuming the computer you are using is your web server) You should see the ./configure command used to compile PHP, look for --with-mysql. Josh -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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) 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()
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)? 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) won't use the mysql_connect() command..?? Anyone else have an solution for the problem..?? Kind regards Martin Allan Jensen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 it installed and phpmyadmin is working finebut when i call fro a script souch as % ? // Connecting, selecting database $link = mysql_connect(127.0.0.10, phpcoder_dk, pdw) or die(Could not connect); print Connected successfully; mysql_select_db(phpcoder_dk) or die(Could not select database); // Performing SQL query $query = SELECT * FROM hits; $result = mysql_query($query) or die(Query failed); ? % The script writes this. % Fatal error: Call to undefined function: mysql_connect() in /home/sites/site2/web/sql.php on line 3 % You can test it at http://www.phpcoder.dk/sql.php I really hope that someone will help me cause i really can't find the problem by myself...! Kind regards Martin Allan Jensen
RE: [PHP-DB] mysql_connect()
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, 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 it installed and phpmyadmin is working finebut when i call fro a script souch as % ? // Connecting, selecting database $link = mysql_connect(127.0.0.10, phpcoder_dk, pdw) or die(Could not connect); print Connected successfully; mysql_select_db(phpcoder_dk) or die(Could not select database); // Performing SQL query $query = SELECT * FROM hits; $result = mysql_query($query) or die(Query failed); ? % The script writes this. % Fatal error: Call to undefined function: mysql_connect() in /home/sites/site2/web/sql.php on line 3 % You can test it at http://www.phpcoder.dk/sql.php I really hope that someone will help me cause i really can't find the problem by myself...! Kind regards Martin Allan Jensen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_connect()
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 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 % ? // Connecting, selecting database $link = mysql_connect(127.0.0.10, phpcoder_dk, pdw) or die(Could not connect); print Connected successfully; mysql_select_db(phpcoder_dk) or die(Could not select database); // Performing SQL query $query = SELECT * FROM hits; $result = mysql_query($query) or die(Query failed); ? % The script writes this. % Fatal error: Call to undefined function: mysql_connect() in /home/sites/site2/web/sql.php on line 3 % You can test it at http://www.phpcoder.dk/sql.php I really hope that someone will help me cause i really can't find the problem by myself...! Kind regards Martin Allan Jensen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql_connect() and phpmyadmin
I just don't understand why phpmyadmin works with it when i can't call it.! I did try with localhost but it won't still work.. PLEASE help i just can't understand it Kind regards Martin -Original Message- From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]] Sent: 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 Subject: RE: [PHP-DB] mysql_connect() 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, 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 it installed and phpmyadmin is working finebut when i call fro a script souch as % ? // Connecting, selecting database $link = mysql_connect(127.0.0.10, phpcoder_dk, pdw) or die(Could not connect); print Connected successfully; mysql_select_db(phpcoder_dk) or die(Could not select database); // Performing SQL query $query = SELECT * FROM hits; $result = mysql_query($query) or die(Query failed); ? % The script writes this. % Fatal error: Call to undefined function: mysql_connect() in /home/sites/site2/web/sql.php on line 3 % You can test it at http://www.phpcoder.dk/sql.php I really hope that someone will help me cause i really can't find the problem by myself...! Kind regards Martin Allan Jensen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql_connect() fails on redhat!
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 my script to make PHP see the mysql ? Does any body know how to make Redhat PHP MYSQL RPM work together? Thanks Siamak, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] mysql_connect() error
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 Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] mysql_connect() error
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 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 Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
