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 connection session. The b
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 trans
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 o
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 cir
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 conn
Have you installed the php_mysql module in PHP5, it is not
included by default now.
Where can I find this Library?
in the extensions subdirectory
You will need the latest PHP5 download as it was missed from
the early ones ;)
biosad.mail.ru
WHAT ?!?!?!?! HOW THEY. IT IS NOT GOOD.
It is very g
> 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
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 php
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 Mai
[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' (U
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";
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)
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
and the user table of mysql database :
#
# Du
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
but when i used mysql_error() i got : "sorry database not found"
as my dbconnect.php file includes
and the user table of mysql database :
#
# Dumping data for table `user`
#
INSERT INTO user VALUES ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y')
> i have the dbconnect.php as :
> //
> 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
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
i have the dbconnect.php as :
//
///
when i put localhost instead of the IP address of my machine (localy) i got
the following error...
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in c:\inetpub\wwwroot\kt\superv_list.php on li
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 4.1.2
ss..
You
> can always have more properties of the class and more functions..
> If you prefer you can hardcode the login, databasename info to the class
> and call the connection fucntions without arguments, or you can set the
> variables of the class and use it so, you can also have more fun
t the
variables of the class and use it so, you can also have more functions to
connect to the different databases (PostGreSQL, Oracle, etc.) .
Does this help???
Gurhan
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 12:33 AM
To: [EMAIL PR
functions?? If yes, you should only check those
> >> database functions' tutorials and just use them inside your class..
> >>
> >> Gurhan
> >>
> >>
> >> -Original Message-
> >> From: jas [mailto:[EMAIL PROTECTED]]
> >>
> native DB connection functions?? If yes, you should only check those
>> database functions' tutorials and just use them inside your class..
>>
>> Gurhan
>>
>>
>> -----Original Message-
>> From: jas [mailto:[EMAIL PROTECTED]]
>> Sent
database using PHP's
> native DB connection functions?? If yes, you should only check those
> database functions' tutorials and just use them inside your class..
>
> Gurhan
>
>
> -Original Message-
> From: jas [mailto:[EMAIL PROTECTED]]
> Sent: Wednesd
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 creating database connection class files would be. I have been
looking and as of yet I have not found one
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 (htt
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: 'a
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...
Warning:
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
> 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.
ía Ferrari <[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(
$rows = mysql_num_rows($result) should work. If you want to know what's
going on, try doing:
" . mysql_error() . "");
?>
-- David Balatero
-Original Message-
From: Tomás García Ferrari [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 2:30 PM
To: PHP List
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 t
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 = @mysql_num_ro
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?
+--
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 connecti
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 M
Hi all,
I'm having some problems with mysql, php4 and apache ...
PHP works ok... but a can't connect mysql database...
This is the error message: Warning: MySQL Connection Failed: Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in
/home/httpd/html/t.php on l
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
ssage-
From: Ian [mailto:[EMAIL 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 does
ntation. So, I won't actually say it, but merely imply 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.
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 in
42 matches
Mail list logo