Posts by Chefe Druida • 1,086 points
187 posts
-
1
votes2
answers544
viewsQ: Error starting nodejs+Sequelize+mysql project
When I try to start my project this giving the following error: D:\www\nodejs\master>node bin/www module.js:472 throw err; ^ Error: Cannot find module 'sequelize' at…
-
1
votes1
answer583
viewsQ: Property forChild does not exist on type typeof Ionicmodule Ionic 2
I created a new Ionic project 2: ionic start myApp blank --V2 Until then, only when I create a new page: ionic g page login He’s making the following mistake below: Typescript Error Property…
-
2
votes2
answers63
viewsA: How to make 2 queries in different database with PHP
At the end of your query $Conn_1 ou $Conn_2 you arrow your connection to db, see in the example below: $Conn_1 = mysql_connect("teste","teste","teste"); $Db1 = mysql_select_db("BANCO1"); $Conn_2 =…
phpanswered Chefe Druida 1,086 -
0
votes1
answer1165
viewsA: Validate if there is already registration in the bank before filling out the form
Solution: SCRIPT: $(document).keydown(function(){ var cpf = $("#cpf"); cpf.blur(function() { $.ajax({ url: '../functions/functionCPF.php', type: 'GET', data:{"cpf" : cpf.val()}, success:…
-
0
votes1
answer1165
viewsQ: Validate if there is already registration in the bank before filling out the form
I have the following form: <form class="form-horizontal" action="cadastrar.php" method="GET"> <fieldset> <legend>DADOS CADASTRAIS</legend> <input type="hidden" required…
-
2
votes2
answers513
viewsA: Autocomplete with jquery and mysql does not list the options when starting to type
SOLUTION: <script type="text/javascript"> $(document).ready(function() { $.getJSON('../functions/functionAutoComplete.php', function(data){ var endereco = []; $(data).each(function(key, value)…
-
1
votes2
answers406
viewsQ: Return with json array showing only first record
<?php //database configuration $dbHost = '127.0.0.1'; $dbUsername = 'root'; $dbPassword = ''; $dbName = 'master'; //connect with the database $Mysqli = new…
-
1
votes2
answers513
viewsQ: Autocomplete with jquery and mysql does not list the options when starting to type
I have the following form: <?php //CHAMA A CONEXÃO COM O BANCO DE DADOS require('../db/conexao.php'); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8">…
-
4
votes1
answer335
viewsQ: Google Chart’s Line with While
Good afternoon, I have the following appointment: SELECT DATE(o.data_fechamento) AS Data, u.nome AS Pessoa, COUNT(*) AS Total FROM ocorrencias AS o LEFT JOIN sistemas AS a ON a.sis_id = o.sistema…
-
3
votes1
answer2380
viewsQ: Extract data from a BLOB field in Mysql
I have a select where there is a column where this returning me in <BLOB> QUERY SELECT * FROM user WHERE user_id=1 RETURN: id data_cad user_data 12 2017-03-01 21:38:57 <Blob> In the BLOB…
-
0
votes2
answers222
viewsA: Error showing return of json array in php
SOLUTION FOUND: <?php $get =…
-
0
votes2
answers222
viewsQ: Error showing return of json array in php
Error: Notice: Trying to get Property of non-object in C: xampp htdocs json get_json.php on line 6 My php code: <?php $get =…
-
1
votes1
answer18787
viewsQ: Start with hidden div and show with button
Based on the answer below, I created the button that displays and hides the div, but what I would like is that the div started already hidden and had a button to display it. How could do? How to…
-
0
votes1
answer91
viewsQ: Group results in single line according to sequential
I have the following query: SELECT * FROM ARELBATIDATRANSITOVIEW WHERE CHAPA = 1234 AND CODEMP = 1 AND BATIDA IS NOT NULL She takes me back to this way: COD |DATA |BATIDA |ST |SEQ_BAT 1234…
-
0
votes1
answer242
viewsQ: Query with array returning only first record
I have the following querys: <?php $VarMensagem = 1; $pdo = new PDO($dsn, $un, $pwd, $opt); $data = array(); $dataGeral = array(); try { $stmt = $pdo->query("SELECT * FROM mensagem WHERE…
-
1
votes2
answers1664
viewsA: query system with php
Test php as follows by removing php of the POST: <?php $questao1 = $_POST['questao1']; // Sem o <br> aqui $questao2 = $_POST['questao2']; // Sem o <br> aqui $questao3 =…
phpanswered Chefe Druida 1,086 -
8
votes2
answers221
viewsQ: Error trying to host app on itunes
We made an iPhone app with Embarcadero xe10 + PHP, but when trying to host it on: He was turned down for not supporting IPV6. I joined the site…
-
1
votes1
answer190
viewsA: Error using proper Ionic 2 css
Solution found: Em home.scss: .fundo { background-color: #000000; } and in home html: <ion-content padding class="fundo">…
-
0
votes1
answer190
viewsQ: Error using proper Ionic 2 css
Css example: .ion-content { background-color: #000000; } home ts. import { Component } from '@angular/core'; import { NavController, ViewController } from 'ionic-angular'; import { HomeService }…
-
4
votes1
answer609
viewsA: Error while trying to run Ionic serves windows
Correction: npm rebuild node-sass Source: https://github.com/sass/node-sass/issues/1764…
-
3
votes1
answer609
viewsQ: Error while trying to run Ionic serves windows
When I try to start my Ionic project this giving the following error: 0 info it worked if it ends with ok 1 verbose cli [ 'C:\\Program Files\\nodejs\\node.exe', 1 verbose cli 'C:\\Program…
-
6
votes1
answer1546
viewsQ: How to round up time?
I have the following function which treats an hour coming from the bank: SELECT f.chapa AS chapa, f.nome AS nome, f.secao AS cod_secao, f.nsecao AS desc_secao, c.codigo AS cod_funcao, c.nome AS…
-
1
votes1
answer298
viewsQ: Error while trying generates Ionic apk v2
Commando: ionic build android --prod Environment variables: ANDROID_HOME C:\Android\sdk CLASSPATH .;%JAVA_HOME% JAVA_HOME C:\Program Files (x86)\Java\jdk1.8.0_121 Path ;%JAVA_HOME%\bin Error: Error:…
-
1
votes2
answers1488
viewsQ: Print without losing css
I have the following page below which is to print out some OS reports, this exactly the way I need, only when I print this losing the css formatting, how do I print without losing the css layout…
-
1
votes2
answers43
viewsQ: Error when trying to calculate in fields of the same table in update mysql
I have the following table: DROP TABLE IF EXISTS `convenio`; CREATE TABLE `convenio` ( `codigo` int(8) DEFAULT NULL, `cpf` varchar(11) NOT NULL DEFAULT '0', `Nome` varchar(35) DEFAULT NULL, `valor`…
-
8
votes1
answer1840
viewsQ: How to implement editable table by updating the fields in the database automatically
I have the following table that lets edit directly in cells: The codes are in 4 parts: Mysql table CREATE TABLE IF NOT EXISTS `php_interview_questions` ( `id` int(8) NOT NULL, `question` text NOT…
-
1
votes1
answer185
viewsQ: ENTER key save table instead of spacing
I have the following table to let edit directly on the grid: Her codes: Mysql table CREATE TABLE IF NOT EXISTS `php_interview_questions` ( `id` int(8) NOT NULL, `question` text NOT NULL, `answer`…
-
0
votes3
answers1584
viewsA: Merge the result of a query on the same line from the sequential
@José Diz , I chose the one that was also a tip from you, because I needed to implement more things in the consultation and worked well with her. Thanks for the help. -- código #2 v2 -- define…
-
0
votes3
answers1584
viewsQ: Merge the result of a query on the same line from the sequential
I have the following appointment: SELECT * FROM SERQUENCIAL WHERE DATA BETWEEN '2017-01-01' AND '2017-01-19' She returns: +--------------+-------+------------+-----------------------+ | ID_PESS NOME…
-
1
votes1
answer58
viewsQ: Error including more than one mysql data in intel XDK javascript with PHP
I’m using the following function: $( document ).ready(function() { var $server; $server = 'http://localhost/mobile/DatabaseXDK/database/www/'; $('#inclusao').on('click', function(){ $nome =…
-
3
votes2
answers1174
viewsQ: Export sql server query result to txt file on apache server automatically
I do the following query of my apache server in an SQL SERVER database: <?php // Dados do banco $dbhost = "192.168.0.100"; #Nome do host $db = "DATABASE"; #Nome do banco de dados $user = "root";…
-
0
votes1
answer215
viewsQ: Error while creating mysql function
I’m trying to create the following function: DELIMITER // FUNCTION DISTANCIA ( lat1 DOUBLE, long1 DOUBLE, lat2 DOUBLE, long2 DOUBLE ) RETURNS DOUBLE DETERMINISTIC BEGIN DECLARE d2r DOUBLE; DECLARE…
-
0
votes1
answer336
viewsQ: Error returning from get from Delphi to php
Upload the following get in php http://site.com.br/Autenticacao/index.php?conteudo={"Login":"[email protected]","Senha":"123","Posicao":{"Latitude":"-18.8693459","Longitude":"-41.955664"}} And I get…
-
1
votes1
answer117
viewsQ: How to take a json link and use it in php
I get the following json link: http://localhost/json/?conteudo={"Login":"[email protected]","Senha":"12345","Posicao":{"Latitude":"-18.8693459","Longitude":"-41.955664"}} How to play it for php below:…
-
0
votes1
answer266
viewsQ: Query with Count returning empty
I have the following appointment: SELECT numero, sistema, status, date_first_queued FROM ocorrencias HAVING DATE(date_first_queued) between DATE_FORMAT(CURDATE() ,'%Y-%m-01') AND CURDATE() AND…
mysqlasked Chefe Druida 1,086 -
0
votes3
answers299
viewsQ: Grid bootstrap getting misaligned in panel with results brought from database
I am displaying the result of a query in panels, only that they are getting misaligned, I want to show as ta in the image below only 1 below the other, the way this, generating a pyramide effect,…
-
1
votes3
answers191
viewsQ: How to display the date in the input after the query
I have the following form: <?php include "conexao.php"; echo"<form class='navbar-form navbar-left' action='#'>"; echo"DATA INICIAL: <input type='text'…
-
1
votes1
answer679
viewsQ: Insert result ajax dynamic query into input
I am using a dynamic query co AJAX + JQUERY, the result is appearing below as shown in the image above. <div class="form-group"> <label for="inputEmail" class="col-lg-4…
-
0
votes1
answer2542
viewsQ: How to color column date type according to current date
I have an Excel schedule table, which I need the color to change according to the date,. If the date is longer than the current date will turn red as well (Schedule expired). I tried conditional…
excelasked Chefe Druida 1,086 -
0
votes2
answers119
viewsQ: Helps decrease the size of php mysql scripts
How could improve the script below, it would be possible to do something with the queries or yes thing, because it does everything I need, more became a bit messy and big, what could do? <?php…
-
2
votes1
answer250
viewsQ: Error while performing sql server + php + Pdo query
Follows the code: $conexao = new PDO("odbc:Driver={SQL Server};Server=127.0.0.1;Database=MASTERDB; Uid=admin;Pwd=admin123;"); $select = $conexao->query("IF Object_ID('tempDB..#TabBatidas', 'U')…
-
2
votes4
answers232
viewsQ: How to change the date order of an implode from a jquery datepicker
I have the following $_get : if(!empty($_GET) && $_SERVER['REQUEST_METHOD'] == 'GET'){ $v_ocorrencia = $_GET['ocorrencia']; $datainicio = $_GET['datainicio']; $datafinal =…
-
2
votes1
answer1641
viewsQ: Run console command and read the return in PHP
In linux if I do the command df -h in the terminal it returns me the partitions, size etc ... as shown below: Filesystem Size Used Avail Use% Mounted on /dev/sda3 25G 6.4G 17G 28% / /dev/sda5 70G…
-
1
votes3
answers412
viewsA: Filter records via datetime and bring them between an initial and final date
try like this: SELECT entradas AS ENTRADAS, saidas AS SAIDAS, saldo AS SALDO, MAX(data_mov_saldo) AS DATA FROM saldo WHERE data_mov_saldo BETWEEN '10/10/2016' AND '20/10/2016' GROUP BY…
-
4
votes1
answer107
viewsQ: Error Openwebmail when sending email to a person
I have installed Open Webmail, I have several more accounts in some accounts as soon as an email is sent to them, returns the error below, more they receive the message, someone has seen and or…
-
1
votes1
answer334
viewsQ: How to merge 8 query returns into one?
I have 8 query’s all have 5 unusual columns and some distinct columns, Based on the common columns I can display a single result of the 8? Common fields: F.CHAPA AS CHAPA, F.NOME AS NOME, F.FILIAL…
-
0
votes1
answer920
viewsQ: Difference between hours without taking into account the date
Good night, I have the following code: WITH CONSULTA AS ( SELECT V.CHAPA, V.DATA, MAX(V.BATIDA) AS MAXBATIDA, MIN(V.BATIDA) AS MINBATIDA FROM ARELBATIDATRANSITOVIEW AS V WHERE V.CODCOLIGADA = 1 AND…
-
0
votes1
answer167
viewsQ: Query condition to display only records that contain the same 3x consecutive number
I have the following appointment: with Consulta as ( SELECT V.CHAPA, F.NOME, V.DATA, F.FILIAL, DATENAME(dw,V.DATA) AS DIA, MAX(V.SEQUENCIALBATIDA) AS BATIDA FROM V_BATIDASANTIGAS AS V LEFT JOIN…
sql-serverasked Chefe Druida 1,086 -
5
votes3
answers461
viewsQ: How to run . sh file on button
It is possible to run a file that .sh in a button , example: /bin/importa.sh in a <a href""></a> also serves.
-
0
votes2
answers1282
viewsQ: Pass results from an Else if array
I have the following code: <?php $array = []; $ano = 2016; for($i = 1; $i <= 12; $i++){ $data = $ano . '-' . $i. '-01'; $inicio = new DateTime($data); $fim = new…