---

3. Listing Program Data Siswa <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="Keywords" content="">

<meta name="Description" content=""> <style type="text/css"> .style1 { font-size: 14px; font-style: italic; font-weight: bold; } body,td,th { color: #FFFFFF; font-size: 12px; } .style2 { color: #000000; font-size: x-large; font-weight: bold; } .style3 { color: #0000FF; font-weight: bold; font-size: 16px; } .style5 { color: #FFFFFF; font-weight: bold; } .style6 {color: #FFFFFF} body { background-color: #FFF; background-repeat: repeat-x; } #wrapper #page #page-bgtop #content .post1 .entry form { color: #000; } #wrapper #page #page-bgtop #content .post1 .entry form { font-size: 14px; } #wrapper #page #page-bgtop #content .post1 .entry form { font-weight: bold; }

4. Listing Program Tambah Siswa
{ if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue;}} $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO siswa (nis, nama, kelas, gender, tempat, tgllahir, alamat) VALUES (%s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['nis'], "text"), GetSQLValueString($_POST['nama'], "text"), GetSQLValueString($_POST['kelas'], "text"), GetSQLValueString($_POST['gender'], "text"), GetSQLValueString($_POST['tempat'], "text"), GetSQLValueString($_POST['tgllahir'], "text"), GetSQLValueString($_POST['alamat'], "text")); mysql_select_db($database_dbkoneksi, $dbkoneksi); $Result1 = mysql_query($insertSQL, $dbkoneksi) or die(mysql_error()); } mysql_select_db($database_dbkoneksi, $dbkoneksi); $query_dtsiswa = "SELECT * FROM siswa"; $dtsiswa = mysql_query($query_dtsiswa, $dbkoneksi) or die(mysql_error()); $row_dtsiswa = mysql_fetch_assoc($dtsiswa); $totalRows_dtsiswa = mysql_num_rows($dtsiswa); ?> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="keywords" content="" /> <meta name="description" content="" /> <style type="text/css"> .style1 {

font-size: 14px; font-style: italic; font-weight: bold; } body,td,th { color: #FFFFFF; font-family: Arial, Helvetica, sans-serif; font-size: 12px; } .style2 { color: #000000; font-size: x-large; font-weight: bold; } .style3 { color: #0000FF; font-weight: bold; font-size: 16px; } .style5 { color: #FFFFFF; font-weight: bold; } .style6 {color: #FFFFFF} #wrapper div div h2 strong { color: #000; }

---