davy_yg

Hello,

I want to ask a question about this php config:

$config['base_url'] = "https://".$_SERVER['HTTP_HOST'].str_replace(basename($_SERVER['SCRIPT_NAME']),"",$_SERVER['SCRIPT_NAME']);

I am trying to config the base_url to https:// but it doesn't work, some of the codes still read the base_url as http://

I wonder why? This is CI by the way - but it has the same logic I believe.

I cannot call php artisan

D:\xampp72\htdocs\lekaeshop>php artisan route:list  
Could not open input file: artisan

D:\xampp72\htdocs\lekaeshop>php artisan list Could not open input file: artisan

composer.lock

"name": "laravel/framework",
"version": "v5.4.28"

Hello,

I have a working ecommerce file created with laravel but I cannot check the laravel version of it.

D:\xampp72\htdocs\lekaeshop>laravel --version
Laravel Installer 2.1.0

D:\xampp72\htdocs\lekaeshop>php artisan --version
Could not open input file: artisan

Any clue why?

When clicking the wishlist button I get this error:

(1/1) NotFoundHttpException

I wonder why?

store/index.blade.php

<a href="{{ url('/wishlist/add/'. $product->prod_id ) }}" class="button-wishlist">Wishlist</a>

WishlistsController.php

public function add(Products $product)
    {
    Wishlists::create([
      'prod_id' => $product->prod_id,
      'user_id' => auth()->user()->user_id
    ]);

    flash('Product added to wishlist.');

    return back();
    }

web.php

Route::get('/wishlists/add/{product}', '[email protected]');

I can't understand where page request key comes from since it is not anywhere in the input form?

Hello,

I get this error - Call to a member function appends() on null

on the following codes:

ProductsController.php

    if ($products_with_meta->count() == 0) {
                $products = null;
                return view('admin.products.products', compact('categories'), ['products' => $products->appends(request()->except('page'))]);
            }

How to fix it?

I finally find it, it should be:

 $.get('subcategories/ajax/get', {

Checking through inspect - element -network

That url should be correct

web.php

Route::get('/cpages/subcategories/ajax/get', '[email protected]_ajax');

I already execute it just like the online version or perhaps it has something with the url:

function getParameterByName(name, url) {
        if (!url) url = window.location.href;
        name = name.replace(/[\[\]]/g, "\$&");
        var regex = new RegExp("[?&]" + name + "(=([^&#]*)|&|#|$)"),
        results = regex.exec(url);
        if (!results) return null;
        if (!results[2]) return '';
            return decodeURIComponent(results[2].replace(/\+/g, " "));
    }

What the url should be on local?

It works online.

I don't understand why in local there is no return of the ajax call.

SubCategoriesController.php

public function get_ajax()
    {
        $subcategories = SubCategories::where('cat_id', request('cat_id'))->get();
        return view('admin.products.ajax.subcategories', compact('subcategories'));
        }

admin.products.ajax.subcategories.blade.php

<option value="">Semua Sub-Kategori</option>
@foreach ($subcategories as $subcat)
<option value="{{ $subcat->subcat_id }}" @if($subcat->subcat_id == request('subcat_id')) selected @endif>
    {{ $subcat->subcat_name }}
    </option>
    @endforeach

I wonder where the value of data comes from?

In my localhost the result only shows the option with this message: Loading...

Only on the server I can see the sub categories.

Hello,

I cannot understand this script:

function changeSubcat() {
    $("#subcat_id").html('<option>Loading...</option>');
    $("#subcat_id").prop('disabled', false);
    var val = $("#cat_id").val();
    $.get('/cpages/subcategories/ajax/get', {
        cat_id: val
      })
      .done(function(data) {
        $("#subcat_id").html(data);
        if(getParameterByName('subcat_id') != "") {
          if(subcat_load_first == true) {
            $("#subcat_id").val(getParameterByName('subcat_id'));
            subcat_load_first = false;
          }
        }
      });
 }

What does this means: .prop('disabled', false); ?

and also: $.get('/cpages/subcategories/ajax/get', { cat_id: val })

How about this: .done(function(data) {

Thanks in advance.

Nevermind, I solved it.

        $men_products = Products::with('productMetas')
                    ->whereHas('productMetas', function ($query) {
                        $query->where('prod_meta_type', 1)
                              ->where('value', 1);
                        })
                    ->limit(env('FEATURED_PRODUCT'))
                    ->get();

(1/1) FatalThrowableError

Parse error: syntax error, unexpected '=>' (T_DOUBLE_ARROW), expecting ',' or ')'

I forget to ask another question:

$query = Products::query();
    $men_products = $query->productMetas()->where('prod_meta_type', 1)->where('value', 1)->get();

(1/1) BadMethodCallException Call to undefined method Illuminate\Database\Query\Builder::productMetas()

I wonder why I get the error message?

What does this query means?

 $query = Products::query();

Hello,

I would like to select men's product:

$men_products = Products::first()->productMetas()->where('prod_meta_type', 1)->where('value', 1)->get();
    

The condition is in productMetas:

class Products extends Model
{
    use SoftDeletes;

protected $primaryKey = 'prod_id';
protected $guarded = ['prod_id'];
protected $dates = ['deleted_at'];

public function productMetas()
{
    return $this->hasMany(ProductsMeta::class, 'prod_id');
}

The above query isn't right since it use first which only captures the first row, if I delete the first then what the query looks like? I also wonder why the result only shows the field from ProductsMeta instead of showing the related field from products and ProductsMeta?

In order to relate the table do you have to call the function?

For example:

$product->productMetas

Hello,

I would like to know if the following model automatically make relation products to other tables like ProductsMetas and productMainImage() ? So when you call product table automatically associate it with other tables also. IS that true?

Making relation

class Products extends Model
{
    use SoftDeletes;

protected $primaryKey = 'prod_id';
    protected $guarded = ['prod_id'];
    protected $dates = ['deleted_at'];

    public function productMetas()
    {
        return $this->hasMany(ProductsMeta::class, 'prod_id');
    }

    public function productMainImage()
    {
        return $this->hasOne(Images::class, 'img_id', 'prod_main_img');
    }

In addition, what is this for?

protected $guarded = ['prod_id'];

Any clue what this code means:

$products->appends(request()->except('page'))

Sublime can do that. Find in Files. Could search for the whole project.

I still wonder if $product->productMetas can call the model function AND the product attributes. So that is true right?

sublime can do so using Find in File. I am using Sublime.

I found this:

Products.php

 public function productMetas()
    {
    return $this->hasMany(ProductsMeta::class, 'prod_id');
    }

What is a grep tool and what is it for? I only use laravel for 1 year and still learning. How could you process $product->productMetas before relating it to another table?

You are right! Thanks

.env

FEATURED_PRODUCT=8

Hello,

Please help me understand this codes:

public function products_details(Products $product)
    {

dd($product);

    Products::where('prod_id', $product->prod_id)->increment('prod_seen');

    $related_products = ProductsMeta::get_related($product->productMetas, $product->prod_id);

when I dd($product); I cannot find productMetas I wonder where $product->productMetas comes from?

 #attributes: array:16 [▼
    "prod_id" => 11
    "prod_name" => "SUNNY BLOUSE 031 SZ 94"
    "prod_main_img" => "26"
    "prod_price" => 100000
    "prod_weight" => 1
    "prod_description" => "Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right ▶"
    "prod_rating" => null
    "prod_featured" => 1
    "prod_stockable" => 0
    "prod_stock" => null
    "prod_availability" => 1
    "prod_type" => null
    "prod_seen" => 36
    "deleted_at" => null
    "created_at" => "2017-09-25 13:15:17"
    "updated_at" => "2019-01-08 06:04:36"
]

Hello,

I have this codes:

web.php

//Store Products
Route::get('/product/{product}', '[email protected]_details');

StoreController.php

public function products_details(Products $product)
{

Products::where('prod_id', $product->prod_id)->increment('prod_seen');

See I cannot understand when someone pass the id such as calling /product/5 will it automatically call the product with the id of 5? If so, why still capturing the id with $product->prod_id ?

Thanks in advance.

Hello,

I have this codes:

 $featured_products = Products::where('prod_featured', 1)->limit(env('FEATURED_PRODUCT'))->get();

I wonder where do you get env('FEATURE_PRODUCT') from? I cannot find it in the table. I can only find prod_featured

What is the difference between auth()->attempt() and auth()->login()

I need some example of auth()->login() to understand

Auth\StatefulGuard.php

    public function attempt(array $credentials = [], $remember = false);

    /**
    * Log a user into the application without sessions or cookies.
    *
    * @param  array  $credentials
    * @return bool
    */

public function once(array $credentials = []);

    /**
    * Log a user into the application.
    *
    * @param  \Illuminate\Contracts\Auth\Authenticatable  $user
    * @param  bool  $remember
    * @return void
    */

public function login(Authenticatable $user, $remember = false);

    /**
    * Log the given user ID into the application.
    *
    * @param  mixed  $id
    * @param  bool   $remember
    * @return \Illuminate\Contracts\Auth\Authenticatable
    */

I finally figure out why. I have similar file with different folder. I read the wrong files.

I can't understand why my sublime still reading the old memory while I already edit the codes. It keeps showing me the old error from:

in dbe595f2a72e7be9c02504364c8741b92e669a34.php (line 26)

I already try to delete the storage view and clean cache but it still remains.

I want the url (from images.url)

Looks like the error comes from on the frontend on this code:

@foreach($posts as $post)

Hello,

I get this: Undefined property: stdClass::$image

error message after Add this code:

 $posts = DB::table('posts')
                ->join('images', 'posts.main_image_id', '=', 'images.img_id')
                ->select('posts.*', 'images.url')
                ->get();

What's lacking?

Hello,

I am having something strange on this online shop.

navigation.blade.php

<ul class="sf-menu">
      <li class="deeper parent current"><a href="{{ url('/') }}">Home</a></li>
      <li><a href="{{ url('/catalog') }}">Catalog</a></li>
      
      @foreach($categories as $category)
        <li>
          <a href="{{ url('/catalog/'. $category->cat_id)}}">
                                    {{ $category->cat_name }}
                                </a>
          @if($category->subCategories->count() != 0)

            <ul>
            @foreach($category->subCategories as $subcat)

                <li><a href="{{ url('/catalog/'. $category->cat_id .'/'. $subcat->subcat_id)}}">{{ $subcat->subcat_name }}</a></li>

            @endforeach
            </ul>

          @endif

        </li>
      @endforeach
      <li><a href="{{ url('/blog') }}">Blog</a></li>
      <li><a href="{{ url('/contact') }}">Contact</a></li>
    </ul>

In the controller:

StoreController.php

public function index()
 {
    $new_products = Products::latest()->limit(env('NEW_PRODUCT'))->get();
    $popular_products = Products::orderBy('prod_seen', 'desc')->limit(env('POPULAR_PRODUCT'))->get();
    $featured_products = Products::where('prod_featured', 1)->limit(env('FEATURED_PRODUCT'))->get();
    //dd($popular_products);
    return view('store.index', compact('new_products', 'popular_products', 'featured_products'));
 }

When I var_dump the categories there are a lot in it, but I do not know where it comes from. Please gives me some ideas.

Route::get('/', '[email protected]');

In the store index it includes navigation.blade.php. This must be something advance. Where does $categories comes from?

Please help.

"Too few arguments to function App\Http\Controllers\API\CustomerAPIController::App\Http\Controllers\API{closure}(), 1 passed and exactly 2 expected"

Any clue why I am getting this error message?

CustomerAPIController.php

  public function SearchCustomer(Request $request)
  {

        $input = $request->all();

        $group_id = @$input['group_id'];
        $search = @$input['search'];
        $maxdata = @$input['maxdata'];


        // $sql = Customer::where('group_id', 'like', $group_id)->orwhere('name', 'like', '%'.$name.'%')->orwhere('address', 'like', '%'.$address.'%')->orwhere('email', 'like', $email)->orwhere('phone', 'like', $phone)->orwhere('notes', 'like', '%'.$notes.'%')->paginate($maxdata);
        $sql = DB::table('ms_customer');

        if($group_id != null && $search != null){

            $sql = $sql->where('group_id', '=', $group_id)
                       ->where(function ($query, $search) {
                            $query->orwhere('name', 'like', '%'.$search.'%')
                                  ->orwhere('address', 'like', '%'.$search.'%')
                                  ->orwhere('email', 'like', '%'.$search.'%')
                                  ->orwhere('phone', 'like', '%'.$search.'%')
                                  ->orwhere('notes', 'like', '%'.$search.'%');
                        });
        }            
        
        if($maxdata != null){
            $sql = $sql->limit($maxdata);
        }               
       
        $sql_arr = $sql->get()->toArray();

       
        return $this->sendResponse($sql_arr, 'Customer retrieved successfully');
      }

D:\xampp72\htdocs\redbuzz>php artisan

'php' is not recognized as an internal or external command, operable program or batch file.

D:\xampp72\htdocs\redbuzz>laravel

'laravel' is not recognized as an internal or external command, operable program or batch file.

Hello,

When I typed php artisan in command prompt it does not recognize the syntax, any clue why?

What do I need to install to make it works?

http://*******/public/api/elorest/Models/Supplier?where=name,like,abc&where=email,like,abc.gmail.com&select=&get=

this syntax works when using & and now I want to change it to or yet it does shows error when I do that.

SQL: select * from ms_supplier where like name like abc||where=email ms_supplier.deleted_at is null)

I wonder why?

Hello,

Anyone understand how to edit data in elorest? (using PUT)

https://github.com/dandisy/elorest

I get the following error when trying to edit.

Class 'App\Models' not found

What does it mean?

Hello,

I create api for login that returns username and message retrieved user successfully:

public function index(Request $request)
{
 
    $data = $request->all();
    $data['email'] = $request->email;
    $password = bcrypt($request->password);

    $User = User::where('email', $data['email']) and where('password', $password)->get();

    if($User != null){

        return $this->sendResponse($data->toArray(), 'Users retrieved successfully');    
    }
    
   }

I am not sure if I write this line correctly:

$User = User::where('email', $data['email']) and where('password', $password)->get();

please help me correct it?

I am working on top of someone else code. I have to build new api. The previous developer uses elorest. I have used laravel for around 1 year. I have no choice but to use elorest.

Most of the tutorial I watches only uses echo json. Elorest seems to be different when calling the api.

So it's checking if there is a transaction row connected to the transaction table?

Cek this code:

$seller = Seller::has('transactions')->findOrFail($id);

has('transaction') is it checking the existance of transactions table?

I read the documentation but still do not understand the syntax to call the api. I working on someone else program:

http://*/public/oauth/[email protected]&password=&grant_type=password&scope=[]&client_id=1&client_secret=2ZxtO4C4pyfeBsRZKO5q9AcSAPKPmHU8bacWThKf

I cannot understand where do you get oauth/ and token ?

and there is another one:

http://*******/public/api/products?query[a][function]=get

This link works but not understandable. Since I have to get another similar api and create the api

What is the point of using elorest? and why not using normal api?

Hello,

What is elorest is for?

Elorest::routes();

Elorest::routes([ 'middleware' => ['auth:api', 'throttle:60,1'], // 'only' => ['post', 'put', 'patch', 'delete'], 'except' => ['get'] ]);

There isn't much information on google about it.

Hello,

I have been looking for away to decrypt bcrypt password online but I cannot understand why they keep asking for a string to check against?

When encrypting it as simple as this:

$user->password = bcrypt($request->password); $user->save();

What am I missing?

I still do not get the point of using casts if we can use validation to validate the data.

Hello,

I would like to check:

routes/api.php

Route::get('reports/documents', '[email protected]');   

Route::resource('customer_groups', 'CustomerGroupAPIController');

How to know if my api works or not using these routes. Is it enough to type: www.mainurl.com/reports/documents and www.mainurl.com/customer_groups

?