Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

Select PHP + Mysql

I'm new to web programming and I'm having trouble creating a CRUD, the insert worked OK, but the next step is that SELECT is not running as it should and I'd like you to help me see which one is being my mistake. I'm doing this: <?php $con...
asked by 06.06.2016 / 06:26
0
answers

Password Bitnami Moodle

I am trying to access PhpMyAdmin in Moodle from Bitnami and I can not log in, I just installed and do not know the root , I'm waiting for answers ... I have tried to leave without a password and have already tried the "root", "admin" and...
asked by 24.03.2016 / 14:23
0
answers

Different results for query Mysql 5.1 and 5.7

We developed a project for a client using MySQL 5.1.68 and at the time of publication we identified that the client's hosting was version 5.7.4. Once the project has been published, we begin to see some strange behaviors in the results return...
asked by 01.09.2015 / 12:54
1
answer

SQL - Condition with Between

I have a form where the user can search for a date range, so far so good. If it searches only for a date, how can I do this directly in sql or even in php?! Any suggestions?     
asked by 28.07.2018 / 15:02
2
answers

Syntax error in sql command [closed]

I'm having a possible syntax problem with sql in my code if (tbCPF.Text != "" && tbNome.Text != "" && tbEndereco.Text != "" && tbNumero.Text != "" && tbBairro.Text != "" && tbCEP.Text != "" && t...
asked by 24.10.2018 / 06:06
1
answer

Remove space from a column in Opencart

I made a select in the table oc_product SELECT * FROM oc_product in the column sku needed to remove all the spaces of these items are more than 2000 lines with this problem it is possible to remove this dynamically follows a...
asked by 26.10.2018 / 17:33
1
answer

Alternative to PHPMyAdmin [closed]

Does anyone know how to tell me a database manager where I can assemble more complex queries without having to type the query? Just by clicking where I want to do a SELECT for example? I need to make multiple queries that involve a SELECT in...
asked by 23.07.2018 / 13:33
3
answers

Option to delete, edit, copy

I want to delete an item in the phpmyadmin table but it does not appear, How do I display these options? I'll leave a print below:     
asked by 16.07.2014 / 23:29
3
answers

How to make an INNER JOIN bringing everything from two tables and one more "max" in a specific field?

Good people, to be more specific I have two tables. table 01: ...andtable02: ...andIwouldliketodoa"select" bringing all of these two tables, but where in the "dots" field (table 02) you have the highest number of points, how to do that? Eg...
asked by 16.11.2017 / 11:50
1
answer

Do I need to create columns in phpmyadmin for each checkbox I've created?

I'm creating a hotel site for a school project, and I wonder if for every checkbox I created in the code, do I have to create a column in the phpmyadmin database? And how do I store that choice of checkbox there in the datab...
asked by 10.07.2017 / 18:57