Questions tagged as 'mysql'

Tagged questions
0
answers

I get the fields but it does not perform the SQL query when updating I can not find the fault

class Noticias{ private $id; private $titulo; private $noticia; public function __construct() { // Argumentos recibidos $a = func_get_args(); // Número de argumentos recibidos $i = func_num_ar...
asked by 19.05.2018 / 15:59
1
answer

Problems with PHP and SQL (expects parameter 1 to be sqli) [duplicated]

I was trying to open my .php file from the localhost and I got the following errors: First error:    Warning: mysqli_select_db () expects parameter 1 to be mysqli, string given in C: \ xampp \ htdocs \ conexion.php on line 8 Code...
asked by 19.05.2018 / 10:43
0
answers

Is it possible to have a strong entity that encompasses several entities in database modeling?

I am in doubt about the database modeling I mention the case: I have a database with some of the tables that are PERSONA (nro_documento,apellidos,nombres,fnacimiento,id_genero,id_tdocumento) TRABAJADOR (nro_documento,codtrabajador,sueldo,id_de...
asked by 18.05.2018 / 11:23
0
answers

How to create a report per month in excel from php and mysql?

This is my script where I generate my report in excel which works perfectly, what I'm looking for is that you can make the downloads indicating the month to avoid downloading all the months in a single file. reporteexcel.php <?php...
asked by 18.05.2018 / 12:38
0
answers

Give ALTER TABLE permissions in Sonarqube with MYSQL?

I'm trying to link MYSQL with SonarQube, but even though I've given the user permission, he still throws the same error in this table.    ActiveRecord :: JDBCError: Error on rename of '. \ sonar # sql-9cc_138.frm'   to '. \ sonar \ active_rul...
asked by 17.05.2018 / 22:19
0
answers

Unknown system variable 'tx_isolation' when starting Mysql in Neatbeans

I installed Mysql 8.0 in my Windows 10 and I already verified that the service is running on my machine, in my Neatbeans 8.2 when I start Mysql the following message is displayed: I would appreciate any help, regards.     
asked by 17.05.2018 / 18:22
1
answer

Update fields with multiple values from different tables in MySQL

I have 3 tables: Product_categories (created from the import of a .csv ) product_reference | category_id | subcategories REF.001 | 1 | 1/2 Categories (created from the import of a .csv ) id | name 1 | categoria...
asked by 21.05.2018 / 11:52
1
answer

How to insert a data type DATE in mysql?

I have a problem inserting a data type date to mysql, melo inserted in the column as 000-00-00 This is my Form <div class="form-group"> <label for="nombre">Fecha recibido</labe> <input type="date" name="fecha...
asked by 22.05.2018 / 20:03
0
answers

Autocomplete input with two conditions

I have the code to autocomplete several text boxes from a selection in a drop-down list. When I enter a character in the "nickname" imput, a query is activated in the clients table and a dropdown appears with the options that match. From the...
asked by 22.05.2018 / 18:28
1
answer

ModuleNotFoundError: No module named 'ConexionBBDD'

My problem is as follows. I can not import the package ConexionBBDD from my package Cliente, how could I fix it? I already have inside the package a file% co_of% empty, but when I call it, it does not recognize me as a package, w...
asked by 19.05.2018 / 02:19