Questions tagged as 'mysql'

Tagged questions
2
answers

how to limit sql column information

Good evening, in a script I use I added this string to get some information, <div class="col"><b><?= $this->lang->line('imei');?>:</b> <?=$db['custom_field'];?></div> and the result is: {"494d4549...
asked by 30.11.2015 / 00:59
1
answer

Refresh Variable - SQL Database - Hibernate

Here are excerpts from my attempt to create real estate and user registration software. The project was developed in the MVC framework. (Model, View, and Control.) Problem: How to update an attribute of a MySQL table? The update must be done...
asked by 29.11.2015 / 19:58
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
0
answers

Image upload code does not send gif to folder

I was trying to send images to the database, and the best way was to save them in a directory and just send the name to MYSQL, but when I send a gif, it n goes to the directory but it goes normally for mysql ... <?php require ('connect.php...
asked by 11.11.2015 / 06:34
4
answers

How to check events between 2 dates in MySQL?

Knowing that I have a table called eventos , and this table has the columns id , titulo , inicio and fim . The inicio and fim columns are of type timestamp , where the start and end date and time of...
asked by 04.02.2014 / 20:30
0
answers

Export Table in EXCEL with PHP

I'm exporting my data to excel, but when I export the accents do not return correctly, this is my script: <?php include_once "bancodedados.php"; $table="smt_cadastro_sociedades"; $select = "SELECT * FROM ".$table; $export =...
asked by 20.10.2015 / 14:00
0
answers

Select SUM within another select MYSQL

This query is already working: SELECT itens.setor, xregras.nsetor, itens.grupo, xregras.ngrupo, itens.conta, xregras.nconta, itens.dotacao, sum(IF(tipo = 'ES',total,0.00)) as efetivado, sum(IF(tipo = 'NE',total,0.00)) as...
asked by 09.10.2015 / 20:38
0
answers

Return database result with password only

Is it possible to return something from the MySQL database only with a "password"? I have two names "so-and-so" and "cyano" so-and-so on 11/07, Fulano would have to put his name and the anniversary date to show something from the database, th...
asked by 11.10.2015 / 01:20
1
answer

Because my LIMIT does not accept variable [duplicate]

ERROR: it simply does not query when I play in a foreach because LIMIT does not become the variable I declare Does anyone know how to do it? $cont = 2; $stm = $pdo->prepare('SELECT sol_camiseta.id, sol_camis...
asked by 11.10.2015 / 06:25
0
answers

Joomla 3.0 Error

When recording a module in joomla 3.0 I got this error: 1286 Unknown storage engine 'InnoDB' SQL=SELECT i.*, v.name AS author FROM stw3q_k2_items as i LEFT JOIN stw3q_k2_categories AS c ON c.id = i.catid LEFT JOIN stw3q_users AS v ON v.id = i....
asked by 06.10.2015 / 21:30