Questions tagged as 'mysql'

Tagged questions
1
answer

Compare fields between two tables in PHP x MySQL

Good morning, I'm in need of some help with some tables in php. I have two tables from which I need to compare data, the tables are in a database in MySQL. The scenario is as follows: I have table1 with columns A, B, C, D and table2 with columns...
asked by 27.01.2018 / 13:18
0
answers

MySql Bank does not connect with Entity Framework

I'm trying to connect a MySql database with C # through the Entity Framework, but every time I click on the next button it does not work (with Sql Server going the problem is with MySql)     
asked by 29.01.2018 / 06:39
1
answer

Record editing form does not change

On one page I have a material registration form, in another I have a table that shows all the materials registered with a button to change the information about a material and this button opens a third page with the same form of the first one on...
asked by 30.01.2018 / 14:00
1
answer

PHP / Mysqli (phpmyadmin) I try to insert into the database, but there is no error

Good luck, I need help with the following: I want to insert 3 simple information into the database, product name, price and image. Out of the form I opened a tag to show the output, but only shows the name! and in the database do not appear new...
asked by 30.01.2018 / 09:57
1
answer

warning: initialization makes integer from pointer without cast [-Wint-conversion]

I have the following code in C that makes a connection to a mysql database and performs a query: #include <mysql.h> #include <stdio.h> int main(void){ MYSQL Connection; MYSQL_RES *res; MYSQL_ROW row; mysql_init(&...
asked by 02.03.2018 / 01:58
1
answer

Load the data into the table of a div inside a form

I have this form: <form name="form4" method="POST" onsubmit="return form_validation()" > <h1><center><strong>Saída de Luvas</strong></center></h1></br> <p><h5><s...
asked by 03.01.2018 / 10:19
1
answer

Use TIMESTAMPDIFF in table creation

I'm adding mysql support for my program, currently it only works with sql server, so I came across a problem with mysql. Table sql server: CREATE TABLE [dbo].[login_user]( [idx] [int] IDENTITY(1,1) NOT NULL, [client_id] [int] NOT NU...
asked by 28.12.2017 / 16:03
0
answers

Make mysql query with INNER JOIN between different mysql servers

How could I query with INNER JOIN between different servers, as exemplified below: SELECT serverA.clinte AS CLIENTE, serverB.enderecoCliente AS ENDERECO FROM 127.0.0.1.dbo.cliente AS serverA INNER JOIN 192.168.0.1.dbo....
asked by 06.02.2018 / 12:04
0
answers

Mysql Codeigniter Parcel System

I need a system that registers several parcels of title in my DB Mysql I have this code below that registers and repeats the insert according to qtde of parcels informed, however happens that when choosing the date with day 30, arrives in Februa...
asked by 25.12.2017 / 07:42
1
answer

Get an HTML data for a SELECT in another file without POST

Good morning, I'm starting my PHP programming life and I have a problem here. I have the following form: <form action="cadastro_pex.php" method="post"> <label>Período: <select name="periodo" id="periodo" style="text-transform:...
asked by 26.01.2018 / 15:06