Aşağıdaki kodlara yeni kayıt için ayrıca dosya ekleme bölümü ile pdf dosya uploadını da gerçekleştirmek istiyorum (Aynı sayfada).
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>