Casting PHP into an array and looping through

Question

I am working on an application for our karate school and would like to get the technique names from the database, store them in an array in a random order and be able to click a button to move through the entire array one at a time.

I have thought about this in several different ways including just doing it randomly from the database which was pretty easy, but it pulls the same technique multiple times and I only want it done once.

Sample code below lists them all randomly just like it should and when I refresh the browser it creates a new list just like I want. Now I would like to know how I could display only one at a time and keep it in the browser until all of them have been gone through.

$sqlQuery= "Select * from Techniques Order BY Rand()";
$statement = $db->prepare($sqlQuery);
$statement->execute();
while($row = $statement->fetch(PDO::FETCH_ASSOC)):
    $techniqueName = $row['Technique_name'];
?>
    <ul>
    <li><?php echo $techniqueName; ?></li>
    </ul>
<?php endwhile; ?>

I really have no idea if this makes any sense. I would also like to stay away from javascript if possible, although that is not really a requirement. Basically it is a fun little game idea that would allow the students to practice without doing the same technique a bunch of times and missing other ones.

Any thoughts would be much appreciated.

So basically you are saying you want them presented randomly BUT that all should be shown before the list is repeated right? — RiggsFolly
– RiggsFolly, Commented Jul 21, 2018 at 18:26
I don't understand what exactly you are trying to do here. But, from what I've understood: you said that you have found a way to do it but the issue with that specific solution is that it repeats the same value multiple times. So, to get rid of the repetition, you can use array_unique($array) function to get rid of repetitive values. — Ali Nisar Haider
– Ali Nisar Haider, Commented Jul 21, 2018 at 18:31
The solution that I had come up with just got another random value from the database, which ended up with it get the same ID on multiple occasions. I have not figured out quite how to do it with an array yet hence my problem. I am still learning as well which does not help matters. — D.j. Dimick
– D.j. Dimick, Commented Jul 21, 2018 at 18:50

Progman · Accepted Answer · 2018-07-21 19:45:41Z

3

If you want to "stay away from javascript" you can save the values in an array, which is stored in a session. On a reload the array in the session is read and one random value is popped from it. At each request the array in the session gets smaller until the array is empty. Then you can reload a new set of techniques from the database. The source code could look like this:

<?php
session_start();
if (!isset($_SESSION['data'])) {
    /*
     * Access the database here. For testing purposes
     * create a dummy array instead
     */
    $array = range(1, 10);
    shuffle($array);
    $_SESSION['data'] = $array;
}
$value = array_pop($_SESSION['data']);
if (!count($_SESSION['data'])) {
    // array is empty, delete it so a new one gets created on the next request
    unset($_SESSION['data']);
}

echo "The current value is: ".$value."<br />\n";

// only for debugging:
if (isset($_SESSION['data'])) {
    var_dump($_SESSION['data']);
} else {
    echo "No array in 'data' set\n";
}

If you want to use javascript you can load all the values in a javascript array. Then you use javascript to iterate over the array and display the value you want until you reached the end. After that you can send a new request to get a new set of techniques from the database.

edited Jul 21, 2018 at 19:45

answered Jul 21, 2018 at 18:26

Progman

20.1k7 gold badges58 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

RiggsFolly Over a year ago

Its a sort of answer, but it would be much better if you actually provided some code to demonstrate how to do this

D.j. Dimick Over a year ago

I like the idea of doing it with a session sort of scenario, and then refreshing to get a new session, however that is beyond my current understanding as @RiggsFolly said some code to demonstrate that or even where I could go/search to start putting those pieces together would be awesome.

D.j. Dimick Over a year ago

after putting the $value['fieldName'] in the out put of that echo it returned exactly what I was looking for thank you @Progman and everyone else that helped.

Collectives™ on Stack Overflow

Casting PHP into an array and looping through

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related