PHP, MySQL & JavaScript All in One, Sams Teach Yourself

Julie C. Meloni is a technical consultant who has been developing web-based applications since the Web first saw the light of day. She has authored numerous books and articles on web-based programming and scripting languages and database topics, and you can find translations of her work in 18 different languages.

• Part I: Web Application BasicsCHAPTER 1: Understanding How the Web WorksA Brief History of HTML and the World Wide WebCreating Web ContentUnderstanding Web Content DeliverySelecting a Web Hosting ProviderTesting with Multiple Web BrowsersCreating a Sample FileUsing FTP to Transfer FilesUnderstanding Where to Place Files on the Web ServerCHAPTER 2: Structuring HTML and Using Cascading Style SheetsGetting Started with a Simple Web PageHTML Tags Every Web Page Must HaveUsing Hyperlinks in Web PagesOrganizing a Page with Paragraphs and Line BreaksOrganizing Your Content with HeadingsUnderstanding Semantic ElementsHow CSS WorksA Basic Style SheetA CSS Style PrimerUsing Style ClassesUsing Style IDsInternal Style Sheets and Inline StylesCHAPTER 3: Understanding the CSS Box Model and PositioningThe CSS Box ModelThe Whole Scoop on PositioningControlling the Way Things Stack UpManaging the Flow of TextUnderstanding Fixed LayoutsUnderstanding Fluid LayoutsCreating a Fixed/Fluid Hybrid LayoutConsidering a Responsive Web DesignCHAPTER 4: Introducing JavaScriptLearning Web Scripting BasicsHow JavaScript Fits into a Web PageExploring JavaScript’s CapabilitiesBasic JavaScript Language ConceptsJavaScript Syntax RulesUsing CommentsBest Practices for JavaScriptUnderstanding JSONUsing the JavaScript Console to Debug JavaScriptCHAPTER 5: Introducing PHPHow PHP Works with a Web ServerThe Basics of PHP ScriptsCode Blocks and Browser Output Part II: Getting Started with Dynamic WebsitesCHAPTER 6: Understanding Dynamic Websites and HTML5 ApplicationsRefresher on the Different Types of ScriptingDisplaying Random Content on the Client SideUnderstanding the Document Object ModelUsing window ObjectsWorking with the document ObjectAccessing Browser HistoryWorking with the location ObjectMore About the DOM StructureWorking with DOM NodesCreating Positionable Elements (Layers)Hiding and Showing ObjectsModifying Text Within a PageAdding Text to a PageChanging Images Based on User InteractionThinking Ahead to Developing HTML5 ApplicationsCHAPTER 7: JavaScript Fundamentals: Variables, Strings, and ArraysUsing VariablesUnderstanding Expressions and OperatorsData Types in JavaScriptConverting Between Data TypesUsing String ObjectsWorking with SubstringsUsing Numeric ArraysUsing String ArraysSorting a Numeric ArrayCHAPTER 8: JavaScript Fundamentals: Functions, Objects, and Flow ControlUsing FunctionsIntroducing ObjectsUsing Objects to Simplify ScriptingExtending Built-in ObjectsUsing the Math ObjectWorking with Math MethodsWorking with DatesThe if StatementUsing Shorthand Conditional ExpressionsTesting Multiple Conditions with if and elseUsing Multiple Conditions with switchUsing for LoopsUsing while LoopsUsing do…while LoopsWorking with LoopsLooping Through Object PropertiesCHAPTER 9: Understanding JavaScript Event HandlingUnderstanding Event HandlersUsing Mouse EventsUsing Keyboard EventsUsing the load and unload EventsCHAPTER 10: The Basics of Using jQueryUsing Third-Party JavaScript LibrariesjQuery Arrives on the ScenePreparing to Use jQueryBecoming Familiar with the $().ready HandlerSelecting DOM and CSS ContentManipulating HTML ContentPutting the Pieces Together to Create a jQuery AnimationHandling Events with jQuery Part III: Taking Your Web Applications to the Next LevelCHAPTER 11: AJAX: Remote ScriptingIntroducing AJAXUsing XMLHttpRequestCreating a Simple AJAX LibraryCreating an AJAX Quiz Using the LibraryDebugging AJAX-Based ApplicationsUsing jQuery’s Built-in Functions for AJAXCHAPTER 12: PHP Fundamentals: Variables, Strings, and ArraysVariablesData TypesUsing Expressions and OperatorsConstantsUnderstanding ArraysCreating ArraysSome Array-Related Constructs and FunctionsCHAPTER 13: PHP Fundamentals: Functions, Objects, and Flow ControlCalling FunctionsDefining a FunctionReturning Values from User-Defined FunctionsUnderstanding Variable ScopeSaving State Between Function Calls with the static StatementMore About ArgumentsTesting for the Existence of a FunctionCreating an ObjectObject InheritanceSwitching FlowImplementing LoopsCHAPTER 14: Working with Cookies and User SessionsIntroducing CookiesSetting a CookieDeleting a CookieOverview of Server-Side SessionsWorking with Session VariablesDestroying Sessions and Unsetting Session VariablesUsing Sessions in an Environment with Registered UsersCHAPTER 15: Working with Web-Based FormsHow HTML Forms WorkCreating a FormAccepting Text InputNaming Each Piece of Form DataLabeling Each Piece of Form DataGrouping Form ElementsExploring Form Input ControlsUsing HTML5 Form ValidationSubmitting Form DataAccessing Form Elements with JavaScriptAccessing Form Elements with PHPUsing Hidden Fields to Save State in Dynamic FormsSending Mail on Form Submission  Part IV: Integrating a Database into Your ApplicationsCHAPTER 16: Understanding the Database Design ProcessThe Importance of Good Database DesignTypes of Table RelationshipsUnderstanding NormalizationFollowing the Design ProcessCHAPTER 17: Learning Basic SQL CommandsLearning the MySQL Data TypesLearning the Table-Creation SyntaxUsing the INSERT StatementUsing the SELECT StatementUsing WHERE in Your QueriesSelecting from Multiple TablesUsing the UPDATE Statement to Modify RecordsUsing the REPLACE StatementUsing the DELETE StatementFrequently Used String Functions in MySQLUsing Date and Time Functions in MySQLCHAPTER 18: Interacting with MySQL Using PHPMySQL or MySQLi?Connecting to MySQL with PHPWorking with MySQL Data Part V: Getting Started with Application DevelopmentCHAPTER 19: Creating a Simple Discussion ForumDesigning the Database TablesCreating an Include File for Common FunctionsCreating the Input Forms and ScriptsDisplaying the Topic ListDisplaying the Posts in a TopicAdding Posts to a TopicModifying the Forum Display with JavaScriptCHAPTER 20: Creating an Online StorefrontPlanning and Creating the Database TablesDisplaying Categories of ItemsDisplaying ItemsUsing JavaScript with an Online StorefrontCHAPTER 21: Creating a Simple CalendarBuilding a Simple Display CalendarCreating the Calendar in JavaScriptCHAPTER 22: Managing Web ApplicationsUnderstanding Some Best Practices in Web Application DevelopmentWriting Maintainable CodeImplementing Version Control in Your WorkUnderstanding the Value and Use of Code Frameworks AppendixesAPPENDIX A: Installation QuickStart Guide with XAMPPAPPENDIX B: Installing and Configuring MySQLAPPENDIX C: Installing and Configuring ApacheAPPENDIX D: Installing and Configuring PHP