Databases
StackOverflow2013
Postsdbo
POneed help unexpected $end in php
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POneed help unexpected $end in php
    primarykey
    data
    text
    <p>I am getting this error in my code.</p> <pre><code>Parse error : syntax error, unexpected $end in /../messenger.php on line 304 </code></pre> <p>I've checked my script a couple of times and i don't find any missing semicolon or bracket.So if anyone can help please give me your advice. </p> <p>Here is my script </p> <pre><code>&lt;?php mysql_connect ("localhost","root",""); mysql_select_db ("aplydroidmessenger"); extract ($_REQUEST, EXTR_OVERWRITE); if ($c=="r"){ $reg = " "; $h = ereg_replace ("~", $reg, $h); $n = ereg_replace ("~", $reg, $n); if ($s == "user") { $sql = "SELECT * FROMhe tbl_user where nick = '$k'"; $result = mysql_query ($sql); $total = mysql_num_rows ($result); if ($total == 0) { $sql = "INSERT INTO tbl_user (name,email,password,nick,status,cdate)"; $sql .= "VALUES ('$n','$e','$p','$k','offline',NOW())"; $result = mysql_query($sql) or die("gagal"); $status = 1; $msgReg = "============================\n"; $msgReg .= " SELAMAT\n"; $msgReg .= "===========================\n"; $msgReg .= "Kamu Telah Terdaftar\n"; $msgReg .= "Nick anda adalah : $k \n"; echo $msgReg; } else { echo "Nick anda telah terdaftar"; } } else if ($s == "room"){ $sql = "SELECT * FROM tbl_user where nick = '$k'"; $result = mysql_query($sql); $total = mysql_num_rows($result); if ($total == 0){ $sql = "INSERT INTO tbl_user (name,email,password,nick,status,cdate)"; $sql .= "VALUES ('$n','$e','$p','$k','room',NOW())"; $result = mysql_query($sql) or die ("gagal"); $status = 1; $msgReg = "SUKSES"; echo $msgReg; } else { echo "Room is exist"; } } } if ($c=="s"){ $sql = "SELECT * FROM tbl_user"; $sql .= "WHERE nick = '$k' AND password = '$p'"; $result = mysql_query($sql) or die ("3"); $row = mysql_num_rows($result); if ($row &gt; 0){ $sql = "UPDATE tbl_user set status = 'online'"; $sql .= "WHERE nick = '$k'"; $result = mysql_query($sql) or die ("2"); if ($result) { echo "1"; } } else { echo "2"; } } if ($c=="f"){ if ($z=="on"){ $sql = "SELECT * FROM tbl_user"; $sql .= "WHERE status='online' AND nick != '$k'"; $result = mysql_query($sql) or die ("gagal"); $spce = "_"; $con = "1"; $row = mysql_num_rows($result); if (!$row == 0){ while ($data = mysql_fetch_array($result)){ $nama .= $data["nick"].$spce; } echo "$con$nama"; } else { echo "1"; } } else if ($z=="off"){ $sql = "SELECT * FROM tbl_user"; $sql .= "WHERE status='offline' AND nick != '$k'"; $result = mysql_query($sql) or die ("gagal"); $spce = "_"; $con = "0"; $row=mysql_num_rows($result); if (!$row == 0){ while ($data = mysql_fetch_array($result)){ $nama .= $data["nick"].$spce; } echo "$con$nama"; } else { echo "0"; } } if ($c=="a"){ $spce = "_"; $con = "1"; $sqla = "SELECT * FROM tbl_user"; $sqla .= "WHERE nick = '$k'"; $reslt = mysql_query($sqla); if (mysql_num_rows($reslt) &gt; 0){ while ($data = mysql_fetch_array($reslt)){ $userid = (int) $data ["id"]; } } $sqlb = "SELECT * FROM tbl_room_user"; $sqlb .= "WHERE id_user = '$userid'"; $hasil = mysql_query($sqlb); if (mysql_num_rows($hasil) &gt; 0){ $i=1; while ($data = mysql_fetch_array($hasil)){ $roomid[$i] = (int) $data ["id_room"]; $i++; } } for ($i=1;$i &lt;=count($roomid);$i++){ $sql_rm = "SELECT * FROM tbl_room"; $sql_rm .= "WHERE id = '$roomid[$i]'"; $resultq = mysql_query($sql_rm) or die ("gagal"); $row=mysql_num_rows($resultq); if (!$row == 0){ while ($data = mysql_fetch_array($resultq)){ $nama .= $data["nama"].$spce; } } } echo "$con$nama"; } if ($c=="o"){ $sql = "UPDATE tbl_user set status = 'offline'"; $sql .= "WHERE nick = '$k'"; $result = mysql_query($sql) or die ("2"); } if ($c=="k"){ $spasi = " "; $null = ""; $m = ereg_replace("~", $spasi, $m); $t = ereg_replace("~", $null, $t); if ($m != ""){ $sql .= "INSERT INTO tbl_msg(dari,ke,msg,status)"; $sql .= "VALUES ('$n','$t','$m','0')"; $result = mysql_query($sql); } } if ($c=="p"){ $pisah = "_"; $batas = " : "; if ($r == "person"){ $sql_tm = "SELECT * FROM tbl_msg"; $sql_tm .= "WHERE dari='$a'"; $sql_tm .= "AND ke='$n' AND status = '0'"; $result = mysql_query($sql_tm); if (mysql_num_rows($result) &gt; 0){ while ($data = mysql_fetch_array($result)){ $msg = $data["msg"]; $dari = $data["dari"]; echo "$dari$batas$msg$pisah"; } } $sql_rd = "UPDATE tbl_msg set status = 1"; $sql_rd .= "WHERE dari = '$a' AND ke = '$n'"; $result_rd = mysql_query($sql_rd); } else if ($r == "room"){ $sql_rm = "SELECT * FROM tbl_room"; $sql_rm .= "WHERE nama='$a'"; $result = mysql_query($sql_rm); if (mysql_num_rows($result) &gt; 0){ while ($data = mysql_fetch_array($result)){ $idroom = $data["id"]; } } $sql_rm = "SELECT * FROM tbl_room_user"; $sql_rm .= "WHERE id_room='$idroom'"; $result = mysql_query($sql_rm); if (mysql_num_rows($result) &gt; 0){ $i=1; while ($data = mysql_fetch_array($result)){ $from[$i] = $data["id_user"]; $i++; } } for ($i=1;$i &lt;=count($from);$i++){ $sql_rm = "SELECT * FROM tbl_user"; $sql_rm .= "WHERE id='$from[$i]'"; $result = mysql_query($sql_rm); if (mysql_num_rows($result) &gt; 0){ while ($data = mysql_fetch_array($result)){ $name[$i] = $data["nick"]; } } } for ($i=1;$i&lt;=count($name);$i++){ $sql_tm = "SELECT * FROM tbl_msg"; $sql_tm .= "WHERE dari='$name[$i]'"; $sql_tm .= "AND ke= '$n' AND status = '0'"; $result = mysql_query($sql_tm); if (mysql_num_rows($result) &gt; 0){ while ($data = mysql_fetch_array($result)){ $msg = $data["msg"]; $dari = $data["dari"]; echo "$dari$batas$msg$pisah"; } } $sql_rd = "UPDATE tbl_msg set status = 1"; $sql_rd .= "WHERE dari = '$name[$i]' AND ke ='$n'"; $result_rd = mysql_query($sql_rd); } } } ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USNickT
    1. USRizaIsUp
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POneed help unexpected $end in php
      1. USRizaIsUp
      1. VTFavorite
    2. VO
      singulars
      1. POneed help unexpected $end in php
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POneed help unexpected $end in php
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COI expect there's a missing `}` at the end. Alas, because there's no indentation at all, I have no idea which one it might be, and I'm not looking through 300 lines of code to try and find it.
      singulars
      1. POneed help unexpected $end in php
      1. USandrewsi
    2. COwhich is the line number `304`..?
      singulars
      1. POneed help unexpected $end in php
      1. USDipesh Parmar
    3. COIt almost certainly means that you're missing a closing `}` in your code: a syntax highlighting editor or good indentation should indicate where
      singulars
      1. POneed help unexpected $end in php
      1. USMark Baker
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload