Questions tagged as 'mysql'

Tagged questions
1
answer

How to make an insert in this table

I have a vehicle registration, which has a combo box with the years for the user to choose, these years comes from the "year" table. When I complete a registration of a new car, I have to give an insert in the table "car", my problem is there, h...
asked by 09.06.2017 / 04:36
1
answer

Variable not defined in SQL query for PHP

I'm trying to send a query with the information of a table in MySQL to an array in PHP, but I'm encountering the following error when I try to print an array position:    "Notice: Undefined variable: array in C: \ xampp \ htdocs \ Domiritmo...
asked by 20.06.2017 / 18:10
1
answer

Saving the File Path in the Bank

I'm having a question I'd like to know with saving the path of images and files I'm uploading currently I save those files to a folder but I'd also like to have the path in the database how can I do this. Well, the controller I use to upload t...
asked by 07.06.2017 / 15:22
1
answer

How to disable mysql password validation with ZoneMinder: ERROR 1819 (HY000)

I loaded the password validation plugin in MySQL 5.7 on Ubuntu Server 16.04 to leave the system with more protection, but it seems that this plugin forces all passwords to comply with certain rules and ends up that none is correct giving this er...
asked by 20.06.2017 / 15:20
0
answers

Recover Data from Mysql

I uninstalled mysql, did not back up the database, but backed up the files: ibdata1, ib_logfile0, and ib_logfile1. The ibdata1 file has 17GB, in my.cnf innodb_file_per_table = 0. How do I recover this data? Is there any software or procedu...
asked by 20.06.2017 / 15:09
1
answer

Node JS - MongoDB x MySQL

Why every Node JS tutorial we see, is always shown example in MongoDB. What do the two have that are so used? Why not use MySQL with Node?     
asked by 17.11.2016 / 22:29
1
answer

Send email after a change in the database

Hello, I'm using the MySQL database and I have an event that runs daily at 1 hour. Within this event I check the date present in a row and compare with the current date, if the current date is smaller then I make the necessary operations. The pr...
asked by 06.06.2017 / 19:08
1
answer

Add hours worked Mysql

I have track records of a truck in a table.    ===================================================== ==== This example up there I have 5 records that I picked up in the table by checking Speed > 0 Records 1 through 3 show that it...
asked by 06.06.2017 / 01:28
0
answers

How to Update 2 tables with Switch case and database data and others coming from an xml return?

switch / case that runs in the bank to see which id ta and get the value in the switch and pass to the other table in the update ... is there any error anyone could help? <?php require_once("core/config/config.php"); if (isset($_POST[...
asked by 24.06.2017 / 17:45
0
answers

PDO, Select a query with some fields, of a certain user and code

I need to set up a query where I will only have 5 fields ( STATUS , ID_USUARIO , PACKED , ID_TRANSACAO and ENTREGUE ). I need when I change from STATUS change in another table, and update in the current fi...
asked by 24.06.2017 / 05:48