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
hey bro, my posts not show on my index. no sql error show. i really confuse now. please help
Adikumoro 3 weeks ago
hey guys, don't use `post`.`id`
instead, use `post_id`
adzuck 2 months ago
I get this code
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/emielfs48/domains/xub-info.nl/public_html/recources/func/blog.php on line 43
and this is line 43 $query = mysql_query($query);
line 43=> while ( $row = mysql_fetch_assoc($query) ) { $posts[] = $row; }
emiel1976ep 3 months ago
@8888aurora I have the same issue. Please tell me you were able to fix it. Can you please help me. please.
kevrev7 4 months ago
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.
kevrev7 4 months ago
This guy is mass up.
mixsmike 6 months ago
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
Ninoschrijver 7 months ago
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.
sebble19844 7 months ago
Okay.. I tried again and still no luck.. I just don't understand how to do this. It's so confusing..
oNEoJoKeR 7 months ago
@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.
oNEoJoKeR 7 months ago