PHP MySQL in DreamHost Tutorial 4 – phpMyAdmin Video Tutorial DreamHost

PHP MySQL in DreamHost Tutorial 4 – phpMyAdmin

Tutorial Hosting
Welcome everybody to Caleb the video maker to this series is about installing PHP and MySQL in DreamHost so where did we leave off well in the last videos we created a database we set up a domain and we learned about File Transfer Protocol but we actually still

Have to create a table for our database so if we go to goodies MySQL databases we can see that we have some stuff in here already we have one database and how do we actually go in here to you know create stuff well we use a tool

Called PHP my admin’ which is a very popular tool that is used to manage your data inside of a database the very nice tool so it’s it’s a good thing to learn so to access that you click this link right here PHP myadmin now a couple of videos ago when we set

Up this database I told you there was a bunch of important stuff you need to remember well this is where that stuff comes in useful and it will come in useful later too so you need to put in your user name for your database and your password and then

When you’re ready click go so this is PHP myadmin if you’ve never seen it before trust me it’s not that confusing all you got to do is click databases up here this will show you the databases you have already and we have this PHP MySQL tutorial 1 which that is the database we

Created in the other video and you can see here we can create a table here by naming it and giving it a number of columns but I prefer to do everything the old-fashioned way so we’re going to actually write some SQL commands here so I’m going to type out the command and

Then I’ll explain it to you guys all right so here’s what we want we’re going to create a table named tutorials and it’s gonna have two columns one is the ID and the other one is the title now the ID is just an automatically generated number that is just for the

Databases use that’s why it’s labeled as the primary key down here the title is something we’re going to put in so we give that varchar’ so that means we can use anywhere from 0 to 100 characters to give the tutorial a title so let’s see if it works let’s click go

Awesome it worked so how do we actually input data into this table well let’s run another command we want to insert into tutorials table into the title column and we’re going to put these as four rows notice how we don’t have to put the primary key that’s done

Automatically so let’s run this and see if it works great it worked so how do we know it worked besides that it said it worked you can run another SQL command and the command is really simple select everything from tutorials so here’s our data and we have the ID and the title

Great so that’s an introduction to PHP myadmin hopefully that was helpful for you guys now that you have data in PHP myadmin we can start working in PHP to try to get that data displayed on a web page thanks and I’ll see you guys in the next video

Welcome back to Caleb the video maker – this is the series of installing MySQL and PHP on DreamHost so where are we exactly we are in FTP through FileZilla and we’re connected to our website as you can see I’m actually using the domain name PHP
Start your career as a software developer – https://calcur.tech/dev-fundamentals 💯 FREE courses (100+ hours) – https://calcur.tech/all-in-ones 🐍 Python course – https://calcur .tech /python-courses ✅ Data Structures and Algorithms – https://calcur.tech/dsa-youtube ~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~ ~ ~~ ✉️ Newsletter – https://calcur.tech/newsletter 📸 Instagram – https://www.instagram.com/CalebCurry 🐦 Twitter – https://twitter.com/calebCurry 🔗 LinkedIn – https://www. linkedin .com/in/calebcurry ▶️ Subscribe – http://calcur.tech/subscribe 👨🏻‍🎓 Courses – https://www.codebreakthrough.com ~~~~~~~~~~~~~~ SUPPORT ME ~ ~~~~~~~~~~~~~ ↪ My Amazon Store – https://www.amazon.com/shop/calebcurry 🅿 Patreon – http://calcur.tech/patreon-calebcurry 🅖 GitHub Sponsors – https ://github.com/sponsors/CalebCurry Ⓟ Paypal – http://paypal.me/calcur 🅑 Bitcoin – 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq 🅔 Eth – 0x350139af84b60d075a3a0379716040b63f6D3853 📈 Buy Bitcoin – https://calcur.tech/crypto Reserve the Ruby Steel -Crypto Rewards Card and get a $25 bonus (use affiliate code “Caleb”) – https://calcur.tech/crypto
#PHP #MySQL #DreamHost #Tutorial #phpMyAdmin


https://i.ytimg.com/vi/SnBybxdqSZ0/hqdefault.jpg