Category : codeigniter

can somebody help, while using IF-ELSE I am getting errors, again and again, I don’t know why? DELIMITER // CREATE PROCEDURE sp_add_project_table(IN project_data varchar(45)) BEGIN SET @total_count = (SELECT count(*) as total_count FROM project_table WHERE created_dt BETWEEN (SELECT DATE_SUB(LAST_DAY(NOW()),INTERVAL DAY(LAST_DAY(NOW()))- 1 DAY) AS ‘FIRST DAY OF CURRENT MONTH’) and (SELECT LAST_day(now())) ORDER BY created_dt); if(@total_count ..

Read more

I was trying to get data from a table. I use select2 multiple select on codeigniter. How to select the data on my model where category = selected values on the option ? here is my select option : <select name="categories[]" id="selectCategory" class="js-example-basic-multiple selectCategory" style="width: 300px;" multiple="multiple"> <option value="">All Categories</option> <?php foreach ($category as $cat) ..

Read more

like i want to fetch user_reference data and post_reference data how can i do that? function flagged(){ $documents = $this->db->collection(‘Flagged Tasks’) ->documents(); $flagged = []; for each ($documents as $document) { if ($document->exists()) { $flagged[$document->id()] = $document->data(); // $flagged[$document->id()] = $document->id(); } } return $flagged; } enter image description here Sourc..

Read more

[Database table picture column image][1] [1]: https://i.stack.imgur.com/U7Dmo.png**strong text** I have uploaded multiple images using single form with image array. Now i want to fetch images one by one so that i can arrange them or use them as single product preview for an e-commerce site. First image as main image and rest are in thumbnail. ..

Read more