Questions tagged as 'mysql'

Tagged questions
1
answer

MySQL Connection with Delphi6

I need to connect to MySQL database using DELPHI6 . Does anyone have a solution?     
asked by 22.06.2015 / 03:08
3
answers

Error giving a select in two tables

I'm trying to do a select in these two tables, but this one bringing up wrong data, I want to do the following, list the loan requests that have not yet been rented, ie if the codigo_socio is in the table borrowed it stays without showing...
asked by 08.06.2015 / 15:49
0
answers

Inner Join + Where in MySQL

How to use INNER JOIN with WHERE ? I'm doing a INNER JOIN with 3 tables. I need a WHERE to return only one record. I'm trying this way: SELECT '*' FROM ('tabela1') INNER JOIN 'tabela2' ON 'tabela1'.'id' = 'tabela...
asked by 27.05.2015 / 20:09
1
answer

How to execute PHP file from function in JavaScript?

I have the following structure for registering a new MySQL database account (register.php): <?php $con = mysqli_connect("meu_host","meu_user","minha_senha","banco"); mysqli_query($con,"INSERT INTO contas VALUES (" + $id + ", " + $pass...
asked by 25.03.2014 / 04:09
1
answer

Get file stored in Bin in MySQL

Live! I'm having trouble getting my PDF file that was stored in a MySQL DB. Whenever I download it, I can not open it because it returns the message that may be corrupted. So I store: $docs = new Documentos(); $assunto = filter_input(IN...
asked by 08.05.2015 / 11:15
1
answer

inserting image into mysql database

If I want to insert an image into the database, just use the following query: INSERT INTO teste (Id_Blob,Na_Imagem) VALUES (1,LOAD_FILE("C://imagem.png")); If I want to insert an image that is on another computer on the network, how does th...
asked by 18.06.2015 / 02:16
2
answers

I can not run the MySQL Server 5.2 Workbench [closed]

I'm trying to connect to the MySql Workbench 5.2 CE server to open a project in Ruby. But I can not connect to the server (local). The following error appears: Can not connect to MYSQL on '127.0.0.1' (10061) . I've tried some tutorials, but not...
asked by 01.05.2015 / 04:42
1
answer

How to use a user's information in the mysql database in a label? iOS

I'm developing an app for iOS that connects to the mysql database and logs in the user using the email and password information, this part is working well. Now I want to get other information from this user and display them on a label. How would...
asked by 18.06.2015 / 08:19
1
answer

Inserting dates in php with PDO

I'm having trouble inserting a date into the database with PDO. I have a mirror class on my table in the bank: class PaginaEntity { private $id; private $data; public function __construct(){ $this->data = date('d-m-y h:i:s A'); //gets...
asked by 19.04.2015 / 04:25
1
answer

Save variable value javascipt in the database

function showpos(position){ lat=position.coords.latitude lon=position.coords.longitude var enderDe = (+lat+',' +lon); How do I save the enderDe variable in my database?!     
asked by 20.04.2015 / 03:32