Questions tagged as 'sql-insert'

Tagged questions
1
answer

Problems using INSERT in PHP (mysqli)

I (beginner in the php development area) I'm having trouble inserting data using the code below: <?php $conn = new mysqli("zz", "zz", "zz", "zz"); // Alterei a string de conexão por questão de segurança if ($conn->connect_error) {...
asked by 04.10.2018 / 15:48
2
answers

PHP form does not record

I have this Form html: <form id="addRunner" name="addRunner" action="service.php" method="POST"> First Name: <input type="text" name="txtFirstName" id="txtFirstName" value="" placeholder="Firt Name"><br> Last Name: <input...
asked by 29.09.2018 / 20:51
2
answers

Problem inserting data into a table containing foreign keys

Hello, everyone! Well ... My problem is this: I have a MySQL database that has 3 tables (Client, Event, Equipment). The event table has two foreign keys, the first one referencing the id of the Customer table (customer_id) and the second re...
asked by 30.07.2018 / 03:46
1
answer

Error Code: 1136. Column count does not match value count at row 1

I am trying to insert data into a table, but I am not getting it, giving this error: "Error Code: 1136. Column count does not match value count at row 1.", does anyone know how to solve? > I've created the following table: create table pesso...
asked by 24.04.2018 / 21:14
2
answers

How to insert value in mysql with PHP and Ajax

I have the following recipe page, which lists the ingredients: <?php $db->setQuery("Select * from #__ingredientes"); $tmpingredientes = $db->loadObjectList(); ?> And then I show you the list of ingredients. I wanted to put an...
asked by 23.10.2017 / 21:11
1
answer

Error inserting data into MySQL table

I'm trying to send data to MySQL from a restaurant reservation, but it only worked the first time and now when I try to send it will not go any further. What is the possible error in my script? Connection File with MySQL : <...
asked by 27.03.2017 / 20:19
2
answers

Column count does not match the count of values in row 1

I need guidance on how to identify the error in this message after importing a text file:    1136 - Column count does not match the count of values in row 1 The columns of the table are 10 and the data entered is also 10. SEE: INSERT IN...
asked by 05.04.2017 / 13:44
3
answers

Insert decimal variable in firebird

I'm doing an Insert in the Firebird database in a UnitUnit (decimal) field, but the decimal places in the table do not appear. C # code: public decimal ValorUnitario { get; set; } produto.ValorUnitario = Convert.ToDecimal(5.50); string sql...
asked by 04.01.2017 / 20:56
2
answers

INSERT Sometimes I did not insert all the data [closed]

I have a problem, $alta = $_GET['alt-a']; $altb = $_GET['alt-b']; $altc = $_GET['alt-c']; $altd = $_GET['alt-d']; $correta = $_GET['correta']; $img = $_SESSION['imagem']; $questao = $_SESSION['questao']; $inserta = mysqli_quer...
asked by 30.06.2016 / 22:30
1
answer

Is it possible to reuse this complex function for multiple entries at the same time?

In the site that I assumed from a previous developer, one registers investors one by one after a system search called CM. The function is called cadastraInvestidor: function cadastraInvestidor(codigoCM){ // TODO 2/4/2015 - Cadastro de investid...
asked by 07.10.2015 / 16:06