Homestead - SQLSTATE[HY000] [2002] Connection refused There's my local cnx data. But i've this error when a service try to connect to the database : {"error":{"type":"PDOException","message":"SQLSTATE[HY000] [2002] Connection refused","file":"\/home\/vagrant\/Code\/dashboard\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connectors\/Connector.php","line":47}} I don't understand what's wrong in my configuration.? Want to reply to this thread?let’s create a simple CRUD application with Laravel . we have updated This tutorial to laravel 5.2 . The application we want to create will manage the users of our application. We will create the following list of features for our application:List users (read users from the database)Create new usersEdit user informationDelete user informationAdding pagination to the list of usersNow to start off with things, we would need to set up a database. So if you have phpMyAdmin installed with your local web server setup, head over to http://localhost/phpmyadmin;

if you don’t have phpMyAdmin installed, use the MySQL admin tool workbench to connect with your database and create a new database.Requirements -> html form –> please install this and follow instructions from official sitePreview Now we need to configure Laravel to connect with our database. hoffman backpack aqua dashSo head over to your Laravel application folder, open config/database.php, change the MySQL array, and match your current database settings. backpack wfp systemHere is the MySQL database array from database.php file:Now we are ready to work with the database in our application. buy backpack altis lifeLet’s first create the database table Users via the following SQL queries from phpMyAdmin or any MySQL database admin tool;efish backpack

Now let’s seed some data into the Users table so when we fetch the users we won’t get empty results. Run the following queries into your database admin tool:NoteLater we will see how we can manage our database via laravel 5.2’s powerful migrations features. zixtro backpackAt the end of this chapter, I will introduce you to why it’s not a good practice to manually create SQL queries and make changes to the database structure. alps zion backpack reviewAnd I know that passwords should not be plain too! Listing the users – read users from databaseLet’s read users from the database. We would need to follow the steps described to read users from database:A route that will lead to our pageA controller that will handle our methodThe Eloquent Model that will connect to the databaseA view that will display our records in the templateSo let’s create our route at /app/http/routes.php.

Add the following line to the routes.php file:If you have noticed previously, we had Route::get for displaying our page Controller. But now we are using resource. So what’s the difference?In general we face two types of requests during web projects: GET and POST. We generally use these HTTP request types to manipulate our pages, that is, you will check whether the page has any POST variables set; if not, you will display the user form to enter data. As a user submits the form, it will send a POST request as we generally define the

tag in our pages. Now based on page’s request type, we set the code to perform actions such as inserting user data into our database or filtering records.What Laravel provides us is that we can simply tap into either a GET or POST request via routes and send it to the appropriate method. Here is an example for that:See the difference here is we are registering the same URL, /register, but we are defining its GET method so Laravel can call UserController class’ showUserRegistration method.

If it’s the POST method, Laravel should call the saveUser method of the UserController class.You might be wondering what’s the benefit of it? Well six months later if you want to know how something’s happening in your app, you can just check out the routes.php file and guess which Controller and which method of Controller handles the part you are interested in, developing it further or solving some bug. Even some other developer who is not used to your project will be able to understand how things work and can easily help move your project. This is because he would be able to somewhat understand the structure of your application by checking routes.php.Now imagine the routes you will need for editing, deleting, or displaying a user. Resource Controller will save you from this trouble. A single line of route will map multiple restful actions with our resource Controller. It will automatically map the following actions with HTTP verbs:HTTP VERBACTIONGETREADPOSTCREATEPUTUPDATEDELETEDELETE Prev Next

The picture above is from Farmers Market, an Icelandic design company and clothing brand. I can’t decide if these clothes should be in Little House on the Prairie or in a fashion magazine. Either way, I love them and that’s part of the reason why I love Iceland. Everything is stylish and cool in a chilled out kind of way. It makes you wonder if Icelanders were born with this understated fashion sense or if they’re just really good at hiding how hard they’re trying. Packing for Iceland is tough because you can experience so many weather conditions in one day. We’re talking about outfits that can go from bright sunshine and mild temperatures to icy winds that are harsher that a slap across the face with a particularly cold Icelandic fish. The weather in Iceland makes the British weather seem calm and mild. It takes unpredictability to whole new level and likes to trick you into a false sense of security and whip it away again just as you remove your fifth layer.

Iceland is the perfect place for knitted jumpers, wool dresses, thick tights and chunky boots. There are a few more practical things you’ll need to put on your list that aren’t quite so stylish. I learned a few things about what you should pack for Iceland and also a few things you have to pick up while you’re there. Here are 8 things everyone should pack for Iceland: No matter what time of year you visit Iceland, you’re definitely going to need a good waterproof jacket. As I’ve mentioned before, the weather in Iceland can flip in seconds and switches from bright and sunny to cold and rainy or even snowing so I’d recommend a light waterproof jacket that you can wear over your warm jumpers. I have a North Face waterproof jacket that has a soft fleecy lining around the neck and a good hood which came in very handy. It also packs up really small so I could stuff it in my backpack when I didn’t need it. These jackets are expensive but they’re well worth it because you’ll keep it for years.

The Icelandic jumper is basically a uniform for locals and you definitely need to be wearing one to be in the cool crew. They’re usually patterned around the neck, come in neutral colours and are made with natural materials. The jumpers are so warm that you don’t need to wear a jacket on top and this is why you feel like you see them EVERYWHERE. Many of the jumpers are handmade and this is reflected in the high price. Their popularity ties in with a recent popularity in knitting and has become something of a national symbol. This is more than just a jumper, it reflects the nation’s ability to cope after the economic crisis in 2008 which hit the country hard. This jumper says that they can look after themselves and they value their traditions. It’s also interesting that this style is spreading and every visitor to Iceland wants a slice of the homemade action. Top tip: Icelandic jumpers are itchy as hell. They’re also hot as hell so make sure you have something light to wear beneath or you’ll be itching like mad.

It’s all about the layers in Iceland to make sure you stay warm but still stylish in this unpredictable climate. My top secret here is thermals. I know what you’re thinking, ‘Thermals aren’t sexy’, right? I know, I know. But when you’ve got thermals underneath you can wear whatever you like on top. I usually wear thermals and then I’ll put leggings with cute jumpers or dresses on top. I don’t look like I’m bundled up but I’ll be super toasty! I had real issues buying these trousers for a number of reasons. Secondly, they were quite expensive at £45. Did I mention they’re ugly? But I was grateful for these trousers when the heavens opened. We usually spent all day on the road visiting different places in Iceland so it would have been horrible to sit in soggy trousers while driving from place to place. Some people opted for waterproof trousers that are lined but I had a thin pair that can be slipped over whatever you’re already wearing. These are cheaper and mean you can take them off if the sun decides to shine.

These also mean you can be wearing a cute outfit underneath. If you’re travelling in the summer you’ll definitely want to get out and about in the mountains and do some hiking so a decent pair of walking shoes is a must. If you’re visiting in the winter then you might not be doing so much hiking but there will be walks to waterfalls and around national parks. If you’re planning to go glacier hiking (more on this coming soon!) then you will need very sturdy boots in order to attach your crampons. I actually didn’t take hiking boots and I wore my cosy Ugg boots for the entire trip because I’d left my boots at my parent’s house in Wales. I was able to hire hiking boots for glacier hiking for 1,000 Icelandic Krona which works out at about £5.00 – much better than buying new ones and even a good option if you don’t want to lug around a heavy pair of boots. A bobble hat with a beard attached is optional but if you want to fit in with the locals then a cute and cosy bobble hat will be your favourite accessory.

It might seem strange to have sun glasses and cashmere bobble hats on the same list but, trust me, you’ll need them. When the sun shines off a fresh layer of snow it’s the most beautiful sight in the world but it doesn’t half make you squint. I’m usually more than happy using my iPhone and DSLR camera when I’m travelling but a combination of the wet weather and underwater activities in Iceland made a GoPro really handy. If you aren’t familiar with what a GoPro is, it’s a tiny camera that comes with a waterproof case and can be easily attached to a head, chest or wrist strap. They’re great for activities like snorkelling, visiting hot springs  or the Blue Lagoon or when you’re around waterfalls. What do you think to the Icelandic style and is there anything else you think that should be on this list? Tips for visiting the Blue Lagoon in Iceland Snorkelling between tectonic plates in Iceland Tips for road tripping and car hire in Iceland