Posts by Hermus • 379 points
27 posts
-
0
votes1
answer24
views -
2
votes0
answers60
views -
1
votes0
answers54
viewsQ: Calculating working days to a date!
I’m doing a product withdrawal system, for example: Certain product category has X working days to be removed. Category | Business days 1 | 1 2 | 3 3 | 4 4 | 3 5 | 3 6 | 3 7 | 4 For example, today…
-
1
votes1
answer150
viewsQ: Logging in to Laravel password without hash
Good people! I took a very old system to make some "improvements", I used Laravel to develop a system that mainly uses the database of this system. The BIG problem is, the passwords saved in the…
-
0
votes1
answer1355
viewsQ: List days of the week with month and year PHP
I am wanting to print the days of the week separated by the number of the week of a given month: What I have so far is: function days_week($date = NULL){ $date = ($date == NULL) ? date('m/d/Y') :…
-
2
votes2
answers179
viewsA: Jquery taking the <i> parent
The @DVD response was correct, $(this).closest('tr').attr("id") I was using . html(), so I was showing me all the content inside the TR and not . attr("id") to get the ID of the tr. Thank you who…
-
0
votes2
answers179
viewsQ: Jquery taking the <i> parent
Good people, I need to get the ID of the clicked one. My HTML is as follows: <table id="datatable"> <thead> <tr> <th>Nome</th> <th>Data de Nascimento</th>…
-
1
votes1
answer507
viewsQ: Count arrays within PHP array
Good folks, I have the following array…
-
1
votes0
answers263
viewsQ: Watermark in photos
Good person, I’m doing my TCC and now I’m implementing a photo gallery, but I need these photos present a watermark that the user choose previously, I’m using the nanoGallery2 to show the gallery/…
-
0
votes0
answers127
viewsQ: What is the right way to pass variables to the Create Laravel page
I’m making my TCC and I have a pre-registration page, where information like [nome, email, senha, token] and she saved on the table pre_register. Then a email for the person with a link, it contains…
-
0
votes1
answer333
viewsQ: Connect Pgadmin via SSH Google Cloud
Good people, let’s go. I have a server in Google Cloud, and I installed the postgres and everything ok, is working beauty, then on my machine I installed the pgAdmin III and made the configuration…
-
1
votes2
answers74
viewsA: Checking column fill with CHECK
About the answer to my problem, I was able to solve it with the help of Diego Marques: CREATE TABLE usuario( id serial, cpf varchar(20), cnpj varchar(20) ); create or replace function…
-
0
votes2
answers74
viewsQ: Checking column fill with CHECK
I am creating the BD of my TCC and the table Clients is: create table clients( id serial primary key, name varchar(255), cpf varchar(11), cnpj varchar(14), .... I thought of doing a CHECK limiting…
-
1
votes2
answers32
viewsA: Register - comparison of existing or non-existent values
I don’t know what database you are using, but at the time of database creation, in the 'name' field you can set it as Unic, that it will not be possible to register another with the same name. You…
-
2
votes1
answer128
viewsQ: Type of relationship between tables (Laravel)
I’m implementing my TCC, about photos and such.. But now I got a question when creating the tables... I’m using Laravel ok? Next, I have the following tables: users - roles - photos - tags works as…
-
1
votes2
answers1257
viewsA: Filter in WHERE Postgresql
I managed to solve my problem using a Translate function. I’ll paste the SQL here to whom it matters: SELECT a.id_alvara, a.id_alvara as numero, a.nome, a.firma, a.tipo_log||' '||a.logradouro||'…
-
1
votes2
answers1257
viewsQ: Filter in WHERE Postgresql
Good morning guys, next, I’m doing a standardization of some records here in the company. So there are 2 tables. Table A(old records) columns as: id_alvara | logradouro 1 | Rua Sete de Setembro n°…
-
0
votes0
answers43
viewsQ: Problem with Notices, Object PDO
I have my class: public function SQL($sql, $arrayParams = null, $fetchAll = TRUE) { try { // Passa a instrução para o PDO $stm = $this->pdo->prepare($sql); // Verifica se existem condições…
-
1
votes0
answers802
viewsQ: Error Class not found with Composer
Good people, next, I’m doing a project here and giving me some problems, I think I’m mixing things up. I installed Composer to use autoload and other dependencies, but now I have a problem: The…
-
1
votes0
answers789
viewsQ: Problem with extension of Postgres PDO
Use apache+php7+postgres on Ubuntu and it works well. But now wanted to do the installation by hand on Windows 8.1 and found a problem: I installed Apache 2.4, PHP 7.1, and Postgres. Apache worked…
-
0
votes1
answer919
viewsQ: SELECT with REGEXP
next, I have a table of people: [name, license plate, Cpf] What happens is, some people who have the "same" Cpf have different enrollments. [Same] is in quotes, because in the database, there are…
-
2
votes1
answer240
viewsQ: How to disable/activate a dblclick Jquery event
Good morning guys, next, I’m wanting to do a quick CRUD mode, in editing, for example, ADM gives 2 clicks in the field to be edited, and the field becomes editable with 2 buttons to the right, one…
-
4
votes1
answer1370
viewsQ: Doubt in class diagram
I am developing my class diagram of a project and got the following question: How do I indicate that only ADM can register a contributor? Do I have to put that in the Class Diagram right now? Thank…
-
0
votes0
answers63
viewsQ: PHP warning for no reason!
I want to make a simple connection to the database but each time I test, after a long page load generates a Warning. File database.class.php: <?php abstract class banco { public $servidor =…
-
3
votes1
answer78
viewsQ: How to put a "page" opening on a piece of the page?
In the example of Datepicker, when someone clicks on input date, open the calendar down correct. How can I do this ? In my case I have a page that only has a calendar made by me, is a specific…
-
1
votes1
answer198
viewsA: How to make a 28-day calendar!
Guys, what do you think? I managed to assemble, since it will be fixed and now I go to the dynamic part of the system, I need to be able to roll the months and years, the years will be easy, just…
-
3
votes1
answer198
viewsQ: How to make a 28-day calendar!
Next, I need to make a 28-day calendar with the following criteria: Every month should start the first day on Sunday, so this already formats the rest of the month. It is necessary next to the…