Web Development

19-Apr-14 2:49

i am working on a project and on a page i get this error.

Parse error: parse error in C:\wamp\www\RMS\comresult.php on line 143

line 143 is the last line of my code.

Please i need help.

Richard MacCutchan19-Apr-14 6:06

19-Apr-14 6:06

Well I'm afraid we cannot guess what is on line 143; or any other line. Please show the code, especially the line where the error occurs.

Izu Great19-Apr-14 8:31

19-Apr-14 8:31

Line 143 is the last line "". This is my code.

XML

<?php
include("conn.php");
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome :: Result Portal</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
body {
    background-color: #FFF;
}
</style>
<!--[if IE]>
<script src="ie/dist/html5shiv.js"></script>
<script src="ie/dist/html5shiv-printshiv.js"></script>
<![endif-->
<script type="text/javascript">
function bk(){
location.assign(document.referrer);
}
var state = true;

function getstate(){
    return state;
    }
</script>
</head>

<body onload="print()">
<?php
                    if(isset($_GET['lev'],$_GET['sem'],$_GET['prog'],$_GET['sess'])){
        $level = $mysqli->real_escape_string(trim($_GET['lev']));
        $sem = $mysqli->real_escape_string(trim($_GET['sem']));
        $prog = $mysqli->real_escape_string(trim($_GET['prog']));
        $sess = $mysqli->real_escape_string(trim($_GET['sess']));

    $sql = "SELECT * FROM course_tb WHERE level LIKE '".$level."' AND semester LIKE '".$sem."'";
    if($result = $mysqli->query($sql)){
        if($result->num_rows > 0){

        $sel = "SELECT DISTINCT regno FROM st_result_data WHERE level LIKE '".$level."' AND semester LIKE '".$sem."' AND programme LIKE '".$prog."'";

        if($res = $mysqli->query($sel)){
            if($res->num_rows > 0){

                //$sel2 = "SELECT * FROM st_result_data WHERE regno LIKE '".$row['regno']."' AND level LIKE '".$level."' AND semester LIKE '".$sem."' AND programme LIKE '".$row['programme']."'";
            //if($res2 = $mysqli->query($sel2)){
                //if($res2->num_rows > 0){
                ?>
                    <table width="700" border="0" cellpadding="0" >
  <tr>
    <td align="center" style="border-bottom: 1px dashed #CCC;"></td>
  </tr>
  <tr>
    <td height="27" style="border-bottom: 1px dashed #CCC;">
      <table width="600" border="0" align="center" cellpadding="0">
        <tr>
          <td align="center"><h4><?php echo $level." | ".$sem; ?> SEMESTER RESULT <?php echo $sess; ?> SESSION <?php echo $prog; ?></h4></td>
        </tr>
      </table>
      <span id="regerr"></span></td>
  </tr>
  <tr>
    <td height="27" style="border-bottom: 1px dashed #CCC;"><table width="650" border="0" align="center" cellpadding="0">
      <tr>
        <td style="border-bottom: 1px dashed #CCC;">Regno</td>
        <td style="border-bottom: 1px dashed #CCC;">Name</td>
        <td style="border-bottom: 1px dashed #CCC;">
        <?php
        while($row=$result->fetch_array()){
            ?>
            <table>
            <tr>
            <td><?php echo $row['courseCode']; ?> </td>
            </tr>
            <tr>
            <td><?php echo $row['creditLoad']; ?> </td>
            </tr>
            </table>
            <?
        }
        ?>
        </td>
        </tr>
      <?php
      //while($rw2 = $res2->fetch_array()){
      ?>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        </tr>
      <?php
      //}
      ?>
    </table></td>
  </tr>
  <tr>
    <td style="border-bottom: 1px dashed #CCC;"><table width="600" border="0" align="center" cellpadding="0">
      <tr>
        <td width="177">No of courses:</td>
        <td width="417">&nbsp;</td>
      </tr>
      <tr>
        <td>No of fail:</td>
        <td>&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td align="center">&nbsp;</td>
  </tr>
  <tr>
    <td align="center"><input type="button" name="button" id="button" value="Print" onclick="print()" /></td>
  </tr>
</table>
                    <?php

                //}else{

                //}
            //}else{
                //echo $mysqli->error;
            //}

            }
        }
                    }
        }echo $mysqli->error;
    }
                    ?>

</body>
</html>

Richard MacCutchan19-Apr-14 8:58

19-Apr-14 8:58

At a guess you have a mismatched brace or HTML tag.

Izu Great19-Apr-14 9:10

19-Apr-14 9:10

The braces are Matched correctly.

Richard MacCutchan19-Apr-14 21:08

19-Apr-14 21:08

I can only suggest that you go through the code and remove sections one at a time until the error disappears. You will then be able to see which section is the cause and correct it.

Izu Great20-Apr-14 0:12

20-Apr-14 0:12

Ok thanks I found the problem.

Izu Great20-Apr-14 0:49

20-Apr-14 0:49

this is the problem.

PHP

<?php
     $sql = "SELECT * FROM course_tb WHERE level LIKE '".$level."' AND semester LIKE '".$sem."'";
 if($result = $mysqli->query($sql)){
     if($result->num_rows > 0){
     while($rw = $result->fetch_array()){
         ?>

         <?
     }}}
     ?>

whenver i try to loop through $result->fetch_array() it returns the Parse Error.

Richard MacCutchan20-Apr-14 1:41

20-Apr-14 1:41

I am not sure about the extra ?> and <?, perhaps it should be:

PHP

<?php
    $sql = "SELECT * FROM course_tb WHERE level LIKE '".$level."' AND semester LIKE '".$sem."'";
    if($result = $mysqli->query($sql)){
        if($result->num_rows > 0){
            while($rw = $result->fetch_array()){
            }
        }
    }
?>

See http://www.w3schools.com/php/php_looping.asp[^].

Graham Breach20-Apr-14 6:26

Graham Breach

20-Apr-14 6:26

You have used a short PHP opening tag "<?" inside the loop instead of the full tag "<?php" - if short_open_tag is disabled in your php.ini, then this will cause a parse error.

Izu Great20-Apr-14 10:01