Questions tagged as 'mysql'

Tagged questions
1
answer

PHP and MySQL: base64_decode within SELECT

Hello, I have an INSERT that registers with the database with base64_encode (), working perfectly. "INSERT INTO Atendimento_Campo_Prontuario ( acpr_id, acpr_apro_id, ac...
asked by 20.07.2016 / 20:10
0
answers

Synchronization failed? MyWorkBench 6.3 - phpMyAdmin

Good people, I would like you to clarify a doubt and if possible, help me. I built a data model (myWorkBench) and then synchronized the data model. After that, I have access to the tables in phpMyAdmin but I do not know why, there is missing a t...
asked by 20.07.2016 / 16:14
0
answers

Request select returning null value

Good afternoon, I'm having trouble getting the value of a select in the form below: {{Form::open(array('action' => 'FilterController@EstatisticaEsic', 'class' => 'form-filter'))}} <div class="col-md-2 col-sm-12 col-xs-12 d...
asked by 05.08.2016 / 20:02
1
answer

Insert with SQLSTATE error [HY093]

I am making a form to save data in the database and this error Erro SQLSTATE [HY093] <?PHP $nome = $_REQUEST['Nome']; $cpf = $_REQUEST['CPF']; $sexo = $_REQUEST['Sexo']; $datanasc = $_REQUEST['DataNasc']; $telefone = $_REQUEST['Tele...
asked by 07.08.2016 / 18:14
3
answers

No select error using mysqli_query

I've done a php to list the rooms, but I'm having difficulty listing them, if anyone can help me, I would appreciate it. <?php $link = mysqli_connect("localhost","root","","hotel"); $result = mysqli_query("SELECT descricao FROM quartos WHER...
asked by 08.06.2015 / 21:53
1
answer

Error changing table via Doctrine Migrations

Through git I used the command below: php bin/console doctrine:migrations:generate I opened the file and made the change <?php namespace Application\Migrations; use Doctrine\DBAL\Migrations\AbstractMigration; use Doctrine\DBAL\Schema...
asked by 15.07.2016 / 17:59
3
answers

No select error using mysqli_query

I've done a php to list the rooms, but I'm having difficulty listing them, if anyone can help me, I would appreciate it. <?php $link = mysqli_connect("localhost","root","","hotel"); $result = mysqli_query("SELECT descricao FROM quartos WHER...
asked by 08.06.2015 / 21:53
0
answers

Save database from another HD

I had a main HD with my webserver - Apache, PHP, Mysql - but it gave trouble and could not access anymore. I needed to format a new hard drive and reinstall my environment. The problem is that you did not have time to export the database. I...
asked by 11.07.2016 / 22:01
1
answer

Error inserting record into daughter table with PHP

Hello, I have the following tables: | ----- tb_user ---------------------------------------- ----- | id - name - login - password - flag_active - permissao | ------------------------------------------------- --------------- | | ------...
asked by 12.07.2016 / 17:22
2
answers

Select in table records with relation MxN

Hello, I have in my database a table tb_usuario (INT id, VARCHAR name, INT flag_active) and a table tb_regional (INT id, VARCHAR name, VARCHAR login, VARCHAR password) . From the relationship between the two the table tb_regional_user (tb_reg...
asked by 12.07.2016 / 14:53