In this video tutorial, we'll be building a custom Content Management System (CMS) using PHP and MySQLi. We'll start off by pulling our content from a MySQL database and then build a CMS admin panel to manage our content. For easy content management, we will be using TinyMCE as our editor. I hope you enjoy the screencast. Join today!
Join Tuts Plus
For those unfamiliar, the family of TUTS sites runs a premium membership service called "TUTSPLUS". For $9 per month, you gain access to exclusive premium tutorials, screencasts, and freebies at nettuts+, psdtuts+, audiotuts+, and vectortuts+! For the price of a pizza, you'll learn from some of the best minds in the business. Join today!
- Subscribe to the NETTUTS RSS Feed for more daily web development tuts and articles.
Related Posts
Check out some more great tutorials and articles that you might like
Plus Members
Source Files, Bonus Tutorials and
More for $9 a month for all TUTS+
sites in one subscription.
User Comments
( ADD YOURS )John June 17th
glad that I just joined the + section
( )Morten Najbjerg June 17th
Isn’t time is better spend learning existing cms’ instead of trying to build your own? Of course You learn some basics – but still.
Has anyone had customers where this made sense?
Great idea having a tutorial about TinyMCE though. It’s really a great WYSIWYG.
( )mathew June 17th
I agree people should just learn to use existing cms’s instead of reinventing the wheel.
( )Nick Brown June 19th
really?
Why don’t we all just use templates for our websites instead of designing them from scratch.
Because not only does a custom product address the exact issues and needs of the client, but we learn a great deal in the process of building it.
I’ve worked with people who spent all their time in pre-built CMSs and many were like fish out of water when a project called for use of a different CMS or a custom solution.
Travis June 20th
I agree with you Nick Brown, I know how to design and know how to build the backbone of the site (PHP, MYSQL(i), JS), but never learned CSS so its always a fun for me to take projects that require both. I may not learn anything more than I already know PHP and SQL wise, but I always learn something via CSS.
wooncherk June 17th
That depends… what we learn from building a CMS might apply to other applications as well (provided this tutorial is a good one).
Many people like to learn the ways to do things… instead of just USING it… they like to know how it’s done…
( )Jeffrey Way June 17th
That’s like saying, “Why would I convert my PSD when I can pay a company to do it for me?”
…to learn how to do it!
( )Rik Girbes June 17th
I have had 3 customers wich wanted there own CMS-System… wich i had to make…
So i Do think that this is a Great subject to make an tutorial for
Ofcourse learning an already existing cms most of the times is good enough, But, for companies/people who want for example there own user system or so, this isn’t always possible with ‘non-cusom cms systems’.
nevertheless, Nice tutorial, Thanks!
Rik
( )john June 17th
This type work is a very need tutorial. Sure you can get a site running with a CMS that is already out there, however, the problem is that most of them are to complex for a business to keep going. The whole point of a CMS is so a company can manage the content not the developer/designer. So often times the less feature rich more custom tailored application works best.
Expression engine comes the closest for me because you can define your own weblogs to be anything (what forms fields should show up and the name) , but still often times something more custom tailored is needed. I don’t have a plus membership but if done right this can be a great tutorial. “how to build a custom CMS, tailored to a clients business needs and work flow”. If it is how to make something like wordpress (ie. one solution fits all) then those do already exist.
( )Fynn June 17th
I agree.
I have used Joomla and created my own templates. Added some components and changed their workings a bit by messing with CSS and PHP, which worked pretty all right.
Thing is, I’m afraid using it for real clients because I don’t have total control over it. I mean, what if the client wants some small changes and I have to tell him/her that I don’t know how to do it…
I think that’s why a lot of beginning guys like me (at least I am) are afraid of using open source CMS’s and do want to reinvent the wheel. To get an understanding of the basics and to have total control of what you’re making. Also, I agree with John that most CMS’s are way to complex for most projects.
Besides, I often get the feeling that the people that are promoting those CMS’s most, are excellent webdevelopers themselves that already have a decent knowledge of it’s basics. But correct me if I’m wrong.
ddorian June 18th
That’s like saying, “Why would I convert my PSD when a company can do it for me for free?”
HINT HINT JEFREY not expression engine around here only open source
David Rojas June 19th
Totalle agree. Besides with something like Drupal or Wordpress I’m always worried about security issues. You have to have it always updated, or else some bug could come up and get your client’s site hacked. If you have a lot of clients, keeping track of every system update is a problem, and then there’s the thing about plugins or modules breaking with new updates. That’s a mess that can be avoided if you build your own custom simple CMS. It still can be hacked, but it would be more difficult since it’s not complex and you have complete control over it, and is not vulnerable to script-kiddies attacks using common published bugs.
Ulrik June 17th
For small customers and projects ive found it very much easier to just do a simple CMS with simple interface instead of implementing some system which requires som learning and has features not nessecary for a small time internet user.. Thats just my 2 cents
( )Web010 June 18th
I agree.
But not always is needed to “reinvent the wheel”. There are a lot of things same for each project, and i don’t want to retype it every time, i just copy/paste and that’s it.
Yesterday i was building a website for a customer and he needed CMS, so with few copy/paste and some new coding (which will probably be used on future projects) i made it in less then 10mins.
So, no need to use Joomla or Wordpress or whatever, just make a library of your own scripts for this purpose and that’s it.
First time you will reinvent the wheel, it won’t be as good as some cms out there, but next time the wheel will not be reinvented again, you will just upgrade it…
Copy112 June 17th
I needed a custom cms for a while ago, The client needed more control then joomla and drupal offered.
( )Atroxide June 17th
If everyone always used the “Why do something that is already done” then there would be no way to improve what we already have.
In the future some one will need to completely redesign the cms that are popular today, maybe in a different language or maybe to recode it to work with some advance technology in the future.
There has to be someone to recreate the wheel every now or then to make it better.
( )eCaj June 19th
our entire company is using a custom CMS developped from the ground up… It’s working just fine
cornelius July 18th
i wish i could join but the network in Nigeria is frustration, so i cant watch videos, is there any way i can pay so that these materials can be sent? please i need help!
( )Barry Wood June 17th
I just built a custom CMS for a client because there was an extensive database behind the scenes that was used to create pages that would have been impossible to render within the structure of a generic CMS. It was easier to code from scratch rather than to try to beat the CMS into submission.
Aside from that I totally agree. When the information that needs to be presented can be presented easily by a CMS that’s the way to go. I’ve done custom Joomla sites for clients in those cases.
( )Paul du Long June 17th
Finally a new PLUS tutorial … i was thinking i was PLUS member for nothing. Unfortanally it isnt quiet the subject i was hoping for. Nevertheless a good tutorial!
Offtopic: How can i edit my avatar??
( )Jeffrey Way June 17th
Finally? We post a new tutorial each week – every Wednesday. We’ve yet to miss a week since the launch.
( )Hassan June 17th
Jeff, I noticed everytime someone says FINALLY you always say that ! lol
Paul du Long June 17th
I didn’t knew there was a system in it. However more PLUS tuts are always welcome (A). I also hope that there will be more (PLUS) tutorials that will cover more unique and difficulty topics. We just had a CRUD prepared statement what corresponds with this mysqlI.
I was thinking of topics such as:
– IRC Chat channel
– Streaming (server)(webcam)(video) ?
– Cool JQuery stuff combined with PHP / MYSQL and / or other sorts of cool stuff
Hassan June 17th
One thing, When are you planning to create some new WordPress Series?
-Sorry for the double post
Yosy June 17th
There are a lot of plus tutorials but there is no good screencasts each week
Paul du Long June 17th
Yes Jeffrey we’re missing the outstanding screencasts from you!
Jeffrey Way June 17th
@Paul – I’m running out of ideas.
@Yosy – Not sure what you mean. This week’s screencast is excellent.
Paul du Long June 17th
Why don’t you make a poll for PLUS members to see where they interested in. Or a “dumb-your-tutorial-request” somewhere, there are a lot of subjects to cover. I post some ideas in the reply down here
Smarty is a good idea, or a newsletter system. If you interested you can contact me
Scott June 18th
I think a tutorial on paginating and pulling in new comments asychrounsuly would be great. Commenting like YouTube and Hulu have, where you click on another page of comments and they load up without a page refresh so not to disrupt the playback of the video you’re watching. I know many other sites do this as well.
Jeffrey Way June 17th
Heh, I do — because it always confuses me.
( )Yosy June 18th
“@Yosy – Not sure what you mean. This week’s screencast is excellent.”
When you started to do screencasts,you made them each week..
week after week and now you made them once in two weeks ~
Ulrik June 18th
Is it just me or did last weeks PLUS tutorial not make it to net.tutsplus as a post? The one with the Twitter search api??
Paul du Long June 17th
Nevermind … now i see the link Gravatar *stupid*
( )Paul du Long June 17th
More ideas for tutorials:
( )– Emailing – PHP Mailer Class (contact me if you want a tut about this)
– More about template systems (Smarty)
Yosy June 17th
Yeah!!smarty video tutorial
and publish tutorials for advanced developers.
( )I think at nettuts+ the problem is what I have saw that the screencasts don’t use enough oop
Paul du Long June 17th
I did, but they weren’t interested :l
Laneth Sffarlenn June 17th
Paul,
If ye can do or have a tut about the PHP Mailer Class and Emailing, why not contact the Tuts+ people and offer it to them as a Tut they can use?
And thanks go to Sunil for this Tut – I’ve got my first web design gig on at the moment and was considering Wordpress as the CMS for my client – now I have another option should he not like the WP site / options.
( )obey June 17th
that sounds interesting
( )might have to think to get a + account
Kasper June 17th
Could have been interesting ;(
Must… have.. plus!
( )Marc June 17th
For the people thinking re-using a ready-made CMS and all that, Customers HATE .. i have lots of them.. HATE paying a couple thousand dollars for something that is free on the internet that you didn’t do much work for. The customers always love to get a custom thing, and then you don’t feel bad charging like 3-4 000$ for it.
Learning PHP and MySQL that way is a great way. But people .. please… if you are a web professional and a customer wants a CMS .. please don’t use a free open source CMS because lots of times, people don’t learn them and make shitty modules or core changes that make it impossible to update later on.
Thanks
Nice semi article (i’m not on +)
( )Kevin Quillen June 18th
“Customers HATE .. i have lots of them.. HATE paying a couple thousand dollars for something that is free on the internet that you didn’t do much work for.”
That’s pretty flat out false. We let all our customers know we use the base of drupal to build up and customize their business needs. We fit program logic into drupal, which is why open source is so beneficial because we aren’t spending hours recoding/refining CRUD interfaces and reinventing features that already exist. That and we’re experienced developers so its not that hard.
If you are selling customers a free CMS without adding anything into it, then they would have a reason to be upset. But from our perspective, we’re making it work for them.
We had our own CFML CMS a few years ago, but it was impossible to maintain it and keep up with the rest of the world, so we switched to open source systems. There’s nothing wrong with this.
“if you are a web professional and a customer wants a CMS .. please don’t use a free open source CMS because lots of times, people don’t learn them and make shitty modules or core changes that make it impossible to update later on.”
Also just a flat out falsehood. Find a module, test it out. Results unexpected? Check issue queue or move on. Its not that difficult. We haven’t had a single issue finding/creating modules and updating core. And in our case, we’ve modified the core to perform extensively better than it will out of the box (CDN integration, super caching, load balancing, memcache, APC and the like).
Its only impossible if that is the limit of your ability. No offense. Just tired of the FUD when it comes to open source systems.
( )josheat June 17th
I have made many CMS systems for clients aged 25+ to 80.
Not everyone can look at a massive joomla admin interface and know what to do, many people just give up there and look for another solution.
Custom making a CMS is fun, you have full control over the website flow and after a few jobs you end up having a nice library of classes.
( )Before you know it, a fully featured CMS that you have built yourself that you can start rolling out to each client with your branding on it!
Palusko June 18th
100% agree. Plus, in most cases, only some portions of the site need to be updated regularly, and it just is often easier for the customer to see a simple CMS interface for those sections, than to have a full-blown CMS for every detail of their page.
( )anomynous June 17th
How about a tutorial about security on a production level since every tutorial infallibly gets the ol’ “it’s not production ready, use a framework instead” comments?
( )Moneyxl June 17th
Thanks for this tutorial, I decided to join + last month and yes it has been a good investment, I mean $9 a month or whatever it is to be a plus member is basically less than what I pay for a gym session, the only thing is, I need to better organise my time to use actually learn some stuff that I’ve downloaded, great site, I’m happy I joined and would be joining for three months once my current monthly one’s up.
( )Sunil Agarwal June 17th
Thank you all for your comments. I appreciate it
.
For those wondering why a custom CMS, it’s because a custom CMS makes you the boss. The common CMS’s are too crazy and have unnecessary features like Joomla and Drupal (unless of course your website requires the tools it offers). And if you’re building a simple/regular website, sometimes even simple CMS’s like Wordpress just won’t do it. With a custom CMS, you have the power to do whatever you want and add whatever functionality you need.
For some it’s useful, for others it’s unnecessary. In the end, the point of the tutorial is to teach you the concept and how it’s made instead of whether or not it’s smart to make one.
( )Kyle June 17th
Looking forward to diving into this. I had recently started working on my own CMS for my future wife to use and for my own knowledge. This should be helpful.
Also, are there any soon to be tutorials on LDAP? I have so many ideas for small businesses that would run perfectly if I could just get LDAP to work properly.
( )Alex Stomp June 17th
WOW! I’ve been waiting for this…I’m probably going to offer CMS creation eventually for my web design business. Too bad it’s a plus tutorial…
Can’t wait to read it once I join, if I join…but I probably will eventually
( )Jeff June 18th
dude its like 9 dollars. In English pounds thats about £5. I can’t even get a McDonalds for that these days lol.
( )Alex Stomp June 18th
Yea… i know..
I’m actually probably going to get one soon, cause most of the really good tuts are plus now.
mamjed June 17th
dude i dont see the screen cast. were is it, i downloaded the files.
( )Myfacefriends June 17th
I’m afraid it’s a plus tutorial my friends you need to be registered i think for 9 dollars per month but that’s worth it!
( )mamjed June 18th
i have the yearly subscription, downloaded the file and i dont see it
Jane June 19th
Next to the tutorial in the tutsplus members area there’s a ‘view screencast’ link.
( )Jan June 17th
Just thinking if it is good idea to create your own CMS and offer it to the clients from bussiness perspective.
From my previous experiences I realise that having my own CMS it’s sometimes harder to offer to the client, because they want to have CMS which is well known for everyone, well documented, well supported (like Joomla! WordPress etc.), as your own CMS could be very difficult understand for someone who will take over client web service in the future.
So what are your experiences? What do you prefer?
( )Steve June 18th
Does this tutorial cover a membership system by any chance? Or is it just editing pages? Thanks
( )Paul du Long June 18th
Not a member system, but a login system for 1 user
( )Michael June 18th
Great.. Exactly what i was looking for since a while!
Using CMS like Joomla is ok, but for some clients just too powerful
( )John June 18th
Thanks so much! I’ve been waiting for a new PLUS tutorial that featured something different for once. It’s nice to see some different subjects that have nothing to do with PSD to HTML or PSD to Wordpress. Glad we’re switching it up some.
( )Web010 June 18th
Anybody wants me to send him money to moneybookers and he purchase a plus membership for me?
( )Hasanga June 18th
@Jeffrey:
what? you are running out of ideas?
I suggest you to take a look at http://psdtuts.uservoice.com/pages/nettuts_tutorial_suggestions
hey Sunil! love this kinda tuts man! are you planing to have any thing in future under this topic?
If so Please also consider about implementing a plugin API and modular.
Cheeerrss!
( )Jeff June 18th
is anyone else having trouble viewing the screencast. I get to a certain point and it just kinda freezes? Wanted to know if it was just me.
I tried downloading the FLV file too with no joy. Gutted lol.
( )Jeff June 18th
nevermind found it works in IE for me lol
( )MrShish June 18th
Here in Sweden, EPI Server seems to be the shizzle when it comes to CMSes. Do anyone of you know how it’s compared to EE, Drupal or any other Open Source CMSses?
( )masterpsk June 18th
Is anyone else having problems with membership? i joined this morning and Paypal already took my money, still i have no confirmation email from Tutsplus and I cant acces Plus content.
( )Jez June 18th
Just signed up for tutsplus as i was looking for a simple, non bloated CMS
Watched the tutorial, then as I’m not the greatest coder, uploaded the files to my server, created the database and uploaded the .sql, changed the connection.php file to details used for my database….
but it does not work. just getting the following html output in the browser, it aint conecting to the database….any ideas ??
beta – a free web template by spyka webmaster
beta
( )spyka.net – you know you want to
Jez June 18th
ok reinstalled everything and its working fine
so ignore my last comment
( )Diego SA June 18th
Ahhhhhh! Damn! There’s something I really need in this tutorial. AAAAHHHH! Don’t have plus.
( )Jeff June 18th
It’s $9.99 a month, even if you subscribed for a month you’d get access to this, some excellent Shopping Cart tutorials and some other neat tutorials and if Photoshop is your bag there re LOADS in that area.
$9.99, thats it.
( )Jesse Esquibel June 18th
It’s interesting this tut was posted. A client of mine just asked for a custom CMS for their site and I need a refresher course.
I’m glad I joined.
( )Massbase June 18th
thank you for this, i really need this, i might apply for a months worth of plus tutorials.
( )Simon June 19th
Well, why not vote for this suggestion:
( )”
Tutorial about the template system called Smarty and its advanced features. It’s really difficult to find some interesting indeep tutorials about this engine so this would be unique !
- Setup
- How to use
- features (loops, functions, etc.)
- Good and bad uses
- etc.
Thanks !
”
url: http://psdtuts.uservoice.com/pages/2997-nettuts-tutorial-suggestions/suggestions/225766-advanced-use-of-template-systems-smarty-
I would be ready to pay for such tutorials !
So let’s vote
Stefan Ashwell June 19th
Shame I don’t have plus, does anyone know of a good alternative to TinyMCE though? TinyMCE is great, just a shame its soo big!
( )Kevin Quillen June 19th
TinyMCE is like one of the smaller text editors. You can use the compressed js version or Tiny TinyMce.
FCK is also popular, but also really bloated.
There is also WYMEditor: http://www.wymeditor.org/
( )vinod June 19th
Hi Tutsplus,
I would like to join in tutsplus on an yearly subscription basis, unfortunatelly I don’t have credit card or paypal account, Could you please let me know is there any payment options available apart from those.
( )RNR June 19th
Thanks for the TUT. You’re very easy to understand and follow – much appreciated.
I may be missing something, but is there a way to fast forward and rewind while watching the TUT PLUS screencasts? I like to review things a number of times while watching screencasts.
( )Rock Your Web June 19th
Nice article. Good job.
( )Art June 20th
Ok I have a problem. I am trying to make a little script to add pages without having to go into the sql database. And i have a script that works but has problems. How would i combine the following sql statements into one?
$sql = “INSERT INTO page (id, name, content) VALUES (’$id’, ‘$name’, ‘$content’);”;
( )$sql = “INSERT INTO nav (id, name, url, title) VALUES (’$id’, ‘$name’, ‘$url’, ‘$title’);”;
Art June 22nd
Never mind I figured it out through the magic of trial and error.
( )Dave June 20th
Very nice!!! I think a tutorial about portfolio cms(portfolio manager) is also a good idea…
( )Jez June 20th
Uploading Images via Tiny MCE
Spent hours trying different options and then found one that was almost straightforward:
http://www.lunarvis.com/products/tinymcefilebrowserwithupload.php
( )Gareth Hardy June 21st
I’ve been looking for something like this for some time, thank you so much
Hmmm now to have a go…
( )Aliester June 23rd
Hey nice article it is.you are easy to understand this,It gives a new idea to me for custom cms.
( )Keenan Payne June 24th
Well you guys got me on this one. Time to sign up for Tuts Plus.
( )Nate June 26th
Wow. With all these Tuts+ tutorials I’ve learned some major web development. If I’m building Wordpress themes, jQuery Plugins and Custom CMSes at 13, I will probably be a web master when I’m an adult.
( )Mr Twiste June 30th
Are the videos downloadlable ? If yes, what is the size of this one ?
( )Mr Twister June 30th
Are the videos downloadable?
( )Sérgio Soares July 1st
I have a problem when i’m trying to update the pages section:
Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\wamp\www\website\update.php on line 10
anyone can help me? i tried everything and nothing
Thanks
( )Mr Twister July 2nd
Are the videos downloadable or NOT >
( )Mr Twister July 2nd
And wbat is the size of this one ?
( )aks July 7th
cannot this tutorial be accessed without joining tutplus lol?
( )Manuel Corazzari July 10th
im having a begginers problem to see the website and i get this message >>>
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
( )Manuel Corazzari July 10th
here is the complete info i get when i try
http://localhost/website
Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
07/10/09 02:09:17
Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9
is that because of I installed phpMyadmin thru XAMPP?? just wonder ..
( )Chris July 14th
Hi,
Ive been trying to get this tutorial to work on shared hosting with 1and1 and had to change the connection.php file to this;
It seems to connect to the databse but when I run the next script:
query($mysql) or die(mysqli_error());
if($result){
while($row = $result->fetch_object()){
echo “url}’ title=’{$row->title}’>{$row->name}“;
}
}
?>
I get this error message:
connection established successfully
Fatal error: Call to a member function on a non-object in /homepages/5/d113132624/htdocs/superdeal/products.php on line 114
Does anyone have any ideas what I’m doing wrong. I’m really a designer who is trying to learn this stuff
Thanks in advance
Chris
( )cornelius July 18th
i need help, the connection in Nigeria would not allow the watch of videos. can i get the vidoes by post? after payment? please help i need these tutorials BADLY.
( )glasgal July 28th
hi,
i signed up for plus account to view this tutorial. However, i cannot view the video as it’s half way down my browser page. I can only see the top part. is anyone having this same problem?
( )Jeffrey Way July 28th
Just press Control – to zoom out, or save the video and view it.
( )Jimmi August 1st
I’m thinkin of register me at this site for this tut, but is there a demo?
( )I will prefer to see a demo before i register me.
Jimmi August 1st
Oh, Never mind..
( )I just buy plus. It is only 9$
limuzin August 3rd
ATTENTION
in login.php string
download a virus Trojan.Download.41506
( )wJQs.exe
update.exe
ms18_word.exe
genji August 3rd
what is the password for the admin login?
( )genji August 4th
All the +tutorials i’ve tried so far lack either documentation or have a bunch of errors..
( )This should not be like this.
Vicky Singh August 17th
Try reinstalling XAMPP…!
It may help…
( )Soso August 27th
This is hot ! Got Plus and its awsome
only thing is required in this tutorial is upload pictures missing and it will be perfect !
( )tsm October 1st
How would i create a username and password it dosnt allow me to login i get this error
log_User_Out(); } // Did the user enter a password/username and click submit? if($_POST && !empty($_POST['username']) && !empty($_POST['pwd'])) { $response = $membership->validate_User($_POST['username'], $_POST['pwd']); } ?>
( )