Questions tagged as 'mysql'

Tagged questions
1
answer

How is the view.blade.php that loads the data for a carousel bootstrap?

I'm trying to load the data dynamically from a mySql database, into a carousel bootstrap, with laravel 5.3. The following is happening: The data is loaded, but the carousel does not work, that is, it stays static, with one image over the other....
asked by 07.04.2018 / 01:31
0
answers

MySQL workbrench

Do not continue, to 99%. How do I continue the installation?     
asked by 07.04.2018 / 02:17
1
answer

How to communicate data from my bank with graph (Highcharts)?

I'm new to php, I'm trying to stock my chart with my bank information.     
asked by 09.04.2018 / 15:01
1
answer

Insert column with mysql function

Good morning, I'm a beginner and I'm having a hard time. I have a column named ID and it is a history table, so this id repeats a few times I wanted a column to return how many times that id was repeated, eg: HOW?     
asked by 06.04.2018 / 16:27
0
answers

Problems with Nginx Cache and Mysql Update

I have a VPS where I work with Nginx, PHP and MariaDB. I also have an application, a news site, where I have on the homepage, some ads that should be counted with each +1 pageviews update. I do this for the UPDATE of the PDO. It turns out...
asked by 06.04.2018 / 17:12
0
answers

Data repeated instead of null

People do not know if this is normal in sql but I'll post here to get my doubts. I have a query with three tables using INNER JOIN, apparently the result is favorable, but a small detail bothers me. see example. What happens is the followi...
asked by 31.03.2018 / 07:41
0
answers

Logic for access permission and registration of permissions in the database Using JStree and Codeigniter

Hello, I'm trying to develop a logic to register permissões de acessos , using codeigniter and plugin jstree At the beginning to add a new permission, the following table is loaded into the database. CREATE TABLE IF N...
asked by 29.03.2018 / 17:23
1
answer

Popular select of countries and states with php mysql ajax

I have 2 selects: #pais and #status. I want you to populate the state with only the states of that country, which are stored in a mysql table: tabela_paises id|pais 1|brasil tabela_estados id|idpais|estado 1| 1 |São Paulo the count...
asked by 29.03.2018 / 17:26
0
answers

Write too slow after adding Trigger to MYSQL Insert

When I insert this trigger into my database there is a slowness, coming to give this message: Errormessage: Lock wait timeout exceeded; try restarting transaction My trigger is as below, the cod_prod field of the products table is indexe...
asked by 29.03.2018 / 21:19
1
answer

How to translate this query to the CodeIgniter query builder?

I'm having trouble putting this query in CodeIgniter, can anyone help? select venda_itens.secao, venda_itens.secao_nome, sum(venda_itens.qtd_itens_finalizada) as qtd_itens, sum(venda_itens.qtd_itens_cancelada) as qtd_itens_cancela...
asked by 02.04.2018 / 19:22