PHP Tutorials: Creating a Blog (Part 8/11)

Loading...

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

Uploaded by on May 28, 2011

Creating a blog, from start to finish, with a MySQL database. Base files shown in the tutorial can be found in the source code section of the phpacademy forum.

Official website
http://phpacademy.org

Support Forum
http://phpacademy.org/forum

Follow us on Twitter!
http://twitter.com/phpacademy

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 2 dislikes

Link to this comment:

Share to:
see all

All Comments (17)

Sign In or Sign Up now to post a comment!
  • hey bro, my posts not show on my index. no sql error show. i really confuse now. please help

  • hey guys, don't use `post`.`id`

    instead, use `post_id`

  • I get this code

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/emielfs48/domains/xub-in­fo.nl/public_html/recources/fu­nc/blog.php on line 43

    and this is line 43 $query = mysql_query($query);

    line 43=>  while ( $row = mysql_fetch_assoc($query) ) { $posts[] = $row; }

  • @8888aurora I have the same issue. Please tell me you were able to fix it. Can you please help me. please.

  • So, Ive done a bunch of searching and I can't figure out why my cat id doesnt match the id. it just stays at 3, never increments and it doesnt matter what I do. I get {title} on my index page when I submit a new post. Can anyone help me troubleshoot this problem. Please.

  • This guy is mass up.

  • SQL query:

    SELECT 'posts'. 'id' AS 'post_id', 'categories'. 'id' AS 'category_id', 'title', 'contents', 'date_posted', 'categories'. 'name'

    FROM 'posts'

    INNER JOIN 'categories' ON 'categories'. 'id' = 'posts'. 'cat_id'

    MySQL said:

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.'id' AS 'post_id', 'categories'.'id' AS 'category_id', 'title', 'contents', 'd' at line 1

  • YoManTino - have you ever thought about a content management system for game reviews etc.. Will be easier then this for you..

    Although if you are into programming then carry-on.. There are other tutorials out there which teach the basics and can lead you too this.

  • Okay.. I tried again and still no luck.. I just don't understand how to do this. It's so confusing..

  • @YaManTino I'm already confused. Do you mind uploading the finished product please? I'm new to PHP, and I'm trying to make a video game reviews, and what not, site, but I'm only good with CSS/HTML. So none of this makes a whole lot of sense to me. But if you don't mind, could you please upload the finished source code and give us the code? If you don't want to, or have the time, it's fine. I can find another blog to download. Personally though, this is the best one that fits my needs. Thanks.

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