Posts by Jefferson Ricardo • 105 points
12 posts
-
-1
votes1
answer32
viewsA: Delete in Foreign Key
ALTER TABLE SUATABELA DROP CONSTRAINT FK_SUACHAVE And try to delete your table. I hope I helped. =)
mysqlanswered Jefferson Ricardo 105 -
1
votes4
answers294
viewsA: How to shadow a text
Use the attribute in your css for text use text-shadow: 0 0 3px #000; for Divs use box-shadow: 0 0 5px #000; it is good you give a studied on these attributes to facilitate in the editing of your…
-
2
votes2
answers43
viewsA: Insert button value into database
For this you need to use Ajax and php let’s go I will create a simple example for Voce better understand: <button type="button" id="pequeno-almoco">Pequeno Almoço</button> <!-- Botão…
-
0
votes3
answers50
viewsA: Bring data from Table and returns no results
Replace your code with this. <?php $servidor = "localhost"; $usuario = "vitor"; $senha = ""; $banco = "funcionarios_db"; $mysqllink = mysqli_connect("$servidor","$usuario","$senha","$banco");…
-
0
votes1
answer66
viewsA: How to search table information by id and send to another part on the same page?
Try to create this icon of the item as link, and the link puts to call the specific page and assigns a parameter as for example <a href="editar-alunos.php?id=1">Editar</a> in php you…
-
-2
votes3
answers86
viewsA: Alert function is not running when clicking the button
$(document).on("click",".botao",function() { var input1 = $('input[name="nome"]').val(); alert(input1); }); <script…
-
0
votes2
answers201
viewsA: Return an "error" message if the mysql query returns empty
if($resultado_usuario->num_rows() > 0) { while($dado = $resultado_usuario->fetch_array()) { //Conteúdo se não for vazio } } else { //Retorno vazio }
-
0
votes2
answers183
viewsA: How to redirect user after login according to user level?
after logging in instead of creating a direct redirect link, it does a validation for redirects of each user level, i.e.: $query = "select nome, usuario, nivel from usuario where usuario =…
-
1
votes2
answers77
viewsA: How to pass a value from a button (dynamically created within a td) to an ajax function and query the database with that value?
Create a button with a class to call after the click on the button create an id to pass the value to variable. $(document).on("click",".seubotao",function() { var id = $(this).attr('id'); $.ajax({…
-
-1
votes2
answers91
viewsA: Responsive Filter
For responsive attributes, you need to apply to your css ex: @media screen and (max-width: 767px) { /* 767px ate a largura*/ #button1 { width: 50px; } } take a look at this article…
-
-6
votes4
answers4763
viewsA: Delete multiple rows from a database
Utilizes the checkbox in your table name="item[]" in PHP creates a loop with foreach: foreach($_POST['item'] as $item) { $sql("delete from paginasimagens WHERE id = '$item'");<br> $sql =…
-
1
votes2
answers63
viewsA: How to add new table row with contents from text box with post ajax
"If you use the mysql follow": Like you’re using the api datatable applies a function of reload in return. on the return of ajax apply this: $('#dataTable').DataTable().ajax.reload( null, false);…