$jumlahbapenarikan = mysql_num_rows($query);
//hitung jumlah surat perintah
$sql2 = "select count(*) from sitampan.bcf15 where suratperintahdate between '" . $_POST['tgl_awal'] . "' and '" . $_POST['tgl_akhir'] . "' group by suratperintahno";
$query = mysql_query($sql2) or die('error sql2');
$jumlahsprint = mysql_num_rows($query);
//hitung jumlah pemberitahuan
$sql3 = "SELECT bcf15no,bcf15tgl,suratno,suratdate FROM bcf15 where suratdate between '" . $_POST['tgl_awal'] . "' and '" . $_POST['tgl_akhir'] . "' and pemberitahuan='1' order by bcf15tgl asc ";
$query = mysql_query($sql3) or die('error sql3');
$jumlahpemberitahuan = mysql_num_rows($query);
//hitung jumlah setujubatal
$sql4 = "select bcf15no,SetujuBatalDate,setujubatalno from bcf15 where SetujuBatalDate between '" . $_POST['tgl_awal'] . "' and '" . $_POST['tgl_akhir'] . "'";
$query = mysql_query($sql4) or die('error sql4');
$jumlahsetujubatal = mysql_num_rows($query);
//hitung jumlah bataltarik
$sql5 = "select bcf15no,bataltarik,bataltarikno,bataltarikdate from bcf15 where bataltarikdate between '" . $_POST['tgl_awal'] . "' and '" . $_POST['tgl_akhir'] . "' group by bataltarikno,bataltarikdate order by bataltarikdate ASC";
$query = mysql_query($sql5) or dier('error sql5');
$jumlahbataltarik = mysql_num_rows($query);
} else {
echo '<div class="col-md-11">';
echo '<p class="bg-primary">Pastikan anda menginput melalui formulir dengan benar!</p>';
echo '</div>';
}
?>
<link type="text/css" rel="stylesheet" href="css/bootstrap.css" />
<link type="text/css" rel="stylesheet" href="css/bootstrap.min.css" />
<section class="content">
<div class="col-md-12">
<h3> Management IKU</h3>
<br>
<!-- tempat parameter tanggal-->
<html>
<head>
<title> Problema 24 </title>
</head>
<body>
<?php
$conexion = mysql_connect("localhost", "root", "andrey") or dier("Problema en la conexion");
mysql_select_db("phpfacil", $conexion) or die("Problema en la selecion de la base de datos");
$registro = mysql_query("select * from cursos where nombrecur='{$_REQUEST['nombre']}'", $conexion) or die("Problemas en el select" . mysql_error());
if ($reg = mysql_fetch_array($registro)) {
?>
<form method="post" action="ej_24_1_2.php">
Curso nuevo:
<input type="text" name="cursonuevo" value="<?php
echo $reg["nombrecur"];
?>
">
<br>
<input type="hidden" name="cursoviejo" value="<?php
echo $reg["nombrecur"];
?>
">
<input type="submit" value="Modificar">
</form>
<?php
} else {
echo "No existe ese curso";
}
?>
</body>
</html>
