Questions tagged as 'mysql'

Tagged questions
1
answer

More than one cursor in procedure Mysql

Do I need to execute more than one cursor in the same procedure? Is this possible? begin DECLARE done INT DEFAULT 0; declare v_dia, v_rotina int; declare v_hora time; declare v_saldo, v_valor decimal(5,2); declare v_flag tinyint; declare v_id...
asked by 04.12.2017 / 13:36
3
answers

Doubt with inner join sql in multiple tables

I have three tables. Usuários , Anúncios and Fotos . The query I'm doing is to get the id of the ad, the Título , Quantidade views, and the first photo of this ad from the photo table. Since a single...
asked by 04.12.2017 / 13:59
1
answer

PHP collecting data and inserting mySQL data

I am trying to collect data from the last section inserted via PHP in MySQL, which shows the last (id, Nome, Idade) on the screen. of% inserted%. page after inclusion should appear that fields below the page select <!DOCTYPE html&...
asked by 04.12.2017 / 17:33
1
answer

PHP in conjunction with Mysql in user registry

I am doing a user registration system and it has been presenting some errors if anyone can help me with them would be very grateful. <?php include("conexao.php"); $Email = $_POST['Email']; $sql_code ="SELECT * FROM usuario WHERE Email...
asked by 02.12.2017 / 17:52
1
answer

Convert data structure in JSON to Object

I'm using the framework Materializecss - autocomplete , and would like to feed an autocomplete field with data coming from my database. Autocomplete works with data in the following object structure: { "Apple": null, "Microsoft": null,...
asked by 01.12.2017 / 14:14
2
answers

Give Name as number in Array foreach

I have this foreach below that lists results of a Select, I would like to name it according to the number, as I did below in the IF, but it still did not work .. foreach($result as $row) { $segurado[] = $row['SEGURADO']...
asked by 01.12.2017 / 20:03
1
answer

Error in selection query on social network requests [closed]

Hello, in my project I need to list the people and the requests received by the user, but when it comes to listing people, I need to list only those that have not sent or that the user has not sent requests, in this case, my friendship table save...
asked by 29.11.2017 / 16:17
1
answer

Error creating a table in mysql

CREATE TABLE EPI ( CODIGO__EPI INTEGER NOT NULL, USUARIO_CODIGO_USUARIO INTEGER NOT NULL, TIPO_EPI_CODIGO_TIPO_EPI INTEGER NOT NULL, EPC_EPI VARCHAR (255) NOT NULL, DATA_CADASTRO_EPI DATE NOT NULL, VALIDADE_EPI DATE NOT NULL,...
asked by 04.12.2017 / 20:31
3
answers

FullCalendar remember every month

I'm working with FullCalendar plugin with PHP and MySQL. I need to make a reminder remember every month, for example, remember every 5 days a payment. I already searched google and I did not find it.     
asked by 05.12.2017 / 11:31
0
answers

Email SMTP (port release)

I'm trying to send an email through phpmailer, but it always makes a mistake. There I went to look at a git examples, but neither are examples going. Do I need to release port 25 or 465 to get the SMTP email sent?     
asked by 30.11.2017 / 13:23