Questions tagged as 'mysql'

1
answer

The values of an arraylist are repeated

Well the problem is as follows; I'm doing a program that has a database and I want to return a query in a list made with an access class (getter and setter) ... but when I see the list that returns the function returns me the amount of queries b...
asked by 19.05.2016 / 20:40
2
answers

MySql query with PHP [closed]

I have 2 tables: Students and Prestamos_Libros. The table Prestamos_Libros has a state field with three possibilities, 1, 2 and 3. the table Students has 15,000 records, of which 259 records belong to group 10. I can list the students of grou...
asked by 23.03.2016 / 02:07
1
answer

Inventory with Variable Price Products

I have created a php / mysql system for dispatch with product inventory and the problem I have is that I do not know how to calculate the cost of the dispatch when I have income from the same product with different prices. My database is co...
asked by 22.03.2016 / 21:19
1
answer

Ubuntu server 16.04 - mysql, The MySQL server is running with the --secure-file-priv option

I need help, I'm setting up a servidor web with ubuntu server 16.04 , apache , mysql and php , and I'm trying to import data from a text file to mysql and I get the following message:    The MySQL server...
asked by 30.07.2016 / 04:04
1
answer

Why do you repeat the data?

Good morning I'm doing a query on mysql trying to bring only one result per date but it's bringing me more than two results from the same date, someone to help me with what I have to remove or add to the query. SELECT DATE_FORMAT(fecha_pe...
asked by 01.08.2016 / 15:12
2
answers

Connection java and mysql

Any questions on how to solve the error? that appears when I try to make a graph in Jfreechart. apparently the error is in the connector. import java.sql.*; import javax.swing.*; public class javaconnect { Connection conn = null; p...
asked by 04.08.2016 / 05:24
3
answers

Search in fields with HTML entities

I have a field in a MySQL database to which I have previously inserted HTML code; I also have a search engine that, when entering the word, searches for the results. The problem is that the data in HTML I have something like P & public that...
asked by 28.04.2016 / 23:06
2
answers

"fopen ()" does not update an existing file

I am working on a code that publishes articles on a page. This code works perfectly when creating the article, however, when trying to update it (publishing the same article with the same name but with different content from my admin panel), it...
asked by 30.04.2016 / 21:03
0
answers

Migration in Laravel

I want to make a migration to MySQL, when I put the php artisan migrate instruction in my command line, I get the following error in console:    In Connection.php line 664:                                                             ...
asked by 05.01.2019 / 01:33
0
answers

Connect PHP by Api to Mikrotik

Hello my question is how to establish two simultaneous connections to two mikroitk teams with user and pass in php through a link api my link code is as follows: (EYE one the teams have the same user and pass and port per api, only change the ip...
asked by 05.01.2019 / 03:22