如何从phpMyAdmin获取数据，具体取决于用户选择的难度级别

Question

i am trying to get some words for my Hangman game from the database depending on which difficulty level the user selects so if the user selects "easy" the only words i want it to select is just the words that have "easy" next to it from the database. right now it selects all the words as you can see in this image --> . this is my difficulty page i hope i explaining this question properly so that everyone can understand me, if you don't understand what i am trying to say please let me know.

Answer 1

Use this

$difficulty = 'hard'; //Value based on user selection
$conn->prepare("SELECT 'word' FROM words_list WHERE difficulty= ? ORDER BY RAND() LIMIT 1");
$conn->bind_param("s", $difficulty);