I have a database with the EAV Entity-attribute-value model, if there is the same data how do I only display the same data once? for example i have table user
id user_id name user_value_name user_value
1 2 vandy useraddress new york
3 2 vandy userscore_tesA 90
4 2 vandy userscore_tesB 30
5 3 ahmad useraddress japan
6 3 ahmad userscore_tesA 80
7 3 ahmad userscore_tesB 70
How do I get my name to be displayed only once? here I will use jquery select2 to display the data
$('#name').select2({
placeholder: "Choose User...",
ajax: {
url: "",
dataType: "json",
delay: 250,
processResults: function(data) {
return {
results: $.map(data, function(obj) {
return {
"id": obj.user_id,
"text": obj.name,
};
})
};
},
}
});
in my controller, I only take data from the database and json's return response
$user = DB::table(users)->get();
return response()->json($user);
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire