Questions tagged as 'phpmyadmin'

Tagged questions
0
answers

Problem when starting phpMyAdmin session

I have a big problem, my app / web has stopped working. I have tried to restore to a version in which it worked and remains the same. I tried to enter my phpMyAdmin panel to see if the problem was there and I missed this error. How can I s...
asked by 25.01.2018 / 11:58
1
answer

Change the structure of a table in MySQL

In this case I will use ALTER TABLE to take the AUTO_INCREMENT to zero (0) . The goal is to bring the table to 0 without having to delete it and create a new one. To do this we just have to write the following order: ALTER TABLE 'nombr...
asked by 20.01.2018 / 19:31
0
answers

Problem loading csv to Phpmyadmin

From a file in excel I generate a csv file which I want to import into PhpMyAdmin using the Import from PhpMyAdmin option. But the first field, which is the primary key, only recognizes the last 3 characters. INSERT INTO 'tabla' VALUES ('214',...
asked by 17.01.2018 / 17:57
1
answer

Edit two fields from different tables in a query

One question, I opened some way that when I edit a specific field of a table, at the time I edit another field in another (Database = Mysql), since I have a date type field and I need that when I modify in special that field I edit another field...
asked by 24.01.2018 / 15:26
0
answers

How to show all the articles of a sale? Laravel

I have a question to make a query where I show the sale with your items sold. I currently have this query: $query=trim($request->get('serachText')); $ventas=DB::table('venta as v') ->join('persona as p', 'v.cliente','=','p.i...
asked by 05.01.2018 / 19:50
0
answers

Take the name instead of the ID

I have a list of data obtained from a database, but when I give "delete", in the text I get if I want to remove the product "id", and wanted to change that instead of the ID, leave the name of the product. The code that I have put is this: <...
asked by 02.01.2018 / 11:53
1
answer

Queries in PHP and MYSQL

I make a payroll system which I have problems with the query module I have the tables called worker that is my main table, hence the foreign keys of my tables "area", "position" and cg_turno. In my insert module I have no problem as I insert by...
asked by 14.02.2018 / 09:27
1
answer

I do not know how to take the value of a select

Hello everyone I need to take the value of a select which I fill with php, but when sending the variables to the php file I do not take the select <select name = "congregacion" id = "cmbCongregacion"class = "input-100" required&...
asked by 28.12.2017 / 03:41
1
answer

Query gives me repeated data

Good: When I make this query, it gives me the repeated data that I have in the table (and2018payments). Is there any way to show me the data once? $qry = "select alu.id_alumno, matr.curso, matr.fecha, matr.grado , alu.proceinsti, alu.apelli...
asked by 10.01.2018 / 15:22
1
answer

Login with different users

Hello stack overflow partners. I have the following Login with 3 types of users. It happens that when entering the login controller. It stays blank and I do not know what else happens. It worked without having to use the switch an...
asked by 07.12.2017 / 22:33