Questions tagged as 'mysql'

Tagged questions
3
answers

How to work with multi tenancy architecture?

I was asked to develop an application with multi tenancy architecture in the PHP language using MySQL as a database. After reading various materials and posts online, I had a question. How to model the application itself? I have two option...
asked by 09.05.2014 / 21:24
1
answer

Group by with subdivisions

I have a SQL that brings the number of people who graduated on a certain date. Let's say that of 300 people, 25 graduated on '2010-06-27'. I would like to include two more columns that will return the number of men and women of those 25 peopl...
asked by 10.12.2015 / 14:22
1
answer

Doubt on using LEFT JOIN in mysql

I have the following problem: I have two tables. students and proof Students have 10 students evidence has 9 results (because one student was absent) The union of the tables occurs through the enrollment field. I want to merge the tw...
asked by 22.05.2016 / 17:12
2
answers

How to do autocomplete JqueryUi with PHP return multiple data?

I have two inputs , I'm using automplete in only one. The autocomplete code: $(document).ready(function() { $.getJSON('include/funcoes/carrega_cidades.php', function(data){ var dados = []; $(data).each(function(key, value...
asked by 11.12.2015 / 20:32
2
answers

Check if username is unique in real time

Hello, guys! Currently, to check if a user name is unique, I do the most basic. I send the POST to a PHP page that checks in MySQL, only then returns the error. cadastro.php: <form role="form" action="https://<?php print $_SERVER['HTTP...
asked by 01.11.2017 / 21:34
1
answer

Updating application (C #) in real time with the Database (Mysql)

I'm creating a client server application, the application would run on multiple machines using the same database (mysql) on an online server. I would like as soon as the data in a table were changed, inserted or even deleted, the other applic...
asked by 20.05.2017 / 07:31
1
answer

How to set up a development environment manually

I'm trying to set up my own development environment on a machine with Windows 10 . The idea would be to install Apache + PHP + MySQL . The problem is that the documentation of the software is quite complicated for beginners like m...
asked by 11.02.2017 / 18:43
2
answers

How to create a csv from a database query and data

I was able to create a perfect .xls file, but .csv can not, it follows the code I used to create .xls $dadosXls = ""; $dadosXls .= " <table border='1' >"; $dadosXls .= " <tr>"; $dadosXls .= " <th&...
asked by 10.11.2015 / 14:31
2
answers

Is it possible to transfer MySQL data directly to a table in Excel?

Is there any way to transfer all the information from the database to a table in Excel? It can be in any language.     
asked by 17.09.2015 / 04:09
2
answers

INNER JOIN with two fields from the same table

I'm having a problem that I have not found a solution to date. I have 3 tables in MySQL: Units: containing store information. Orders: Contains the order information made by store01 for store02, both of which are listed in the units table....
asked by 29.01.2015 / 16:04