Learn PHP/MySQL Feedback Thread

[Bearclaw]

Excellent thread. Looking forward to this! :thumbsup:

[DiscipleDOC]

Vin, why not sticky this and mod this thread so we can keep this thread going?

I think that this is going to be a real good tutorial. :thumbsup:


Edit: Real good read.

Question: Do you know if linux have a version of NotePad plus?

[ViN86]

Vin, why not sticky this and mod this thread so we can keep this thread going?

I think that this is going to be a real good tutorial. :thumbsup:

k, im going to sticky this, then make a feedback thread so the main thread doesnt clutter :)

[ViN86]

here is a section to post comments and feedback for the learn PHP/MySQL thread. if you have questions/concerns or problems, post here and ppl will help you out :)

[fivefeet8]

PHP variables may only consist of numbers, letters, and underscore characters (A-Z,a-z,0-9,_).

I think you meant variable names. When I first read it, it almost sounded like you meant the value of the variables.

[ViN86]

I think you meant variable names. When I first read it, it almost sounded like you meant the value of the variables.

correct. that is what i meant. ill fix it, thx :)

[Bearclaw]

Lesson 3! Will there be a test?!

[ViN86]

only if you continue to speak without raising your hand.

[Bearclaw]

:eek2:

[ViN86]

:eek2:

attitude? now there will definitely be a quiz.

[Bearclaw]

:lame:

[crainger]

Is it just me or is the top of this thread missing :O_o:

[Bearclaw]

Is it just me or is the top of this thread missing :O_o:

:bleh:

[t3hl33td4rg0n]

I can help out here if you need the extra hand.

Conditionals / Loops: if | for | foreach | do / while | switch

:D

I could maybe do something with MySQL queries with PHP using mysqli as opposed to standard mysql extension....

[ViN86]

I can help out here if you need the extra hand.

Conditionals / Loops: if | for | foreach | do / while | switch

:D

I could maybe do something with MySQL queries with PHP using mysqli as opposed to standard mysql extension....
that would be awesome. i dont know mysqli very well, i typically use the standard mysql extension. it'd be cool if you could do a segment on mysqli :D

[SH64]

Awesome work Vin!! keep it up :thumbsup:

[nemecb]

When you do MySQL please, please, please talk about security up front. We don't need any more SQL injection flaws.:eek:

[t3hl33td4rg0n]

that would be awesome. i dont know mysqli very well, i typically use the standard mysql extension. it'd be cool if you could do a segment on mysqli :D

Well, thinking about it, mysqli is OOP and requires a class... Probably wouldn't be a good idea to get into that without covering general OOP based stuff.

Personally I've always used mysql, and have only one project using mysqli. I'm gonna try to expand it as much as possible, as of right now its very elementary lol.

[jcrox]

Is Vin planning on continuing this? If not, I'd be glad to pick it up and continue it. I just started this class and could pretty much just post my once a week lessons from school. Also, if anyone is interested in learning ASP.NET Ive got videos that can walk people through learning it.

[ViN86]

yea i am. i have just been busy with moving to school.

i will try to add the next part within the week. also, feel free to pm me guys if you want to add certain sections. there can be more than one author :)

[fivefeet8]

Well, thinking about it, mysqli is OOP and requires a class... Probably wouldn't be a good idea to get into that without covering general OOP based stuff.


I've always thought OOP in PHP was fairly easy to understand, but then again, I had knowledge of OOP concepts from my C++ background when I started php programming. I agree some basic coverage of OOP in PHP would be a good idea.

[ViN86]

Well, thinking about it, mysqli is OOP and requires a class... Probably wouldn't be a good idea to get into that without covering general OOP based stuff.

Personally I've always used mysql, and have only one project using mysqli. I'm gonna try to expand it as much as possible, as of right now its very elementary lol.

well OOP will have to be explained eventually, so down the road you can definitely write a mysqli lecture.

[nemecb]

Honestly, using OOP classes is not that difficult, it's writing one properly that gets hard (and very subjective). Objects are basically pretty intuitive to most people because they abstract away a lot of the nasty details and let you focus on the interface. A complete discussion of OOP probably isn't necessary (and frankly is way outside the scope of this tutorial IMHO), just a quick introduction to objects and how to use them should do the trick.

[pross]

nice thread so far mate, i have only one small concern so far; you are using double quotes in your variables, tho this is ok to do and works fine it can lead to hassles later especially if you want to include a double quote in the html output, for example..

$test = "hello";
$output = "<a href="http://someurl.com">" . $test;

the above snippet will break unless the double quotes inside the html link are escaped with a \

single quotes however do not have this problem..

$test = 'hello';
$output = '<a href="http://someurl.com">' . $test;

[ViN86]

nice thread so far mate, i have only one small concern so far; you are using double quotes in your variables, tho this is ok to do and works fine it can lead to hassles later especially if you want to include a double quote in the html output, for example..

$test = "hello";
$output = "<a href="http://someurl.com">" . $test;

the above snippet will break unless the double quotes inside the html link are escaped with a \

single quotes however do not have this problem..

$test = 'hello';
$output = '<a href="http://someurl.com">' . $test;
yes, good point.

i typically use double quotes and escape them when i want them in the HTML. but single quotes would probably be a better idea.