rsvb

Experience

7,350

5 Best Reply Awards

  • Member Since 6 Months Ago
  • 34 Lessons Completed
  • 1 Favorite

5th June, 2018

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

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

30th May, 2018

rsvb left a reply on Laravel Eager Loading Vs Database View • 2 months ago

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.

28th May, 2018

rsvb left a reply on How Do I Set Relationships With Conditions? • 2 months ago

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

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

26th May, 2018

rsvb left a reply on Dive In PHP OOP • 2 months ago

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.

21st May, 2018

rsvb left a reply on Enterprise Applications • 2 months ago

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.

18th May, 2018

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

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 • 3 months ago

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

15th May, 2018

rsvb left a reply on Socialite Hitting 404 Page • 3 months ago

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 • 3 months ago

Best practice is :

  1. backup webserver .
  2. download laravel from webserver.
  3. run composer local.
  4. upload laravel to webserver.

10th May, 2018

rsvb left a reply on Running Scheduler Another Way Other Than Cron? • 3 months ago

I delete the mail in mail folder.

8th May, 2018

rsvb left a reply on Laravel Socialite - Facebook - User Access Token Changes • 3 months ago

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.

7th May, 2018

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

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.

6th May, 2018

rsvb left a reply on Web Development Became Too Complex • 3 months ago

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

1 very positive point : one app serves all.

5th May, 2018

rsvb started a new conversation First Things First Lol • 3 months ago

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 • 3 months ago

You should to see :

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

4th May, 2018

rsvb left a reply on RAW Queries And SQL Injection • 3 months ago

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.

3rd May, 2018

rsvb left a reply on Authentication Scaffolding • 3 months ago

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 • 3 months ago

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 • 3 months ago

set_time_limit(0); 0 = unlimited

rsvb left a reply on A Medium Size Website With Laravel Vue • 3 months ago

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 • 3 months ago

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

2nd May, 2018

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

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

1st May, 2018

rsvb left a reply on Hosting On Shared Server Best Practice • 3 months ago

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 • 3 months ago

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.

30th April, 2018

rsvb left a reply on Hosting On Shared Server Best Practice • 3 months ago

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

rsvb left a reply on Laravel Socialite Not Completely Destroying Session • 3 months ago

You should login into another facebook account on your device.

26th April, 2018

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

You must login user

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

24th April, 2018

rsvb left a reply on How To Send Mail Using Gmail Account • 3 months ago

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

23rd April, 2018

rsvb left a reply on Eloquent Typecasting To Nvarchar(4000) • 3 months ago

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 • 3 months ago

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

rsvb left a reply on Development Setup • 3 months ago

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

22nd April, 2018

rsvb left a reply on Is One User Table Enough? • 3 months ago

I added colums in user table.

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

21st April, 2018

rsvb left a reply on How To Use Laravel Passport For Web Authentication? • 3 months ago

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

19th April, 2018

rsvb left a reply on Create A Job To Run Every Second • 3 months ago

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.

18th April, 2018

rsvb left a reply on Create A Job To Run Every Second • 4 months ago

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

14th April, 2018

rsvb left a reply on Many Routes In Web.php • 4 months ago

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.

13th April, 2018

rsvb left a reply on Coverting MS Access Queries To Laravel Query Builder • 4 months ago

DB::select

9th April, 2018

rsvb left a reply on Where To Go ? Laravel Or .NET Core 2 • 4 months ago

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.

4th April, 2018

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

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 • 4 months ago

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.

3rd April, 2018

rsvb left a reply on How To Use Always Encryption In Laravel With Sql Server • 4 months ago

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

2nd April, 2018

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

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

1st April, 2018

rsvb left a reply on Laravel Composite Index Issue • 4 months ago

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.

27th March, 2018

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format • 4 months ago

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

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format • 4 months ago

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 • 4 months ago

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 • 4 months ago

"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.

25th March, 2018

rsvb left a reply on UpdateOrCreate Duplicates? • 4 months ago

I would not use it.

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

Edit Your Profile
Update

Want to change your profile photo? We pull from gravatar.com.