Questions tagged as 'mysql'

Tagged questions
1
answer

Difficulty in 1: n

Hello, I'm having a hard time making the relationship of one table ( clientes ) and another ( acompanhamento ). Come on. I have these 2 tables in my DB - clients and monitoring. The follow-up table should have the contacts of the...
asked by 03.04.2018 / 21:33
2
answers

Help with date when ordering

I have a field in the table that is set to dtConcat2 timestamp CURRENT_TIMESTAMP and in insert it takes the date of the server and writes in that field, the problem when I print the invoice the date field goes like this: Order...
asked by 03.12.2017 / 13:40
1
answer

MySQL log cleaning

On my MySQL server the myaccess.log file located in MySQL / logs / is a large size, around 30GB. I would like if possible to zero out this file, however I need to make sure it will not compromise database information. If anyone can help me with...
asked by 17.11.2017 / 14:43
2
answers

Create a new database with Mysql username and password directly from PHP [duplicate]

Is it possible to create a new database with Mysql username and password directly from the PHP script? I ask why we are finalizing a registration system where each client will have its own database. If so, could you provide an example? I under...
asked by 17.01.2018 / 13:06
1
answer

Notifications in Android application

I am developing an application and would like to know how I can generate notifications when there is a new record in the database, I am receiving the data via JSON. I was seeing Firebase, but I could not do it.     
asked by 23.11.2017 / 21:20
0
answers

Problem connecting to MySQL by Visual Studio

I'm trying to make the connection through Visual Studio, when I go to configure it 'Data Source Configuration Wizard' / p> Being that I already imported and referenced the MySQL .dll (s) my project. However, it continues to present this error...
asked by 13.11.2014 / 05:37
0
answers

Send data by Ajax, make MySQL query in the background and plot Google chart with the data found

Here's a step-by-step guide to what the code I'm about to do is right. After that I will introduce the new approach that I would like to use, but unfortunately it is not working. In the first place (1) data is sent through a simple form; (...
asked by 13.11.2014 / 13:49
1
answer

Returning more than one variable in JQuery / PHP

Being objective, my problem is this: I have a form in PHP / HTML and I'm using a field auto-fill via Jquery. This form brings up the last numbers wagered by the user and remakes the wager with this numbers automatically without it needing to...
asked by 19.02.2017 / 00:29
1
answer

PHP does not return database result

Hello, I have the following function: function makeLogin($user, $pass) { $pdo = new PDO("mysql:host=".HOSTNAME.";dbname=".DATABASE.";charset=utf8;", USERNAME, PASSWORD); $sql = $pdo->prepare("SELECT user, pass FROM users WHERE us...
asked by 18.01.2017 / 11:17
3
answers

Search for more than one value in the same column? [closed]

The table has the fields (query_id, patient_id, data_exame, result) and has exams from 2010 to today. I would like to bring the records of the patients who took exams in 2011, 2012 and 2015 for example. It has to bring the records in those years...
asked by 19.04.2016 / 21:52