Currently I have 2 tables, the first table shows a count of statuses, refno. and agent_id(person in charge of the refno.) and the second table has an id and agent_name. So to refer a particular agent next to the refno. in table 1, you can reference it via the id of the agent table.
Let’s say I want to get all rows in a text column that contain both of three words (word1, word2, word3)
i am trying to display data using 2 tables in codeigniter, i have a products table with some products and another table with the id of the products, i did the following in controller:
Currently I’m trying to retrieve all the entries from my data that are within a particular timeframe. To do this I have a method in my model class with the following statement:
Currently I’m using CodeIgniters MVC framework to fetch my records between a particular time period. I have done the same filtering for a dropdown and achieved the result, but I cant figure out how to do the same with a date picker. The following is my View model:
I’m new to PHP/CodeIgniter and am making a table that retrieves the count of values from Mysql within a particular timeframe.
Currently I’m using Mysql and CodeIgniter to fetch my entries from my database in a particular timeframe. Each entry has a status in the database of either D,N,Y. Now to display this data I have a different statement for each of the statuses which I want to group into 1 statement. Model Class: public function … Read more
i have a codeigniter shopping cart website, where user can add multiple products in cart and then checkout, when the user clicks the confirm button in checkout the user details and product details should be added to database, i did the following code:
Currently I’m using CodeIgniter to retrieve my data in a particular timeframe. All these entries have a status. I am trying to get a count of all the data that are present in the particular time frame. Currently this is my model class where I have the following entry to return all the entries in a particular date range: