Good day mga ka programmers !!!
bali nasa part na po ako nang reservation kaso i encounter this error na Warning: Undefined array key....
nag tatary po kasi ako na kunin yung mga data sa kabilang table and i mange to get the username(usern) pero yung first name at last name diko po makuha...
eto po mga errors ko:
eto po yung code ko sa reservation (reservation.php).
P.S. salamat po sa mga nag tuturo sa akin at specially kay vhin le maraming salamat po master
bali nasa part na po ako nang reservation kaso i encounter this error na Warning: Undefined array key....
nag tatary po kasi ako na kunin yung mga data sa kabilang table and i mange to get the username(usern) pero yung first name at last name diko po makuha...
eto po mga errors ko:
Warning: Undefined array key "f_name" in C:\xampp\htdocs\obs\reservation.php on line 30
Warning: Undefined array key "l_name" in C:\xampp\htdocs\obs\reservation.php on line 31
eto po yung code ko sa reservation (reservation.php).
Code:
<?php
session_start();
require('connection.php');
?>
<!DOCTYPE html>
<html>
<link type="text/css" rel="stylesheet" href="ccs/index.css" />
<head>
<body bgcolor="lightgray">
<meta charset="utf-8">
<title>OBS Reservation</title>
<link type="text/css" rel="stylesheet" href="" />
<link type="text/css" rel="stylesheet" href="" />
</head>
<body>
<?php date_default_timezone_set('Asia/Manila');
?>
<?php
// If form submitted, insert values into the database.
if (isset($_REQUEST['Reservation_Date'])){
$Date_And_Time_Created = date("y-m-d h:i:s");
$usern = $_SESSION['usern'];
$f_name = $_SESSION['f_name'];
$l_name = $_SESSION['l_name'];
$Reservation_Date = stripslashes($_REQUEST['Reservation_Date']);
//escapes special characters in a string
$Reservation_Date = mysqli_real_escape_string($con,$Reservation_Date);
$Service = stripslashes($_REQUEST['Service']);
$Service = mysqli_real_escape_string($con,$Service);
$query = "INSERT INTO `reservation_log` (usern,f_name,l_name,Reservation_Date, Service,Date_And_Time_Created) VALUES ('$usern','$f_name','$l_name','$Reservation_Date','$Service','$Date_And_Time_Created')";
$result = mysqli_query($con,$query);
if($result){
echo "<div class='form'>
<h3>You Booked an apointment .</h3>
<br/>Click here to <a href='index.php'>go back.</a></div>";
}else {
echo "test: " . $query;
}
}else{
?>
<form action="#" style="border:0px solid #0000">
<div class="wrap">
<nav>
<div class="logo"><img src="img/logo.png" height="120" width="120"></div>
<ul>
<li><a href="index.php">HOME</a></li>
<li><a href="reservation.php">BOOK AN APPOINTMENT</a></li>
<li><a href="logout.php">Log Out</a></li>
</div>
<div id="booking" class="section">
<div class="section-center">
<div class="container">
<div class="row">
<div class="booking-form">
<div class="form-header">
<h1>Make your reservation</h1>
</div>
<form>
<div class="row">
<center>
<div class="col-md-6">
<div class="form-group">
<input class="form-control" type="date" name="Reservation_Date" placeholder="Date" required />
<span class="form-label">Date</span>
</div>
</div>
</div>
<div class="row">
<center>
<div class="col-md-4">
<div class="form-group">
<select class="form-control" name="Service" id="Service">
<option disabled selected>Services</option>
<option value="Cedula">Cedula</option>
<option value="Barangay Clearance">Barangay Clearance</option>
<option value="Barangay I.D.">Barangay I.D.</option>
<option value="Barangay Permit">Barangay Permit</option>
<option value="Barangay Certificate">Barangay Certificate</option>
<option value="Barangay Business Permit">Barangay Business Permit</option>
</select>
</div>
</div>
</center>
</div>
<div class="form-btn">
<center>
<a class="button" href="index.php">Cancel</a>
<button type="submit" class="button">Book</button>
</center>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</form>
<?php } ?>
</body>
</html>
P.S. salamat po sa mga nag tuturo sa akin at specially kay vhin le maraming salamat po master
Attachments
-
You do not have permission to view the full content of this post. Log in or register now.