Databases
StackOverflow2013
Postsdbo
POUndefined index: status
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUndefined index: status
    primarykey
    data
    text
    <p>My PHP code</p> <pre><code>&lt;?php include "conn.php"; if(isset($_POST['submit'])){ $id_guru=htmlentities($_POST['id_guru']); $id_pelajaran=htmlentities($_POST['id_pelajaran']); $id_kelas=htmlentities($_POST['id_kelas']); $query=mysql_query("insert into tbl_jadwal values('','$id_guru','$id_pelajaran','$id_kelas')"); if($query){ ?&gt;&lt;script language="javascript"&gt;document.location.href="?page=jadwal_pengajaran&amp;status=1";&lt;/script&gt;&lt;?php }else{ ?&gt;&lt;script language="javascript"&gt;document.location.href="?page=jadwal_pengajaran&amp;status=2";&lt;/script&gt;&lt;?php } }else{ unset($_POST['submit']); } ?&gt; &lt;!-- start page-heading --&gt;&lt;title&gt;Sistem Informasi SMP YPPI&lt;/title&gt; &lt;div id="page-heading"&gt; &lt;h1&gt;Jadwal Pengajaran&lt;/h1&gt; &lt;/div&gt; &lt;!-- end page-heading --&gt; &lt;table border="0" width="100%" cellpadding="0" cellspacing="0" id="content-table"&gt; &lt;tr&gt; &lt;th rowspan="3" class="sized"&gt;&lt;img src="images/shared/side_shadowleft.jpg" width="20" height="300" alt="" /&gt;&lt;/th&gt; &lt;th class="topleft"&gt;&lt;/th&gt; &lt;td id="tbl-border-top"&gt;&amp;nbsp;&lt;/td&gt; &lt;th class="topright"&gt;&lt;/th&gt; &lt;th rowspan="3" class="sized"&gt;&lt;img src="images/shared/side_shadowright.jpg" width="20" height="300" alt="" /&gt;&lt;/th&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td id="tbl-border-left"&gt;&lt;/td&gt; &lt;td&gt; &lt;!-- start content-table-inner ...................................................................... START --&gt; &lt;div id="content-table-inner"&gt; &lt;?php if(isset($_GET['status']=='1')){ ?&gt; &lt;div id="message-green"&gt; &lt;table border="0" width="100%" cellpadding="0" cellspacing="0"&gt; &lt;tr&gt; &lt;td class="green-left"&gt;Data Tersimpan&lt;/td&gt; &lt;td class="green-right"&gt;&lt;a class="close-green"&gt;&lt;img src="images/table/icon_close_green.gif" alt="" /&gt;&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/div&gt; &lt;?php } if(isset($_GET['status']=='0')){ ?&gt; &lt;div id="message-red"&gt; &lt;table border="0" width="100%" cellpadding="0" cellspacing="0"&gt; &lt;tr&gt; &lt;td class="red-left"&gt;Gagal Menyimpan&lt;/td&gt; &lt;td class="red-right"&gt;&lt;a class="close-red"&gt;&lt;img src="images/table/icon_close_red.gif" alt="" /&gt;&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/div&gt; &lt;?php } ?&gt; &lt;form action="?page=jadwal_pengajaran" method="post"&gt; &lt;table border="0" width="100%" cellpadding="0" cellspacing="0"&gt; &lt;tr valign="top"&gt; &lt;td&gt;&lt;!-- start step-holder --&gt; &lt;!-- end step-holder --&gt; &lt;!-- start id-form --&gt; &lt;table border="0" cellpadding="0" cellspacing="0" id="id-form"&gt; &lt;tr&gt; &lt;th valign="top"&gt;Guru&lt;/th&gt; &lt;td&gt;&lt;select name="id_guru" class="styledselect_form_1"&gt; &lt;?php $guru=mysql_query("select * from data_guru order by nama_guru asc"); while($row1=mysql_fetch_array($guru)){ ?&gt; &lt;option value="&lt;?php echo $row1['id_guru'];?&gt;"&gt;&lt;?php echo $row1['nama_guru'];?&gt; [ &lt;?php echo $row1['nip'];?&gt; ] &lt;option&gt; &lt;?php } ?&gt; &lt;/select&gt; &lt;/td&gt; &lt;td&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th valign="top"&gt;Pelajaran&lt;/th&gt; &lt;td&gt;&lt;select name="id_pelajaran" class="styledselect_form_1"&gt; &lt;?php $pelajaran=mysql_query("select * from setup_pelajaran order by nama_pelajaran asc"); while($row2=mysql_fetch_array($pelajaran)){ ?&gt; &lt;option value="&lt;?php echo $row2['id_pelajaran'];?&gt;"&gt;&lt;?php echo $row2['nama_pelajaran'];?&gt;&lt;/option&gt; &lt;?php } ?&gt; &lt;/select&gt; &lt;/td&gt; &lt;td&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th valign="top"&gt;Kelas&lt;/th&gt; &lt;td&gt;&lt;select name="id_kelas" class="styledselect_form_1"&gt; &lt;?php $kelas=mysql_query("select * from setup_kelas order by nama_kelas asc"); while($row3=mysql_fetch_array($kelas)){ ?&gt; &lt;option value="&lt;?php echo $row3['id_kelas'];?&gt;"&gt;&lt;?php echo $row3['nama_kelas'];?&gt;&lt;/option&gt; &lt;?php } ?&gt; &lt;/select&gt; &lt;/td&gt; &lt;td&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th&gt;&amp;nbsp;&lt;/th&gt; &lt;td valign="top"&gt;&lt;input type="submit" name="submit" class="form-submit" /&gt; &lt;input type="reset" class="form-reset" /&gt; &lt;/td&gt; &lt;td&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;!-- end id-form --&gt; &lt;/td&gt; &lt;td&gt;&lt;!-- start related-activities --&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;img src="images/shared/blank.gif" width="695" height="1" alt="blank" /&gt;&lt;/td&gt; &lt;td&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; &lt;p&gt;&lt;em&gt;*Tidak boleh 1 Kelas, 1 Pelajaran di ajarkan oleh 2 Guru atau lebih&lt;br /&gt;&lt;/em&gt; &lt;/p&gt; &lt;p&gt;&amp;nbsp;&lt;/p&gt; &lt;!-- start product-table ..................................................................................... --&gt; &lt;form id="mainform" action=""&gt; &lt;table border="0" width="71%" cellpadding="0" cellspacing="0" id="product-table"&gt; &lt;tr&gt; &lt;th width="13%" class="table-header-repeat line-left minwidth-1"&gt;&lt;a href=""&gt;Nomor&lt;/a&gt; &lt;/th&gt; &lt;th width="24%" class="table-header-repeat line-left minwidth-1"&gt;&lt;a href=""&gt;Nama Guru&lt;/a&gt;&lt;/th&gt; &lt;th width="26%" class="table-header-repeat line-left minwidth-1"&gt;&lt;a href=""&gt;NIP&lt;/a&gt;&lt;/th&gt; &lt;th width="24%" class="table-header-repeat line-left minwidth-1"&gt;&lt;a href=""&gt;Mata Pelajaran&lt;/a&gt;&lt;/th&gt; &lt;th width="24%" class="table-header-repeat line-left minwidth-1"&gt;&lt;a href=""&gt;Kelas&lt;/a&gt;&lt;/th&gt; &lt;th width="13%" class="table-header-options line-left"&gt;&lt;a href=""&gt;Aksi&lt;/a&gt;&lt;/th&gt; &lt;/tr&gt; &lt;?php $view=mysql_query("select * from tbl_jadwal jadwal, setup_kelas kelas, setup_pelajaran pelajaran, data_guru guru where jadwal.id_kelas=kelas.id_kelas and jadwal.id_pelajaran=pelajaran.id_pelajaran and jadwal.id_guru=guru.id_guru order by id_jadwal asc"); $no=0; while($row=mysql_fetch_array($view)){ ?&gt; &lt;tr&gt; &lt;td&gt;&lt;?php echo $no=$no+1;?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $row['nama_guru'];?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $row['nip'];?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $row['nama_pelajaran'];?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $row['nama_kelas'];?&gt;&lt;/td&gt; &lt;td class="options-width"&gt; &lt;a href="" title="Delete" class="icon-2 info-tooltip"&gt;&lt;/a&gt; &lt;a href="" title="Edit" class="icon-5 info-tooltip"&gt;&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; &lt;?php } ?&gt; &lt;/table&gt; &lt;!-- end product-table................................... --&gt; &lt;/form&gt; &lt;div class="clear"&gt;&lt;/div&gt; &lt;/div&gt; &lt;!-- end content-table-inner ............................................END --&gt; &lt;/td&gt; &lt;td id="tbl-border-right"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th class="sized bottomleft"&gt;&lt;/th&gt; &lt;td id="tbl-border-bottom"&gt;&amp;nbsp;&lt;/td&gt; &lt;th class="sized bottomright"&gt;&lt;/th&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre> <p>Warnings are:</p> <p>Notice: Undefined index: status in <code>C:\xampp\htdocs\tugasakhir\jadwal_pengajaran.php on line 48</code></p> <p>Notice: Undefined index: status in <code>C:\xampp\htdocs\tugasakhir\jadwal_pengajaran.php on line 63</code></p> <p>I have tried to put isset before $get, but there it is, another warning displayed </p> <p>Parse error: <code>syntax error, unexpected '==' (T_IS_EQUAL), expecting ',' or ')' in C:\xampp\htdocs\tugasakhir\jadwal_pengajaran.php on line 48</code></p> <p>Pls help me finding the problem.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USNico David
    1. USNico David
    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
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUndefined index: status
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POUndefined index: status
      1. This table or related slice is empty.
      1. VTClose
    3. VO
      singulars
      1. POUndefined index: status
      1. This table or related slice is empty.
      1. VTClose
    1. COYour form is incomplete in your snippet. Could you post the rest, please?
      singulars
      1. POUndefined index: status
      1. This table or related slice is empty.
    2. COOkay. There you are, I've posted the whole code.
      singulars
      1. POUndefined index: status
      1. USNico David
 

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