Questions tagged as 'mysql'

Tagged questions
2
answers

I can not bring database data from more than one table

I'm learning how to do an admin, and so I created some tables in the database, but I do not know why I can only insert and delete user table and non-project table data. It must be some silly mistake, below I'll show you how I created my codes....
asked by 10.06.2015 / 20:19
1
answer

How does an e-commerce with bars ex: www.loja.com/meunome, and how is bd divided? [closed]

I would like to know if possible how a great e-commerce works for example, I would like to create my user and put my products for sale, in the example link: www.loja.com.br/meunome www.loja.com.br/seunome How does this work? Does the perso...
asked by 14.05.2015 / 16:19
2
answers

Error: Access denied for user 'root' @ 'localhost' (using password: NO) when accessing Website

Good evening, I've been trying to run a website through a raspberry to access it with remote access. I installed OS Pipplware along with Lamp and phpmyadmin. I sent through the filezilla based on the website and ran everything perfection. Php...
asked by 19.06.2015 / 17:37
3
answers

How to close mysql connections in C #

Running the code below: DataSet bdDataSet; MySqlConnection conexao; public void inserir() { bdDataSet = new DataSet(); conexao = new MySqlConnection("Server=localhost; Database=teste; Uid=; Pwd="); tr...
asked by 24.07.2014 / 01:43
1
answer

ShellExecute using CMD to open mysql

Gentlemen, I would like to ask you if you have the command cmd to run mysql.exe on it, let me use a line of code: ShellExecute(Handle,'open',PChar('cmd.exe'),PWideChar('/k cd\mysql\bin & mysql.exe --host 192.168.0.50 --user root --d...
asked by 22.05.2014 / 18:38
2
answers

SELECT with PDO and variable

How can I do a SELECT in MYSQL with PDO next to it below: $buscarNoticiaTitulo = "noticias.titulo LIKE '%teste%'"; $sqlNoticias = $pdo->prepare('SELECT * FROM noticias WHERE :buscarNoticiaTitulo'); $sqlNoticias->execute(array("buscarNoti...
asked by 25.02.2016 / 19:30
1
answer

Condition in MySQL in data query

Is there any way to do a condition to show data only if the status is as aprovado in the database? MySQL: Nome ProdValor Data Status Goku 250,00 15/04/2015 Aprovado Goku 250,00 15/04/2015 Pendente...
asked by 16.04.2015 / 03:31
1
answer

PHP OO Class Problems

Good Night, I am trying to implement a method that registers the user comment in the database in the comment table that has the foreign key user_id. How do I get access to this userid? I tried through my getIdUsuario method of the User class, bu...
asked by 31.03.2015 / 05:06
4
answers

How to bring a specific result from one SQL query above the others?

I have the following SQL query: SELECT DISTINCT 'user_id' AS 'id', 'user_name' AS 'name' FROM 'users' ORDER BY 'id' ASC; That generates output: +----+--------+ | id | name | +----+--------+ | 1 | Calebe | | 2 | João | | 3 | Lucas...
asked by 03.02.2014 / 00:24
2
answers

Phone book with database

I have a phone book with the form already ready and now I need that when the user type in the field to search for a name or sector, this value must be compared with values of the database and a value corresponding to the search of it is returned...
asked by 18.11.2014 / 15:09