Questions tagged as 'sql-insert'

Tagged questions
1
answer

Save an ArrayList to an SQLITE table

If yes, how? This is my table: db.execSQL("create table amc (_id integer primary key autoincrement,tipo text not null, resultado float not null,data date not null, id_usuario integer not null, FOREIGN KEY (id_usuario) REFERENCES usua...
asked by 06.07.2017 / 20:13
1
answer

What to do when this happens?

I'm working on a system in which I must register various data from a form in different tables using mysql. It works like this: The person does a registration and in the same form requests a special attention, I save his data normally and with hi...
asked by 24.05.2017 / 21:06
1
answer

How to Define Variable PHP 7 for POST? [closed]

I am trying to write information from a form on a base, however when I generate the following code below an error is presented in the file saying: Notice: Undefined index: txtFirstName in C:\xampp\htdocs\begin\service.php on line 64 Notice: Un...
asked by 25.09.2018 / 23:19
1
answer

INSERT in mysql in another domain [closed]

Make an INSERT in mysql in another domain. For example: on my site has the site administrator, and there I can register my products, when registering, will register on my website and on another site outside my domain. Can you do this?     
asked by 03.10.2014 / 13:24
1
answer

importing Xml data to Mysql database - only writes the LAST record

In this code all the XML records are read, but in the Mysql database only the last XML record block is written. I know that reading each record over-writes the previous one but the strange thing is that I gave an ECHO and checked that the foreac...
asked by 08.08.2018 / 17:19
2
answers

Insert row in MYSQL without leaving the page (using PHP)

I have a system of downloading songs with a download button and I would like that when I click the button, it inserts a line in the database without leaving the page. Now what I did is open a new page that does the insert: For each song ha...
asked by 04.06.2018 / 16:23
2
answers

How to merge edit / new button?

I would like that, if already there is $nome registered in the table, it gives an update and if it does not exist, it gives an insert. I do not understand what the problem is in my code. $dbconn = mysqli_connect($servername, $username,...
asked by 01.07.2017 / 13:24
1
answer

My code does not error, but does not compile either. Nothing happens: / [closed]

I do not know what happens in the code. It does not error, but also does not insert and does not go to the Login screen and also does not enter the else "error"     
asked by 21.05.2018 / 04:31
1
answer

Insert problem: String sql is correct, but not inserted by Java, only manually by Mysql! Procedures datetime attributes

Good evening everyone! I'm using java and Mysql. At the moment I'm using Procedure for insertion everything happens in a perfect way the String goes to the bank with all the correct parameters, but something happens that it hits the bank, burns...
asked by 30.11.2018 / 03:52
1
answer

INSERT and INNER JOIN together in MySQL?

Hello, is it possible to use INNER JOIN together with INSERT ? I have a table A with 3 columns X, Y and Z and table B with columns W, X and Y and I need to insert table W in table A, column W? I'm trying this way but I get no res...
asked by 22.03.2018 / 18:21