Why won't my php script connect to mysql?

Question

Hey guys, I'm trying to make a full-text search bar and already my script wont work... My php script is this...

<?php

MySQL_connect("hostname", "username", "password"); 
MySQL_select_db("our_db"); 
$query = " 
    SELECT * FROM articles 
    WHERE MATCH(title, body) AGAINST ('PHP') 
"; 
$sql = MySQL_query($query); 
/* output results */ 
?>

And when I try to preview it, it comes up with:

Fatal error: Call to undefined function MySQL_connect() Error in line 12 (line 12: MySQL_connect("hostname", "username", "password"); ) Server Error in '/' Application. -------------------------------------------------------------------------------- HTTP Error 500 - Internal Server Error.

... if any of you guys can work it out it would be much appreciated... Thanks

'mysql_connect', not 'MySQL_connect', etc

Alister Bulman
– Alister Bulman

2011-03-06 01:52:26 +00:00
Commented Mar 6, 2011 at 1:52 — Alister Bulman
– Alister Bulman, Commented Mar 6, 2011 at 1:52
yeah... i tried that it didn't work, thanks anyway.

Sam
– Sam

2011-03-06 01:54:03 +00:00
Commented Mar 6, 2011 at 1:54 — Sam
– Sam, Commented Mar 6, 2011 at 1:54

steveo225 · Accepted Answer · 2011-03-06 01:28:02Z

2

Sounds like your PHP configuration is not setup for mySQL. Try using the phpinfo() function to see if it is.

answered Mar 6, 2011 at 1:28

steveo225

12k16 gold badges70 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

steveo225 Over a year ago

Just create a dummy script, with <?php phpinfo(); ?> and then navigate to that script. It will dump a lot, including what extensions are configured. Just look for a mysql entry, it should have version info if installed. Otherwise there will not be a mysql entry, or it will state that it is not configured.

Jon Over a year ago

@Sam: well, you could start by googling it.

Sam Over a year ago

Yh it came up with the php page, but what am i looking for? :L

steveo225 Over a year ago

They are all slightly different, but basicall, just do a search for mysql and you should get 1 or 2 boxes that list information like Client API version or mysql.default_host. If the boxes aren't there, or have values that suggesting it isn't configured, contact your host.

Sam Over a year ago

i did a search for mysql and the sections they were under were: Path, MySqlnd and _SERVER["path"]

|

Collectives™ on Stack Overflow

Why won't my php script connect to mysql?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related