Fill PHP array with button click

Question

Long time viewer, first time asking a question. College student new to PHP so hopefully I do this right.

I have a webpage in PHP which connects to a MYSQL db and reads back the data to the page. As the data is being read in, it populates an array. Each item that is being pulled from the db is set to a button.

Ideally, I only want to fill the array with the item that is clicked. Is it possible what I'm trying to do or is there a better alternative. I have seen that elements such as buttons are client side whereas PHP is server which (I think) indicates that I would have to refresh the page.

Thanks in advance for any help and patience!

<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "project_db";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) 
    {
        die("Connection failed: " . $conn->connect_error);
    } 

    $sql = "SELECT ingredient_id, ingredient_name FROM ingredients"; 
    $result = $conn->query($sql);

$array = array(); //used to hold each ingredient as a variable to pass to php script
array_unshift($array,""); 
unset($array[0]); //our first ingredient_id is set to 1 so I've started my array at 1 to allow for that
$_SESSION['arr'] = $array;

if ($result->num_rows > 0) 
{
    // output data of each row
    while($row = $result->fetch_assoc()) 
    {
    echo "<br /><button id='$row[ingredient_id]' name='button' value='button' class='btn-info btn-lg' onClick='return addItem($row[ingredient_id])'>$row[ingredient_name]</button><br />";
                array_push($_SESSION['arr'],$row['ingredient_name']);
    }
} 
else 
{
    echo "0 results";
}

    $conn->close();
?>

You can create ajax query for transmision data on client to server with out reload page, sorry for my english. — Naumov
– Naumov, Commented Feb 24, 2016 at 12:22
purplepsycho - I am trying to only save certain items to an array so that I can use anything that is in the array across multiple web pages. I still need to read in everything that's in the database though. — sumosaurus
– sumosaurus, Commented Feb 24, 2016 at 14:39

brokensax · Accepted Answer · 2016-02-24 14:15:01Z

1

Use javascript to get the data from the DB using an AJAX call. For the button click part, you can use jquery's on.click() function

answered Feb 24, 2016 at 14:15

brokensax

693 bronze badges

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

4 Comments

sumosaurus Over a year ago

Am I correct in saying that I would be able to fill a js array then? Will the other pages of my website be able to see that js array?

brokensax Over a year ago

If I understand you correctly, then once you get the data in javascript, you can dynamically create html code and add it to a pre-specified <div> in your view or html. This way, every time something new comes as the response, your page will be modified accordingly.

sumosaurus Over a year ago

Sorry @brokensax I wasn't clear. I want to use the contents of the javascript array on another page of my website (something equivalent to a session variable in PHP).

brokensax Over a year ago

Yes, you can. Check this link for more information : stackoverflow.com/questions/21065193/…

Collectives™ on Stack Overflow

Fill PHP array with button click

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related