Daha sonra uploadı yapılan dosyanın kullanıcıyı görüntülerken de görüntülenebilmesi için önerisi olan var mı? Mysql veriyolu atamam mı gerekiyor?
<?php
//include files
include("../includes/sessions.php");
include("../includes/config.php");
$page = $_SERVER['PHP_SELF'];
$clientid = $_GET['clientid'];
//get site title
$sql="SELECT * FROM options WHERE name = 'options'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$sitename = $row['sitename'];
$sitetitle = $row['sitetitle'];
$currency = $row['currency'];
}
}
?>
<!DOCTYPE html>
<html lang="tr">
<head>
<title><?php echo $sitetitle; ?></title>
<!-- META SECTION -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="shortcut icon" href="../img/favicon.png" type="image/x-icon">
<link rel="icon" href="../img/favicon.png" type="image/x-icon">
<!-- END META SECTION -->
<!-- CSS INCLUDE -->
<link rel="stylesheet" href="../css/styles.css">
<!-- EOF CSS INCLUDE -->
</head>
<body>
<!-- APP WRAPPER -->
<div class="app">
<!-- START APP CONTAINER -->
<div class="app-container">
<!-- START SIDEBAR -->
<?php
include_once("../includes/sidebar.php");
?>
<!-- END SIDEBAR -->
<!-- START APP CONTENT -->
<div class="app-content app-sidebar-left">
<!-- START APP HEADER -->
<?php
include_once("../includes/header.php");
?>
<!-- END APP HEADER -->
<!-- START PAGE CONTAINER -->
<div class="container">
<div class="row">
<div class="col-md-12">
<div class="block block-condensed">
<!-- START HEADING -->
<div class="app-heading app-heading-small">
<div class="title">
<h5>Poliçe Ekle</h5>
<p>Bilgi Ekleme</p>
</div>
<div class="heading-elements">
<a href="../clients" class="btn btn-default btn-icon-fixed"><span class="icon-users"></span> Müşterileri Görüntüle</a>
<a href="../addclient" class="btn btn-default btn-icon-fixed"><span class="icon-user-plus"></span> Müşteri Ekle</a>
</div>
</div>
<!-- END HEADING -->
<div class="block-content">
<?php
if(isset($_POST['submit'])) {
$npolicyname = $_POST['policyname'];
$npolicynumber = $_POST['policynumber'];
$nplaka = $_POST['plaka'];
$npvalue = $_POST['pvalue'];
$odeme = $_POST['odeme'];
$nreceived = $_POST['received'];
$var = $_POST['startdate'];
$date = str_replace('/', '-', $var);
$nstartdate = date('Y-m-d', strtotime($date));
$var = $_POST['expirydate'];
$date = str_replace('/', '-', $var);
$nexpirydate = date('Y-m-d', strtotime($date));
$nspecialcomments = mysqli_real_escape_string($conn, $_POST['specialcomments']);
$sql = "INSERT INTO policy (agency, clientid, policyname, policynumber, plaka, value, odeme, received, startdate, expirydate, specialcomments) VALUES ('$agencyid','$clientid','$npolicyname','$npolicynumber', '$nplaka','$npvalue','$odeme','$nreceived','$nstartdate','$nexpirydate','$nspecialcomments')";
if($run = mysqli_query($conn,$sql)){
echo '<div class="alert alert-success alert-icon-block alert-dismissible" role="alert">
<div class="alert-icon">
<span class="icon-checkmark-circle"></span>
</div>
<strong>Tebrikler!</strong> Yeni poliçe başarıyla eklendi.
<button type="button" class="close" data-dismiss="alert" aria-label="Kapat"><span class="fa fa-times"></span></button>
</div>';
}else{
echo '<div class="alert alert-danger alert-icon-block alert-dismissible" role="alert">
<div class="alert-icon">
<span class="icon-warning"></span>
</div>
<strong>Olamaz!</strong> Eklenemedi, lütfen tekrar deneyin..
<button type="button" class="close" data-dismiss="alert" aria-label="Kapat"><span class="fa fa-times"></span></button>
</div>';
}
}
?>
<?php
$sql = "SELECT * FROM clients WHERE id='$clientid'";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
$fname= $row['fname'];
}
$conn->close();
?>
<form class="form-horizontal" action="" method="post">
<div class="form-group">
<label class="col-md-4 control-label">Müşteri Adı</label>
<div class="col-md-8">
<?php echo $fname; ?>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label">Poliçe Türü</label>
<div class="col-md-8">
<input type="checkbox" name="policyname" value="Trafik">Trafik<br>
<input type="checkbox" name="policyname" value="Kasko">Kasko<br>
<input type="checkbox" name="policyname" value="Sağlık">Sağlık<br>
<input type="checkbox" name="policyname" value="DASK">DASK<br>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label">Belge Seri No</label>
<div class="col-md-8">
<input type="text" class="form-control" name="policynumber">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label">Plaka</label>
<div class="col-md-8">
<input type="text" class="form-control" name="plaka">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label">Poliçe Değeri (<?php echo $currency; ?>)</label>
<div class="col-md-8">
<input class="form-control" data-validation="number" name="pvalue">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label">Alınan Miktar (<?php echo $currency; ?>)</label>
<div class="col-md-8">
<input class="form-control" data-validation="number" name="received">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label">Ödeme Türü</label>
<div class="col-md-8">
<input type="checkbox" name="odeme" value="Nakit">Nakit<br>
<input type="checkbox" name="odeme" value="Kredi Kartı">Kredi Kartı<br>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label">Başlangıç Tarihi</label>
<div class="col-md-8">
<div class="input-group bs-datepicker">
<input type="text" class="form-control" name="startdate">
<span class="input-group-addon">
<span class="icon-calendar-full"></span>
</span>
</div></div>
</div>
<div class="form-group">
<label class="col-md-4 control-label">Bitiş Tarihi</label>
<div class="col-md-8">
<div class="input-group bs-datepicker">
<input type="text" class="form-control" name="expirydate">
<span class="input-group-addon">
<span class="icon-calendar-full"></span>
</span>
</div></div>
</div>
<div class="form-group">
<label class="col-md-4 control-label">Özel Yorumlar</label>
<div class="col-md-8">
<textarea class="form-control" rows="5" name="specialcomments"></textarea>
</div>
</div>
<div class="form-group text-right">
<div class="col-md-12">
<button type="submit" name="submit" class="btn btn-primary btn-icon-fixed"><span class="icon-floppy-disk"></span> Poliçeyi Kaydet</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<!-- END PAGE CONTAINER -->
</div>
<!-- END APP CONTENT -->
</div>
<!-- END APP CONTAINER -->
<!-- START APP FOOTER -->
<?php
include_once("../includes/footer.php");
?>
<!-- END APP FOOTER -->
<!-- APP OVERLAY -->
<div class="app-overlay"></div>
<!-- END APP OVERLAY -->
</div>
<!-- END APP WRAPPER -->
<!-- START SCRIPTS -->
<script>
var startDate = document.getElementsByName('startdate1')[0];
startDate.onchange = function (e) {
var date = startDate.value;
var newdate = date.split("/").reverse().join("-");
var d = new Date(newdate);
d.setDate(d.getDate()-1);
d.setFullYear(d.getFullYear()+1);
var dd = d.getDate();
var mm = d.getMonth()+1;
var y = d.getFullYear();
var someFormattedDate = dd + '/'+ mm + '/'+ y;
document.getElementById("expiry1").value= someFormattedDate;
};
</script>
<script type="text/javascript" src="../js/vendor/jquery/jquery.min.js"></script>
<script type="text/javascript" src="../js/vendor/jquery/jquery-ui.min.js"></script>
<script type="text/javascript" src="../js/vendor/bootstrap/bootstrap.min.js"></script>
<script type="text/javascript" src="../js/vendor/moment/moment.min.js"></script>
<script type="text/javascript" src="../js/vendor/customscrollbar/jquery.mCustomScrollbar.min.js"></script>
<script type="text/javascript" src="../js/vendor/bootstrap-select/bootstrap-select.js"></script>
<script type="text/javascript" src="../js/vendor/bootstrap-datetimepicker/bootstrap-datetimepicker.js"></script>
<script type="text/javascript" src="../js/vendor/maskedinput/jquery.maskedinput.min.js"></script>
<script type="text/javascript" src="../js/vendor/form-validator/jquery.form-validator.min.js"></script>
<script type="text/javascript" src="../js/vendor/noty/jquery.noty.packaged.js"></script>
<script type="text/javascript" src="../js/vendor/datatables/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="../js/vendor/datatables/dataTables.bootstrap.min.js"></script>
<script type="text/javascript" src="../js/vendor/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript" src="../js/vendor/knob/jquery.knob.min.js"></script>
<script type="text/javascript" src="../js/vendor/jvectormap/jquery-jvectormap.min.js"></script>
<script type="text/javascript" src="../js/vendor/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
<script type="text/javascript" src="../js/vendor/jvectormap/jquery-jvectormap-us-aea-en.js"></script>
<script type="text/javascript" src="../js/vendor/sparkline/jquery.sparkline.min.js"></script>
<script type="text/javascript" src="../js/vendor/morris/raphael.min.js"></script>
<script type="text/javascript" src="../js/vendor/morris/morris.min.js"></script>
<script type="text/javascript" src="../js/vendor/rickshaw/d3.v3.js"></script>
<script type="text/javascript" src="../js/vendor/rickshaw/rickshaw.min.js"></script>
<script type="text/javascript" src="../js/vendor/isotope/isotope.pkgd.min.js"></script>
<script type="text/javascript" src="../js/app.js"></script>
<script type="text/javascript" src="../js/app_plugins.js"></script>
<script type="text/javascript" src="../js/app_demo.js"></script>
<script type="text/javascript">
$.validate({
modules : 'date,file,location',
onValidate: function(){
delayBeforeFire(function(){
app.spy();
},100);
}
});
</script>
<!-- END SCRIPTS -->
<script type="text/javascript" src="../js/app_demo_dashboard.js"></script>
</body>
</html> 