Questions tagged as 'mysql'

Tagged questions
0
answers

How to display and hide bookmarks in Google Maps with MySql?

I made a site with Google Maps that used each position of an array for each marker ... var map; var markers = []; function initMap() { var uluru = {lat: -23.9651447, lng: -46.3838347}; map = new goog...
asked by 31.10.2017 / 01:05
1
answer

How can I show an image that is in the database using jsp?

Well, here's the thing. I'm using JSP, SERVLET and MySQL to insert images into my project, I just happen to save the image path in the database, and then call that path to show the image. Hence the problem: <% ArrayList<Fotos>...
asked by 19.11.2017 / 20:02
0
answers

How to do a return from a Stored Procedure - MySQL

I'm doing a login screen, but I can not return the ID of the selected user. DELIMITER $$ USE webnote $$ CREATE PROCEDURE login (IN email2 varchar(60), senha2 varchar(16)) BEGIN if EXISTS(select id_aluno from aluno where email = em...
asked by 20.11.2017 / 20:13
1
answer

Delete a record from the database when the deadline expires

How can I automatically delete a record from the MYSQL database when it reaches a deadline? remembering I'm using a date_termino attribute of type Date     
asked by 20.11.2017 / 19:00
0
answers

Questions about loading combobox in C # with MySql database

Good afternoon, I'd like to know how I can populate a C # combo box with data from a table in MySQL. I am making an application for a jewelry store, and I would like to know how I can fill out the combo box of suppliers through your code (or id,...
asked by 06.11.2017 / 16:41
1
answer

Help - Logical Formulation - SQL, PHP, HTML [duplicate]

I have a table in the bank with a team register, where each line corresponds to an employee and his respective team. For example, employee_id, employee 1, Mario 1, Sérgio 2, John 2, Joseph I want to bring the data on the scre...
asked by 06.11.2017 / 19:51
1
answer

error creating simple like button

I'm trying to create a simple like button that simply adds a +1 to a table in col like, ignoring that it can click more than once and that it is subject to invasion because it's just a test. The way it is now it gives me the following errors:...
asked by 06.11.2017 / 16:33
0
answers

How to make two querys in a JSON?

I'm putting together a map using the mapbox API, creating some points dynamically on the map. I have a JSON that gives me some information (getDados.php), however I wanted to perform one more query within that file and get some more data from ot...
asked by 25.10.2017 / 13:07
1
answer

Error trying to insert information into mysql database

I have the following tables Produto { idproduto nome preco } Promocao { descricao datainicio datatermino id_produto_fk } When trying to insert a new promotion I get the following error: com.mysql.jdbc.exceptions.jdbc4.MySQ...
asked by 28.10.2017 / 04:05
1
answer

How can I transform a BLOB file into an image using PHP?

I need to transform a BLOB file that comes from a MYSQL database to the Image type, to use on my site, I need to do the conversion using PHP, when I use the image in BLOB format, it goes to the whole site in binary .     
asked by 18.11.2016 / 18:08