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

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

Building game apps in Sketchware

Last week I gave a tutorial on how to create a quiz app using Sketchware. Maybe you want to create a more complex game and that is possible using Sketchware. Today we will be looking at creating more complex games such as an endless runner, car racing or any animated game. You could even create a 3D game but that is of you can create the graphics.      The first step is deciding what kind of game you want to create. This starts with the objective of the game, how the user will earn points, the various levels as well as customizations and upgrades. Once you have the concept you can then start building your app. This tutorial will show you how to create a game app like the one in the video below. Still needs work but I hope you get the idea. What you will need For a simple game app, you will need the following:  1. A sprite sheet These are images of your various characters e.g. it can be a happy face, sad face, angry face and so on. If it's a runner, you can have them at rest and th

How to save data to local storage in Sketchware

At some point you might want your users to be able to save or store data for later use. This might be when a game is paused or when recording information.  There are two ways to save data in an app. One is using the Shared preferences component which saves data in the user's device storage or using online storage such as Firebase database or Firebase storage 1. Shared Preferences This saves data on the user's device or phone memory and thus it is also referred to as 'saving to local storage.' This means that when the User deletes the App, then that data is also lost. 2. Firebase Database/Storage This saves the User data on a central database managed by Google but under your control. Just like your email. This data remains in your database when a user deletes the App. It is also the platform from which messages are stored and received when chatting.  Tutorial For today's tutorial we will save data to Shared Preferences Step 1 Add an *edittext* widget to your app.  Ch