PHP Tutorials: MySQL Basics (Part 2/6)

[BigRedBugs]

MySQL doesn't have an "extra" column to insert "auto_increment". Could you help to solve this problem?

[anik1212]

believe me ...it would have been lot simple if you could post the html form you created along with the description.

btw It was difficult to create .htaccess file. If anyone wondering how to do it here it is...

Open notepad ...write whatever you have to...and save it as .htaccess ...dont put .txt at last.

[Tteo12345able]

At 4:20 he opens his editor (eg. NetBeans, Dreamweaver) to edit the script. Now it shouldn`t be that hard anymore. At that moment you should just open the editor that you are using.

[vapiant13]

An advise: If you don't understand parts of this your probly not ready to learn about this, you should first learn HTML basics, then php basics, then you can look at mysql again, thou I recommend you learn javascript basics as well, but it's not a requirement :D Please like so people will this message.

[MistoKurdish]

Your are great thank you , but Alex makes me love php and he makes everything easy ... :(

[mariiak08]

please alex make a tutorial of mysql please

[Stereotest]

Its a good video - I do agree that some things could've been thought out better (jumping straight into XAMPP/PHPAdmin without explanation), but then I was able to follow it without too many problems.

Then again - I was using XAMPP for quite some time, so maybe its just that its not a beginner type of video. You have to know a bit of PHP prior to starting...

[TheTnbReport]

why would you not include a link to a downloadable .php file displaying your "form " syntax if your not going to show us how to write the form code ?

[aicrop02]

where's alex?

[thimira92]

You can of course copy the entire script from config to php and replace the include_once(config.php); with it, and your entire script should function exactly the same. His third file insert.php does nothing yet (his video ends). It's just two basic html forms (google how to code html forms). The third file has no connection with the other two files YET.

[thimira92]

His next file (init.php) is an initialisation file. Basically, before you can edit, add, delete anything from the mysql database, you need to log in to it. INIT.PHP does the logging in for you. He has a line called include_once(config.php);. What this means is ALL the code from config.php (which holds the login information) is copied into INIT.php. You do this for two reasons, to make your script shorter & more organised, and also to make it more secure by storing your password, etc. elsewhere

[thimira92]

Yes, he skipped some parts and wasn't the clearest, but it's not that hard to follow with some basic php knowledge from google.

1.) The program he is using doesn't matter. You can use notepad and still do exactly the same thing.

2.) He has 3 files (forget about the .htaccess for now). config.php holds the database information (username, password, and the actual database). What he is doing is extracting the array "config" & capitalising each key and assigning it each value (for easier access)

[jerickalmeda1379]

He's slow.

[MyDefused]

How did he get to the files... Did he make them? Is it somewhere in xampp?

[nineballssj9]

what do that for each part say at th ebottom

[jasonkirk]

First of all this is a free service which I appreciate so I can't complain about production values, though I will give some creative criticism to improve future videos.

The speaker was easy enough to understand, "accent" or not. The sound spikes from being close to the microphone was very annoying though.

The text editor didn't bother me like it did for many. The speaker is just starting at a level that assumes the watcher can adapt to what they have on hand. Prefer notpad++ myself.

[madichelp0]

This tutorial is close to useless, because those watching a video tutorial will not be good enough to just figure out them self how to start the programs.

[motion2000]

What he is doing, is opening netbeans 6.9.1 its free on the web.. then you just create a new project in there and create the file structure that he has.

[NlNEbar]

how can you not understand where he goes? There is an explorer on the left of his text editor which shows the files etc. If you cant understand that you shouldn't be on these videos.

thanks for the videos btw very informative and clear

[iAgentDrizzy]

omg, i was totally gonna do this, but you annoy the hell outta me, sorry man, can't do this, gotta go find a vid with alex in it to make me feel good inside

[TheKillaFruit]

He has a editing program.

How can you not follow that he opened up his php editor?

Use notepad or something if you can't figure it out.

[benj212]

can you talk faster please omg

[theantiantichrist]

Where are the files, what are the files, where should I put them, should i copy insert.php, where should i put that, what the hell is going on? Thanks.

[dogdutyascetic]

Hmm. Useless. Files come out of nowhere.

[wbmkk]

Couldn't you zoom in more when you are recording these videos.

It isn't easy to read whet has been written

[jakewestgomila]

please edit so we know how to find them files!

[Sicklymade]

When you went to the text editor....where did you find those files? did you make them? or what?

[YaManTino]

@Sicklymade Yes, I made them. However, to make sure the focus was put on MySQL I made those files beforehand.

[YaManTino]

You have a browser and a code/text editor, right?

I'm just switching between those two windows :/

That has nothing to do with the tutorial at all, it's something you're doing all the time if you're working with PHP (or any web development language, for that matter)...

[celebritymurderparty]

@YaManTino Hi YaManTino - i think the confusion here is that this tutorial comes up immediately after "the basics" - thinking it's the next step in the chain of learning how to create PHP.

In principle it sounds like what you're doing is reasonably easy to understand - however the file structure and how to place certain things isn't. It took me 10 mins to realise that you had to launch PHPmyadmin from XAMPP.

Can you please tell me where to create the mysql and subsequent directories?

[celebritymurderparty]

Respond to this video... Also - where do you find the syntax sql in the xampp file structure?

Thanks for doing the video - but for us noobs we may need things to be spelled out more explicitly.

Kind Regards,

Jez

[powerhousephg]

wow...i'm really frustrated about this. i can't even continue using the tutorial. there's absolutely no way for me to see how you got to editing the php code. pointless to go on from here...that sux

[vaughnscheunemann]

@powerhousephg Learn PHP this is about MYSQL. I find these tutorials Helpful.

[powerhousephg]

around 4:20 you move out of our view to an editor of some sort, without telling us how to get there. then you start editing things and we're just left to play guessing games on how we can do that ourselves. kinda difficult to follow.

[noilsipnm]

At 4:20 you can see he is using IDE called netbeans to create those php files and talks about .htaccess file sure he should have mentioned about this as it is a tutorial. But its not hard to figure out. Basically he is creating 3 php files here, config.php, init.php and insert.php. And if you know basic php then u will sort of figure out wht the code in there means. You can use regular txt editor to create php files as well like notepad++.

Please correct me if I am wrong! I m just a newbie! :P

[noilsipnm]

He also talks about xampp / wamp / mamp in first tutorial. U can use any one those web servers to view the php files created in this tutorial in your browser like he does at the end.

Sure things wont tie up if you dont know the basics, but to make ur life easier learn some basic php and how to setup xampp / wamp or mamp and use it. Then continue here. Hope that helped. :)

[funkgerat]

@powerhousephg Go to a higher resolution or get a pair of glasses. It clearly shows that he uses the NetBeans IDE. And you should know how to switch between applications on your computer before attempting to write any code.

[powerhousephg]

@funkgerat i had a pair of glasses, but your mom stepped on 'em when she rushed to catch the nut. oh, and you should lose your virginity before attempting to get that joke.

[blva888]

@funkgerat Really that was uncalled for. Telling some to go to a higher resolution is just mean. Videos on here are for people to learn and some have never seen an editor like this one. Show people respect!

[funkgerat]

@blva888 How is it mean to tell someone to go to 720p so they can see the all the text in the video?

[randalusa]

If you don't zoom in to make the text larger in the tutorial, it is of little use to me. I really wanted to watch the series, though will shut off now at 1:55 because the screen is just too small. I know that I could make it a little better by going full-expand. But that takes away all the other stuff I want to see on the sides and bottom. Plus it generally makes the text blurry. Simple solution: Zoom in like Alex and others always do. Thanks anyway.

[thaman941]

foreach ( $config as $k => $v ) { define(strtoupper($k), $k);  }

I have an error when i use the config file

is this a problem in the beginning?

I cant see the difference in ' ` " (they all look a likeon your video)

[YaManTino]

@thaman941 You should use define(strtoupper($k), $v); ;)

If you can't see the difference, try viewing in fullscreen HD.

[iamzesh]

Could you explain this please: ($config as $k => $v) { define(strtoupper($k), $v)} ?

Nice videos by the way!

Thank you for keeping on posting those!

[YaManTino]

@iamzesh I am working on creating a blog tutorial. I will explain what it means there!

But basically, you're just defining constants 'the hard way'. Probably doesn't make sense, but it will if you watch my blog videos. It may still take me a while to finish them though :(

[nwinburn]

Regardless of what people are saying, this is great stuff for someone who knows nothing about MySQL/php.

Thank you for your videos!

[FIGHT3R93]

please bring back you version of these mysql tutorials. when i first started i watched your tutorials and they helped me alot. THIS JUST BORED ME AND IF THIS WAS THE VIDEO I WATCHED INSTEAD OF YOURS I WOULD NOT HAVE CARRIED ON!!!!!!!

[Darienbeagle]

Is the code available for downloading?

[rainbowcrak]

How do you get on phpMyAdmin, you dont even show...

[YaManTino]

@rainbowcrak This is usually localhost/phpmyadmin/

[fanreymysterio619]

@rainbowcrak Go get XAMPP

[GardartHD]

i dont want to play grepolis, i wanna teach PHP/mySQL