Questions tagged as 'mysql'

1
answer

Store form data temporarily before writing to the database

How do I store data on a form temporarily before inserting into the bank? I have a form with a set of fields. After the user populates the field set, you have the option to add one more set with the same fields to insert new values. I would like...
asked by 27.07.2015 / 15:37
1
answer

Difficulty in grouping and where clause in MySql

I need to search the database for the last 4 most recent records, with the exr_exa_id column matching the reported id's, and exr_exa_id can not be duplicated. I tried to group in a few ways, but I was not successful, because it...
asked by 13.08.2015 / 20:30
1
answer

Version of MySql.Data.Entity compatible with MySql 5.6

What are the versions of: MySql.Data MySql.Data.Entity EF Compatible with version 5.6 of MySql?     
asked by 24.07.2015 / 06:02
1
answer

Sendmail () localhost in LOT

Friends, I'm able to send mail normally using sendmail () localhost, as follows: sendmail.ini [sendmail] smtp_server=smtp.gmail.com smtp_port=587 error_logfile=error.log debug_logfile=debug.log smtp_ssl=auto auth_username=meugmail auth_pas...
asked by 26.07.2015 / 18:45
2
answers

Replication between MySql and Sqlite (E vice versa)

I'm developing a system that integrates a MySQL database with an Android application (via a webservice ). I can already connect, pass data, change them in the bank through the App and things like that. My problem is being the moment that I n...
asked by 23.07.2015 / 05:10
1
answer

How to execute a procedure in PHP

I'm trying to create a listing and I'm having trouble calling the select procedure. Code connecting to the bank: <?php $conexao = mysql_connect("localhost", "admin", "admin") or print (mysql_error()); print "Conexão OK!"; mysql_clo...
asked by 10.09.2015 / 03:31
1
answer

How to convert latin1_swedish_ci data to utf8_bin in php?

I've got a SQL script that "mounts" 3 tables, one with country, one with states, and one with Brazilian cities. The script makes the collection , of the names, in latin1_swedish_ci and I needed it to be utf8_bin , because the...
asked by 13.01.2016 / 15:01
2
answers

generate query dynamically with union

$sql = 'SELECT COUNT(*) FROM '; $cola = ' UNION '; // Deixar os espaços em branco "em volta". $colaWhere = ' WHERE '; $first = true; $wheres = ""; foreach($arrayNomeBDs as $nomeBD){ $where = ' status = 2'. ' AND nomePessoa="O aqui vai var...
asked by 01.07.2015 / 18:33
1
answer

How to set default size of a PHP image

I would like to know if there is any way to set the height, and the default width in php, I saw some forms, but I used an external class, I wonder if there is any way to use the GD library ... $dest = imagecreatefromjpeg('imgs/bg.jpg'); $tam...
asked by 16.11.2015 / 00:42
1
answer

MySQL select random with priorities

I have the following scenario, I have a table and I need to make a select with an order by RAND (). But I'd like to put some conditions for example: TABELA ID | NOME | IDADE | GRUPO    Data 1 | Hiago | 20 | 1 2 | Igor | 15| 1 3 | Ana| 18...
asked by 21.11.2015 / 02:02