Questions tagged as 'mysql'

Tagged questions
2
answers

Permission system

I have a system with a required login. What should happen: If the "active" column is = 1 redirects to a certain page, if it is = 0 redirects to another page. <?php if (!empty($_POST) AND (empty($_POST['id']) OR empty($_POST['senha']) AND...
asked by 21.09.2017 / 14:17
1
answer

Mysql Auto-increment conditioned to a table column

Hello, I'm trying to create a vehicle table that looks like this with php and mysql: +----+-----------------+-------+--------+ | id | nome do veiculo | marca | codigo | | 1 | Gol | VW | 1 | | 2 | Golf | VW...
asked by 20.09.2017 / 20:03
1
answer

FILE PHP editing image and information coming with POST

My code is not editing the information the way it is with the following error, Unknown column '$ full_name' in 'field list', I am passing this value and all others .. The Edit form: <form class="cmxform form-horizontal" method="POS...
asked by 25.06.2017 / 16:25
1
answer

Export DB to Excel

Well, I'm doing a data recovery from my bank to Excel, it's working perfect so far, so it's having a limit, it's not making the impression of my whole table! So getting the 2,800 initial users and there are more than 9k could you help me? Cou...
asked by 21.06.2017 / 17:31
1
answer

Join of two tables query php + mysql

I have two tables: accounts payable and accounts receivable. The two tables have: code, description, date, datepagamento, data collection and value. How do I make a query to get the data of the two tables by sorting by the date? I was us...
asked by 19.08.2017 / 07:54
2
answers

Query on two different tables in Wordpress

I'm having a code, where it returns me some data from all users of the wp_usermeta table, (in this case I'm just pulling the Full Name, and the Capabilities , however to get my table fuller, add users email, which is in the wp_us...
asked by 18.08.2017 / 16:21
1
answer

What's wrong with this query? [closed]

I want to do a subtraction of the total value of a column of a table, with the total value of a column of another table. Query: SELECT ( SUM(r.valor_receita) - ( SELECT SUM(d.valor_despesa) FROM despesa...
asked by 19.06.2017 / 18:12
1
answer

Problems when listing related table data in Laravel 5.3?

I'm working with php, laravel 5.3 and myql. After creating everything (Migration, model, controller, View, relationship), is giving me the following error:    ErrorException in 1d01653e0e29121ce444ef5c2072fb4d52e5e7db.php line 12:   Trying to...
asked by 29.07.2017 / 02:40
1
answer

Jquery autocomplete for city search, does not distinguish data from cities with the same name

I'm using JQuery, Ajax, PHP and MYSQL to do the Autocomplete in a search field for cities in Brazil. When I type the name of the city the suggestions appear and when I move the mouse over each city the code automatically fill in the form with...
asked by 04.07.2017 / 06:19
1
answer

Stop running a certain php snippet

I need to stop the operation of a particular piece of code. The exit, as far as die, stops the whole foreach code block. I just need to stop inside the if, but keep running the foreach, then go back to those ifs, but do not run the first if...
asked by 17.07.2017 / 15:45