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

Posted by: Admin  :  Category: Php

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

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 – www.developphp.com
Video Rating: 4 / 5

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

25 Responses to “Part 3: How to Build PHP and MySQL CMS Website Software”

  1. RedpandamCorporation Says:

    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/index.php on line 13

  2. Whisperingonthewind Says:

    Hi OB1 AKA Adam, I could not get part of the code to work, it needed isset, works a treat now woop at last. ;~)
    if (!isset($_GET[‘pid’])){
    $pageid=’1′;

    Great Tutorials

  3. TheGODsOPINION Says:

    Hi Flash!
    I love your Videos! Keep it up with the good work!

    Maybe u can help me also in this case:
    I have an HTML PAGE with TEXTAREA, DROP-DOWN-LIST and SUBMIT BUTTON
    and lets say User typed “TEXT” in the TEXTAREA and CATEGORIZED it with the DROP-DOWN-LIST OPTION
    called “OPTION1”. After he hit the SUBMIT Button, I would like that his “TEXT” is saved in the
    MYSQL under FIELD “OPTION1”.

    Whats the PHP Code for that?

    Thank you in advance!

  4. danpp13 Says:

    Hi I am having the same issue as some other people.
    I have followed the tutorial perfectly and still have the same error:

    Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /public/sites/***************/index.php on line 7

    has anyone found the solution to this yet?

  5. danpp13 Says:

    Hi I am having the same issue as some other people.
    I have followed the tutorial perfectly and still have the same error:

    Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /public/sites/***************/index.php on line 7

    has anyone found the solution to this yet?

  6. danpp13 Says:

    Hi I am having the same issue as some other people.
    I have followed the tutorial perfectly and still have the same error:

    Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /public/sites/***************/index.php on line 7

    has anyone found the solution to this yet?

  7. Whisperingonthewind Says:

    Hi Adam Dreamweaver CS5 will not render some of your code.

    This code will not render in DWCS5: –
    $query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());
    This code will render in DWCS5: –
    $query = mysqli_query($myConnection, $sqlCommand) or die(“myConnection: ” . mysqli_error());

  8. rEs0LuTe12 Says:

    you should try $pageid = mysql_real_escape_string($_GET[‘pid’]); to protect it from sql injection, anyways good job with the tutorial. 🙂

  9. dragon10y Says:

    @flashbuilding Do you know how I can fix this error ?
    Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /public/sites/beta.dragondesig­nz.eu/cms/index.php on line 7

  10. dragon10y Says:

    Can someone help me with this error ?

    Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /public/sites/beta.dragondesignz.eu/cms/index.php on line 7

  11. samiwistler Says:

    PHP gurus

  12. JJDR04 Says:

    Why is is so difficult to post a comment here? I keep geting an error message… something must be wrong with youtube here.

  13. acchu1986 Says:

    thank you so much for the help….
    But the query is printing only the last record in the browser. I am trying to complete the videos but i am getting stuck at some point of time.

    Thanks

  14. acchu1986 Says:

    Sir , Can you please tell me where is the $myConnection variable in the file .. I did not find it.. I just copied from ur site.

    And also I am still getting the error..

    Thanks.. Early response would be appreciated

  15. JJDR04 Says:

    @acchu1986
    Check the connect_to_mysql.php file inside the scripts folder. Remember that the $myConnection variable is is inside this file. make sure the path to the file is correct.

  16. JJDR04 Says:

    @flashbuilding
    I am Still struggling with it.Any luck anybody with highlighting the menu items
    please help… Thanks everyone!

  17. acchu1986 Says:

    Where is the $myConnection .. I am getting error

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home2/xxxxxx/public_html/index.php on line 8

  18. JJDR04 Says:

    Hi Adam. Is there a way to highlight the generated menu links? In other words, highlight the current selected menu item. Any help will be greatly appreciated.

  19. JJDR04 Says:

    I figured it out. If anybody is having this problem also, just replace the line:

    if (!$_GET[‘pid’])

    with:

    if (!isset($_GET[‘pid’])).

    In other words, set the variable Get to true by adding “isset” to it. The problem was that the Get variable, $pid was not being passed to the php engine.

    I hope this can help someone. Thanks.

  20. JJDR04 Says:

    Hi guys…On page load, I keep getting the message Undefined index: pid in F…
    Even when I open the original files I download from Adam’s website. I am getting this error in the main index page.

    If I click on any of the link buttons, the error disappear. Again, I only get this error when I first open the page on the browser.

    Any help will be appreciated… Thanks

  21. aspdotnetexperts1 Says:

    Thanks for sharing this informative Video. For Expert Level .NET Video’s visit “TheSYNERGETICS” channel on youtube . Synergetics is Awarded as the Best. NET Training Service Provider by Microsoft

  22. ztarrfect Says:

    @flashbuilding I actually find your voice relaxing on this vid 🙂

  23. sackyhead Says:

    I am getting this error: Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:xampphtdocsNEWCMSindex.php on line 7

    Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:xampphtdocsNEWCMSindex.php on line 7

  24. ashperfectimage Says:

    If you need a Content Management Website cheek out my channel, I offer a CMS site digital Download!!

  25. lilabrowns Says:

    hey adam, i wanna get the last id from the query as my homepage not number 1, like any update on my site should be my homepage for that day,because right now i have to go to my database and change it to number 1 for any new updates to be a homepage ,any help

Leave a Reply

*