PHP Mailing List wrote:
Can I maintain just one mysql connection resource to all my pages per
user session. As far as I knows create connection is more expensive than
executing queries ?
No, you can't store resources (of which mysql connections are one
example) in sessions.
Any reference h
go as fast as you can to give the next in line a chance to reuse it
from the pool.
Satyam
- Original Message -
From: "PHP Mailing List" <[EMAIL PROTECTED]>
To:
Sent: Monday, June 11, 2007 6:53 PM
Subject: [PHP] MySQL Connection in Session ?
Can I maintain just
Can I maintain just one mysql connection resource to all my pages per
user session. As far as I knows create connection is more expensive than
executing queries ?
Any reference how to make efficient for connection resources ?
Thanks,
Dino
--
PHP General Mailing List (http://www.php.net/)
To
On Fri, April 28, 2006 10:26 am, sathyashrayan wrote:
> I am a self thought php beginner. I wrote my first toy
> code for database connection in php/mysql. The connection
> is successful but iam getting a warning and my rows/columns
> are not showing. I am getting a warning:
>
> Warning: mysqli_
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 10:14 PM
To: Php-General
Subject: Re: [PHP] Beginner's php/mysql connection probs
sathyashrayan wrote:
> -Original Message-
> From: John Nichel [mailto:[EMAIL PROTECTED]
>
sathyashrayan wrote:
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 9:11 PM
To: Php-General
Subject: Re: [PHP] Beginner's php/mysql connection probs
sathyashrayan wrote:
Dear group,
(I am a very beginner so please bear with me
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 9:11 PM
To: Php-General
Subject: Re: [PHP] Beginner's php/mysql connection probs
sathyashrayan wrote:
> Dear group,
>
> (I am a very beginner so please bear with me for a s
sathyashrayan wrote:
Dear group,
(I am a very beginner so please bear with me for a simple question)
I am a self thought php beginner. I wrote my first toy
code for database connection in php/mysql. The connection
is successful but iam getting a warning and my rows/columns
are not showing.
sathyashrayan schrieb:
Dear group,
(I am a very beginner so please bear with me for a simple question)
I read that sentence somewhere before *mmh*
I am a self thought php beginner. I wrote my first toy
code for database connection in php/mysql. The connection
is successful but iam gett
Dear group,
(I am a very beginner so please bear with me for a simple question)
I am a self thought php beginner. I wrote my first toy
code for database connection in php/mysql. The connection
is successful but iam getting a warning and my rows/columns
are not showing. I am getting a warning:
> From: Christian Ista [mailto:[EMAIL PROTECTED] File
> 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2) Character set
> '#33' is not a compiled character set and is not specified in the
> 'c:\mysql\share\charsets\Index' file Resource id #5
I answer to myself.
In fact I reinstall MySQL
Hello,
I Have MySQL 4.1.14 and 5.0.15 installed on my Windows XP Pro SP2.
There are installed in D:\Tools\MySQL\MySQL Server 4.1.14 and MySQL Server
5.0.15 for the version 5. They work on port 3306 and 3307.
When I try a DB connection, I receive this error:
File 'c:\mysql\share\charsets\?.conf
On Wednesday 26 October 2005 08:35, the author Jay Blanchard contributed to
the dialogue on-
RE: [PHP] MySql connection error on win XP for script that works on Freebsd
5.3:
>[snip]
>I have searched the mysql website and located an article which shows
>reference
>to this erro
[snip]
I have searched the mysql website and located an article which shows
reference
to this error indicating that the client may need to be upgraded but as I am
using the mysql-5.0.13-rc-win32.zip package I am cautious about assuming
that
that is the actual cause.
[/snip]
http://us3.php.net/m
I have just installed MySql on Win XP and am attempting to run a php script to
create some databases. The script works fine on FreeBSD 5.3 running
mysql-client-5.0.11 and mysql-server-5.0.11.
MySQL has been installed on windows XP using a download of
mysql-5.0.13-rc-win32.zip. Test.php reports
Hi,
I have Apache 2, PHP 5 and MySQL 4.1 installed on an XP pro box.
I have created a new database 'ijdb' with a single table 'joke' and have
entered data into two of the three fields in the table.
I can access the database / tables / data from a command prompt.
However, when I try to connect t
Hi,
For a long time, on all of my mysql pages, I've done something like this
$conn = mysql_connect($server,$username,$password) or die("Could not
connect")
mysql_select_db($db);
I've finally put that into its own script file, moved it to my include
files, and simply included it whereever I neede
I think you've just answered your own question here:
"I get a "Can't Connect to MySQL Server" error. I am not sure if it is
localhost, since my webserver is on a different machine with a different
name. The MySQL installation is on a different machine, separate from
the web server with its own
Hi There,
I'm trying to establish a first time connection to MySQL running on Win
2000. I have loaded the application and have entered a user name and
password. The code that I am entering to establish a connection is:
I get a "Can't Connect to MySQL Server" error. I am not sure if it is
loc
Robb Kerr wrote:
Ok, I feel like a complete bonehead because I can't seem to figure this
thing out. But, I readily welcome someone making me feel worse by pointing
out my simple mistake. I can't get DW to connect to a MySQL database on a
new server with which I'm working. I've worked with other se
Ok, I feel like a complete bonehead because I can't seem to figure this
thing out. But, I readily welcome someone making me feel worse by pointing
out my simple mistake. I can't get DW to connect to a MySQL database on a
new server with which I'm working. I've worked with other servers and
haven't
Hello,
Thanks it works now
Regards
Moses
> Hello, This seems not to be working, I am using win2000 and a newbie. please
> simplify this process.
>
> ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
> mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
> -> IDENTIF
On Tue, 2003-06-17 at 18:19, [EMAIL PROTECTED] wrote:
> Hello, This seems not to be working, I am using win2000 and a newbie. please
> simplify this process.
>
> ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
> mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
> -
n Wilson <[EMAIL PROTECTED]>
>> date:Wed, 18 Jun 2003 01:17:15
>> to: [EMAIL PROTECTED]
>> cc: [EMAIL PROTECTED]
>> subject: Re: [PHP] MySQL Connection
>>
>> On Tue, 2003-06-17 at 17:13, [EMAIL PROTECTED] wrote:
>> > Hello,
>> &
OPTION;
ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
mysql>
Regards
> from:Lars Torben Wilson <[EMAIL PROTECTED]>
> date:Wed, 18 Jun 2003 01:17:15
> to: [EMAIL PROTECTED]
> cc: [EMAIL PROTECTED]
> subject: Re: [PH
On Tue, 2003-06-17 at 17:13, [EMAIL PROTECTED] wrote:
> Hello,
>
> Would be grateful if someone couldkindly point me in the right direction.
Check the MySQL documentation. You also might want to ask on the MySQL
mailing list.
http://www.mysql.com/doc/en/Default_privileges.html
http://www.mys
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)
> John,
> I was under the impression that the mysql database had as default user
> when
> installed:
> ..
> anonymous
> root
>
The last time I installed MySQL it had four default users, I think.
> And that the _anonymous_ user could only create a database that began
John W. Holmes wrote in message :
> Because a default install of MySQL includes an anonymous user, one with
> no username or password. There is also a root user with no password.
> Read the MySQL manual on Installation and the GRANT command on how to
> fix this.
>
> ---John W. Holmes...
..
Professionals. Get your copy
today. http://www.phparch.com/
> -Original Message-
> From: Anthony Ritter [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, February 02, 2003 3:16 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] php/mysql connection
>
> Newbie question and OT. Sorry.
>
>
Newbie question and OT. Sorry.
I am able to conncet to a mysql server with the following call to
mysql_connect().
$connect=@mysql_connect("","","");
There are no parameters in the function call.
Why can I connect if there are no parameters?
However, if I give mysqladmin the password of:
goodpa
Hi,
I tried to display phpinfo and I am getting following values
display_errors On On
display_startup_errors On On
error_append_string no value no value
error_logno value no value
error_prepend_string no value
>My server is running on shared server which has support for PHP 4.1.2. I
>installed mySQL for our shared server. I also installed phpMyAdmin. Both
>are running properly. But I am facing following problems
>
>1) If there is any error in the script - It is not getting displayed -
>screen is beco
> My server is running on shared server which has support for PHP 4.1.2.
I
> installed mySQL for our shared server. I also installed phpMyAdmin.
Both
> are running properly. But I am facing following problems
>
> 1) If there is any error in the script - It is not getting displayed -
> screen is b
Hi,
My server is running on shared server which has support for PHP 4.1.2. I
installed mySQL for our shared server. I also installed phpMyAdmin. Both
are running properly. But I am facing following problems
1) If there is any error in the script - It is not getting displayed -
screen is becom
> Hey all, this is probably more to do with Mysql but I figured i'd
> ask here as well.
>
> The problem:
> When connecting to the mysql server on the local machine its
> fine, but when you connect to a remote machine
> eg $db = mysql_connect("x.x.x.x", "user", "password");
> and reque
Jo wrote:
>The problem:
>When connecting to the mysql server on the local machine its fine, but when you
>connect to a remote machine
>eg $db = mysql_connect("x.x.x.x", "user", "password");
>and request something from the database, it connects, BUT it takes about 5 minutes...
>
I have an idea,
Hey all, this is probably more to do with Mysql but I figured i'd ask here as well.
The problem:
When connecting to the mysql server on the local machine its fine, but when you
connect to a remote machine
eg $db = mysql_connect("x.x.x.x", "user", "password");
and request something from the data
I was just wondering if there was a way to connect to a MySQL server on a
server other than the one that your php script is on. I tried just putting
in the URL of the site in place of localhost but that didn't work. Is there
anything special that I have to do to get it to work? Thanks,
Dave
--
Thanks for all the help so far, great to have others out there helping.
Only way it will let me connect is to explicitly use the connection
information in the connect statement and the select_db statements, can't
pass in the variables.
This seems a little on the insecure side, and a pain. Is
t: Saturday, March 30, 2002 10:02 PM
Subject: [PHP] MySQL Connection Error - mysql_select_db
> here is a function used to authenticate users against mysql database.
> Problem is, I am not connecting for some reason. I have the db variables:
> $db_host
> $db_user
> $db_pass
> $d
31/03/2002 01:02:04, "Patrick Hartnett" <[EMAIL PROTECTED]> wrote:
You Need to use the command
Mysql_Select_Db("$db_name") Or Die("Unable to connect!");
after connect with mysql
I use something like this:
mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!");
Mysql_Select_D
here is a function used to authenticate users against mysql database.
Problem is, I am not connecting for some reason. I have the db variables:
$db_host
$db_user
$db_pass
$db_name
They are populated from an include ("x.php") in the beginning of the php
section. It is getting past the connect
On Tuesday 29 January 2002 15:29, Uma Shankari T. wrote:
> Hello,
>
>
> How do i check php support mysql..
>
>
> If any one came to know this tell me...
You have already been told how to. See the posting by Chris in response to
your posting about the same question just a little while ago.
Hello,
How do i check php support mysql..
If any one came to know this tell me...
Regards,
Uma
--
PHP General 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: [
7; '--with-layout=GNU' '--enable-debugger' '--enable-ftp'
'--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets'
'--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-yp'
'
Hello,
I have installed php3 in my system.I want to connect with mysql.I have
given this code
$link=mysql_connect("localhost","username","password") or die("could not
connect");
but it is giving Fatal error: Call to undefined function: mysql_connect()
Why it is showing like.
Mys
Here is my situation:
1. Two hosts: HA and HB, both connected with each other via Internet.
2. On HA there is a MySQL server SA and a Web server WA, while on
HB there is a SB and a WB.
3. On WA there is a page, on which there are two buttons: ba and bb.
The ba is linked to a script sa.php while b
>If I use extention .inc for including my connection-
>variables file then browser attempts to download this file which is
>not better then first. I searched the net on this topic and found a
>LOT of information about this problem and the best that I found is
>here I just want you to be aware of
27;t be made.
> > No code is shown, just a line number. If, in your
> > case, PHP dumps the
> > source code to the browser window when the db
> > connection won't work,
> > then something has to be wrong. :)
> >
> > --Matt
> >
> >
> &g
ce code to the browser window when the db
> connection won't work,
> then something has to be wrong. :)
>
> --Matt
>
>
> -Original Message-
> From: BRACK [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 09, 2001 5:57 AM
> To: Attila Strauss
> Cc: [EMA
won't work,
then something has to be wrong. :)
--Matt
-Original Message-
From: BRACK [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 5:57 AM
To: Attila Strauss
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL connection
I have tested again what I said yesterday and found
riment -
> > > > start Apache but "forget" to start SQL and go to
> > > > your site
> > > > http://localhost/... you will see yourself all the
> > > > information on the
> > > > screen.
> > > >
> > > >
; > > Youri
> > >
> > > On 7 Aug 2001, at 12:53, Ryan Christensen wrote:
> > >
> > > > I'm curious as to how the "hacker" would see all
> > > this information (the
> > > > username.. password, etc..) just by going t
Ha ha... "hardcore the user/password"
Sorry... I realize you gave a good answer, just had to laugh. :)
-Original Message-
From: Attila Strauss [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 1:33 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL connection
st by going to a
> > site where the SQL backend
> > > was down?
> > >
> > > Ryan
> > >
> > > > -Original Message-
> > > > From: BRACK [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, August 07, 2001 12:36 PM
> &g
quot; would see all
> this information (the
> > username.. password, etc..) just by going to a
> site where the SQL backend
> > was down?
> >
> > Ryan
> >
> > > -Original Message-
> > > From: BRACK [mailto:[EMAIL PROTECTED]]
> >
Yes that is what I mean, but also When I played with my Apache I
saw ALL my information on the screen without any error message.
Actually it maybe that my PHP server was down at that moment
as well, well, I must check it up
Youri
On 7 Aug 2001, at 13:00, Bjorn Van Simaeys wrote:
> Hi,
>
>
07, 2001 12:36 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] MySQL connection
> >
> >
> > I just wanned to bring the issue of security of MySQL connection:
> >
> > Let us imagine that SQL server was down for some hours (of
> > course without us knowin
I mean he will know all your sensitive information to enter your SQL
server in couple of hours when server will be up again.
Youri
On 7 Aug 2001, at 14:40, Tyler Longren wrote:
> If the SQL server is down how will he hack it? That's like hacking a
> webserver that doesn't exist.
>
> Tyler Lo
Hi,
I think BRACK a.k.a. Jouri means that the connection
string (from the PHP pages) would be visible in the
client's browser once the SQL server stops running.
However, I am not so sure about this as all commands
are processed on the server - it will, however display
an error message that the S
M
> To: [EMAIL PROTECTED]
> Subject: [PHP] MySQL connection
>
>
> I just wanned to bring the issue of security of MySQL connection:
>
> Let us imagine that SQL server was down for some hours (of
> course without us knowing it) and at the same hours our SQL site
> was visit
If the SQL server is down how will he hack it? That's like hacking a
webserver that doesn't exist.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 7 Aug 2001 21:35:58 +0200
"BRACK" <[EMAIL PROTECTED]> wrote:
> I just wanned to bring the issue of securit
I just wanned to bring the issue of security of MySQL connection:
Let us imagine that SQL server was down for some hours (of
course without us knowing it) and at the same hours our SQL site
was visited by some kind of hacker, he can see on his screen all
our SQL connection info like username,
> Warning: MySQL Connection Failed: Can't connect to MySQL server on
> 'localhost' (10061) in c:\arquivos de
> programas\apache group\apache\htdocs\db_connect.php on line 3
> Couldn't connect.
Is the MySQL deamon running?
IE, is there a black MS-DOS window (maybe minimized) that has something not
When I try to connect mysql with the following code:
MySql Connection
The following error appear:
Warning: MySQL Connection Failed: Can't connect to MySQL server on
'localhost' (10061) in c:\arquivos de
programas\apache group\apache\htdocs\db_connect.php on line 3
66 matches
Mail list logo