Questions tagged as 'mysql'

1
answer

Doubt on MySQL Query

What code do I need to display all posts for a user? I did something like this in PHP: "SELECT * FROM postagens WHERE id='$p_id' AND u_id='$u_id';"; But always returns 0 rows: ( CREATE DATABASE IF NOT EXISTS social DEFAULT CHARACTER SET ut...
asked by 21.03.2018 / 18:45
1
answer

How to use the Where in the consultation in laravel

How can I make a query below with mysql in laravel: SELECT gps.positions.id, gps.positions.protocol, gps.positions.deviceid, gps.positions.servertime, gps.positions.devicetime, gps.positions.fixtime, gps.positions.v...
asked by 21.03.2018 / 17:46
2
answers

How to solve the error Call to undefined function mysql_connect () [duplicate]

I'm doing an IT inventory to register and I want to connect to the database, but it's giving this error:    Fatal error: Uncaught Error: Call to undefined function   mysql_connect () in C: \ xampp \ htdocs \ xampp \ cadastrando.php: 9 Stack...
asked by 22.12.2016 / 15:20
0
answers

Unlock mysql remote access. Problems with mysql.user and password expired

Good afternoon. Next, I had to release remote access so one server can access the mysql database from another. I followed the steps of this link: link When I ran this command: GRANT ALL PRIVILEGES ON *.* TO usuario@HOST IDENTIFIED BY '...
asked by 08.03.2018 / 18:51
1
answer

javascript dynamic table write to mysql database

How do I get the table inserts and write to the database?. Follow my code. function addItens () { // Elemento textarea: const texto = $("#texto"); // Elemento table: const table = $("#products-table"); // Divide o c...
asked by 08.03.2018 / 19:03
1
answer

How to export mysql table to table in excel

I have a nice system where the user registers on one page and sees another. However, the user of this system wants to be able to export this table which is exactly my table in the database to a giant Excel tab that it has. I have no idea h...
asked by 08.03.2018 / 15:08
1
answer

Wrong time recording

I have these 3 classes as a template. Object: import java.io.Serializable; import java.util.List; import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; i...
asked by 08.03.2018 / 12:53
0
answers

MgmtSrvr ERROR - Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid = nodeid on command line

I'm trying to set up a mysql-cluster server and when I try to start the cluster manager with this command: ndb_mgmd -f /var/lib/mysql-cluster/config.ini --configdir=/var/lib/mysql-cluster is giving this message:    [MgmtSrvr] ERR...
asked by 09.03.2018 / 16:07
0
answers

Doubt about connection node.js

A question about node.js ... I am sending a request, to save to the database. My question is, what is the correct way to create simultaneous connections in the bank? Because when the function executes, the node terminates, and I did not want it...
asked by 09.03.2018 / 14:44
0
answers

Loop in Json [PHP and MYSQL]

I have a data visualization page from a table bd, and one of the cells of this table in html is actually a loop. I want to do the inline editing, which I've used in other projects ( link ), but with all the fixed fields. This time, I do not have...
asked by 09.03.2018 / 19:20