rsvb

rsvb

Member Since 1 Year Ago

Utrecht

Experience Points 7,350
Experience Level 2

2,650 experience to go until the next level!

In case you were wondering, you earn Laracasts experience when you:

  • Complete a lesson — 100pts
  • Create a forum thread — 50pts
  • Reply to a thread — 10pts
  • Leave a reply that is liked — 50pts
  • Receive a "Best Reply" award — 500pts
Lessons Completed 34
Lessons
Completed
Best Reply Awards 5
Best Reply
Awards
  • start-engines Created with Sketch.

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • first-thousand Created with Sketch.

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • 1-year Created with Sketch.

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • 2-years Created with Sketch.

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • 3-years Created with Sketch.

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • 4-years Created with Sketch.

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • 5-years Created with Sketch.

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • school-session Created with Sketch.

    School In Session

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

  • welcome-newcomer Created with Sketch.

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • full-time-student Created with Sketch.

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • pay-it-forward Created with Sketch.

    Pay It Forward

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

  • subscriber-token Created with Sketch.

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • lifer-token Created with Sketch.

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • lara-evanghelist Created with Sketch.

    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 Created with Sketch.

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • lara-veteran Created with Sketch.

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • 10k-strong Created with Sketch.

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • lara-master Created with Sketch.

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • laracasts-tutor Created with Sketch.

    Laracasts Tutor

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

  • laracasts-sensei Created with Sketch.

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • top-50 Created with Sketch.

    Top 50

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

05 Jun
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year ago

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

I delete the mail in mail folder.

08 May
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year ago
09 Apr
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year ago

rsvb left a reply on UpdateOrCreate Duplicates?

I would not use it.

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