Тёмный

Inserting Data Into MySQL Database Relational Tables Using PHP 

Clever Techie
Подписаться 102 тыс.
Просмотров 77 тыс.
50% 1

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
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:
/ inserting-data-20819049
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 ) clevertechie.com - PHP, JavaScript, Wordpress, CSS, and HTML tutorials in video and text format with cool looking graphics and diagrams.
( RU-vid Channel ) / clevertechietube
( Google Plus ) goo.gl/J71p6f - clever techie video tutorials.
( Facebook ) / clevertechie
( Twitter ) / theclevertechie

Хобби

Опубликовано:

 

5 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 43   
@vince2nd
@vince2nd 7 лет назад
My teacher is really shit. Having to source content on RU-vid 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
@user-mo9tc4jk4w
@user-mo9tc4jk4w 5 лет назад
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.
@Xessoriez
@Xessoriez 7 лет назад
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?
@aaronely759
@aaronely759 6 лет назад
You are a good teacher
@AriannaEuryaleMusic
@AriannaEuryaleMusic 7 лет назад
Thank you for sharing and teaching, very useful information indeed.
@clevertechie
@clevertechie 7 лет назад
Thank you Euryale, I'm glad you found it useful.
@klarabelkostas8378
@klarabelkostas8378 2 года назад
You are simply amazing teacher !!
@clevertechie
@clevertechie Год назад
Thank you very much :)
@webDLabs
@webDLabs 6 лет назад
I like your tutorials. would like to make tutorails on advanced curl using php
@stefan4800
@stefan4800 7 лет назад
Your videos are so pretty! I'm enjoying just watching them! And your site is pretty as well! Pretty and simple. You put some very useful lessons from mmtuts, which is very good channel as well. And thank you for a book! The book is pretty as well, I would read it just because it's pretty, not to mention it's very useful and practical.
@clevertechie
@clevertechie 7 лет назад
Thank you! I'm glad you enjoy these videos and think the content is pretty :) I'm trying to make programming as fun as possible by incorporating as many cool looking visuals as I can.
@roeunchamnab3208
@roeunchamnab3208 6 лет назад
thank you idol
@wahabaliashraf2096
@wahabaliashraf2096 6 лет назад
When i execute this code on localhost it display a blank page whats the reason of it?
@soneknd631
@soneknd631 7 лет назад
Hi Bro. what does name this program use creat source code?
@arunasmilasius3550
@arunasmilasius3550 4 года назад
@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.
@aartavazd
@aartavazd 3 года назад
why would you insert your unvalidated valu directly into an SQL? it is not safe! your code can be hacked and your sql can be hacked. why don't you use prepared statement?
@arlandmichelenavillegas3753
@arlandmichelenavillegas3753 7 лет назад
this is so good.. thank you
@devoncyrus7708
@devoncyrus7708 3 года назад
you probably dont give a shit but if you're stoned like me during the covid times then you can watch pretty much all of the new series on InstaFlixxer. Been watching with my gf during the lockdown :)
@dwaynecollin4669
@dwaynecollin4669 3 года назад
@Devon Cyrus yup, have been using InstaFlixxer for months myself :D
@galwaygirl5609
@galwaygirl5609 3 года назад
how would you do this using a CSV datadset?
@maclanphere5674
@maclanphere5674 5 лет назад
for the "many to many" tables you created, wouldn't it save storage space to create these as views, rather than new tables?
@bhushanramse2894
@bhushanramse2894 7 лет назад
please make tutorials on java technology..
@gowthams8340
@gowthams8340 6 лет назад
Please post more videos about php tutorials
@clevertechie
@clevertechie 6 лет назад
Okay, for sure brother
@chanthykeo400
@chanthykeo400 7 лет назад
Hello brother. can you send the source code me. I need the source code create project.
@danishimels6925
@danishimels6925 2 года назад
please upload the database data set
@webstuff56
@webstuff56 6 лет назад
you do a great job! Are you still active?
@jamietjeh
@jamietjeh 6 лет назад
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
@mtamohammed8519
@mtamohammed8519 5 лет назад
Please post a video for Multi user database beck-end with MySQl Workbench and front- end with MS Access
@Xessoriez
@Xessoriez 7 лет назад
Hi, First of all, I would like to say thank you so much for making wonderful videos and i personally love your way of teaching, explaining and visualizing lessons, Awesome! Secondly, I would like to know how do you make these tremendous looking cool videos and which tools you use to show your codes in an appropriate way, thumbs up! OK, from now on i wanna share something personal with you regarding my perspective about "Programming". I am a well versed HTML & CSS Developer and also know WordPress and Blogger platforms very well. I like back-end programming a damn lot and my favorite language is "PHP". I started to learn PHP but unfortunately due to tight timing of my Job i couldn't carry it on and focused on it. Even since i have found your utube channel and watched your videos i hit SUBSCRIBE because you deserve it. When i see a pile of programming code done with php i kind of fear like i can never do it so as an expert what are your suggestions and advise to me like can i ever be able to code like you in PHP and would i be able to understand Programming somehow. Reply would be highly appreciated, thanks in advance! Apologize for long comment, lol
@clevertechie
@clevertechie 7 лет назад
You're very welcome and thank you for your kind words. The code can be very intimidating to look at, just take it one step at a time and learn basics first, eventually you will start understanding things and writing a bunch of code won't be a problem for you. It takes practice and experience to get good at it.
@Xessoriez
@Xessoriez 7 лет назад
Clever Techie thanks!
@jamietjeh
@jamietjeh 6 лет назад
dont forget to lookup the syntax if you are not sure on how to use it or on how to resolve errors. even the most skilled coders have "cheat sheets" they look at or syntax sheets so dont think for a second that you absolutely have to memorize each and every one of em
@ofeyofey
@ofeyofey 4 года назад
SQL source code is no longer available for free on Clever Techie :(
@yentsvanloock1716
@yentsvanloock1716 4 года назад
It's sad that they start to wall off stuff that was free first... I don't mind walling off the new stuff after you switched to patreon... But walling off stuff that was free for your followers before is just a dick move... sad
@Belissimo-T
@Belissimo-T 3 года назад
@@yentsvanloock1716 use the wayback machine lol
@freyja8849
@freyja8849 2 года назад
yo i cant even access to the code? the website didn't even work properly
@ripper_op5442
@ripper_op5442 2 года назад
Your video is not SEO optimized. Btw thanks for tutorial
@heeragulshan1213
@heeragulshan1213 4 года назад
clever techie.com does'nt work perfectly today
@_stevek
@_stevek 5 лет назад
For the love of god someone teach this guy how to say gross - /ɡrōs/
Далее
How to Insert Images into MySQL Database
17:55
Просмотров 20 тыс.
Make Up with Balloons 💄☺️🍓
00:23
Просмотров 3,2 млн
Web Scraping Using PHP - Parse IMDB.com Movies HTML
27:46
inserting data into two db tables using php
22:00
Просмотров 25 тыс.
Learn SQL In 60 Minutes
56:24
Просмотров 2 млн
Create MySQL Database - MySQL Workbench Tutorial
17:16
Просмотров 622 тыс.
SQL Tutorial for Beginners [Full Course]
3:10:19
Просмотров 11 млн
PHP cURL Tutorial - Learn PHP Programming
13:54
Просмотров 154 тыс.
Js chart  using php and mysql extremely easy example.
7:15
Save HTML Form Data to a MySQL Database using PHP
24:38
PHP Regular Expressions Tutorial
14:50
Просмотров 45 тыс.
Fetch JSON Data & Insert into Mysql table in PHP
5:52
Ноги После 160км
0:18
Просмотров 998 тыс.
Ноги После 160км
0:18
Просмотров 998 тыс.
easy game filter 😎
0:12
Просмотров 7 млн