Questions tagged as 'mysql'

Tagged questions
1
answer

How to validate the highest value received in mysql?

I have a query that returns me the last accesses of the users in the system. I would like to know how I could handle it to return only dates that were longer than 15 days. The query is this: SELECT u.id, concat(u.firstname,' ',u.lastname)...
asked by 23.03.2018 / 11:43
3
answers

How to select all but one specific column?

You can select all columns in a table: SELECT * FROM wp_rw_programacao WHERE id = $id But I need to eliminate the id column from the result. Is it possible?     
asked by 19.10.2017 / 17:09
1
answer

Write data in 3 PDO-related tables

I need to insert data into related 3 tables using PDO . The first table t_repo_proj (repositórios) , and the second t_grnte_proj (gerentes) . I need to know which manager is associated with which repository. For this, I created...
asked by 28.03.2018 / 14:47
0
answers

Pulling the data from the database to the Ticket!

I want to know a way to pull the information needed to be printed in the Ticket, in addition to photo too, because on another screen I already have the correct form that upa the information for the database (Mysql) Thispartoftheapplicationwo...
asked by 27.03.2018 / 15:18
0
answers

Prevent enrollment between specific beginnings and endings

I have a checkbook, in it I can enter the starting number and end of the block, that is from 1 to 10 ; 20 to 30 and etc., however I wanted to prevent registration between these codes. Type, (since I have the example above) I could not...
asked by 20.03.2018 / 18:24
1
answer

Execute trigger according to the value of a column

I need this trigger to be executed when there is an update in the auction table, but only when the value of the auc_status column is equal to 3 . That is, as soon as the value of auc_status is changed to 3 , it must exe...
asked by 20.03.2018 / 18:54
0
answers

How to calculate the next available house?

At the moment I'm doing a project and I'm having a problem with an algorithm. Given the 4 directions (North, East, South, West), if the user chooses one of the 4, the next available home with 1 empty house should be allocated. The house...
asked by 23.03.2018 / 17:49
0
answers

How to hide / block / access system files and BD

I'm having a hard time solving a security issue in my company's system, it's a PHP application with BD MySQL. Where today I only maintain and implement new features, but at the moment I need to install this system on a client of ours and there i...
asked by 23.03.2018 / 17:48
0
answers

About connection class pdo

I'm developing a small project using php with standard mvc and the smarty template engine. I made a connection class without applying any pattern and it looks like this: Class Conexao extends Config { private $bd_host; private $bd_use...
asked by 20.03.2018 / 01:05
1
answer

XAMPP for Android

I'm about to take back-end development classes in college and I lost my computer and I can not even get another one right now. I would like to know if you have an apache, php and MySQL environment installed on Android, as the only device I ha...
asked by 19.03.2018 / 21:54