Questions tagged as 'mysql'

Tagged questions
0
answers

error in session CodeIgniter

I have a dynamic menu that does a search in the database and fills in this menu, when I'm in home it works normally but when the page changes the value returns null and it generates error in count() , I noticed that whenever I change page...
asked by 18.09.2018 / 17:16
0
answers

How to edit using AngularJS

I am studying AngularJS and I was able to create a table receiving the MySQL database data. Now I need to learn how to edit the data. I was able to put a modal and clicking the edit button opens, but I do not know how to pull the data. d...
asked by 18.09.2018 / 16:25
0
answers

Connection Limit, Slow Query (MYSQL)

I made a select to return about 70k lines, everything was working perfectly until I added the function "group_concat ()", after adding this function the query enters timeout and can not return any item. > Is there any way to optimize this sele...
asked by 17.09.2018 / 14:58
2
answers

Problem with quotation marks in query syntax in MySQL

I have a class, and within that class, I have a function to update a data in the MySQL database. Here is the function: public function set_detail($id, $detail, $value) { $query = "UPDATE 'contacts' SET $detail = '$value' WHERE 'contact'.'id'...
asked by 16.09.2018 / 22:35
1
answer

Doubt to get the id of a different table Php and MySql [closed]

How do I save the id of a different table inside a select? Code below <div class="medium"> <span> <select name="turma"> <option>Selecione a Sala</option>...
asked by 17.09.2016 / 15:04
0
answers

Convert Varchar column to Date without losing data

Before the database was saving the date in a varchar field and the Brazilian standard (% with%), then I modified the values using the code below: UPDATE tabela SET coluna= DATE_FORMAT(STR_TO_DATE(coluna, '%d/%m/%Y'), '%Y-%m-%d') WHERE coluna L...
asked by 23.09.2018 / 21:02
0
answers

Ajax does not load

I'm trying to fill in 2 combobox (State), (City) with the database return, the first one of states got, the states are shown and then I get their UF to do the municipalities query, but my ajax does not seem to call the php file. HTML <di...
asked by 23.09.2018 / 07:37
0
answers

How to search for similar words (misspellings) in MYSQL

I'm building a search system using Mysql and PHP, with a form in the _GET method. I wanted to put together a system that if the person types the wrong one, the site can "correct" the word, or suggest the correct word. The only way I though...
asked by 14.09.2018 / 22:30
1
answer

Create query in query builder - laravel

I'm starting to work with Laravel and I need to make a query in the database, it's a simple query, but as I'm starting I still do not know how to do it. I need to get the sales made today, yesterday, this month, previous month, current year...
asked by 14.09.2018 / 22:45
0
answers

Save data from the for loop in the database

Good morning I'm developing a financial part where I fill in a certain form that is due date, full value, discount value, school year, discount percentage and installment amount before saving those installments in the database I created a for lo...
asked by 14.09.2018 / 16:50