mysql php help

[EmmaFlower]

Tweet

Hi,

when I try to connect to mysql I get this error on the page

Fatal error: Call to undefined function mysql_connect() in \\web-wfwin\soho\footballonthetv.co.uk\http://www.affiliates4u.com/forums/w...\cdsbought.php on line 17

here is the test page itself, http://www.footballonthetv.co.uk/cdsbought.php

I had a look at the php.ini to check the extension=php_mysql.dll was un coloned and it seems ok, any ideas?

Emma

[accelerator]

You have referenced a function in your code on that line, which means the actual function must be stated somewhere in the PHP file. Functions normally go at the top of the page, or are often in a separate inc-functions.php file, which gets included in your script. A function looks like this:

function YourFunctionNameHere() {
...
}

Ask at phpfreaks.com if you need more help or see:

PHP Tutorials

Rgds

[jramroop]

Hi,

when I try to connect to mysql I get this error on the page

Fatal error: Call to undefined function mysql_connect() in \\web-wfwin\soho\footballonthetv.co.uk\http://www.affiliates4u.com/forums/w...\cdsbought.php on line 17

here is the test page itself, List of CDS

I had a look at the php.ini to check the extension=php_mysql.dll was un coloned and it seems ok, any ideas?

Emma

Hi Emma,

this error normally means that PHP has not been compiled with mysql support. (mysql.so extension) this does not come with PHP or MySQL distributions on certain platforms. You can check this by uploading this script to your server:

<?php
phpinfo();
exit();
?>

Post the link here and I'll have a look for you.

Cheers
James

[EmmaFlower]

thanks accelarator I will take a look at that.

James www.footballonthetv.co.uk/testphp.php

it's coming up

No input file specified.

???!!???

[jramroop]

t
James www.footballonthetv.co.uk/testphp.php

it's coming up

No input file specified.

???!!???

I am assuming your website is on a Windows Server.
This could be a path related issue.. what the

"doc_root" path in your php.ini?

You might need to contact your hosting provider and get them to fix it. It's a web server or php configuration issue.

[jramroop]

This might also help:

No input file specified | IIS Aid

[EmmaFlower]

I am assuming your website is on a Windows Server.
This could be a path related issue.. what the

"doc_root" path in your php.ini?

You might need to contact your hosting provider and get them to fix it. It's a web server or php configuration issue.

This is what I can see

The root of the PHP pages, used only if nonempty.

and yes it is on a windows server
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues. The alternate is to use the
; cgi.force_redirect configuration below
doc_root =

; The directory under which PHP opens the script using /~username used only
; if nonempty.
user_dir =

; Directory in which the loadable extensions (modules) reside.
extension_dir ="C:\Program Files\PHP\ext"

[jramroop]

Hi Emma,

Is this a local/development or production server?
If it's local, you can play around with the php.ini settings and see if that makes a difference..

Refer to this website and comments to find out the different settings you can try

No input file specified | IIS Aid

Hope this helps..