PHP Code after '>' Displayed as HTML

Question

I am going nuts trying to use PHP to get and insert values into an SQLite database. I haven't even managed to get that far yet!
It seems that all the php code after '>' is displayed as html text and I cant understand why. The code is posted below.

   <html>
<head></head>
<body>
<?php
try
{
  //create or open the database
  $database = new SQLiteDatabase('myDatabase.sqlite', 0666, $error);
}
catch(Exception $e)
{
  die($error);
}

//add Movie table to database
$query = 'CREATE TABLE Movies ' .
         '(Title TEXT, Director TEXT, Year INTEGER)';

if(!$database->queryExec($query, $error))
{
  die($error);
}

//insert data into database
$query =
  'INSERT INTO Movies (Title, Director, Year) ' .
  'VALUES ("The Dark Knight", "Christopher Nolan", 2008); ' .

  'INSERT INTO Movies (Title, Director, Year) ' .
  'VALUES ("Cloverfield", "Matt Reeves", 2008); ' .

  'INSERT INTO Movies (Title, Director, YEAR) ' .
  'VALUES ("Beverly Hills Chihuahua", "Raja Gosnell", 2008)';

if(!$database->queryExec($query, $error))
{
  die($error);
}

//read data from database
$query = "SELECT * FROM Movies";
if($result = $database->query($query, SQLITE_BOTH, $error))
{
  while($row = $result->fetch())
  {
    print("Title: {$row['Title']} <br />" .
          "Director: {$row['Director']} <br />".
          "Year: {$row['Year']} <br /><br />");
      }
    }
    else
    {
      die($error);
    }
    ?>
    </body>
    </html>

And this is what is displayed in html.

queryExec($query, $error)) { die($error); } //insert data into database $query = 'INSERT INTO Movies (Title, Director, Year) ' . 'VALUES ("The Dark Knight", "Christopher Nolan", 2008); ' . 'INSERT INTO Movies (Title, Director, Year) ' . 'VALUES ("Cloverfield", "Matt Reeves", 2008); ' . 'INSERT INTO Movies (Title, Director, YEAR) ' . 'VALUES ("Beverly Hills Chihuahua", "Raja Gosnell", 2008)'; if(!$database->queryExec($query, $error)) { die($error); } //read data from database $query = "SELECT * FROM Movies"; if($result = $database->query($query, SQLITE_BOTH, $error)) { while($row = $result->fetch()) { print("Title: {$row['Title']}" . "Director: {$row['Director']}". "Year: {$row['Year']}"); } } else { die($error); } ?>

I am running this on Mac OS X on my localhost apache server.
Any help would be awesome.

Hang on, what line of the code posted does everything start being outputted as HTML? — Edoardo Pirovano
– Edoardo Pirovano, Commented Jul 5, 2011 at 11:16
I have trouble understanding your question. Which '>' do you mean? Is ALL php source code displayed (which would mean that your apache is misconfigured) or just a certain part? — yankee
– yankee, Commented Jul 5, 2011 at 11:16
Sorry should have specified. I have put in what is output in my html browser — StuStirling
– StuStirling, Commented Jul 5, 2011 at 11:18

k102 · Accepted Answer · 2011-07-05 11:43:59Z

2

since code between <?php and -> contains no < or > symbols it's treated like some kind of html tag. so, you see everything outside if this tag. this means - php isn't installed (properly)

try this: check your httpd.conf for such string: AddType application/x-httpd-php .php and try to save your file as .php

edited Jul 5, 2011 at 11:43

answered Jul 5, 2011 at 11:38

k102

8,1099 gold badges52 silver badges72 bronze badges

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

3 Comments

StuStirling Over a year ago

I can't find that line in my httpd.config?

StuStirling Over a year ago

I added it and it made no difference

StuStirling Over a year ago

tried stripping the php code out and putting it in a separate file called test.php and running it with 'php test.php' but still to no avail. It must be something to do with the php setup on my mac

user428517 · Accepted Answer · 2011-07-05 13:45:40Z

1

If you're using a .html file, try renaming it to .php.

answered Jul 5, 2011 at 13:45

user428517

4,2031 gold badge24 silver badges39 bronze badges

Comments

Scott C Wilson · Accepted Answer · 2011-07-05 11:17:07Z

0

Are you sure your php installation is working? Try running this script (test.php):

<?php
phpinfo();
?>

answered Jul 5, 2011 at 11:17

Scott C Wilson

19.7k11 gold badges64 silver badges88 bronze badges

Comments

Rukmi Patel · Accepted Answer · 2011-07-05 11:19:59Z

0

if you are saying that code after ?> running as html then it is completely fine..because ?> is closing tag for php ..

anything under "" is considered as php and outside of it consider as html...

or php server is not installed properly so that everything is considered as html code..

answered Jul 5, 2011 at 11:19

Rukmi Patel

2,5619 gold badges29 silver badges42 bronze badges

1 Comment

StuStirling Over a year ago

I have editedd my question to show what is being output in my html browser. This code is basically copied from a tutorial located at switchonthecode.com/tutorials/…

Sandeep Manne · Accepted Answer · 2011-07-05 11:22:44Z

0

Surely your Apache is not configured properly with php, its just sending the raw page, not only after >, check view-source in your browser you can see all your code

answered Jul 5, 2011 at 11:22

Sandeep Manne

6,0825 gold badges41 silver badges55 bronze badges

2 Comments

StuStirling Over a year ago

I just check my source and up until that '>' its all in pink which i guess is the colour for php. Its as if its reading it as a closing bracket?

Sandeep Manne Over a year ago

Its reading it as html tag, so its not displaying that, but your server is not at all executing your php code.

Edson Medina · Accepted Answer · 2011-07-05 11:32:21Z

0

What filename have you used for the script?

answered Jul 5, 2011 at 11:32

Edson Medina

10.3k4 gold badges43 silver badges53 bronze badges

2 Comments

StuStirling Over a year ago

for the above code I have it in an html file called test.html and access it using 127.0.0.1/test.html

afaf12 Over a year ago

Rename the file to test.php then.

yankee · Accepted Answer · 2011-07-05 13:53:09Z

0

Your code is not executed on the server. Apache delivers your php-Sourcecode. Your webbrowser thinks that <?php is an opening tag, but it does not recognize it and does not display the tag. Here your browser thinks that the tag I mentioned ends: if(!$database->queryExec($query, $error)). See the > in this line? So your browser believes that everything from <?php to this > is an unknown tag, which it ignores and does not display. In your Browser right click on the page and select view source code. Then you should see the full source.

Make sure that you have mod-php correctly installed in your apache or that you have your cgi-mod setup correctly. Check your httpd.conf for the registered file extensions (should look like AddType application/x-httpd-php .php .phtml .php3). Make sure that your php-file has a file existensions that fits to this configuration.

answered Jul 5, 2011 at 13:53

yankee

41.3k17 gold badges113 silver badges169 bronze badges

1 Comment

StuStirling Over a year ago

Ok managed to get this working and it displays the phpinfo(). What I did was re-copy my php.ini.default file to php.ini. So basically started over.

Collectives™ on Stack Overflow

PHP Code after '>' Displayed as HTML

7 Answers 7

3 Comments

Comments

Comments

1 Comment

2 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

3 Comments

Comments

Comments

1 Comment

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related