Questions tagged as 'mysql'

Tagged questions
4
answers

How to print next line

I have the following code: <? $result = $connection -> query("SELECT * FROM testemunhos") or die($connection -> error); while($row = $result -> fetch_array(MYSQLI_ASSOC)){ ?> <div class="item"> <div class="quote-lef...
asked by 24.03.2015 / 15:54
1
answer

Why does inner join return repeated values?

Good evening, I have a query to two tables in which I want the second table to return all the data with the id of table 1 but only returns me a table value when there are more than one with the same id. I need to return the data all of the ta...
asked by 30.03.2015 / 22:54
1
answer

Problem with checkbox

When I try to check the database if any registry exists, check the checkbox as checked, it always returns me as not checked. <?php $result_cat = $conexao->prepare("SELECT * FROM colecoes WHERE activo = :activo"); $result_cat-&...
asked by 31.03.2015 / 01:03
1
answer

Export MySQL database data to Excel

I'm running a post that sends a string with all the titles and fields of a database, however it only exports when I send up to 4 months. I would like to be able to submit up to 1 year, how could I improve the code below to create this file?...
asked by 02.07.2015 / 21:59
2
answers

Error connecting to MySQL database in Java

Connection code: package br.bent.jdbc; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; public class Conexao { private static Conexao conexao; public static Conexao getInstance(){ if...
asked by 06.07.2015 / 05:13
1
answer

Problem with the code (Find values between one date and another in the database)

The problem is as follows. I am working on a code that will fetch a series of flights that are available between one date and another entered by the user. Dates are entered through the datepicker in js, but I think this part is working fine and...
asked by 13.05.2015 / 11:09
1
answer

MySQL, load upside down

Hello, if I add a file here it goes to the bottom of the list, but I want it to go to the beginning. Codethatexecutesthisif($sql=mysqli_query($coneccao,"SELECT * FROM arquivos_downloads WHERE nome LIKE '%$palavra_chave%'")) { w...
asked by 12.05.2015 / 18:09
2
answers

Blank page when executing sql command [closed]

When I run the index.php page, there is a form that goes to the login.php page When the login page is executed it is completely blank, it does not execute anything. The code is as follows: <?php include_once("../../conf.php"); $mysql...
asked by 12.05.2015 / 14:04
1
answer

Make Submit text and image at the same time

Good night everyone, I have the following question, can someone help me do this (?): Make submit image and text at the same time when doing submit . My idea was to type="file" to make submit of an image be in id=...
asked by 26.04.2015 / 00:47
1
answer

Do submit with and appear JS dialog

<form action="" name="Insert" method="post" onsubmit="alert(1); return false;"> <a href="#" onclick="javascript:document.Insert.submit()" type="submit" >Eliminar</a> <form action="" name="Insert" method="post" o...
asked by 25.04.2015 / 17:01