Uploading.com PHP 6 MySQL Programming for the Absolute Beginner

roliviu · #1 (**permalink**) 07-24-2009, 08:45 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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	Programing Book	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

Welcome to the Free PDF Ebooks Download.

Download FREE EBOOK DOWNLAOD TOOLBAR

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)