I have this database created in phpMyAdmin:
The problem I have is that when I insert the data of the form where I create a user manages to connect to the database, the data sends them but does not save them, concluding with the redirect...
I'm doing a facturer, and when it came to billing several products, it occurred to me to use checkboxs since I still have not gotten with JS , so is the code of the checkboxs :
<?php
require_once ("ModeloProductos.php");...
I have a database with 2 tables. A call sec_users with the following fields:
pk_user login pswd
Another table called solicitud with the following fields:
pk_solicitud fk_usuario fe...
I have this table in the database:
Tabla de Ejemplo:
id - registro - valor
1 - compras - 1,2,6
2 - ventas - 3,4
3 - deudas - 5
I want to make a query where I send only the number 3 and bring me the record 2 in this exampl...
I would like to know if there is an Insert Update instruction in MySQL, something that would know that if that record already exists in my table, update it and create a new one, and if so, how is it handled?
I have a function that concatenates a query from POST variables, this I do with a foreach:
$id = $_POST['empId'];
$query = "UPDATE userInfo SET ";
foreach ($_POST as $key => $value) {
$query .= "$key = '$value', ";
}
$query .= " WHERE i...
I have a question about saving an image in a database, in specific mysql, my question is what would occupy more space in the server, save the bytes of the image in a field of type bytes or save the image in a specific directory and then t...
Good morning, today I come with a small problem that is this
echo $consulta;
to which he replies with:
SELECT SUM(carrito_cant) as cantidad FROM carrito_tb WHERE carrito_folio='3041M�Ra' and carrito_NP='NA';
Devido to the character or...
I am concatenating two fields but it is showing me the end of one capo with the other. example: Pedro PabloCastro Ruíz
SELECT documento, concat(nombres, '', apellidos) as datos, nacimiento FROM jugador