Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

Migrate data from Database to different server database in MySQL?

good I have the following panorama I have a database called Mybase in which there is a table called mytabla on a server and I have another server where I have a database called Mybase2 in which there is a table called MyTabla2 equa...
asked by 13.12.2017 / 18:49
2
answers

How to show hidden table in phpmyadmin?

Greetings, I'm using phpmyadmin 4.7.4 and I gave it on the eye icon next to the name of a table, and now I do not find the option to show my table again, does anyone know how I can go back to show my table there?     
asked by 03.12.2017 / 22:24
2
answers

How to save array of select Mariadb and save values in different variables (not the complete array) PHP?

Hello, I have a function that returns an array but I want to access by means of its indexes to the value that I want from the selected fields in the database, for example, to save the variable at the index [0] in other words the first value of t...
asked by 13.09.2017 / 21:19
2
answers

Group records in a table

I have the following query: SELECT * FROM tabla1; So it shows this: Empresa | Empleado -------- --------- pepsi | jose -------- --------- pepsi | pedro -------- --------- pepsi | juan What I want you to show is this: Empresa |...
asked by 12.06.2017 / 15:02
2
answers

Problem when displaying databases

I wanted to locate the route where my databases are hosted, with the aim of configuring a .bat file to make automatic backups. On the server where I have the PHPMYADMIN installed, I do the following, showing the following databases, and mine...
asked by 04.09.2017 / 09:19
2
answers

In MySQL how should the data types be declared in case of using the following elements in JAVA

1) If you are going to create a password with JPasswordField, what type of data should be declared in the SQL database ... would it be varchar or another? I understand that the passwords are encrypted and ask for another type of data. 2) In t...
asked by 18.05.2017 / 03:41
2
answers

SQL select one thing from two different tables in the same query

Good, I have two tables, one is called PERSONAL and the other TASK, and I do not know if it is possible through the JOIN operator to select the field "name" of the PERSONAL table and the "description" field of the TASK table that has a certain i...
asked by 23.02.2017 / 20:02
1
answer

PDO num_rows count

I have this select input that gives me the option to choose a name of all the ones that can be removed: <td width="50%"> <select class="form-control" id="acro_proyecto" name="acro_proyecto" required> <option value="<...
asked by 01.06.2017 / 09:06
2
answers

Good morning. Someone who can explain or help me how to export in pdf the records of each row in mysql

This is the code that generates the query of the entire table $sql = "SELECT * FROM mitabla"; $query = mysqli_query($con, $sql) or die (mysqli_error($con)); $item = 0; while($row = mysqli_fetch_array($query)){ $item = $item+1; }...
asked by 20.08.2016 / 09:50
2
answers

Error with $ _SERVER ['$ PHP_SELF']

I have a CRUD but when I insert it, I get the following error:    "Forbidden access!   You do not have permission to access the requested object. The object is protected against reading or the server can not read it.   If you believe that t...
asked by 06.08.2016 / 19:09