Postingan lainnya
kenapa database tidak masuk dalam program?
Assalamualaikum teman teman sekolah koding, saya ada problem input database, kenapa ketika saya sudah inputkan datanya tetapi data tersebut tidak masuk ke database? mohon bantuannya
koneksi.php [<?php $hostName = "localhost"; $userName = "root"; $passWord = ""; $database = "skripsi";
$connect = mysqli_connect($hostName,$userName,$passWord) or die('Connection Failed'); $select = mysqli_select_db($connect,$database) or die('Database Failed'); ?>](https://link.com)
index.php [<!DOCTYPE html> <html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Survey Kepuasan Pelanggan</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/blog-post.css" rel="stylesheet">
</head>
<body background="">
<!-- Navigation -->
<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
<div class="container">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">E-SURVEY</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav navbar-right">
<li><a href="#login" data-toggle="modal"><button class="btn btn-primary btn-sm"><span class="glyphicon glyphicon-log-in"></span> Login</button></a></li>
</ul>
<ul class="nav navbar-nav">
<li class="active"><a href="#survey" data-toggle="tab">Survey</a></li>
</ul>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container -->
</nav>
<div class="container">
<div class="panel panel-default" >
<div class="panel-body" style="background-color:#e6e6e6;">
<div class="col-lg-12">
<img class="img-responsive" src="./images/bannersurvey.jpg" alt="" style="height:300px;width:1290px">
<hr>
</div>
<div class="col-lg-12">
<p align="center" style="background-color:black; color:white;" > <font size="5">SURVEY KEPUASAN PELANGGAN</font></p>
</div>
<div class="row">
<div class="panel-body">
<form method='POST' action='aksi_kuosioner.php' onSubmit=\"return validasisurvey(this)\" >
<script language="javascript">
function validasisurvey(form){
if (form.companyName.value == ""){
alert("Anda belum mengisikan nama Anda.");
form.companyName.focus();
return (false);
}
if (form.companyAddress1.value == ""){
alert("Anda belum mengisikan alamat Anda.");
form.companyAddress1.focus();
return (false);
}
}
</script>
<table class="table" >
<tr >
<td>
<div class="form-horizontal" style="margin-top:20px;background-color:#fff;padding-top:20px;padding-bottom:20px;">
<div class="page-header" style="margin-left:30px;">
<h3>Informasi Pelanggan</h3>
</div>
<div class="form-group">
<label for="nama_pelanggan" class="control-label col-sm-2">Nama Pelanggan</label>
<div class="col-sm-3">
<div class="input-group">
<div class="input-group-addon">
<span class="glyphicon glyphicon-user"></span>
</div>
<input type="text" id="nama_pelanggan" class="form-control" name="companyName" placeholder="Nama Pelanggan">
</div>
</div>
</div>
<div class="form-group">
<label for="alamat_pelanggan" class="control-label col-sm-2">Alamat</label>
<div class="col-sm-3">
<div class="input-group">
<div class="input-group-addon">
<span class="glyphicon glyphicon-bookmark"></span>
</div>
<input type="text" id="alamat_pelanggan" class="form-control" name="companyAddress1" placeholder="Alamat">
</div>
</div>
</div>
<div class="form-group">
<label for="produk" class="control-label col-sm-2">Produk</label>
<div class="col-sm-3">
<div class="input-group">
<div class="input-group-addon">
<span class="glyphicon glyphicon-tags"></span>
</div>
<select name="companyProduct" id="produk" class="form-control">
<option value="Kartu Halo">Kartu Halo</option>
<option value="Kartu AS">Kartu AS</option>
<option value="Kartu Simpati">Kartu Simpati</option>
</select>
</div>
</div>
</div>
<div class="form-group">
<label for="hp" class="control-label col-sm-2">Telepon</label>
<div class="col-sm-3">
<div class="input-group">
<div class="input-group-addon">
<span class="glyphicon glyphicon-phone"></span>
</div>
<input type="text" id="hp" class="form-control" name="companyHp" placeholder="No Handphone">
</div>
</div>
</div>
<div class="form-group">
<label for="tgl" class="control-label col-sm-2">Tanggal</label>
<div class="col-sm-3">
<div class="input-group">
<div class="input-group-addon">
<span class="glyphicon glyphicon-calender"></span>
</div>
<?php
include "fungsi/fungsi_indotgl.php";
$tanggal = date('Y-m-d');
$tglFinal = tgl_indo($tanggal);
?>
<input type="text" id="tgl" class="form-control" disabled="" name="companyName" value="<?php echo $tglFinal; ?>">
</div>
</div>
</div>
</div>
</td>
</tr>
<tr>
<td width="97%" valign="top" align="center" colspan="5" style="border-style: none; border-width: medium">
<font face="Arial" size="1"><b>Mohon kesediaan Anda untuk memberikan
penilaian dan masukan kepada Toko Sparepart dan Bengkel Hing DW Motor Caruban, dimana hal ini sangat bermanfaat
untuk meningkatkan kualitas layanan kami.<br>
</b><i>Silahkan diisi dengan mengklik option radio
serta keterangan sesuai dengan penilaian Anda
pada kolom yang telah disediakan</i></font>
</td>
</tr>
<tr>
<td colspan="9">
<table class="table table-striped table-bordered">
<thead>
<th width='3%' ><b><font face='Tahoma' size='2'>No</font></b></th>
<th colspan='2'><p align='center'><b><font face='Tahoma' size='2'>DESKRIPSI</font></b></th>
<th colspan="5" bgcolor='#FFFF00'><p align='center'><font face='Tahoma' size='2'>KUALITAS</font></th>
</thead>
<tbody>
<?php
include "koneksi.php";
error_reporting(0);
$no = 1;
$sql = mysql_query("SELECT * FROM tgroup");
while($data = mysql_fetch_array($sql)){
$id = $data[groupId];
echo "<tr valign='top'>
<td><font face='Tahoma' size='2' colspan='1'><b> $no</b></font></td>
<td colspan='2'><font face='Tahoma' size='2'><b>$data[groupName]</b></font></td>
<td height='25' width='8%' bgcolor='#000000'><p align='center'><font face='Tahoma' size='1' color='white'>A<br>(Sangat Baik)</font></td>
<td height='25' width='8%' bgcolor='#000000'><p align='center'><font face='Tahoma' size='1' color='white'>B<br>(Baik)</font></td>
<td height='25' width='8%' bgcolor='#000000'><p align='center'><font face='Tahoma' size='1' color='white'>C<br>(Cukup)</font></td>
<td height='25' width='8%' bgcolor='#000000'><p align='center'><font face='Tahoma' size='1' color='white'>D<br>(Buruk)</font></td>
<td height='25' width='8%' bgcolor='#000000'><p align='center'><font face='Tahoma' size='1' color='white'>E<br>(Sangat Buruk)</font></td>
</tr>";
$hasil = mysql_query("SELECT * FROM tdescription, tgroup WHERE tdescription.groupId = '$id' AND tdescription.groupId = tgroup.groupId ORDER BY tgroup.groupId");
$i = 1;
while ($r = mysql_fetch_array($hasil)){
echo "<tr>
<td colspan='1'></td>
<td colspan='2'><font face='Tahoma' size='2'> $r[description]</font></td>
<td align='center'> <input type='radio' name='asfa$i$data[groupId]' value='A'> </td>
<td align='center'> <input type='radio' name='asfa$i$data[groupId]' value='B'> </td>
<td align='center'> <input type='radio' name='asfa$i$data[groupId]' value='C'> </td>
<td align='center'> <input type='radio' name='asfa$i$data[groupId]' value='D'> </td>
<td align='center'> <input type='radio' name='asfa$i$data[groupId]' value='E'> </td>
</tr>";
$i++;
}
echo "<br>";
$no++;
}
?>
</tbody>
</table>
</td>
</tr>
<tr>
<td colspan="8">
<div class="well">
<h4>Komentar / Saran...</h4>
<div class="form-group">
<textarea name='suggestion' class="form-control" rows="3" placeholder="Tulis Komentar dan Saran..."></textarea>
</div>
</div>
<hr>
</td>
</tr>
<tr>
<td colspan="8"> <center><button type="submit" class="btn btn-primary btn-lg">Submit</button></center> </td>
</tr>
<tr>
<td width="97%" valign="top" align="center" colspan="5" style="border-style: none; border-width: medium">
<center class="well">
<font face="Arial" size="1"><b>Terima Kasih Atas Waktu dan Masukan yang anda berikan,Semua masukan yang anda berikan </b> </i></font>
<font face="Arial" size="1"><b>akan kami terima sebagai sarana bagi kami untuk meningkatkan kulaitas pelayanan kami</b> </i></font>
</center>
</td>
</tr>
</table>
</form>
</div>
</div>
</div>
</div>
</div>
<nav class="navbar navbar-inverse navbar-absolut-bottom" role="navigation">
<div class="container">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<center><font color="white" size="1" >Created By Wahyu Budiman</font></center>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container -->
</nav>
<div class="modal fade" id="login">
<form name="login" action="./adminweb/cek_login.php" method="POST" onSubmit="return validasi(this)" >
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header" bgcolor="black">
<button class="close" data-dismiss="modal">&times;</button>
<div class="modal-title" >
<center><h4>Login Admin</h4></center>
</div>
</div>
<div class="modal-body">
<div class="form-horizontal">
<div class="form-group">
<label for="username" class="col-sm-3 control-label">Username</label>
<div class="col-sm-5">
<div class="input-group">
<div class="input-group-addon">
<span class="glyphicon glyphicon-user"></span>
</div>
<input type="text" class="form-control" name="username" placeholder="Username">
</div>
</div>
</div>
<div class="form-group">
<label for="username" class="col-sm-3 control-label">Password</label>
<div class="col-sm-5">
<div class="input-group">
<div class="input-group-addon">
<span class="glyphicon glyphicon-lock"></span>
</div>
<input type="password" class="form-control" name="password" placeholder="Password">
</div>
</div>
</div>
<div class="form-group">
<label for="" class=" control-label col-sm-3"></label>
<div class="col-sm-1">
<button class="btn btn-primary" type="submit"><span class="glyphicon glyphicon-log-in"></span> Masuk</button>
</div>
</div>
</div>
</div>
<div class="modal-footer">
<center>Copyright &copy; 2023 Toko Sparepart dan Bengkel Hing DW Motor Caruban<br> All rights reserved.</center>
<center>Created by Na.</center>
</div>
</div>
</div>
</form>
</div>
<script src="js/jquery.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="js/bootstrap.min.js"></script>
</body>
</html> ](https://link.com)
aksikuesioner.php [<link href="css/bootstrap.min.css" rel="stylesheet"> <?php error_reporting(0); include "koneksi.php"; include "fungsi/fungsi_indotgl.php"; $companyName = $_POST[companyName]; $companyProduct = $_POST[companyProduct]; $companyAddress = $_POST[companyAddress1]; $companyPhone = $_POST[companyPhone]; $companyFax = $_POST[companyHp]; $companyPF = $companyPhone." / ".$companyFax; $suggestion = $_POST[suggestion]; $agreeCity = $_POST[agreeCity]; $date = date('Y-m-d'); $companyId = date('Ymd his');
$no_hitung = 1; $sql_hitung = mysql_query("SELECT * FROM tgroup"); while($data_hitung = mysql_fetch_array($sql_hitung)){ $id_hitung = $data_hitung[groupId]; $hasil_hitung = mysql_query("SELECT * FROM tdescription, tgroup WHERE tdescription.groupId = '$id_hitung' AND tdescription.groupId = tgroup.groupId ORDER BY tgroup.groupId"); $i_hitung = 1; while ($r_hitung = mysql_fetch_array($hasil_hitung)){ $id_hitung = $data_hitung[groupId]; $asfa_hitung = $_POST['asfa'.$i_hitung.$id_hitung]; if (empty($asfa_hitung)){ echo "<script lang=javascript> window.alert('Anda belum mengisi kuisioner atau ada kuisioner yang belum terisi..!'); history.back(); </script>"; exit; }
$i_hitung++;
}
echo "<br>";
$no_hitung++;
}
if (empty($companyName)){ echo "<script lang=javascript> window.alert('Isi Nama Anda'); history.back(); </script>"; exit; }
elseif (empty($companyAddress)){ echo "<script lang=javascript> window.alert('Isi Alamat Anda'); history.back(); </script>"; exit; }
elseif (empty($companyFax)){ echo "<script lang=javascript> window.alert('Isi No HP Anda'); history.back(); </script>"; exit; }
else{ $no = 1; $sql = mysql_query("SELECT * FROM tgroup"); mysql_query("INSERT INTO tcompany(companyId,companyName,companyAddress,companyPhoneHP,dateSurvey,suggestion,product) VALUES('$companyId','$companyName','$companyAddress','$companyPF','$date','$suggestion','$companyProduct')"); while($data = mysql_fetch_array($sql)){ $id = $data[groupId]; $hasil = mysql_query("SELECT * FROM tdescription, tgroup WHERE tdescription.groupId = '$id' AND tdescription.groupId = tgroup.groupId ORDER BY tgroup.groupId"); $i = 1; while ($r = mysql_fetch_array($hasil)){ $id = $data[groupId]; $asfa = $_POST['asfa'.$i.$id]; // echo "$i $asfa<br>"; if ($asfa == 'A'){ mysql_query("INSERT INTO tanswer (descriptionId,groupId,companyId,jawaban,jawabanA,jawabanB,jawabanC,jawabanD,jawabanE) VALUES('$r[descriptionId]','$r[groupId]','$companyId','$asfa','1','0','0','0','0')"); } elseif($asfa == 'B'){ mysql_query("INSERT INTO tanswer (descriptionId,groupId,companyId,jawaban,jawabanA,jawabanB,jawabanC,jawabanD,jawabanE) VALUES('$r[descriptionId]','$r[groupId]','$companyId','$asfa','0','1','0','0','0')"); } elseif($asfa == 'C'){ mysql_query("INSERT INTO tanswer (descriptionId,groupId,companyId,jawaban,jawabanA,jawabanB,jawabanC,jawabanD,jawabanE) VALUES('$r[descriptionId]','$r[groupId]','$companyId','$asfa','0','0','1','0','0')"); } elseif($asfa == 'D'){ mysql_query("INSERT INTO tanswer (descriptionId,groupId,companyId,jawaban,jawabanA,jawabanB,jawabanC,jawabanD,jawabanE) VALUES('$r[descriptionId]','$r[groupId]','$companyId','$asfa','0','0','0','1','0')"); } else{ mysql_query("INSERT INTO tanswer (descriptionId,groupId,companyId,jawaban,jawabanA,jawabanB,jawabanC,jawabanD,jawabanE) VALUES('$r[descriptionId]','$r[groupId]','$companyId','$asfa','0','0','0','0','0')"); } $i++; } echo "<br>"; $no++; }
echo "<center><font face='Tahoma' size='2'>
Pelanggan yang terhormat,<br><br>
Terima kasih atas waktu yang telah diluangkan untuk melengkapi survey yang kami sediakan. <br>
Pendapat Anda sangat berarti bagi kami untuk meningkatkan pelayanan. <br><br>
Hormat kami, <br><br>
Management<br>
Toko Sparepart dan Bengkel Hing DW Motor Caruban </font><br>
<a href='./index.php'>
<button class='btn btn-lg btn-info'><span class='glyphicon glyphicon-arrow-left'></span> Kembali</button>
</a>
</center>";
}
?>](https://link.com)
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban