Questions tagged as 'mysql'

Tagged questions
2
answers

Problems with Datatables using PHP and MySQL

I made a system, where user can create table for the bank, and tbm can create columns, so I do not know which columns were created, but with the bank script I can list the columns of this table I'm trying to mount my view table with datata...
asked by 18.10.2017 / 16:12
2
answers

php error with mysql and mysqli

I'm a little new to programming and I'm having a hard time, I was programming a website and I ran it on wampserver, but for a while I updated the wamp version and MYSQL's php commands stopped working, it works only when I change the commands to...
asked by 16.01.2018 / 04:27
1
answer

What is the difference between the query with '(quotation marks) and without' (quotation marks)?

Good luck, I want to know the difference of a value involved with '(quotation marks) and value without the' (quotation marks). Ex: SELECT * FROM dados WHERE nome = $nome (valor sem uso das aspas) SELECT * FROM dados WHERE nome = '$nome' (va...
asked by 15.01.2018 / 02:28
1
answer

doubts with summation Mysql

I have the following tables Thetablecontamov,canhaveseveralcasualtiesofthesamerecordofthetablecrecpa.Ineedtoselectrecordsfromthecrecpatableandthesumofthelows(valuefield)ofeachrecord,Itriedwithasubselect,butwithoutsuccess,whatistherightwaytodoit...
asked by 13.01.2018 / 23:00
1
answer

Inform the user that the registration already exists

I have a user registration code on my site, it sees that the user is already registered and does not re-enter the table, but I can not inform the user that the registration already exists. $sql = 'INSERT INTO usar (campo1, campo2) VALUES (...
asked by 27.11.2017 / 14:34
2
answers

Search filter not specific

I have a page with a search filter with the options "service", "state" and "city" and a submit button that redirects to the page where a table with the already filtered records will appear. But currently the filter only works if all three opti...
asked by 29.11.2017 / 14:02
1
answer

UPDATE not working with ajax?

The problem is this, I have an edit form whose data is sent by ajax . Here is the code: $("#edit_rua").click(function(){ var id = $(this).attr("data-id"); var nome = $("#nome_rua2").val(); var cod = $("#cod_rua").val(); $.ajax({...
asked by 30.11.2017 / 18:40
1
answer

How to use a website on the server [closed]

So I created a system in php that saves the numbers among other things from company employees, I use xampp on my computer, I was wondering how do I put the system in php on the server and make it get open on company computers ...     
asked by 27.11.2017 / 16:03
1
answer

Logic of a Likes table

In a PHP + MySQL application in which I need to store as many likes + id's of who I gave in a post, I came to doubt the logic. Assuming 2 users give like in the same post at the same time, and both execute: UPDATE te_anuncios SET curtidasTo...
asked by 03.02.2018 / 12:49
1
answer

Calculate average speed of the last records of the MYSQL table

I am developing a project that calculates the evolution of the water rise. Made with arduino and ultrasonic sensor it feeds the data into a mysql table. every 60 seconds it inserts the value of the height of the water. So far right. How could...
asked by 17.12.2017 / 20:13