Quick Search
| Free Programing Ebook Download Free ebook office, office xp ebook, ebook systems, download databases ebooks, c++ study guide, c# certification, and many free programing ebook to download ... |
| toolbar powered by free-ebook-download.net |
 |
07-24-2009, 08:45 PM
|
|||
|
|||
PHP 6 MySQL Programming for the Absolute Beginner
Table of Contents
Chapter 1 Exploring the Environment..................................... 1 Programming on the Web Server............................................ .......................................... 3 Installing PHP and Apache .................................................. ....................................... 4 Using an Existing Server............................................ .................................................. 4 Installing Your Own Development Environment....................................... .......... 5 Installing with XAMPP............................................. .................................................. .. 7 Starting Your Server .................................................. .................................................. . 8 Checking Your Security Settings.......................................... ..................................... 9 Configuring Apache............................................ .................................................. ...... 10 Running Your Local Server............................................ .................................................. .. 11 Adding PHP to Your Pages............................................. ............................................ 11 Examining the Results........................................... .................................................. .. 12 Display Errors .................................................. .................................................. ........... 16 Windows Extensions .................................................. ................................................ 17 Changes in PHP 6................................................. .................................................. ...... 19 Safe Mode.............................................. .................................................. ....................... 19 Register Globals .................................................. .................................................. ....... 19 Creating the Tip of the Day Program........................................... .................................. 19 Summary........................................... .................................................. .................................. 20 Chapter 2 Using Variables and Input...................................... 21 Introducing the Story Program........................................... ............................................. 21 Using Variables in Your Scripts........................................... ............................................. 23 Introducing the Hi Jacob Program........................................... .............................. 23 Creating a String Variable.......................................... .................................................. ..... 25 Naming Your Variables......................................... .................................................. ... 25 Assigning a Value to a Variable .................................................. ............................. 25 Printing a Variable’s Value .................................................. ..................................... 26 Using Variables for More Complex Pages............................................. ......................... 28 Building the Row Your Boat Page .................................................. ......................... 28 Creating Multi-Line Strings .................................................. .................................... 30 Working with Numeric Variables......................................... ........................................... 31 Making the ThreePlusFive Program .................................................. ..................... 31 Assigning Numeric Values............................................ ............................................ 33 Using Mathematical Operators......................................... ....................................... 33 Creating a Form to Ask a Question.......................................... ....................................... 34 Building an HTML Page with a Form .................................................. ................... 35 Setting the Action Attribute to a Script File .................................................. ...... 36 Writing a Script to Retrieve the Data .................................................. .................. 37 Sending Data without a Form.............................................. ............................................ 39 Understanding the get Method .................................................. ............................. 39 Using a URL to Embed Form Data.............................................. ............................. 40 Working with Multiple Field Queries........................................... ......................... 42 Building a Pre-formatted Query .................................................. ............................ 42 Reading Input from Other Form Elements .................................................. ........ 43 Introducing the borderMaker Program........................................... .............................. 43 Building the borderMaker.html Page .................................................. .................. 44 Reading the Form Elements .................................................. ................................... 47 Reading Select Elements .................................................. ......................................... 48 Reading Radio Groups............................................ .................................................. .. 49 Returning to the Story Program........................................... ........................................... 50 Designing the Story .................................................. .................................................. 50 Building the HTML Page .................................................. .......................................... 52 Building the Story .................................................. .................................................. ... 54 Summary........................................... .................................................. .................................. 56 Controlling Your Code with Conditions and Functions......................................... ......................... 57 Chapter 3 Examining the Petals around the Rose Game.............................................. ................ 57 Creating a Random Number............................................ ................................................. 58 Viewing the Roll Em Program........................................... ....................................... 58 Printing a Corresponding Image............................................. ................................ 60 Using the if Statement to Control Program Flow.............................................. ......... 61 Introducing the Ace Program .................................................. ................................ 61 Creating a Condition......................................... .................................................. ....... 63 Exploring Comparison Operators .................................................. ......................... 64 Creating an if Statement......................................... .................................................. 65 Working with Negative Results........................................... ............................................ 66 Demonstrating the Ace or Not Program........................................... ............................. 66 Using the else Clause............................................ .................................................. .... 68 Working with Multiple Values............................................ ............................................. 69 Writing the Binary Dice Program .................................................. ......................... 69 Using Multiple else if Clauses .................................................. ................................ 71 Using the switch Structure to Simplify Programming....................................... ....... 72 Building the Switch Dice Program .................................................. ....................... 73 Using the switch Structure......................................... .............................................. 74 viii PHP 6/MySQL Programming for the Absolute Beginner Combining a Form and Its Results........................................... ....................................... 75 Responding to Checkboxes........................................ .................................................. ...... 78 Using Functions to Encapsulate Parts of the Program........................................... ... 81 Examining the This Old Man Program........................................... ....................... 82 Creating New Functions .................................................. .......................................... 84 Using Parameters and Function Values............................................ ............................. 84 Examining the Param.php Program .................................................. .................... 85 Looking at Encapsulation in the Main Code Body ............................................. 87 Returning a Value: The chorus() Function.......................................... .................. 88 Accepting a Parameter in the verse() Function .................................................. . 89 Managing Variable Scope............................................. .................................................. .... 90 Looking at the Scope Demo .................................................. .................................... 91 Returning to the Petals Game.............................................. ............................................ 93 Starting HTML .................................................. .................................................. .......... 94 Main Body Code .................................................. .................................................. ....... 94 The printGreeting() Function.......................................... ......................................... 95 The printDice() Function .................................................. ......................................... 96 The showDie() Function .................................................. ........................................... 97 The calcNumPetals() Function .................................................. ............................... 97 The printForm() Function.......................................... ................................................ 98 The Ending HTML Code .................................................. ........................................... 99 Summary........................................... .................................................. .................................. 99 Chapter 4 Loops and Arrays............................................ ....... 101 Introducing the Poker Dice Program........................................... ................................ 102 Counting with the for Loop.............................................. .............................................. 103 Initializing a Sentry Variable .................................................. ............................... 104 Setting a Condition to Finish the Loop .................................................. ............. 105 Changing the Sentry Variable.......................................... ...................................... 105 Building the Loop.............................................. .................................................. ...... 106 Modifying the for Loop .................................................. .......................................... 106 Using a while Loop.............................................. .................................................. ............ 110 Repeating Code with a while Loop .................................................. ..................... 110 Recognizing Endless Loops .................................................. ................................... 111 Building a Well-Behaved Loop .................................................. ............................. 113 Working with Basic Arrays............................................ .................................................. 114 Generating a Basic Array............................................. ............................................ 116 Using a Loop to Examine an Array’s Contents .................................................. 117 Using the array() Construct to Preload an Array............................................. .. 117 Detecting the Size of an Array .................................................. ............................. 118 Improving This Old Man with Arrays and Loops............................................. ......... 118 Building the place Array............................................. ............................................. 120 Writing Out the Lyrics .................................................. ........................................... 121 Contents ix Using Arrays in Forms............................................. .................................................. ....... 121 Arranging an HTML Form to Create an Array .................................................. . 124 Reading an Array from a Form .................................................. ............................ 125 Keeping Persistent Data.............................................. .................................................. ... 126 Counting with Form Fields............................................ ......................................... 127 Storing Data in the Text Box .................................................. ................................ 129 Using a Hidden Field for Persistence .................................................. ................. 130 Using a Session Variable to Store Data.............................................. .......................... 130 Starting the Session .................................................. ................................................ 133 Working with Session Data .................................................. .................................. 133 Using Sessions Well .................................................. ................................................ 134 Writing the Poker Dice Program........................................... ........................................ 135 Setting Up the XHTML............................................. ................................................. 135 Building the Main Code Body .................................................. .............................. 135 Starting Up the Game .................................................. ............................................ 136 Playing the Game .................................................. .................................................. .. 136 Creating the First Pass Output............................................ ................................... 137 Building the Second Pass Output............................................ .............................. 139 Creating the evaluate() Function .................................................. ........................ 142 Counting the Dice Values............................................ ............................................ 145 Counting Pairs, Twos, Threes, Fours, and Fives ................................................ 146 Looking for Two Pairs............................................. .................................................. 147 Looking for Three of a Kind and a Full House .................................................. . 147 Checking for Four of a Kind and Five of a Kind ................................................ 148 Checking for Straights .................................................. ........................................... 148 Cashing Out .................................................. .................................................. ............ 149 Summary........................................... .................................................. ................................ 150 Chapter 5 Better Arrays and String Handling.................... 151 Introducing the Word Search Program........................................... ............................ 151 Using the foreach Loop to Work with an Array............................................. ........... 153 Introducing the foreach.php Program .................................................. .............. 154 Creating an Associative Array............................................. ........................................... 155 Examining the assoc.php Program........................................... ............................ 156 Building an Associative Array............................................. ................................... 156 Building an Associative Array with the array() Function ............................... 158 Using foreach with Associative Arrays .................................................. .............. 159 Using Built-In Associative Arrays............................................ ....................................... 159 Introducing the formReader.php Program........................................... ............. 160 Reading the $_REQUEST Array .................................................. ............................ 160 Creating a Multidimensional Array............................................. ................................. 163 Building the HTML for the Basic Multidimensional Array ............................ 165 Responding to the Distance Query............................................. .......................... 166 x PHP 6/MySQL Programming for the Absolute Beginner Making a Two-Dimensional Associative Array............................................. .............. 169 Building the HTML for the Associative Array .................................................. .. 169 Responding to the Query............................................. ............................................ 171 Building the Two-Dimensional Associative Array ............................................ 172 Getting Data from the Two-Dimensional Associative Array.......................... 173 Manipulating String Values............................................ ................................................ 173 Demonstrating String Manipulation with the Pig Latin Translator ........... 173 Building the Form .................................................. .................................................. . 176 Using the split() Function to Break a String into an Array ............................ 176 Trimming a String with rtrim() .................................................. ........................... 177 Finding a Substring with substr() .................................................. ....................... 177 Using strstr() to Search for One String Inside Another ................................... 178 Using the Concatenation Operator .................................................. .................... 178 Finishing the Pigify Program........................................... ............................................... 179 Translating Between Characters and ASCII Values.......................................... 179 Returning to the Word Search Creator........................................... ............................. 179 Getting the Puzzle Data from the User .................................................. ............. 179 Setting Up the Response Page.............................................. .................................. 181 Working with the Empty Data Set............................................... ......................... 182 Building the Program’s Main Logic............................................. ......................... 182 Parsing the Word List.............................................. ................................................. 185 Clearing the Board .................................................. .................................................. 186 Filling the Board............................................. .................................................. ......... 187 Adding a Word .................................................. .................................................. ....... 189 Making a Puzzle Board............................................. ................................................ 195 Adding the Foil Letters........................................... .................................................. 196 Printing the Puzzle .................................................. ................................................. 197 Printing the Answer Key............................................... ........................................... 199 Summary........................................... .................................................. ................................ 200 Chapter 6 Working with Files............................................. ... 201 Previewing the Quiz Machine........................................... ............................................. 202 Entering the Quiz Machine System............................................ .......................... 202 Editing a Quiz.............................................. .................................................. ............. 202 Taking a Quiz.............................................. .................................................. .............. 203 Seeing the Results .................................................. .................................................. . 204 Viewing the Quiz Log .................................................. ............................................. 205 Saving a File to the File System............................................ .......................................... 205 Introducing the saveSonnet.php Program .................................................. ....... 205 Opening a File with fopen() .................................................. .................................. 207 Creating a File Handle .................................................. ........................................... 208 Examining File Access Modifiers......................................... .................................. 208 Writing to a File.............................................. .................................................. ......... 209 Contents xi Closing a File .................................................. .................................................. .......... 209 Loading a File from the Drive System............................................ .............................. 210 Introducing the loadSonnet.php Program........................................... .............. 210 Beautifying Output with CSS .................................................. ............................... 211 Using the “r” Access Modifier .................................................. .............................. 212 Checking for the End of the File with feof()............................................ ........... 212 Reading Data from the File with fgets() .................................................. ............ 212 Reading a File into an Array............................................. .............................................. 212 Introducing the cartoonifier.php Program........................................... ............. 213 Loading the File into an Array with file()............................................ ................ 214 Using str_replace() to Modify File Contents .................................................. ..... 214 Working with Directory Information....................................... ................................... 215 Introducing the imageIndex.php Program .................................................. ...... 215 Creating a Directory Handle with openDir()......................................... ............. 218 Getting a List of Files with readdir()......................................... ............................ 218 Selecting Particular Files with preg_grep() .................................................. ...... 219 Using Basic Regular Expressions....................................... .................................... 219 Storing the Output............................................ .................................................. ...... 221 Working with Formatted Text.............................................. ......................................... 222 Introducing the mailMerge.php Program........................................... ............... 223 Determining a Data Format .................................................. ................................. 223 Examining the mailMerge.php Code .................................................. ................. 224 Loading Data with the file() Command........................................... .................... 225 Splitting a Line into an Array and to Scalar Values ......................................... 226 Creating the QuizMachine.php Program........................................... ......................... 226 Building the QuizMachine.php Control Page.............................................. ...... 227 Editing a Test.............................................. .................................................. .............. 234 Taking a Quiz.............................................. .................................................. .............. 244 Grading the Quiz.............................................. .................................................. ....... 246 Creating an Answer Key............................................... ............................................ 247 Viewing the Log .................................................. .................................................. ..... 250 Summary........................................... .................................................. ................................ 251 Chapter 7 Writing Programs with Objects......................... 253 Introducing the SuperHTML Object............................................ ................................. 253 Building a Simple Document with SuperHTML......................................... ....... 254 Including a File .................................................. .................................................. ..... 255 Building the Web Page.............................................. ............................................... 256 Writing Out the Page .................................................. ............................................. 257 Working with the Title Property.......................................... ................................. 258 Adding Text and Tags with SuperHTML......................................... ..................... 259 Creating Lists the SuperHTML Way............................................... ....................... 262 Building More Specialized Lists............................................. ................................ 264 xii PHP 6/MySQL Programming for the Absolute Beginner Making Tables with SuperHTML .................................................. ......................... 264 Creating a Basic Table .................................................. ............................................ 266 Creating Super Forms .................................................. ............................................ 267 Building Drop-Down Menus............................................. ...................................... 269 Understanding OOP............................................... .................................................. ......... 271 Objects Overview .................................................. .................................................. ... 272 Creating a Basic Object .................................................. .......................................... 273 Adding Methods to a Class............................................. ......................................... 276 Reusing Class Files .................................................. .................................................. 280 Inheriting from a Parent Class .................................................. ............................ 282 Building the SuperHTML Class............................................. .......................................... 285 Overall Strategy .................................................. .................................................. ..... 285 Creating the Constructor .................................................. ...................................... 286 Creating the Bottom of the Page.............................................. ............................. 288 Adding Headers and Generic Tags.............................................. .......................... 288 Creating Lists from Arrays .................................................. .................................... 290 Creating Tables One Row at a Time.............................................. ........................ 292 Creating Forms............................................. .................................................. ............ 293 Building Basic Form Objects........................................... ........................................ 294 Building Select Objects .................................................. .......................................... 295 Responding to Form Input............................................. ......................................... 296 Summary........................................... .................................................. ................................ 296 XML and Content Management Chapter 8 Systems............ 299 Understanding Content Management Systems........................................... .............. 299 Examining Existing Content Management Systems ....................................... 300 Moodle............................................ .................................................. ........................... 301 WordPress......................................... .................................................. ......................... 301 Drupal............................................ .................................................. ............................ 302 Introducing simpleCMS......................................... .................................................. ........ 303 Viewing Pages from a User’s Perspective .................................................. .......... 303 Examining the PHP Code .................................................. ...................................... 305 Looking at the Header............................................ .................................................. 306 Viewing the CSS .................................................. .................................................. ..... 307 Inspecting the Menu System............................................ ...................................... 309 Looking at Content Blocks .................................................. .................................... 310 Improving the CMS with XML............................................... ......................................... 311 Introducing XML............................................... .................................................. ....... 311 Working with XML............................................... .................................................. ... 312 Understanding XML Rules .................................................. .................................... 312 Examining main.xml .................................................. ............................................. 313 Simplifying the Menu Pages............................................. ...................................... 314 Introducing XML Parsers........................................... .................................................. .... 314 Contents xiii Working with Simple XML............................................... ....................................... 315 Working with the simpleXML API .................................................. ...................... 315 Creating a simpleXML Object............................................ ..................................... 317 Viewing the XML Code .................................................. ........................................... 317 Accessing XML Nodes Directly .................................................. ............................. 318 Using a foreach Loop on a Node.............................................. .............................. 319 Manipulating More Complex XML with the simpleXML API......................... 319 Returning to XCMS.............................................. .................................................. ............ 323 Extracting Data from the XML File.............................................. ......................... 324 Summary........................................... .................................................. ................................ 325 Using MySQL t Chapter 9 o Create Databases..................... 327 Introducing the Adventure Generator Program........................................... ............ 327 Using a Database Management System............................................ ........................... 330 Working with MySQL............................................. .................................................. ......... 331 Installing MySQL 6.0............................................... .................................................. 331 Using the MySQL Executable........................................ .......................................... 331 Creating a Database.......................................... .................................................. .............. 333 Creating a Table............................................. .................................................. .......... 333 Working with String Data in MySQL .................................................. ................. 337 Creating a Primary Key .................................................. .......................................... 338 Using the DESCRIBE Command to Check a Table’s Structure ...................... 338 Inserting Values .................................................. .................................................. ..... 339 Selecting Results........................................... .................................................. ........... 340 Writing a Script to Build a Table............................................. .............................. 341 Creating Comments in SQL .................................................. .................................. 342 Dropping a Table .................................................. .................................................. ... 342 Running a Script with SOURCE............................................ ................................. 342 Working with a Database via phpMyAdmin........................................ ...................... 343 Connecting to a Server............................................ ................................................. 344 Creating and Modifying a Table............................................. ....................................... 345 Editing Table Data.............................................. .................................................. ..... 346 Exporting a Table .................................................. .................................................. .. 346 Creating More Powerful Queries........................................... ........................................ 350 Limiting Columns .................................................. .................................................. . 352 Limiting Rows with the WHERE Clause .................................................. ............ 353 Adding a Condition with a WHERE Clause .................................................. ...... 353 Using the LIKE Clause for Partial Matches .................................................. ....... 354 Generating Multiple Conditions .................................................. ......................... 354 Sorting Results with the ORDER BY Clause............................................ ............ 355 Changing Data with the UPDATE Statement......................................... ............ 356 Returning to the Adventure Game.............................................. ................................. 356 Designing the Data Structure .................................................. .............................. 357 Summary........................................... .................................................. ................................ 359 xiv PHP 6/MySQL Programming for the Absolute Beginner Connecting Chapter 10 to Databases within PHP................. 361 Connecting to the Hero Database.......................................... ....................................... 362 Getting a Connection .................................................. ............................................. 363 Choosing a Database.......................................... .................................................. ..... 365 Creating a Query............................................. .................................................. ......... 365 Retrieving the Data.............................................. .................................................. ... 366 Retrieving Data in an HTML Table............................................. ................................... 366 Getting Field Names .................................................. ............................................... 368 Parsing the Result Set .................................................. ............................................ 369 Returning to the AdventureGame Program........................................... ............ 370 Connecting to the Adventure Database .................................................. ............ 370 Displaying One Segment........................................... .............................................. 371 Retrieving the Room Number from the Form.............................................. ..... 375 Making the Data Connection .................................................. ............................... 376 Writing the buildButton() Function.......................................... ........................... 377 Finishing the HTML .................................................. ................................................ 378 Viewing and Selecting Records........................................... ........................................... 378 Editing the Record .................................................. .................................................. 381 Generating Variables......................................... .................................................. ..... 386 Printing the HTML Code.............................................. ............................................ 386 Creating the List Boxes .................................................. .......................................... 386 Committing Changes to the Database.......................................... ............................... 386 Summary........................................... .................................................. ................................ 389 Chapter 11 Data Normalization..................................... ......... 391 Introducing the spy Database.......................................... .............................................. 392 The badSpy Database.......................................... .................................................. ............ 392 Inconsistent Data Problems.......................................... .......................................... 393 Problem with the Operation Information....................................... ................... 394 Problems with Listed Fields............................................ ........................................ 394 Age Issues............................................ .................................................. ....................... 394 Designing a Better Data Structure......................................... ....................................... 395 Defining Rules for a Good Data Design............................................ ................... 395 Normalizing Your Data.............................................. .............................................. 395 First Normal Form: Eliminate Listed Fields .................................................. ..... 395 Second Normal Form: Eliminate Redundancies...................................... ......... 397 Third Normal Form: Ensure Functional Dependency ..................................... 398 Defining Relationship Types .................................................. ................................ 398 Recognizing One-to-One Relationships .................................................. ............. 399 Describing Many-to-One Relationships..................................... ........................... 399 Recognizing Many-to-Many Relationships..................................... ..................... 400 Building Your Data Tables............................................ .................................................. . 400 Contents xv Setting Up the System............................................ .................................................. 400 Creating the agent Table............................................. ............................................ 401 Inserting a Value into the agent Table .................................................. .............. 403 Converting birthday to age............................................... .............................................. 403 Introducing SQL Functions......................................... ............................................ 403 Finding the Current Date.............................................. .......................................... 404 Determining Age with DATEDIFF() .................................................. ..................... 404 Performing Math on Function Results .................................................. .............. 405 Converting Number of Days to a Date.............................................. ................... 406 Extracting Years and Months from the Date .................................................. ... 406 Concatenating to Build the age Field .................................................. ................ 407 Building a View.............................................. .................................................. .................. 407 Creating a Reference to the operation Table .................................................. ... 409 Building the operation Table .................................................. ............................... 409 Using a Join to Connect Tables .................................................. ............................ 411 Creating Useful Joins............................................. .................................................. . 411 Examining a Join without a WHERE Clause .................................................. .... 412 Adding a WHERE Clause to Make a Proper Join.............................................. .. 412 Adding a Condition to a Joined Query .................................................. .............. 413 Creating a View to Store a Join .................................................. ............................ 414 Building a Link Table for Many-to-Many Relationships..................................... ..... 415 Enhancing the ER Diagram .................................................. .................................. 416 Creating the specialty Table............................................. ...................................... 417 Interpreting the agent_specialty Table with a Query ..................................... 418 Building a View for the Link Table .................................................. ..................... 419 Summary........................................... .................................................. ................................ 420 Chapter 12 Building a Three-Tiered Data Application........ 421 Introducing the dbMaster Program........................................... ................................... 421 Viewing the Main Screen............................................ ............................................. 422 Viewing the Results of a Query............................................. ................................. 423 Viewing Table Data .................................................. ................................................. 424 Editing a Record .................................................. .................................................. .... 425 Confirming the Record Update .................................................. ........................... 425 Adding a Record............................................ .................................................. ........... 426 Processing the Add............................................... .................................................. ... 427 Deleting a Record .................................................. .................................................. .. 427 Building the Design of the SpyMaster System............................................ ............... 428 Creating a State Diagram........................................... ............................................. 428 The View Query Module............................................ ............................................... 429 The Edit Table Module .................................................. ........................................... 429 The Edit Record and Update Record Modules .................................................. . 429 The Add Record and Process Add Modules........................................... .............. 429 xvi PHP 6/MySQL Programming for the Absolute Beginner The Delete Record Module............................................ .......................................... 430 Designing the System............................................ .................................................. ......... 430 Why Make It so Complicated?...................................... .......................................... 430 Building a Library of Functions......................................... .................................... 431 Writing the Non-Library Code.............................................. .......................................... 432 Preparing the Database.......................................... .................................................. 432 Examining the spyMaster.php Program........................................... ................... 433 Creating the Query Form .................................................. ...................................... 433 Including the dbLib Library........................................... ......................................... 434 Connecting to the spy Database.......................................... .................................. 435 Retrieving the Queries .................................................. ........................................... 435 Creating the Edit Table Form.............................................. ................................... 435 Building the viewQuery.php Program........................................... ...................... 436 Viewing the editTable.php Program .................................................. .................. 439 Viewing the editRecord.php Program........................................... ...................... 440 Viewing the updateRecord.php Program........................................... ................. 441 Viewing the deleteRecord.php Program .................................................. ........... 443 Viewing the addRecord.php Program........................................... ....................... 444 Viewing the processAdd.php Program .................................................. .............. 444 Creating the dbLib Library Module............................................ ................................... 446 Setting a CSS Style............................................. .................................................. ...... 446 Setting Systemwide Variables......................................... ....................................... 446 Connecting to the Database .................................................. ................................. 447 Creating a Quick List from a Query............................................. ......................... 448 Building an HTML Table from a Query............................................. ................... 449 Building an HTML Table for Editing an SQL Table ........................................... 450 Creating a Generic Form to Edit a Record............................................ .............. 454 Building a Smarter Edit Form.............................................. .................................. 456 Determining the Field Type.............................................. ...................................... 458 Working with the Primary Key............................................... ............................... 459 Recognizing Foreign Keys .................................................. ..................................... 460 Building the Foreign Key List Box............................................... .......................... 461 Working with Regular Fields .................................................. ............................... 461 Committing a Record Update .................................................. .............................. 461 Deleting a Record .................................................. .................................................. .. 462 Adding a Record............................................ .................................................. ........... 463 Processing an Added Record .................................................. ................................ 465 Building a List Box from a Field............................................. ........................................ 466 Creating a Button That Returns Users to the Main Page................................ 467 Taking It to the Next Level............................................. ................................................. 468 Optimizing Your Data.............................................. ................................................ 468 Reusing the dbLib Module .................................................. .................................... 469 Summary........................................... .................................................. ................................ 469 Index............................................. ............................ 471 Code:
http://uploading.com/files/U5PAQKQV/PHP 6 MySQL Programming for the Absolute Beginner.rar.html  
      
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Programming for the absolute beginner by Yawn. | shooter | Video Training | 0 | 09-13-2009 01:22 PM |
| Programming for the absolute beginner by Yawn. | shooter | Video Training | 0 | 09-13-2009 07:31 AM |
| Harris, PHP 6/MySQL Programming for the Absolute Beginner | shooter | Technical Book | 1 | 06-13-2009 01:31 PM |
| Python Programming for the Absolute Beginner | aneemanee | Free Programing Ebook Download | 0 | 05-23-2009 10:58 AM |
| [Rapidshare.com] Harris, PHP 6/MySQL Programming for the Absolute Beginner | FED | Technical Book | 1 | 04-29-2009 09:40 AM |
Linear Mode
