Inserting Data Into MySQL Database Relational Tables Using PHP

21
6



Upgrade your Clever Techie learning experience:

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:

Using MySQL insert and select statements, we’re going to be inserting all the data which we scraped from imdb.com and inserting it inside the relational database which has many to many relational tables. Inserting data into movies, stars, directors and genres is easy, what’s tricky is inserting the data into many to many relational tables and making sure the movies_id corresponds to the right star, director and genre.

““““““““““““““““““““““““““““““““““““““““““““““`
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:

This download (Patreon unlock) includes:
(MySQL database SQL cheat sheet, scrape IMDB function PHP source code, workbench movies relational tables SQL source code)
+
( 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! )

“““““““““““““““““““““““““““““““““““““““““““““““
( Website ) – PHP, JavaScript, WordPress, CSS, and HTML tutorials in video and text format with cool looking graphics and diagrams.

( YouTube Channel )

( Google Plus ) – clever techie video tutorials.

( Facebook )

( Twitter )

Nguồn: https://saesrpg.net/

Xem thêm bài viết khác: https://saesrpg.net/giai-tri/

21 comments

  1. Arunas Milasius 12 July, 2020 at 05:02 Reply

    @CleaverTechie, thanks for the training guides and scripts. this is really great tools and scripts to learn from applications. i do have 1 question if you have minutes as i can't get your scrape script to work as it throughs me Warning: array_merge(): Argument #1 is not an array in /Users/*******/LocalHost/scrape_imdb.php on line 153" u i was able to work through your initial scraping tutorial, but you are using a different script in this video and i just can't get it to scrap. any help would be very much appreciated. A.

  2. mac lanphere 12 July, 2020 at 05:02 Reply

    for the "many to many" tables you created, wouldn't it save storage space to create these as views, rather than new tables?

  3. زنبق الشام 12 July, 2020 at 05:02 Reply

    Awesome video.

    I heard you saying * means fetching all records, (at the beginning of your tutorial).

    Actually * asterisk means fetching all columns in the table.

    'Where' clause affects, whether or not you are fetching all rows.

    Just thought I needed to clarify this for the viewers benefit.

  4. MTA MOHAMMED 12 July, 2020 at 05:02 Reply

    Please post a video for Multi user database beck-end with MySQl Workbench and front-
    end with MS Access

  5. Lanka Rathnayaka 12 July, 2020 at 05:02 Reply

    Hello
    First of all thank You Very much for this awesome tutorial set on your playlist.I tried This tutorial and When I run I get an error on the scrape_imdb.php file.Which I copied from your web scraping tutorial

    Error
    Notice: Undefined variable: data in C:xampphtdocsphpdata insertscrape_imdb.php on line 153

    Warning: array_merge(): Argument #1 is not an array in C:xampphtdocsphpdata insertscrape_imdb.php on line 153

    Notice: Undefined variable: data in C:xampphtdocsphpdata insertscrape_imdb.php on line 153

    Warning: array_merge(): Argument #1 is not an array in C:xampphtdocsphpdata insertscrape_imdb.php on line 153

    here is the image of the error code line
    https://drive.google.com/open?id=16KHYDU1g22nvFWNgxPBN2GV07BzrpesB

    Any help

  6. jamietjeh 12 July, 2020 at 05:02 Reply

    i guess IMDB thanks you aswell for all the people you just tought on how to plunder their database and strech their bandwith lol i know youve warned them but ofc people will try and capture everything at once lol

  7. vKey 12 July, 2020 at 05:02 Reply

    Hi,
    Mate
    Love it you ROCK!
    I am new to PHP and have learned its fundamentals myself as i did not know about your channel before so now i have subscribed here and learning it feels like i am going to rip PHP like a pro, Thanks!

    Anyway how do you present these beautiful presentations before live coding previews?

  8. #TeamFlash 12 July, 2020 at 05:02 Reply

    My teacher is really shit. Having to source content on YouTube in order to know stuff. Between your previous videos and this I completely understand what I need to do. Thanks for bring born and learning your craft, the world needs more ppl like you

Leave a reply