Questions tagged as 'mysql'

2
answers

Group in mysql along with join

I have a student table and a parent table. A student may be associated with up to three parents. SELECT a.idAluno, a.matriculaAluno, a.nomeAluno, a.sexoAluno, a.dataNascAluno, b.id, b.matricula,...
asked by 20.04.2017 / 22:06
0
answers

How to call input text function when clicking category

How to create a function that when clicking category it opens a screen with input text for an observation in the request. If anyone can help me with this, I give two complete POS systems. Mycodelookslikethis:<divid="box...
asked by 20.04.2017 / 18:37
1
answer

Mount dynamic table with php

Hello, I'm trying to build a report page in php using data from the database but I'm not able to lay the data horizontally correctly. The logic is as follows: The search fields are: startingdate|enddate|stations(canbe1ormore)Thissearchsho...
asked by 04.05.2017 / 15:23
1
answer

Hybrid deployments with PHP Laravel MySQL + MongoDB

I'm developing a system with PHP Laravel + MongoDB . The login part and password will be modeled using MySQL and I will use MongoDB to do a quiz . I was thinking of putting a Schema in% with% of this type:...
asked by 04.05.2017 / 22:51
1
answer

Format the last result of the Select Mysql different

I need to put the last result in a different format. like in a mysql table, for example. <a class="registro">Valor 1</a> <a class="registro">Valor 2</a> <a id="ultimoregistro" class="registro">Valor 3</a>...
asked by 04.05.2017 / 17:15
1
answer

Navcat bank connection

I would like to resolve a data connection problem in navcat. I can not send the data to the database and I do not know what I'm doing wrong, if anyone can give me some suggestions, the connection is mysql . config.php: <?php $config = a...
asked by 11.05.2017 / 15:41
3
answers

No select error using mysqli_query

I've done a php to list the rooms, but I'm having difficulty listing them, if anyone can help me, I would appreciate it. <?php $link = mysqli_connect("localhost","root","","hotel"); $result = mysqli_query("SELECT descricao FROM quartos WHER...
asked by 08.06.2015 / 21:53
2
answers

Logic for query in signatures system

Hello, I'm developing an online subscription system for a client, and I've come across a lot of difficulties. I will explain a bit about the system's operation and what difficulties I am having. My system has 8 plans, registered in a table c...
asked by 30.04.2017 / 03:31
1
answer

Return results on different inputs

Well, here's my code. My query is returning the results I want, however, it is only returning in one input. How do I return the name_id in an input and the location in another? <?php $nome = $_POST['name']; if (isset($_POST['nam...
asked by 29.04.2017 / 23:08
0
answers

INFO: Error parsing HTTP request header

When submitting a form, I was testing how much information I can send via HTTP. I am using Mysql DBMS. I have an application that runs several fields of type textarea. Example: a form with 10 textarea (I use a field limiter to validate the am...
asked by 29.04.2017 / 23:57