MySQL PHP database connection

Question

Here is my index.html file. I load the page and nothing happens. Shouldn't it print "Please try again" on the webpage if my info is incorrect?

 <html>
    <body>
      <h1>mySQL</h1>

      <?php

      $server = "mysql.blah.com"; 
      $username = "my_username";
      $password = "my_password";
      $database = "my_database";

      $mysqlConnection = mysql_connect($server, $username, $password);
      if (!$mysqlConnection){
        echo "Please try later.";
      }
      else {
        echo "All good";
        mysql_select_db($database, $mysqlConnection);
      }

      ?>

    </body>
</html>

Change this index.html page to index.php page, and run it from the server again. — Rajdeep Paul
– Rajdeep Paul, Commented Jan 7, 2017 at 18:27
Don't use mysql_* functions, they are deprecated as of PHP 5.5 and are removed altogether in PHP 7.0. Use mysqli or pdo instead. And this is why you shouldn't use mysql_* functions. — Rajdeep Paul
– Rajdeep Paul, Commented Jan 7, 2017 at 18:28
Did you change the handler to load HTML as PHP? What PHP version are you running? What do you error logs show? Is the PHP in your source? — chris85
– chris85, Commented Jan 7, 2017 at 18:29

Alex · Accepted Answer · 2017-01-07 18:28:18Z

5

This is because your file has the .html extension.
Change it to .php and run it again.

Be sure to run it on a web server, that has PHP installed

answered Jan 7, 2017 at 18:28

Alex

38.6k55 gold badges217 silver badges340 bronze badges

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

1 Comment

tazboy Over a year ago

Totally forgot I couldn't run PHP off of my computer without a server running. Thanks.

Francis Sunday · Accepted Answer · 2017-01-09 14:27:06Z

-1

change the file to the .php extension and use this refactored version

<html>
    <body>
      <h1>mySQL</h1>

      <?php

     try 
     {
        $server = "mysql.blah.com"; 
        $username = "my_username";
        $password = "my_password";
        $database = "my_database";

        $mysqlConnection = new PDO('mysql:host={$server};dbname={$database};', '{$username}', '{$password}');
        $mysqlConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      }
      catch(PDOException $e)
      {
        echo ('Please try later.');
        echo $e->getMessage();
      }
      ?>

    </body>
</html>

edited Jan 9, 2017 at 14:27

answered Jan 7, 2017 at 18:43

Francis Sunday

771 silver badge11 bronze badges

3 Comments

tazboy Over a year ago

I tried this code but it had errors on this line: $mysqlConnection = new PDO('mysql:host={$server};dbname={$database};', {$username}, {$password}); Thanks.

Francis Sunday Over a year ago

@tazboy what error message did you get, and i made a little correction to the script

tazboy Over a year ago

I don't remember exactly but it said something about an error with '{'

Collectives™ on Stack Overflow

MySQL PHP database connection

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related