Questions tagged as 'mysql'

1
answer

Bank query for another variable

I have the following scenario, I make a query to the database and return all the data: <?php include ("conectar.php"); $query = "SELECT * FROM pontos ORDER by pontos DESC LIMIT 0,10"; if ($result = mysqli_query($link, $query)) { $list...
asked by 20.05.2015 / 19:51
2
answers

Search mysql database with php with multi-level

I am trying to perform the following query in the database, through an html form, but in php I am only able to fetch all the data from my table. In case the user would choose the type of filter and would be made a query in the database, I am usi...
asked by 18.05.2015 / 17:48
1
answer

(Hibernate2) GenericJDBCException: Could not execute query - Closed session error while navigating the platform

Good afternoon! I have a web application and I decided to migrate it to Cloud from google. When I start my tomcat, the application runs smoothly, but after a certain time, these errors begin to appear. 09:24:35,719 WARN [JDBCExceptionRepor...
asked by 25.05.2015 / 21:18
1
answer

URL Friendly by title

Good evening people, I am here implementing the friendly url system on a website and I already have to work for some page, I am now blocked in the file view_establishment which is what shows the establishments in this case I have for example...
asked by 08.02.2015 / 02:28
1
answer

How to show related table data in an organized way by topics

I have a question in SQL that is as follows: I have two tables, the parent table, and the daughter table, where the daughter table receives the id of the parent table as foreign key, however, I do not know how to show the data entered in...
asked by 08.01.2015 / 18:37
1
answer

How to do update via ajax + php

I want to update data through a modal, however it is not updating. Anyone have any idea why you're not updating? Modal: <script type="text/javascript"> $(document).ready(function() { $('#salvar').click(function() { var des...
asked by 27.01.2015 / 01:02
1
answer

How to make a request on the server using the COMET method?

I have a system, in which it displays database files, in list form. I query the database every 5 seconds using the Polling method. How do I use the Comet method? Since this method is not asking for server information all the time.    ...
asked by 15.09.2014 / 16:47
1
answer

Update of Multiple Images

My code is currently playing its part well up and putting the watermark on upload images, but I would like to be storing the names of all images in the database. $idnoticia = $_GET['idnoticia']; $watermark = imagecreatefrompng('watermark.png'...
asked by 06.04.2015 / 15:17
1
answer

Configure Relational and Non-Relational databases in the same project with Spring-Data + Hibernate

I'm trying to create a Java application where I need to set up two databases: MongoDB and MySQL. My idea is to use Spring-Data with Hibernate for both banks, but I found only tutorials for setting up Cross-Store between the banks. Is there an...
asked by 08.04.2015 / 00:06
4
answers

Loading values from a select in my GridView

My DAL that does Select and saves it in type list using System; using System.Data; using System.Collections.Generic; using System.Linq; using System.Web; using MySql.Data; using MySql.Data.MySqlClient; using Geax1.Model; namesp...
asked by 24.09.2014 / 17:41