Posts by Rogério de Sá Jr. • 67 points
9 posts
-
1
votes1
answer73
viewsQ: Single-line save in DB, the result of the PHP variable (WHILE/LOOP) of a MYSQL Query
I have the following problem: When performing a query, the while result is composed of more than one value, for example: $query_sku = mysqli_query($connect, "SELECT t.column_name FROM skus AS s…
-
0
votes1
answer158
viewsQ: How to echo the value of a variable from the query result
To automate my process of generating one JSON, i save the variable name in the database (Ex: $teste_value_1). In my php file. i have the value of this variable, for example $teste_value_1 = "Isso é…
-
1
votes1
answer587
viewsQ: Insert JSON file into database via PHP
I have a JSON file that I need to do the Insert of the information contained in it in the database. JSON file:…
-
0
votes1
answer1243
viewsQ: How to capture (GET) multiple values sent in the same variable (PHP)?
After a query, I am sending different values through the same variable (through an input): <input type="hidden" id="sku" name="sku" value="<?= $reg->sku ?>"> This way, my URL is as…
-
0
votes1
answer651
viewsQ: Select "select" values through "GET"
I’m trying and I can’t seem to do the following: I thought to "automate" the system reporting process that I am doing, for this, when registering the PRODUCT, you also register the column id name…
-
0
votes3
answers90
viewsQ: How to do more than one select in the same query in different BD tables?
The problem is this: I have the tables: Which are foreign keys in the following table: And I need to pull all the column names "modelo_conector", "nome_genero_conector" and "tipo_de_conector" and…
-
1
votes2
answers1174
viewsQ: How to do more than one select in the same query?
How can I do more than one select in the same query? I tried it this way (using UNION), but it didn’t work: DATABASE Table: cameras_lines id_camera_linha | nome_linha_camera Table: manufacturers…
-
0
votes3
answers17051
viewsA: Change a select based on the selection of another select (from data in BD)
****I was able to solve it this way**** I set an example with states and cities because I believe it’s easier to understand what the problem was and what the solution is: index php. ?> <?php…
-
2
votes3
answers17051
viewsQ: Change a select based on the selection of another select (from data in BD)
I have the following problem: In a form, I need to select a MANUFACTURER, and according to this selection, it shows the PRODUCTS linked to that manufacturer only. I have the following table where I…