Questions tagged as 'mysql'

Tagged questions
1
answer

How to send formatting from CKEditor to DB?

My question is as follows, I configured CKEditor inside a textarea , where everything I type sends to banco de dados which at the same time feeds another page, working in sistema de noticias style. But in the page t...
asked by 19.06.2014 / 01:50
1
answer

Access to MySql database via connector / net

I'm developing a system that will access the MySql database just to query data. I made reference to mysql.data.dll and am using access through MySqlConnection. It turns out that the system is returning the following error:    Access...
asked by 18.06.2014 / 15:54
1
answer

Read contents of a netflow package

I'm developing a tool that captures every UDP packet passing through my firewall (an OpenBSD 5.4, simulated by a virtual machine), but I'm having trouble extracting the information I need from these packages. My code is basically: try { Dat...
asked by 22.08.2014 / 07:57
2
answers

Foreach - check and save only those that are not in the DB

Within a foreach I need to make an insert in my database only of records that are not written, thus avoiding duplicate records, but I could not imagine a solution to check if a record is stored in the database and if it is ignored and check the...
asked by 25.08.2014 / 14:18
1
answer

Codeigniter - Installation script

I created an installer for my system it installs normal, but before the installation finishes the error occurs Error Number: 1046 No database selected CREATE TABLE IF NOT EXISTS 'auditoria' ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'usuario'...
asked by 31.07.2014 / 00:13
3
answers

How do I create a view in mysql by taking data from 4 or more different tables?

HowcanIcreateaviewanddisplaythedataasfollows:     
asked by 21.06.2014 / 22:26
1
answer

How to get an output parameter from MySql via C #

I researched and applied what I saw, but it is giving error: MySqlConnection con = new MySqlConnection(banco.Conexao); MySqlCommand comando = new MySqlCommand("sp_venda", con); comando.CommandType = System.Data.CommandType.StoredProcedure; co...
asked by 26.03.2014 / 16:44
1
answer

How to write what is received in an Apache port right in mySQL?

Hello. I have a server Apache (XAMPP) and I need to receive messages from a device that sends messages to a specific IP and port. I would like to set Apache to listen for a port (443, for example) and to record everything that it r...
asked by 23.04.2014 / 15:59
1
answer

Count grouping per week

I have a table in MySQL and am trying to group it by week (may be week of the year) Select count(id),month(data_tarefa), year(data_tarefa) from tarefas group by mes, ano So it works cool, but I would need to group by week, I researched and...
asked by 17.02.2014 / 16:49
3
answers

How to select separate records on multiple pages of a pagination in PHP?

How do I select all the records in a page? Similar to what gmail does where ever, by checking the checkbox that only selects that of the current page, a text appears just above to select all other records that are separated into multiple...
asked by 13.02.2014 / 02:04