How to create a blog PHP and MySQL database | Intro & Demo
Vložit
- čas přidán 7. 09. 2024
- 🚀Download the Source Code here for only $2: awamelvine.gum...
🔥My upcoming Premium Course: codingpoets.co...
This video is an intro and a demo of a series of tutorials on how to create a dynamic blog website using PHP and MySQL Database. The blog application in this tutorial will comprise the basic features of a blog application such as user registration and login system, create, read, update and delete post articles, post image uploading, categorizing posts into topics and more.
This series is, however, a continuation of a series I created before on this channel in which I show you how to design the template that we will be using in this video to make it dynamic.
You can watch the previous series here before taking this one: • Designing a responsive...
So, I'm saying this at the start of the series rather than the end so new people can see this. If y'all are thinking of whether or not to follow these tutorials, I'm here to say do it! Awa's videos were one of the best sources I used to help me with my project. His videos are super detailed which is great if you want to learn and understand PHP.
Thank you so much, Temi! Wish you the best on your project.
Sorry to ask can this be use for commercial purpose?
Awal where have u been ?
@@adetayoazeez5789 yes, feel free to use it
I fully agree, His videos are very usefull
Hi Melvin. Here from Uganda, thanks for the tutorials, they are very helpful to me. Stay blessed
I have finished 15 video how to create a blog website, it was awesome..
now i am exciting to learn this series..
thanks bro..
Thanks for watching Ali. I'm glad you're learning from this.
hi man please don't stop this amazing tutorials plz
You're the best I'm kifff, I do not speak English but you push me to speak English. thank you to contunuer as his
Thanks a lot Sir. I have been waiting for this series for a very long time. Thanks again. #Love #from #PAKISTAN
Awa, hello. Please post new tutorials with php and mysql. I am really looking forward to it
Thanks very much master! You've helped me a lot. I have a problem please; How to display the posts in horizontal/row form in the index page? All the posts from the database are displaying vertically in the index page. I have three blogs row in my html index page. I need the posts to follow that order and if there is a fourth blog it should take a new line/row.
Really really really really amazing!!
Your channel have great potential. No utuber colmplete like your channel!! You amazing!!
Excelent content!
Im your new subscriptor!
Please Create a Web Application using php and designing the frontend from scratch, you're so goood.
Bro, you are amazing talented kind programmer, Thank you for all of these videos blog tutorial.
Bro thanks for these tutorials, there are no many people that like to teach stuff like this, it's very valuable! I've got a question not related to this, have you got any suggest about buying a Mac Laptop? Which one is your favourite? Thanks for your comments and keep uploading videos!
Hey Awa I Just purchased the source code, good work bro... im a beginner PHP developer. I hope to learn a lot from it.
Awesome! I bookmarked your videos/playlist so I can go back and view these later.
Hi Cynthia, thank you for following these videos. I'm glad you like them.
test
AMA MELVINE. You are a super box of awesomeness.谢谢你哦
Thank you very much, Emmanuel 😊
Thanks bro, you took so long but finally here, #nairobi loves you
Thanks for the kind words, Karuga Joseph.
#nairobi receive my love from #cameroon, #nigeria
Legit bro just iger waiting 4 more 4rm u dear
You rock dude.
Thanks Brother. Your series is helping alot.
Hi Awa,
you are original and the best and all your tutorials are perfect with mind blowing explanations.
If all goes well, someday l will join your patron.
Please, do you have a video on how to push php and mysql database to github or heroku?
This is a great application. Beautiful and smart. Congrats! :)
Thanks bro. Great Tutorial. I am getting a lot from it
How to create a permanent image that paste to the center of the article when creating articles?
how to design fuger image?
Can you tell how we can create database and link it with connet.php file
Hello Awa. Thanks for awesome tutorials. I have been following your tutorials and i have learnt a lot. only one issue. when you access the blog via a mobile device, the login button is unclickable. what could be the issue?
How can I add Ajax pagination at the bottom of the homepage, and also when clicking the topic page, we should have pagination, another question is, how to display all users Admin and normal users in the Admin Dashboard, how you please shows us how to add dynamics CHART for user statistics, total post and filter by date, etc, and also how to add Google Analytics?
Hello Awa i made the ui dashboard but how how to add life on it how to make it work ?
Recently I've purchase your the Source Code however, error prompt which i need your advise.
first of all thanks a lot for making this wonderful series. But please tell me what changes should I have to do in my code when I will host this on the original server??? I am getting errors on line 34 of db.php on the original server
hey hello... this code is messed up in admin dashboard ......add post section .. it is not working in mobile.. it is not being responsive their.. fix it.
HOW TO ADD many picture with caption in to article?
Great job, excellently explained :-)
Thank you, David!
Hello Mr Melvine. Great tutorial. Just what I had been looking for. I have a question, when I add a new post, the new images are not aligned in the slider, they are below the older images, why? Regards.
love from india
Thank you awa your tutorial if very useful for me very kind of you......
Very helpful video sir...
Thank you sir.
Thank you, Pravat!
adds a more advanced notification sythme and a forum
Sorry, is it be only admin that can post or all users
Hello, Great tutorials thanks, can you add like, unlike, time ago function instead date published
Hello sir, firstly thanks for your tutorials. Also, I hope you will answer my question. So, If I code the website watching videos from this playlist, will I need to download source code in order to complete this blog website project? I mean, are there something in the source code that isn't included in the videos?
thank you
Pls upload video how to add multiple author not admin pls
First of all, great tutorials!
Maybe you can add something which makes the links after clicking the posts to /blog/title_of_post instead of /blog/single.php?id=1 ?
Hi Marcel, thanks for your suggestion. It's a really great idea as it helps with SEO. I actually thought of it but figured it might be beyond the scope of this course as I want it to be beginner-friendly.
I would either need to create a router from scratch or use a PHP router package to achieve this. Either way, it might be hard to grasp and might make the video series too long.
If you like I could create another tutorial dedicated to this purpose?
@@AwaMelvine Pease!!, As a Seospecialist I will wait for this tutorial))))))
I Have being Trying To Pay For The Source Code but My Country Card Is Not Allowed
damn your keyboqard sounds nice
Thanks
I am getting an error.....My database tables work when I work with them. But whenever I try to access my tables the next day it says 'table does not exist in engine. Help me with this please!!'
good afternoon boss thanks for this nice videos God bless you please after taking the site online if i register my Id under the database will be 0 even for post and topics id does not increase always showing 0
This is a nice job.
But i still need your help.
Can you not do something about the post URL instead of showing the post id it should rather show the post title
Прекрасный пример того, как не стоит делать блог. Спасибо, давно такую парашу не видел:D
Dima Beelan Чем не нравится?
Could you please make a video on the admin's section responsiveness on smaller devices ?
I have completed the design. The issues posted erlier are resolved leaving one issue, i.e., the footer is foating into middle of the page, especially in single sheet post. If possible please review and provide guidance. Thank you.
so please how can i give all users ability to send posts on the page, but i the admin will decide to publish it or not. that is to say the dashboard is set to "UNPUBLISH" by default. thanks
i have realised one problem with the website.......the dashboard is not responsive and also the when you decrease the size of the website to the mobile size the login links will not work.......i wish you could adress this problem sir
Que version de php estaba utilizando
I think there should be an option for users to post their blogs
thank you sir ....love you a lot
Hi awa please teach us how to publish it on live
Hi awa please teach us how to publish it on live
am subcription
why the Signup page is going to localhost 8888?
Hi bro tnks for good videos but i have 1 question could sent me your html and css model since i knew html and css
Awa Melvine Please tell me which Xampp server do you use
Thx bro
you can make a message system deprive like twiiter?
Hi Awa.great video as always.could you provide the source codes of this series on your website?
Hi, can you send me an email on my website? Thanks
Damn! this is AWESOME!
Thank you! 😊
Hi, in this project use RESTFUL?
Awesome video!
Hey this website is fully messed up. Fails to be fully responsive. Add post section and similar topics and user . dashboard is not responsive. Bas mobile view. .. website is heavy. FUll of images.. no option for super admin.. poor dashboard.. no code is merged for pagination.. provide source code also as u add some feature as u added pagination.. I gave lots of time here and found this. Fix it
Does this only works on a privat server?
How to add multiple images in the article ??
Awa Melvine you are missed.
I hope you are fine
Heyyy Urbain! That's very kind of you to check on me. I've been fine, thanks. Just got swept into life's vicissitudes and haven't had a chance to upload in a long time. I'm back now though.
@@AwaMelvine I am happy to hear from you, welcome back.
I am glad that you are fine.
Happy to have you back
thanks for this serie
nice broo
how can I find this code on github?
When you taking the company complete series of vedio for DETABASE
your videos are helpful. But, I am unable to find the correct code for the following as the browser showing eror syntax (endforeach is showing error). Please provide information about error in the following syntax. Thank you.
Hi, I think you made a mistake:
Please change this:
into this:
No quotes.
@@AwaMelvine Thank you. One more issue. If possible please resolve.
Warning: Use of undefined constant ROOT_PATH - assumed 'ROOT_PATH' (this will throw an Error in a future version of PHP) in D:\Websites-Servers\Xampp\htdocs\tm\servicesjournal\app\controllers\users.php on line 2
Warning: include(ROOT_PATH/app/database/db.php): failed to open stream: No such file or directory in D:\Websites-Servers\Xampp\htdocs\tm\servicesjournal\app\controllers\users.php on line 2
Warning: include(): Failed opening 'ROOT_PATH/app/database/db.php' for inclusion (include_path='D:\Websites-Servers\Xampp\php\PEAR') in D:\Websites-Servers\Xampp\htdocs\tm\servicesjournal\app\controllers\users.php on line 2.
The above issue is occuring on inclusion of file db.path in user.php. The code is given below -
user.php file code:
register.php file code:
Register
Register
Username
email
Password
Password Confirmation
Register
Or
@@prasadtm Please do
define("ROOT_PATH", ...);
instead of
define(ROOT_PATH, ...);
in your path.php
@@AwaMelvine Thank you for reply. My path file code is as follows -
Thanks for responding. If possible please review the mailed pages. Actually I tried so many alternatives but failed to go forward; now I am in a stage to stop the project. Your voice is beautiful and narrations are excellent but feeling very inconvenieance to go back and listen the videos repeatedly due to the keyboard sounds. Already severa times I have gone through your videos. I think there are version issues may be as I am using present PHP version. Any have if possible please resolve the issue. It is not possible to post every issues publicly. Thank you once again for your goodness.
@@AwaMelvine I have gone through the following website also -
codewithawa.com/posts/how-to-create-a-blog-in-php-and-mysql-database---admin-posts
Hey great video,can you please provide a source code,it will help me a lot.
I just started watching this series, does it allows users to comment?
NO
Can anybody explain the functioning of manage user.Suppose I published this website online then many people can create account and write their post so if my friend create an account and if he wrote some posts then how can I see and read his/her posts.
Please somebody reply this
No he clearly stated that only the Admin has root access to add another admin, so as long as you don't give out your admin password other registered users can only have access to read. while only Admins can Read and Write
Amazing!!
Hi awa when security and testing parts will upload?
Hi Mustafa, what do you mean by security and testing? Do you mean unit tests?
Hello friend. Can I edit the code and sell it online and also to clients
Is it okay to put a web page made from this on the internet?
please reply quickly
@@thediscover4387 yes, feel free to do that
@@AwaMelvine thanks a lot,🙏
Vibe of this thing free na
When are releasing next part?
Can u please share me the code of this project sir
I deleted all my functions and started over. I went through
all the chapters concerning the functions, and I just completed the validation
chapter. However, I am still having the same issue. I cannot add another user
until I delete the one that I have in the database. I have no errors, and the
database populates fine; except, I can only add the next user after I delete
the current one. I have looked over my code and can’t find what I did wrong.
Really sorry about your stress. Can you try creating the user with a different username each time and let's see if it works?
@@AwaMelvine I'll give that a try. The only stress I have is when my ex-wife calls. This is a passion, and nothing that is worthwhile, comes without bumps in the road.
@@AwaMelvine that didn't work. I tried with different everything. It seems that it has to be in the create or update function. Not sure.
@@6191jaken do you use Github? I could take a look at your code
@@AwaMelvine I have an account. I never posted anything on it. Let me figure out how to do that and I will send you the link. Thank you very much.
Suggested #Laravel
I'll implement this same website later on with Laravel in another tutorial series
@@AwaMelvine thanks it should be advanced blog website. ...with laravel jquery ajax
@@MuhammadAdnan-gx6rd :) Okay, I'll consider that. Even though I'm not a fan of JQuery though but we'll see about it when the time comes
@@AwaMelvine okay waiting
@@AwaMelvine not jquery so Vue ?
need help
$stmt->bind_param($types, ...$values);
fatan error: boolen value
you have to call the variable type using i/s ie
$stmt="INSERT INTO eg (id , types, values) VALUE(?,?,?)"
$stmt->bind_param('iss', $id, $types, $values);
hope its not too late
Awal pls I want the HTML and CSS source code
How to upload under article
Do you mean how to create a block post and have it saved in the database? Continue watching the other episodes and you will see it.
why didn't you add comment section?
It would have made the course too long, and I didn't want that because it might have discouraged viewers from watching. I might be wrong but that's what I thought.
But bro can you explain this website is seo friendly or not.
Hi HACKER King, the website is done in PHP so it is server-side rendered. This makes it SEO friendly. Also, we will set the title of the article as the content in the tag on each page. These factors contribute to making the site SEO friendly but there are other SEO optimization techniques that can be done as well but that is beyond the scope of this course.
@@AwaMelvine okk
@@AwaMelvine Bro cane you send me source code because I am creating this project but lod of errors showing.
If you give me the source code, then I will be able to compare for my project.
But bro how to upload image under article
In one of the proceeding episodes, I have implemented image upload. Just continue watching the other episodes.
@@AwaMelvine o
hello bro i need your help
download link ?
For those asking for code and links: codewithawa.com/tutorials