Posts by Fernando Fefu • 301 points
29 posts
-
0
votes0
answers22
viewsQ: Select comparing in Where 2 columns of different tables
I’m trying to set up a consult but it’s not bringing anything. SELECT EMP, COD, VEV, SEQ, TIP, NUM, EMI, VEN, DTR, GRU, PRO, QTD, PVE, TOT, FAT, COM, COO, REF, VAR, hcli.NOM as "VENDEDOR", hemp.enc…
sqlasked Fernando Fefu 301 -
0
votes1
answer42
viewsQ: Do not bring duplicates with a certain condition in a SELECT
I need to build a query that removes duplicates from a custom column (concatenated) if a given column is X value. For example: SELECT emp, cod, vev, gru, concat(cast(emp as char(20)), cast(cod as…
sqlasked Fernando Fefu 301 -
1
votes1
answer106
viewsA: TIMEDIFF with period exception (Business hours)
Solved via php. If someone with the same problem follows me code already considering Saturday/Sunday and array for holiday.. Detail in the code that for Saturday the period is different that was…
-
0
votes1
answer106
viewsQ: TIMEDIFF with period exception (Business hours)
Hello, I have an SQL query that returns the time difference between 2 dates, but I need to calculate this difference by adding a period (08:00 - 18:00) for example: Start date: 2019-10-18 15:00:00…
-
1
votes1
answer57
viewsQ: Datediff calculating only time
I currently have a code that calculates the difference of 2 date/time but my calculation is only calculating the time and if the final date is another day the time does not count +24h and only makes…
-
1
votes2
answers101
viewsQ: How to use more than one LIKE in PDO bindValue
I’m having a hard time making an appointment SQL with the bindValue from PDO. I need to pass more than one value in the clause query like :cc plus the value returned is 0. If I use only one value…
-
0
votes1
answer81
viewsQ: Problem for "Save image as" php
I have a code that generates an electronic signature but when the user clicks right on the image generated to "Save image as" the name of the image comes as default name_pagina.php.png. How do I get…
-
0
votes1
answer821
viewsQ: Get input value for AJAX
I found a code that sends an information via AJAX, but I need that, in addition to sending this information, it also send the value from another camp(input). I need to read the value of input name…
-
0
votes1
answer29
viewsQ: Set the name of the select input from the database
How do I make the item description (coming from the bank) appear in select instead of the phrase "Select Equity Account" I want it to appear: $listar3["DES_CONTA_PATRIMONIAL"] for the selected item.…
-
0
votes2
answers50
viewsA: How to query 2 columns in a single input text
$var1 = $_GET["revenda"]; $var2 = $_GET["bemdesc"]; $var3 = $_GET["bemdesc"]; $query = ("SELECT bem, des_bem, revenda FROM AFX_BEM WHERE revenda LIKE :rev AND ( des_bem LIKE :bd OR bem LIKE :bd2 )…
-
0
votes2
answers50
viewsQ: How to query 2 columns in a single input text
Hello, How do I use a single input text to query 2 columns? Currently my code has an input=select and an input=text but in the text I want to see 2 columns.. how do I do this in the sql query? Note…
-
-1
votes1
answer2147
viewsQ: pass two parameters via GET
Hello, I am doubtful how I can pass 2 parameter via GET, only the second would be after the answer of the first. what I want to do is select an item in an input select and update the page with that…
-
0
votes1
answer189
viewsQ: Administrator of Parking in C
How do I calculate the totals of car parking values as stated below: Do a C program to assist in the administration of a parking lot For this procedure the following has been informed: for each car…
casked Fernando Fefu 301 -
0
votes1
answer483
viewsQ: Backup mysql database in PHP
I need a backup knob that I can select a folder where will save my mysql data.. I found some mysql dump codes but all with save location defined via code and what I really need is that it is…
-
0
votes2
answers851
viewsA: problem with emphasis on jquery autocomplete
solved my problem by changing the line $row['value']=htmlentities(stripslashes(utf8_decode($row['value']))); for $row['value']=stripslashes(utf8_encode($row['value']));…
-
0
votes2
answers851
viewsQ: problem with emphasis on jquery autocomplete
I have a UTF-8 problem in my code. I have a input text with autocomplete (jquery function) that works ok with results coming from Mysql, but when a word is accented the accented letter appears a…
-
-1
votes1
answer1795
viewsQ: update a div without refresh on the page, after insertion via ajax
I need to build a new (table-like) structure containing the information that has just been inserted into mysql via ajax without the page being updated. To better specify, I currently have a while…
-
1
votes1
answer469
viewsQ: Send id to an Hidden field by clicking on an item in the.js autocomplete
I need to send the client id to an Hidden field by clicking on its name that is brought by the jquery autocomplete. The autocomplete is already working ok.. what I really need is to click send the…
-
-1
votes2
answers128
viewsA: Create a register where the user increments a new checkbox to save a new information in Mysql
I found a code on the Net that gave me a light.. I haven’t implemented it yet but that’s basically it: Javascript: At First include the jQuery library. <script…
-
3
votes2
answers128
viewsQ: Create a register where the user increments a new checkbox to save a new information in Mysql
I need to create a client register, where certain part of the registration the user has several checkbox that would use to store if the client has such documents, for example: [] RG [X] CPF []…
-
3
votes1
answer293
viewsQ: Create a download link for path that is in mysql
I have the following structure in the database: reuniaoId escolaId usuarioId dataReuniao tituloReuniao pathReuniao 7 14 1 2016-01-13 AEQEQ uploads/reuniao/ata_2016_2418530_2HK73386F.pdf I need to…
-
3
votes3
answers5281
viewsQ: take the value of a <td> by clicking on a checkbox of the same <tr> jquery line
How do I get a value from a <td> by clicking on a checkbox that is in the same <tr> in jquery Follows my code: HTML <table style="display:none;" id="tableTime"> <tr> <td…
-
1
votes2
answers3874
viewsQ: How to take the value of an input within a <td> in jquery
Ola, I have the following table in html <table style="display:none;" id="tableTime"> <tr> <td class="hora">08:00</td> <td class="eventoAgenda" id="0800"></td>…
-
0
votes1
answer374
viewsQ: Return ajax error when have accent
I have a table that when I include some text that contains accent add all other texts of the same condition. tried several ways to use UTF-8 I found on the net but none worked and I noticed in the…
-
1
votes1
answer1983
viewsQ: Get column values from a table and save the value of each column in an input
I have a table with 2 columns and I would like to, when clicking on some row, assign the values of each column of this row clicked on a <input type="text" />. I have a code that he assigns but…
-
-2
votes1
answer464
viewsQ: Return 2 date type in ajax
I have an ajax that returns me a date on onSelect of a datepicker, so far so good.. but I need the consultation to return me also the ID of a select (dentists) how can I make these 2 returns on a…
-
0
votes1
answer216
viewsQ: how to put the return of a json in a specific place of a table?
I have a fixed table with schedules from 08:00am to 19:00pm each has its line with its description(that would be the type of query) I receive a json on my page when selecting a date on my datepicker…
-
-1
votes2
answers340
viewsA: Why is my query not working with the php variable
try this way $query_matricula = mysqli_query($conexao,"SELECT matricula FROM usuario where nome = '{$nome}'") or die("ERROR" .mysqli_error());
-
2
votes1
answer1167
viewsQ: Handle JSON data coming from a jQuery datepicker request with ajax
I need to create an agenda.. I have a datepicker and a fixed table beside with schedule that start from 08:00am until 19:00pm and when I click on a datepicker day it returns to me all the queries of…