Re: [PHP-DB] MySQL connection

That makes complete sense. Thank you Joshua. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Mar 5, 2017, at 6:44 PM, Arneson, Joshua wrote: > > If you have multiple calls to the database that are grouped, definitely > perform them during the same

Re: [PHP-DB] MySQL connection

If you have multiple calls to the database that are grouped, definitely perform them during the same connection session. The bottom line is unless the overhead associated with opening and closing the connection is going to be an issue programmatically, keep connections brief and group your

Re: [PHP-DB] MySQL connection

Ah, thanks for the reply Joshua. Duly noted. So when is it bad to make multiple open and close connections then? I am guessing that could have some impact with lots of users too. Yes? If the website in question does not have a lot of users (less than 1,000), is this still a bad call to keep an

Re: [PHP-DB] MySQL connection

Right off the bat, you need to consider concurrency issues. Depending on the size of your user base and level of activity this could become a major issue. In the end, why hold an open connection for 15 minutes just to process 20-30 transactions that take 20-30ms each? Just better (under most

[PHP-DB] MySQL connection

Hello everyone, Long time. Hope all are well. Quick question. How should MySQL connections be treated? Is it ok to leave them open or is it better to close them after transactions? I have a website that uses sessions and was wondering if there was any situations where I should be closing the

[PHP-DB] MySQL connection

I have: WinNT_4.00 Server Apache PHP_5 MySQL_4 [myscript.php] ... $link = mysql_pconnect(); ... - If you run php.exe myscript.php, you'll get message: Fatal error: Call to undefined function: mysql_pconnect()... HOW TO DECIDE THIS PROBLEM ? -- PHP Database

Re: [PHP-DB] MySQL connection

I have: WinNT_4.00 Server Apache PHP_5 MySQL_4 [myscript.php] ... $link = mysql_pconnect(); ... - If you run php.exe myscript.php, you'll get message: Fatal error: Call to undefined function: mysql_pconnect()... HOW TO DECIDE THIS PROBLEM ? Have you installed the

Re: [PHP-DB] MySQL connection

Have you installed the php_mysql module in PHP5, it is not included by default now. Where can I find this Library? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL Connection

Hello, Would be grateful if someone couldkindly point me in the right direction. Whenever I try to connect to mysql server, I get these messsage back 1. mysql GRANT ALL PRIVILEGES ON *.* TO moses@% IDENTIFIED BY cludiana; ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)

Re: [PHP-DB] MySQL Connection

On Wed, 2003-06-18 at 08:16, [EMAIL PROTECTED] wrote: Hello, Would be grateful if someone couldkindly point me in the right direction. Whenever I try to connect to mysql server, I get these messsage back 1. mysql GRANT ALL PRIVILEGES ON *.* TO moses@% IDENTIFIED BY cludiana; ERROR

Re: [PHP-DB] MySQL Connection

[EMAIL PROTECTED] wrote: Would be grateful if someone couldkindly point me in the right direction. Whenever I try to connect to mysql server, I get these messsage back 1. mysql GRANT ALL PRIVILEGES ON *.* TO moses@% IDENTIFIED BY cludiana; ERROR 1045: Access denied for user: '@127.0.0.1' (Using

Re: [PHP-DB] MySQL CONNECTION PROblem

but when i used mysql_error() i got : sorry database not found and i have privileges in mysql/ user table .. as shown below... the point is if i changed 192.168.0.111 to localhost .. i managed to get the data ... as my dbconnect.php file includes ? mysql_connect(192.168.0.111 , root , password)

Re: [PHP-DB] MySQL CONNECTION PROblem

but when i used mysql_error() i got : sorry database not found as my dbconnect.php file includes ? mysql_connect(192.168.0.111 , root , password) or die(SORRY CANNOT CONNECT) ; mysql_select_db(kt) or die(sorry database not found); ? and the user table of mysql database : # # Dumping data for

Re: [PHP-DB] MySQL CONNECTION PROblem

On Tue, 10 Jun 2003 16:47:26 +0300 nabil [EMAIL PROTECTED] wrote: but when i used mysql_error() i got : sorry database not found as my dbconnect.php file includes ? mysql_connect(192.168.0.111 , root , password) or die(SORRY CANNOT CONNECT) ; mysql_select_db(kt) or die(sorry database

[PHP-DB] MySQL CONNECTION PROblem

i have the dbconnect.php as : // ?php mysql_connect(192.168.0.111 , root , pass) or die (Couldn't connect to database); mysql_select_db(DatabaseName) or die(sorry database not found); ? /// when i put localhost instead of the IP address of my machine (localy) i got

[PHP-DB] MySQL CONNECTION PROBlem2

Sorry , when i put the IP instead of localhost i got the error... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] MySQL CONNECTION PROblem

i have the dbconnect.php as : // ?php mysql_connect(192.168.0.111 , root , pass) or die (Couldn't connect to database); mysql_select_db(DatabaseName) or die(sorry database not found); ? /// when i put localhost instead of the IP address of my machine

[PHP-DB] mysql connection problem

hi i've added a new apache 2.0.35 server with an php 4.2.0 module to my machine, but always when this php-module tries to connect my mysql server (on the same machine) this error: Host 'weilbach' is not allowed to connect to this MySQL server appears. my other apache 1.3.23 server with php

[PHP-DB] MySQL Connection Class

I know this may seem a little vague but I would like to know where a good tutorial on creating database connection class files would be. I have been looking and as of yet I have not found one that deals specifically with this question. Thanks in advance. Jas -- PHP Database Mailing List

Re: [PHP-DB] MySQL Connection Class

ur class.. Gurhan -Original Message- From: jas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 12:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL Connection Class I know this may seem a little vague but I would like to know where a good tutorial on

Re: [PHP-DB] MySQL Connection Class

0, 2002 12:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL Connection Class I know this may seem a little vague but I would like to know where a good tutorial on creating database connection class files would be. I have been looking and as of yet I have not found one that de

RE: [PHP-DB] MySQL Connection Class

, Oracle, etc.) . Does this help??? Gurhan -Original Message- From: jas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 12:33 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Connection Class So all I would need to do is create a file named db_connection.php3 and put

Re: [PHP-DB] MySQL Connection Class

Does this help??? Gurhan -Original Message- From: jas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 12:33 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Connection Class So all I would need to do is create a file named db_connection.php3 and put in the funct

[PHP-DB] MySQL Connection FailedL

Hi, I'm trying to get IRM to work with my MySQL server. IRM uses php3. It worked for a bit (entry 30 form the MySQL log as shown below). Suddenly, affter fidling with (i believe this is what it was) the file php.ini I know get this: Warning: MySQL Connection Failed: Access denied for user:

[PHP-DB] MySQL Connection Lost....

Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all that helped! The problem I'm now experiencing is when I try to interface with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly and through a MySQL GUI Client. I get the following error...

Re: [PHP-DB] MySQL connection: Change on syntaxis?

At 9:05 AM +0100 6/22/01, Russ Michell wrote: Is this a new use of the function mysql_num_rows? No!. It's not a change in syntax, but it is a change in PHP's behavior. In PHP 4, mysql_num_rows() and mysql_num_fields() will issue error messages if the argument is not a result set. In PHP 3

Re: [PHP-DB] MySQL connection: Change on syntaxis?

Tomás García Ferrari pressed the little lettered thingies in this order... Hello, I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on lines like this: $rows = mysql_num_rows($result); and noticed that this is a solution: $rows =

Re: [PHP-DB] MySQL connection: Change on syntaxis?

on 6/21/01 2:30 PM, Tomás García Ferrari at [EMAIL PROTECTED] wrote: I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on lines like this: $rows = mysql_num_rows($result); and noticed that this is a solution: $rows = @mysql_num_rows($result); Is this a new

RE: [PHP-DB] MySQL connection: Change on syntaxis?

[mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 2:30 PM To: PHP List Subject: [PHP-DB] MySQL connection: Change on syntaxis? Hello, I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on lines like this: $rows = mysql_num_rows($result); and noticed

Re: [PHP-DB] MySQL connection: Change on syntaxis?

[EMAIL PROTECTED] To: PHP List [EMAIL PROTECTED] Date: Friday, June 22, 2001 7:33 AM Subject: [PHP-DB] MySQL connection: Change on syntaxis? Hello, I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on lines like this: $rows = mysql_num_rows($result); and noticed

Re: [PHP-DB] MySQL connection: Change on syntaxis?

Is this a new use of the function mysql_num_rows? No! You can use the @ to 'suppress error messages' that may reveal delicate information to users such as paths to directories on your server. It can be preppended to almost any php function likely to result in an error, if used incorrectly.

[PHP-DB] MySQL connection: Change on syntaxis?

Hello, I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on lines like this: $rows = mysql_num_rows($result); and noticed that this is a solution: $rows = @mysql_num_rows($result); Is this a new use of the function mysql_num_rows? +--

Re: [PHP-DB] mySQL connection problem

Check to see that mySQL is running on your system. On mine, when it is not, I get an error just like that. Matt LENNART KARLSSON [EMAIL PROTECTED] wrote in message 9cefep$4pu$[EMAIL PROTECTED]">news:9cefep$4pu$[EMAIL PROTECTED]... Hi! I have a problem when I try to use a mySQL connection. I

[PHP-DB] mySQL connection problem

Hi! I have a problem when I try to use a mySQL connection. I run Win98SE, PWS 4 and php4. php is working. When I try to run any mySQL scripts (v this one is a forum from planet-source-code.com) I get this error: Running: mysql_pconnect(localhost,root); -- Warning: Can't connect to MySQL

[PHP-DB] MySQL connection problem - need help from expert

Please help me !!! Description :- Server 1 is installed MySQL which located in US. Server 2 is located in Singapore, and doesn't install Mysql. Both of them are installed PHP and Acaphe. Case:- I would like to set the server 2 connect to Server 1's MySQL database. What should I do? Thank you

RE: [PHP-DB] MySQL connection problem - need help from expert

it... -Original Message- From: Ian [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 5:50 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL connection problem - need help from expert Please help me !!! Description :- Server 1 is installed MySQL which located in US

RE: [PHP-DB] MySQL connection problem - need help from expert

PROTECTED]] Sent: Thursday, March 22, 2001 7:50 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL connection problem - need help from expert Please help me !!! Description :- Server 1 is installed MySQL which located in US. Server 2 is located in Singapore, and doesn't install Mysql. Both of them

Re: [PHP-DB] MySQL connection problem - need help from expert

Thanks, Thor and Cal ; ) "Ian" [EMAIL PROTECTED] wrote in message 99eaaj$njn$[EMAIL PROTECTED]">news:99eaaj$njn$[EMAIL PROTECTED]... Please help me !!! Description :- Server 1 is installed MySQL which located in US. Server 2 is