what is wrong with php?
Hi all, I find php slow when accessing mysql. When I do $sql='select count(*) from table'; $result = mysql_query($sql); It takes 10 sec to return. Is this normal speed for php or my Mandrake Linux configuration problem? The same query run in mysql return instantly. Thanks _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
MySql vs Access
Hi all, How is MySql compare to Access database? I understand that Access database is fit for a small environment where you have 5 to 10 users. Can MySql handle larger environment like Oracle, Microsoft SQL or it is just like Access? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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
Basic index questions
Hi, I am trying to learn about indexing and have a few questions. 1. Does index only apply to query that use = operator in the where clause? 2. Does operators such as , like and between will result to full table scan? 3. For example, In the following table: tbl_A id int primary key, flag1 char(1), amount float, signup_date date In a query has multiple condition in the where clause such as, select * from tbl_A where flag1 = 'y' and amount 10 and signup_date between '2002-02-01' and '2002-03-31'. If only the flag and signup_date field has index, will the index be use? 4. Where could I learn more about indexing? Thanks for helping. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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: php+apache+mysql installation. Help
Do I need to uninstall the old Apache before installing the newer version? How do I uninstall the old Apache in linux? Do I just use the package manager to remove the package? What does make do? I don't know how linux work. Please advise. Thanks. From: Andrew Lietzow [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: php+apache+mysql installation. Help! Date: Thu, 23 May 2002 21:34:37 -0500 Dear Andy, Here's a thought. Before you go much further, install Apache 2.0.36. It's easy to install and lots of improvements will be gained that you'll appreciate down the road, i.e. mod_ssl is preconfigured into the system. Andrew Lietzow The ACL Group, Inc. On Thursday 23 May 2002 06:33 pm, you wrote: Hi, I am new to linux and trying to install Apache, php and mysql on my Redhat 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: checking whether build environment is sane..configure error:newly created file is older than distributed files! I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box. Would appreciated if some one could advise how to install PHP. Thanks P.S. I have start Mysql manually. How do I make it auto start and shutdown? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 -- Andrew Lietzow The ACL Group, Inc. 515-274-0300 v/f 515-710-1955 c _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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+apache+mysql installation. Help!
Hi, I am new to linux and trying to install Apache, php and mysql on my Redhat 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: checking whether build environment is sane..configure error:newly created file is older than distributed files! I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box. Would appreciated if some one could advise how to install PHP. Thanks P.S. I have start Mysql manually. How do I make it auto start and shutdown? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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: mysql/php on linux
Hello all, Thanks for the help. I move my php test script to \var\www\html When I call the php script from my browser, It shows me: ?php phpinfo(); ? and not result of the phpinfo() function. When I run php phpinfo() at the shell command, it out puts the html result. What is problem, my Apache not understand the php script? Thanks From: Jim Philips [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED] Subject: RE: mysql/php on linux Date: 18 Mar 2002 21:59:09 -0500 You should not save php scripts in cgi-bin. They need to be in your document root directory or a sub-directory of the rooot directory. In my case, document root is: /usr/local/apache/htdocs If you need a test script, you can just run this: ? phpinfo(); ? If it is in the document root directory, just point your browser to: localhost/(script name) If everything is installed right, you will get a page with information about your php install. On Mon, 2002-03-18 at 20:35, Andy Cheng wrote: Hi all, I too new to php and mysql, trying to get things works. I installed Redhat 7.2, Apache, mysql and php. I copied a sample php script from the internet and save it as phptest.php in my cgi-bin. When calling it from my browser, I got Format error. Did I not do it right? Should I put it in my cgi-bin? Could some one send me a working php script and instruct me how to test it? Thanks From: Todd Williamsen [EMAIL PROTECTED] To: 'Andrew Hazen' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: mysql/php on linux Date: Mon, 18 Mar 2002 08:50:28 -0600 PHP http://www.php.net/manual/en/install.linux.php mySQL http://www.mysql.com/doc/L/i/Linux.html I never had any problems with mysql and PHP talking to each other on Linux, and I am very wet behind the ears with Linux. Maybe you can give us an error messages you are receiving, and that will give all of us a better understanding of what is going on. If it?s the OS or Glib libraries, you will get the same error over and over again. I don't use RedHat, so I don't know what they have in it, I use Caldera OpenLinux 3.1 which is much better(from what I hear). I have heard that RedHat 7.2 is a bit quirky. Again, its all hear say. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 8:31 AM To: [EMAIL PROTECTED] Subject: mysql/php on linux Hi all, This is probably a boring repeat question, so maybe someone can just point us to an existing response or file on the web: We are trying to set up a webserver with the following: Linux Red Hat 7.2 MySQL ? newest PHP 4.1 ? newest We can?t seem to get them all talking to each other, so we will just start over from scratch. Can someone provide a step-by-step?? Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - 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 _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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: mysql/php on linux
Hi all, I am using RH linux 7.2. I do have these lines: AddType application/x-httpd-php .php IfDefine HAVE_PHP LoadModule php_module modules/mod_php.so IfDefine HAVE_PHP AddModule mod_php.c IfDefine HAVE_PHP4 AddModule mod_php4.c in my httpd.conf. I think Windows version's of http.conf is different. How do I check if the module is load or installed? From: Dustin Rabe [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED] Subject: RE: mysql/php on linux Date: Sat, 23 Mar 2002 11:57:53 -0800 (PST) Try adding this to your http.conf file in apache. ScriptAlias /php/ c:/php/ AddType application/x-httpd-php .php Action application/x-httpd-php /php/php.exe My Best, Dustin Rabe --- Andy Cheng [EMAIL PROTECTED] wrote: Hello all, Thanks for the help. I move my php test script to \var\www\html When I call the php script from my browser, It shows me: ?php phpinfo(); ? and not result of the phpinfo() function. When I run php phpinfo() at the shell command, it out puts the html result. What is problem, my Apache not understand the php script? Thanks _ Send and receive Hotmail on your mobile device: http://mobile.msn.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: mysql/php on linux
Hi all, I too new to php and mysql, trying to get things works. I installed Redhat 7.2, Apache, mysql and php. I copied a sample php script from the internet and save it as phptest.php in my cgi-bin. When calling it from my browser, I got Format error. Did I not do it right? Should I put it in my cgi-bin? Could some one send me a working php script and instruct me how to test it? Thanks From: Todd Williamsen [EMAIL PROTECTED] To: 'Andrew Hazen' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: mysql/php on linux Date: Mon, 18 Mar 2002 08:50:28 -0600 PHP http://www.php.net/manual/en/install.linux.php mySQL http://www.mysql.com/doc/L/i/Linux.html I never had any problems with mysql and PHP talking to each other on Linux, and I am very wet behind the ears with Linux. Maybe you can give us an error messages you are receiving, and that will give all of us a better understanding of what is going on. If its the OS or Glib libraries, you will get the same error over and over again. I don't use RedHat, so I don't know what they have in it, I use Caldera OpenLinux 3.1 which is much better(from what I hear). I have heard that RedHat 7.2 is a bit quirky. Again, its all hear say. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 8:31 AM To: [EMAIL PROTECTED] Subject: mysql/php on linux Hi all, This is probably a boring repeat question, so maybe someone can just point us to an existing response or file on the web: We are trying to set up a webserver with the following: Linux Red Hat 7.2 MySQL newest PHP 4.1 newest We cant seem to get them all talking to each other, so we will just start over from scratch. Can someone provide a step-by-step?? Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - 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 _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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: Mysql installation. Help!
Great, the uppercase in $sth-{NUM_OF_FIELDS} works. Now I can start to learn perl. Any advice on where could I find a good source for beginner on the web? Thank you very much. From: ds [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Mysql installation. Help! Date: 11 Mar 2002 19:41:08 + I don't understand the code. I copy it from a book. I am trying to print out the records returned from a query. I have a table named client in database andy. The table has 2 records. When I run the above code, I have 2 blank lines return. Could any one tell me what the problem is? Where could I find better documentation on DBI::DBD::mysql stuff for beginner? man DBD::mysql is difficult to understand. Thanks again for the info. #!/usr/bin/perl use DBI; $dbh=DBI-connect('DBI:mysql:andy'); my $query=select * from client; my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n; $sth-execute; my $rows; while(@row=$sth-fetchrow_array) {my $i; for $i (0..($sth-{num_of_fields}-1)) {print [.$row[$i].];} print(\n); } $sth-finish; $dbh-disconnect Hi, I'm not an expert in perl too, but i would correct your code to this: #!/usr/bin/perl use DBI; $dbh=DBI-connect('DBI:mysql:andy'); my $query=select * from client; my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n; $sth-execute; my $rows; while(@row=$sth-fetchrow_array) {my $i; for $i (0..($sth-{NUM_OF_FIELDS}-1)) {print [.$row[$i].];} print(\n); } $sth-finish; $dbh-disconnect Note the uppercase in $sth-{NUM_OF_FIELDS}. Also remove the line my $rows... It's doing nothing there. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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
Mysql installation. Help!
Hi all, I got this error message when trying to connect to mysql at the shell command: Error 2002:Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock There is no mysql.sock in the /var/lib/mysql directory. Did I miss some thing in the mysql installation? Where could I find the mysql.sock? I install mysql that came with redhat 7.2. Thank for the help. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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: Mysql installation. Help!
Thanks for the help. I got it working. I could connect to mysql from shell command. Now I try to connect to mysql using perl. I installed the DBI::DBD module for perl. I think the DBI::DBD also working since I don't see error return running the following code: #!/usr/bin/perl use DBI; $dbh=DBI-connect('DBI:mysql:andy'); my $query=select * from client; my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n; $sth-execute; my $rows; while(@row=$sth-fetchrow_array) {my $i; for $i (0..($sth-{num_of_fields}-1)) {print [.$row[$i].];} print(\n); } $sth-finish; $dbh-disconnect I don't understand the code. I copy it from a book. I am trying to print out the records returned from a query. I have a table named client in database andy. The table has 2 records. When I run the above code, I have 2 blank lines return. Could any one tell me what the problem is? Where could I find better documentation on DBI::DBD::mysql stuff for beginner? man DBD::mysql is difficult to understand. Thanks again for the info. From: Chuck \PUP\ Payne [EMAIL PROTECTED] To: Doug Thompson [EMAIL PROTECTED], Andy Cheng [EMAIL PROTECTED], Intrex [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: Mysql installation. Help! Date: Sun, 10 Mar 2002 14:18:13 -0500 Ok, if never run it then you have to start once, if I remember right undex Red Hat, you have to go to /etc/rc.d/init.d and do this... ./mysql start that will start it Then you will need to set it up so it will start later. SuSE you have to start it once You will then need to set a password for mysql. I hope that helps. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Fortune for today -- Q: How many Zen masters does it take to screw in a light bulb? A: None. The Universe spins the bulb, and the Zen master stays out of the way. If mysql.sock doesn't exist, that is because the server is not running. I fought the same battle as Mark and ultimately downloaded and installed the RPM for 3.23.49a from MySQL in place of the copy that came with RH. The MySQL RPM installed and came up just like it says in the book. Saves a lot of hair and dain bramage. If the server process _is_ running, it may be useful to go through the section on binary installation and check those items to see if your RPM set everything up correctly. Don't bet on finding anything, but it doesn't take long to do these checks. http://www.mysql.com/doc/I/n/Installing_binary.html Regards, Doug Perfection is finally attained not when there is no longer anything to add, but when there is no longer anything to take away. -- Antoine de Saint Exup?ry On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote: What I did was beat my brains out on the same exact problem. In the end I have no clue what I did to get it actually working. I had re-installed the mysql from the .tar.gz, I installed all the RPM's several times. Everytime, I fully rebooted the system, and finally I have to run safe_mysqld --user=root I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz, rebooted the system, then re-ran safe_mysqld --user=root. Mark - Original Message - From: Andy Cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 10, 2002 10:01 AM Subject: Mysql installation. Help! Hi all, I got this error message when trying to connect to mysql at the shell command: Error 2002:Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock There is no mysql.sock in the /var/lib/mysql directory. Did I miss some thing in the mysql installation? Where could I find the mysql.sock? I install mysql that came with redhat 7.2. Thank for the help. - 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 _ Chat with friends online, try MSN Messenger: http://messenger.msn.com
Perl DBI installation. Help!
Hello all, I am new to linux. I was told that I need DBI::DBD to connect to Mysql using perl. So I go to http://www.mysql.com/downloads/api-dbi.html and downloaded DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz. Using gunzip, I unziped the two files. Now I have DBI-1.18.tar and Msql-Mysql-modules-1.2216.tar. What should I do next to install them and test them? Thanks for the help _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
DBI installation
Hello all, I am new to linux. I need to connect to Mysql using perl. I downloaded DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz from http://www.mysql.com/downloads/api-dbi.html. I don't see any installation instruction. Could some one show me how to install it? Thanks for the help. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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
How to access MySql using Perl. Help
Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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
How to access MySql using Perl. Help
Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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