Blog PDO connection error

Asked May 11 '17 at 07:15

Active May 11 '17 at 07:16

Viewed 35 times

So I'm getting this error,

Parse error: syntax error, unexpected '$conn' (T_VARIABLE) in C:\MAMP\htdocs\Blog\verwerk.php on line 14.

This is my script

<?php
/**
 * Created by PhpStorm.
 * User: Desir
 * Date: 10-5-2017
 * Time: 11:55
 */

$servername = "localhost";
$username = "root";
$password = "-";

try {
        $conn = new PDO("mysql:host=$servername;dbname=blog", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully";
    }
catch(PDOException $e)
    {
        echo "Connection failed: " . $e->getMessage();
    }
?>

I can't figure out a way to get it working been trying loads of stuff. Would be nice if someone could actually help me figure this out.

Thanks.

edited May 11 '17 at 07:16

Jens

67,715
15
98
113

asked May 11 '17 at 07:15

Kim Allenboy Nijenhuis

1

This code does not have the said parse error – Hanky Panky May 11 '17 at 07:18
Well, tell me why I'm getting it then? – Kim Allenboy Nijenhuis May 11 '17 at 07:20
some where you try to use `$conn` variable? show us that code along with the above code – Alive to die - Anant May 11 '17 at 07:21
2

Is this really the whole code? As it is now, there are no errors except a failing DB connection, but that would trigger the `catch` block. – Tobias F. May 11 '17 at 07:23
The script I added above is the only script where I used this variable – Kim Allenboy Nijenhuis May 11 '17 at 07:25
I also got a script for adding a post, deleting and editing one. I also have an index.php – Kim Allenboy Nijenhuis May 11 '17 at 07:26
1

@KimAllenboyNijenhuis is the above code belong to `verwerk.php`? if no then show `verwerk.php` page code.don't remove this one ,just add `verwerk.php` page code in your question – Alive to die - Anant May 11 '17 at 07:27
1

Usually errors like this are because you left out `;` on the line before the error. – Barmar May 11 '17 at 07:28
1

The code above is my verwerk.php (My connection) – Kim Allenboy Nijenhuis May 11 '17 at 07:30
the problem is with your password for the mysql. i tested this code with my password which is characters and numbers, and it was connected successfully – Exprator May 11 '17 at 07:32
@Exprator well this is weird, because I use the same password for logging in on phpMyAdmin. – Kim Allenboy Nijenhuis May 11 '17 at 07:34
i know, but from script special characters create problem, just change the password and give it a try – Exprator May 11 '17 at 07:39
Well I fixed it by removing the try and catch, only I'm getting a different error at the moment. – Kim Allenboy Nijenhuis May 11 '17 at 07:43
And the new error is...? – Tobias F. May 11 '17 at 07:46
I already fixed it, thanks for helping tho, really appreciate your time. – Kim Allenboy Nijenhuis May 11 '17 at 07:52

Blog PDO connection error

0 Answers0