Posts by Samuel Verissimo • 57 points
9 posts
-
3
votes2
answers50
viewsA: Connect 3 sql tables to each other using INSERT
I’ll try to clear up some things for you from SQL. You did right in creating the separate tables. You must place the field that has the reference of another table (Foreign key), in main table, in…
-
0
votes1
answer204
viewsA: Open modal bootstrap and ask for password confirmation, if password is right, call another modal
After a while researching, I managed to solve thus: if($senha_confirm == $senha && $senha_confirm_2 == $senha) { echo" <script> $(document).ready(function() {…
-
0
votes1
answer204
viewsQ: Open modal bootstrap and ask for password confirmation, if password is right, call another modal
I am asking the confirmation of a password for the user, in case the password is right, call another modal with other options, wrong case, display that the password is wrong. I don’t think I know…
-
-1
votes1
answer225
viewsQ: Save checkbox fields that are displayed through a WHILE with PHP?
I have a table called tarefas_check, when there is record in this table, the record is displayed this way: <!-- Checklist --> <form method="post" action=""> <?php $sql = "SELECT *…
-
0
votes2
answers205
viewsA: Changing the value of a variable when selecting an option
I was able to sort the table that way <div class="sorting"> <form action="" method="POST"> <select name="filtro" onchange="this.form.submit()"> <option value="a">Ordem…
-
0
votes2
answers205
viewsQ: Changing the value of a variable when selecting an option
In my product table, I would like to make some basic filters, such as sort by alphabetical order, price, etc... The idea is as follows, when the user selects a option (does not necessarily need to…
-
-1
votes1
answer166
viewsQ: Add days to a date in mysql and compare it to the current date?
I have some conditions on a page of my system, I need to put something in my SELECT so that on his own SELECT has already entered a certain condition. The condition is as follows, I need these two…
-
0
votes3
answers202
viewsA: Ways to take only the month of the dates recorded in the database
I had nowhere to run, and I ended up using the SELECT MONTH, I didn’t know I could select a field twice in one SELECT, follows my answer below that it worked: $sql = "SELECT comercio.*,…
-
0
votes3
answers202
viewsQ: Ways to take only the month of the dates recorded in the database
I need to take only the months of the dates of a given field that is in my database, however, preferably without using SELECT MONTH. That way, we get the current month of today’s date: $mes_atual =…