Posts by adventistaam • 3,354 points
330 posts
-
1
votes1
answer6901
viewsQ: Use sum with Eloquent
I have the following appointment: SELECT P.ID ,P.NR_CRACHA CRACHA ,P.NM_CLIENTE NOME ,E.DS_EMPRESA EMPRESA ,SUM( R.VL_PRECO ) VALOR FROM registro R JOIN pessoa P JOIN empresa E WHERE P.CD_PESSOA =…
-
0
votes1
answer132
viewsQ: Chosen does not work with Lockable
I’m trying to use the Bootstrap + Chosen But it just doesn’t work. I’ve done all the Imports and nothing The Times I did so: <link href="{{ asset('css/chosen.min.css') }}" type="text/css"…
-
3
votes1
answer5901
viewsQ: General error: 1215 Cannot add Foreign key Constraint
I am trying to add a foreign key to this table with the following code block public function up() { Schema::create('registros', function (Blueprint $table) { $table->increments('id');…
-
0
votes1
answer71
viewsQ: How to iterate php array
I have the following block feeding an array $insert = array(); for($i = 0; $i < 2; $i++){ $insert[] = array( "os" => $cdOs, "name" => $iten->name ); } The array returns like this: array…
-
0
votes0
answers189
viewsQ: Fill in combobox via Jquery
I have the following html combobox: <div class="form-group col-lg-6 row"> {{ Form::select( 'state',array( 0 => '' ),null, array( 'class' => 'form-control', 'data-placeholder' =>…
-
0
votes1
answer140
viewsQ: Authentication Required (packagist.org)
I’m trying to create a project in Laravel with the command: composer create-project --prefer-dist laravel/laravel blog But is requiring an authentication: Authentication required (packagist.org)…
-
0
votes0
answers1609
viewsQ: SQL Server Driver in WAMP
I’m trying to install the SQL Server driver for php 5.5.12 (x64) but I haven’t been able to yet I downloaded the dll’s from website official, and added in php.ini They appeared in the list of PHP…
-
0
votes2
answers60
viewsQ: Access direct key
I would like to access the direct key of an array object without having to loop (foreach) Instead of being like this: $nome = ""; $codigo = 0; $objeto = DB::select( "SELECT NOME FROM TABELA WHERE…
-
2
votes1
answer105
viewsQ: Select columns in different tables
I am using Laravel 5.3 and would like to use columns of two different tables related to foreign key: For example: Client table id | nome | end_cep 1 | carlos | 69084555 2 | Maria | 69088555 Address…
-
0
votes1
answer130
viewsQ: How to Design Wamp for Lamp
I have a Windows finished project (wampserver) using Laravel 5.2 in php 5.5.12 working perfectly. I’d like to know how to copy it to the server that is in Centos 7. Which is PHP 7. If I install…
-
0
votes1
answer53
viewsQ: Search using model
I would like to use my model to do research on Laravel. I wish that, if possible, one could explain to me: I have my model class minhaModel extends Model { protected $table = "minha_model"; public…
-
0
votes1
answer503
viewsA: Call Oracle function in Laravel?
I found the problem: Changed ->select("SELECT funcao(':login') FROM DUAL", array( "login" => $login)); To ->select("SELECT funcao(':login') FROM DUAL", array( $login)); Thus remaining:…
-
1
votes1
answer150
viewsQ: Insert data into Oracle table "no returning id into"?
I’m using Laravel 5.2 and when I have enter data he wants to return the last, but at the moment I want to enter and know if the operation was successful. My role in the controller is like this:…
-
1
votes1
answer503
viewsQ: Call Oracle function in Laravel?
I did all the configuration to connect on Oracle, it connects, but I want to make a query within a function, but it is giving the following error message: Queryexception in Connection.php line 729:…
-
2
votes1
answer2127
viewsQ: Why can’t the web server find my route?
I did the upload of a system in Laravel called android_api on the hostgator server, and configured in the public file. Until the main page it works, where Laravel 5 appears, but when I put the route…
-
14
votes4
answers11575
viewsQ: Use . env file in PHP project?
I realized that in the Laravel uses the file .env for some settings and in the code it a function env(), ask: Is there any way to use the file .env in my project php without using any framework? If…
-
3
votes2
answers2878
viewsA: Open a modal with a button in another modal?
Check whether in the fullCalModal2 have the buttons identified? ID or Class? Take a look at this example: $('.btn-info').on('click', function(){ $('#myModal').modal('show'); });…
-
1
votes1
answer32
viewsQ: Result after update
Hello I would like after an execution in the database return me a value 1, for example I have the function in php: function registrar_pagamento( $pago, $registro ){ require_once…
-
0
votes2
answers245
viewsA: Add a month to jQuery
If only to add the month can be done as follows on the link function calcularMes(){ var dataIncial = $('#checkin').val(); var dataArray = dataIncial.split('/'); var dia = dataArray[0]; var mes =…
jqueryanswered adventistaam 3,354 -
1
votes1
answer272
viewsQ: Colorize field select option Chosen
I have a select option field and would like the user to click submit, the system color the field When inspecting the element with Chrome I realized that Chosen put a style display: None and if you…
-
1
votes1
answer334
viewsQ: Insert data into the chart
I have the following code: window.onload = function () { var chart = new CanvasJS.Chart("chartContainer", { title:{ text: "Desktop Search Engine Market Share, Dec-2012" }, animationEnabled: true,…
-
1
votes1
answer1935
viewsQ: Configure oci8 in xampp php7.18
I’m trying to set up oci in xampp with php7.1.8. I’ve activated the line extension=php_oci8_12c.dll in the php.ini, but when starting the service it gives following message. Unable to locate…
-
0
votes3
answers63
viewsA: I cannot retrieve JSON in jQuery
Try it this way: $.getJSON("//viacep.com.br/ws/"+ cep +"/json/?callback=?", function(dados) { if (!("erro" in dados)) { //Atualiza os campos com os valores da consulta.…
-
1
votes1
answer62
viewsQ: make:auth do not create Route::group
I am studying Laravel following the following tutorial and I stopped at the part where the instructor gives the following command line php artisan make:auth In it creates the following block:…
-
1
votes1
answer1386
viewsA: Ajax and Jquery Freight Calculation
It depends on what you’re using in your form, whether it’s class or id Example: $('.btn-calcular').on('click', function(){ var tipo_frete_class = $('.tipo_frete').val(); var tipo_frete_id =…
-
1
votes2
answers166
viewsA: Dynamic completion autocomplete
I managed to solve! I added within my function to load Combo the following line: $('#setor').trigger("chosen:updated"); Thus remaining: function carregarComboSetor( idSetor ){ /* resto do codigo **/…
-
0
votes3
answers134
viewsA: reading return json_encode php with ajax
Try to return only the data on success and inside you make it: ... /* resto do codigo */ success: function (data) { $.each(data, function(i, j)){ console.log( j.id ); } } ... At least it works that…
ajaxanswered adventistaam 3,354 -
1
votes2
answers166
viewsQ: Dynamic completion autocomplete
I’m trying to use the Bootstrap + Chosen, in my select option to make a combobox with autocomplete. Only I’m filling in the select dynamically with jquery. But when implementing Bootstrap + Chosen…
-
1
votes0
answers126
viewsQ: Insert values in the chart
I’m trying to put the values on the bar graph, but I’m not getting it var especialidade = []; var totais = []; function especFn() { $.ajax({ url : 'function/especialidade.php', type : 'post',…
-
0
votes0
answers74
viewsQ: Change Tab Icon color
Hello I’m using the class Slidingtablayout normally. But I would like you to change the color when selecting the item or Fragment The slidingTabLayout settings I’m making are those on onCreate:…
androidasked adventistaam 3,354 -
1
votes0
answers66
viewsQ: Json Retrofit Badly Formed
I’m with my return in json like this: { "success": 1, "email": "[email protected]" } But the retrofit is saying it’s poorly formed: Gives the following message: use Jsonreader.setLenien(true) to…
-
2
votes1
answer206
viewsA: How best to avoid sql inject
Using PDO also helps $query = "SELECT* FROM cadastro WHERE nome = :nome LIMIT 1"; $stmt = $this->connection->prepare($query); $stmt->bindValue(":nome", $input, PDO::PARAM_STR); Thus, you…
-
0
votes1
answer39
viewsQ: Expandablelist comes hidden initially
Every time I start Activity with Expandablelist comes hidden, then I have to press the off button and turn it on so it shows. How do I fix it? my Expandablelist <ExpandableListView…
androidasked adventistaam 3,354 -
3
votes2
answers260
viewsQ: Retrieve json object
I have the following object: { codigo : "1", nome : "Carlos" } Java class (POJO) public class usuario{ @SerializedName("codigo") private int codigo; @SerializedName("nome") private String nome; /*…
-
0
votes1
answer268
viewsQ: Pass value from Dialogfragment to Fragment
I have fragment1 and Datepickerfragment In the case DatePickerFragment extends DialogFragment I would like when selecting the date to return to Fragment. Only you’re giving it here:…
-
0
votes1
answer216
viewsQ: Return Vector within JSON Retrofit Array
How do I bring information from one vector inside another json-format vector to retrofit: I have my return: [ [ {"prato":"BROCOLIS C\/ SALSINHA"}, {"prato":"ACELGA"}, {"prato":"ALFACE + JERIMUM…
-
0
votes1
answer2105
viewsQ: Pass more than one parameter through the URL
I have the following code: public interface service { @GET("?acao=R&tipo_refeicao={tipo}&data={data}") public void getCardapio( Callback<List<Cardapio>>…
-
0
votes2
answers626
viewsQ: Convert json array to retrofit
I have the following return in json { "cardapio": [ { "tipoprato": "SALADAS", "pratos": [ { "prato": "ALFACE + REPOLHO ROXO" } ] }, { "tipoprato": "PRATO PRINCIPAL", "pratos": [ { "prato":…
-
1
votes2
answers2085
viewsA: Fix Double Click Buttons with Jquery
You can do with jquery too. Only that in the part of setTimeout you can replace for your processing that would $.ajax({ url : 'seruarquivo.php', dataType : 'json', type : 'post', beforeSend :…
-
0
votes4
answers1877
viewsA: Export MYSQL information to JSON
If using PDO can look very elegant your return: public function getCliente ( $idcliente ){ require_once "class.connection.php"; require_once "../model/class.cliente.php"; $retorno = array();…
-
3
votes1
answer12023
viewsQ: Insert TIME DATE on Oracle
I have the following information INSERT INTO tabela (codigo, datahora ) VALUES (1, NVL('',TO_DATE('19/07/2017 19:49:00', 'DD/MM/YYYY HH24:MI:SS'))) Why NVL? Because if it has no valid value for…
oracleasked adventistaam 3,354 -
2
votes1
answer1446
viewsA: How to insert time into Oracle?
You can use the TO_DATE; INSERT INTO EXEMPLO (DESCRICAO, NUMEROMAXIMO, HORAENTRADA, HORASAIDA) VALUES ('Descrição', '50', TO_DATE('15:51:00','HH24:MI:SS') , TO_DATE('16:51:00','HH24:MI:SS'))…
-
0
votes1
answer277
viewsA: Passing placeholder value to a variable
There are some ways you can pass on the value of your input. As you’re new, I’ll show you a very simple way. The default <form action="serarquivo.php" method="post"> <label…
phpanswered adventistaam 3,354 -
0
votes2
answers105
viewsA: php array for json will not all data
Come back like this: $paises = array(); //EDIÇÃO while ($pais = mysqli_fetch_assoc($conn, $query)) { while ($pais = mysqli_fetch_assoc($query)) { $paises[] = array( "paises" => $pais['paises'];…
-
0
votes0
answers193
viewsQ: Add Google Provided Key to my APP
Google Play suggests a license key for my app They have a public RSA key encoded in Base64 to include in your binary file. Remove any spaces. MIIBIjANBgkqhkiG9... How do I add this key provided by…
-
1
votes1
answer934
viewsQ: Find . Keystore from APK
Does anyone know where I find the file. Keystore of my digitally signed APK? It’s the same . jks?
-
1
votes1
answer703
viewsA: Pass value of a variable in Array?
Se está vindo como string você pode fazer de dois jeitos que são a mesma coisa: $('.btn-comida').on('click',function(){ var prodadicional = $(this).data('adicionais').split(' e ');…
-
0
votes2
answers319
viewsQ: Select combobox from a click on the table row
I have a combobox and a table: I would like every time when clicking on the table, select the item in the combobox according to the click. Follow example of the problem. Try to click several times…
-
1
votes2
answers79
viewsQ: Get row item except for one column
Hello! I would like a help regarding the click on a table. When I clicked on the row came the data of this row, except when clicked on a specific column (column 3 for example), because I want to do…
-
-2
votes3
answers1138
viewsA: Take a PHP variable using AJAX
Try sending it like this to see what happens <script> $.get( "request.php", { dados: "dados" }, function( data ) { console.log(data); } ); </script> And in php: <?php $dados =…