Questions tagged as 'mysql'

Tagged questions
1
answer

CRUD MySQL with NodeJS: How to use Pool correctly?

I created two files to test the use of MySQL with NodeJS as below, but I'm finding the answer slow and I think I'm doing something wrong: DOUBTS : 1) Is this way to access the database the most correct? That is, every time I need to save...
asked by 23.07.2017 / 17:39
2
answers

How to limit IPs that can connect remotely to mysql?

I have a centos 7 server with MySQL 5.6 installed, I can control the privileges of each user / host with GRANT. But my question is how to allow only a few IPs to connect to the bank. connect, but only those with some privilege do something. An...
asked by 26.07.2017 / 17:27
1
answer

Select model according to the brand

I have the function that returns all the registered brands: (With fields ID and BRAND) public function lista(){ $lista = array(); $n = 0; $db = new mysql(); $exec = $db->executar("SELECT * FROM automovel_ma...
asked by 23.08.2017 / 14:52
1
answer

What is the best way to store a multivalued item

When issuing a NF-e it is possible to insert up to 990 products / items per document . Since each product has several attributes. What would be the best way to store and link each product, and its respective attributes, to an NF-e? I curre...
asked by 03.08.2017 / 23:06
1
answer

I can not log into phpmyadmin

At this point I'm studying cloud shared file services like OwnCloud and Pydio. I'm using Debian 9 as a machine. I installed xampp on it. I usually entered the settings in phpmyadmin and I put the password in the root user. When you get the...
asked by 06.08.2017 / 01:04
1
answer

Query mysql_query does not return column [closed]

Greetings to everyone in the community. I'm going through a strange problem. When I select the syntax of the query and colon in PHPMyAdmin, the query returns all the fields I want. But when I put it in the code, it does not return any value....
asked by 30.08.2017 / 17:43
1
answer

To have a bank in phpMyAdmin do you need the bank in Mysql? [duplicate]

Hello, I would like you to help me in an issue, my code connects to my bank that is in phpMyAdmin, and in some places I have read, I have verified that it is a bank manager. My question and doubt are exactly the title. Is it possible to have a...
asked by 30.08.2017 / 21:54
2
answers

How to make a welcome screen in PHP?

I want to create a welcome page for the user who logged into the site. My difficulty is in creating the query as I do it and show the user name through an echo? login.php form <?php session_start(); if(isset($_POST['submi...
asked by 30.06.2017 / 06:22
1
answer

Problems updating data with empty DateTime

I need help with the following ... I need to update several data at once through my application, but one of the conditions is that the field field in the database is empty because it is the one that will be updated. The field in question is...
asked by 21.09.2017 / 02:26
1
answer

PHP / MySQL Select total balance of 1 client in the table

My client JOSÉ appears 4 times on this table, and I wanted to get his balance total. How do I do this? tabela "clientes" ID NOME SALDO 1 josé 10 1 josé 20 1 josé 30 4 maria 50 5 marta 60 1 josé...
asked by 21.09.2017 / 21:04