Skip to main content

Mysqli_fetch_assoc not returning result [Solved]

So I recently came across this scenario where I needed to retrieve data using the mysqli_fetch_assoc() function but was not getting any output. My code was running and it wasn't giving me any errors. I tried using mysqli_num_rows to check if there was a result and it returned 1, meaning there was a result. So if you're in the same situation, I hope this will help. I had the following code:

$query = "SELECT id FROM users WHERE id = $user_id";
$result = mysqli_query($con, $query);
$row = mysqli_fetch_assoc($result);
echo $row['username'];

After hours of cracking my head, going through my code and countless Google searches I finally realized my mistake. If you take a closer look at the code above, you will realise that I am only selecting the id column from the users table. The result will thus be a table with a single column- id. So if I check whether the query returned a result, the answer will be yes. However that result does not contain the 'username' column which I am trying to echo at the end of my code snippet, meaning there won't be any output. So in order to fix this, I made a slight change to my code to select all columns that I needed. The code now looks like this:

$query = "SELECT * FROM users WHERE id = $user_id";

The result returned by this query contains a number of columns, including the 'username' which I am interested in.

I hope you found this helpful and manage to fix that bug that's been stressing you.

Happy coding


Popular posts from this blog

Hip hop and RnB songs to apologize to your partner

Love is a beautiful thing, but it often goes wrong. This often leads to pain, suffering and sorrow.  Being imperfect beings, hearts tend to get broken all the time regardless how hard we may try to avoid it.  The heartbreak is often inadvertent but at times we find ourselves in the wrong. An oversight, a word unsaid or even a lapse in our judgement can cause our loved ones harm. This doesn't always have to be the end though. Oftentimes, relationships can be mended by simply uttering three simple words: "I AM SORRY". This article is a collection of some of my favourite 'I'm sorry' songs. I hope you'll enjoy these apology songs, but more importantly, I hope you will get a few quotables and some wisdom nuggets from them.  The best apology however, is to change behaviour (got that from a Jay Z interview) so as you apologize, please remember that it was your actions that hurt them. The best apology is one which involves you not repeating those same mistakes aga

How to easily create background notifications in Sketchware(original)

One of the keys to building a successful app is to find mechanisms that will keep your users engaged. You can do this by using background notifications. This tutorial will show you how to do that in Sketchware. We will cover: 1. How to create notifications in Sketchware 2. How to show these notifications even when the app is closed. We will start by creating a new project. If you do not know how to create a new project please check out this article here. Once we have created our project, let us create a more block to place our code. Navigate to the events menu and then to the moreblock section as shown in the image above. Create a moreBlock. I have created a moreblock with the name "BackgroundActivity" with a boolean variable named "run." See the image below for how to add the boolean variable. Place the following block in the moreBlock Background activity code: moveTaskToBack(_run); That will move our task to the background.  Please note, that at this point we have

Php date: How to get the first and last day of the week

In this tutorial, I'll show you how to get the first and last day of the week in php. By default, in PHP the week runs from Monday to Sunday. However we'll cover two methods to get the first and last day for both those who consider Sunday or Monday as their first day of the week. We will be using 2 functions to achieve this: date() strtotime() We will use a combination of these two functions and store the result in a variable.  How to get the first day of the week If you want to get Sunday, use this method: $firstday = date('l Y-m-d', strtotime("sunday -1 week")); echo $firstday; If you want to get the date for Monday, this current week, use this method: $monday = date('l Y-m-d', strtotime("monday -1 week ")); echo $monday; How to get the last day of the week The following code will give you Saturday as the last day of the current week. $lastday = date('l Y-m-d', strtotime("saturday 0 week")); echo $last