[PHP-DB] PHP compile error: Cannot find mysql header files

2004-10-10 Thread andy
Hi all,

I'm attempting to configure PHP with apache and mysql support, but the
config fails, because it can't find the mysql header files.

I have mysql installed and working,
these are the rpms installed:
MySQL-client-4.0.21-0
MySQL-server-4.0.21-0
MySQL-shared-compat-4.0.21-0

When configuring PHP, I'm using this:
[EMAIL PROTECTED] mysql]#
./configure --with-apache=../apache_1.3.31 --with-mysql=/usr/bin/mysql

This is the Error:
configure: error: Cannot find MySQL header files under /usr/bin/mysql

When I search for mysql.h, I get this:
[EMAIL PROTECTED] local]$ locate mysql.h
/home/andy/snort/snort-2.2.0/src/win32/WIN32-Includes/mysql/mysql.h
/usr/local/src/php-4.3.9/ext/dbx/dbx_mysql.h
/usr/local/src/php-4.3.9/ext/mysql/php_mysql.h
/usr/local/src/php-4.3.9/ext/mysql/libmysql/mysql.h
/var/www/html/php_tarball/php-4.3.9/ext/dbx/dbx_mysql.h
/var/www/html/php_tarball/php-4.3.9/ext/mysql/php_mysql.h
/var/www/html/php_tarball/php-4.3.9/ext/mysql/libmysql/mysql.h

correct me if I'm wrong, but shouldn't the path be something like
/usr/bin/mysql or /usr/lib/mysql or /usr/sbin/mysql ?

I've tried all of these paths and they don't work.

anything to help is greatly appreciated.

Thanks,
HC

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] PHP compile error: Cannot find mysql header files

2004-10-10 Thread Jason Wong
On Monday 11 October 2004 09:49, andy wrote:

First, read manual  MySQL Functions

Second, decide whether you want to compile using the bundled MySQL library. If 
so the above tells all you need to know. If not you need to install the devel 
package for MySQL.

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
Be frank and explicit with your lawyer ... it is his business to confuse
the issue afterwards.
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Form action

2004-10-10 Thread Ng Hwee Hwee
Hi all,

i'm designing a lot of forms and would like to know the standard practice. which of 
the following will be advisable?

1) form action is $PHP_SELF
i.e. form name=form01 action=?=$PHP_SELF;? method=post
i.e the script to check if the values submitted is valid and the scripts to
 insert the data into the database are all in the same php file with the form.
2) form action is another verification php file
i.e. form name=form01 action=verify_form.php method=post
i.e the script to check if the values submitted is valid and the scripts to
 insert the data into the database are in a different php file with the form.

which of them is best?? i read before that the second option is preferred because if 
users click back on their browser, they will not resubmit the form again etc.. does 
anyone has a suggestion for me?

thank you so much!

regards,
hwee


Re: [PHP-DB] Form action

2004-10-10 Thread Shahmat Dahlan
When I first started out with PHP, I asked the same myself the same 
questions as you just did. But over the years I have concluded:

Method (1) centralizes all your form submission processes for addition, 
deletion, updating purposes, which means when you want to start 
debugging, you would end up having to debug A (one) particular file 
only. But makes your debugging process just a little bit tiresome, in 
the case where your form is a little bit complicated.

Method (2) decentralizes all your form submission processes, but in a 
way you'd simplify your coding practice as you segregate your forms from 
your submission processes, which simplifies debugging, and you would not 
need to go through all your line of codes, as in method (1)

There are pros and cons to these two methods, I would prefer to use 
method (1), and as soon as the form gets submitted, I'd end up utilizing 
either Javascript or the header function to redirect the page. So that 
when users won't be able to click on the back button.

Well, that's just my honest opinion, other may have other ideas.
Ng Hwee Hwee wrote:
Hi all,
i'm designing a lot of forms and would like to know the standard practice. which of 
the following will be advisable?
1) form action is $PHP_SELF
   i.e. form name=form01 action=?=$PHP_SELF;? method=post
   i.e the script to check if the values submitted is valid and the scripts to
insert the data into the database are all in the same php file with the form.
2) form action is another verification php file
   i.e. form name=form01 action=verify_form.php method=post
   i.e the script to check if the values submitted is valid and the scripts to
insert the data into the database are in a different php file with the form.
which of them is best?? i read before that the second option is preferred because if users click 
back on their browser, they will not resubmit the form again etc.. does anyone has a 
suggestion for me?
thank you so much!
regards,
hwee
 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP-DB] 3D charts

2004-10-10 Thread Vipin Chandran
hi,
Can we draw 3d graphs or pie charts using php and gd? or is there any
class or method available for this ?
-- 
Regards,
Vipin Chandran

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php