php - Date field's rows are not shown in the grocery crud table -


i new grocery crud. impressed how time saver library , want thank great developers worked on project.

i have small problem showing date field in table. when press edit button , it's shown in edit , view pages. doesn't appear in table.

even if create record myself add record button, it's saved not shown in table. have checked many things default format of date in library. 

$config['grocery_crud_date_format'] = 'sql-date';

i tried different web browsers

this table , how update date , save db:

$datestring = "%y-%m-%d"; $time = time();   $data = array(                 'attendence_date_daily' => mdate($datestring, $time),                 'check_in_time' => null,                 'check_out_time' => null,                 'attendence_status' => null,                 'employee_comment' =>null,                 'deducted_today' => 0,                 'user_id' => $row->id                 );

this how created table

public  function edit_daily_record()                     {                               $crud = new grocery_crud();                                         $crud->columns('daily_record_id','attendance_date_daily','check_in_time','check_out_time','attendence_status','employee_comment','deducted_today','user_id');                                        $crud->set_table('daily_attendence_record');                                        $crud->display_as('attendance_date_daily','date')                                                  ->display_as('user_id','employee');                                        $crud->set_subject('daily record');                                        $crud->set_relation('user_id','users','username');                                        $output = $crud->render();                             $this->_example_output($output);                     }

where 'attendance_date_daily' of type date in mysql db . fields shown correctly except date

'daily_record_id' auto increment pk 'user_id' fk

can please me problem? image 1

image 1

image 2

image 2

i solved of mr. paul savostin 1 of advanced members in grocery crud advance members.

the issue simple typo. name of filed in database different controller 1 letter.

this shows how can letter change whole code!


Comments

Post a Comment

Popular posts from this blog

searchKeyword not working in AngularJS filter -

i writing app using angularjs on front end. want search through table word/field; 1 search box everything. according article here: http://hello-angularjs.appspot.com/searchtable can use filter: searchkeyword this. this code, , not working expected. <label>search: <input ng-model="searchkeyword"></label> <table ng-repeat="post in posts | orderby: sort | filter: searchkeyword"> <tr> <td> {{index(post)}} </td> <td> {{post.title}} </td> <td> {{post.author}} </td> <td> {{post.content}} </td> <td> {{post.date | date: "d/m/yyyy"}} </td> </tr> </table> what should do? thank you try this: controller $scope.posts = [ {title:'title one', author:'author one', content: 'content one'}, {title:'title two', author:'author two', content: 'cont...
Read more

sequelize.js - Sequelize: sort by enum cases -

i have model ( article ) field (the name type ) of type enum('source', 'translated') , return 1 article ordered type field. source articles should returned before translated articles. like: article.findone(order: [ { type: [ 'source', 'translated' ] } ]); unfortunately there appears no built-in solution sorting enums. instead have sort by case , couldn't find documentation on how sequelize. what conventional approach here? sorting case hard in sequelize, sort field (the second answer in linked post) should possible: order: sequelize.fn('field', sequelize.col('type'), 'source', 'translated') it's supported mysql far know though
Read more

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more