Gossamer Forum
Home : General : Internet Technologies :

php & mysql

Quote Reply
php & mysql
I meet a question when I practice PHP and MySQL:
I have $db=mysql_connect(); or $db=mysql_pconnect(); in my *php code.
I got error message:
"Call to undefined function: mysql_connect()"
"Call to undefined function: mysql_pconnect()"

Will you tell me that what is the possible solution?

I have installed Mandrake Linux in my PC. There are PHP, MySQL , Apache
come with Mandrake installation.

Last edited by:

jinwu: Jun 8, 2003, 6:03 AM
Quote Reply
Re: [jinwu] php & mysql In reply to
Sounds like MySQL is not correctly setup for your server. See this URL;

http://www.nother.net/....html#section-1.1.1.

It states;

Quote:
1.1 After logging in I get the following error: "Fatal error: Call to undefined function: mysql_pconnect()". What's wrong?
You may need to install the php-mysql module (rpms and debs are available).

It always helps to do a Google search :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [jinwu] php & mysql In reply to
One thing that may help is looking up your PHP environment via:

Code:
<? phpinfo() ?>

Stick that into a file called something like test.php.

Then execute the file in your web browser...Look for the mysql section.
========================================
Buh Bye!

Cheers,
Me

Last edited by:

Stealth: Jun 8, 2003, 6:55 PM
Quote Reply
Re: [jinwu] php & mysql In reply to
There is no MYSQL section in phpinfo()
I have installed Mandrake Linux in my PC. There are PHP, MySQL , Apache
come with Mandrake installation. i.e. I installed mysql
I could not found php.ini. I copied php.ini.Recommand to /etc/php.ini. PHP still not support mysql
MySQL is located in the /etc/init.d

How do I make my php support mysql?

Last edited by:

jinwu: Jun 9, 2003, 9:59 AM
Quote Reply
Re: [jinwu] php & mysql In reply to
Welp, looks like you have not configured MySQL correctly.

Are you sure that there is no mysql section in your phpinfo??? Did you use "Find in Page" for mysql? The mysql section is between the FTP and odbc sections within the phpinfo output.

What version of PHP are you using?

There should be a libMySQL.dll file in the following folder:

C:\PHP\dlls

Also, look in the following folder:

C:\PHP\extensions

Look for the following dlls

php_msql.dll
php_mssql.dll

etc.

These are used to connect to your various ODBC or RDBMS servers.

Also, you might want to try installing the MySQL ODBC driver for Windows...Search the Web for (via Google):

MyODBC

For further assistance, you might want to go to the Mandrake website and see if there is any technical documents that may help you.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [jinwu] php & mysql In reply to
If you really need, try http://www.nusphere.com (free version). I have it running great on my PC, and setup is a piece of cake Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] php & mysql In reply to
Dear Andy:
Do you mean Nusphere PHPEd
I only see trial version for Nusphere product.
Will you tell me how to get the free version.
Quote Reply
Re: [jinwu] php & mysql In reply to
Looks like they have stopped it :(

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] php & mysql In reply to
http://www.mysql.com/news/article-75.html

- wil