PHP and HTML code that is not working

[Macadrian]

I am currently developing a small website as part of a final project review and I must absolutely use tomcat5.5. So I used the web application PHP/Java bridge template. So my problem is that not only the PHP code does not run, but also the HTML that is after the HTML code and also ignored.

Here is the code I typed:

.... 
<div class="text"> 
<?php 
mysql_connect ( 'localhost', 'root', 'admin') or die ( 'Error connecting to MySQL'); 
mysql_select_db ( 'Oreka') or die ( 'Error Oreka selection'); 
$ response = mysql_query ( 'SELECT * FROM rectape') or die ( 'Error query'); 
while ($ data = mysql_fetch_array ($ answer)) 
{echo $ data [ 'id'].'< br/>'; 
}
mysql_close (); 
?> 
<p> resumption of HTML </p> 
</div> 
....

All that is before this part of code works perfectly. But from what I have written here, nothing appears, neither the query results or error messages. When I display the source code of that page, "<p> resumption of HTML </p> </div>" and everything after that there does not appear. I do not know if I made a syntax error or if there is another problem.

[CitricAcid]

I'd say you have an error somewhere in your php code. Specifically, if you have an error in the mysql_connect, mysql_select_db mysql_query or you do a die () and blow the rest does not play. A "trick" to find the line in error:

  <? php 
  echo "connect"; 
  mysql_connect ( 'localhost', 'root', 'admin') or die ( 'Error connecting to MySQL'); 
  echo "- OK <br /> select DB"; 
  mysql_select_db ( 'Oreka') or die ( 'Error Oreka selection'); 
  echo "- OK <br /> query"; 
  $ response = mysql_query ( 'SELECT * FROM rectape') or die ( 'Error query'); 
  echo "- OK <br />"; 
  while ($ data = mysql_fetch_array ($ answer)) 
  (Echo $ data [ 'id']. "<br/> '; 
  ) 
  mysql_close (); 
  ?>

And if not, it gets even better with the log file errors of php

[Praetor]

Hello and a quick question before: What do you know about coding? If you've tried to make a simple

echo 'test';

refer history to see if it appears. I also think there is an error, which is not displayed. Add the line error_reporting (0); in your PHP code.

[Macadrian]

Thank you all. CitricAcid I tried your code. It does gives me "connect". In the log file I found "PHP Fatal error: Call to undefined function mysql_connect ()" which is odd, because if the connection settings were wrong, normally it would display "Error connecting to mysql" too.

To answer the Praetor question, I am doing research in telecommunications.

[fellah]

"PHP Fatal error: Call to undefined function mysql_connect ()"

There is nothing odd in this error message. This kind of error message might occur if mysql extension is not installed on your server. Check this and see if you can solve your problem.