Questions tagged as 'mysql'

Tagged questions
1
answer

Query MYSQL bring results by order of distance using coordinates [duplicate]

I have a table that has the coordinates (latitude and longitude) of the users. How do I make an appointment to bring people closer to the location. Ex: ID | Lat | Long 1 | -22.874428 | -43.372334 2 | -20.292799 | -40.301991...
asked by 31.08.2017 / 13:16
1
answer

Difficulties getting values inside an array

I am making a code where I select information from the database and feed an array, in the sequence I am trying to use the contents of this array to compare with other information and process the rest of the code. But I'm having trouble gettin...
asked by 06.10.2017 / 02:52
1
answer

Record Radio Button Mysql PHP

I have a system in PHP, JavaScript and MYSQL where the person assembles his request ... Link to the site It's working correctly, but I need to pass data to a report and I do not know how to do it ... Ex. Size 06x08 - Oval - Without Fr...
asked by 19.09.2017 / 05:28
2
answers

Search for all records that exist in another table at least once

Hello, I'm having trouble doing the following query: I have 3 tables: users_categories , main_bucks and new_bucks When a user creates a budget, the system creates a record in primary_budget with the main information, which is: Who c...
asked by 19.09.2017 / 20:07
2
answers

On-demand paging with button and POST method in PHP using PDO

I looked at some sites and saw some things about it, but I can not understand the logic behind the page on demand. jQuery(document).ready(function(){ jQuery('#btnpaginas').click(function(){ var dados = jQuery( this ).serial...
asked by 01.09.2017 / 03:06
1
answer

Many zeros in the modal

I created a test modal in the attempt to return the value of the id to the view and since it has more than 5000 records in the query, I do not know what happens .. but it prints one million zeros in the modal, does anyone know the can it be?...
asked by 31.08.2017 / 22:30
2
answers

Difficulty in creating sum column in mysql

I am doing a commission report, but a question arose, I want to bring some totals at the end of the report, for example the gross value of all commissions, which would be vl_comis - desc_comis . Anyway, how do I create a column called t...
asked by 20.09.2017 / 19:02
1
answer

How to update multiple records at once? PHP + MYSQL

TABLESIZE:ID|NOME|PRECO1|06x08|0.002|08x10|0.003|09x12|0.004|11x14|0.005|13x18|0.006|18x24|0.00Ineedtoupdateprices...howdoIdothisusingUPDATEwithPDOMySELECTisthustogetherwithaWHILE<divclass="panel-body"> <?php $pdo = db_conn...
asked by 22.08.2017 / 03:00
1
answer

Single download page for each user

I'm trying to create a user area on my site with PHP and MySQL, so far I've been able to make the login system and a private page for clients. The question is how could I make a single page available to each customer? My goal is to provide...
asked by 21.08.2017 / 17:56
1
answer

Error: Uncaught Error: Class 'mysqli' not found

I'm using Apache to make a localhost site, but I have an online bank and wanted to access it I make the connection in php <?php $servername = "host.com"; $username = "user"; $password = "pass"; $dbname = "banco...
asked by 21.08.2017 / 17:13