Questions tagged as 'phpmyadmin'

Tagged questions
2
answers

Nothing happens when calling .php file via Ajax call in pure Javascript

I'm creating persistence on MySql server for my own web application. For this I am using xampp and phpmyadmin. I created a database in phpMyAdmin and in my application, in a javascript I have an Ajax request for a .php file that makes this co...
asked by 28.05.2018 / 23:27
2
answers

Disable ONLY_FULL_GROUP_BY for once

How do I disable it ONLY_FULL_GROUP_BY for once? I ask why I have already done the steps below: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); and also direct from phpmyadmin : I selected localhost; I click...
asked by 20.04.2018 / 16:30
1
answer

Create procedure in phpmyadmin

I'm trying to create a procedure that changes between insert and update in phpmyadmin but it returns an error in the line of if EXISTS, then I tried to create it by the graphical panel and it returns error in the last line always ... Does anyone...
asked by 13.12.2017 / 15:23
2
answers

sql file or direct to the database

Today a question arose to me, I was creating a table in the database and I came across whether I should do this manually, directly in the database or create this table through queries, creating a .sql page. What would be best and safest?...
asked by 13.12.2017 / 01:22
1
answer

Join in sql that returns all

I have two tables, the one of episodes and of episodes seen, I need to make a query that will join the two by the id of the episode, but I do not want the episodes that are not in the second table do not come in the result, an example: Thisi...
asked by 24.10.2017 / 19:21
1
answer

How to make an INNER JOIN by bringing specific fields from two tables and removing the repeated records and with a max condition?

Well, I have the following tables: Table 01: Andtable02: Then I would like to bring only all the fields with bigger points and do not repeat the waiter in case, how to do it?     
asked by 19.11.2017 / 22:08
1
answer

Is this a server error?

I developed an application on which my local server is working perfectly. So when I put it on the web server it is returning me the following error: Fatal error: Class 'mysqli' not found in Does anyone know if this is a web server error or...
asked by 12.08.2017 / 17:51
1
answer

Database does not work

I've never made a form, so please forgive me if you're absurdly wrong. Here is the bank with the table: CREATE DATABASE db_formacao; USE db_formacao; CREATE TABLE 'db_formacao'.'formacoes' ( 'ID' INT( 5 ) NOT NULL AUTO_INCREMENT , 'NOME'...
asked by 17.07.2017 / 15:31
1
answer

Form does not receive registered data

What's happening: I have a system that, when you finish filling out the form and saving, does not save the changes appearing a alert "saved without changes" and returning to the previous page. It does not seem to be a connection pr...
asked by 31.07.2017 / 14:27
2
answers

Azure error phpMyAdmin: Access denied!

Sometimes, during my work developing my app in azure, I come across this situation: I use the chrome browser My MySql database: MySQL no Aplicativo so I only use it for an application. Any suggestions on how to fix this?  ...
asked by 04.10.2017 / 17:50