Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

Optimize Mysql Database?

I have a TABLE called "Data" which I filled with information brought from a CSV file (Generated from a third-party system). the database has multiple columns with Codes that are not numeric. This is just a small example Table Data Easil...
asked by 24.08.2017 / 06:33
1
answer

How to call names in php from a database?

Good afternoon friends I have this code in HTML (it's just part of the whole code) and even with a database, I would like to know how to say "Monica", "uzziel", "Andres" could bring the names that I have registered in my database. A if I have...
asked by 08.08.2017 / 01:53
1
answer

I can not access tables "in use" on phpmyadmin

Today, when I turned on the PC and started the Xampp, I saw that there are certain tables that I use and I can not access them or repair them if I select them. And it gives an error to access them. How can I access them or repair...
asked by 23.08.2017 / 14:26
2
answers

Problems with the UTF-8 encoding in mysql

I have problems with the character encoding with the ñ and tildes, the page is in utf-8 and the table and the DB in utf-8_general_ci but it happens as in the following image. Any solution? $ connection = new mysqli ($ host, $ userdb, $...
asked by 17.06.2017 / 21:24
1
answer

I can not enter mysql in debian

When installing MySql-Workbrench, it has unconfigured MySQL and phpMyAdmin, stopping working. I have tried to install it again and it gives me the following error:    ERROR 2002 (HY000): Can not connect to local MySQL server through socket   ...
asked by 14.06.2017 / 18:39
1
answer

SQL AUTO-INCREMENT in SSMS

I have exported a PhpMyAdmin database. When I open the document that I generated when exporting with Microsoft SQL Server Management Studio , it shows me the queries of all the tables and data in the database (so far). Since some of the instr...
asked by 18.05.2017 / 17:56
1
answer

PDO does not paint errors

Good afternoon, I am trying to tell PDO that when a SQL statement error is generated, the error code is generated, and currently I think it is due to the connection: public function __CONSTRUCT() { try { $this->pdo = new PDO('my...
asked by 11.05.2017 / 13:53
2
answers

how to build two queries to the same table in one

I have this table with these two queries but I can not find a way to show the two queries in one The final result should look like this:     
asked by 27.05.2017 / 02:05
1
answer

Compare an Input with a record in a bbdd

We imagine that I have this form (It's much bigger but I want to try just one field): <form id="form1 " action="?action" method="POST"> <tr> <th style="text-align:left;">Acronimo</th> <td&...
asked by 14.05.2017 / 19:29
1
answer

does anyone know how I can put a date as the name of a column in phpmyadmin?

It turns out that I have a php with data and one of these is a date and I want to put it as the name of a column but I get an error, they know how I can do it so that I do not get that error, this is the php <?php require('../../conexion.ph...
asked by 18.04.2017 / 04:10