Passing database values to JavaScript under Symfony? [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 5 years ago.

Improve this question

I am creating an autocomplete tool for a specific input field in a form. The autocomplete is fed by a JavaScript array containing the values to suggest, and it works the way I want with fake values. But now, I want to feed the array with actual values from my MySQL database, meaning I have to get my DB's values (an entire column's values, it happens) to this array somehow. Note that I only need to store these values once, like when the page loads.

I've been browsing a lot, but haven't tried anything by lack of understanding of the code and mechanisms. The answer I need is close to what this thread is suggesting, but I couldn't understand how the OP linked his controller to his JavaScript (storing the value of an HTML element with the ID "categories-fetch" in a JS variable seems a bit insufficient to me, if not irrelevant).

I am using HTML-CSS-JS for the front end, Symfony and Doctrine for the back-end and DB communication with MySQL. Any ideas?

SOLUTION EDIT:

With help from @Davis, managed it with a method that gets the data:

From the database to PHP
From PHP to Twig (@Davis's answer)
From Twig to JS

As I said, I haven't tried coding anything yet, pretty much knowing that I wouldn't get to the intended result if I couldn't understand the mechanisms and how to adapt others' solutions to my code. Nonetheless I'm adding a link to the SO post that gave me a solution closest to what I needed, if it can help — MatTheLemur
– MatTheLemur, Commented Oct 31, 2020 at 5:45
So... you are building a datalist. Can you tell us more about your setup? Are you using webpack, building the js array with twig? — msg
– msg, Commented Oct 31, 2020 at 6:18
My JS array is built with fake, hard-coded values. Though I am using Twig for this project, I don't believe it would be useful to build the array as I wouldn't be able to fetch an entire table column's values, just info regarding a specific record. Also, I'm using a textarea with an added autocomplete feature (got help from here) as opposed to a datalist, and am not intending to change mainly because it needs to be a large input field. Not using Webpack at the moment — MatTheLemur
– MatTheLemur, Commented Oct 31, 2020 at 6:48

Davis · Accepted Answer · 2020-10-31 06:48:36Z

0

I can't add a comment yet!

I hope this article can help you

creating templates

// php
return $this->render('xx/xx/xx.html.twig', [
    'data' => [
        'name' => 'davis',
        'age' => 18,
        'sex' => 'M'
    ]
]);

// twig
<select id="ice-cream-flavors">
    {% for column, value in data %}
        <option value="{{ value }}">
    {% endfor %}
</select>

answered Oct 31, 2020 at 6:48

Davis

965 bronze badges

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

2 Comments

MatTheLemur Over a year ago

Thanks, I've been looking into it since I saw your message, and I'm thinking it could work if I can query for and send a DB table column into that variable used in the render statement, since there's also a way to send data from Twig to JS. Working on it, it would be nice if it fit that nicely

Davis Over a year ago

Is it possible to get data through Ajax calling API interface?

Collectives™ on Stack Overflow

Passing database values to JavaScript under Symfony? [closed]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related