Posts by Chefe Druida • 1,086 points
187 posts
-
2
votes1
answer255
viewsQ: Error opening exported excel file in PHP
I use the following code: <html xmlns="http://www.w3.org/1999/xhtml" lang="pt-br" xml:lang="pt-br"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible"…
-
2
votes2
answers75
viewsQ: Query with calculation returning error in condition
I have the following select: SELECT imp_loja AS LOJA, imp_item AS ITEM, imp_desc AS DESCRICAO, imp_dias_giro AS DIAS_DE_GIRO, imp_nec AS NECESSIDADE, imp_pedido AS PEDIDO, imp_bancao AS BANCAO,…
mysqlasked Chefe Druida 1,086 -
0
votes1
answer94
viewsQ: Run Query according to selected Radiobutton
I have the following form: <?php echo"<fieldset>"; echo"<legend>OPÇÕES</legend>"; $query_menu = mysql_query("SELECT rm_id AS FUNCAO, rm_desc AS DESCRICAO, rm_obs AS OBSERVACAO,…
-
0
votes2
answers44
viewsQ: Automatic redirection of pages
I have 3 panels,example: painel1.php painel2.php painel3.php They’ll be playing on a monitor, which I would like: That only one was opened on the screen, and that every 10 seconds the browser…
phpasked Chefe Druida 1,086 -
0
votes1
answer487
viewsQ: Send a value to modal
I have a table with several employees and on it counts the plate of each hum. I created a modal that when the manager clicks on the employee name is called a modal where it is possible to enter the…
-
1
votes2
answers412
viewsQ: How to send the result of a query by e-mail SHELL SCRIPT
I have the following appointment: #!/bin/bash db="bats"; table="promotion"; dbHost="192.168.0.246"; dbUser="root"; dbPass="root"; result=`mysql -h $dbHost --user=$dbUser --password=$dbPass…
-
3
votes2
answers293
viewsQ: Insert in mysql with strtoupper not accepting numbers and letters
I am doing the following Insert: <?php include "conexao.php"; $v_tipo = $_POST ["tipo"]; $v_funcao = $_POST ["funcao"]; $v_numero = $_POST ["numero"]; $v_responsavel =…
-
2
votes1
answer332
viewsQ: Query with variable date in Mysql returning empty
I need to make a query in Mysql setting 3 variables,when only in the case of right integer,more when I include empty return date ta. Follows my query,what could be doing wrong? SET @tipo = 47; SET…
-
5
votes1
answer423
viewsQ: Use CONCAT to adjust the amount of php mysql numbers
I need to complete the amount of numbers to display on the screen, what would that be. a amount which would be an example: 20 need to fill 15 characters with 0,Example: 000000000000020. A friend of…
-
2
votes1
answer274
viewsA: Error multiplying decimal by integer in php
Follow solution elaborated with the tips of @Diego F and @rray $v_quantidade = 10; $v_preco = '3,68' ; $v_preco = str_replace(',', '.', $v_preco); $v_numero = $v_quantidade * $v_preco; $v_total =…
-
1
votes1
answer274
viewsQ: Error multiplying decimal by integer in php
Follow the example of my code: $v_quantidade = 10; $v_preco = '3,68' ; $v_total = $v_preco * $v_quantidade; echo "$v_total"; My variable $v_quantity it brings whole number, example: 3.. 5..10..…
-
0
votes2
answers3558
viewsA: Direct print without going through the php dialog box
Solution: So as indicated by our colleague @LF Ziron insert the css along with the print function. Follows code: <script> function cont(){ var conteudo = conteudo =…
-
0
votes2
answers3558
viewsQ: Direct print without going through the php dialog box
I use java script to print only the contents of a div, but I need you not to use the browser print dialog box. Reason: I created a formatting for the text, when it goes to print by the dialog box…
-
0
votes1
answer270
viewsA: Form making empty Insert
Based on the answers of Henrique and Raylan Soares I was able to solve my problem,.
-
0
votes1
answer924
viewsQ: Select field fill according to code entered in another field
Based on the image below, I would like when the person swiped their card, a select was made in mysql and where the store is written to appear the store where the person is registered. How could I…
-
0
votes1
answer270
viewsQ: Form making empty Insert
Good morning Galera, They could help me identify what is wrong in my form or in the Insert that is saving empty records in the bank. INSERT: Alert( 'Note successfully registered !!…
-
0
votes1
answer23
viewsQ: How to turn 2 forms into 1 only '
Good morning, you guys, I have these two Forms that would be an input and an output, the two do Insert in the bank,: <div class="col-md-6"> <div class="panel panel-danger"> <div…
-
0
votes2
answers284
viewsQ: How to keep a $_POST on the page
I have a question system,: <form class="form-horizontal" method="POST" action="perguntas.php"> <fieldset> <legend>SELECIONE O QUESTIONÁRIO</legend> <div…
-
0
votes1
answer1351
viewsQ: How to display the previous navigation url with PHP?
I use the function below to go to the next question of a question system I have,I could not create this function to go back,someone would have some hint? Knob: echo"<button id='button'…
-
0
votes1
answer37
viewsA: Query with Join returning empty
I was able to reach the result as directed by @rray . Thank you. SELECT q.quest_nome AS QUESTIONARIO, u.usu_id AS ID_USUARIO, u.usu_nome AS USUARIO, l.loja_id AS END, a.area_desc AS SETOR,…
-
0
votes2
answers1802
viewsQ: Framework to create admin dashboards and dashboards
I would like to have a framework to create administrative panels, if possible that already have dashboards included. Some people have already indicated me ready layouts, more I would like to develop…
-
1
votes1
answer275
viewsQ: Doubt question and answer systems with $_GET method
I have a system that shows a question and the person replies, When the staff responds step I use the $_GET method to pick up his answer and insert the information in the bank,plus the failure and…
-
0
votes1
answer37
viewsQ: Query with Join returning empty
Please help me check my query because it is giving an error that I am not able to identify. If I do the simple consultation: SELECT * FROM respostas WHERE resp_usuario='8' AND resp_questionario='6'…
-
0
votes1
answer176
viewsQ: Doubt Google Charts with Loop
Good morning, I’m using a Google Hart to create a dashboard, only that it’s only bringing me a result my loop isn’t working, someone could help me see what’s wrong ? <?php include("conecta.php");…
-
5
votes2
answers26904
viewsA: How to Export an HTML table to PDF and EXCEL
Good morning, You may be using 2 jquery plugins, follow the example: <!DOCTYPE html> <html lang="en" class="no-js"> <head> <meta charset="UTF-8" /> <meta…
-
1
votes2
answers645
viewsQ: Make calculations based on PHP or Mysql averages
A friend created a project in Arduino that monitors power consumption in Kw/h. It every 5 minutes inserts the consumption information in the Mysql database. Every five records I need to average…
-
0
votes1
answer64
viewsA: Insert GET mode
Solved. I passed as follows: if(isset($_GET['submit'])){ $loja = $_GET ["loja"]; $id_usuario = $_GET ["id_usuario"]; $questionario = $_GET ["questionario"]; $area = $_GET ["area"]; $idpergunta =…
-
1
votes2
answers75
viewsA: Query is not running, inserts nothing
Solved: include("conexao.php"); if(isset($_GET['submit'])){ $loja = $_GET ["loja"]; $id_usuario = $_GET ["id_usuario"]; $questionario = $_GET ["questionario"]; $area = $_GET ["area"]; $idpergunta =…
-
0
votes2
answers75
viewsQ: Query is not running, inserts nothing
What could be wrong? Inserts nothing into the bank. Form: <form class="form-horizontal" action="chk-gerente.php?nro_pergunta=<?php echo $nro_pergunta; ?>" method="GET"> <fieldset>…
-
0
votes3
answers2083
viewsA: Attach href to a button
Thank you guys for the tips,I tested and gave you the right ones, but the one that looked exactly like I needed was: @hgfdgd : when you have a button, embed it in a form: <form action=YOUR_URL…
-
-1
votes1
answer64
viewsQ: Insert GET mode
Good morning, This is the form of a question form of mine: <form class="form-horizontal" action="chk-gerente.php?nro_pergunta=<?php echo $nro_pergunta; ?>" method="GET"> <fieldset>…
-
0
votes3
answers2083
viewsQ: Attach href to a button
In a locker I have this link: <a href="chk-gerente.php?nro_pergunta=<?php echo $nro_pergunta; ?>">Próximo</a> And that button: <button type="submit" class="btn btn-default"…
-
0
votes1
answer68
viewsQ: Variable error
I have tried to find a mistake that is happening to me and I could not, Error: Notice: Undefined variable: st in /var/www/html/questions/chk-manager.php on line 143 The line he’s pointing at is…
-
0
votes1
answer244
viewsQ: Error when displaying image inside a php <td>
I’m creating a panel I make a calculation of the time a OS ta open and depending on the result shows in the table a colored ball... only it’s not working out,: Parse error: syntax error, Unexpected…
-
4
votes1
answer1369
viewsQ: PDF Data Import in PHP
It may be a stupid question, but I still have to ask: You can import data from a file in pdf in the php and save in bank mysql?
-
2
votes1
answer430
viewsQ: Change . by , with PHP or Mysql
I have a table that saves data that comes from a txt and I have a value field and it saves in format: 5.00 How do I change in the database or PHP to 5,00? That is, changing the . (point) by ,…
-
1
votes2
answers823
viewsQ: Adding the column of a PHP table
Good evening, you guys, I bring in a table a result of a select of a bank, but in the result: echo"". $T_TOTAL.""; I’m bringing a variable because I had to do a treatment to get my result. Doubt:…