Questions tagged as 'mysql'

Tagged questions
0
answers

Join 2 query on mysql [duplicate]

I have a problem in attaching 2 query in mysql. Well I have a query that, roughly speaking, brings me information from a transporter, from the cte and how much was the freight. Another query shows me the price lists of the conveyors. I want...
asked by 07.05.2018 / 16:47
0
answers

Database does not receive querys for php script although it works

I have a problem with receiving the form in the database, it seems that although the script is correct it simply ignores it, so using xampp, I tried cloud9 too and the same thing happens. <?php include 'connection.php'; $name = $sbname = $...
asked by 07.05.2018 / 00:53
0
answers

Laravel: How to work access levels? [duplicate]

Good evening, I'm developing a system with Laravel 5.6, and I have a table of USERS that has the attribute level. This attribute can be either USER or ADMIN. How do I block page / dashboard access if the user has a USER level?     
asked by 15.05.2018 / 02:18
0
answers

Set up Mysql to accept TIMESTAMP zerado

I am migrating a database from SQL Server to MySQL . In migration it gives error when populating tables in MYSQL TIMESTAMP . Incorrect datetime value ( 2007-10-21 00:00:00.000000 ) When du% manual% fills the hours, it inserts the valu...
asked by 15.05.2018 / 02:18
1
answer

My code gives this error Fatal error: Call to a member function fetch_assoc () on boolean

Does anyone know why this error in php when querying a table in mysql    "Fatal error: call fetch_assoc () on boolean in   /storage/emulated/0/site/roja/adm/editar_produto.php on line 85 " Since in another page using the same...
asked by 08.05.2018 / 21:11
0
answers

How to create download button in PHP [duplicate]

I have a download area where the file links are in a MYSQL table and I created a key that would be the key to download. The table is this: id| arquivo |chave 1 |arquivo.mp4 |e8d95a51f3af4a3b134bf6bb680a213a The only way I can downl...
asked by 03.05.2018 / 23:46
2
answers

ChartJS + mysql + php (subscriptions in the month)

Well, I have a table of user registrations. I'm creating a chartjs to display the number of registered users per month on a bar chart. The mysql query would only have to return me 2 columns (MONTH and TOTAL NUMBER OF SIGNATURES OF THAT MON...
asked by 16.05.2018 / 20:56
1
answer

Error between accounts in 2 tables laravel

Sorry for my not experiencing in laravel, I'm starting the studies and I need to consult a Mysql table according to the value of another table eg: Tabela Sessões | id | nome | | 1 | João | | 2 | Fabio | | 3 | M...
asked by 16.05.2018 / 19:52
0
answers

Options Selectize.js using Ajax

I'm developing an application using selectize.js, and would like the values that appear in the input or select to be imported from the BD (Mysql). I would like to import them using ajax, because when selecting an option in select, other fields m...
asked by 03.05.2018 / 16:39
0
answers

Impact with the use of INDEXES in MySQL

I have a table that currently has 25 million records , so any query I make, however simple, becomes very slow. I was researching on INDICES to improve search performance and found that it helps a lot on speed issues and that's great, but I...
asked by 03.05.2018 / 17:52