Posts by White • 384 points
23 posts
-
0
votes1
answer164
viewsA: Regex For Numeric Fields
When asked a question here, we’re supposed to have something to guide us. Still, I think this is the solution. Digits from 1 to 9 followed by a semicolon with 1 number or more as decimals.…
-
2
votes2
answers124
viewsA: How to format results display
The solution would be as follows: <?php $novadata = date('d/m/Y', strtotime($linha['DATA'])); ?> <td><?php echo $novadata ?></td> strtotime to convert to time with / or -,…
-
1
votes2
answers1251
viewsA: Foreign key for different tables (Mysql)
The variable you referenced was wrong. It would be cod_author'. foreign key(cd_autor) references autor(cod_autor) ON UPDATE SET NULL ON DELETE SET NULL, foreign key (cd_editora) references…
-
0
votes0
answers31
viewsQ: Registration (Log) of visits to a Website through IP and secure in a BD
After a survey I still haven’t found what I wanted. I wonder if you can help me in the reasoning for this feature. With PHP and Mysql it is possible to save visits to a Website in a database, and in…
-
0
votes2
answers843
viewsA: How to activate version control in Visualcode?
Install the Power Shell plugin and don’t forget to 'sync' after the commit in order to appear in the web application. Restart VS Code to get the plugin installed.
-
0
votes1
answer67
viewsA: Information Is Not Loaded in MODAL Edit After Paging
I think this will help you: <?php while ($mm = mysqli_fetch_assoc($result)){ echo '<tr>'; echo '<td>'.$mm['id_variavel'].'</td>'; echo '<td> <button type="button"…
-
0
votes1
answer372
viewsA: How to Expire Cookies?
I think this will solve the problem: if (isset($_COOKIE['usuario'])) { unset($_COOKIE['usuario']); setcookie('usuario', null, -1, '/'); return true; } else { return false; }…
-
0
votes2
answers1965
viewsA: get mysql data using javascript and ajax
When it is "disabled", it does not store. Try removing disabled in HTML. <p><span class="labelFake">MVA: </span><input type="text" id="mva"></p> Copy and run, see if it…
-
-1
votes2
answers33
viewsA: Introducing formulas in the web application
The easy way: <!DOCTYPE html> <html> <body> <form action="/inserirnotas.php"> MF: <input type="text" name="media><br> T1: <input type="text"…
-
2
votes1
answer84
viewsA: Table populated via bank coming with empty field
The tag <td> is badly closed in selectUser.php. Copy this into your code: <tr> <td>$r[nome]</td> <td>$r[email]</td> <td>$nascimento</td>…
-
6
votes5
answers223
viewsQ: Sum of hours greater than 24 hours
I have a variable with the value '18:00', which corresponds to a duration received through calculations between two times. $tempo = '18:00'; // queria somar 8:00 Answer: $temposomado = '2:00';…
-
0
votes2
answers90
views -
0
votes2
answers90
views -
0
votes1
answer87
viewsA: Bank modeling with classes with n relationship for n
It’s not correct, _rel_organograma_de_porte, you have a link going from you to yourself, please delete it. If variables are connected, you have to make a separate table. When the connection is 'n'…
-
2
votes3
answers892
viewsQ: Date and Time in Datetime format
How do I concatenate these two variables to ISO format (Y-m-d H:i:s)? $data = '17-04-2018'; $hora = '16:12';
-
1
votes1
answer153
viewsQ: Calculation of interval duration
Good morning, I would like to know that someone can help me create an interface in conjunction with the calculation, in PHP, between hours of work with minutes of pause. That is, we would have an…
-
1
votes1
answer37
viewsA: Select with filter in Entity being generated duplicate
When duplicate registration happens, always try to use the distinct in the query you do the search in. It usually works. SELECT DISTINCT [Extent1].[Id] AS [Id], [Extent1].[Nome] AS [Nome] FROM…
-
1
votes3
answers1419
viewsA: Change color of tabs by selecting tabs
I think by inserting style can solve the problem. <div class="panel-body"> <ul class="nav nav-tabs"> <li style="background-color: blue;" selected> **<a href="#texto"…
-
1
votes5
answers289
viewsA: Capture text within the option tag
I think that $("#page1:form_section:form1:selectListCampus").text(); solves the problem. So just go find the selected option and instead of returning you to value, returns the text inside the tag.…
-
1
votes1
answer79
viewsA: c1803 error in kyvi installation
You need to insert the missing file into the project root folder (from the place where you open it) inside a /GL folder. Fix it fine. pastaraiz/GL/glew.h
-
2
votes1
answer84
viewsA: List an item accompaniments from a mysql sale
Utilizes the distinct in the SELECT what you do. I think it presents the set or the last record inserted with the id_sale. SELECT DISTINCT item_pedido.id_venda, item_pedido.id_pastel,…
-
1
votes2
answers545
viewsA: Query DELETE taking too long to load
The best solution I can come up with is for you to draw the line. Delete in the same by adding, for example, LIMIT 10000 at the end of the query. Delete the records in the same but by parcels. A…
-
3
votes1
answer1124
views