mysql - How to fix this message ?Severity: Notice --> Undefined property: stdClass:: -


enter image description herei trying display table mysql db using codeigniter , angularjs doing wrong? view: list_show_data.php

<?php defined('basepath') or exit('no direct script access allowed'); ?><!doctype html> <html ng-app="app"> <head> <meta charset="utf-8"> <title>list show data</title>  <link rel="stylesheet" src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">  </head> <body>  <div ng-controller="decontroller"> <table class="table table-bordered table-striped table-hover"> <thead> <tr> <th>first name</th> <th>last name</th> <th>email</th> <th>role</th> <th>privileges</th> <th>user name</th> </tr> </thead> <tbody> <tr ng-repeat="n in list_data">     <td>{{n.first name}}</td>     <td>{{n.last name}}</td>     <td>{{n.email}}</td>     <td>{{n.role}}</td>     <td>{{n.privileges}}</td>     <td>{{n.user name}}</td> </tr> </tbody> </table> </div> <script type="text/javascript" href="/public/js/angular.js"> </script> <script type="text/javascript"    src="https://ajax.googleapis.com/ajax/libs/angularjs/1.5.6/angular.min.js">  </script> <script type="text/javascript"> var app = angular.module('app',[]); app.controller('decontroller', function($scope,$http){     $scope.list_data=[];     $http.get("ajax_load_data").success(function(result){         $scope.list_data=result;     }); }); </script> </body> </html>

this controller:maintest.php

<?php defined('basepath') or exit('no direct script access allowed');  class maintest extends ci_controller {  /**  * index page controller.  *  * maps following url  *      http://example.com/index.php/welcome  *  - or -  *      http://example.com/index.php/welcome/index  *  - or -  * since controller set default controller in  * config/routes.php, it's displayed @ http://example.com/  *  * other public methods not prefixed underscore  * map /index.php/welcome/<method_name>  * @see https://codeigniter.com/user_guide/general/urls.html  */ public function list_show_data() {      $this->load->helper('url');     $this->load->view('list_show_data');  }  public function ajax_load_data() {     $this->load->helper('url');     $res = $this->db->get('stlc_users')->result();     $data_arr = array();     $i=0;     foreach($res $r)     {         $data_arr[$i]['first name'] = $r->first  ;         $data_arr[$i]['last name'] = $r->last  ;         $data_arr[$i]['email'] = $r->email;         $data_arr[$i]['role'] = $r->role;         $data_arr[$i]['privileges'] = $r->privileges;         $data_arr[$i]['user name'] = $r->user  ;         $i++;     }     echo json_encode($data_arr); }

}

this error i'm getting:

severity: notice --> undefined property: stdclass::$first c:\xampp\htdocs\stlc\application\controllers\maintest.php 38 error - 2016-09-22 16:31:19 --> severity: notice --> undefined property: stdclass::$last c:\xampp\htdocs\stlc\application\controllers\maintest.php 39 error - 2016-09-22 16:31:19 --> severity: notice --> undefined property: stdclass::$user c:\xampp\htdocs\stlc\application\controllers\maintest.php 43

this error message means $r object, represents row db table stlc_users, not have these 2 properties: last , user. reason there no columns these names in db table.


-

Comments

Post a Comment

Popular posts from this blog

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more