MySQL For Beginners - Tutorial 1 - Introduction to Basics

[manioz]

Its really great for the beginners..good on you

[MsKoko144]

Very good !

Thank you !

[bmnccrazed]

:| derp

[NJHeart2Heart]

Flash4real,

I'm not even two minutes into it and you've lost me! I have a mac, have no idea what wampserver is or how you created your file! I have a beginners idea about html and that's about it. I'm interested in learning how php and MySQL interact in the context of a website, spefically, it's been used in websites that do simulation games... Do you or anyone else have videos that work as prequels to your "sequel" videos? (ha.. thought that was cute myself!) :)

[SpeezCraftGaming]

@NJHeart2Heart Hey, i also running a mac. You should download MAMP server instead! That's exactly like the WAMP server. So just install that and set you preferences. Then log on you localhost and do like hes doing! //MangoSlicer :D

[NJHeart2Heart]

@SpeezCraftGaming

Thanks!! The rest of it wasn't so difficult to understand, but getting started was the bugger for me :)

[flash4real]

@NJHeart2Heart See my PHP videos on my channel.

[007redheat]

@NJHeart2Heart if you have mac, used download and install MAMP instead of WAMPserver.

[alaminpabna1987]

hi,

SEO totorial site URL........

LazyCash24

[GemsterLOL]

can you use this for minecraft bukkit servers coz you need MySQL for most the plugins

[owlsandlions]

@GemsterLOL Yes you can but I am still confused on how it works. if you find out let me know.

[GemsterLOL]

@owlsandlions im not sure dude its blowing way over my head lol!

[myhueta]

crippi teacher. reading a book.

[piszo15]

I can't find that website!Please send for me the URL!

[flash4real]

@piszo15 bit(dot)ly/mysql_1

[RebornXSoldier]

Awesome video! Really great tutorial. Thanks for all the help!

[MultipleSolutionsENT]

Exceptional and intuitive!

[AnotherRandomViewer]

Excellent video thanks, but there's one thing I don't understand; you seem to know what you're talking about, than why do you say "sequel"? Instead of just SQL? (Structered Query Language)

[brentwallac]

@AnotherRandomViewer I think it's his accent dude.

[flash4real]

@AnotherRandomViewer You can pronounce it both ways. I prefer "sequel". Perhaps because it's a syllable shorter.

[RebornXSoldier]

@flash4real I prefer S-Q-L because that's what the letters are, it is an acronym and there aren't any vowels in it, so it would be more reasonable to phonetically pronounce it "sk'l" which, of course, sounds awful, and if someone didn't know it was spelled S-Q-L and you were calling it sequel, they wouldn't know that asking what the letters stood for was an option or which letters were in the acronym. The last part may not occur very often, but even once would be bad enough. No big deal though!

[jnb03c]

@AnotherRandomViewer I've found that Oracle SQL is usually pronounced "sequel" and MySQL is usually "S-Q-L"

I end up calling everything "sequel" as well, but I'm a GIS analyst and don't use Oracle or MySQL as regularly

[TheTnbReport]

thanks man worked great

[bmxtricky5]

help i keep getting the error Call to undefined function mysql_connect() heres my code $connect = mysql_connect("localhost","use­r","");

if($connect) { echo "Connected!";

} else { echo "Fuck";

}

[flash4real]

@XxCodGodxX2 You'll need a text editor like Notepad++, and Photoshop. You'll need a knowledge of PHP, Javascript, and FBML. I think you're under-exaggerating the size of this project.

[XxCodGodxX2]

@flash4real

I kneew its going to take alot of time. I have a text editor(Komodo Edit) Do i need to create a database to keep all the stories that the users send.Do you have any videos for FBML. Thank you.

[flash4real]

@XxCodGodxX2 Yes. No.

[XxCodGodxX2]

@flash4real

okay thanks for your help



[Wassouf10]

thnx dude

[AlliedCeaser]

Cant log in to phpmyadmin web page thing.........

[Seandrew0]

this is great and all but this really helped me when i started out:

Link: 65b50gm)c1e)q)z)b)r2ox)k0e)o)d­ie)c)v).hop.click)bank.)net/?t­id=SUN41212

just remove the brackets.

[galaxymariosuper]

good job - keep on!

[Diebrox]

"You don't have permission to access /phpmyadmin/ on this server." Help?

[flash4real]

@Diebrox Go to C:\wamp\alias. Open the file phpmyadmin.conf and add

Options Indexes FollowSymLinks MultiViews

Allow Override all

Order Deny,Allow

Deny from all

Allow from 127.0.0.1

Allow from MACHINE_IP

[XxCodGodxX2]

@flash4real

Im new to web designing and i want to create a website like Fmylife.com. A website that has usere generated content. I wanted to ask you if you can tell me all the programs i need. BTW i have a mac and i want to work on the site on my mac if there are no programs then i can work on my PC. And i wanted the user to login through facebook, so i dont have to worry about creating a Login system. Please help me. Thank you.

[brentwallac]

@XxCodGodxX2 The guy isn't a tutor - go learn a course or do the leg work yourself. Christ - read a book.

[cobolt95]

Hi, I followed this exactly (I am fairly sure) and it echo's problem. How does the php know what db to connect to? I have multiple in there already for phpbb and wordpress.

[cobolt95]

@cobolt95 actually I got it. Pretty good tutorial, thanks. Subscribed and liked :)

[okush69]

i wanna learn a programming lang that is easy to learn, has many functions and is used by many websites and developers. i know html and css, and a little bit of JAVA, but its not very useful to use JAVA in an html website. i dont wanna waste my time learning it then know that its useless... and also is php and mysql related? what other languages would i have to learn to make a good fully functioning website? thanks from now. and by the way localhost didnt work for meh, could you help me witthat?

[soetjeislief]

Very nice video! And also easy to learn I did this because I later xammp with a host but I wanted to go buy first learn to use phpmyadmin: D

[seeyditti]

what do i do with the index.php file that you created?

[dphjirpeeps]

Thank you so much!  This is great!

[MrAlancurrall]

Hi,

Could really do with the MySQL part two video. All PHP videos on your website are fantastic.

Many thanks,

Alan.

[ShErDdEr100]

It's prounouced 'my ess que ell'. Sorry I'm just being finickity haha

[nacarioanjun]

very helpful

[hamidrezashamloo]

Hi, I get these errors:

If field type is "enum" or "set", please enter the values using this format: 'a','b','c'...

what do I wrong?

Best regards

[mynewmedia]

I'm using MAMP and all went well, until I tried to open the php file in a browser. I have the index.php file on my desktop. When I drag it over firefox icon to open in the browser, I get the message that "Firefox is already open", and when I drag it over the Safari icon, it opens as the coding

Can you tell me what I'm doing wrong? thanks.

[MrClaudioborn]

I still don't quite get how php links to the database. For example, why, to test, you use localhost/tut1? if the database wasn't named tut1, there is no folder made named tut1, and there is no way to create the database in x or y folder.

[flash4real]

@MrClaudioborn I created the folder "tut1" to store the PHP files in. The folders have nothing to do with the database. The important thing is that Apache (the framework that lets you run PHP) is linked to the database system. Once Apache and the database system are linked, you can call database functions from your php files.

As long as PHP is able to run, the folder location and name do not affect how the database behaves. Have I answered your question?

[MrClaudioborn]

@flash4real yes, sir! I was somewhat confused but some hands-on took away many of those doubts. THANKS for the video. It's of great help!!!

[Bhimbim021107]

sorry, but may i ask you something, my username is root, can i change it ?, or should i reinstall mysql ?, thanks, your video was really helpful : D,

i'm waiting your reply : ).

[flash4real]

@Bhimbim021107 The root username cannot be changed. The root user is like the god of all databases. Instead, try creating a new user with whatever name you want, and give it all privileges.

[Bhimbim021107]

@flash4real hmm okay, buat if i really want to change it, i must reinstall it right ?, now i'm having another problem about foreign key, it's quite difference than mysql server 2005 : (.

[jsmith19810808081]

@flash4real That's not strictly true you can remove the root user after adding your own custom user, like so:

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'localhost' WITH GRANT OPTION;

DROP USER root@localhost

FLUSH PRIVILEGES;

[HybridApok]

how do i open what i saved in notepad++ with the browser...

[DrymR]

Thank you I appreciate your introduction it allows me to understand well the software ...

[2yung4grey]

:(...... thanks anyway.

[2yung4grey]

should you learn oracle sql, pl/sql before starting this?. I also want to know where i can download sql,pl/sql. Ive tried going to oracle.com and installed the 10g release2 version but the universal installer keeps telling me it fails. Ive tried it twice but to no avail. Please help me out.I want to get ahead before school starts.

[flash4real]

@2yung4grey No, learning this from scratch is fine.

[chancez6]

Hey. I am using WAMP. When I create a HTML form a PHP on the same page it give me a Undefined index error. I noticed you didn't have that on your videos. What optin do I have to get rid of to get rid of that error? Thanks!

[flash4real]

@chancez6 There's an error in your code, or you put a different value for the database settings than I did. Try finding the error yourself, and if you can't, send me your code.

[chancez6]

@flash4real No. See I just mean in general. I created a simple login code with just a password without a database (it's just has one password that I defined). I am getting this error because the form has net been submitted so, it's saying that there is no such things (Undefined Index).

My Real Question: How would you turn it off so you still get errors like in your videos but not get the (Undefined Error). I noticed you didn't have these.

[flash4real]

@chancez6 I'm not exactly sure what you mean, but undefined error means that a variable (Or similar) hasn't got a value. So if you set $myvariable = $_POST['something']; and the page isn't receiving any form data, you'll get that error. Fix this by using the @ symbol just before the code giving you issues.

[chancez6]

@flash4real Hey. That is what I needed. Thanks. It all works now without those unnecessary errors.