How to Create a Blog PHP & MySQL database #20 | Create, Read, Update topics

In this episode, we implement the create, read, and update features for topics on the admin section.

[HoaNguyen-rpkb]

it's great, everyone followed from part 1 to now, everything works great, you helped me a lot, thank you so much

[sentimentscity]

Thank you so much Awa love and support from the 🇵🇭🇵🇭🇵🇭🇵🇭🇵🇭🇵🇭🇵🇭

[urbaindesign]

Mr Melvine Awa!
Thanks a lot once again for the good work you're doing.

I appreciate a lot

Please continue your good deeds.

#AwaInspires us a lot

[poets]

i am having an error Fatal error: Uncaught Error: Call to a member function bind_param() on bool in db.php:18 i need help i did as it has been done in your videos i checked many time but its not working

[anarishakari]

Amazing. Waoo... I am getting practical.

[anthonyakro]

Amazing content!!! I have been following up from the first video. Please how soon will the next video be uploaded? I am anxiously waiting.

[TELMACSolutions]

how did anyone bind the id (which is of type int) to the update query function in the admin folder and have it retrieve results?

[TELMACSolutions]

hi all, anyone following this in 2023? found this error: Uncaught Error: Call to a member function bind_param() on bool in for admin create posts but signup in root folder working well. checked table name, sql query, nothing seems to be the issue

[PrinceStiles]

Hello Sir, please in the statement to get the id from the browser, in the case of $id=topic["id"]; $name=topic ["name"]... I have an error which says "undefined index: id and same applies to the name and description" ... I realized it's because of the topic["id"] for instance that we assigned to the $id..

Please how may I address this error?

[gandepuunlanshima]

Hi Awa, great job thanks. Pls I ran into trouble with $topics_id = create('topics', $_POST); It says Fatal Error: uncaught error call to a member function bind_param() on bool in... executeQuery(INSERT INTO top.. ', Array)...
Every other thing works fine once I remove the creat function. My messages display fine but topic is not created in the data base... When I dump it in the browser dd($_POST); it works perfectly. Once in call on the create function as above.. I get that error...

[Joseph_Ibrahim]

greetings Sir Awa, uhm i have a little problem...i keep getting this error sir Fatal error: Cannot redeclare executeQuery() (previously declared in please how do i go about it sir. thanks

[vusimbhamali]

Awa, great tutorial. Please advice if this whole exercise can run on PHP 7?Thank you in advance.

[DevelopmentKit]

Trying to access array offset on value of type null in on line 23

why facing this problem?

[abdullahfajrutheen]

awa melvine please tell me what is your xampp server version

[rogbazeez]

Hi Mr Melvine,
I seem to have run into some problems as i cannot get add-topic to create topics. i keep getting http error 500 unable to handle request. please i would need your assistance.

[CEKC]

Who has the error: Fatal error: Uncaught Error: Call to a member function bind_param () on boolean in ...
Change in file "create.php" <input type = "text" name = "title" class = "text-input"> to <input type = "text" name = "name" class = "text-input">

[HoaNguyen-rpkb]

hi Awa, How do I display posts grouped by custom taxonomy?
I'm trying to group the same post $published = $post['published'];
this is how i do it and it doesn't work can you help me?!!!
<?php foreach ($topics as $topic): ?>
<h1 echo $topic['name']; ?></h1>
<hr>
<?php foreach ($posts as $post): ?>
<div class="">
<div class="">
<h2><a href="single.php?id=<?php echo $post['id']; ?>"><?php echo $post['title']; ?></a></h2>
</div>
</div>
<?php endforeach; ?>
<?php endforeach; ?>

[urbaindesign]

I have a suggestion, I know you have planned this course already and I don't know if you have plan of creating a 404 page and talking about .htaccess?
Thanks a lot.

You don't have to change your plan if you have not planned it.

But think of it

[anisarip]

the variable value="<?php echo $id; ?>" and others is undefined

[xVecna]

I can't get to fetch $description and other values after i click on Edit.
any advice?
code seems clear to me...