Part 3: How to Build PHP and MySQL CMS Website Software

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
32,339
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Sep 13, 2009

In this part of the lesson we learn how to script out our magic index page to be smart enough to display all of the data in the system, and all pages.

Source Files - http://www.developphp.com/view.php?tid=322

  • likes, 1 dislikes

Link to this comment:

Share to:

Uploader Comments (flashbuilding)

  • Quick Question ... What is the difference between MySQLI and MySQL?

  • I have a page in my MySQL course, right in the beginning section, that discusses it a bit and should explain it all.

  • I think the EXTERNAL CSS would be way better for being able to update the entire site styles in 1 sheet.

  • In this case not really cuz this entire custom system runs off of 1 file for displaying everything. Saves time and workflow by putting the CSS right in the head tag like I am doing here for styling mostly. I put inline styles for example variety. But for a one page system like what I am building here, you would overcomplicate it by adding External CSS. External CSS is best when you have more than one page or file. Otherwise not needed at all.

Top Comments

  • Help me someone i get error

    "Warning: mysqli_error() expects exactly 1 parameter, 0 given in D:\Hosting\5705737\html\Cpanal­\index.php on line 38"

    what does this mean? here is the line of code

    $sqlCommand = "SELECT id, linklabel FROM pages WHERE showing='1' ORDER BY id ASC";

    $query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error()

    i have team viewer someone please help :)

  • Hi I watch your videos alot and I cant figure out how to fix this. Please can you help. Thank you for your time.

    Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/intertel/public_html/ind­ex.php on line 13

see all

All Comments (71)

Sign In or Sign Up now to post a comment!
  • even though this took hours, you just helped me graduate, thank you!

  • I can get it to show 1 element from a database but not all.

  • @kizzel77

    if you get this error check if your hosting account support mysqli.

    and in most cases you will notice that this is not the case if you get this error.

  • @slevin741 It connects to your database.

  • $myconnection wtf is that variable do ??

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more