Questions tagged as 'mysql'

Tagged questions
2
answers

How to avoid duplicate records in the Database?

I'm doing a register in PHP, and I want to do that if a user is already registered, I can not do it again. In the controller I have the following code: ' try { $daoaccesori = new DAOAccesori();...
asked by 05.02.2018 / 11:24
1
answer

How can I give limited time to events in a Mysql and PHP table?

Good afternoon everyone apologize for my little annoyance. I have a little doubt, I'm trying to give time to each event that enters the db Event table in the duration column, what I want to do is count down to "0" and then delete all the row...
asked by 16.02.2018 / 20:36
0
answers

My application crashes when I query in large amounts of DB MySQL data

I have an application developed to generate reports the language that was used was C sharp, this application connects to a MySQL DB in a server that is inside the same network, the reports are generated by parameters of date and time, At the mom...
asked by 05.02.2018 / 18:31
1
answer

Mysql oberten singles of artists

I'm trying to get the user's singles, but I can not do it. If someone gives me a hand I'd appreciate it. Here I leave my database link     
asked by 16.02.2018 / 18:17
0
answers

ajax php mysql select dependent

I have a select that depends on another, when selecting the first one it throws me an error in a modal window of the browser "parsererror" and it does not load the data associated with the option of the first select. I have looked for the way to...
asked by 05.02.2018 / 18:41
0
answers

How to save the ID of an insertion in BD in another table in PHP?

I have three tables: MAIN : ID_main, date, name REGISTER : ID_register, data MODIFICATION : ID_modification, data, register_ID MASTER : ID_master, main_ID, register_ID, modification_ID Operation: I fill in the MAIN data....
asked by 19.02.2018 / 20:13
1
answer

MYSQL Retrieve copy

I find a situation that had not occurred to me until now. I have an application whose database is MYSQL. The other day something happened and some records were lost. Now I have recovered the copy of the early morning in which step is lost...
asked by 05.02.2018 / 16:28
0
answers

save canvans in variable blob of mysql with a post ajax and php

I need your help a week ago I am trying to store an image of a Canvas in a mysql table, the column of the table is of type longblob. the HTML is as follows: <!DOCTYPE html PUBLIC > <head> <meta http-equiv="Content-Type" content=...
asked by 05.02.2018 / 17:54
0
answers

BD by default in Vtiger CRM 6.0.0

Good morning, I'm using Vtiger CRM 6.0.0 I have the CRM, but I do not have the BD, and I can not install a new one either. What I need are the instructions that create the structure and the data. Does anyone know how to create the defaul...
asked by 06.02.2018 / 14:08
0
answers

Connect mysql using the real ip

Good, I want to configure the mysql server of the xampp so that it can be connected for example by "navicat" using the real ip of the server (152.34 ...). I can only do it with ip 127.0.0.1 on the same pc.     
asked by 02.02.2018 / 16:10