Questions tagged as 'mysql'

Tagged questions
0
answers

Saving Image in MySQL with Asp.Net MVC

I would like to know how to save an image in the MySQL database, the table is called db_usuarios with the following structure: ID int GrupoUsuario int Nome Varchar Apelido Varchar .... Foto Blob UserController Controller [HttpPost] [Val...
asked by 14.10.2018 / 06:02
1
answer

Generate batch accounts with corrupted date

Good evening everyone, I'm developing a project in which I generate batch accounts depending on the number of months that the user selects being a maximum of 12 months, ok the CRUD of these accounts, is already working perfectly, I created a for...
asked by 09.10.2018 / 02:46
1
answer

How to create a function for my IF with Class Public Function?

Well, I have the following public function : /** * Mostrar notícias * * @param string $featured - Define se será noticia de destaque ou padrão que mostrará * * @param string $date - Define o tempo em que mostrará as notícias recentes (ex...
asked by 08.10.2018 / 23:25
0
answers

send the array value to the mysql database

I would like to be able to send the array data in the convert.toCharArray parameter to the mysql database? My question is what value do I put in the INSERT line in the VALUES field? I can connect to the base but nothing appears in the table crea...
asked by 01.10.2018 / 15:15
1
answer

Use result of one SQL query as attribute to another query. (MYSQL)

I have the following structure: tabela (Grupo): -cd_grupo -nm_grupo -ds_filtros -> Aqui armazeno parte do comando SQL utilizado como filtro , para posteriormente atualizar. I have stored the following information. cd_grupo | nm_ gru...
asked by 30.09.2018 / 22:13
0
answers

How to link a question with a database response

I'm trying to create a question and answer system in PHP and MySQL. I already have the database created, I would like to know how to make the question linked to the response that the student made. And show in a loop all the answers answered b...
asked by 30.09.2018 / 03:15
0
answers

Returning data with SQL queries

Hello, I have a table called notebooks and news. I need to return 5 news from each notebook respecting the order of presentation: Model: //metodo retorna os dados do carderno public function get_caderno ($idcaderno = null) { $this->...
asked by 26.09.2018 / 17:41
1
answer

PHP sends partial data to mysql

Oops! I'm learning to use the html + php + mysql trio and the business is giving me a dance. when I finally understood the mistakes I was making, I went for the most real test, I made a very simple login, the strange one, just send the password...
asked by 26.09.2018 / 19:49
0
answers

How to put the photos items inside the XML using PHP and MYSQL

I am creating an XML generator that is working right, but I have reached the point where I have to insert the photos in xml and I do not know how to do it. The "photos" tag should look like this: <Fotos> <Foto> <URLArquivo...
asked by 26.09.2018 / 20:37
0
answers

Change mysql root password in linux! [duplicate]

Good afternoon, guys! I'm new to the development world and I'm new to linux. I installed mysql client and server and then installed mysql-workbanch via xubuntu's program center. At no time has he asked me to set the password and I can not c...
asked by 04.10.2018 / 23:04