RE: php and mysql
Also be careful with this:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
(after to establish a connection)
Edwin.
-Mensaje original-
De: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 09 de Marzo de 2006 02:17 p.m.
Para: Mary Adel
CC: [EMAIL 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
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: JC [mailto:[EMAIL 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 socket
> '/var/lib/mysql/mysql.sock' (2) my code is as follows:
>
> print "hi";
> mysql_connect('localhost', 'root','') or die(mysql_error()); echo
> "Connected to MySQL"; 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 wrote:
>> 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 Message-
>> From: Mary Adel [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, March 09, 2006 3:06 PM
>> To: mysql@lists.mysql.com
>> Subject: php and mysql
>>
>>
>> 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 "hi";
>> mysql_connect('localhost', '', '') or die(mysql_error());
>> echo "Connected to MySQL";
>> print "connected";
>> ?>
>> if their is any configuration please tell me
>>
>> thanks,
>> mary
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/[EMAIL PROTECTED]
>>
>>
>
>
>
--
hi mary,
take a look at
http://www.stanton-finley.net/fedora_core_5_installation_notes.html#MySQ
L.
basically, you need to make sure that your mysql server accepts local
connection.
if you login to your mysql server:
mysql -u root (if no password for root) or
mysql -u root -p (if there is pw for root)
and then:
select user,host,password from mysql.user;
if you don't see an entry for root & localhost, then you need to add it
in.
hope that help.
JC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: php and mysql
Mary, you need to know 100% that mysql is actually running and what port or socket it is listening on for connections, before you even try and connect to it. If you call mysqld directly with a script something like: #! /bin/sh # start-mysql-5.0.18 # # start the MySQL database server /usr/local/mysql-5.0.18/bin/mysqld \ --defaults-file=/usr/local/mysql-5.0.18/my.cnf \ --port=7000 \ --socket=/var/lib/mysql/mysql.sock \ --pid=/var/lib/mysql/laptop.pid \ --user=mysql \ --datadir=/var/lib/mysql & Then use a processes monitoring tool such as: http://www.student.nada.kth.se/~f91-men/qps/ This will then show you if mysqld is running OK. It will also show you the parameters in the above script that you passed to mysqld to get it started. You then need to try and connect to mysqld with the mysql monitor program as already mentioned. If you just set the client options in /etc/my.cnf config file, these will be applied globally to all mysql client programs. EG. # /etc/my.cnf # MySQL client program configuration file # last updated 2006-03-05 # mysqld server configuration file lives in # /usr/local/mysql-/my.cnf #--- # mysql client program configuration options #--- [mysql] auto-rehash # needed for security - to stops multiple deletes/updates # without a where clause safe-updates #--- # The following options will be passed to all MySQL clients [client] socket = /var/lib/mysql/mysql.sock port = 7000 #snip #--- # end of mysql client program configurations # /etc/my.cnf More options for your mysqld server can be set in the --defaults-file=/usr/local/mysql-5.0.18/my.cnf These options are additional to the options you pass in the above script. EG #--- # mysqld server configuration options #--- [mysqld] basedir=/usr/local/mysql-5.0.18 ## use for testing multiple instances of mysqld ## these parameters are normally passed to mysqld ## from the start-mysql-5.0.18 script ## ##basedir=/usr/local/mysql-5.0.18 ##port=7005 ##socket=/usr/local/mysql-5.0.18/data/mysql.sock ##pid-file=/usr/local/mysql-5.0.18/data/laptop.pid ##datadir=/usr/local/mysql-5.0.18/data ##user=mysql server-id=1 #skip-networking skip-name-resolve skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M # logging options log=5-0-18.log log-bin=laptop-bin log-error=5-0-18.error-log log-queries-not-using-indexes log-slow-admin-statements log-slow-queries=5-0-18.slow-log log-warnings #--- # end of mysqld server configuration file # /usr/local/mysql-/my.cnf Next you will need to check php is using the same socket to connect to mysqld server. Use the phpinfo() function in a php script, to verify this. Obviously, you will need the mysql or mysqli extension loaded for this. HTH Keith Roberts In theory, theory and practice are the same; In practice they are not. On Fri, 10 Mar 2006, Logan, David (SST - Adelaide) wrote: > To: Mary Adel <[EMAIL PROTECTED]> > From: "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/en/can-not-connect-to-server.html > > Regards > > > --- > ** _/ ** David Logan > *** _/ *** ITO Delivery Specialist - Database > *_/* Hewlett-Packard Australia Ltd > _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] > _/ _/ _/ _/ Desk: +618 8408 4273 > _/ _/ _/_/_/ Mobile: 0417 268 665 > *_/ ** > ** _/ Postal: 148 Frome Street, > _/ ** Adelaide SA 5001 > Australia > invent > --- > > -Original Message- > From: JC [mailto:[EMAIL 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 > >
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
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: JC [mailto:[EMAIL 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 socket
> '/var/lib/mysql/mysql.sock' (2)
> my code is as follows:
>
> print "hi";
> mysql_connect('localhost', 'root','') or die(mysql_error());
> echo "Connected to MySQL";
> 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 wrote:
>> 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 Message-
>> From: Mary Adel [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, March 09, 2006 3:06 PM
>> To: mysql@lists.mysql.com
>> Subject: php and mysql
>>
>>
>> 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 "hi";
>> mysql_connect('localhost', '', '') or die(mysql_error());
>> echo "Connected to MySQL";
>> print "connected";
>> ?>
>> if their is any configuration please tell me
>>
>> thanks,
>> mary
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/[EMAIL PROTECTED]
>>
>>
>
>
>
--
hi mary,
take a look at
http://www.stanton-finley.net/fedora_core_5_installation_notes.html#MySQ
L.
basically, you need to make sure that your mysql server accepts local
connection.
if you login to your mysql server:
mysql -u root (if no password for root) or
mysql -u root -p (if there is pw for root)
and then:
select user,host,password from mysql.user;
if you don't see an entry for root & localhost, then you need to add it
in.
hope that help.
JC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 wrote:
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 Message-
From: Mary Adel [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 09, 2006 3:06 PM
To: mysql@lists.mysql.com
Subject: php and mysql
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
thanks,
mary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
hi mary,
take a look at
http://www.stanton-finley.net/fedora_core_5_installation_notes.html#MySQL.
basically, you need to make sure that your mysql server accepts local
connection.
if you login to your mysql server:
mysql -u root (if no password for root) or
mysql -u root -p (if there is pw for root)
and then:
select user,host,password from mysql.user;
if you don't see an entry for root & localhost, then you need to add it
in.
hope that help.
JC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: php and mysql
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 wrote:
> 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 Message-
> From: Mary Adel [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 09, 2006 3:06 PM
> To: mysql@lists.mysql.com
> Subject: php and mysql
>
>
> 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 "hi";
> mysql_connect('localhost', '', '') or die(mysql_error());
> echo "Connected to MySQL";
> print "connected";
> ?>
> if their is any configuration please tell me
>
> thanks,
> mary
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: php and mysql
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 create a mysql user just for the db access required by your pages. PB - thanks, mary -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.0/275 - Release Date: 3/6/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: php and mysql
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 Message-
From: Mary Adel [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 09, 2006 3:06 PM
To: mysql@lists.mysql.com
Subject: php and mysql
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
thanks,
mary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
php and mysql
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 thanks, mary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP and mysql
mysqladmin -u root password
Curtis
sheeri kritzer wrote:
> Hi Alaister,
>
> Your root password is not actually set. If you do
>
> mysql -u root -p
> and it fails, it means that the password is not
>
> if you do
>
> mysql -u root
>
> the mysql client will parse as the database you're trying
> to use -- that's just the syntax of the mysql client. Which means
> that your password is not very secure, because it's the same as your
> database name. You should get an error like this:
>
> ERROR 1049 (42000): Unknown database ''
>
> What you should do is this:
>
> # mysql -u root
>> set password=password("");
>
> where is your new password.
>
> hope this helps.
>
> -Sheeri
>
>
> On 10/27/05, Alastair Roy <[EMAIL PROTECTED]> wrote:
>> 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 the script, that works fine, next question is how do I set the
>> permissions for root in mysql to allow root to login, if I use
>> #mysql -u root I go straight in
>> If I use
>> #mysql -u root -p
>>
>> I get access denied for [EMAIL PROTECTED]
>>
>> -Original Message-
>>
>> Visit our websites:
>>
>> http://www.dailysnack.com +IBw-bite size news and gossip+IB0
>>
>> http://www.express.co.uk The Worlds Greatest Newspaper
>>
>> http://www.dailystar.co.uk Simply The Best 7 Days A Week
>>
>> http://www.happymagazine.co.uk The One Stop Shopping Magazine
>>
>> http://www.ok.co.uk First For Celebrity News
>>
>> http://www.northernandshell.co.uk The Mark Of Excellence
>>
>> http://www.expresspictures.com Express Newspapers and OK Magazine
>> online picture archive
>>
>>
>>
>>
>> Also visit:
>>
>> The NMA: Opening Up Newspapers http://www.nmauk.co.uk
>>
>> ###2004###
>>
>> Any views or opinions are solely those of the author
>> and do not necessarily represent those of Express Newspapers
>>
>> The information transmitted is intended only for the person
>> or entity to which it is addressed and may contain confidential
>> and/or privileged material.If you are not the intended recipient
>> of this message please do not read ,copy, use or disclose this
>> communication 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 communications may be monitored.
>>
>>
>> ##EXN2000##
>>
>>
>> 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, 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 the webserver is on.
>>
>> -Sheeri
>>
>> On 10/25/05, Alastair Roy <[EMAIL PROTECTED]> 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 using
>> >
>> >
>> >
>> > > > include 'library/config.php';
>> > include 'library/opendb.php';
>> >
>> > $query = "INSERT INTO user (host, user, password, select_priv,
>> insert_priv,
>> > update_ priv) ".
>> > "VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y',
>> 'Y',
>> > 'Y')";
>> > mysql_query($query) or die('Error, insert query failed');
>> >
>> > $query = "FLUSH PRIVILEGES";
>> > mysql_query($query) or die('Error, insert query failed');
>> >
>> > include '
Re: PHP and mysql
Hi Alaister,
Your root password is not actually set. If you do
mysql -u root -p
and it fails, it means that the password is not
if you do
mysql -u root
the mysql client will parse as the database you're trying
to use -- that's just the syntax of the mysql client. Which means
that your password is not very secure, because it's the same as your
database name. You should get an error like this:
ERROR 1049 (42000): Unknown database ''
What you should do is this:
# mysql -u root
> set password=password("");
where is your new password.
hope this helps.
-Sheeri
On 10/27/05, Alastair Roy <[EMAIL PROTECTED]> wrote:
> 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 the script, that works fine, next question is how do I set the
> permissions for root in mysql to allow root to login, if I use
> #mysql -u root I go straight in
> If I use
> #mysql -u root -p
>
> I get access denied for [EMAIL PROTECTED]
>
> -Original Message-
>
> Visit our websites:
>
> http://www.dailysnack.com +IBw-bite size news and gossip+IB0
>
> http://www.express.co.uk The Worlds Greatest Newspaper
>
> http://www.dailystar.co.uk Simply The Best 7 Days A Week
>
> http://www.happymagazine.co.uk The One Stop Shopping Magazine
>
> http://www.ok.co.uk First For Celebrity News
>
> http://www.northernandshell.co.uk The Mark Of Excellence
>
> http://www.expresspictures.com Express Newspapers and OK Magazine online
> picture archive
>
>
>
>
> Also visit:
>
> The NMA: Opening Up Newspapers http://www.nmauk.co.uk
>
> ###2004###
>
> Any views or opinions are solely those of the author
> and do not necessarily represent those of Express Newspapers
>
> The information transmitted is intended only for the person
> or entity to which it is addressed and may contain confidential
> and/or privileged material.If you are not the intended recipient
> of this message please do not read ,copy, use or disclose this
> communication 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 communications may be monitored.
> ************
>
> ##EXN2000##
>
>
> 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, 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 the webserver is on.
>
> -Sheeri
>
> On 10/25/05, Alastair Roy <[EMAIL PROTECTED]> 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 using
> >
> >
> >
> > > include 'library/config.php';
> > include 'library/opendb.php';
> >
> > $query = "INSERT INTO user (host, user, password, select_priv,
> insert_priv,
> > update_ priv) ".
> > "VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y',
> > 'Y')";
> > mysql_query($query) or die('Error, insert query failed');
> >
> > $query = "FLUSH PRIVILEGES";
> > mysql_query($query) or die('Error, insert query failed');
> >
> > include 'library/closedb.php';
> > ?>
> >
> >
> >
> > When I try this I get the access for user [EMAIL PROTECTED] host denied, it
> > is
> > driving me nuts no matter what I try I get the same thing other scripts I
> > have tried do the same thing, have tried messing around with the
> config.php
> > and opendb.php included scripts but nothing works if I run php -f
> opendb.php
> > I get no errors which I think means it is working, then again I don't
> know.
> >
> >
> >
> > Anyone have any ideas ??
&
RE: PHP and mysql
Hi Alastair,
You don't have a password for root set. The syntax for mysql (the
client) would put your #mysql -u root as setting the database
to .
If you use the -p option, even if you don't supply a password, it will
be rejected if no password is set.
You may like to check out
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Alastair Roy [mailto:[EMAIL 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 the script, that works fine, next question is how do I set the
permissions for root in mysql to allow root to login, if I use
#mysql -u root I go straight in
If I use
#mysql -u root -p
I get access denied for [EMAIL PROTECTED]
-Original Message-
Visit our websites:
http://www.dailysnack.com "bite size news and gossip"
http://www.express.co.uk The Worlds Greatest Newspaper
http://www.dailystar.co.uk Simply The Best 7 Days A Week
http://www.happymagazine.co.uk The One Stop Shopping Magazine
http://www.ok.co.uk First For Celebrity News
http://www.northernandshell.co.uk The Mark Of Excellence
http://www.expresspictures.com Express Newspapers and OK Magazine
online picture archive
Also visit:
The NMA: Opening Up Newspapers http://www.nmauk.co.uk
###2004###
Any views or opinions are solely those of the author
and do not necessarily represent those of Express Newspapers
The information transmitted is intended only for the person
or entity to which it is addressed and may contain confidential
and/or privileged material.If you are not the intended recipient
of this message please do not read ,copy, use or disclose this
communication 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 communications may be monitored.
##EXN2000##
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, 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 the webserver is on.
-Sheeri
On 10/25/05, Alastair Roy <[EMAIL PROTECTED]> 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 using
>
>
>
> include 'library/config.php';
> include 'library/opendb.php';
>
> $query = "INSERT INTO user (host, user, password, select_priv,
insert_priv,
> update_ priv) ".
> "VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y',
'Y',
> 'Y')";
> mysql_query($query) or die('Error, insert query failed');
>
> $query = "FLUSH PRIVILEGES";
> mysql_query($query) or die('Error, insert query failed');
>
> include 'library/closedb.php';
> ?>
>
>
>
> When I try this I get the access for user [EMAIL PROTECTED] host denied, it
is
> driving me nuts no matter what I try I get the same thing other
scripts I
> have tried do the same thing, have tried messing around with the
config.php
> and opendb.php included scripts but nothing works if I run php -f
opendb.php
> I get no errors which I think means it is working, then again I don't
know.
>
>
>
> Anyone have any ideas ??
>
>
>
> Thanks in advance
>
>
> Visit our websites:
>
> http://www.dailysnack.com "bite size news and gossip"
>
> http://www.express.co.uk The Worlds Greatest Newspaper
>
> http://www.dailystar.co.uk Simply The Best 7 Days A Week
>
> http://www.happymagazine.co.uk The One Stop Shopping Magazine
>
> http://www.ok.co.uk First For Celebrity News
>
> http://www.northernandshell.co.uk The Mark Of Excellence
>
> http://www.express
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 the script, that works fine, next question is how do I set the
permissions for root in mysql to allow root to login, if I use
#mysql -u root I go straight in
If I use
#mysql -u root -p
I get access denied for [EMAIL PROTECTED]
-Original Message-
Visit our websites:
http://www.dailysnack.com “bite size news and gossip”
http://www.express.co.uk The Worlds Greatest Newspaper
http://www.dailystar.co.uk Simply The Best 7 Days A Week
http://www.happymagazine.co.uk The One Stop Shopping Magazine
http://www.ok.co.uk First For Celebrity News
http://www.northernandshell.co.uk The Mark Of Excellence
http://www.expresspictures.com Express Newspapers and OK Magazine online
picture archive
Also visit:
The NMA: Opening Up Newspapers http://www.nmauk.co.uk
###2004###
Any views or opinions are solely those of the author
and do not necessarily represent those of Express Newspapers
The information transmitted is intended only for the person
or entity to which it is addressed and may contain confidential
and/or privileged material.If you are not the intended recipient
of this message please do not read ,copy, use or disclose this
communication 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 communications may be monitored.
##EXN2000##
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, 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 the webserver is on.
-Sheeri
On 10/25/05, Alastair Roy <[EMAIL PROTECTED]> 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 using
>
>
>
> include 'library/config.php';
> include 'library/opendb.php';
>
> $query = "INSERT INTO user (host, user, password, select_priv,
insert_priv,
> update_ priv) ".
> "VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y',
> 'Y')";
> mysql_query($query) or die('Error, insert query failed');
>
> $query = "FLUSH PRIVILEGES";
> mysql_query($query) or die('Error, insert query failed');
>
> include 'library/closedb.php';
> ?>
>
>
>
> When I try this I get the access for user [EMAIL PROTECTED] host denied, it is
> driving me nuts no matter what I try I get the same thing other scripts I
> have tried do the same thing, have tried messing around with the
config.php
> and opendb.php included scripts but nothing works if I run php -f
opendb.php
> I get no errors which I think means it is working, then again I don't
know.
>
>
>
> Anyone have any ideas ??
>
>
>
> Thanks in advance
>
>
> Visit our websites:
>
> http://www.dailysnack.com “bite size news and gossip”
>
> http://www.express.co.uk The Worlds Greatest Newspaper
>
> http://www.dailystar.co.uk Simply The Best 7 Days A Week
>
> http://www.happymagazine.co.uk The One Stop Shopping Magazine
>
> http://www.ok.co.uk First For Celebrity News
>
> http://www.northernandshell.co.uk The Mark Of Excellence
>
> http://www.expresspictures.com Express Newspapers and OK Magazine online
picture archive
>
>
>
>
> Also visit:
>
> The NMA: Opening Up Newspapers http://www.nmauk.co.uk
>
> ###2004###
>
> Any views or opinions are solely those of the author
> and do not necessarily represent those of Express Newspapers
>
> The information transmitted is intended only for the person
> or entity to which it is addressed and may contain confidential
> and/or privileged material.If you are not the intended recipient
> of this message please do not read ,copy, use or disclose this
> communication and notify the sender immediately. It should be
> not
Re: PHP and mysql
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 using
>
> include 'library/config.php';
> include 'library/opendb.php';
you can't issue a query until you've defined your connection. Is that done in
one of the above include files? We need to see your connection code (don't show
us the password, of course) if we are to help troubleshoot this.
> $query = "INSERT INTO user (host, user, password, select_priv, insert_priv,
> update_ priv) ".
> "VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y',
> 'Y')";
> mysql_query($query) or die('Error, insert query failed');
"Error, insert query failed" isn't very helpful. You need to print the mysql
error if you want to know what went wrong.
> $query = "FLUSH PRIVILEGES";
> mysql_query($query) or die('Error, insert query failed');
Same here, except this is even worse, as it's the same message as before for a
different query. How will you tell which statement didn't work?
> include 'library/closedb.php';
> ?>
>
> When I try this I get the access for user [EMAIL PROTECTED] host denied, it is
Perhaps that's just a typo, but it should be '[EMAIL PROTECTED]', not
'[EMAIL PROTECTED] host'.
> driving me nuts no matter what I try I get the same thing other scripts I
> have tried do the same thing, have tried messing around with the config.php
> and opendb.php included scripts but nothing works if I run php -f opendb.php
> I get no errors which I think means it is working, then again I don't know.
>
> Anyone have any ideas ??
First, from what I can see, you don't know what's wrong because you don't print
the errors when something goes wrong. Of course, that means we can't tell you
either. I recommend following Example 1 in the PHP manual
<http://www.php.net/manual/en/ref.mysql.php#mysql.examples>, but I'd add that
you should actually print the query string in addition to the error. That way,
you can verify the query is actually what you intended. Something like this:
$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
$query = 'SELECT * FROM my_table';
$result = mysql_query($query) or die("Query: $query
failed: " . mysql_error());
Then, if you still need help, copy and paste the exact error message into your
next post.
Second, you really should use GRANT to add a user and set privileges rather than
directly editing the user table. It's safer (for example, your INSERT will fail
if [EMAIL PROTECTED] already exists, but the equivalent GRANT statement would
still work), and you don't need FLUSH PRIVILEGES.
You appear to be trying to grant global SELECT, INSERT, and UPDATE privs to
[EMAIL PROTECTED] In that case, your two queries can be replaced by this one:
$query = "GRANT SELECT, INSERT, UPDATE ON *.*
TO [EMAIL PROTECTED] IDENTIFIED BY 'mypass'"
See the manual for details of using GRANT (and REVOKE) to manage users
<http://dev.mysql.com/doc/refman/5.0/en/grant.html>.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, 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 the webserver is on.
-Sheeri
On 10/25/05, Alastair Roy <[EMAIL PROTECTED]> 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 using
>
>
>
> include 'library/config.php';
> include 'library/opendb.php';
>
> $query = "INSERT INTO user (host, user, password, select_priv, insert_priv,
> update_ priv) ".
> "VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y',
> 'Y')";
> mysql_query($query) or die('Error, insert query failed');
>
> $query = "FLUSH PRIVILEGES";
> mysql_query($query) or die('Error, insert query failed');
>
> include 'library/closedb.php';
> ?>
>
>
>
> When I try this I get the access for user [EMAIL PROTECTED] host denied, it is
> driving me nuts no matter what I try I get the same thing other scripts I
> have tried do the same thing, have tried messing around with the config.php
> and opendb.php included scripts but nothing works if I run php -f opendb.php
> I get no errors which I think means it is working, then again I don't know.
>
>
>
> Anyone have any ideas ??
>
>
>
> Thanks in advance
>
>
> Visit our websites:
>
> http://www.dailysnack.com +IBw-bite size news and gossip+IB0
>
> http://www.express.co.uk The Worlds Greatest Newspaper
>
> http://www.dailystar.co.uk Simply The Best 7 Days A Week
>
> http://www.happymagazine.co.uk The One Stop Shopping Magazine
>
> http://www.ok.co.uk First For Celebrity News
>
> http://www.northernandshell.co.uk The Mark Of Excellence
>
> http://www.expresspictures.com Express Newspapers and OK Magazine online
> picture archive
>
>
>
>
> Also visit:
>
> The NMA: Opening Up Newspapers http://www.nmauk.co.uk
>
> ###2004###
>
> Any views or opinions are solely those of the author
> and do not necessarily represent those of Express Newspapers
>
> The information transmitted is intended only for the person
> or entity to which it is addressed and may contain confidential
> and/or privileged material.If you are not the intended recipient
> of this message please do not read ,copy, use or disclose this
> communication 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 communications may be monitored.
>
>
> ##EXN2000##
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP and mysql
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 access the mysql database using the root user, and enter information
> into the user table, this is the PHP I am using
>
>
>
> include 'library/config.php';
> include 'library/opendb.php';
>
> +ACQ-query = "INSERT INTO user (host, user, password, select+AF8-priv,
> insert+AF8-priv,
> update+AF8- priv) ".
> "VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y',
> 'Y')";
> mysql+AF8-query(+ACQ-query) or die('Error, insert query failed');
>
> +ACQ-query = "FLUSH PRIVILEGES";
> mysql+AF8-query(+ACQ-query) or die('Error, insert query failed');
>
> include 'library/closedb.php';
> ?>
>
>
>
> When I try this I get the access for user root+AEA-local host denied, it is
> driving me nuts no matter what I try I get the same thing other scripts I
> have tried do the same thing, have tried messing around with the config.php
> and opendb.php included scripts but nothing works if I run php -f opendb.php
> I get no errors which I think means it is working, then again I don't know.
>
>
>
> Anyone have any ideas ??
>
>
>
> Thanks in advance
>
>
> Visit our websites:
>
> http://www.dailysnack.com +IBw-bite size news and gossip+IB0-
>
> http://www.express.co.uk The Worlds Greatest Newspaper
>
> http://www.dailystar.co.uk Simply The Best 7 Days A Week
>
> http://www.happymagazine.co.uk The One Stop Shopping Magazine
>
> http://www.ok.co.uk First For Celebrity News
>
> http://www.northernandshell.co.uk The Mark Of Excellence
>
> http://www.expresspictures.com Express Newspapers and OK Magazine online
> picture archive
>
>
>
>
> Also visit:
>
> The NMA: Opening Up Newspapers http://www.nmauk.co.uk
>
> +ACMAIwAj-2004+ACMAIwAj-
> +AF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8-
> Any views or opinions are solely those of the author
> and do not necessarily represent those of Express Newspapers
> +AF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8-
> The information transmitted is intended only for the person
> or entity to which it is addressed and may contain confidential
> and/or privileged material.If you are not the intended recipient
> of this message please do not read ,copy, use or disclose this
> communication 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 communications may be monitored.
> +ACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACo-
>
> +ACMAIw-EXN2000+ACMAIw-
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP and mysql
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 using When I try this I get the access for user [EMAIL PROTECTED] host denied, it is driving me nuts no matter what I try I get the same thing other scripts I have tried do the same thing, have tried messing around with the config.php and opendb.php included scripts but nothing works if I run php -f opendb.php I get no errors which I think means it is working, then again I don't know. Anyone have any ideas ?? Thanks in advance Visit our websites: http://www.dailysnack.com “bite size news and gossip” http://www.express.co.uk The Worlds Greatest Newspaper http://www.dailystar.co.uk Simply The Best 7 Days A Week http://www.happymagazine.co.uk The One Stop Shopping Magazine http://www.ok.co.uk First For Celebrity News http://www.northernandshell.co.uk The Mark Of Excellence http://www.expresspictures.com Express Newspapers and OK Magazine online picture archive Also visit: The NMA: Opening Up Newspapers http://www.nmauk.co.uk ###2004### Any views or opinions are solely those of the author and do not necessarily represent those of Express Newspapers The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.If you are not the intended recipient of this message please do not read ,copy, use or disclose this communication 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 communications may be monitored. ##EXN2000##
Re: Seg Fault php and MySql ODBC on Linux.
At 16:47 +0300 10-06-2005, Gleb Paharenko wrote: Hello. Check that you have the latest version. There is a bug: http://bugs.mysql.com/bug.php?id=7040 I downloaded yesterday the latest version of ODBC Connector. Version: mysql-max-4.1.8-pc-linux-i686 + MyODBC-3.51.11-2.i586.rpm (libmyodbc3-3.51.11.so) Give me a seg fault. mysql-max-4.1.8-pc-linux-i686 + libmyodbc-2.50.39.so Works (if I change the socket to '/var/lib/mysql/mysql.sock' from '/tmp/mysql.sock' Santino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Seg Fault php and MySql ODBC on Linux.
Hello. Check that you have the latest version. There is a bug: http://bugs.mysql.com/bug.php?id=7040 Santino <[EMAIL PROTECTED]> wrote: > Hello, > > I have a segmentation fault using MySql with PHP/ODBC on Linux. > > I do a query with exec and I get a segmentation fault in "my_SQLPrepare". > > If I use the isql command line, all works fine. > > Is it a MySql problem or a Php problem? > > Thank you. > > Santino Cusimano > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Seg Fault php and MySql ODBC on Linux.
Hello, I have a segmentation fault using MySql with PHP/ODBC on Linux. I do a query with exec and I get a segmentation fault in "my_SQLPrepare". If I use the isql command line, all works fine. Is it a MySql problem or a Php problem? Thank you. Santino Cusimano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: php and mysql
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 (went fine, I can connect), apache_1.3.31 (went fine, I can launch the web server) now I have installed php-4.3.9 and when I configure it using ./configure --with-mysql=/usr/local/mysql it goes fine , but when I try to use make, I got an error: checking for mysql_close.. Please can you help? Regards Fernando Retagi Cornastone Mozambique Lda Tel. +258 1 311700/06 e-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
php and mysql
Hi All! I have installed mysql 4.0.20 (went fine, I can connect), apache_1.3.31 (went fine, I can launch the web server) now I have installed php-4.3.9 and when I configure it using ./configure --with-mysql=/usr/local/mysql it goes fine , but when I try to use make, I got an error: checking for mysql_close.. Please can you help? Regards Fernando Retagi Cornastone Mozambique Lda Tel. +258 1 311700/06 e-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: PHP and MySQL
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
descriptive error message.
Regards,
David Bevan
GetAnyIdeas Web Design
P. 416.452.9410
F. 416.570.4529
E. [EMAIL PROTECTED]
W. http://www.getanyideas.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP and MySQL
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 too. Apache is > enhanced with PHP and they works together perfect. The only problem is > with using MySQL through PHP. What version of PHP are you running? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP and MySQL
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 too. Apache is
enhanced with PHP and they works together perfect. The only problem is
with using MySQL through PHP. I think PHP should automatically use its
built-in functions to manipulate MySQL databases, isn't it ? 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 ?
Thanks,
Danesh Daroui
Re: PHP and Mysql
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 table data .
Respectfully,
Ligaya Turmelle
"Seena Blace" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> Does any one help me in formating the output result in PHP with mysql?
> The code is here.
>
>
> $username="root";
> $password="";
> $database="databasename";
> $host="localhost";
> $today = date("F j, Y, g:i a");
> mysql_connect($host,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
> #echo "Connected successfully";
> #$softwareid=$_GET['softwareid'];
> #$softwareid1=$_GET['softwareid1'];
> $query="SELECT hostid,hostname,cabinetnumber FROM host";
> $result=mysql_query($query);
> $num=mysql_numrows($result);
> mysql_close();
> echo "Host Details $today";
> $i=0;
> while ($i < $num) {
> $hostid=mysql_result($result,$i,"hostid");
> $hostname=mysql_result($result,$i,"hostname");
> $cabinetnumber=mysql_result($result,$i,"cabinetnumber");
> echo "$hostid $hostname
$cabinetnumber ";
> //echo "$softwareid $manufacturername: $nameVersion:
$version";
> Thanks
>
>
>
> -
> Do you Yahoo!?
> Yahoo! Search - Find what you're looking for faster.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP and Mysql
Hi,
Does any one help me in formating the output result in PHP with mysql?
The code is here.
Host Details $today";
$i=0;
while ($i < $num) {
$hostid=mysql_result($result,$i,"hostid");
$hostname=mysql_result($result,$i,"hostname");
$cabinetnumber=mysql_result($result,$i,"cabinetnumber");
echo "$hostid $hostname
$cabinetnumber ";
//echo "$softwareid $manufacturername: $nameVersion:
$version";
Thanks
-
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster.
Re: PHP AND MYSQL
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 like:
$softwareid = $_POST["softwareid"];
$manufacturer = $_POST["manufacture"];
etc, etc...
Plus...are you able to connect to the db server?
Use:
mysql_connectd("$host", "$username", "$password");
-- Jason
On Mon, 2004-02-02 at 16:07, Seena Blace wrote:
> Hi,
> Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can please
> help me.
> When I 'm inserting data thru html FORM ,getting error Notice: Undefined variable:
> like this.Can some one please send some tips pl?
> Html code:
>
>
> Software id: [input]
> Manufacturer: [input]
> Name: [input]
> Version: [input]
> [input]
>
> >
> PHP code
> > $database="testdatabase";
> mysql_connect("localhost");
> @mysql_select_db($database) or die( "Unable to select database");
> $query = "INSERT INTO software1 VALUES
> ('','$softwareid','$manufacturer','$name','$version')";
> mysql_query($query);
> mysql_close();
> ?>
>
> Let me know what is wrong pl.
> thx -seena
>
>
> -
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!
-
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: PHP AND MYSQL
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: Seena Blace [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 4:08 PM To: [EMAIL PROTECTED] Subject: PHP AND MYSQL Hi, Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can please help me. When I 'm inserting data thru html FORM ,getting error Notice: Undefined variable: like this.Can some one please send some tips pl? Html code: Software id: Manufacturer: Name: Version: Let me know what is wrong pl. thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP AND MYSQL
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 please help me. When I 'm inserting data thru html FORM ,getting error Notice: Undefined variable: like this.Can some one please send some tips pl? Html code: Software id: Manufacturer: Name: Version: PHP code Let me know what is wrong pl. thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP AND MYSQL
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["manufacture"];
etc, etc...
Plus...are you able to connect to the db server?
Use:
mysql_connectd("$host", "$username", "$password");
-- Jason
On Mon, 2004-02-02 at 16:07, Seena Blace wrote:
> Hi,
> Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can please
> help me.
> When I 'm inserting data thru html FORM ,getting error Notice: Undefined variable:
> like this.Can some one please send some tips pl?
> Html code:
>
>
> Software id:
> Manufacturer:
> Name:
> Version:
>
>
>
> PHP code
> $database="testdatabase";
> mysql_connect("localhost");
> @mysql_select_db($database) or die( "Unable to select database");
> $query = "INSERT INTO software1 VALUES
> ('','$softwareid','$manufacturer','$name','$version')";
> mysql_query($query);
> mysql_close();
> ?>
>
> Let me know what is wrong pl.
> thx -seena
>
>
> -
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP AND MYSQL
Hi, Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can please help me. When I 'm inserting data thru html FORM ,getting error Notice: Undefined variable: like this.Can some one please send some tips pl? Html code: Software id: Manufacturer: Name: Version: Let me know what is wrong pl. thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
Re: FW: How To Learn php and mysql.
Thanks Ricard, Mike,Kim,Chris and John. Now thats going the extra mile, giving me the ISBN code to the book. Once again, thanks. Braulio "mike" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > >As for a book, I recommend the one on PHP and mySQL web development by Luke > Willing and Laura Thompson. > > >Good luck! > >Richard > > I would second that reccomendation. Luke Welling and Laura Thompson have a really good book. ISBN 067232525X. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FW: How To Learn php and mysql.
>As for a book, I recommend the one on PHP and mySQL web development by Luke Willing and Laura Thompson. >Good luck! >Richard I would second that reccomendation. Luke Welling and Laura Thompson have a really good book. ISBN 067232525X. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Learn php and mysql.
Thanks, John. Braulio "John Nichel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Braulio Lumbreras wrote: > > > What is the best way to learn php and mysql? What book is recommended for > > self study of both ? > > > > Braulio > > > > The PHP website is an excelent place. The online manual is real nice, > and there are plenty of user comments which I have found useful. The > PHP mailing list is a good place to go when your stuck, as well as this > mailing list when you need to solve a MySQL problem (after you've > googled and searched the archives that is ;). I'm not much for actual > print books, but I found, "Web Database Applications with PHP & MySQL" > from O'Reilly to be a pretty interesting read. > > -- > By-Tor.com > It's all about the Rush > http://www.by-tor.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Learn php and mysql.
Thanks, Chris. Braulio ""Chris"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > PHP and MySQL Web Development, by Luke Welling and Laura Thomson > > It's an excellent book. > > -Original Message- > From: Richard Bewley [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 6:53 PM > To: [EMAIL PROTECTED] > Subject: FW: How To Learn php and mysql. > > > The best way to learn is by taking a script (I used a message board written > in php/mysql) and hacking it, then running it on your webserver, breaking > it, and fixing it again. Just make tiny changes at first, play with logic, > then work on bigger things. > > As for a book, I recommend the one on PHP and mySQL web development by Luke > Willing and Laura Thompson. > > Good luck! > Richard > > -Original Message- > From: Braulio Lumbreras [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 9:48 PM > To: [EMAIL PROTECTED] > Subject: How To Learn php and mysql. > > What is the best way to learn php and mysql? What book is recommended for > self study of both ? > > Braulio > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How To Learn php and mysql.
PHP and MySQL Web Development, by Luke Welling and Laura Thomson It's an excellent book. -Original Message- From: Richard Bewley [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 6:53 PM To: [EMAIL PROTECTED] Subject: FW: How To Learn php and mysql. The best way to learn is by taking a script (I used a message board written in php/mysql) and hacking it, then running it on your webserver, breaking it, and fixing it again. Just make tiny changes at first, play with logic, then work on bigger things. As for a book, I recommend the one on PHP and mySQL web development by Luke Willing and Laura Thompson. Good luck! Richard -Original Message- From: Braulio Lumbreras [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 9:48 PM To: [EMAIL PROTECTED] Subject: How To Learn php and mysql. What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Learn php and mysql.
Braulio Lumbreras wrote: What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio The PHP website is an excelent place. The online manual is real nice, and there are plenty of user comments which I have found useful. The PHP mailing list is a good place to go when your stuck, as well as this mailing list when you need to solve a MySQL problem (after you've googled and searched the archives that is ;). I'm not much for actual print books, but I found, "Web Database Applications with PHP & MySQL" from O'Reilly to be a pretty interesting read. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Learn php and mysql.
Thanks,Kim. G'day to you too. Braulio "Kim Kohen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] G'day Braulio > What is the best way to learn php and mysql? What book is recommended for > self study of both ? As an absolute newbie I used "Build Your Own Database Driven Website Using PHP & MySQL" from http://www.sitepoint.com/books/phpmysql1/ It got us up and running pretty painlessly. You can download the first 4 chapters for free and see if it's the sort of thing you're after. cheers Kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Learn php and mysql.
G'day Braulio > What is the best way to learn php and mysql? What book is recommended for > self study of both ? As an absolute newbie I used "Build Your Own Database Driven Website Using PHP & MySQL" from http://www.sitepoint.com/books/phpmysql1/ It got us up and running pretty painlessly. You can download the first 4 chapters for free and see if it's the sort of thing you're after. cheers Kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Learn php and mysql.
Thanks, Richard. What is the name of the book by Luke Willing and Laura Thompson? Braulio ""Richard Bewley"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > The best way to learn is by taking a script (I used a message board written > in php/mysql) and hacking it, then running it on your webserver, breaking > it, and fixing it again. Just make tiny changes at first, play with logic, > then work on bigger things. > > As for a book, I recommend the one on PHP and mySQL web development by Luke > Willing and Laura Thompson. > > Good luck! > Richard > > -Original Message- > From: Braulio Lumbreras [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 9:48 PM > To: [EMAIL PROTECTED] > Subject: How To Learn php and mysql. > > What is the best way to learn php and mysql? What book is recommended for > self study of both ? > > Braulio > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: How To Learn php and mysql.
The best way to learn is by taking a script (I used a message board written in php/mysql) and hacking it, then running it on your webserver, breaking it, and fixing it again. Just make tiny changes at first, play with logic, then work on bigger things. As for a book, I recommend the one on PHP and mySQL web development by Luke Willing and Laura Thompson. Good luck! Richard -Original Message- From: Braulio Lumbreras [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 9:48 PM To: [EMAIL PROTECTED] Subject: How To Learn php and mysql. What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How To Learn php and mysql.
What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
php and mysql email problem...
I'm not sure I'm posting this to the correct list. If I'm not, please reply and let me know which list to post this to. Thanks. We have a php-mysql web-based e-mail system that has a problem that has happened twice in a 2 month period. This morning, somebody logged into it and all of his mail was gone. We ran 'mysql repair ' . It cycles through each table in the database. It gives a 'OK' for each one except for the e-mail table. It says something about corrupt numbers. It's like one off or something. It fixes the problem. I'm wanting to know if anybody else has had any problems like this or any information about it, including any work-arounds to keep it from happening. Thanks in advance, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: php and mysql
You need to install a package. Unless you install PHP from source and include MySQL at Compile time. If you install PHP from a RPM package, you will need to install a package called php-mysql-.rpm Thanks Emery - Original Message - From: "Adam Clauss" <[EMAIL PROTECTED]> 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: > 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 PM > > To: [EMAIL PROTECTED] > > Subject: php and mysql > > > > > > hi > > i want to use php with mysql. However, i do not know > > if i should install another package from mysql that > > incluse shared library between php and mysql?. i > > already installed mysql client and server package. if > > there more package i should install,can you please > > tell the name and where can i find it? > > > >redhat8.0 > >mysql 4.0.15 > > thanks > > > > __ > > Do you Yahoo!? > > The New Yahoo! Shopping - with improved product search > > http://shopping.yahoo.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: php and mysql
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: <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 03:48 Subject: php and mysql > hi > i want to use php with mysql. However, i do not know > if i should install another package from mysql that > incluse shared library between php and mysql?. i > already installed mysql client and server package. if > there more package i should install,can you please > tell the name and where can i find it? > >redhat8.0 >mysql 4.0.15 > thanks > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: php and mysql
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 PM > To: [EMAIL PROTECTED] > Subject: php and mysql > > > hi > i want to use php with mysql. However, i do not know > if i should install another package from mysql that > incluse shared library between php and mysql?. i > already installed mysql client and server package. if > there more package i should install,can you please > tell the name and where can i find it? > >redhat8.0 >mysql 4.0.15 > thanks > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
php and mysql
hi i want to use php with mysql. However, i do not know if i should install another package from mysql that incluse shared library between php and mysql?. i already installed mysql client and server package. if there more package i should install,can you please tell the name and where can i find it? redhat8.0 mysql 4.0.15 thanks __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Announcement] for PHP and MySQL 4.1 Users/Testers
Hi, The new mysql extension (ext/mysqli) is now in the php-cvs-repository. Please note that you need MySQL Version 4.1 (both server and client library) and that this extension has experimental status. Configuration: --with-mysqli=/path-to-mysql-4.1 -without-mysql If you want to use both ext/mysql and ext/mysqli you have to specity --with-mysqli=/path-to-mysql-4.1 --with-mysql=/path-to-mysql-4.1 Some new features: OO and plain interface SSL connection support Variable bindings Bigint support Replication support For some samples check the tests subdir. I'll add documentation within the next days. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: PHP and MySQL bug
Doesn't you have any simpler answer??
Maybe installing the new version of mysql server - I have version 3.23.49 -
should do the trick
- Original Message -
From: "Larry Brown" <[EMAIL PROTECTED]>
To: "Nuno Lopes" <[EMAIL PROTECTED]>; "MySQL 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 absolutely necessary and stop everything in the registry under run
> and stop anything in the start folder of the start menu and run the same
> tests. If no positive results I would uninstall php completely and clean
> any reference in the registry of it and then install with everything still
> shut down. Retest, if no progress do the same with mysql. These are
> radical and time-consuming methods, but it seems as though it is broken.
If
> you absolutely need this fixed fast you might resort to paying the
> developers to give you a solution, although it may end up being what I
just
> listed, or it could be some simple fix that we aren't aware of.
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
> -Original Message-
> 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 pconnect the error is the same!
>
>
> - Original Message -----
> From: "Larry Brown" <[EMAIL PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> 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_pconnect instead of
> connect
> > just to see what result you get. I have read some unfavorable
statements
> > about using pconnect with a large number of hits so if it works you
should
> > read the comments about it on php.net. Do a search for mysql_pconnect.
> >
> > Larry S. Brown
> > Dimension Networks, Inc.
> > (727) 723-8388
> >
> > -Original Message-
> > From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, January 06, 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 Brown" <[EMAIL PROTECTED]>
> > To: "MySQL List" <[EMAIL PROTECTED]>
> > Sent: Sunday, January 05, 2003 4:16 PM
> > Subject: Re:PHP and MySQL bug
> >
> >
> > > Try replacing the following line...
> > >
> > > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query
> doesn't
> > > work
> > >
> > > With...
> > >
> > > $query = "UPDATE d SET h='$h' WERE id='$id'";
> > > $queryr = mysql_query($query) or die("The sql statement does not
> > execute");
> > >
> > > if(mysql_affected_rows() !== 1)
> > > {
> > >die("The sql statement is successfully run however either h did not
> > > change or there is an internal error. Try executing the sql from the
> > > command line to make sure it otherwise works.");
> > > }
> > >
> > > and see which is coming back.
> > >
> > >
> > > Larry S. Brown
> > > Dimension Networks, Inc.
> > > (727) 723-8388
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: PHP and MySQL bug
@mysql_select_db("be"); // this doesn't fail, because only the second
(UPDATE) query fails. The first query (SELECT) is done!
- Original Message -
From: "Marek Kilimajer" <[EMAIL PROTECTED]>
To: "Nuno Lopes" <[EMAIL PROTECTED]>
Cc: "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:
>
> >I done a echo of Mysql_error and it returned:
> >'Nenhum banco de dados foi selecionado'
> >
> >(I have the mysql server in portuguese, but the translation is something
> >like '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='$id'"); // this
> >> > query doesn't work
> >>
> >>Personally, I'd call it bad programming practice to do a database update
> >>and not check to see if it worked or not. In this case, how are you
> >>determining that the query did not work? Are you manually checking the
> >>database? You don't have anything in your code to check the status of
> >>this query.
> >>
> >>Perhaps this might get you somewhere:
> >>
> >>$qid = @mysql_query("UPDATE d SET h = '$h' WHERE id = '$id'");
> >>
> >>if (isset($qid) && mysql_affected_rows() == 1)
> >>{
> >> echo "query executed";
> >>} else {
> >> echo "query failed: " . mysql_error();
> >>}
> >>
> >>At least this way you might get some indication of where the problem is.
> >>
> >>CYA, Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: PHP and MySQL bug
* 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 name of the computer with the db. If the db is on a system other than the one with the web server than you should check the network/network cards for errors. The connection may be dropping because of communication. If it is on the same box then some other memory resident program etc may be causing the connection to drop. Refer to my previous post in re. to stopping services etc. * MySQL * Larry S. Brown Dimension Networks, Inc. (727) 723-8388 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: PHP and MySQL bug
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 bug
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 is located
>
>
> - Original Message -
> From: "Nuno Lopes" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, January 07, 2003 7:31 AM
> 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 pconnect the error is the same!
> >
> >
> > - Original Message -
> > From: "Larry Brown" <[EMAIL PROTECTED]>
> > To: "MySQL List" <[EMAIL PROTECTED]>
> > 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_pconnect instead
> > > of
> > connect
> > > just to see what result you get. I have read some unfavorable
> statements
> > > about using pconnect with a large number of hits so if it works
> > > you
> should
> > > read the comments about it on php.net. Do a search for
mysql_pconnect.
> > >
> > > Larry S. Brown
> > > Dimension Networks, Inc.
> > > (727) 723-8388
> > >
> > > -Original Message-
> > > From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, January 06, 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 Brown" <[EMAIL PROTECTED]>
> > > To: "MySQL List" <[EMAIL PROTECTED]>
> > > Sent: Sunday, January 05, 2003 4:16 PM
> > > Subject: Re:PHP and MySQL bug
> > >
> > >
> > > > Try replacing the following line...
> > > >
> > > > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this
> > > > query
> > doesn't
> > > > work
> > > >
> > > > With...
> > > >
> > > > $query = "UPDATE d SET h='$h' WERE id='$id'";
> > > > $queryr = mysql_query($query) or die("The sql statement does not
> > > execute");
> > > >
> > > > if(mysql_affected_rows() !== 1)
> > > > {
> > > >die("The sql statement is successfully run however either h
> > > > did
not
> > > > change or there is an internal error. Try executing the sql
> > > > from
the
> > > > command line to make sure it otherwise works.");
> > > > }
> > > >
> > > > and see which is coming back.
> > > >
> > > >
> > > > Larry S. Brown
> > > > Dimension Networks, Inc.
> > > > (727) 723-8388
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: PHP and MySQL bug
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 is located
>
>
> - Original Message -
> From: "Nuno Lopes" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, January 07, 2003 7:31 AM
> 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 pconnect the error is the same!
> >
> >
> > - Original Message -
> > From: "Larry Brown" <[EMAIL PROTECTED]>
> > To: "MySQL List" <[EMAIL PROTECTED]>
> > 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_pconnect instead of
> > connect
> > > just to see what result you get. I have read some unfavorable
> statements
> > > about using pconnect with a large number of hits so if it works you
> should
> > > read the comments about it on php.net. Do a search for
mysql_pconnect.
> > >
> > > Larry S. Brown
> > > Dimension Networks, Inc.
> > > (727) 723-8388
> > >
> > > -Original Message-
> > > From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, January 06, 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 Brown" <[EMAIL PROTECTED]>
> > > To: "MySQL List" <[EMAIL PROTECTED]>
> > > Sent: Sunday, January 05, 2003 4:16 PM
> > > Subject: Re:PHP and MySQL bug
> > >
> > >
> > > > Try replacing the following line...
> > > >
> > > > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query
> > doesn't
> > > > work
> > > >
> > > > With...
> > > >
> > > > $query = "UPDATE d SET h='$h' WERE id='$id'";
> > > > $queryr = mysql_query($query) or die("The sql statement does not
> > > execute");
> > > >
> > > > if(mysql_affected_rows() !== 1)
> > > > {
> > > >die("The sql statement is successfully run however either h did
not
> > > > change or there is an internal error. Try executing the sql from
the
> > > > command line to make sure it otherwise works.");
> > > > }
> > > >
> > > > and see which is coming back.
> > > >
> > > >
> > > > Larry S. Brown
> > > > Dimension Networks, Inc.
> > > > (727) 723-8388
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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:
I done a echo of Mysql_error and it returned:
'Nenhum banco de dados foi selecionado'
(I have the mysql server in portuguese, but the translation is something
like '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='$id'"); // this
> query doesn't work
Personally, I'd call it bad programming practice to do a database update
and not check to see if it worked or not. In this case, how are you
determining that the query did not work? Are you manually checking the
database? You don't have anything in your code to check the status of
this query.
Perhaps this might get you somewhere:
$qid = @mysql_query("UPDATE d SET h = '$h' WHERE id = '$id'");
if (isset($qid) && mysql_affected_rows() == 1)
{
echo "query executed";
} else {
echo "query failed: " . mysql_error();
}
At least this way you might get some indication of where the problem is.
CYA, Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 absolutely necessary and stop everything in the registry under run
and stop anything in the start folder of the start menu and run the same
tests. If no positive results I would uninstall php completely and clean
any reference in the registry of it and then install with everything still
shut down. Retest, if no progress do the same with mysql. These are
radical and time-consuming methods, but it seems as though it is broken. If
you absolutely need this fixed fast you might resort to paying the
developers to give you a solution, although it may end up being what I just
listed, or it could be some simple fix that we aren't aware of.
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message-
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 pconnect the error is the same!
- Original Message -
From: "Larry Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
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_pconnect instead of
connect
> just to see what result you get. I have read some unfavorable statements
> about using pconnect with a large number of hits so if it works you should
> read the comments about it on php.net. Do a search for mysql_pconnect.
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
> -Original Message-
> From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 06, 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 Brown" <[EMAIL PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> Sent: Sunday, January 05, 2003 4:16 PM
> Subject: Re:PHP and MySQL bug
>
>
> > Try replacing the following line...
> >
> > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query
doesn't
> > work
> >
> > With...
> >
> > $query = "UPDATE d SET h='$h' WERE id='$id'";
> > $queryr = mysql_query($query) or die("The sql statement does not
> execute");
> >
> > if(mysql_affected_rows() !== 1)
> > {
> >die("The sql statement is successfully run however either h did not
> > change or there is an internal error. Try executing the sql from the
> > command line to make sure it otherwise works.");
> > }
> >
> > and see which is coming back.
> >
> >
> > Larry S. Brown
> > Dimension Networks, Inc.
> > (727) 723-8388
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 pconnect the error is the same!
- Original Message -
From: "Larry Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
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_pconnect instead of
connect
> just to see what result you get. I have read some unfavorable statements
> about using pconnect with a large number of hits so if it works you should
> read the comments about it on php.net. Do a search for mysql_pconnect.
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
> -Original Message-
> From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 06, 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 Brown" <[EMAIL PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> Sent: Sunday, January 05, 2003 4:16 PM
> Subject: Re:PHP and MySQL bug
>
>
> > Try replacing the following line...
> >
> > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query
doesn't
> > work
> >
> > With...
> >
> > $query = "UPDATE d SET h='$h' WERE id='$id'";
> > $queryr = mysql_query($query) or die("The sql statement does not
> execute");
> >
> > if(mysql_affected_rows() !== 1)
> > {
> >die("The sql statement is successfully run however either h did not
> > change or there is an internal error. Try executing the sql from the
> > command line to make sure it otherwise works.");
> > }
> >
> > and see which is coming back.
> >
> >
> > Larry S. Brown
> > Dimension Networks, Inc.
> > (727) 723-8388
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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_pconnect instead of connect
just to see what result you get. I have read some unfavorable statements
about using pconnect with a large number of hits so if it works you should
read the comments about it on php.net. Do a search for mysql_pconnect.
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 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 Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 4:16 PM
Subject: Re:PHP and MySQL bug
> Try replacing the following line...
>
> @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query doesn't
> work
>
> With...
>
> $query = "UPDATE d SET h='$h' WERE id='$id'";
> $queryr = mysql_query($query) or die("The sql statement does not
execute");
>
> if(mysql_affected_rows() !== 1)
> {
>die("The sql statement is successfully run however either h did not
> change or there is an internal error. Try executing the sql from the
> command line to make sure it otherwise works.");
> }
>
> and see which is coming back.
>
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL bug
It would be helpful if you posted that error. You can get it by changing
the die to
$queryr = mysql_query($query) or die(mysql_error());
Without knowing the error, you problem will be harder for everyone to debug.
-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: 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: "Larry Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 4:16 PM
Subject: Re:PHP and MySQL bug
> Try replacing the following line...
>
> @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query doesn't
> work
>
> With...
>
> $query = "UPDATE d SET h='$h' WERE id='$id'";
> $queryr = mysql_query($query) or die("The sql statement does not
execute");
>
> if(mysql_affected_rows() !== 1)
> {
>die("The sql statement is successfully run however either h did not
> change or there is an internal error. Try executing the sql from the
> command line to make sure it otherwise works.");
> }
>
> and see which is coming back.
>
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.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 Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 4:16 PM
Subject: Re:PHP and MySQL bug
> Try replacing the following line...
>
> @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query doesn't
> work
>
> With...
>
> $query = "UPDATE d SET h='$h' WERE id='$id'";
> $queryr = mysql_query($query) or die("The sql statement does not
execute");
>
> if(mysql_affected_rows() !== 1)
> {
>die("The sql statement is successfully run however either h did not
> change or there is an internal error. Try executing the sql from the
> command line to make sure it otherwise works.");
> }
>
> and see which is coming back.
>
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: PHP and MySQL bug
I done a echo of Mysql_error and it returned:
'Nenhum banco de dados foi selecionado'
(I have the mysql server in portuguese, but the translation is something
like '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='$id'"); // this
> > query doesn't work
>
> Personally, I'd call it bad programming practice to do a database update
> and not check to see if it worked or not. In this case, how are you
> determining that the query did not work? Are you manually checking the
> database? You don't have anything in your code to check the status of
> this query.
>
> Perhaps this might get you somewhere:
>
> $qid = @mysql_query("UPDATE d SET h = '$h' WHERE id = '$id'");
>
> if (isset($qid) && mysql_affected_rows() == 1)
> {
> echo "query executed";
> } else {
> echo "query failed: " . mysql_error();
> }
>
> At least this way you might get some indication of where the problem is.
>
> CYA, Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL bug
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 dowload. No caso de um mirror estar indisponível, utilize
outro.";
}
}
@MYSQL_CLOSE();
?>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL bug
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 work because of the /* Some code including ... */ part ;-)
First thing, I would check if $h and $id really are what you expect them
to be, like:
$sql = "UPDATE d SET h='$h' WHERE id='$id'";
echo $sql;
MYSQL_QUERY($sql);
If this part is okay, then the problem lies within this myterious /*
Some code */.
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Nuno Lopes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 11:46 AM
Subject: PHP and MySQL bug
> Dear Sirs,
>
> I'm using PHP and MySQL to make my programs. But I think I discovered
a bug
> in PHP or in MySQL (I don't know!).
>
> In one of my files I have the following:
>
> MYSQL_CONNECT("localhost", "**user**", "**pass**");
> mysql_select_db("be");
> $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! But if I close the
connection and
> open another te query is done:*/
>
> MYSQL_CLOSE();
> MYSQL_CONNECT("localhost", "**user**", "**pass**");
> mysql_select_db("be");
> MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
>
> ---
> I don't know why is this? Because I'm used to do more than a query per
> connection and this never happened!
> I'm using Win 2k, Apache 2.0.43, MySQL 3.23.49-nt and PHP 4.3.
>
>
> I hope you solve this,
> Nuno Lopes
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PHP and MySQL bug
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. Right now I have to assume certain steps are being made. If they
are than I don't have a solution but I'd rather go with what you are
actually doing than go by my assumptions. By all means hide the names of
the innocent and continue with a,b,c but just don't do "..."
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 04, 2003 5:46 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: PHP and MySQL bug
Dear Sirs,
I'm using PHP and MySQL to make my programs. But I think I discovered a bug
in PHP or in MySQL (I don't know!).
In one of my files I have the following:
MYSQL_CONNECT("localhost", "**user**", "**pass**");
mysql_select_db("be");
$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! But if I close the connection and
open another te query is done:*/
MYSQL_CLOSE();
MYSQL_CONNECT("localhost", "**user**", "**pass**");
mysql_select_db("be");
MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
---
I don't know why is this? Because I'm used to do more than a query per
connection and this never happened!
I'm using Win 2k, Apache 2.0.43, MySQL 3.23.49-nt and PHP 4.3.
I hope you solve this,
Nuno Lopes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and MySQL bug
Dear Sirs,
I'm using PHP and MySQL to make my programs. But I think I discovered a bug
in PHP or in MySQL (I don't know!).
In one of my files I have the following:
MYSQL_CONNECT("localhost", "**user**", "**pass**");
mysql_select_db("be");
$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! But if I close the connection and
open another te query is done:*/
MYSQL_CLOSE();
MYSQL_CONNECT("localhost", "**user**", "**pass**");
mysql_select_db("be");
MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
---
I don't know why is this? Because I'm used to do more than a query per
connection and this never happened!
I'm using Win 2k, Apache 2.0.43, MySQL 3.23.49-nt and PHP 4.3.
I hope you solve this,
Nuno Lopes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and MySQL 4.0.x
I am trying to setup PHP 4.2.x wth MySQL 4.0.x Somewhat new to this, I installed PHP via the redhat RPM. PHP is being loaded as a module to httpd. The error I keep getting is that httpd can't find libmysqlclient.so.10 and MySQL 4.0.x rpm installed libmysqlclient.so.11. I tried making a symlink from 11 to 10, but that just caused httpd to crash. Is there a newer php mysql.so libary? Does anyone have any ideas? sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL help please !
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", "user", "password");
>
> Ideas ? Why is it now a undefined function ?
>
> Andrew
> -Original Message-
> From: Andrew Rich [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 25 April 2002 11:14 AM
> To: [EMAIL PROTECTED]
> Subject: PHP and MySQL help please !
>
> + PHP Installed and going - I can write to files, retrieve flatfiles
> + Apache running servers outpages nop probes
>
> Trying to talk to SQL using PHP.
>
> --
>
>
> Go to SQL now
> echo "looking";
>@ $db = mysql_pconnect("localhost", "user", "password");
> if (!$db);
> {
> echo "Error: Could not connect to database. Please try again later.";
> exit;
> }
> mysql_select_db("test");
> $query = "select * from logbook" ;
> $result = mysql_query($query);
> $num_results = mysql_num_rows($result);
> echo "Number of books found: ".$num_results."";
> ?>
>
>
>
> -
> What gets me if I can do all this from the mysql prompt:-
> laptop>mysql -u user -p (enterpassword gets me in)
> mysql>use test; OK
> mysql>select * from logbook; OK (shows entries no probs);
>
> -
> What am I doing wrong ?
>
> It doesnt get past the
>
> @ $db = mysql_pconnect("localhost", "user", "password");
>
> in the code.
>
> ??
>
> Andrew
>
> ---
> Andrew Rich
> Callsign: VK4TEC
> [EMAIL PROTECTED]
> www.users.bigpond.com/andrew.rich/vk4tec.htm
>
> ---
> Andrew Rich
> Callsign: VK4TEC
> [EMAIL PROTECTED]
> www.users.bigpond.com/andrew.rich/vk4tec.htm
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PHP and MySQL help please !
> I am not sure if the include statement is design to add mysql BINARIES or
> SOURCE CODE ??
Neither. It's eventually going to link the final php binary with
the mysql shared libraries (probably libmysqlclient).
I'm not too familiar with PHP, so I don't know if '--with-mysql=' wants
the location of the MySQL root directory (typically /usr/local/mysql for
source installations) or the directory that contains the libraries (like
above, but /usr/local/mysql/lib).
Check to see if /usr/local/mysql exists first.
Better yet, try this:
find /usr -name libmysqlclient*
Hopefully, it will show you the location of one (or more) MySQL client
libraries.
Start there.
Michael
On Thu, 25 Apr 2002, Andrew Rich wrote:
> Fatal Error: Call to undefined function: mysql_connect() in
> /var/www/html/results.php
>
> + I think my PHP does not have mysql included, although I put in the
> ./configure --with mysql=/usr/local/mysql \
> + When I type "which mysql" it says "/usr/bin/msql"
> + So should I put:-
>
>./configure --with-mysql=/usr/local/mysql OR
> ./configure --with-mysql=/usr/bin/mysql
>
> ?
>
> 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 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", "password");
>
> $db = mysql_pconnect("localhost", "user", "password");
>
>
> Ideas ? Why is it now a undefined function ?
>
> Andrew
> -Original Message-
> From: Andrew Rich [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 25 April 2002 11:14 AM
> To: [EMAIL PROTECTED]
> Subject: PHP and MySQL help please !
>
>
> + PHP Installed and going - I can write to files, retrieve flatfiles
> + Apache running servers outpages nop probes
>
> Trying to talk to SQL using PHP.
>
> --
>
>
> Go to SQL now
> echo "looking";
>@ $db = mysql_pconnect("localhost", "user", "password");
> if (!$db);
> {
> echo "Error: Could not connect to database. Please try again later.";
> exit;
> }
> mysql_select_db("test");
> $query = "select * from logbook" ;
> $result = mysql_query($query);
> $num_results = mysql_num_rows($result);
> echo "Number of books found: ".$num_results."";
> ?>
>
>
>
> -
> What gets me if I can do all this from the mysql prompt:-
> laptop>mysql -u user -p (enterpassword gets me in)
> mysql>use test; OK
> mysql>select * from logbook; OK (shows entries no probs);
>
> -
> What am I doing wrong ?
>
> It doesnt get past the
>
> @ $db = mysql_pconnect("localhost", "user", "password");
>
> in the code.
>
> ??
>
> Andrew
>
>
>
>
> ---
> Andrew Rich
> Callsign: VK4TEC
> [EMAIL PROTECTED]
> www.users.bigpond.com/andrew.rich/vk4tec.htm
>
>
>
>
> ---
> Andrew Rich
> Callsign: VK4TEC
> [EMAIL PROTECTED]
> www.users.bigpond.com/andrew.rich/vk4tec.htm
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
/*-
RE: PHP and MySQL help please !
Fatal Error: Call to undefined function: mysql_connect() in
/var/www/html/results.php
+ I think my PHP does not have mysql included, although I put in the
./configure --with mysql=/usr/local/mysql \
+ When I type "which mysql" it says "/usr/bin/msql"
+ So should I put:-
./configure --with-mysql=/usr/local/mysql OR
./configure --with-mysql=/usr/bin/mysql
?
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 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", "password");
$db = mysql_pconnect("localhost", "user", "password");
Ideas ? Why is it now a undefined function ?
Andrew
-Original Message-
From: Andrew Rich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 25 April 2002 11:14 AM
To: [EMAIL PROTECTED]
Subject: PHP and MySQL help please !
+ PHP Installed and going - I can write to files, retrieve flatfiles
+ Apache running servers outpages nop probes
Trying to talk to SQL using PHP.
--
Go to SQL now
Number of books found: ".$num_results."";
?>
-
What gets me if I can do all this from the mysql prompt:-
laptop>mysql -u user -p (enterpassword gets me in)
mysql>use test; OK
mysql>select * from logbook; OK (shows entries no probs);
-
What am I doing wrong ?
It doesnt get past the
@ $db = mysql_pconnect("localhost", "user", "password");
in the code.
??
Andrew
---
Andrew Rich
Callsign: VK4TEC
[EMAIL PROTECTED]
www.users.bigpond.com/andrew.rich/vk4tec.htm
---
Andrew Rich
Callsign: VK4TEC
[EMAIL PROTECTED]
www.users.bigpond.com/andrew.rich/vk4tec.htm
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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", "password");
$db = mysql_pconnect("localhost", "user", "password");
Ideas ? Why is it now a undefined function ?
Andrew
-Original Message-
From: Andrew Rich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 25 April 2002 11:14 AM
To: [EMAIL PROTECTED]
Subject: PHP and MySQL help please !
+ PHP Installed and going - I can write to files, retrieve flatfiles
+ Apache running servers outpages nop probes
Trying to talk to SQL using PHP.
--
Go to SQL now
Number of books found: ".$num_results."";
?>
-
What gets me if I can do all this from the mysql prompt:-
laptop>mysql -u user -p (enterpassword gets me in)
mysql>use test; OK
mysql>select * from logbook; OK (shows entries no probs);
-
What am I doing wrong ?
It doesnt get past the
@ $db = mysql_pconnect("localhost", "user", "password");
in the code.
??
Andrew
---
Andrew Rich
Callsign: VK4TEC
[EMAIL PROTECTED]
www.users.bigpond.com/andrew.rich/vk4tec.htm
---
Andrew Rich
Callsign: VK4TEC
[EMAIL PROTECTED]
www.users.bigpond.com/andrew.rich/vk4tec.htm
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and MySQL help please !
+ PHP Installed and going - I can write to files, retrieve flatfiles
+ Apache running servers outpages nop probes
Trying to talk to SQL using PHP.
--
Go to SQL now
Number of books found: ".$num_results."";
?>
-
What gets me if I can do all this from the mysql prompt:-
laptop>mysql -u user -p (enterpassword gets me in)
mysql>use test; OK
mysql>select * from logbook; OK (shows entries no probs);
-
What am I doing wrong ?
It doesnt get past the
@ $db = mysql_pconnect("localhost", "user", "password");
in the code.
??
Andrew
---
Andrew Rich
Callsign: VK4TEC
[EMAIL PROTECTED]
www.users.bigpond.com/andrew.rich/vk4tec.htm
---
Andrew Rich
Callsign: VK4TEC
[EMAIL PROTECTED]
www.users.bigpond.com/andrew.rich/vk4tec.htm
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MACOSX and PHP and MYSQL
There is a great page with instructions and binaries for this stuff at http://www.entropy.ch/software/macosx/ Michael Bensin Joseph wrote: > I have MACOSX 10.1.3. > PHP runs fine with no problem could someone help me install or direct me > to where i can get instruction of how to install MYSQL on my machine > please. > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MACOSX and PHP and MYSQL
Assuming you have the developer tools installed, it compiles just fine: ./configure make make install if you don't have the dev tools, check VersionTracker. Someone probably has the binaries packaged up. On Tuesday, April 2, 2002, at 01:11 PM, Bensin Joseph wrote: > I have MACOSX 10.1.3. > PHP runs fine with no problem could someone help me install or direct > me to where i can get instruction of how to install MYSQL on my machine > please. > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MACOSX and PHP and MYSQL
I have MACOSX 10.1.3. PHP runs fine with no problem could someone help me install or direct me to where i can get instruction of how to install MYSQL on my machine please. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: drop down list using php and mysql
Yup Yup , you sure could.. Or you could also use
while ($array_name=mysql_fetch_Array($result)) {..}but for some reason
i always write at least a couple extra lines and use number of rows.. I
guess it is because thats how i learned it first :))
Gurhan
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 6:31 PM
To: Gurhan Ozen; mailing list; [EMAIL PROTECTED]
Subject: Re: drop down list using php and mysql
You could also bypass the num_rows entirely...
".$query);
echo '';
for ($i=0; $row = mysql_fetch_assoc($result); $i++) {
echo ''.($row["field"]).'';
}
echo '';
?>
# Nathan
- Original Message -
From: "Gurhan Ozen" <[EMAIL PROTECTED]>
To: "mailing list" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 15, 2002 4:17 PM
Subject: RE: drop down list using php and mysql
A correction... for line has the greater sign wrong:) It has to be :
for ($i=0; $numresult > $i; $i++)
Sorry about that:)
Gurhan
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 6:01 PM
To: mailing list; [EMAIL PROTECTED]
Subject: RE: drop down list using php and mysql
Hi,
This type of qustion should be forwarded to PHP-DB list. Its adres is:
[EMAIL PROTECTED] .
As for the answer to your question.. IF you'd like to create a dynamic
drop-down menu.. You can just just query the table for the options to be
displayed and loop through the result set and print them on html .. For
example:
$query="select field from table";
$result=mysql_query($query);
$numrows=mysql_num_rows($result);
echo '';
for ($i=0; $numresult < $i; $i++)
{
$row=mysql_fetch_array($result);
echo ''.($row["field"]).'';
}
Gurhan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: drop down list using php and mysql
You could also bypass the num_rows entirely...
".$query);
echo '';
for ($i=0; $row = mysql_fetch_assoc($result); $i++) {
echo ''.($row["field"]).'';
}
echo '';
?>
# Nathan
- Original Message -
From: "Gurhan Ozen" <[EMAIL PROTECTED]>
To: "mailing list" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 15, 2002 4:17 PM
Subject: RE: drop down list using php and mysql
A correction... for line has the greater sign wrong:) It has to be :
for ($i=0; $numresult > $i; $i++)
Sorry about that:)
Gurhan
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 6:01 PM
To: mailing list; [EMAIL PROTECTED]
Subject: RE: drop down list using php and mysql
Hi,
This type of qustion should be forwarded to PHP-DB list. Its adres is:
[EMAIL PROTECTED] .
As for the answer to your question.. IF you'd like to create a dynamic
drop-down menu.. You can just just query the table for the options to be
displayed and loop through the result set and print them on html .. For
example:
$query="select field from table";
$result=mysql_query($query);
$numrows=mysql_num_rows($result);
echo '';
for ($i=0; $numresult < $i; $i++)
{
$row=mysql_fetch_array($result);
echo ''.($row["field"]).'';
}
Gurhan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: drop down list using php and mysql
A correction... for line has the greater sign wrong:) It has to be :
for ($i=0; $numresult > $i; $i++)
Sorry about that:)
Gurhan
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 6:01 PM
To: mailing list; [EMAIL PROTECTED]
Subject: RE: drop down list using php and mysql
Hi,
This type of qustion should be forwarded to PHP-DB list. Its adres is:
[EMAIL PROTECTED] .
As for the answer to your question.. IF you'd like to create a dynamic
drop-down menu.. You can just just query the table for the options to be
displayed and loop through the result set and print them on html .. For
example:
$query="select field from table";
$result=mysql_query($query);
$numrows=mysql_num_rows($result);
echo '';
for ($i=0; $numresult < $i; $i++)
{
$row=mysql_fetch_array($result);
echo ''.($row["field"]).'';
}
Gurhan
-Original Message-
From: mailing list [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 4:52 PM
To: [EMAIL PROTECTED]
Subject: drop down list using php and mysql
Hello,
I am trying to build a drop down list using php and mysql. Does anyone
have any examples of this?
Regards,
Adrian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: drop down list using php and mysql
Hi,
This type of qustion should be forwarded to PHP-DB list. Its adres is:
[EMAIL PROTECTED] .
As for the answer to your question.. IF you'd like to create a dynamic
drop-down menu.. You can just just query the table for the options to be
displayed and loop through the result set and print them on html .. For
example:
$query="select field from table";
$result=mysql_query($query);
$numrows=mysql_num_rows($result);
echo '';
for ($i=0; $numresult < $i; $i++)
{
$row=mysql_fetch_array($result);
echo ''.($row["field"]).'';
}
Gurhan
-Original Message-
From: mailing list [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 4:52 PM
To: [EMAIL PROTECTED]
Subject: drop down list using php and mysql
Hello,
I am trying to build a drop down list using php and mysql. Does anyone
have any examples of this?
Regards,
Adrian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
drop down list using php and mysql
Hello, I am trying to build a drop down list using php and mysql. Does anyone have any examples of this? Regards, Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and MySQL for a Collaboration project
Hello All, I have been lurking here for the past couple of weeks and learning a bunch, thank you for all of your posts, just listening to you guys is great. We are developing a web based file management interface for collaboration and security. - Login script - Add three levels of security - Admin - Allows editing of files with file locking - User Specific can view some of the files, not all... - Guest - can only view a few files. - Add / Remove users and permissions to view / edit... - Add / Remove files with file description / size and type We are using PHP and MySQL for this, however, I am concerned about the security of some of the more sensitive files. We would like to have them simply in an HTACCESS protected folder, however, we want to use PHP to add and remove the users through a web interface, we don't want people to just be able to type in the URL of the file and get it again, for two reasons, 1. General Privacy 2. Maybe someone has it checked out and editing it. I have read the post about containing images within a MySQL database. Should we store the files inside the DB, using the posted method of storing an image, and relying on MySQL inherent security, the HTACCESS method or does anyone have a better suggestion? Patrick Egan Egan Consulting 15 Elvina Gardens Toronto, Ontario M4P 1X7 T] 416 630 4982 F] 416 488 7187 C] 416 726 4832 Pager] 416 377 9031 E] [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> W] www.eganconsulting.com <http://www.eganconsulting.com> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can I establish a ADO Connection to work with PHP and MySQL on Linux
From: "sreedhar" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Subject: Can I establish a ADO Connection to work with PHP and MySQL on Linux > Hi all, > > My Database on Linix. Can I establish a ADO Connection to work with PHP and > MySQL on Linux. Uhm yes You could do that, but why? Why use an ADO Connection in PHP, when PHP has a native interface to MySQL? Check out http://www.php.net/manual/en/ref.mysql.php - Carsten - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can I establish a ADO Connection to work with PHP and MySQL on Linux
Hi all, My Database on Linix. Can I establish a ADO Connection to work with PHP and MySQL on Linux. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP-DB] any good web hosting with php and mysql support?
Check out : http://www.weberdev.com/index.php3?GoTo=phenominet/prices.htm This is your one stop shop for hosting. WeberDev.com is hosted there and I can tell you that their service is amazing. They are fast, reliable and more than anything, very professional (specially in PHP / MySQL). Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 8:18 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP-DB] any good web hosting with php and mysql support? Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a company for which someone can vouch. I did started hosting my web site at a webhoster that promised 99.99% uptime and my site is hardly ever up and running. They don't answer my emails either. IS there anyone who have web sites hosted at webhosting service for a reasonably long time without any problems? IF yes, can you please contact me and tell me about it? This might be kind of off-topic for both lists, and i apologize to both lists, so you might want to reply to my email rather than sending it to list(s). Thank you very much. Gurhan -- PHP Database 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: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: any good web hosting with php and mysql support?
We do this as well. http://www.nk.ca . My question: Is anyone tracking MYSQL-php supported Hosting sites? On Mon, Jan 14, 2002 at 12:57:58PM -0600, Mike(mickalo)Blezien wrote: > > Check out Just Lightning: http://www.justlightening.net > > >On Mon, 14 Jan 2002 13:55:00 -0500, NDPTAL85 <[EMAIL PROTECTED]> wrote: > > >>On Monday, January 14, 2002, at 01:17 PM, Gurhan Ozen wrote: > >> > >>> Hi All, > >>> I am currently looking for a reliable web host to host my personal > >>> website. > >>> I know there are millions of web hosting companies that have PHP and > >>> MYSQL > >>> support but I just can't trust any of the fully-assured and confident > >>> webhosting ads anymore. I would like to get a service from a company for > >>> which someone can vouch. > >>> I did started hosting my web site at a webhoster that promised 99.99% > >>> uptime and my site is hardly ever up and running. They don't answer my > >>> emails either. > >>> IS there anyone who have web sites hosted at webhosting service for a > >>> reasonably long time without any problems? IF yes, can you please > >>> contact me > >>> and tell me about it? This might be kind of off-topic for both lists, > >>> and i > >>> apologize to both lists, so you might want to reply to my email rather > >>> than > >>> sending it to list(s). > >>> Thank you very much. > >>> > >>> Gurhan > > Mike(mickalo)Blezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work! > http://www.thunder-rain.com > Tel: 1(225)686-2002 > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: any good web hosting with php and mysql support?
Check out Just Lightning: http://www.justlightening.net >On Mon, 14 Jan 2002 13:55:00 -0500, NDPTAL85 <[EMAIL PROTECTED]> wrote: >>On Monday, January 14, 2002, at 01:17 PM, Gurhan Ozen wrote: >> >>> Hi All, >>> I am currently looking for a reliable web host to host my personal >>> website. >>> I know there are millions of web hosting companies that have PHP and >>> MYSQL >>> support but I just can't trust any of the fully-assured and confident >>> webhosting ads anymore. I would like to get a service from a company for >>> which someone can vouch. >>> I did started hosting my web site at a webhoster that promised 99.99% >>> uptime and my site is hardly ever up and running. They don't answer my >>> emails either. >>> IS there anyone who have web sites hosted at webhosting service for a >>> reasonably long time without any problems? IF yes, can you please >>> contact me >>> and tell me about it? This might be kind of off-topic for both lists, >>> and i >>> apologize to both lists, so you might want to reply to my email rather >>> than >>> sending it to list(s). >>> Thank you very much. >>> >>> Gurhan Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-DB] any good web hosting with php and mysql support?
Go to www.webhostingtalk.com this is forum about hosting services. _ Valery Vlasyuk http://www.cgi-network.net - Original Message - From: "Shannon Kendrick" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 8:43 PM Subject: RE: [PHP-DB] any good web hosting with php and mysql support? > Ive got numerous accounts with www.palmversa.com and I > have to say they are very reliable and extremely > cheap. > > Hope this helps > > Shannon > > > > > > > -- > > > PHP Database 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: > > [EMAIL PROTECTED] > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list > > archive) > > > > To request this thread, e-mail > > <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > > __ > Do You Yahoo!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP-DB] any good web hosting with php and mysql support?
In my previous email, I mentioned that http://www.nomonthlyfees.com provided 500 megs of disk space per account. I host several a domains by redirecting domains (5) to sub-directories within that 500. I don't have a 500-meg account for each domain. After the first year, the 500-megs cost $70/year. rick Richard Emery IT Sr. Project Manager (972) 478-3398 >-- Original Message -- >From: Gurhan Ozen <[EMAIL PROTECTED]> >Date: Mon, 14 Jan 2002 13:17:59 -0500 > > Hi All, > I am currently looking for a reliable web host to host my personal website. >I know there are millions of web hosting companies that have PHP and MYSQL >support but I just can't trust any of the fully-assured and confident >webhosting ads anymore. I would like to get a service from a company for >which someone can vouch. > I did started hosting my web site at a webhoster that promised 99.99% >uptime and my site is hardly ever up and running. They don't answer my >emails either. > IS there anyone who have web sites hosted at webhosting service for a >reasonably long time without any problems? IF yes, can you please contact me >and tell me about it? This might be kind of off-topic for both lists, and i >apologize to both lists, so you might want to reply to my email rather than >sending it to list(s). > Thank you very much. > >Gurhan > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-DB] any good web hosting with php and mysql support? (OT)
Hi, i'm looking for people that can write mysql articles for free. in exchange every article that they write will have information and link url to their site. All articles will be placed on http://www.cgi-network.net __ Valery Vlasyuk http://www.cgi-network.net - Original Message - From: "Mikel King" <[EMAIL PROTECTED]> To: "Gurhan Ozen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <> Sent: Monday, January 14, 2002 8:43 PM Subject: Re: [PHP-DB] any good web hosting with php and mysql support? (OT) > Starting @ $20.00/month http://www.ocsny.com > > > > > > >-- Original Message -- > >From: Gurhan Ozen <[EMAIL PROTECTED]> > >Date: Mon, 14 Jan 2002 13:17:59 -0500 > > > > Hi All, > > I am currently looking for a reliable web host to host my personal website. > >I know there are millions of web hosting companies that have PHP and MYSQL > >support but I just can't trust any of the fully-assured and confident > >webhosting ads anymore. I would like to get a service from a company for > >which someone can vouch. > > I did started hosting my web site at a webhoster that promised 99.99% > >uptime and my site is hardly ever up and running. They don't answer my > >emails either. > > IS there anyone who have web sites hosted at webhosting service for a > >reasonably long time without any problems? IF yes, can you please contact me > >and tell me about it? This might be kind of off-topic for both lists, and i > >apologize to both lists, so you might want to reply to my email rather than > >sending it to list(s). > > Thank you very much. > > > >Gurhan > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: any good web hosting with php and mysql support?
On Monday, January 14, 2002, at 01:17 PM, Gurhan Ozen wrote: > Hi All, > I am currently looking for a reliable web host to host my personal > website. > I know there are millions of web hosting companies that have PHP and > MYSQL > support but I just can't trust any of the fully-assured and confident > webhosting ads anymore. I would like to get a service from a company for > which someone can vouch. > I did started hosting my web site at a webhoster that promised 99.99% > uptime and my site is hardly ever up and running. They don't answer my > emails either. > IS there anyone who have web sites hosted at webhosting service for a > reasonably long time without any problems? IF yes, can you please > contact me > and tell me about it? This might be kind of off-topic for both lists, > and i > apologize to both lists, so you might want to reply to my email rather > than > sending it to list(s). > Thank you very much. > > Gurhan Try www.astrodawg.com or www.pair.com -- Mister Worf, show these children the airlock. - Picard -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-DB] any good web hosting with php and mysql support? (OT)
Starting @ $20.00/month http://www.ocsny.com > >-- Original Message -- >From: Gurhan Ozen <[EMAIL PROTECTED]> >Date: Mon, 14 Jan 2002 13:17:59 -0500 > > Hi All, > I am currently looking for a reliable web host to host my personal website. >I know there are millions of web hosting companies that have PHP and MYSQL >support but I just can't trust any of the fully-assured and confident >webhosting ads anymore. I would like to get a service from a company for >which someone can vouch. > I did started hosting my web site at a webhoster that promised 99.99% >uptime and my site is hardly ever up and running. They don't answer my >emails either. > IS there anyone who have web sites hosted at webhosting service for a >reasonably long time without any problems? IF yes, can you please contact me >and tell me about it? This might be kind of off-topic for both lists, and i >apologize to both lists, so you might want to reply to my email rather than >sending it to list(s). > Thank you very much. > >Gurhan > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP-DB] any good web hosting with php and mysql support?
Ive got numerous accounts with www.palmversa.com and I have to say they are very reliable and extremely cheap. Hope this helps Shannon > > > > -- > > PHP Database 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: > [EMAIL PROTECTED] > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP-DB] any good web hosting with php and mysql support?
I use FGDesigner.com. They have proven to be quite reliable and have a wide range of plans available based on what you would need. You can check out the website. My husband and I have been hosting our site through them for a couple of years and never had any problems. I also know that they have PHP support because I was asking about it recently. I am pretty sure that they have MySQL support too - I can't be positive because I don't use MySQL. Good luck finding someone! -Natalie > -Original Message- > From: Gurhan Ozen [SMTP:[EMAIL PROTECTED]] > Sent: Monday, January 14, 2002 1:18 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [PHP-DB] any good web hosting with php and mysql support? > > Hi All, > I am currently looking for a reliable web host to host my personal > website. > I know there are millions of web hosting companies that have PHP and MYSQL > support but I just can't trust any of the fully-assured and confident > webhosting ads anymore. I would like to get a service from a company for > which someone can vouch. > I did started hosting my web site at a webhoster that promised 99.99% > uptime and my site is hardly ever up and running. They don't answer my > emails either. > IS there anyone who have web sites hosted at webhosting service for a > reasonably long time without any problems? IF yes, can you please contact > me > and tell me about it? This might be kind of off-topic for both lists, and > i > apologize to both lists, so you might want to reply to my email rather > than > sending it to list(s). > Thank you very much. > > Gurhan > > > -- > PHP Database 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: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP-DB] any good web hosting with php and mysql support?
I use http://www.nomonthly fees.com Initial buy-in is $200. However, that includes domain name registration, 500 megs of disks pace, 5 giga-bytes of band-width per month. Complete PHP and MYSQL support. Bunch of other stuff too, like 1000 POP3 email boxes, PGP, shopping carts, etc. After first year, it's $70 per year ( $6/month) -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 12:18 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP-DB] any good web hosting with php and mysql support? Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a company for which someone can vouch. I did started hosting my web site at a webhoster that promised 99.99% uptime and my site is hardly ever up and running. They don't answer my emails either. IS there anyone who have web sites hosted at webhosting service for a reasonably long time without any problems? IF yes, can you please contact me and tell me about it? This might be kind of off-topic for both lists, and i apologize to both lists, so you might want to reply to my email rather than sending it to list(s). Thank you very much. Gurhan -- PHP Database 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: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-DB] any good web hosting with php and mysql support?
Try www.aletiahosting.com $9.95 a month -- Original Message -- From: Gurhan Ozen <[EMAIL PROTECTED]> Date: Mon, 14 Jan 2002 13:17:59 -0500 Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a company for which someone can vouch. I did started hosting my web site at a webhoster that promised 99.99% uptime and my site is hardly ever up and running. They don't answer my emails either. IS there anyone who have web sites hosted at webhosting service for a reasonably long time without any problems? IF yes, can you please contact me and tell me about it? This might be kind of off-topic for both lists, and i apologize to both lists, so you might want to reply to my email rather than sending it to list(s). Thank you very much. Gurhan -- PHP Database 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: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
any good web hosting with php and mysql support?
Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a company for which someone can vouch. I did started hosting my web site at a webhoster that promised 99.99% uptime and my site is hardly ever up and running. They don't answer my emails either. IS there anyone who have web sites hosted at webhosting service for a reasonably long time without any problems? IF yes, can you please contact me and tell me about it? This might be kind of off-topic for both lists, and i apologize to both lists, so you might want to reply to my email rather than sending it to list(s). Thank you very much. Gurhan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: pass variable in JS to php and mysql-query
Hi Phuc,
I work around the problem and I fix the problem without the submit()
function.
It will dynamic update content in room by sending the sql_query to
server and get
info back.
thank for your response.
Nguyen Trong Phuc wrote:
>
> i think that u can't, b/c php is server side while JS is client site. u can
> doSubmit() when building is changed, then php script get infomation and
> response to browser.
>
> Trong Phuc
>
> - Original Message -
> From: "Phieu Huynh" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Sunday, November 11, 2001 4:31 PM
> Subject: pass variable in JS to php and mysql-query
>
> >
> > function changebuilding (which) {
> > sel_var = which.selectedIndex
> > <?
> >$sql_query = "select distinct room
> > from general.room_info
> > where building='$variable' group by level asc";
> >
> >$sql_result = mysql_query($sql_query) or die (" Can't execute the
> > query");
> >
> >$i=0;
> >while ($row = mysql_fetch_array($result_sec_level))
> > print ("ar[".$i++."] = \"".$row[0]."\";\n");
> > ?>
> > for (i=0; i < ar.length; i++) {
> > option = new Option(ar[i])
> > document.myform.room.options[i]=option
> >}
> > }
> >
> >
> >
> > Building :
> > 1
> > 2
> > 3
> >
> > Room :
> >
> >
> >
> >
> >
> > I can pass the variable in building to $variable by submit button
> > but I want to pass the sel_var variable to $variable and dynamic update
> > the content in room.
> >
> > --
> >
> > phil Huynh
> >
> >
--
Phieu (phil) Huynh
Computer System Officer
Monash University
Electrical & Computer Systems Engineering
Phone : +61 3 990 53469
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: pass variable in JS to php and mysql-query
I'm working in an application using JS with ASP and MSQL. We use Remote
Scripting for real-time updating and reading the Database without reloading
a page or move to another page. It works very well. More details on this
one can be found at http://msdn.microsoft.com/scripting/
I guess it isn't very hard to make such a thing (and even simpler then MS'
one) for PHP. I hope so, 'cause I like to use it with my own PHP projects
too.
Greetinx Michaël Hompus
i think that u can't, b/c php is server side while JS is client site. u can
doSubmit() when building is changed, then php script get infomation and
response to browser.
Trong Phuc
>
> function changebuilding (which) {
> sel_var = which.selectedIndex
> $sql_query = "select distinct room
> from general.room_info
> where building='$variable' group by level asc";
>
>$sql_result = mysql_query($sql_query) or die (" Can't execute the
> query");
>
>$i=0;
>while ($row = mysql_fetch_array($result_sec_level))
> print ("ar[".$i++."] = \"".$row[0]."\";\n");
> ?>
> for (i=0; i < ar.length; i++) {
> option = new Option(ar[i])
> document.myform.room.options[i]=option
>}
> }
>
>
>
> Building :
> 1
> 2
> 3
>
> Room :
>
>
>
>
>
> I can pass the variable in building to $variable by submit button
> but I want to pass the sel_var variable to $variable and dynamic update
> the content in room.
>
> --
>
> phil Huynh
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: pass variable in JS to php and mysql-query
i think that u can't, b/c php is server side while JS is client site. u can
doSubmit() when building is changed, then php script get infomation and
response to browser.
Trong Phuc
- Original Message -
From: "Phieu Huynh" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, November 11, 2001 4:31 PM
Subject: pass variable in JS to php and mysql-query
>
> function changebuilding (which) {
> sel_var = which.selectedIndex
> <?
>$sql_query = "select distinct room
> from general.room_info
> where building='$variable' group by level asc";
>
>$sql_result = mysql_query($sql_query) or die (" Can't execute the
> query");
>
>$i=0;
>while ($row = mysql_fetch_array($result_sec_level))
> print ("ar[".$i++."] = \"".$row[0]."\";\n");
> ?>
> for (i=0; i < ar.length; i++) {
> option = new Option(ar[i])
> document.myform.room.options[i]=option
>}
> }
>
>
>
> Building :
> 1
> 2
> 3
>
> Room :
>
>
>
>
>
> I can pass the variable in building to $variable by submit button
> but I want to pass the sel_var variable to $variable and dynamic update
> the content in room.
>
> --
>
> phil Huynh
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL 4.0.0
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 >> without any problems. Sebastian> Yes, it works fine if I use the libmysql that is bundled with PHP. Only Sebastian> when I ./configure --with-mysql=/usr/local/mysql and link PHP against Sebastian> the MySQL 4.0.0 library this problem occurs. The problem could be that some structs has changed between MySQL 3.23 and 4.0; To get 4.0 to works, you need to recompile all object files that uses the libmysql library to use the 4.0 include headers. Could you try to recompile the mysql-php module with the 4.0 header files and check if this helps ? Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL 4.0.0
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 when I ./configure --with-mysql=/usr/local/mysql and link PHP against the MySQL 4.0.0 library this problem occurs. -- Sebastian Bergmann http://sebastian-bergmann.de/ http://phpOpenTracker.de/ Did I help you? Consider a gift: http://wishlist.sebastian-bergmann.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and MySQL 4.0.0
Hi! > "Sebastian" == Sebastian Bergmann <[EMAIL PROTECTED]> writes: Sebastian> Just compiled PHP (current CVS) with support for MySQL 4.0.0, but now Sebastian> Apache won't start: Sebastian> Cannot load /usr/local/apache2/modules/libphp4.so into server: Sebastian> undefined symbol: mysql_module_entry Sebastian> PHP is ./configure'd --with-apxs2=/usr/local/apache2 Sebastian>--with-mysql=/usr/local/mysql Sebastian>--without-pear Sebastian>--enable-inline-optimization Sebastian> Is this a known problem? No this is not a known problem. Can you find out what could be the problem ? The symbol 'mysql_module_entry' doesn't come from the MySQL library, so this is a PHP problem. Note that you can use MySQL 4.0 with the old MySQL 3.23 library without any problems. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
