How can I get the value of a field from another table on my method? And of course, I have the primary key of its table.
I want to do something in add/edit action like this:
if (is_empty(value_field_from_another_table)) {
…
I have created one application with Codeigniter Grocery Crud with SQLite. It is working fine at localhost. But when I hosted online by CPanel, it shows syntax error following,
A Database Error Occurred
Error Number: HY000/1
near "SHOW": syntax…
We need to use the :
$crud->where('session.active',"1");
in my condition, but when i add the above line it's give me error like :
http://prntscr.com/nltp9i
This is my code :
$crud = new…
before i ask some question i just want to appreciate this is the best CRUD generator for CI/PHP. I'm using this for all of my website.
so my question is, i have some fields in my controller :
$crud->display_as('id', 'No')
->display_as('name',…
I am writing an app using Codeigniter/groceryCRUD.
How can I restrict two users to work on the same field at the same time ?
EDIT
I have tried when two users work simultaneously. The first user can not see modifications made by the second user, but…
The idea is when I add a new row, one of the field (ID) have to has a default value + Value of another field + date.
Example of ID: IDPeter17112017
So, this is the code I have but it doesn't work, or maybe isn't the best way to do…
I have a table created in Mysql with this colums
secretNumber (Primary key & AI)
Name
Date
etc...
My idea is when I'm going to add a new item to this table, automatically generate a "secret number" but must has 3 requirements:
Unique…
public function ajax_disposisi() {
$this->load->helper('tanggal');
$this->jadwal->column_search=array('nomor','tanggal');
$this->jadwal->column_order=array(null,'nomor','tanggal');
$list =…
Hi everyone I got some problem with my text editor in Grocery Crud. In my default text editor I couldn't upload image into the editor so I think I want to change default text editor with bootstrap summernote. But the problem is how to I to do that ?…
Query is not filtering the duplicate rows from two tables in grocery crud, i'm trying to show one list without duplicates and it seems query is being ignored by the controller. what am i doing wrong?
Model
public function delete_duplicaterow() {
…
For example, i have two tables ('intervalosHorarios' and 'entregas' [1_n]) and i want to show 'entregas' list from specific 'intervalosHorarios' id. I tried the following but it didn't work.
Tables
Controller List
public function…
i am trying to use set_field_upload to upload a images in a database field called "photo", the crud is working perfectly for text/dates...etc
But u can't use the file upload
it's not showing as a file button, its only a text input.
no errors in…
I'm trying to check for a valid date in grocery crud (end date should be after start date) but the below code does not work it still saves the invalid date, can anyone help?
$crud->set_rules('cardEnd','End…
I'm Having an issue understanding and using the Grocery crud callback funtion...the documentation isn't clear.
I have 3 tables:
1. Team $crud->fields('TeamID','Name', 'HomeCountry');
2. Player $crud->fields('PlayerID','Fname', 'Sname', Title',…
