How to create a CMS with PHP // Part 2 - Getting rows from our database

[RBCbclprodz]

Awesome tutorial! 5*

First php tutorial I saw and already understand it well and finally mysql actually worked with me! YAY!

But anyway, I believe the charset (collation) on the database is wrong to me, letters like "é" appears as a "?" looking like some symbol. which Collation should I use for body and title?

Thanks for reading,

*reply by anyone is appreciated too! :)

[ahmedmansoori90]

Hello .. thank you for your tutorial .. i am facing problem with get_content()

Call to undefined function get_content()

can you help me solving it?

[P1Raul]

Man you are the best but i need some tut about DB :D

[Pitfallstudios]

I don't see a point in using a class.

For a global connection I just use an external file.

include 'scripts/SQLconnect.php';

[lesterjin]

I've tried to follow the tutorial but I get this error "Access denied for user 'ODBC'@'localhost' (using password: NO)" - what should I do to solve this problem?

[cbspace]

@ScoobyDooobyD00 - I've been trying to learn PHP for a while, but practicing code bit by bit just isn't sticking in. I'm hoping by doing a project (a CMS) I'll learn better.

But what I'd like to know is, in your tutorials, will you be showing ways of securing the CMS from things like SQL injection, spam etc?

[alexmc814]

Hi, thanks a lot for this tutroial What I wanted to ask is - let's say I need to echo not just content (title, body), but to take out of mysql - metakeywords, metadescription, metatitle and so on. I cannot understand how to take all those mysql fields out of the get_content function to index.php file?

[supervoodoob]

Parse error: syntax error, unexpected T_OBJECT_OPERATOR in C:\xampp\htdocs\_class\cms_cla­ss.php on line 10

i've done everything i've tried 3 diff servers and still this shit comes out what should i do ?

[sorryunlucky]

@supervoodoob

Hi, I had the same error, you've spelt one of the commands wrong, I fixed it by removing all of the text and just starting again in that function.

[dragosh32]

Got a question for you.This is only for MAC? Or for Windows too?

[dragon10y]

@dragosh32 windows to !

[dragosh32]

@dragon10y

And -> is => in windows ? Sorry if my questions are stupid :s

[dragon10y]

@dragosh32 no -> is just a code, it doesn't have anything to do with MAC or windows ^^

[PhiberOptics]

Wow i have wamp installed php scripts work but the only thing that is showing up is the get_content()?> i even tried putting this on a website that has php support on it and it don't display anything i have in that data base i made. Anyone have any ideals?

[ajrademacher]

thank you thank you thank you!!!! I have watched a ton of tutorials, and no one has got it to work like you have. I will keep watching more!

[davidknag]

For those of you seeing indexphp is get_content()?>

you have to run it on apache with PHP. Try downloading xampp server. Google it.

[abcdef12330]

@davidknag Probably they also forgot the semi-colon :3

[zeificaiOn]

All I see on indexphp is get_content()?>

[kleinespelvids]

Great tutorial ! And unlike lots of tutorials on the web, this actually works :P

Subscribed!

[Foaman]

Why would a web designer choose "scoobydooobyd00"? And... why would a web designer use a mac? Bleh...

[7715z]

name of the text editor?

[LDDCreations]

@7715z I used TextMate in this video, and still today.

[WheelTireFamily]

A solution that worked for me. ?php echo $obj->get_content(); ?

[Zeffrin101]

nice editor... when I get to work Im going to download it... god I hope my PC comes soon :D

[yawnx2]

i get this error:

Parse error: syntax error, unexpected T_VARIABLE in [---my directory---] on line 9

[ctminarchist]

@yawnx2 I get the same thing

[darkknightgaury]

Your way is fine however, create a constructor that takes username,password, database name and host. Once you instantiate the class $obj=new ModernCMS("username","password­","host","dbName");

In the constructor you can set the var at the top and call the function connect();

Your example is bleeding from the class. You want to try to encapsulate.

In another note Good job !

[fungames2]

Did you take a summer class or go to school to learn some of this?

[javarnanda]

Thank u so much for this great tutorial...but now im stuck!

me too ...I have followed this video,and in my index.php i visualize:

get_content()") ?>

what's the problem?

i read the comments below...and i realize that im not the first one with this problem.

If you can help me, i really apprecciated! greetings from italy!

[G15BT]

I have followed this, all i get in my index.php is:

get_content()") ?>

Any solutions?

Thanks

[jorgerko15]

@G15BT  add echo between <?php (here) $obj

[jelco222]

@jorgerko15 tyvm!

[davidknag]

@G15BT You have to run it on apache with PHP. Try downloading xampp server. Google it.

[zacharney1]

hey, when i add the code $obj->host the -> part stops the code and it wont work

[Kiajw]

I think that this is a great series. The only thing is that prefacing the examples you say that you aren't going to go into great detail, because people can ask around. I think that the purpose of doing a tutorial is to explain, and go into detail. Otherwise why do it. For example, tutvid does GREAT tutorials on all types of things, and he goes into great detail, which is why so many people watch his stuff. If he did CMS I would be there.  People want to learn.

[wankshit]

Hey, i'm stuck roughly half way through this video. I've finished the first complete part of cms_class.php and have everything down to a T, ive checked every piece of punctuation against the lines in the video and still i get:

"Parse error: syntax error, unexpected ')' in /Applications/XAMPP/xamppfiles­/htdocs/tensai_cms/_class/cms_­class.php on line 13"

I know roughly what this error means and have checked over all brackets etc and its exactly the same! What am I doing wrong?

[wankshit]

p.s, the part im at is around 6.30, when i try to test the connection i get the aformentioned error

[backbreaker95]

is there anyone here that can help me with a database that can support 10000 people and there login info. and points they can earn points and redeem them for prizes anyone who can help me and wants to get in to this website with me message me! plz

[ivolol]

This still isn't really modern... most new stuff is following the MVC model these days.

[LDDCreations]

MVCs are great but it is fairly difficult to build a good MVC from scratch. One of the reasons for making this series was to introduce classes in PHP so I could create another series on building an MVC similar to Code Igniter. My problem was trying to link a database class and pull results in my view file from the controller.

[ScoobyDooobyD00]

I logged into my other account, sorry if there was any confusion.

[fallendown2005]

@ivolol if they can't understand this then MVC will really lose them...lol

[mine070]

I get this :

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /home/simplit/public_html/test­er/_class/cms_class.php on line 11

Access denied for user 'root'@'localhost' (using password: NO)

[emadmoussa]

check your database password or privileges. or restart apache. If this problem continues, try to remove and reinstall xampp or wamp.

you can save the tables you already created by using ''export'' and then once xampp is reinstalled, create a new database and ''import'' the tables back into it...and bingo fresh start.

[mine070]

I have a online payed for Linux server.

[GreenyFool]

Great series mate, really helping me start off in PHP. (Y)

[FireDartOnline]

Hey great series, I am having a problem. I get this:

get_content()?>

where it should display the content from the database.

Got any idea?

-FireDart

[CamiloSanchez1979]

nicely done doggie

[zeckdude]

This CMS series is excellent! I am learning alot very quickly! You should consider getting some of your work on Nettuts, you have good quality tuts!

[Kj3k53]

Great!

[crazymanny00]

excellent vid, thanks for recommending this to me. i learnt a lot. : D

[TendencyDriven]

You really do have some pro tutorials.

Thankyou.

[ScoobyDooobyD00]

Your Welcome, Thanks