Unexpected results in brower when using pdo_mysql

Question

My code is very simple. I'm attempting to connect to a MySQL instance using pdo_mysql functions. I'm thinking there is a syntax error but the dozens of websites I researched doesn't help me identify it. Below is my code and what is presented on the webpage. Can someone give me some direction?

*** I tried to insert some sites but the app is not letting me.

The pdo_mysql extension is enabled and is displayed in phpinfo.php.

I'm using PHP 7.1.4 on a Windows Server 2012R2 with IIS 8.5

FastCGI is enabled.

Here is my code:

<?php
$username = "myusername";
$password = "mypassword"
$dbname = "mysql"
$hostname = "myserver"
$query = "select user,host from mysql.user";
try {
    $dbconn = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $dbconn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully"; 
    }
catch(PDOException $e)
    {
    echo "Connection failed: " . $e->getMessage();
    }
$dbconn = null;
?>

The results on the webpage is:

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully"; } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); } $dbconn = null; ?>

did you try any other simple php class or file which just print or loop ? — zod, Apr 28 '17 at 18:52

score 0 · Accepted Answer · answered Apr 28 '17 at 19:03

Based on the fact that your webpage is outputting all of the text after the >, I'm inclined to think that this file is being interpreted as an HTML document, rather than being processed as PHP.

If you view the source for the web page, I would bet that you would see everything from <?php to $dboconn-> in the source, but treated as one long html element.

The obvious thing to check first is if the file has a .php extension. If not, then you'll need to dig into why your server is not executing .php files.

Thanks. That got me past that issue. Now on to another. – jprichart Apr 28 '17 at 20:47 — jprichart, Apr 28 '17 at 20:47

Unexpected results in brower when using pdo_mysql

1 Answers1