I'm really not sure what to try next. ps -aux shows MySQL as hogging
the CPU, not PHP or Terminal:
When this happens, do a 'SHOW PROCESSLIST' in mysql to see what it's
doing.
I have, and I can't see anything unusual. There are a few scripts
that loop with very slow overhead (with
reason I would stop the
script is for some other purpose, like a software update.
However, the number of socket clients connecting in the past 3-4
months has steadily increased, and this seems to have exposed (if not
created) a strange performance issue with PHP 5.2.4, MySQL 5.0.45
and/or Mac
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
:?php
print hi;
mysql_connect('localhost', '', '') or die(mysql_error());
echo Connected to MySQLbr /;
print connected;
?
if their is any configuration please tell me
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
:?php
print hi;
mysql_connect
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
:?php
print hi;
mysql_connect('localhost', '', '') or die(mysql_error());
echo Connected to MySQLbr /;
print connected;
?
if their is any configuration
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
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
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
(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
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dear MySQL users,
MySQL AB announces an updated release of the MySQL Connector/PHP for
MySQL and PHP, the Windows downloads for connecting MySQL to PHP, as
MySQL AB has released MySQL 4.1.18 [1].
The MySQL Connector/PHP consists of the mysql/mysqli
.
##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
:[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
-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
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
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
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
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
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
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
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
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
hi...
trying to build php4 with mysql4.1-12, for use in apache2. i have the
following ./compile that works for php5. however, when i try to use it for
php4, i get a msg, stating that it can't find the MySQL Headers...
can anybody provide any pointers as far as what the Headers are for mysql,
and
hi,
have you installed php4-mysql ?
look at http://www.coagul.org/article.php3?id_article=169 for example.
Mathias
Selon bruce [EMAIL PROTECTED]:
hi...
trying to build php4 with mysql4.1-12, for use in apache2. i have the
following ./compile that works for php5. however, when i try to use
--with-mysql is supposed to be the directory in which configure can find
the mysql header (.h) files and the mysql library (mysql.so) underneath
that directory.
/usr/bin/mysql_config is a program -- a binary if you will
It's incredibly unlikely that your MySQL header files and the mysql.so
Dear MySql List experts,
I have the following installed on redhat 9:
[EMAIL PROTECTED] html]#php -v
PHP 4.3.10 (cgi) (built: Mar 8 2005 17:52:13)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
-
[EMAIL PROTECTED] html]#
There is likely an rpm package for the php mysql module. Install that, or
compile php with mysql support.
P
--Original Message--
From: Kamal Ahmed
To: mysql
Cc: Kamal Ahmed
Sent: Mar 9, 2005 3:58 PM
Subject: PHP/MyphpAdmin/MySql
Dear MySql List experts,
I have the following installed
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
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
Hello,
I recently upgraded the MySQL server from 4.0.15 to 4.1.7, without
significant problems. But I continued to use PHP-4.3.9 linked against
the old MySQL 4.0.15 on the webservers for some time. Everything went
ok, up until the point when I tried linking PHP-4.3.9 against
MySQL
On Wed, Dec 08, 2004 at 11:25:55AM +0100, Bogdan TARU wrote:
Everything went
ok, up until the point when I tried linking PHP-4.3.9 against
MySQL-4.1.7. After starting the new Apache/PHP (ldd httpd shows
'/usr/local/mysql-4.1.7/lib/mysql/libmysqlclient.so.14'), I get a
whole lot
server from 4.0.15 to 4.1.7, without
significant problems. But I continued to use PHP-4.3.9 linked against
the old MySQL 4.0.15 on the webservers for some time. Everything went
ok, up until the point when I tried linking PHP-4.3.9 against
MySQL-4.1.7. After starting the new Apache/PHP (ldd
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
. 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]
snip
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 ?
/ snip
Try removing the '@' from the mysql_pconnect statement to get a more
Hello,
I would like to migrate my MySQL servers from 4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would
be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
I appreciate your thoughts.
Thanks.
--
MySQL General Mailing List
For list
[snip]
I would like to migrate my MySQL servers from 4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would
be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
[/snip]
PHP 4 is compatible with MySQL 4.1. My caution to you would be using
Jay Blanchard wrote:
[snip]
I would like to migrate my MySQL servers from 4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would
be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
[/snip]
PHP 4 is compatible with MySQL 4.1. My caution
Jay Blanchard wrote:
[snip]
I would like to migrate my MySQL servers from 4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would
be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
[/snip]
PHP 4 is compatible with MySQL 4.1. My caution
Jay Blanchard wrote:
[snip]
I would like to migrate my MySQL servers from 4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would
be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
[/snip]
fwiw, i build-from-source use a collection
[snip]
of course, YMMV ...
[snip]
Sorry, YMMV? What does that mean?
Is there a reference somewhere for all these acronyms?
Thanks
Graham
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Graham Cossey wrote:
Sorry, YMMV? What does that mean?
Is there a reference somewhere for all these acronyms?
Yes it's called Google.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry, YMMV? What does that mean?
YMMV = Your Mileage May Vary
Is there a reference somewhere for all these acronyms?
lots.
google (internet acronyms)
richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
Sorry, YMMV? What does that mean?
Is there a reference somewhere for all these acronyms?
Yes it's called Google.
Yep, as soon as I posted I knew I should not have :)
It's late and I'm getting lazy...
--
MySQL General Mailing List
For list archives:
Hola, MySQL wizards.
I'm using LAMP on Fedora Core 2.
Some kind soul produced a tutorial on the net and the first script,
birthdays_create_database.php, I am trying to use yields an error in
the browser of: Couldn't connect to MySQL Here is the script.
---
[snip]
$dbhost = 'localhost';
[/snip]
Try changing this to 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This is really just a PHP question, I think.
Are MySQL and Apache running on the same machine?
What version of MySQL are you running?
Typically, you need a PHP mysql_connect() call including the MySQL
host, username, and password. You only list the host above.
With a default installation of
I can connect in the php by using 'root' and the root pw. But when I
tried adding a user ( sarah ) with GRANT I cannot connect from php. The
php is simple, what am I overlooking? Again putting the root user name
and pw it'll work in php but not for sarah:
the php
i usually do
$link = mysql_connect($server, $userid, $password);
and it works, except when the pw is incorrect
suomi
leegold wrote:
I can connect in the php by using 'root' and the root pw. But when I
tried adding a user ( sarah ) with GRANT I cannot connect from php. The
php is simple, what
What error are you getting? My problem when moving to 4.1 was
forgetting that I was using an older MySQL client.
I'm not positive, but I think that in order to connect to MySQL 4.1
with PHP you need to use the mysqli functions, not mysql, and mysqli
requires PHP 5.
If you want to keep
On Fri, 13 Aug 2004 11:24:46 -0400, Wesley Furgiuele
[EMAIL PROTECTED] said:
What error are you getting? My problem when moving to 4.1 was
forgetting that I was using an older MySQL client.
I'm not positive, but I think that in order to connect to MySQL 4.1
with PHP you need to use
I think that's the problem.
Could be a lot of editing PHP scripts for a lot of people(!?)
Thanks
Try to compile PHP against the client library for MySQL 4.1. I'll
wonder if it won't work. ext/mysqli is required if you like to
use things like prepared statements...
Regards,
A.
--
MySQL
Hi
I'm brand new to this list, so please forgive me if I'm wasting everybodies
time :-).
I've used a couple of days tracking this one down and just thought I would
share it if anyone is strugling with the same problem.
Running :
FreeBSD 4.9-RELEASE-p5
Apache 2.0.50
PHP 4.3.8
MySQL 4.0.20
Moved from a PHP list to a MySQL list. :-)
On 06/30/2004 09:55 PM John W. Holmes spoke:
Bob Lockie wrote:
If I select rows with a limit clause I need to know if there are more
rows than the limit.
Either do a SELECT COUNT(*) prior to your LIMIT query to see how many
total rows there are, or use
If I want 20 rows to display, I ask for 21.
If I get 21, I know to ask for another page.
Bob Lockie wrote:
Moved from a PHP list to a MySQL list. :-)
On 06/30/2004 09:55 PM John W. Holmes spoke:
Bob Lockie wrote:
If I select rows with a limit clause I need to know if there are
more rows than
Hi,
I don't know whether I can ask this question on this mailing
list or not, but I want to know how the php communicates with mysql,
when it is on the localhost. Does it use unix domain sockets or it
uses TCP sockets only? Any help or pointers in this regard will be of
great help for me
venkata ramana wrote:
Hi,
I don't know whether I can ask this question on this mailing
list or not, but I want to know how the php communicates with mysql,
when it is on the localhost. Does it use unix domain sockets or it
uses TCP sockets only? Any help or pointers in this regard
it installed on Windows at the moment - because it's more
convenient to debug (and restart)!
Cheers,
Matt
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql-list-
[EMAIL PROTECTED]
Sent: 15 April 2004 20:29
To: Matt Chatterley
Subject: Re: Slow Connection from PHP to MySQL 5.0
do
. The
two servers are on different subnets of a LAN, but are able to talk to each
other unrestricted (all TCP services I have tried work perfectly, e.g. SMTP,
FTP).
The problem is that connections from PHP to MySQL seem to take 4-5 seconds
(after which any queries within the connection go through
Hi,
Does any one help me in formating the output result in PHP with mysql?
The code is here.
form action=hostrep.php method=get
/form
?
$username=root;
$password=;
$database=databasename;
$host=localhost;
$today = date(F j, Y, g:i a);
mysql_connect($host,$username,$password);
@mysql_select_db
in
a table data TD.
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.
form action=hostrep.php method=get
/form
?
$username=root;
$password=;
$database
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:
form action=insert.php method=post
Software id: input
[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
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
: 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:
$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
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
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
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
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
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]
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
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
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
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
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
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
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
]
To: Rory McKinley [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 6:22 PM
Subject: Re[2]: [PHP-DB] MySQL Regular expression
Actually in response to my previous comment, would the following
achieve wwhat I want?
... and strcmp('$foot_budget', substring_index(substring_index(rates
Apologies for any confusion - wrong list. Should have gone to PHP-DB
instead.TGIF.
- Original Message -
From: Rory McKinley [EMAIL PROTECTED]
To: O Franssen [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, October 10, 2003 9:14 AM
Subject: Re: Re[2]: [PHP-DB] MySQL Regular
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
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
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
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
Hi all,
In learning PHP and expanding my (seriously limited) SQL knowledge, I
need to write a query that will look for one or more (can be any number)
of the following fields held in the table:
+---+-+
| Field | Type|
+---+-+
| id| int(6) |
|
: Saturday, August 30, 2003 1:28 PM
To: [EMAIL PROTECTED]
Subject: PHP Search + MySQL Query
Hi all,
In learning PHP and expanding my (seriously limited) SQL knowledge, I
need to write a query that will look for one or more (can be any number)
of the following fields held in the table
Brown, Chris wrote:
+---+-+
Field | Type|
+---+-+
id| int(6) |
svc | varchar(20) |
sev | tinyint(1) |
dsc | varchar(60) |
inits | varchar(20) |
dst | date|
tst | time|
den | date|
ten | time
We recently installed php and Mandrake 9. Php is no recognizing any of
the mysql statements. On a working php installation the two extensions
mysql.so and gd.so are in the /usr/lib/php/extensions directory. How does
php create this directory for mysql. By unchecking the two extensions in
My test.php page recognizes the potential for mysql but something went
wrong when I first tried to install mysql so I removed mysql and am
about to attempt a re-install.
I've a couple of books on hand, neither of which addresses MAC OSX
which is unix based.
OSX comes with apache and php
Open a terminal/console Window and type:
mysql
If You got an error message You have to follow these steps:
su
mysql_install_db
chown -R mysql.mysql /var/mysql
chmod 577 /var/mysql
then go in the Application/Utility folder and launch the MySqlMonitor
Click on Launch at startup.
I followed these
Here's a couple of links that should help.
PHPMac
http://www.phpmac.com/
has an article about turning on PHP in Apache.
MySQL on Mac OS X
http://developer.apple.com/internet/macosx/osdb.html
PHP on Mac OS X
http://developer.apple.com/internet/macosx/php.html
Even though OS X comes with Apache
I had asked the group previously about limiting the results shown on my
website to a certain number and then navigating to the next group etc...
I found a great article by Joe O'Donnell called Building A Dynamic MySql
Paging Class with PHP ... I created his example and it worked fine.
Then I
]
Sent: Thursday, March 13, 2003 5:20 AM
To: [EMAIL PROTECTED]
Subject: Recordset paging with php on mySql database ... works on first
page but ...
I had asked the group previously about limiting the results shown on my
website to a certain number and then navigating to the next group etc...
I
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
Angel Flow wrote:
Would like to ask people's thoughts on whether Perl or
PHP has higher performance with MySQL. I've heard
rumours that DBI is slower than the PHP MySQL driver.
I would say that comparing DBI to ADODB is more appropriate; PHP more or
less directly calls the mysql C library
, 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
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
: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
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
')
- 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
1 - 100 of 246 matches
Mail list logo