Questions tagged as 'mysql'

4
answers

Select mysql accent showing question mark " " [duplicate]

Today I migrated my site to the hostgator and this problem happened, the accents are all with some characters The files are all with correct accent in the database My collation in the database is like: utf8_general_ci I'm using meta...
asked by 26.04.2014 / 00:23
1
answer

Use a column as a header

I have a table in mysql of products, and I need in select or php to transform a column into header, eg: cod produto valor pagina 123 caderno 1,00 pagina 1 456 lápis 1,00 pagina 1 789 borracha 1,00 pagina...
asked by 18.12.2017 / 22:55
1
answer

Failed to add reference to "System.runtime" in ASP.NET

I'm trying to install the latest "stable version" of Mysql.Data by NuGet package manager. The version in question is 6.10.5. When you try to install, the following message is displayed: Failed to add reference to 'System.Runtime'. Please...
asked by 18.12.2017 / 17:11
1
answer

the table does not receive registration

Good afternoon, I'm trying to make a PHP Code that involves Database, and in the course of the code I came across an error which I can not solve. when he tries to register a data through the web, he does not register in any way , alreadywhenItr...
asked by 02.01.2018 / 21:06
1
answer

Fill Selects based on selected item from another Select

I am having difficulty filtering two selects based on an earlier selection of the user. In this case, the user will select the client, and the selects seller and manager should only show the sellers and clients of that selected cli...
asked by 15.12.2017 / 17:43
1
answer

Windows with php the utf-8 characters are correct and Linux is not? [duplicate]

I created pages in php in windows 2012 environment with php (to migrate from asp to php) The pages in php are: HTML5 (made in Notpad ++ in UTF-8 encoding) It has < meta charset="UTF-8" > us head Mysql accesses: $pdo...
asked by 16.12.2017 / 06:13
0
answers

How to get a value inside the array

I would like to know how to get the value of this array Array ( [TIMEDIFF('2017-12-14 17:44:14', '2017-12-14 16:12:21')] => 01:31:53 ) I've tried $timEnd = $resultConvertido['TIMEDIFF('2017-12-14 17:44:14', '2017-12-14 16:12:21')'];...
asked by 14.12.2017 / 21:47
1
answer

MySQL database doubts

In this database and I can not do it: I have this: value_id | entity_type_id | attribute_id | entity_id | value 600 | 2 | 22 | 40 | Gaga 601 | 2 | 20 | 40 | Tonha A...
asked by 14.12.2017 / 20:21
1
answer

Time calculation for PHP + MySQL point

I am creating a table for calculating employee hours, but I am not able to calculate to see if the correct amount of hours worked has been worked on the day. The database looks like this: Thesitewilllooklikethis: In the last column, under...
asked by 27.12.2017 / 15:52
1
answer

Docker-compose to create lamp with phpunit

I'm trying to use docker-compose to create a LAMP environment along with phpunit to run TDD php and what I want to do is this: run a mysql image 5; run an image phpunit 5; run a php 5.6 image so that it communicates with the other i...
asked by 27.12.2017 / 16:24