php syntax error, unexpected T_VARIABLE, expecting ',' or ';' on line 29 [closed]

Question

I'm trying to echo my information from my database in a simple blog. Now it just won't work. Whatever I try. I'm trying to figure it out myself but I am stuck behind a single error.

php syntax error, unexpected T_VARIABLE, expecting ',' or ';' on line 29

I just can't find a solution for it.. Hope you guys can help me. I am getting pretty insane of being stuck for hours here.

require('config.inc.php');
require('template.inc.php');
require('functions.inc.php');

$db_host = "***********";
$db_username = "************0";
$db_pass = "*********";
$db_name = "****************";

@mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to        mysql");
@mysql_select_db("$db_name") or die ("no database");

$title=$_POST['title'];
$contents=$_POST['contents'];
$author=$_POST['author'];
$date=$_POST['date'];
$date = strftime("%b %d, %y", strtotime($date));

$sqlcreate = mysql_query("INSERT INTO blog (date, title, contents, author)
            VALUES(now(),'$title','$contents','$author')");
$query="SELECT * FROM tablename";
$result=mysql_query($query);
htmlOpenen('Voeg nieuwe post toe');
while ($result=mysql_query($query) ) {
echo'
<span class="post">
    <h1>'$result['title'];'</h1>
    <h2>'$result['date'];'</h2>
    <p>'$result['contents'];'</p>
    <h3>'$result['author'];'</h3>
';
}
htmlSluiten();
mysql_close();

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — John Conde
– John Conde, Commented Jan 30, 2013 at 14:18
Also, please don't give away your DB credentials to everybody — danronmoon
– danronmoon, Commented Jan 30, 2013 at 14:21

John Conde · Accepted Answer · 2013-01-30 14:17:53Z

3

You forgot your concatentors:

echo'
<span class="post">
    <h1>'$result['title'];'</h1>
    <h2>'$result['date'];'</h2>
    <p>'$result['contents'];'</p>
    <h3>'$result['author'];'</h3>
';

should be

echo'
<span class="post">
    <h1>'.$result['title'].'</h1>
    <h2>'.$result['date'].'</h2>
    <p>'.$result['contents'].'</p>
    <h3>'.$result['author'].'</h3>
';

answered Jan 30, 2013 at 14:17

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

1 Comment

Jos Over a year ago

Thanks, it works sort off now. But everytime I refresh my page it just puts the last post in my database again and than in shows up again. Is there some way to prevent this?

Collectives™ on Stack Overflow

php syntax error, unexpected T_VARIABLE, expecting ',' or ';' on line 29 [closed]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related