jlrdw

Another older but good tutorial is https://scotch.io/tutorials/a-guide-to-using-eloquent-orm-in-laravel Gives good basic understanding.

I just do it like

<td><a href="<?php echo DIR . 'dog/edit?dogid=' . $row->dogid; ?>">Edit</a></td>

I don't always use blade however. DIR is a constant I defined.

See https://laracasts.com/discuss/channels/general-discussion/guidelines-for-posting-on-laracastscom

Here's a good guide: https://laracasts.com/discuss/channels/general-discussion/guidelines-for-posting-on-laracastscom

Have you worked any examples from the docs, or viewed any of Jeffrey's videos?

From PHP manual on closing a connection

If you don't do this explicitly, PHP will automatically close the connection when your script ends.

Now eloquent has nothing to do with anything, at runtime eloquent has to be converted to normal queries. In fact try something, test a normal query it will naturally run and finish faster. You are running inside a framework where some things are going through more processing.

It may be your queries needs a look over. But when the whole process is over, the connection is done. Taylor does not have persistent connections.

This is one of the pitfalls of active record, I'd say run some real test using straight PDO. Not fake test, but real live test. Laravel also has getPdo() for direct PDO usage.

SHow some code, usage, is Departments a subfolder, what is the controller name, etc.

Just curious, have you went through Jeffrey's free intro videos?

Once you have all working correctly, you shouldn't be getting errors. My error log is always empty, except during development of course.

You need to properly place the folder structure, see:

http://novate.co.uk/deploy-laravel-5-on-shared-hosting-from-heart-internet/

What class, and exact error, stack trace.

however,it is mandatory for this project.

Then I'd do another project and tell whoever blank blank. Just me. It is crazy storing images like that.

@sushma0596 could you mark as answered please?

Eloquent connections staying open

They don't stay open, you are probably getting too many hits. Check with your host / provider on load balancing.

Have you even considered homestead? Just to check everything out.

But I'd imagine has a million hits on installing php, I thing Jeffrey even has a video on it. Not to mention Youtube.

For dev you could install a bitnami stack, would be independent of your other mysql install.

I'd start viewing some videos on the subject, besides Jeffrey, there are complete how to videos on youtube on deployment.

But really a simple pull from master, then an update / sync to the development folder and finally a composer update a couple times a week should do it. And really as far as git vs ftp, same files. The trick is to know what files need updated as there is no point in uploading everything every time.

Sorry, but very first question:

Is there a setting to limit the px dimensions of an uploaded file?

Now I see problem.

Need to make image web ready I myself use Adobe photoshop. High resolution (large) images and mobile friendly don't match, a big no no.

I'd restrict uploading anything until either

• User makes image web ready

or

• You find a decent library that does it for them.

I know Facebook optimizes webifies images

There answered.

If you are going to use Visual Studio Code, why not do one even better and just go with netbeans?

Just curious, did OP never read this in the docs:

dimensions

The file under validation must be an image meeting the dimension constraints as specified by the rule's parameters:

'avatar' => 'dimensions:min_width=100,min_height=200'

Available constraints are: min_width, max_width, min_height, max_height, width, height, ratio.

A ratio constraint should be represented as width divided by height. This can be specified either by a statement like 3/2 or a float like 1.5:

'avatar' => 'dimensions:ratio=3/2'

Since this rule requires several arguments, you may use the Rule::dimensions method to fluently construct the rule:

use Illuminate\Validation\Rule;

Validator::make($data, [ 'avatar' => [ 'required', Rule::dimensions()->maxWidth(1000)->maxHeight(500)->ratio(3 / 2), ], ]);

Other good sources of info on security:

https://www.owasp.org/index.php/Main_Page

http://shiflett.org/articles

I generally writ my own auth / roles and csrf routines, just don't like laravels built-in.

I'd also make sure you have practice forms with a checkbox, date field, option group (select), etc. Take a checkbox for example, many newbees don't realize that if a checkbox isn't checked nothing is passed, so you have to handle how to deal with that.

Also a popup calendar and perhaps a popup lookup table.

Start off slow, remember one step at a time.

Just my suggestions.

See answer here https://laracasts.com/discuss/channels/laravel/recommendations-for-upgrade-from-50

Check if Laravel Shift can help you.

They say that there's no setting to limit this.

Use a library that has the requirements you need.

Wouldn't it be easier to have

• User and their clients on one host one system separate from other users
• Each customer their own domain, site, setup

Just pull master, change your dev to match then run composer update, I do this every few days.

Normally someone doesn't query that many records at once, that's why there's pagination.

$dogid = '1';
        $sql = "SELECT * FROM " . PREFIX . "dogs WHERE dogid = :dogid";
        $sth = DB::getPdo()->prepare($sql);
        $params = [':dogid' => $dogid];
        $sth->execute($params);
        $dog = $sth->fetch(\PDO::FETCH_ASSOC);
        print_r($dog);

Just a quick test.

@sam0081 so you have intranet?

• If you are online you have internet
• If your internet is down you are offline

Other way around

quasarjs in laravel

Seems quasarjs is a js frontend, correct? So if it works with php it works with laravel.

Did you remember to put the use statement

use Illuminate\Support\Facades\DB;

This

$dog = DB::table('dc_dogs')->where('dogid', '=', $dogid)->first();

as example is working for me.

• 1. What packages do you pull in when starting a new project?

none

• 1. Do you use a CSS framework? If so, please list

I write my own css and media queries

• 1. Do you separate your project into composer packages / modules or keep it all within the app directory?

I look at at laravel as crud and database management

• 1. Do you use a JS framework? If so, please list

Some jquery, I dont believe in over-javafication So a popup calendar, popup lookup, inline edit only in certain situations, etc.

• 1. na
• 1. I use the folder structure like docs
• 1. Only comment where something is complex, the obvious no.
• 1. I apply proper namespacing

Example I have a helper folder where I have a custom paginator for popup lookup tables, the namespace is

namespace App\Helpers;

Netbeans is pretty good also.

Same here I came from java and c# prior to php, php was fairly easy to grasp. To really learn laravel, learn what to "weed" out vs what's really needed.

If you have programmed in java, you should know that large enterprise doesn't jump on latest thing, or update stuff every other month.

That engine running internally is PDO and PHP, that's it.

You could start here would probably be better than a video anyway https://www.w3schools.com/html/

They also cover CSS.

@Cronix good to know, where do you put

DB::disableQueryLog();

Are you running a query that returns a huge resultset rather that paginating? Also just load what's needed on a page. As an example if an edit page only uses some js for a popup calendar just load that js, not 10 million lines of other js.

If you haven't commented it out it is.

@Tupakamaru if you have verified that, @TaylorOtwell states

Security Vulnerabilities

If you discover a security vulnerability within Laravel, please send an e-mail to Taylor Otwell at [email protected] All security vulnerabilities will be promptly addressed.

I'd put in subject line Security Vulnerability

Yes, watch the intro videos.

Look at this folder structure

https://drive.google.com/file/d/0B1_PFw--3o74WHNmMFlkRklKRTg/view?usp=sharing

Even on xamp or whatever install laravel using this guide:

http://novate.co.uk/deploy-laravel-5-on-shared-hosting-from-heart-internet/

Again in development and production use the guide, I recently used it for a shared host, the guide works 100% with zero problems.

Load your css using asset helper:

<link href="<?php echo asset('assets/css/dog/style.css'); ?>" rel="stylesheet">

Just correctly resolve your paths.

Look over this query and see how it was derived: https://laracasts.com/discuss/channels/eloquent/orderby-computed-related-attribute

Watch this https://drive.google.com/file/d/0B1_PFw--3o74YjVreHNBOWU2aEE/view?usp=sharing

An example is using `like'

        $dogsearch = (isset($_REQUEST['psch']) <> '' ? Cln::fixValue($_REQUEST['psch']) : "");
        $dogsch = $dogsearch . "%";
        $aval = (isset($_REQUEST['aval']) <> '' ? Cln::fixValue($_REQUEST['aval']) : "");

change to laravel request if desired

and

$query = Dog::where('dogname', 'like', $dogsch);
        if ($aval == "n") {
            $query->where('adopted', '=', 1);
        } else if ($aval == "y") {
            $query->where('adopted', '=', 0);
        }
        $dogs = $query->orderBy('lastedit', 'DESC')->paginate(5);
        $pagelinks = array('psch' => $dogsearch, 'aval' => $aval);

and view

echo '<td>' . $dogs->appends($pagelinks)->links() . '</td>';

Of course all passed to view with ->with statements.

And the little form at top of list page to perform a search:

<div>
    <form method="post" action="dog/indexadmin">
    <!--<form method="post" action="<?php //echo DIR; ?>dog/indexadmin">-->
        <label>sch</label><input type="text" name="psch" value="">
        <label>Avail y or n</label><input type="text" name="aval" value="" size="10">
        <input type="submit" name="submit" value="Search">       
    </form>
</div>

Your code is not showing, see this to help you post: https://laracasts.com/discuss/channels/general-discussion/guidelines-for-posting-on-laracastscom

Like asking

• How do I become an electrician

Go through the apprenticeship program and on the job training.

• How to become a doctor

Take all college requirements and fulfill the residency requirements.

• Your question

Learn php, html, css, js, etc, then start learning laravel through docs, videos, etc. Many of these folks have programmed for years. This stuff takes a while to learn correctly.

I don't know about all of that, I just made an asset folder and

<img src="<?php echo asset('assets/upload/imgdogs') . '/' . $row->dogpic; ?>

zero problems.

phalcon framework is the fastest one

Because it's compiled C or C language extension, ofcourse it's faster.

How to make your laravel project faster

Real question is php. Load balancing a large site helps.

But laravel is fine as is for a medium to small site. I came from enterprise java to php, (long story). I have a site I did in ver5.1 and maintain for a humane society.

Now is laravel / php ready Fedex size well no.

So unless you are programming something like

• Fedex
• CH Robinson
• JB Hunt
• Walmart Sams warehousing / logistics

uses, the you are just fine with php / laravel.

Large enterprise use java / servlets / EJB or if using php, the have compiled c++ classes for heavy hitting. Usually they will have custom code / framework for their needs.

As an example, CH Robinson has around 23 million dollars in their logistics solutions.

And to add to what @sutherland said there are free videos to get you started.

A quote from docs

"Are you a visual learner? Laracasts provides a free, thorough introduction to Laravel for newcomers to the framework. It's a great place to start your journey".