Author: Robin Nixon
Web designers will learn how to use these technologies together and pick up valuable web programming practices along the way—including how to optimize websites for mobile devices.
At the end of the book, you’ll put everything together to build a fully functional social networking site suitable for both desktop and mobile browsers.
Explore MySQL, from database structure to complex queries
Use the MySQLi extension, PHP’s improved MySQL interface
Create dynamic PHP web pages that tailor themselves to the user
Manage cookies and sessions and maintain a high level of security
Use Ajax calls for background browser server communication
Style your web pages by acquiring CSS2 and CSS3 skills
Implement HTML5 features, including geolocation, audio, video, and the canvas element
Reformat your websites into mobile web apps
From the Preface
The combination of PHP and MySQL is the most convenient approach to dynamic, database-driven web design, holding its own in the face of challenges from integrated frameworks—such as Ruby on Rails—that are harder to learn. Due to its open source roots, it is free to implement and is therefore an extremely popular option for web development.
This book is for people who wish to learn how to create effective and dynamic websites. This may include webmasters or graphic designers who are already creating static websites but wish to take their skills to the next level, as well as high school and college students, recent graduates, and self-taught individuals.
2. Laravel: Up & Running: A Framework for Building Modern PHP Apps
Author: Matt Stauffer is a developer and a teacher. He is a partner and technical director at Tighten Co., blogs at mattstauffer.co, and hosts The Five-Minute Geek Show and the Laravel Podcast.
What sets Laravel apart from other PHP web frameworks? Speed and simplicity, for starters. This rapid application development framework and its ecosystem of tools let you quickly build new sites and applications with clean, readable code.
Fully updated to cover Laravel 5.8, the second edition of this practical guide provides the definitive introduction to one of today’s mostpopular web frameworks.
Matt Stauffer, a leading teacher and developer in the Laravel community, delivers a high-level overview and concrete examples to help experienced PHP web developers get started with this framework right away.
This updated edition also covers Laravel Dusk and Horizon and provides information about community resources and other noncore Laravel packages.
Dive into features, including:
Blade, Laravel’s powerful custom templating tool
Tools for gathering, validating, normalizing, and filtering user-provideddata
The Eloquent ORM for working with application databases
The role of the Illuminate request object in the application lifecycle
PHPUnit, Mockery, and Dusk for testing your PHP code
Tools for writing JSON and RESTful APIs
Interfaces for filesystem access, sessions, cookies, caches, and search
Tools for implementing queues, jobs, events, and WebSocket event publishing
3. Full-Stack Vue.js 2 and Laravel 5: Bring the frontend and backend together with Vue, Vuex, and Laravel
Author: Anthony Gore
This book gives you practical knowledge of building modern full-stack web apps from scratch using Vue with a Laravel back end.
In this book, you will build a room-booking website named “Vuebnb”. This project will show you the core features of Vue, Laravel and other state-of-the-art web development tools and techniques.
The book begins with a thorough introduction to Vue.js and its core concepts like data binding, directives and computed properties, with each concept being explained first, then put into practice in the case-study project.
You will then use Laravel to set up a web service and integrate the front end into a full-stack app. You will be shown a best-practice development workflow using tools like Webpack and Laravel Mix.
With the basics covered, you will learn how sophisticated UI features can be added using ES+ syntax and a component-based architecture. You will use Vue Router to make the app multi-page and Vuex to manage application state.
Finally, you will learn how to use Laravel Passport for authenticated AJAX requests between Vue and the API, completing the full-stack architecture. Vuebnb will then be prepared for production and deployed to a free Heroku cloud server.
What you will learn
Core features of Vue.js to create sophisticated user interfaces
Build a secure backend API with Laravel
Learn a state-of-the-art web development workflow with Webpack
Full-stack app design principles and best practices
Learn to deploy a full-stack app to a cloud server and CDN
Managing complex application state with Vuex
Securing a web service with Laravel Passport
4. Modern PHP: New Features and Good Practices
Author: Josh Lockhart
PHP is experiencing a renaissance, though it may be difficult to tell with all of the outdated PHP tutorials online. With this practical guide, you’ll learn how PHP has become a full-featured, mature language with object-orientation, namespaces, and a growing collection of reusable component libraries.
Author Josh Lockhart—creator of PHP The Right Way, a popular initiative to encourage PHP best practices—reveals these new language features in action. You’ll learn best practices for application architecture and planning, databases, security, testing, debugging, and deployment.
If you have a basic understanding of PHP and want to bolster your skills, this is your book.
Learn modern PHP features, such as namespaces, traits, generators, and closures
Discover how to find, use, and create PHP components
Follow best practices for application security, working with databases, errors and exceptions, and more
Learn tools and techniques for deploying, tuning, testing, and profiling your PHP applications
Explore Facebook’s HVVM and Hack language implementations—and how they affect modern PHP
Build a local development environment that closely matches your production server
5. Murach’s MySQL (3rd Edition)
Author: Joel Murach is the oldest son of technical publishing pioneer Mike Murach.
This is the latest edition of the book that application developers worldwide have used to master MySQL…now updated for MySQL 8 and beyond.
As you would expect, this book shows how to code all the essential SQL statements for working with a MySQL database. You’ll use these statements every day to have MySQL do more of your work for you.
But beyond that, it shows how to work with classic MySQL features that take you to new level, such as summary queries, subqueries, functions, views, transactions, stored procedures, triggers, and security.
It shows how to take advantage of newer MySQL features such as window functions, Common Table Expressions (CTE), and roles for database security. It shows how to design a database, including how to use MySQL Workbench to create and implement the design.
It even presents a starting set of skills for a database administrator (DBA) if you’re interested in that career path or if you need to be your own DBA.
In short, it s a must-have guide for anyone who works with MySQL, beginning and experienced developers alike.
6. Algorithms (4th Edition)
Author : Kevin Wayne & Robert Sedgewick
This fourth edition of Robert Sedgewick and Kevin Wayne’s Algorithms is the leading textbook on algorithms today and is widely used in colleges and universities worldwide.
This book surveys the most important computer algorithms currently in use and provides a full treatment of data structures and algorithms for sorting, searching, graph processing, and string processing–including fifty algorithms every programmer should know.
In this edition, new Java implementations are written in an accessible modular programming style, where all of the code is exposed to the reader and ready to use.
The algorithms in this book represent a body of knowledge developed over the last 50 years that has become indispensable, not just for professional programmers and computer science students but for any student with interests in science, mathematics, and engineering, not to mention students who use computation in the liberal arts.
The companion web site, algs4.cs.princeton.edu, contains
An online synopsis
Full Java implementations
Exercises and answers
Programming assignments with checklists
Links to related material
The MOOC related to this book is accessible via the “Online Course” link at algs4.cs.princeton.edu. The course offers more than 100 video lecture segments that are integrated with the text, extensive online assessments, and the large-scale discussion forums that have proven so valuable. Offered each fall and spring, this course regularly attracts tens of thousands of registrants.
Robert Sedgewick and Kevin Wayne are developing a modern approach to disseminating knowledge that fully embraces technology, enabling people all around the world to discover new ways of learning and teaching.
By integrating their textbook, online content, and MOOC, all at the state of the art, they have built a unique resource that greatly expands the breadth and depth of the educational experience.
7. Learning Laravel’s Eloquent
Author: Francesco Malatesta
About This Book
Build highly efficient applications with the Eloquent ORM using an expressive syntax
Get to grips with the power of relationships and how Eloquent handles them
Go beyond simple theory with various step-by-step code examples
Who This Book Is For
This book is perfect for developers with some basic knowledge of PHP development, but are new to the Eloquent ORM. However, developers with previous Laravel and Eloquent experience will also benefit from the in-depth analysis of specific classes and methodologies in the book.
What You Will Learn
Configure a new Laravel project and set up database connections in minutes
Build and work with models to handle your data with an expressive syntax
Define relations between your models to create complex functionalities
Query your database using relations simply
Use collections to gather results and perform many operations on them with a powerful data structure
Use the Eloquent ORM without Laravel
Control your models during the request lifecycle with event listeners and observers
Learning Laravel’s Eloquent starts off by taking you through setting up your first project and guiding you in creating a perfect Laravel environment. You will learn how to build the right database structure with the Migrations system and the Schema Builder class.
Next, you will be introduced to the main element of Eloquent: the model. After treating the model as a single, isolated entity, you will learn how to create relations between them. You will be taken through organizing, filtering, and sorting your data with collections.
You will then learn to enhance an application with new features using events and by creating new observers. Towards the end of the book, you will discover how to install, configure, and use the Eloquent ORM without Laravel. The book concludes by walking you through how to deal with complex problems and build advanced and flexible systems.