Posts by Alison Paulo • 307 points
28 posts
-
-1
votes1
answer45
viewsQ: Calculate the chargeback in percentage of the final value C#
Good evening, the question is more about calculation than programming. The problem is this: if I sell something I must add 15% service charge. var total = 100; var acrescimoPercent = 15.00; var…
-
0
votes0
answers38
viewsQ: Error calling localhost API in . Net Core and React Native. Returns (Network Request File) error
I’m trying to connect a request from my app using React Native calling this Api that was made on Dot Net Core. This is the desired result. But when access Android Virtual Device returns me an error…
-
1
votes2
answers413
viewsQ: Inputmask Regex
I need a mask that gives me this result: FB.B0.C6.E2.65.EB.D3.09.42.EB.23.C0.23.BE.D5.EF.D6.BB.A7.7C-6 Note that between the dots the characters are random, may be letters and numbers, but every 2…
-
0
votes1
answer219
viewsQ: Repeated post in sending the data to the controller, how do I fix?
I’m trying to develop a php mvc system but I came across this problem in Create. The post is sending multiple data repeated do not know why this is happening. My view create looks like this <form…
-
0
votes0
answers37
viewsQ: Shopping cart error in array when recovering last id sqlsrv_fetch_array 11- is not a Valid ss_sqlsrv_stmt Resource in
I am mounting a shopping cart but am facing the following error I mentioned in the title. The method takes 2 parameter the $listProducts is an array as all purchase information and the $Total…
-
2
votes3
answers2407
viewsQ: State and City Combobox associative array in Javascript
I’m trying to set up this associative array, in the case of the combobox is the state of São Paulo, it has to show 5 cities of São Paulo, if it is Rio de Janeiro, shows the 5 cities of Rio de…
-
4
votes1
answer1092
viewsQ: Download Javascript Array on a Combobox
I would like help in this small problem, I have to do a combobox shows 5 states being loaded by an array in javascript, my code is like this. HTML <select > <option…
-
0
votes1
answer901
viewsQ: Backup and Restore in Delphi with Sql Server how to do?
Hello I would like to know how I can do a Backup and Restore to integrate in my system. I have a code ready but is for Firebird I believe that does not fit to Sql Server. I read in some topics that…
-
0
votes1
answer565
viewsQ: How do I run the Menuiten.Click event in an if? Delphi loop
I’m putting together the login part of my system, only I’m facing a big problem. My cancel button from the login screen needs to receive two features. The first is that being clicked before the main…
-
0
votes1
answer157
viewsA: TCPDF how to redirect the page if the code is invalid?
if(isset($_GET['CODIGO']) AND $_GET['CODIGO'] != ''){ $dados = filter_var($_GET['CODIGO'], FILTER_SANITIZE_NUMBER_INT); $sql = "SELECT CODIGO FROM TESTE_TABELA WHERE CODIGO = $dados"; $query =…
-
1
votes1
answer157
viewsQ: TCPDF how to redirect the page if the code is invalid?
I am making a report for printing with TCPDF but I am facing some difficulties in redirecting if the code is invalid. see the following code: if(isset($_GET['CODIGO']) AND $_GET['CODIGO'] != ''){…
-
1
votes1
answer342
viewsQ: Sqlite filter as date return error with strftime function
Hello I have the error in the following code SELECT L.*, C.DESCRICAO AS CATEGORIA , CASE WHEN L.TIPO_LANCAMENTOS = 'C' THEN 0 ELSE 1 END AS ICONE FROM LANCAMENTOS L JOIN CATEGORIAS C ON(C.CODIGO =…
-
1
votes2
answers1135
viewsA: Freight Couriers Error in Pac and Sedex
After hours of searching I managed to solve both problems, in fact they were not so difficult but it took about 5 hours to find out what was happening. Regarding the error -5 that gave in the Sedex…
-
2
votes2
answers1135
viewsQ: Freight Couriers Error in Pac and Sedex
I would like your help in the following mistakes, the first is in Pac, it return the value, until then everything right, but it also brings: Fatal error: Uncaught Exception 'Exception' with message…
-
2
votes1
answer113
viewsA: Extract returns Undefined variable on the detail page
I managed to solve, it was missing a fetch_array same. public function PegarUrl($url){ $sql = "SELECT * FROM CADPRO WHERE URL = '$url'"; $query = sqlsrv_query($this->Conn->Conectar(), $sql) or…
-
0
votes1
answer113
viewsQ: Extract returns Undefined variable on the detail page
I am with the following variable indefinite error, I am developing a shopping cart using Friendly Url. Everything was going fine until I got to the part of returning all the contents of my product…
-
1
votes1
answer763
viewsQ: How to return the records between two values with the SQL Server Database?
Example of my table: My question is this... On my featured news page have to appear the 2 latest news and on the secondary news page have to appear the 2 other news in sequence. Example: in the…
-
0
votes1
answer106
viewsA: Error change password on login system with PHP SQL Server
After snooping for hours I found the 3 errors that caused the system not to run. 1º no while, 2º query had passed the wrong parameter and last in sqlsrv_query I had put before $sql. public function…
-
1
votes1
answer106
viewsQ: Error change password on login system with PHP SQL Server
Good afternoon, I’m having a big problem where I can’t get the password in the system. What is bugging me is that it seems that sqlsrv_fetch_array works differently from mysql_fetch_array, I have a…
-
1
votes2
answers780
viewsA: Error Insert PHP OO Sql Server sqlsrv_query() expects Parameter 1 to be Resource, Boolean Given in
$this->Con = array("Database" => $this->Database, "UID" => $this->User, "PWD" => $this->Pass); $this->Coninfo = sqlsrv_connect($this->Localhost, $this->Con); Damn this…
-
1
votes2
answers780
viewsQ: Error Insert PHP OO Sql Server sqlsrv_query() expects Parameter 1 to be Resource, Boolean Given in
Guys this Class is giving me a work I confess to you that I see no error here, I have seen in php.net I believe that I am following all the logics and syntax. If anyone can help me solve this…
-
0
votes1
answer1200
viewsQ: Argument 2 passed to sqlsrv_connect() must be of the type array, string Given
I searched many places and was amazed to find almost nothing of PHP OO using SQL Server. In short, I cannot understand what is wrong here, I think it helps, I thank you. <?php class Conexao{…
-
0
votes1
answer363
viewsQ: Error listing items using JSON and PHP
I am inserting items in a list through a SESSION in PHP, these items will be read in another page using JSON, but is giving error and I am not able to solve. session_start();…
-
-3
votes3
answers112
viewsA: INSERT method with PHP OO error using SQL SERVER 2012
public function insert($sql){ $return = sqlsrv_query($this->_con,$sql); if($return > 0){ echo"deu"; }else{ die( print_r( sqlsrv_errors(), true)); } } public function…
-
0
votes3
answers112
viewsQ: INSERT method with PHP OO error using SQL SERVER 2012
This is my class connection in the database class Conection { private $_host = 'ALISON\MSSQLSERVER2'; private $_user = 'banco'; private $_pass = '123456'; private $_database = 'aulateste'; private…
-
0
votes2
answers170
viewsA: I cannot update because it is not recovering php Pdo id
Solution of my problem the script now works if(isset($_GET["id"])){ $id = filter_var($_GET["id"], FILTER_SANITIZE_NUMBER_INT);// Atribuindo a variável $id o valor inteiro no metodo get id…
-
0
votes2
answers170
viewsQ: I cannot update because it is not recovering php Pdo id
Here is to recover in html: if(isset($_GET["id"])){ $administrador = new Administrador(); $mostrar = $administrador->listar_id($_GET["id"]); } <form action="Crud.php" method="post"…
-
0
votes1
answer102
viewsQ: Error due to PHP UPDATE with PDO
This code cannot find the records, and brings that variable $lista is undefined. My HTML: <html> <head> <meta charset="UTF-8"> <title></title> </head>…