Please help undefined variabel: sql

<?php
//program untuk menampilkan data mahasiswa
session_start();
include "Inc_db.php";

//baca dari tabel student
	// $sql= "SELECT student_nim, student_name, student_program FROM tb_student";
	// $result=mysql_query($sql);
	//x$totalrow=mysql_num_rows($result);

?>
<html>
<head>
	<title>Mahasiswa</title>
</head>
<body>
	<form action="Student.php" name="frm_search" method="post" method="#">
		<table width="350" border="0" align="center" cellpadding="0">
			<td height="25" colspan="3">
				<strong>Searching Data</strong>
			</td>
			<tr><td>NIM</td>
				<td><input type="text" name="frm_nim"></td>
			<tr><td>Nama</td>
				<td><input type="text" name="frm_name"></td>
			<tr><td>Prodi</td>
				<td>
					<select name="frm_prodi">
						<option value="">--Pilih Semua--</option>
						<option value="MI">Manajemen Informatika</option>
						<option value="TI">Teknik Informatika</option>
						<option value="SI">Sistem Informasi</option>
					</select>
				</td>
			</tr>
			<tr>
				<td><input type="radio" name="logic" value="AND" checked>AND</td>
				<td><input type="radio" name="logic" value="OR">OR</td>
			</tr>
			<td></td>
			<td><input type="submit" name="submit" id="Submit" value="Search"></td>
			</tr>
			</tr>
		</table>
	</form>
<?php
	if(!isset($_POST['frm_nim']) && !isset($_POST['frm_name']) && !isset($_POST['frm_prodi']) && !isset($_POST['logic'])) {
		$sql="SELECT student_nim, student_name, student_program FROM tb_student";
	} else 
			$logic=$_POST['logic'];
		if (empty($_POST['frm_nim']) && empty($_POST['frm_name']) && empty($_POST['frm_prodi'])) {
			$sql="SELECT student_nim, student_name, student_program FROM tb_student";
		} else 
		if (!empty($_POST['frm_nim']) && empty($_POST['frm_name']) && empty($_POST['frm_prodi'])) {
			$sql="SELECT student_nim, student_name, student_program FROM tb_student WHERE student_nim='".$_POST['frm_nim']."'";
		} else
		if (!empty($_POST['frm_nim']) && !empty($_POST['frm_name']) && empty($_POST['frm_prodi'])) {
			$sql="SELECT student_nim, student_name, student_program FROM tb_student WHERE student_nim='".$_POST['frm_nim']."' $logic student_name='".$_POST['frm_name']."'";
		} else 
		if (!empty($_POST['frm_nim']) && !empty($_POST['frm_name']) && empty($_POST['frm_prodi'])) {
			$sql="SELECT student_nim, student_name, student_program FROM tb_student WHERE student_nim='".$_POST['frm_nim']."' $logic student_name='".$_POST['frm_name']."' $logic student_program='".$_POST['frm_prodi']."'";
		} else
		if (!empty($_POST['frm_nim']) && !empty($_POST['frm_name']) && empty($_POST['frm_prodi'])) {
			$sql="SELECT student_nim, student_name, student_program FROM tb_student WHERE student_program='".$_POST['frm_prodi']."'";
		}else
		if (!empty($_POST['frm_nim']) && !empty($_POST['frm_name']) && empty($_POST['frm_prodi']))  {
			$sql="SELECT student_nim, student_name, student_program FROM tb_student WHERE student_name='".$_POST['frm_name']."'";
		}else
		if (!empty($_POST['frm_nim']) && !empty($_POST['frm_name']) && empty($_POST['frm_prodi']))  {
			$sql="SELECT student_nim, student_name, student_program FROM tb_student WHERE student_name='".$_POST['frm_name']."' $logic student_program='".$_POST['frm_prodi']."'";
		}else
		if (!empty($_POST['frm_nim']) && !empty($_POST['frm_name']) && empty($_POST['frm_prodi'])) {
			$sql="SELECT student_nim, student_name, student_program FROM tb_student WHERE student_nim='".$_POST['frm_nim']."' $logic student_name='".$_POST['frm_name']."'";
		} else
		if (!empty($_POST['frm_nim']) && !empty($_POST['frm_name']) && empty($_POST['frm_prodi'])) {
			$sql="SELECT student_nim, student_name, student_program FROM tb_student WHERE student_nim='".$_POST['frm_nim']."' $logic student_program='".$_POST['frm_prodi']."'";
		}

	$result= mysql_query($sql);
	$baris="1";
	$var_nim="";
	$var_name="";
	$var_program="";
	//eksekusi query
	echo "<center>";
	//hitung jumlah record
	$totalRow= mysql_num_rows($result);
?>


    <h2 align="center">MAHASISWA</h2>
    <table border="1" width="800" border="0" align="center" cellpadding="0">
    <td>NIM</td><td>Nama</td><td>Prodi</td><td>Aksi</td>
    </tr>
    </html>
<?php
if($totalRow==0){
?>
	<tr><td colspan="4">Data belum tersedia</td></tr>
<?php
}
	else {
	while ($data=mysql_fetch_array($result)) {
		$nim= $data['student_nim'];
		$name= $data['student_name'];
		$program= $data['student_program'];
	
		?>
		<tr>
			<td><?php echo $nim ?></td>
			<td><?php echo $name ?></td>
			<td><?php echo $program ?></td>
		<td><a href="Student_edit.php">Edit</a>
			<a href="Student_delete.php">Hapus</a></br>
			</tr>
		<?php 
	} //-while
}
//}
?>
		</table>
		<br>
		<center>Jumlah Data : <?php echo $totalRow;?></center>
		<form action="Student_insert.php" method="POST">
		<tr>
			<br>
			<td><input type="submit" value="Tambah Data"> </td>
		</br>
		</tr>
	</form>
	<form action="Student.php" method="POST">
		<tr>
			<br>
			<td><input type="submit" value="Refresh"> </td>
		</br>
		</tr>
	</form>
	</body>
</html>
1 Like

I cleaned up your code.
You need to use triple backticks to post code to the forum.
See this post for details.

1 Like