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
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
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
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
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
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
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
[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
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)
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
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
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
A number of connection classes and abstraction toolkits already exist. Your
PHP 4.x install probably came with PEAR's DB.php abstraction layer. Save
yourself the trouble perhaps?
jas said:
So all I would need to do is create a file named db_connection.php3 and
put in the functions
Ok just to clear it up... our server is not running php4 unfortunately. =)
Dave Richardson [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
A number of connection classes and abstraction toolkits already exist.
Your
PHP 4.x install probably came with PEAR's
, 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
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
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
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 =
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
$rows = mysql_num_rows($result) should work. If you want to know what's
going on, try doing:
?php
$rows = mysql_num_rows($result) or die(Error grabbing number of rows. MySQL
said:pfont color=red . mysql_error() . /font);
?
-- David Balatero
-Original Message-
From: Tomás García Ferrari
Hi,
the '@' is an error control operator avaialble in all php versions. When
prepended to an expression in PHP, any error messages that might be
generated by that expression will be ignored.
Check the PHP Manual for more info.
Dobromir Velev
-Original Message-
From: Tomás García Ferrari
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.
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
In the 'user' table in the 'mysql' database on server1, you need to insert
the username you'll be using to connect (and the encrypted password), and in
the Host field you have to specify the hostname of server2, as well as what
privileges you want that user to have (I recommend nn,
Greetings and Salutations Ian,
Somewhere in your code you are going to have a line similar to this:
$currentConnection = mysql_connect ($server, $userName,$password)
$server is going to be either the name or the IP address of your server
$userName is going to be the MySQL user name you use to
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
26 matches
Mail list logo