Posts by Groot • 146 points
27 posts
-
0
votes1
answer46
viewsA: Button with 2 "href’s" in php?
Below follows an example, just fit your code. I didn’t use show/IDE but slideToggle. Don’t forget to tag jQuery . $(document).ready(function(){ $('h2.accor1').click(function(){…
-
0
votes0
answers604
views -
1
votes0
answers76
viewsQ: show image coming from postgresql database with ajax
I saved the image in the postgresql(oid) database with php. Now I intend to show this image on the screen through AJAX, but I’m not getting it. The line "$("#image") is maintained.…
-
3
votes1
answer370
viewsQ: take the status of pg_query and pass to php variable
Imagine the following consultation: pg_query($conn,"selects * from tabela"); Considering there’s a mistake in selects, 'ERROR: syntax error at or near "selects" LINE 1: selects * from table... ^'…
-
0
votes1
answer140
viewsA: delete record in dynamic table with php ajax
Solved by checking the answer here and adapting to my code. include("dbconn.php"); <script src="jquery.min.224.js"></script> <?php $qry = pg_query($dbconn,"select id, nome, cidade…
-
0
votes1
answer140
viewsQ: delete record in dynamic table with php ajax
I have the following dynamic table and I want to delete the records via AJAX/PHP but I am not able. I tried this way, passing the line id as the button id but it didn’t work...…
-
1
votes0
answers74
views -
0
votes2
answers82
viewsQ: send file by ajax
I have a form to fill and record files in the database passing the data by ajax but the file is not coming. The form: <script src="jquery.min.224.js"></script>…
-
0
votes1
answer40
viewsA: limit links in php posgresql paging
Solved in this way: $dottedBefore = false; $dottedAfter = false; if ($totalpag > 1 && $pag<= $totalpag) { for ($i = 1; $i <= $totalpag; $i++) { if ($i == $pag) { echo "<i>[" .…
-
-1
votes1
answer40
viewsQ: limit links in php posgresql paging
I have this code that makes me pagination, but I intend to limit to 4 links to each side. The intended: Previous,11,12,13,14,15,16,17,18,19,Next Current code: $qry1= pg_query($dbconn,"select * from…
-
-1
votes2
answers348
viewsQ: real money mask in php jquery array
I have a field to insert a monetary value into an array but the mask only works in the first input, when I add a new line the mask does not work. In this line $("#finTpVal"). maskMoney({Symbol:'R$…
-
0
votes0
answers47
viewsQ: postgresql query between
Table X has the following information: (id serial unique, vlinicial numeric(10,2), vlfinal numeri(10,2)) ID VLINICIAL VLFINAL -------------------- 1 0.01 10000.00 2 10000.01 20000.00 3 20000.01…
postgresqlasked Groot 146 -
1
votes1
answer34
viewsQ: increment lines based on a postgresql record
I have a query that returns the amount and initial value and I want to transform this query into several lines according to the quantity. Example: Consultation: select 3 as numero, 10001 as…
-
2
votes1
answer197
viewsQ: pass value of select with array by ajax
I need to pass the information of a select array through ajax but I’m not getting it. My form: <form method="post" id="form1"> <table width="100%" border="0" cellspacing="0" cellpadding="0"…
-
0
votes1
answer51
viewsQ: ajax result in php session
I’m filtering a Cpf/cnpj through imput/datalist and checking the result with ajax. I intend to bring the result in 2 sessions php but I’m not getting it. The page containing the filter: <!doctype…
-
0
votes1
answer147
viewsA: download/print file recorded in postgresql database with php
Resolved as follows: // consulta postgresql $query = pg_query($dbconn,"select *, encode(lo_get(arquivo),'base64') as arquivo1 from tabela where id = 1") or die(pg_last_error($dbconn)); $queryRow =…
-
0
votes1
answer147
viewsQ: download/print file recorded in postgresql database with php
I uploaded a file to the postgresql database with the OID column type. With the code below I can view/open the file in the browser, but I intend to download and/or print that same file on the…
-
0
votes1
answer192
viewsQ: Array mask
I have a form that I add or remove lines as I increment data, through the buttons. This form has 2 fields with mask, but it turns out that the mask only works in the first line and not in the…
-
0
votes1
answer28
viewsQ: Mousemove reset counter jquery
With this code, the page redirects after 5 minutes if there is no action, and this only happens in refresh or when changing pages, but, intended that the counter reset the movement of the mouse and…
-
0
votes1
answer786
viewsA: write images to postgresql database with php
After a lot of head bumping and seeing unclear examples, most copies of the manual are also not very clear, I was able to upload the client image to the database on the server without having the…
-
0
votes1
answer786
viewsQ: write images to postgresql database with php
I intend to upload images through the browser to a postgresql database using php. I tested with lo_import but it gives me an error indicating that it has to be via superuser on the server side. Any…
-
1
votes1
answer808
viewsQ: display jpg image saved to postgresql database (oid) for html
I recorded an image in the postgresql database with the OID type and now I intend to display this image on an html page with the tag . I verified that through the lo_export I can send to a folder…
-
2
votes1
answer200
viewsQ: photo with distorted webcam using Html5 + javascript
Using the code below, I can capture an image of the camera through the browser, but taking into account that I intend a Portrait format of 4x3 (354x472px). The way the measurements are indicated,…
-
0
votes1
answer1231
viewsA: How to create this view in postgres?
I simulated a query here and did not check any impediment with the number of times the function is used. Maybe showing a little more of the data you are using if you can better analyze the query. so…
-
0
votes1
answer26
viewsQ: do not remove if first line html java
good. with this code I can add and remove lines but I’m having a hard time locking the first one so it won’t be deleted. how can I do? var table = $( '#table-data' )[0]; $( table ).delegate(…
-
0
votes1
answer475
viewsQ: pass input value to php session variable without page Reload
Good. How best to pass an input value to a php session variable without page Reload? For example, with this method the page does the Reload: <form method="post"> <input type="text"…
-
0
votes1
answer407
viewsQ: How can I remove table row with jQuery
I created a table with two buttons one has the function to add new rows to the table and another remove them. I tested this way and can only add new lines, when I try to remove an error happens. var…