What this chapter covers:

  • Creating MySQL user accounts
  • Creating a new database
  • Defining a database table
  • Choosing the right column type
  • Using MySQL, MySQLI, and PDO to query a database

When I first started working with databases, one of the greatest frustrations was that all the books and online tutorials I consulted assumed that you already knew the basics of database design and construction, or—if you didn't—that you planned to use Microsoft Access. MySQL is very different from Access, which is intended for use in small office environments. MySQL is not only fast and multiplatform; it's capable of handling a high number of simultaneous connections without any perceptible loss of performance. The differences ...

Get PHP Solutions: Dynamic Web Design Made Easy now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.