Tutorials? MySQL connection with PHP and Bash!

John Hammond · Beginner ·🛠️ AI Tools & Apps ·14y ago
If you would like to support me, please like, comment & subscribe, and check me out on Patreon: https://patreon.com/johnhammond010 E-mail: johnhammond010@gmail.com PayPal: http://paypal.me/johnhammond010 GitHub: https://github.com/JohnHammond Site: http://www.johnhammond.org Twitter: https://twitter.com/_johnhammond

What You'll Learn

Connects to MySQL database using PHP and Bash scripts

Full Transcript

what's going on guys rude lanal here and um i'm bringing you a little bit more content i'm trying to show you some mysql database connection with php in this video and uh a little bit later on the video i actually tried it with object oriented programming um and that didn't really work out for me because uh i i'm not very good at oop yet i think i love that acronym oop that's so weird but and i really didn't think that was a good way to do to use it when you're trying to connect to a mysql database too because i mean the whole point of objects is so that you can you have a frame or like you have an instance that you can call back as many times as you want you can create multiple objects but you're never really going to do that with the mysql database i mean as far as i know a server administrator is only going to connect to his own his own server administration of like you know the mysql database so i thought it was kind of silly but i i tried to avoid that i showed another method in that and then after that i moved on to a little bit of some minecraft text processing because they have item ids in the game minecraft i don't know if you guys played or not it's a fun fun game it's a lot it's like it's a lot like a sandbox game when you go around you build stuff you kill monsters but i i really enjoy it i host i host a server on nullshell.com you can connect there it's since social.com is more of a web server um there is not a lot of ram and uh the server the minecraft server is gonna lag a whole lot if you actually play it but i'm gonna get more ram eventually trust me trust me on that one but other than that that's what i was working on the video i was trying to chop up some of the item ideas that you can use with the give command and uh on the on you're playing multiplayer and online stuff so i yeah i grabbed it off the wikipedia page you might see me doing that real soon i don't know if when it's gonna pop up it might have already i can't really watch the video i can't watch the video because kaden live um my computer is really not the fastest machine around so when i when i'm using caden live to edit these videos to speed them up and add my audio over them it is uh it is so slow when i try to play it back to try to play it back inside kitten live that the the time doesn't match up with when i'm recording and the time in the video so i it's just a big conundrum and i try to avoid it so uh back on task back on track whatever it is um yeah i was downloading it off the uh jeez i cannot think today i was downloading off the wikipedia page i think i grabbed a little bit out of there i think i just copied and pasted i would use links that uh the command line web browser but i don't know if i did or not actually i i really i'm so out of it because i tried to record a video just recently of me creating a script that will loop through a youtube playlist and download everything and i want to have that be content for you guys and i did it successfully from the command line and then i tried to build a script while i was making the video and uh it was a big fail like i was going at it for an hour and i still haven't figured it out it gave me so much of a hard time and i can't really think straight right now but other than that yeah i think that's all that happened in the video and i know that this is kind of silly because i'm i'm posting more videos about all the things that i'm doing now but i really should be attacking these tutorial videos the thing is i don't feel like i'm good at it like when i'm posting the videos uh i show you what i can do in these tutorials i mean is that good enough for you guys i watch all these other tutorial makers like the new boss and their metal x1000 for linux and stuff like those those are my shout outs i'm sorry i don't want to be name dropping or anything but uh those guys are really great and phenomenal in the videos that they do and i'm like man i can't do this this is just way too over my head it's not though i mean i i know if i keep pushing that i can make some really cool stuff for you but jeez it's crazy um other than that uh i'm gonna try and post some more content on those shells since i haven't done that i might put these code commentaries up these are still on youtube right now when i'm making this video and um i might do some game maker stuff i really want to play with some input boxes on there i haven't done anything with the gmgy suite if you've heard of that on my website nulshell.com i know that was a big deal up there uh and i'm thinking about making a forum uh but i want to make it from scratch i don't want to use like pro boards pro boards yeah yeah that's right pro boards are like uh yab yet another bulletin board bulletin v v bulletin yeah v bulletin that's what it is i think but i want to make it on my own with my sequel but i don't really know the best way to design that because let's see you have you have uh you have a field for you have a table for users for users that are registered and then you have another table that is full of categories the cat the form categories then you have another table that is boards boards that are in the categories and then inside the boards you have threads and inside each thread you have a post and each post corresponds with the user and it yeah i don't know how i'll be able to integrate that but i know php can do a lot of cool stuff with it so i'm sure i might be able to do it doing some work with javascript like i said i'm trying to turn that french project that i was working on into javascript i've been trying to avoid that recently i don't know i've been lazy i've been lazy i'm sorry guys but let's actually last last week just a few days ago i think it was uh the school that i'm that i attend actually was renovating over the summer and they're tearing down a building that i use and like the drama organization that i'm in uses so me and the crew went down there we tried to we tried to take everything out of there because it was a ton of stuff we spent maybe two days there and i got i got a couple s i got a couple scrapes i got beat up i didn't get beat up but i got some bruises some wood had fallen on me so my arm is a little bit of a mess but that's what that's keeping me busy there's a lot of stuff going on that's why i can't post so much content for you guys but trust me i'm trying i'm really trying i woke up today and i'm like hey man let's do something for these guys but yeah send me some questions i mean that'll give me inspiration just something to do i'm watching videos i'm trying to keep up with the community but there's just so much out there and so much we can you and i can do that sounds so cheesy but i'm running out of time here guys um 6 minutes 40 seconds you know but thanks for watching it'd be cool if you could comment rate subscribe all that stuff thanks guys bye
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from John Hammond · John Hammond · 2 of 60

1 Code Commentaries? PHP to JavaScript in Bash and PHP!
Code Commentaries? PHP to JavaScript in Bash and PHP!
John Hammond
Tutorials? MySQL connection with PHP and Bash!
Tutorials? MySQL connection with PHP and Bash!
John Hammond
3 Variable Naming in Python! Happy Birthday, Linux! Nokia N900!
Variable Naming in Python! Happy Birthday, Linux! Nokia N900!
John Hammond
4 JavaScript Splits The URL!
JavaScript Splits The URL!
John Hammond
5 HTML Tables in Python!
HTML Tables in Python!
John Hammond
6 HTML, Net Shares, GML!
HTML, Net Shares, GML!
John Hammond
7 Python 08 Programming Style and Comments
Python 08 Programming Style and Comments
John Hammond
8 Python 26 Object Oriented Programming
Python 26 Object Oriented Programming
John Hammond
9 75 Python Tutorials, Out Now!
75 Python Tutorials, Out Now!
John Hammond
10 Batch 14 Mathematical Expressions
Batch 14 Mathematical Expressions
John Hammond
11 Batch 85 Array Append
Batch 85 Array Append
John Hammond
12 Batch 86 Array Count
Batch 86 Array Count
John Hammond
13 Batch 87 Array Index
Batch 87 Array Index
John Hammond
14 Batch 88 Array Insert
Batch 88 Array Insert
John Hammond
15 Batch 89 Array Remove
Batch 89 Array Remove
John Hammond
16 Batch 90 Array Reverse
Batch 90 Array Reverse
John Hammond
17 Python [colorama] 00 Installing on Linux
Python [colorama] 00 Installing on Linux
John Hammond
18 Python [colorama] 09 Cursor Position
Python [colorama] 09 Cursor Position
John Hammond
19 Python [hashlib] 02 Algorithms
Python [hashlib] 02 Algorithms
John Hammond
20 Python 00 Installing IDLE on Linux
Python 00 Installing IDLE on Linux
John Hammond
21 Python [pygame] 11 Rectangular Collision Detection
Python [pygame] 11 Rectangular Collision Detection
John Hammond
22 Python [pygame] 12 Platforming Rectangular Collision Resolution
Python [pygame] 12 Platforming Rectangular Collision Resolution
John Hammond
23 Python [XML-RPC] 01 Research
Python [XML-RPC] 01 Research
John Hammond
24 Python [pyenchant] 03 Personal Word Lists
Python [pyenchant] 03 Personal Word Lists
John Hammond
25 FancyURLopener Authentication and User-Agent [urllib] 03
FancyURLopener Authentication and User-Agent [urllib] 03
John Hammond
26 Python 04: PEP8 Coding
Python 04: PEP8 Coding
John Hammond
27 Python Challenge! 17 COOKIES
Python Challenge! 17 COOKIES
John Hammond
28 Google CTF 2016: Ernst Echidna
Google CTF 2016: Ernst Echidna
John Hammond
29 Google CTF 2016: Spotted Quoll
Google CTF 2016: Spotted Quoll
John Hammond
30 Google CTF 2016: Can you Repo It?
Google CTF 2016: Can you Repo It?
John Hammond
31 Google CTF 2016: No Big Deal
Google CTF 2016: No Big Deal
John Hammond
32 Google CTF 2016: In Recorded Conversation
Google CTF 2016: In Recorded Conversation
John Hammond
33 Homemade CTF Challenge: 01 "Orchestra"
Homemade CTF Challenge: 01 "Orchestra"
John Hammond
34 Homemade CTF Challenge: 02 "Bae's Base"
Homemade CTF Challenge: 02 "Bae's Base"
John Hammond
35 Homemade CTF Challenge: 03 "Web Hunt"
Homemade CTF Challenge: 03 "Web Hunt"
John Hammond
36 Homemade CTF Challenge: 04 "UPX"
Homemade CTF Challenge: 04 "UPX"
John Hammond
37 Homemade CTF Challenge: 05 "The Assumption Song"
Homemade CTF Challenge: 05 "The Assumption Song"
John Hammond
38 Homemade CTF Challenge: 06 "A Brisk Stroll"
Homemade CTF Challenge: 06 "A Brisk Stroll"
John Hammond
39 Homemade CTF Challenge: 06 "I lost my password!"
Homemade CTF Challenge: 06 "I lost my password!"
John Hammond
40 web25 :: Mr. Robot : EKOPARTY CTF 2016
web25 :: Mr. Robot : EKOPARTY CTF 2016
John Hammond
41 web50 : RFC 7230 :: EKOPARTY CTF 2016
web50 : RFC 7230 :: EKOPARTY CTF 2016
John Hammond
42 misc50 : Hidden inside EKO :: EKOPARTY CTF 2016
misc50 : Hidden inside EKO :: EKOPARTY CTF 2016
John Hammond
43 Hack The Vote 2016 CTF: Sander's Fan Club [web100]
Hack The Vote 2016 CTF: Sander's Fan Club [web100]
John Hammond
44 Hack The Vote 2016 CTF Warpspeed [forensics150]
Hack The Vote 2016 CTF Warpspeed [forensics150]
John Hammond
45 Juniors CTF 2016 :: Black Suprematic Square
Juniors CTF 2016 :: Black Suprematic Square
John Hammond
46 Juniors CTF 2016 :: Six Strange Tales
Juniors CTF 2016 :: Six Strange Tales
John Hammond
47 Juniors CTF 2016 :: Lost Code
Juniors CTF 2016 :: Lost Code
John Hammond
48 Juniors CTF 2016 :: Here Goes!
Juniors CTF 2016 :: Here Goes!
John Hammond
49 Juniors CTF 2016 :: Southern Cross
Juniors CTF 2016 :: Southern Cross
John Hammond
50 Juniors CTF 2016 :: Clone Attack
Juniors CTF 2016 :: Clone Attack
John Hammond
51 Juniors CTF 2016 :: Dirty Repo
Juniors CTF 2016 :: Dirty Repo
John Hammond
52 Juniors CTF 2016 :: Hackers Blog
Juniors CTF 2016 :: Hackers Blog
John Hammond
53 Juniors CTF 2016 :: Voting!!!
Juniors CTF 2016 :: Voting!!!
John Hammond
54 Juniors CTF 2016 :: The Good, The Bad and The Junkman
Juniors CTF 2016 :: The Good, The Bad and The Junkman
John Hammond
55 Juniors CTF 2016 :: Stop Thief!
Juniors CTF 2016 :: Stop Thief!
John Hammond
56 Juniors CTF 2016 :: ROFL
Juniors CTF 2016 :: ROFL
John Hammond
57 Juniors CTF 2016 :: Restriced Area
Juniors CTF 2016 :: Restriced Area
John Hammond
58 Juniors CTF 2016 :: Oh SSH!
Juniors CTF 2016 :: Oh SSH!
John Hammond
59 HackCon CTF 2017 TRIVIA and BONUS Challenges
HackCon CTF 2017 TRIVIA and BONUS Challenges
John Hammond
60 HackCon CTF 2017 "Bacche" Challenges
HackCon CTF 2017 "Bacche" Challenges
John Hammond

Related AI Lessons

Up next
I Asked ChatGPT to Apply to 500 Jobs (8 Interviews in 48 Hours)
Sabrina Ramonov 🍄
Watch →