Posts by Henrique Felix • 637 points
31 posts
-
-1
votes4
answers70
viewsA: How to return the sum of the business value column, month by month, based on the starting data_column?
Good morning, Try: select sum(valor_negocio) from negocio group by data_inicio
-
9
votes2
answers49314
viewsA: Commands to update Ubuntu apt-get update or apt update sem get?
The command apt-get update updates the list of packages and programs that can be installed on the machine. The command apt-get upgrade updates the system and downloads and installs package and…
-
1
votes2
answers757
viewsA: HTML and PHP form
Good afternoon , Assuming you wish to send the data submitted in the form to the email, you must import the phpmailer library. User Identification Name: Email: Sex: Masculine Feminine Date of Birth…
-
0
votes2
answers99
viewsA: Trigger for table optimization
Good morning , I solved the problem by creating a precedent (Mysql does not accept commands optimize at Trigger). And I created a Trigger to call the Procedure every time you update the table. It…
-
0
votes2
answers99
viewsQ: Trigger for table optimization
I’m trying to create a trigger which rotates the control OPTIMIZE mysql. In short, I have an A table and created a B table that will save a datetime where this value will be updated every time the…
-
3
votes1
answer1519
viewsQ: Edit record before passing validation rule in Laravel
I own a form who registers clients. In the field of CPF, i format the data with jQuery by inserting the punctuation between the digits. It turns out that by inserting this formatting, my Requets do…
-
2
votes1
answer531
viewsQ: Multidimensional array from mysql query
Good afternoon, I have a system, with the following tables : pagina: id,nome ,icone, idGrupo. paginaGrupo: id,nome,icone, idGrupoUser. I’m setting up a dynamic menu on top of these tables. I take…
-
0
votes1
answer944
viewsQ: Sending form via Ajax in Laravel + Request
I have a form that makes the registration of people. I need to send it with Ajax to not reload the page. So far I have the following ready that I followed from a tutorial. Js who makes the upload.…
-
2
votes1
answer946
viewsQ: Condition in request Condition
I have a request class called PessoaRequest. In this class, I validate my form to register people. But now, some information has appeared to be entered that are not mandatory: father’s and mother’s…
-
1
votes2
answers830
viewsQ: Mask in html field does not work
Good afternoon, I have a page in my application to register customers , nothing out of the ordinary. On this page , I have some fields ( cif ,rg , phone,phone_2 ,etc) that when typing are formatted…
-
-1
votes2
answers291
viewsA: how to log in divided into two parts?
Good morning , After validating 1 login ,you play its login name in a session and redirect to the login screen2. On the login screen 2 , in the login field you display the name that is in the…
-
1
votes1
answer1621
viewsA: Press button + MYSQL Database Data overwriting "Select * From table limit 18"
Good afternoon friend , EDIT -- By your comment above, you want the data to be dynamically loaded, right ? Then Voce will need to rest on a little ajax. Edit -- Below , follows a small example ,…
mysqlanswered Henrique Felix 637 -
1
votes2
answers95
viewsQ: Form recording the same data
Good afternoon guys. I have a problem that I can’t find a solution. I made a form to record the registrations of a web site , but often this being saved the same registration several times (see…
-
1
votes1
answer100
viewsA: Help to send PHP data to DB
Good night, If it’s starting, start by learning about PDO or mysqli, it’s easier. In your code , is missing the data Internet , these 4 dates you take from a form where someone informs them? Let’s…
-
0
votes0
answers103
viewsQ: Problem when listing text file data in c++
Good night to you all, I have to deliver a job in college , the same being done in C++. As it is the first time I come across this language , I have a problem in one of the part of the program.…
-
1
votes4
answers6560
viewsA: Telephone and CPF masks in Textfield
Good night , <script type="text/javascript"> // Mascaras Javascript function mascara(o,f){ v_obj=o v_fun=f setTimeout("execmascara()",1) } function execmascara(){…
-
0
votes1
answer330
viewsA: JS function does not execute - $ is not defined
Good afternoon , First I’d like to thank @Emirmarques for taking the time to help me. I was browsing the stack , when I found the following post. Run Javascript function in event by clicking a…
-
-1
votes1
answer330
viewsQ: JS function does not execute - $ is not defined
Good morning to all , I started studying javascript recently and I have a problem that I could not solve. Goes down: I have a page that I’m doing like a quiz. Follow the full page code:…
-
2
votes3
answers989
viewsQ: Execute command with variable -JS
Good morning , On a page, I have some div to which I put an effect for them to appear (toogle) I would like that effect to be alternated whenever I perform its respective function. Then, I…
-
-1
votes1
answer110
viewsQ: Problem when displaying array
I have a problem in logic to display data from an array. Is the following: I have a function, which returns the result of entries per UF per day. In it I step 2 parameters, an array with the dates…
-
0
votes2
answers51
viewsQ: Error registration report on method return
I’m having a problem I haven’t been able to solve in over a week. I wish to make a registration report for a particular website. In the report, I want to list the cities and their total…
-
0
votes2
answers6610
viewsA: Select within select sorted by the second mysql query
After studying a little about the JOIN MYSQL, I managed to solve my problem . It follows as it turned out: SELECT a.id,a.nome,count(b.tipoServico) FROM tblTecnicos AS a INNER JOIN tblServico AS b ON…
-
0
votes2
answers6610
viewsQ: Select within select sorted by the second mysql query
I got a problem, I don’t know if I’m doing it right, but come on. I have a table that lists some employees ( tblTecnicos ). I have another table , which has the records of services that these…
-
1
votes1
answer386
viewsA: My calendar only displays the first scheduled appointment of each day
@Jorge B. Sorry, I didn’t know . Follow the code with the problem solved. <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>…
-
7
votes1
answer386
viewsQ: My calendar only displays the first scheduled appointment of each day
I’ve set up a calendar with a PHP + Mysql calendar , it’s already 80% of the development. But, I have a problem, like if I register for an event for the day 20/07, this appointment is displayed…
-
4
votes1
answer135
viewsQ: Execute function x minutes after submitting form
Good afternoon guys, appeared a problem to solve on a site, something that had not yet moved. The following is, on the page I have a form where the person can register. When making the registration,…
phpasked Henrique Felix 637 -
1
votes1
answer1297
viewsQ: Grab sequential ID based on last entered
I got a problem that’s giving me trouble. I have the following code: $sql = $pdo->prepare ("SELECT cpf,idUser FROM `tblContacts` where cpf = '".$cpf."' limit 1"); $sql->execute(); $row =…
-
2
votes2
answers1761
viewsQ: Hide Div after x seconds after running action
Good morning Galera, I have in my home , a field to consult CPF. The field has only one text field , where I inform the CPF, if I find some Cpf in the database , it returns me some data.I submit the…
-
3
votes2
answers295
viewsQ: Save bank value to same user
I have a page with a field for entries that are recorded in the database and when recording I assign a user ID randomly in this register. Thus: $name = $_POST['name']; $phone1 = $_POST['phone1'];…
-
1
votes0
answers459
viewsQ: Dynamic pages through request
I’m setting up a web application in a way that future maintenances will be well simplified. So I started searching for dynamic pages, etc. Except in practice, I don’t even know how to start. I…
-
1
votes1
answer498
viewsQ: Take 2 select value and display the data of each
I’m putting together a page where the person will be able to compare 2 products. I have 2 tables, categories and products. The 1st combobox, make a select in the table of categories. When choosing a…