To display data from a table (e.g., patient_category) in a MySQL database using CodeIgniter and PHP, you'll need to follow these steps:
Configure CodeIgniter Database Settings: Make sure your CodeIgniter application is properly configured to connect to your MySQL database. Set the database connection parameters in the config/database.php file.
Create a Model: Create a model to interact with the database. This model will handle querying the patient_category table.
// application/models/Patient_category_model.php class Patient_category_model extends CI_Model { public function __construct() { parent::__construct(); $this->load->database(); } public function getPatientCategories() { $query = $this->db->get('patient_category'); return $query->result(); } }
Create a Controller: Build a controller that will load the model and fetch data from the patient_category table.
// application/controllers/PatientCategoryController.php class PatientCategoryController extends CI_Controller { public function __construct() { parent::__construct(); $this->load->model('Patient_category_model'); } public function displayPatientCategories() { $data['patient_categories'] = $this->Patient_category_model->getPatientCategories(); $this->load->view('patient_categories_view', $data); } }
Create a View: Create a view file to display the fetched data (patient_categories_view.php).
<!-- application/views/patient_categories_view.php --> <!DOCTYPE html> <html> <head> <title>Patient Categories</title> </head> <body> <h1>Patient Categories</h1> <table border="1"> <tr> <th>Category ID</th> <th>Category Name</th> <!-- Add other table headers as needed --> </tr> <?php foreach ($patient_categories as $category) { ?> <tr> <td><?php echo $category->category_id; ?></td> <td><?php echo $category->category_name; ?></td> <!-- Display other table data fields as needed --> </tr> <?php } ?> </table> </body> </html>
Access the Controller Method: Finally, access the displayPatientCategories() method of the PatientCategoryController from your browser.
For example, if your CodeIgniter application is running locally:
http://localhost/yourapp/index.php/PatientCategoryController/displayPatientCategories
Ensure that you've replaced yourapp with the actual name of your CodeIgniter application directory.
This basic setup will fetch data from the patient_category table and display it in a tabular format using a view file in CodeIgniter. Adjust the view file and database query methods according to your table structure and requirements.
I hope this information will be useful for you. If you have any questions please share with me.
Thanks for reading,
Dgi Host.com
Top comments (0)