Basic information of PHP and MySQL dynamic website development: Version 4th original title: PHP and MySQL for Dynamic Web Sites: Visual quickpro guide author: (US) larry ULLMAN: the name of the series by Du Kai CHEN zongbin: Turing Program Design Series Press: People's post and telecommunications Press ISBN: 9787115299406 published on: January 2013: 16 open pages: 1 version: 1-1 category: Computer
For more information, PHP and MySQL dynamic website development: Version 4th introduction books, computer books, PHP and MySQL dynamic website development: version 4th uses the task-based method to teach PHP and MySQL, uses a large number of images to guide readers to learn languages in depth, and shows readers how to construct a web site. It provides the fastest way to learn tasks and concepts with simple and intuitive steps and explanations. Through this book, readers can quickly and efficiently learn PHP and MySQL, and can immediately become a master who builds web sites! PHP and MySQL dynamic website development: Version 4th is applicable to Web application developers and suitable for beginners and middle-level readers. Directory PHP and MySQL dynamic website development: 4th chapter 1st PHP Overview 1 1.1 Basic Syntax 1 1.2 send data to Web browser 5 1.3 write comments 9 1.4 What is variable 12 1.5 introduction string 15 1.6 connection string 17 1.7 Number Introduction 19 1.8 constant Introduction 22 1.9 single quotes and double quotes 24 1.10 Basic Debugging steps 27 1.11 review and practice 28 1.11.1 Review 29 1.11.2 practice 29 Chapter 29 PHP programming 30 2nd creating html forms 30 2.1 Processing HTML Forms 34 2.3 condition statements and operators 38 2.4 verify form data 42. 2.5 introduction to array 47 2.5.1 create array 51 2.5.2 access array 52 2.5.3 multidimensional array 55 2.5.4 array sorting 60 2.6 for and while loop 63 2.7 review and practice 66 2.7.1 review 66 2.7.2 practice 67 chapter 3rd Creation dynamic Web site 68 3.1 contains multiple files 68 3.2 review HTML form 75 3.3 create sticky form 80 3.4 create your own function 84 3.4.1 create a function with parameters 86 3.4.2 set the default parameter value 90 3.4.3 return value from function 93 3.7 review and practice 98 3.7.1 Review 98 3.7.2 practice 98 chapter 4th MySQL Introduction 99 4.1 naming database elements 99 4.2 selecting column types 100 selecting other column attributes 4.3 4.4 Access MySQL 106 4.4.1 use MYSQL client 106 4.4.2 use phpMyAdmin 109 4.5 review and practice 113 4.5.1 Review 113 4.5.2 practice 113 chapter 5th SQL introduction 114 5.1 create database and Table 114 5.2 Insert record 118 5.3 select data 122 5.4 Use Condition Statement 124 5.5 use like and not like 128 5.6 sort Query Result 129 limit query result 5.7 132 update data 5.8 delete data 133 5.9 use function 135 5.10.1 text function 138 5.10.2 numeric functions 141 5.10.3 Date and Time Functions 143 5.10.4 formatting Date and Time 146 5.11 Review and practice 148 5.11.1 review 148 5.11.2 practice 149 chapter 6th Database Design 150 standardization 6.1 6.1.1 key 150 6.1.2 relationship 152 6.1.3 First paradigm 153 6.1.4 second paradigm 155 6.1.5 third paradigm 157 6.1.6 review design 159 6.2 create an index 161 6.3 use different table types 163 6.4 language and MySQL 165 6.5 time zone and MySQL 170 6.6 foreign key constraint 175 6.7 review and practice 180 6.7.1 review 180 6.7.2 practice Chapter 180 advanced SQL and MySQL 7th 181 execute join 7.1 7.1.1 join 181 7.1.2 Outer Join 182 7.1.3 join three or more table 188 7.2 group selected results 191 7.3 advanced selection 195 execute Fulltext lookup 7.4 7.4.1 create Fulltext index 200 7.4.2 execute basic Fulltext lookup 200 7.4.3 execute Boolean Fulltext lookup 202 204 query optimization 7.5 7.6 executing transactions 211 7.7 database encryption 214 7.8 review and practice 217 7.8.1 review 217 7.8.2 practice 218 chapter 8th error handling and debugging 219 8.1 error types and Basic Debugging Methods 219 8.1.1 Basic Debugging steps 221 8.1.2 debug HTML 224 8.2 display PHP error 226 8.3 adjust error reports in PHP 228 create a custom error handler 8.4 232 PHP debugging technology 8.5 236 SQL and MySQL debugging technology 8.6 8.6.1 debug SQL Problems 240 8.6.2 debug access problems 241 8.7 review and practice 241 8.7.1 review 241 8.7.2 practice 242 chapter 9th Use PHP and MySQL 243 9.1 modify template 243 9.2 connect to MySQL 245 9.3 execute simple query 249 search query Results 257 9.5 ensure SQL Security 262 9.6 statistics returned records 266 9.7 Use PHP update records 268 9.8 review and practice 274 9.8.1 review 275 9.8.2 practice 275 Chapter 10th common programming technology 276 10.1 send to scripts value 276 10.2 use a hidden form input box 280 10.3 edit an existing record 286 10.4 mark the page number of the query result 293 10.5 create a sorted display result 300 10.6 review and practice 305 10.6.1 review 305 10.6.2 practices 306 Chapter 2 Web Application Development 11th 307 send email 11.1 307 process File Upload 11.2 11.2.1 Allow File Upload 313 11.2.2 Use PHP to upload files 313 319 PHP and JavaScript 11.3 11.3.1 create Javascript file 325 11.3.2 create PHP script 329 11.4 understand HTTP header 332 Date and Time Functions 11.5 339 review and practice 11.6 11.6.1 review 343 11.6.2 practice 343 Chapter 343 cookie and session 12th 345 create login page 12.1 345 create Login function 348 12.3 use cookie 353 12.3.1 set cookie 354 12.3.2 access cookie 358 12.3.3 set cookie parameter 12.3.4 Delete cookie 363 12.4 use session 367 12.4.1 set session variable 368 12.4.2 Access session variable 370 12.4.3 Delete session variable 373 12.5 improve Session Security 376 12.6 review and practice 379 12.6.1 review 379 12.6.2 practice 379 chapter 13th security methods 381 13.1 block spam 381 13.2 pass type verification data 388 13.3 verify files by type 394 13.4 prevent XSS attacks 398 13.5 use filter extensions 401 13.6 prevent SQL injection attacks 405 13.7 review and practice 412 13.7.1 review 412 13.7.2 practice 412 chapter 14th Perl Compatible Regular Expressions 414 14.1 create test script 414 14.2 defining simple mode 419 14.3 using quantifiers 422 14.4 using character classes 424 14.5 finding all matches 427 14.6 using modifiers 432 14.7 matching and replacement modes 434 14.8 review and practice 438 14.8.1 review 438 14.8.2 practice 438 chapter 15th jquery Introduction 439 15.1 what is jquery 439 contains jquery 15.2 441 use jquery 15.3 444 Select page elements 15.4 446 event processing 15.5 449 Dom operations 15.6 453 use Ajax 15.7 15.7.1 create a form 459 15.7.2 create server script 461 15.7.3 process Ajax request 462 15.7.4 create javascript 464 15.8 review and practice 470 15.8.1 review 470 15.8.2 practice 470 chapter 16th introduction to object-oriented programming 472 16.1 basic knowledge and syntax 472 16.1.1 object-oriented basics 472 OOP syntax 473 in PHP 16.2 475 use MySQL 475 16.2.1 to create a connection 478 16.2.2 execute a simple query 482 16.2.3 get results 486 16.2.4 preprocessing statement 16.3 490 datetime class 16.4 Review and practice 497 16.4.1 review 497 16.4.2 practice 498 chapter 17th example -- Forum 499 17.1 database creation 499 writing template 17.2 508 index creation page 17.3 Forum creation page 516 creation argument page 17.4 517 release message 526 17.6.1 create form 526 17.6.2 process form 531 review and practice 17.7 17.7.1 review 537 17.7.2 practice 537 chapter 538 example -- User Registration 18th 539 create template 18.1 write configuration script 539 18.2.1 create Configuration file 545 18.2.2 create database script 549 18.3 create homepage 553 register 18.4 554 activate account 18.5 564 login and logout 18.6 567 password management 18.7 18.7.1 Reset Password 573 18.7.2 Change Password 573 578 review and practice 18.8 18.8.1 review 583 18.8.2 practice 583 chapter 19th example -- e-commerce 584 19.1 database creation 584 Management Terminal 19.2 19.2.1 add artist 590 19.2.2 add print 591 596 create public template 19.3 606 product catalog 19.4 609 shopping cart 621 19.5.1 add project 621 19.5.2 view shopping cart 625 record order 19.6 631 review and practice 19.7 19.7.1 review 637 19.7.2 practice 637 source of this book: china Interactive publishing network
