Home / Questions

Questions[laravel-5]

Martin Hope
pxs
Asked: 2020-11-01 13:38:22 +0800 CST
  • 3

I am using laravel and I do the following query:

$cantidadDeposito  = DB::select('SELECT SUM(cantidad) FROM `finanzas` WHERE miembro = ?', [$idNombre]);
print_r ($cantidadDeposito);

Which gives me as a result:

stdClass Object ( [SUM(cantidad)] => 750 )

how can i just read the number?

Thanks.

laravel-5
Martin Hope
albertolg89
Asked: 2020-04-18 12:27:48 +0800 CST
  • 3

I'm trying to install npm to use vue.js in my laravel project but I get this error when I run the command npm install:

npm ERR! code ETIMEDOUT
npm ERR! errno ETIMEDOUT
npm ERR! network request to https://registry.npmjs.org/lodash failed, reason: connect ETIMEDOUT 151.101.4.162:443
npm ERR! network This is a problem related to network connectivity.
npm ERR! network In most cases you are behind a proxy or have bad network settings.
npm ERR! network
npm ERR! network If you are behind a proxy, please make sure that the
npm ERR! network 'proxy' config is set properly.  See: 'npm help config'

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\alberto89\AppData\Roaming\npm-cache\_logs\2018-04-17T20_25_48_205Z-debug.log

I am using node version: v9.11.1and npm version: 5.6.0. Dear colleagues, it can happen.

laravel-5
Martin Hope
Juan Pablo B
Asked: 2020-11-04 18:42:03 +0800 CST
  • 4

I have 3 tables: Draw, player and round, and in turn a common table for all three having as attributes: id, id_draw, id_player, id_round.

What I don't know is how to build this type of relationships and how to insert data. Since in a many-to-many relationship with two tables it would be: draw->player()->attach(...);

With this type of relationship of 3 tables, I don't know how to insert data and build the belongsToMany relationship.

Relations:

enter image description here

The ternary relationship is given by draw - PlayerATP - Round being the resulting table Matches

laravel-5
Martin Hope
Juan Pablo B
Asked: 2020-11-04 04:53:00 +0800 CST
  • 4

I have the following URL: domain.com/user/3/edit.

I would like to know if it is recommended that the user ID appears in the URL, or would a URL be better, such as: domain.com/user/edit.

If the last option is better, how could it be done? modifying Route Route::get to Route::post?

laravel-5
Martin Hope
Cidius
Asked: 2020-10-28 04:55:43 +0800 CST
  • 4

I am also looking for the best way to do this depending on my example that I am going to detail.

Basically what my controller does is bring the selected category name (from a navbar), and through a scope, I bring the category as an object. Then through the 1:M relationship I bring all the articles of that category. And well, it ends up showing

My issue is that I order them by id in ascending order. And being an article, it shows me the oldest first. What I would need would be to order them in descending order so that it shows me the newest ones first

public function searchCategoria($nombre){

    $categoria = Categoria::searchCategoria($nombre)->first();
    $articulos = $categoria->articulos()->paginate(5);

    $articulos->each(function($articulos){
        $articulos->categoria;
        $articulos->imagen;
    });
    dd($articulos);
    return view('front/index')->with("articulos",$articulos);
}

This is the result of that dd of $articles

LengthAwarePaginator {#249 ▼
#total: 1
#lastPage: 1
#items: Collection {#250 ▼
#items: array:1 [▼
  0 => Articulo {#252 ▶}
]
}
#perPage: 5
#currentPage: 1
#path: "http://emap.net/categorias/Noticias"
#query: []
#fragment: null
#pageName: "page"
}

In my little experience in PHP and more in Laravel, I haven't used any ordering method yet. But I am interested to know if there is a better solution, by orderBy in the relation inside the model or something like that. Because at least in Java sort is always the last resort.

The other one that occurred to me basically is to fetch the category, get its id and search for all the articles with a where and an orderBy. I would not be making use of the relationship, it would be more practical but I don't know if it is the most correct

laravel-5