Retrieve Full Name From Database

Yii 1.1 General Discussion
1

Hi,

in my table I have id, firstname, lastname rows. but i need to store both first & last name into name field. pls help me.

I written in model like this…

           public function getFullName() {


                             return $this->first_name . ' ' . $this->last_name;


           }
2

It’s perfect! Now you call this so:

$this->fullName

3

from where i need to call this one: $this->fullname

4

Whrere you need name+lastname

5

i need only name. In name field i need to store fisrt & last name.

6

Ok. You could create a "complete_name" field and make an UPDATE with CONCAT sql to make name+surname together.

7

Sorry. i’m not getting. pls tell me how to run in sql

8

Should be:




UPDATE users SET complete_name = CONCAT(name, ' ', surname)
9

it’s working. But, it’s not correct process. When i modified like this and login with facebook or google my application is not working.

10

You should launch this script to normalize your db. Then you should make changes to your code to support name+surname field.

11

hello,

Define variable in model like :

public $full_name;

and then

public function getFullName() {

           $this->full_name=$this->first_name . ' ' . $this->last_name;


                             return $this->full_name;


           }
12

NOw also i’m not getting fullname into my database.

13

Do as,

In your model




public $full_name;

public function afterFind(){

 $this->full_name=$this->first_name.' '.$this->last_name;

return parent::afterFind();

}
14

Not working like this also. pls help me.

15

share your code which you are using for testing