PHP & MySQL
Learn PHP, the programming language used to build sites like Facebook, Wikipedia and WordPress, then discover how these sites store information in a database (MySQL) and use the database to create the web pages. This full-color book is packed with inspiring code examples, infographics and photography that not only teach you the PHP language and how to work with databases, but also show you how to build new applications from scratch. It demonstrates practical techniques that you will recognize from popular sites where visitors can: Register as a member and log in; Create articles, posts and profiles that are saved in a database; Upload their own images and files; Automatically receive email notifications; Like and comment on posts. To show you how to apply the skills you learn, you will build a complete content management system, enhanced with features that are commonly seen on social networks. Written by best-selling HTML & CSS and JavaScript & jQuery author Jon Duckett, this ...
Learn PHP, the programming language used to build sites like Facebook, Wikipedia and WordPress, then discover how these sites store information in a database (MySQL) and use the database to create the web pages. This full-color book is packed with inspiring code examples, infographics and photography that not only teach you the PHP language and how to work with databases, but also show you how to build new applications from scratch. It demonstrates practical techniques that you will recognize from popular sites where visitors can: Register as a member and log in; Create articles, posts and profiles that are saved in a database; Upload their own images and files; Automatically receive email notifications; Like and comment on posts. To show you how to apply the skills you learn, you will build a complete content management system, enhanced with features that are commonly seen on social networks. Written by best-selling HTML & CSS and JavaScript & jQuery author Jon Duckett, this ...
MySQL Cookbook, 4th Edition
For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to resolve MySQL problems from scratch. In this updated fourth edition, authors Sveta Smirnova and Alkin Tezuysal provide more than 200 recipes that cover powerful features in both MySQL 5.7 and 8.0. Beginners as well as professional database and web developers will dive into topics such as MySQL Shell, MySQL replication, and working with JSON. You'll learn how to: Connect to a server, issue queries, and retrieve results; Retrieve data from the MySQL Server; Store, retrieve, and manipulate strings; Work with dates and times; Sort query results and generate summaries; Assess the characteristi ...
For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to resolve MySQL problems from scratch. In this updated fourth edition, authors Sveta Smirnova and Alkin Tezuysal provide more than 200 recipes that cover powerful features in both MySQL 5.7 and 8.0. Beginners as well as professional database and web developers will dive into topics such as MySQL Shell, MySQL replication, and working with JSON. You'll learn how to: Connect to a server, issue queries, and retrieve results; Retrieve data from the MySQL Server; Store, retrieve, and manipulate strings; Work with dates and times; Sort query results and generate summaries; Assess the characteristi ...
PHP: The Good Parts
Get past all the hype about PHP and dig into the real power of this language. This book explores the most useful features of PHP and how they can speed up the web development process, and explains why the most commonly used PHP elements are often misused or misapplied. You'll learn which parts add strength to object-oriented programming, and how to use certain features to integrate your application with databases. Written by a longtime member of the PHP community, PHP: The Good Parts is ideal for new PHP programmers, as well as web developers switching from other languages. Become familiar with PHP's basic syntax, variables, and datatypes; Learn how to integrate the language with web pages; Understand how to use strings, arrays, and PHP's built-in functions; Discover the advantages of using PHP as an object-oriented language; Explore how PHP interacts with databases, such as SQLite and MySQL; Learn input and output-handling best practices to prevent security breaches. ...
Get past all the hype about PHP and dig into the real power of this language. This book explores the most useful features of PHP and how they can speed up the web development process, and explains why the most commonly used PHP elements are often misused or misapplied. You'll learn which parts add strength to object-oriented programming, and how to use certain features to integrate your application with databases. Written by a longtime member of the PHP community, PHP: The Good Parts is ideal for new PHP programmers, as well as web developers switching from other languages. Become familiar with PHP's basic syntax, variables, and datatypes; Learn how to integrate the language with web pages; Understand how to use strings, arrays, and PHP's built-in functions; Discover the advantages of using PHP as an object-oriented language; Explore how PHP interacts with databases, such as SQLite and MySQL; Learn input and output-handling best practices to prevent security breaches. ...
Linux Server Hacks
Linux Server Hacks is a collection of 100 industrial-strength hacks, providing tips and tools that solve practical problems for Linux system administrators. Every hack can be read in just a few minutes but will save hours of searching for the right answer. Some of the hacks are subtle, many of them are non-obvious, and all of them demonstrate the power and flexibility of a Linux system. You'll find hacks devoted to tuning the Linux kernel to make your system run more efficiently, as well as using CVS or RCS to track the revision to system files. You'll learn alternative ways to do backups, how to use system monitoring tools to track system performance and a variety of secure networking solutions. Linux Server Hacks also helps you manage large-scale Web installations running Apache, MySQL, and other open source tools that are typically part of a Linux system. ...
Linux Server Hacks is a collection of 100 industrial-strength hacks, providing tips and tools that solve practical problems for Linux system administrators. Every hack can be read in just a few minutes but will save hours of searching for the right answer. Some of the hacks are subtle, many of them are non-obvious, and all of them demonstrate the power and flexibility of a Linux system. You'll find hacks devoted to tuning the Linux kernel to make your system run more efficiently, as well as using CVS or RCS to track the revision to system files. You'll learn alternative ways to do backups, how to use system monitoring tools to track system performance and a variety of secure networking solutions. Linux Server Hacks also helps you manage large-scale Web installations running Apache, MySQL, and other open source tools that are typically part of a Linux system. ...
Using SQLite
You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application. With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. Using SQLite guides you every step of the way. ...
You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application. With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. Using SQLite guides you every step of the way. ...
SQL Pocket Guide, 3rd Edition
If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language's complexity, and covers key aspects of SQL used in Oracle, DB2, SQL Server, MySQL, and PostgreSQL. That includes the syntax for querying, managing transactions, and making changes to data, as well as SQL functions, type conversion functions and formats, and regular expression syntax. ...
If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language's complexity, and covers key aspects of SQL used in Oracle, DB2, SQL Server, MySQL, and PostgreSQL. That includes the syntax for querying, managing transactions, and making changes to data, as well as SQL functions, type conversion functions and formats, and regular expression syntax. ...
Mastering Regular Expressions, 3rd Edition
Regular expressions are an extremely powerful tool for manipulating text and data. They are now standard features in a wide range of languages and popular tools, including Perl, Python, Ruby, Java, VB.NET and C# (and any language using the .NET Framework), PHP, and MySQL. If you don't use regular expressions yet, you will discover in this book a whole new world of mastery over your data. If you already use them, you'll appreciate this book's unprecedented detail and breadth of coverage. If you think you know all you need to know about regularexpressions, this book is a stunning eye-opener. As this book shows, a command of regular expressions is an invaluable skill. Regular expressions allow you to code complex and subtle text processing that you neverimagined could be automated. Regular expressions can save you time and aggravation. They can be used to craft elegant solutions to a wide range of problems. Once you've mastered regular expressions, they'll become an invaluable part ...
Regular expressions are an extremely powerful tool for manipulating text and data. They are now standard features in a wide range of languages and popular tools, including Perl, Python, Ruby, Java, VB.NET and C# (and any language using the .NET Framework), PHP, and MySQL. If you don't use regular expressions yet, you will discover in this book a whole new world of mastery over your data. If you already use them, you'll appreciate this book's unprecedented detail and breadth of coverage. If you think you know all you need to know about regularexpressions, this book is a stunning eye-opener. As this book shows, a command of regular expressions is an invaluable skill. Regular expressions allow you to code complex and subtle text processing that you neverimagined could be automated. Regular expressions can save you time and aggravation. They can be used to craft elegant solutions to a wide range of problems. Once you've mastered regular expressions, they'll become an invaluable part ...
Head First jQuery
Want to add more interactivity and polish to your websites? Discover how jQuery can help you build complex scripting functionality in just a few lines of code. With Head First jQuery, you'll quickly get up to speed on this amazing JavaScript library by learning how to navigate HTML documents while handling events, effects, callbacks, and animations. By the time you've completed the book, you'll be incorporating Ajax apps, working seamlessly with HTML and CSS, and handling data with PHP, MySQL and JSON. If you want to learn - and understand - how to create interactive web pages, unobtrusive script, and cool animations that don't kill your browser, this book is for you. Use jQuery with DOM to overcome the limitations of HTML and CSS; Learn how jQuery selectors and actions work together; Write functions and wire them to interface elements; Use jQuery effects to create actions on the page; Make your pages come alive with animation; Build interactive web pages with jQuery and Ajax; Build ...
Want to add more interactivity and polish to your websites? Discover how jQuery can help you build complex scripting functionality in just a few lines of code. With Head First jQuery, you'll quickly get up to speed on this amazing JavaScript library by learning how to navigate HTML documents while handling events, effects, callbacks, and animations. By the time you've completed the book, you'll be incorporating Ajax apps, working seamlessly with HTML and CSS, and handling data with PHP, MySQL and JSON. If you want to learn - and understand - how to create interactive web pages, unobtrusive script, and cool animations that don't kill your browser, this book is for you. Use jQuery with DOM to overcome the limitations of HTML and CSS; Learn how jQuery selectors and actions work together; Write functions and wire them to interface elements; Use jQuery effects to create actions on the page; Make your pages come alive with animation; Build interactive web pages with jQuery and Ajax; Build ...
Discovering SQL
Discover best practices for turning data into information you can use Structured Query Language, more popularly known as SQL, is a standard database language used to create, access and manipulate data, and store and maintain information in relational databases such as Access, SQL Server, Oracle, and MySQL. If that's all you know about SQL, then you're already ahead of the curve! Assuming no prior knowledge of SQL or relational databases, author Alex Kriegel takes you on a voyage of discovery as you learn SQL basics and learn to work with data stored in a relational database. Written in a beginner-friendly tone, this guide walks you through the creation of a sample database that incorporates all the SQL concepts taught throughout the book and also introduces data modeling, query tuning, and optimization. ...
Discover best practices for turning data into information you can use Structured Query Language, more popularly known as SQL, is a standard database language used to create, access and manipulate data, and store and maintain information in relational databases such as Access, SQL Server, Oracle, and MySQL. If that's all you know about SQL, then you're already ahead of the curve! Assuming no prior knowledge of SQL or relational databases, author Alex Kriegel takes you on a voyage of discovery as you learn SQL basics and learn to work with data stored in a relational database. Written in a beginner-friendly tone, this guide walks you through the creation of a sample database that incorporates all the SQL concepts taught throughout the book and also introduces data modeling, query tuning, and optimization. ...
Professional Linux Programming
As Linux continues to grow in popularity, there has never been more of a need to understand how to develop for this platform. Rather than focusing on a particular language or development technique, Professional Linux Programming looks at the different development environments within Linux - the kernel, the desktop, and the web - and then demonstrates best practices, tools, and techniques for integrating applications with the OS as a whole. This book is essential for understanding the nuances that differentiate programming for Linux from programming for any other platform. After beginning with simple shell scripts, the reader quickly moves on to the more advanced topics like software drivers and the graphical interface. The wide variety of tools that you can use to build application software, utilities, and even the Linux kernel itself are covered. You'll also explore the unique components of a Linux system and delve into the inner workings of the system. And you'll find out how to u ...
As Linux continues to grow in popularity, there has never been more of a need to understand how to develop for this platform. Rather than focusing on a particular language or development technique, Professional Linux Programming looks at the different development environments within Linux - the kernel, the desktop, and the web - and then demonstrates best practices, tools, and techniques for integrating applications with the OS as a whole. This book is essential for understanding the nuances that differentiate programming for Linux from programming for any other platform. After beginning with simple shell scripts, the reader quickly moves on to the more advanced topics like software drivers and the graphical interface. The wide variety of tools that you can use to build application software, utilities, and even the Linux kernel itself are covered. You'll also explore the unique components of a Linux system and delve into the inner workings of the system. And you'll find out how to u ...