rsvb

rsvb

Utrecht

Member Since 11 Months Ago

Experience Points 7,350
Experience
Level
Lessons Completed 34
Lessons
Completed
Best Reply Awards 5
Best Answer
Awards
  • Start Your Engines Achievement

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • First Thousand Achievement

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • One Year Member Achievement

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • Two Year Member Achievement

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • Three Year Member Achievement

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • Four Year Member Achievement

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • Five Year Member Achievement

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • School In Session Achievement

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • Welcome To The Community Achievement

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • Full Time Learner Achievement

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • Pay It Forward Achievement

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • Subscriber Achievement

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • Lifer Achievement

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • Laracasts Evangelist Achievement

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • Chatty Cathy Achievement

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • Laracasts Veteran Achievement

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • Ten Thousand Strong Achievement

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • Laracasts Master Achievement

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • Laracasts Tutor Achievement

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • Laracasts Sensei Achievement

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • Top 50 Achievement

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

05 Jun
7 months ago

rsvb left a reply on Is It Possible To Use Laravel For Purely Backend (API Interaction) Purposes?

You can use the components you only want to use without knowledge of the components you don't want to use.

30 May
7 months ago

rsvb left a reply on Laravel Eager Loading Vs Database View

I think I was one of the last who used views lol. I stopped with the views when I started with Laravel, because you can now change your data retrieving in the php files, what is a little bit more handy than changing the views in the database.

28 May
7 months ago

rsvb left a reply on How Do I Set Relationships With Conditions?

{
    public function student()
    {
        $this->belongsTo(User::class, 'student_id' );
    }

    public function teacher()
    {
       $this->belongsTo(User::class, 'teacher_id' );
    }
}
26 May
7 months ago

rsvb left a reply on Dive In PHP OOP

OOP is not how you develop in Laravel in general.

OOP is in the framework, so if you need framework extensions, you should use OOP.

21 May
8 months ago

rsvb left a reply on Enterprise Applications

You will need a lot of server capacity and peak load handling.

Defining Peak Load and Peak Capacity

Peak load refers to the maximum number of concurrent users and requests per minute that you expect the system to support, based on the pattern of activity that typically exists on your system. You may want your system to support a certain number of requests with a certain response time per request. This doesn't mean that your system can in fact handle this load: it might be able to handle the number of users, but only by processing their requests at a slower rate. If you decide you want your system to handle the maximum number of concurrent users that typically access the system and submit requests, you may have to add server resources to achieve the desired response time. You may, instead, decide to use another design point, steady state load, which is explained on page 61. Whether you choose peak load or steady state load as your system capacity design point depends on several factors, including acceptable response time, all of which are described later in this chapter.

Peak capacity refers to the maximum number of concurrent users that the system can realistically sustain before requests per minute start to decline and response time starts to increase. Peak capacity may be more or less than peak load, and knowing the difference is critical to planning your system. You may find out at first that your system cannot handle the peak load. However, if you use peak load as a design point, you can do things to adjust aspects of your system and bring peak capacity to a level that is acceptable for your enterprise.

18 May
8 months ago

rsvb left a reply on 1366 Incorrect String Value, On CSV Import To MySQL DB

Perhaps you use a php str function, you should use mb_str.

http://php.net/manual/en/ref.mbstring.php

rsvb left a reply on 1366 Incorrect String Value, On CSV Import To MySQL DB

Can you save é in the table column? If yes the column is okay, if no you should change the column collation.

15 May
8 months ago

rsvb left a reply on Socialite Hitting 404 Page

Route::get('login/{social/callback}', 'Auth\[email protected]') ->where('social','twitter|facebook|linkedin|google|github');

should be

Route::get('login/{social}/callback', 'Auth\[email protected]')
            ->where('social','twitter|facebook|linkedin|google|github');

rsvb left a reply on Install Maatwebsite/excel Package Without Composer

Best practice is :

  1. backup webserver .
  2. download laravel from webserver.
  3. run composer local.
  4. upload laravel to webserver.
10 May
8 months ago

rsvb left a reply on Running Scheduler Another Way Other Than Cron?

I delete the mail in mail folder.

08 May
8 months ago

rsvb left a reply on Laravel Socialite - Facebook - User Access Token Changes

This means that every 90 days you must send a person through the Facebook Login process, and the person must agree to specific data permissions by tapping the “continue” button.

07 May
8 months ago

rsvb left a reply on Default DB: MySQL - Need To Sync With SQL Server

I make 1 stored procedure in mysql, very easy. It is best to do the action as close as it can be, in the database itself.

06 May
8 months ago

rsvb left a reply on Web Development Became Too Complex

Web development is way way way way etc. too too too complicated.

1 very positive point : one app serves all.

05 May
8 months ago

rsvb started a new conversation First Things First Lol

First of all, you need to know how to search the Internet, which most of askers obviously have no idea how to do. Knowing where to look for answers is the first skill you need as any kind of developer, front-end, back-end, mobile, sysadmin, whatever.

rsvb left a reply on RAW Queries And SQL Injection

You should to see :

AND data.id = "218 OR 1 = 1" so no injection but a search string.

04 May
8 months ago

rsvb left a reply on RAW Queries And SQL Injection

The important thing here is that the parameter values are combined with the compiled statement, not an SQL string. SQL injection works by tricking the script into including malicious strings when it creates SQL to send to the database. So by sending the actual SQL separately from the parameters, you limit the risk of ending up with something you didn't intend. Any parameters you send when using a prepared statement will just be treated as strings (although the database engine may do some optimization so parameters may end up as numbers too, of course). In the example above, if the $name variable contains 'Sarah'; DELETE FROM employees the result would simply be a search for the string "'Sarah'; DELETE FROM employees", and you will not end up with an empty table.

Very simple.

03 May
8 months ago

rsvb left a reply on Authentication Scaffolding

Username / password is not very secure. For really secure you should add a 3rd check.

rsvb left a reply on Updating 150,000 Records Is Timing Out - Can't Find A Solution

UPDATE cart JOIN (SELECT @no := 1000) r SET Number=@no:=@no+1;

rsvb left a reply on Updating 150,000 Records Is Timing Out - Can't Find A Solution

set_time_limit(0); 0 = unlimited

rsvb left a reply on A Medium Size Website With Laravel Vue

Never use tools the client wants, the client is complete ignorant about computer software.

rsvb left a reply on Adding New Fields To User For Registration

In the database there should be a default value if the column can not be empty.

02 May
8 months ago

rsvb left a reply on What Framework / Template For A Webapp With Idea To Convert To Native App?

Most popular front-end frameworks used for developing generic designs that facilitate rapid prototyping these days are Bootstrap, Skeleton, and Foundation. Among the three, Bootstrap handles the lion’s share leaving Skeleton, and Foundation somewhat a mile distance

01 May
8 months ago

rsvb left a reply on Hosting On Shared Server Best Practice

Now another thing, in case you do not have local, is the default install 100% right on a webhost?

rsvb left a reply on Hosting On Shared Server Best Practice

Why should the webhost setup be different from the local setup? They should be the same in my opinion. Then this question would be history lol.

30 Apr
8 months ago

rsvb left a reply on Hosting On Shared Server Best Practice

The easiest way for me is 1:1 webserver : localserver.

rsvb left a reply on Laravel Socialite Not Completely Destroying Session

You should login into another facebook account on your device.

26 Apr
8 months ago

rsvb left a reply on Auth::attempt() Not Working When Connecting In Laravel With Facebook

You must login user

auth()->login($user, true)

24 Apr
8 months ago

rsvb left a reply on How To Send Mail Using Gmail Account

It can be done, but it is a big hassle. I could not find 1 pages with clear instructions.

23 Apr
8 months ago

rsvb left a reply on Eloquent Typecasting To Nvarchar(4000)

A php string should match the mssql column type, i think nvarchar is the correct type, but now it will not use the varchar index.

rsvb left a reply on Auth Login With Custom Fields

You do not need a password when you use facebook as authentication.

rsvb left a reply on Development Setup

I develop on the webhost. One flaw, I must upgrade local ( with composer ).

22 Apr
8 months ago

rsvb left a reply on Is One User Table Enough?

I added colums in user table.

Auth::user()->addedcolumn gives the value.

21 Apr
9 months ago

rsvb left a reply on How To Use Laravel Passport For Web Authentication?

The Auth facade has the user properties. Only authenticated users should be capable of getting the application pages.

19 Apr
9 months ago

rsvb left a reply on Create A Job To Run Every Second

while (true) { process the rows }

will never stop, set_time_limit(3600) will stop after 1 hour, so you need to start the cronjob every hour and you have a stop.

18 Apr
9 months ago

rsvb left a reply on Create A Job To Run Every Second

What it has to do with job running?? You must proces unprocessed rows, continuously.

14 Apr
9 months ago

rsvb left a reply on Many Routes In Web.php

It would be nicer to put all config params in a database, but I like databases and do not like all that distinct config files.

13 Apr
9 months ago
09 Apr
9 months ago

rsvb left a reply on Where To Go ? Laravel Or .NET Core 2

Biggest problem for companies with php is that you can not get a php certificate.

counterpart of this https://www.microsoft.com/en-us/learning/mcsd-certification.aspx does not exist by my knowledge.

04 Apr
9 months ago

rsvb left a reply on Is There Any Usefull Official Documentation (with Proper Explanation) About The .env Parameters?

There are 5 app params and 6 db params. the db params are the same as always, so what should be documented?

rsvb left a reply on Sum Of Total Row Data In Database Table

You must make an attribute in the model which is the sum of the columns.

public function getTotalAttribute()

return this->class_000 + this->class_100 + etc.

03 Apr
9 months ago

rsvb left a reply on How To Use Always Encryption In Laravel With Sql Server

ColumnEncryption = Enabled, don't know if this will fix, maybe.

02 Apr
9 months ago

rsvb left a reply on Is It Good To Learn Laravel 5.1 As A Beginner?

5.1 is 2 1/2 years ago, that is a long time in web terms.

01 Apr
9 months ago

rsvb left a reply on Laravel Composite Index Issue

In mysql you can create an index and specify the length, so you keep the info in the column, but truncate it in the index.

27 Mar
9 months ago

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format

Yes, i can update the query in mysql with no problems.

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format

Eloquent gave me more misery, I'll stop with it completely.

Not suitable for professional development.

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format

As you can not read null is correct as value for an integer. It should not give an error, and it happend before, so this is interesting.

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format

"SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'NULL' for column 'tb' at row 1 (SQL: update ac set tb = NULL

NULL is correct for the database, but not for Eloquent. Not nice.

25 Mar
9 months ago

rsvb left a reply on UpdateOrCreate Duplicates?

I would not use it.

I use mysql INSERT .... ON DUPLICATE KEY UPDATE