logo

Query Your MySQL Database Using SELECT w/ PHP PDO - The PHP script & MYSQL Query

Build a web form that accepts user input, passes it to a PHP server page to query a MySQL database and get a result set. Loop through the result set and populate a HTML table with live data from your database.

5 Videos In This Series

Runtime: 10:07

Create Your First MySQL Database on IONOS Web Hosting (1/5)
Use IONOS web hosting to create your first MySQL Database in minutes! In our example we create a music catalog with various tables, relationships and more. Watch Now

MySQL IONOS PHPMyAdmin

Runtime: 13:00

Create MySQL Database Tables in PHPMyAdmin on IONOS Web Hosting (2/5)
Create tables in your database with columns of various data types. Relate those tables with Foreign Keys and write custom queries to join those tables together into one dataset. Watch Now

IONOS PHPMyAdmin MySQL

Runtime: 14:14

Import CSV or Text File data into MySQL Database with PHPMyAdmin on IONOS (3/5)
Simple tutorial showing how to take a simple Excel file, export it as comma separated values and then import that data file into your IONOS hosted MySQL database using PHPMyAdmin Watch Now

MySQL PHPMyAdmin

Runtime: 12:56

Query Your MySQL Database Using SELECT w/ PHP PDO - Building The Web Form & UI (4/5)
Setting Up The Web Form and Table HTML to Allow for User Search Input Watch Now

-- NOW PLAYING --

Runtime: 29:38

Query Your MySQL Database Using SELECT w/ PHP PDO - The PHP script & MYSQL Query (5/5)
Take user input and run it against your MySQL Database to return a set of results. Watch Now