I am trying to connect to MySQL

Asked Dec 31 '16 at 21:24

Active Dec 31 '16 at 21:35

Viewed 33 times

I am trying to connect to my mySQL database with dis code:

<?php
define('DB_NAME','pets');
define('DB_USER','root');
define('DB_PSW','password');
define('DB_HOST','localhost');

$link = mysql_connect(DB_HOST, DB_USER, DB_PSW);
if (!$link){
    die('Could not connect to DB ' . mysql_error());
}

$db_selected = mysql_select_db(DB_NAME, $link);if (!db_selected) {
    die('Cant use ' . DB_NAME . ': ' . mysql_error());
}
echo "Connected!";

But it never displays anything, it's just blank. I have php installed, and this displays info:

<?php
phpinfo();
?>

I am running PHP Version 7.0.8-0ubuntu0.16.04.3

Can You please help me?? Thank You!

edited Dec 31 '16 at 21:35

Funk Forty Niner

74,450
15
68
141

asked Dec 31 '16 at 21:24

Ervin

Check your server error log. – Barmar Dec 31 '16 at 21:25
What version of PHP are you running. The mysql extension was removed in PHP 7, you need to use mysqli or PDO. – Barmar Dec 31 '16 at 21:25
Does ` – Funk Forty Niner Dec 31 '16 at 21:25
Where can i check server error log? – Ervin Dec 31 '16 at 21:27
I am running PHP Version 7.0.8-0ubuntu0.16.04.3! Then propably this is the problem. Yes? – Ervin Dec 31 '16 at 21:28
2

^ that comment (*"I am running PHP Version 7.0.8-0ubuntu0.16.04.3"*) just closed the question. The `mysql_` API will not run on php 7, it's been deleted. Use the `mysqli_` or PDO api. – Funk Forty Niner Dec 31 '16 at 21:28
Yes – Ervin Dec 31 '16 at 21:29
2

http://php.net/manual/en/function.mysql-connect.php *"**Warning** This extension was deprecated in PHP 5.5.0, and it was **removed** in PHP 7.0.0."* – Funk Forty Niner Dec 31 '16 at 21:30
Can I even upvote theese comments? – Ervin Dec 31 '16 at 21:30
Probably not, TBH I can't remember if low rep members can upvote comments, but you can try ;-) – Funk Forty Niner Dec 31 '16 at 21:30
However, what would have shown you something, would have been PHP's error reporting http://php.net/manual/en/function.error-reporting.php – Funk Forty Niner Dec 31 '16 at 21:32

I am trying to connect to MySQL

0 Answers0