Book VI: Databases with MySQL 627 in Java

Maker PDF417 in Java Book VI: Databases with MySQL 627

Examining the Basic Structure of Data 629 Determining the fields in a record631 Introducing SQL data types631 Specifying the length of a record632 Defining a primary key633 Defining the table structure 633 Introducing MySQL 634 Why use MySQL 635 Understanding the three-tier architecture 636 Practicing with MySQL 636 Setting Up phpMyAdmin 637 Changing the root password639 Adding a user 644 Using phpMyAdmin on a remote server 647 Making a Database with phpMyAdmin649

Writing SQL Code by Hand657 Understanding SQL syntax rules 658 Examining the buildContactsql script 658 Dropping a table 659 Creating a table659

Adding records to the table 660 Viewing the sample data661 Running a Script with phpMyAdmin661 Using AUTO_INCREMENT for Primary Keys664 Selecting Data from Your Tables 666 Selecting only a few fields 668 Selecting a subset of records 669 Searching with partial information 671 Searching for the ending value of a field 671 Searching for any text in a field 673 Searching with regular expressions 674 Sorting your responses675 Editing Records 676 Updating a record676 Deleting a record 677 Exporting Your Data and Structure677 Exporting SQL code680 Creating XML data 682

Recognizing Problems with Single-Table Data683 The identity crisis 684 The listed powers684 Repetition and reliability686 Fields that change 686 Deletion problems 687 Introducing Entity-Relationship Diagrams687 Using DBDesigner 4 to draw ER diagrams687 Creating a table definition in DBDesigner 688 Connecting to a database with DBDesigner690 Manipulating your data from DBDesigner693 Introducing Normalization695 First normal form695 Second normal form696 Third normal form697 Identifying Relationships in Your Data 698

Calculating Virtual Fields 701 Introducing SQL Functions702 Knowing when to calculate virtual fields 703 Calculating Date Values 703 Using DATEDIFF to determine age704 Adding a calculation to get years704 Converting the days integer into a date 706 Using YEAR( ) and MONTH( ) to get readable values707 Concatenating to make one field 707 Creating a View708

Using an Inner Join to Combine Tables 710 Building a Cartesian join and an inner join711 Enforcing one-to-many relationships 714 Counting the advantages of inner joins714 Building a view to encapsulate the join715 Managing Many-to-Many Joins 716 Understanding link tables 718 Using link tables to make many-to-many joins 718

AJAX Spelled Out727 A is for asynchronous 727 J is for JavaScript727 A is for and 727 And X is for data 728 Making a Basic AJAX Connection728 Building the HTML form 731 Creating an XMLHttpRequest object 731 Opening a connection to the server 733 Sending the request and parameters733 Checking the status734 All Together Now Making the Connection Asynchronous 735 Setting up the program 736 Building the getAJAX( ) function 737 Reading the response 737

Introducing jQuery739 Getting acquainted with jQuery 740 Getting started with jQuery 743 Coding with jQuery 746 Putting jQuery to Work747 Selecting elements in jQuery 748 Selecting all elements of a specific type749 Modifying the list items 751 Selecting elements by class name753 Managing Events through jQuery 756 Using bind to bind events to elements 756 Unbinding 757

Interfacing with the Official UI Plugin764 Dragging and dropping 764 Sorting with the table sorter767 Creating dialog boxes 771 Interface Elements for jQuery 775 Getting to know the Interface Elements 776 Selectables 782 Making a slider784

Working with XML 787 Generating XML with PHP 788 Handling the XML response with jQuery 789 Introducing JSON 795 Overview of JSON 795 Using JSON with PHP 796 Using JSON with AJAX 797 Generating tables with JSON798

Understanding Clients and Servers 803 Parts of a client-side development system 804 Parts of a server-side system805 Creating Your Own Server with XAMPP 806 Running XAMPP807 Testing your XAMPP configuration 807 Adding your own files 808 Setting the security level 809 Compromising between functionality and security811 Choosing a Web Host812 Finding a hosting service 813 Connecting to a hosting service814 Managing a Remote Site 815 Using Web-based file tools 815 Understanding file permissions817 Using FTP to manage your site 818 Naming Your Site 821 Understanding domain names821 Registering a domain name822 Managing Data Remotely825 Creating your database825 Finding the MySQL server name 827