Build a Custom CMS Using PHP and MySQLi: New Plus Tutorial
plus

Build a Custom CMS Using PHP and MySQLi: New Premium Tutorial

on Jun 17th 2009 with 119 comments
Download Source Files

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!

Full Website
Admin Panel

Join Tuts Premium

NETTUTS+ Screencasts and Bonus Tutorials

For those unfamiliar, the family of TUTS sites runs a premium membership service called “Premium”. For $19 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.


Tags: Premium
 
Enjoyed this Post?

Subscribe to our RSS Feed, Follow us on Twitter or simply recommend us to friends and colleagues!

By

Rollover to read this author's bio or click through to see a full list of posts by this author.

Hi. I'm Sunil. Currently a student at Rutgers University majoring in Computer Engineering. I am self-taught in the languages I know and in my spare time I like to make random applications and learn new tech.  

Plus Premium
 
 
Note: Want to add some source code? Type <pre><code> before it and </code></pre> after it. Find out more
← Older Comments
  • Manuel Corazzari

    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

    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

    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

    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?

    • http://www.jeff-way.com Jeffrey Way

      Just press Control – to zoom out, or save the video and view it. :)

  • Jimmi

    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

      Oh, Never mind..
      I just buy plus. It is only 9$

  • limuzin

    ATTENTION
    in login.php string

    download a virus Trojan.Download.41506
    wJQs.exe
    update.exe
    ms18_word.exe

  • genji

    what is the password for the admin login?

  • genji

    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

    Try reinstalling XAMPP…!

    It may help… :)

  • Soso

    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

    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']); } ?>

  • Michel

    Hi Guys!
    This CMS do not work for me :(
    i use MAMP PRO as my localhost.
    i´m running mac os X 10,6

    i can install wp “out of the box” but i cant run the demo! strange as hell..

    what can i do?

    Thanks

  • Ray

    I joined.

    I downloaded.

    I followed the instructions.

    It worked beautifully.

    Thank you so much!

    • Michel

      are you using mamp pro ? are you on a mac?

  • Stephen

    Easy to follow, good grounding to build upon.

    One thing though, you went through “RU” but not the “CD” maybe another tutorial covering creating new content and links and deleting existing content and links.

    ATB

  • Alex

    I have a problem when i’m trying to update the home page or the firt page 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

  • Joao Cunha

    hy, im a plus member and a beginner in php and mysql. i tried to follow the tutorial; I created the database and all the cells according to the tutorial i made all the steps described (just to the part of building the navigation system) and when I tested the script the header shows up but then i have all the page blank and no errors. i checked all the code several times and everything is all right. the connection.php is also alright and in the same directory. I dont know why this happen. im using a Mac and mamp. it would be great if someone have an idea in what is happening. I also think that the files (php) should be available for download for easy implementation. thanks

  • John

    You can make a CMS so easily using Dreamweaver’s insert and update.

    For the text formatting, use ‘TinyMCE’.

    http://tinymce.moxiecode.com/

    That what I do for my xclients and you can reuse the code over and over and over again.

  • http://www.helloeverything.co.uk Hello Everything

    Really useful tutorial, thanks for making it! I would love to see a part two, that extends into making it production ready, protecting against SQL injection attacks etc and extends the CMS.

    Thank again

  • orboreale

    I subscribe to the premium. But i have a problem. I downloaded your file and opened it. When i tried to open the file “Video-Tutorial-Overview.html”. No pictures, no video, only text works.

    Sorry, i don’t write english very well. I’m french.

    Thank you for your help

  • neliuz

    Hi guys :)
    Thanks ALOT for this tutorial!

    i am making a cms for a client!

    But i have some problems with the login..

    I have just pasted everything from the zip folder in this tutorial!
    Made exactly the same data base as it is in the tutorial.

    The same username and password!

    But when i try to login it just gives me: Please enter a correct username and password

    Any idea?
    Please i need help :) PS i am a premium member!

  • neliuz

    Anyone? Maby Jeffrey Way who mada this login system ?
    I cant get throught past the login screen…

    Please enter a correct username and password

    Please please please

    • Lotte

      I have the same problem, did you find a solution?

  • http://www.allbdlog.wordpress.com Mijan

    I am new learner of php mysql.
    so I want to the full code

    how can i download the code

← Older Comments