Parse error

**EOBeav** · Sep 10, 2006, 21:12

I'm getting this message:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/consul12/public_html/phpmysql/chapter4/jokelist.php on line 36

Line 36 is:

PHP Code:


  echo '<p>' . $row['joketext'] . '</p>';

This is from the Kevin Yank php/MySQL book, and I've been able to successfully run it from the server on my own computer. I'm trying to run it from the server on my webhost. Any ideas where to look to fix this? Oh, the server on my computer was Windows, and the one on LP is Linux, if that makes a difference.

**bobber205** · Sep 10, 2006, 21:36

I would guess that you did not connect to MySQL correctly.

**clamcrusher** · Sep 10, 2006, 21:51

with parse errors, your mistake is often on the lines before the line reported. this is because the parser did not fail until the line reported.

so look a few lines before line 36.

if your text editor provides syntax highlighting for php, your mistake will usually be obvious, as often the colors will go haywire around where you made your mistake. if you dont have an editor that offers this, get one now. a good code editior is indispensable. one i recomend is notepad++

**EOBeav** · Sep 10, 2006, 22:00

Yeah, I actually have Notepad2 for that stuff. I'm having a tough time finding the error in there, though.

**EOBeav** · Sep 10, 2006, 22:02

Originally Posted by bobber205

I would guess that you did not connect to MySQL correctly.

So where would I look to find this out?

**clamcrusher** · Sep 10, 2006, 22:07

this is not a mysql connection error. this is a parse error.

you can always post a bit more code if your having a tough time. post the code before line 36.

**EOBeav** · Sep 10, 2006, 22:18

Does it matter that the server I'm transferring all of this to is Linux, and the server on my computer at home is Windows? Just kind of grasping at straws here...

**clamcrusher** · Sep 10, 2006, 22:37

different versions of php could cause a parse error in only 1 version, although this is not common.

i dont think you have the same version of the file on the working and non working server.

**spikeZ** · Sep 11, 2006, 01:09

Post some more code as clam suggested. It doesn't look like a connection error.

**simplecode** · Sep 11, 2006, 01:43

Try to print the 5 lines above 36 and below 36

**EOBeav** · Sep 11, 2006, 07:38

Here they are, and thanks to everybody for taking a look at it:

PHP Code:


$result = @mysql_query('SELECT joketext FROM joke');

if (!$result) {

  exit('<p>Error performing query: ' . mysql_error() . '</p>');

}



// Display the text of each joke in a paragraph

while ($row = mysql_fetch_array($result)) {

  echo '<p>' . $row['joketext'] . '</p>';

}



?>

</blockquote>

</body>

</html>

**kyberfabrikken** · Sep 11, 2006, 07:43

Doesn't look like the error is in there. Try posting the entire file.

**coastgames** · Sep 11, 2006, 08:20

When i take that same routine snippet and test it it works. The error is further up the script.

Are you using any echo<<<EOF 's
It could be that or even an extra } or {

**clamcrusher** · Sep 11, 2006, 09:43

my guess is you have an unclosed double quote "

but post more code.

**EOBeav** · Sep 11, 2006, 17:00

Ok, here's the whole thing. What's weird is now I'm not connecting to the database at all. I haven't changed anything.

PHP Code:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>Our List of Jokes</title>

<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />

</head>

<body>

<?php



// Connect to the database server

$dbcnx = @mysql_connect('localhost' , 'username' , 'databasename' , 'password');

if (!$dbcnx) {

  exit('<p>Unable to connect to the ' .

      'database server at this time.</p>');

}



// Select the jokes database

if (!@mysql_select_db('joketable')) {

  exit('<p>Unable to locate the joke ' .

      'database at this time.</p>');

}



?>

<p>Here are all the jokes in our database:</p>

<blockquote>

<?php

  

// Request the text of all the jokes

$result = @mysql_query('SELECT joketext FROM joke');

if (!$result) {

  exit('<p>Error performing query: ' . mysql_error() . '</p>');

}



// Display the text of each joke in a paragraph

while ($row = mysql_fetch_array($result)) {

  echo '<p>' . $row['joketext'] . '</p>';

}



?>

</blockquote>

</body>

</html>

**bobber205** · Sep 11, 2006, 18:10

You typically need a port number after the server name. Mine is
"localhost:8889".

That may be way you're not connecting.

**EOBeav** · Sep 11, 2006, 18:56

I found somebody in our webhost's forums who helped me out, and we got it fixed. Thanks for your help though.

**simplecode** · Sep 11, 2006, 20:42

what was the issue?

**EOBeav** · Sep 11, 2006, 20:54

I didn't have the correct database name at mysql_select_db. This was one of those "d-ohh" moments, that I seem to have a lot of since attempting to learn php/MySQL.

**bobber205** · Sep 11, 2006, 21:06

Ah ha!

I was right.

**EOBeav** · Sep 11, 2006, 21:09

Originally Posted by bobber205

I would guess that you did not connect to MySQL correctly.

Yep!!

**clamcrusher** · Sep 11, 2006, 22:21

that doesnt make any sense if php was reporting a parse error.

weird...

**kyberfabrikken** · Sep 12, 2006, 00:45

Originally Posted by clamcrusher

that doesnt make any sense if php was reporting a parse error.

weird...

yeah ... that error is completely unrelated to the database connection.

**EOBeav** · Sep 12, 2006, 20:30

Can't say I disagree with you guys...All I know is that it's fixed now.

The SitePoint Forums have moved.

User Tag List

Thread: Parse error

Thread Tools

Display

Parse error

Bookmarks

Bookmarks

Posting Permissions