PROTECTED]; mysql@lists.mysql.com
Asunto: RE: php and mysql
If you still have issues after that, then read
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
Regards
---
** _/ ** David Logan
uot;Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]>
> Subject: RE: php and mysql
>
>
> If you still have issues after that, then read
> http://dev.mysql.com/doc/refman/5.0
PROTECTED]
Sent: Friday, 10 March 2006 6:42 AM
To: Mary Adel
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: php and mysql
On Thu, 9 Mar 2006, Mary Adel wrote:
> Thanks for al your help and i di that and now i have another error
>
> Can't connect to local MySQL server through
On Thu, 9 Mar 2006, Mary Adel wrote:
Thanks for al your help and i di that and now i have another error
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
my code is as follows:
";
print "connected";
?>
if u can help in this i ll appreciate that a lot
On Thu,
Thanks for al your help and i di that and now i have another error
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
my code is as follows:
";
print "connected";
?>
if u can help in this i ll appreciate that a lot
On Thu, 2006-03-09 at 13:37 -0500, fbsd_user w
Mary Adel wrote:
I have a severe problem that php5 cannot connect to mysql and i don't
know why
also i am using linux
here is my peice of code
:";
print "connected";
?>
if their is any configuration please tell me
PHP wants a username and password. For web pages, it's good practice to
creat
You need a login id and password unless this is test DB added under
ID "root"
You have to use the same login id as the one you created the
db/table with.
mysql_connect('localhost', 'Login id', 'pw') or die(mysql_error())
mysql_connect('localhost', 'root') or die(mysql_error())
-Original Mes
munication and notify the sender immediately. It should be
>> noted that any review, retransmission, dissemination or other
>> use of, or taking action in reliance upon, this information by
>> persons or entities other than the intended recipient is prohibited.
>> E-mail commu
on, dissemination or other
> use of, or taking action in reliance upon, this information by
> persons or entities other than the intended recipient is prohibited.
> E-mail communications may be monitored.
> ****************
>
PROTECTED]
Sent: Thursday, 27 October 2005 6:23 PM
To: 'sheeri kritzer'
Cc: mysql@lists.mysql.com
Subject: RE: PHP and mysql
Thanks for your reply I think this is the issue I don't think root is
allowed to login from local host I created another user called web user
and
changed th
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: 25 October 2005 18:06
To: Alastair Roy
Cc: mysql@lists.mysql.com
Subject: Re: PHP and mysql
Yes.
Whenever you have a problem, go back to basics. Can you login as root
on the commandline? What password do you use there? Once you're
there, ch
Alastair Roy wrote:
> Greetings everyone, I am having a problem with PHP and mysql I have copied a
> script exactly off a website to open the database and insert a new user I
> try to access the mysql database using the root user, and enter information
> into the user table, this is the PHP I am us
Yes.
Whenever you have a problem, go back to basics. Can you login as root
on the commandline? What password do you use there? Once you're
there, check root's permissions, but I'd be willing to bet your
password is incorrect, or root is only allowed to logon from localhost
and not the machine t
Hello.
May be this could be a bit helpful:
http://dev.mysql.com/doc/refman/5.0/en/access-denied.html
Alastair Roy wrote:
> Greetings everyone, I am having a problem with PHP and mysql I have copied a
> script exactly off a website to open the database and insert a new user I
> try to ac
Have you tried posting this to the PHP general mailing list?
Respectfully,
Ligaya Turmelle
---
Life is a game... so have fun.
---
www.PHPCommunity.org
Open Source, Open Community
Visit for more information or to join the movement
Fernando F. Retagi wrote:
Hi All!
I have installed mysql 4.0.20 (wen
When I run
this little PHP script I always get fail error message:
/[EMAIL PROTECTED]("localhost", "root", "myrootpass"); if
(!$link_id)
{
echo "Failed !";
exit;
}
*/
Should I change something in php.ini ?
Try removing the '@' from the mysql_pconnect statement to get a more
des
On Fri, 26 Nov 2004 05:44:00 +0100, "Danesh Daroui"
<[EMAIL PROTECTED]> said:
> Hi all,
>
> I have installed MySQL Server 4.1.7 on a Linux Fedora Core 3 machine. It
> works great locally and remotely. This machine also supposed to act as a
> web server by using Apache 2.0.52 and it works fine t
go to www.codewalkers.com under the tutorials/basics section there is a
tutorial called "Sorting Database Results with PHP". It will show you how
to display the data. If you are just looking for a quick cheat - You need
to use tables. Place each record on a table row and each attribute in
a tab
Thank you very much to all.
Jason Burfield <[EMAIL PROTECTED]> wrote:This is probably something for the php list,
however, how is
REGISTER_GLOBALS set on your server? On or off? It is off by default on
newer version of PHP. (has been for a while.)
If it is off you need to grab the vars from post
PHP has changed their superglobals, no longer can you just put a $ infront
of the assigned name attribute. (You can change this in the php.ini file,
but it's discouraged)
Instead use
$_GET['name']
Or
$_POST['name']
So for $manufacturer
$_POST['manufacturer']
-Original Message-
From: See
Seena,
I believe that the proper syntax is ---> mysql_connect( host,
username,password)
Also I generrally when passing variables use $_POST['name'] --->
$_POST['version']
Good luck,
Nestor :-)
Seena Blace wrote:
Hi,
Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can
This is probably something for the php list, however, how is
REGISTER_GLOBALS set on your server? On or off? It is off by default on
newer version of PHP. (has been for a while.)
If it is off you need to grab the vars from post like:
$softwareid = $_POST["softwareid"];
$manufacturer = $_POST["man
ROTECTED]>
To: "'gamalt tant'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, September 28, 2003 04:49
Subject: RE: php and mysql
> There shouldn't be anything else required (besides PHP). PHP has built in
> functions to access MySQL.
> See
Go to http://www.rpmfind.com and search for php-mysql
It should give you a list of packages.
So, to use PHP with MySQL you need to install a package with a name like
php-mysql-**.rpm
Hope this helps
Thanks
Emery
- Original Message -
From: "gamalt tant" <[EMAIL PROTECTED]>
To: <[EM
There shouldn't be anything else required (besides PHP). PHP has built in
functions to access MySQL.
See:
http://www.php.net/manual/en/ref.mysql.php
Adam Clauss
[EMAIL PROTECTED]
> -Original Message-
> From: gamalt tant [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 27, 2003 8:48
QL List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 4:12 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
> Since nobody is jumping in to say it is some simple configuration/setting
> personally my next step would be to shut down all services on the box that
> aren't absol
t;MySQL List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 5:06 PM
Subject: Re: [PHP] Re: PHP and MySQL bug
> @mysql_select_db("be"); -- this failed
> do echo mysql_error(); to see what went wrong
>
>
>
> Nuno Lopes wrote:
>
&
* Try add to /etc/hosts the name and ip of DB is located
>> I'm using Windows 2000.
In Windows2000 make the same changes in winnt/system32/drivers/etc/hosts.
If it connects the first time and every time thereafter that you recreate
the connection it should not be anything to do with resolving the
Then go to c:\winnt\system32\drivers\etc and make the changes in the hosts
file that you will find there.
-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 1:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] Re: PHP and MySQL
I'm using Windows 2000.
- Original Message -
From: "Cleber" <[EMAIL PROTECTED]>
To: "Nuno Lopes" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 10:23 AM
Subject: Re: [PHP] Re: PHP and MySQL bug
> Try add to /etc/hosts the name and ip of DB
'no db was selected')
- Original Message -
From: "David Freeman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 10:29 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
> @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id=
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 4:31 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] Re: PHP and MySQL bug
I have the latest version of PHP (4.3.0) as module in apache 2.0.43 and
mysql 3.23.49.
Everything is working fine, except this.
With pc
ED]>
Sent: Monday, January 06, 2003 6:28 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
> This definitely sounds like a buggy installation or there may be some
> problem with the communication between the web server and the mysqld. Is
> the db on a different machine? Try using mysql_
, 2003 1:09 PM
To: MySQL List; [EMAIL PROTECTED]
Subject: [PHP] Re: PHP and MySQL bug
The problem is if I close the connection and reopen it the query is done,
but if I remain with the same connection has the previous query, mysql
returns an error.
- Original Message -
From: "Larry
: Monday, January 06, 2003 10:09 AM
To: MySQL List; [EMAIL PROTECTED]
Subject: Re: PHP and MySQL bug
The problem is if I close the connection and reopen it the query is done,
but if I remain with the same connection has the previous query, mysql
returns an error.
- Original Message -
From
The problem is if I close the connection and reopen it the query is done,
but if I remain with the same connection has the previous query, mysql
returns an error.
- Original Message -
From: "Larry Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 20
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 10:29 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
>
> > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this
> > query doesn't work
>
> Personally, I'd call it bad
Here is the source code:
Seleccione a localização para o download:Localização Principal";
if ($mirrors) {
echo " Mirrors";
$m=explode("»",$mirrors);
foreach ($m as $v) {
$m2=explode("!",$v);
echo "$m2[0]";
}
echo "Nota: Deve escolher o mirror mais próximo da sua localização,
para acelerar o dowloa
Nuno,
> $r=MYSQL_QUERY("SELECT n,u,m,h FROM d WHERE id='$id'");
>
> /* Some code including "mysql_num_rows" and "mysql_fetch_array($r,
> MYSQL_NUM)"
> And the another query:
> */
>
> MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
>
> /* i don't know why but this doesn't work!*/
It doesn't wor
I'd like to try and see if I can find the problem as I write with PHP for
MySQL quite a bit. However, without the specifics of how the script is
running as is, I can't tell where the problem is. Write a quick script in
complete detail that does what your post is doing and I'll look for
anything.
Hello,
Try this
good luck
Andrew Rich wrote:
> Further to this, I removed the "@" symbol and got:-
>
> Fatal Error: Call to undefined function: mysql_connect() in
> /var/www/html/results.php
>
> @ $db = mysql_pconnect("localhost", "user", "password");
>
> $db = mysql_pconnect("localhost", "us
t; ?
>
> I am not sure if the include statement is design to add mysql BINARIES or
> SOURCE CODE ??
>
> Lost.
>
> Andrew
>
> -Original Message-
> From: Andrew Rich [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 25 April 2002 11:28 AM
> To: Andrew R
11:28 AM
To: Andrew Rich; [EMAIL PROTECTED]
Subject: RE: PHP and MySQL help please !
Further to this, I removed the "@" symbol and got:-
Fatal Error: Call to undefined function: mysql_connect() in
/var/www/html/results.php
@ $db = mysql_pconnect("localhost", "user&qu
Further to this, I removed the "@" symbol and got:-
Fatal Error: Call to undefined function: mysql_connect() in
/var/www/html/results.php
@ $db = mysql_pconnect("localhost", "user", "password");
$db = mysql_pconnect("localhost", "user", "password");
Ideas ? Why is it now a undefined function
Hi!
> "Sebastian" == Sebastian Bergmann <[EMAIL PROTECTED]> writes:
Sebastian> Michael Widenius wrote:
>> The symbol 'mysql_module_entry' doesn't come from the MySQL library,
>> so this is a PHP problem.
Sebastian> Okay.
>> Note that you can use MySQL 4.0 with the old MySQL 3.23 library
Michael Widenius wrote:
> The symbol 'mysql_module_entry' doesn't come from the MySQL library,
> so this is a PHP problem.
Okay.
> Note that you can use MySQL 4.0 with the old MySQL 3.23 library
> without any problems.
Yes, it works fine if I use the libmysql that is bundled with PHP. Only
On 19-Sep-2001 Neil Silvester wrote:
> I am having a little problem with a PHP 4 statement in one of my webpages. I
> am using a drop down box of selections that is built a table in a MySQL
> database.
> This is what I have so far (everything works well, the correct information
> is displayed f
echo ('' . $row["Category"] .
'');
You might be able to escape the " with /" or the like but I'm not great at
php, yet. ;)
- Original Message -
From: "Neil Silvester" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 5:42 PM
Subject: PHP and Mysql problem
> -Original Message-
> From: Neil Silvester [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 20 September 2001 08:12
> To: [EMAIL PROTECTED]
> Subject: PHP and Mysql problem
>
>
> I am having a little problem with a PHP 4 statement in one of my webpages. I
> am using a drop down box of se
On Sun, 8 Jul 2001 19:10, Kevin Smith wrote:
> Hi All,
>
> Has anyone ever had this problem when using PHP 4.06 and MySQL 3.23.39
> running on Apache 1.3.20 on Windows 2000 Professional SP!?
>
>
> Warning: Supplied argument is not a valid MySQL result resource
> in d:\program files\apache
> gro
which caused me to realise the database wasn't able to be read by
Windows. :)
Thanks,
Kevin
- Original Message -
From: "Jason Burfield" <[EMAIL PROTECTED]>
To: "Kevin Smith" <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001 4:15 PM
Subject: Re: PHP and M
Well, it's difficult to tell but I would say it would be your SQL statement
but since you didn't provide us with that...
- Original Message -
From: "Kevin Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001 17:40
Subject: PHP and Mysql
> Hi All,
>
> Has anyon
Is there a particular reason why you want the images in a mysql database.
It would be faster if you put that path to the images in a table then the
actual images.
Mat
- Original Message -
From: "Kevin Pratt" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Friday, June 15,
This topic has been covered many times - check the PHP-General mailing list
archives (http://marc.theaimsgroup.com/?l=php-general)
--zak
- Original Message -
From: "Kevin Pratt" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 12:25 PM
Subject: PHP a
Why would you want to do that? That's what filesystems are for.
> Can any one tell me how place images in to a mysql database and then
> retrieve them later?
-
Before posting, please check:
http://www.mysql.com/manual.php
If you want to repeatedly loop through a result set in PHP, you can use
mysql_data_seek($result, 0);
to reset the pointer to the first row. See
http://www.php.net/manual/en/function.mysql-data-seek.php
-steve
At 9:33 AM +0800 6/4/01, Rolf Hopkins wrote:
>Yep, that's the wa
Yep, that's the way you do it. Put it into a 2D array or even better, a
class. That's if you are familiar with OOP.
- Original Message -
From: "Marco Bleeker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 6:57
Subject: PHP and MySQL result set navigation
> I d
I had this same problem. I could connect via the mysql client if I was
ROOT, but not otherwise.
You may have a permissions problem. Ensure that /var, /var/lib, and
/var/lib/mysql are set to: drwxr-xr-x
That cured it for me.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROT
> Hi,
>
> I've installed MYSQL on Red hat.
>
> I'm trying to run the command
>
> mysqlaccess
>
> It asks for the Password for MySQL superuser root:
> Can anyone tell me the password for this?
>
>
> Thanks
> Sandeep
mysqlaccess is a perl script to check the access priviliges of a user:d
Hi,
I've installed MYSQL on Red hat.
I'm trying to run the command
mysqlaccess
It asks for the Password for MySQL superuser root:
Can anyone tell me the password for this?
Thanks
Sandeep
-
Before posting, please check
I had the same problem. Ensure the permissions for /var, /var/lib, and
/var/lib/mysql are set to: drwxr-xr-x
-Original Message-
From: Ben Kennish [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:56 AM
To: [EMAIL PROTECTED]
Subject: PHP and MySQL
Who would've thought it woul
Joe and Nancy M wrote:
>
> Thanks to everyones help, I have my webpages using php to read my mysql
> table and presenting the appropriate information. I upload and refresh my
> table via telnet when the whole thing needs refreshing.
>
> I would like to give my end user a tool to change the tabl
I think that my file permissions are set OK. Heres a list of my MySQL
folder...
total 1652
drwx--6 mysql27 4096 Mar 1 11:37 .
drwxr-xr-x 20 root root 4096 Feb 15 16:26 ..
-rw---1 mysql27244 Feb 26 16:56 .bash_history
drwx--2 my
- Original Message -
From: "Ben Kennish" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 11:55 AM
Subject: PHP and MySQL
> Who would've thought it would take 3 days to install MySQL, PHP and get
> them talking???!!
>
> I've installed PHP 4.0.4pl1 using an RPM f
Chris,
I *strongly* suggest you read up on SQL. You simply don't know the
difference between the most important commands :)
There shouldn't be a space in your database (and it cannot either). Please
also post what commands you're using to select your database etc. From
what you show us here, we
Hi,
If you still have that space, I'd take it out.
-Original Message-
From: Chris Hallgren [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 28 February 2001 10:15 a.m.
To: [EMAIL PROTECTED]
Subject: PHP and mysql
PHP and mysql dont work for some reason i installed both as directed with
the
I can think of a couple of things. You have the wrong URL somewhere in your
code, your web server isn't configured correctly or compiled PHP
incorrectly. Either way, this does not relate to MySQL and you are much
better off asking the PHP list.
You may want to try accessing normal HTML pages th
MAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 7:55 AM
Subject: Re: PHP and MySQL in red hat 7.0
> [EMAIL PROTECTED] wrote:
> >
> > Thanks Matt.
> > MySQL is finally working.
> > But the problem now is that PHP is
[EMAIL PROTECTED] wrote:
>
> Thanks Matt.
> MySQL is finally working.
> But the problem now is that PHP is not recognizing its MySQL
> functions. The error I am getting is:
>
> Fatal error: Call to undefined function: mysql_pconnect() in
> /var/www/html/Willy/MySQL/test1.php on line 28
>
> Well
Mike Yuen writes:
> Is there anyway to tell how many connections are currently being served by
> MySQL. I'm using this in combination with PHP. Also, does MySQL
> automatically shut down when you leave the page? I'm not using
> mysql_pconnect - just the regular mysql_connect.
Hi!
You are prob
ps -ef|grep -c mysql
Subtract 3 from this as this is the default number of daemons that
start. One is spawned for each new child.
Yes, if the php script terminates, the mysql child will also terminate.
This is not the behaviour with persistant connections though. Please
move this over to the php
71 matches
Mail list logo
