Working on a CodeIgniter project, I am faced with the task of adding information to a form within my view page called meal_add.php. Below is the form structure:
<div id="content" class="box">
<form action="<?php echo base_url(); ?>index.php/admin_logins/meal2" method="post">
<fieldset>
<legend id="add_employee_legend">
Add Meal Information
</legend>
<div>
<label id= "emp_id_add_label">Employee ID:</label>
<input type="text" name="emp_id" id = "employee_id_add" placeholder="Employee ID" required="1"/>
</div>
<br>
<div>
<label id= "is_guest_add_label">Guests?</label>
<input type="checkbox" name ="is_guest_checkbox" class ="guestcheck" value="1" onchange="valueChanged()"/>
</div>
<br>
<div id = "guestnum" hidden = "true">
<label id= "num_of_guest_add_label">No. of Guests:</label>
<input type="text" name="num_of_guest" id = "num_of_guest_add" placeholder='0'/>
</div>
<div>
<label id= "remarks_add_label">Remarks:</label>
<textarea rows="1" cols="20" style="margin-left: 35px"></textarea>
</div>
<input type="submit" name="submit" id = "meal_info_submit" value="Save Meal Information"/>
<button id = "cancel_button" onclick="location.href='<?php echo base_url(); ?>index.php/admin_logins/meal'">
Cancel
</button>
</fieldset>
</form>
The controller method for adding data is as follows -
function meal2()
{
if($_POST)
{
date_default_timezone_set('Asia/Dacca');
$mdata['emp_id'] = $this->input->post('emp_id');
$mdata['entry_date'] = date('Y-m-d');
$mdata['is_guest'] = $this->input->post('is_guest_checkbox');
$mdata['num_of_guest'] = $this->input->post('num_of_guest');
$mdata['remarks'] = $this->input->post('remarks');
$res = $this->meal_model->insert_meal($mdata);
if($res)
{
$this->session->set_flashdata('message','Meal information added successfully');
redirect("admin_logins/meal");
}
}
else
{
$this->load->view('admin_logins/meal_add');
}
}
And the model method for insertion is -
public function insert_meal($data)
{
return $this->db->insert('meal', $data);
}
In the database, there is a table named employee with fields as shown below:
column | data type
--------------|--------------
id | int PK
emp_id | varchar(15)
emp_name | varchar(50)
emp_mobile_no | varchar(15)
Another table named meal has the following structure:
column | data type
--------------|-------------
id | int PK
emp_id | varchar(15)
entry_date | date
is_guest | int
num_of_guest | int
remarks | text
The objective is to match the entered Employee ID in the form on the meal_add.php page with values from employee.emp_id. If a match is found, data should be saved in the meal table using the corresponding employee.id. If no match is found, show a PHP flash message stating that the ID does not exist on the meal_add.php page. While I understand that a JOIN query is necessary, the text matching part is proving challenging. Any guidance on organizing code and where to implement it would be greatly appreciated.
The database used here is MySQL.
EDIT - 1:
Within the controller method, I have attempted the following -
$temp = $this->input->post('emp_id');
$sql = "SELECT e.id FROM employee AS e WHERE e.emp_id = ?";
$mdata['emp_id'] = $this->db->query($sql, $temp)->emp_id;
if($mdata['emp_id'] == '')
{
$this->session->set_flashdata('message','Employee ID does not exist');
redirect("admin_logins/meal");
}
But regardless of the input provided in $temp, I always receive the flash message and get redirected. Additionally, I tried this -
echo "<pre>";
print_r($mdata);
die();
After which, upon executing echo and print_r(), I encountered the following output -
A PHP Error was encountered
Severity: Notice
Message: Undefined property: CI_DB_mysql_result::$emp_id
Filename: controllers/admin_logins.php
Line Number: 150
Array
(
[emp_id] =>
)