MySQL PHP Tutorial - Select & Display Data From MySQL Tables

Опубликовано: 03 Ноябрь 2024
на канале: Clever Techie

29,897

376

Upgrade your Clever Techie learning experience:
  / clevertechie

UPDATE! (9/13/19) New features and improvements for Clever Techie Patreons:

1. Download full source code with detailed comments - easy to learn and understand code
2. Weekly source code file updates by Clever Techie - every time I learn new things about a topic I will add it to the source file and let you know about the update - keep up with the latest coding technologies
3. Library of custom Clever Techie functions with descriptive, easy to understand comments - skyrocket coding productivity, code more efficiently by using Clever library of custom re-usable functions
4. Syntax code summary - memorize and review previously learned code faster
4. Organized file structure - access all Clever Techie lessons, source code, graphics, diagrams and cheat sheet from a single workspace - no more searching around for previously covered material and source code - save enormous amount of time and effort
5. Outline of topics the source file covers - fast review of all previously learned coding lessons
6. Access to all full HD 1080p videos with no ads
7. Console input examples - interactive examples that make it easier to understand and learn coding
8. Access to updated PHP Programming Book by Clever Techie
9. Early access to Clever Techie videos

Subscribe to Clever Techie patreon:
  / clevertechie

````````````````````````````````````````````````````````````````````````````````````````````` This MySQL PHP tutorial is suitable for beginners as well as advanced MySQL users. In this lesson we mostly cover selecting data from the tables as well as relational tables and then displaying the data in a nicely formatted HTML with CSS. What's important to understand when making queries and getting back results from the SELECT statements in MySQL is that we're working with objects which have their unique properties and methods.

`````````````````````````````````````````````````````````````````````````````````````````````
Hey guys, I'm now using Patreon to share improved and updated video lesson material. For a small fee you can access all the downloadable files from this lesson (source code, icons & graphics, cheat sheets) and everything else included in the video from the Patreon page. Additionally, you will get access to ALL Clever Techie videos in HD format with no ads. Thank you so much for supporting Clever Techie :)

Download this video's files here:
  / mysql-php-select-20819050

This download (Patreon unlock) includes:
(movies database sql dump file, php select & display source code, MySQL workbench table structure diagram, style.css, readme.txt)
+
( You also get access to ALL source code and any downloadable content of ALL Clever Techie videos, as well as access to ALL videos in HD 1080p quality format with all video ads removed! )

``````````````````````````````````````````````````````````````````````````````````````````````

A method called fetch_assoc() for example of MySQL result object, works in a unique way because whenever called it keeps getting the next row result of the SELECT statement query which was previously loaded with the MySQL object query() method. By understanding how objects work and where these methods come from, you will get a clear picture of how to work with MySQL data, so you can select and show everything from the MySQL database that you ever want. You will also get a good understanding of how to display all the data returned from MySQL with PHP and integrate the code into HTML by learning from this MySQL PHP tutorial.

``````````````````````````````````````````````````````````````````````````````````````````````
( Website ) https://clevertechie.com - PHP, JavaScript, Wordpress, CSS, and HTML tutorials in video and text format with cool looking graphics and diagrams.

( YouTube Channel )    / clevertechietube

( Google Plus ) https://goo.gl/J71p6f - clever techie video tutorials.

( Facebook )   / clevertechie

( Twitter )   / theclevertechie