Hello ,please help, i retrive data (id,username,name) from "users" table to my form, it works fine, but then i want to save the data (id,username,name) in another table but it doesnt work, the new table has the same colum name , here is the Debbuger:
Data Array
Errors
Debug Info
Data Array
Array ( [cont] => lists [ccname] => Busqueda_Pacientes [act] => view [gcb] => 163 [chronoform] => Baja_Inventario [event] => submit [option] => com_chronoconnectivity5 [Itemid] => [lang] => es [Consulta_Pacientes] => Array ( [id] => 163 [username] => hugo11 [name] => Hugo Esquer ) [Numero_Procedimiento] => 02 [ID_Codigo_barras] => 123456789 [Descripcion] => Paracetamol [Cantidad] => 1 [button6] => Guardar [language] => es-ES [idp] => 36 )
Array ( )
Errors
Array ( )
Debug Info
Array ( [1] => Array ( [DB Save] => Array ( [Queries] => Array ( [0] => INSERT INTO `k1nuf_chronoengine_chronoforms_datatable_Baja_Inventario` (`Numero_Procedimiento`, `ID_Codigo_barras`, `Descripcion`, `Cantidad`, `button6`, `user_id`, `uniq_id`, `created`) values ('02', '123456789', 'Paracetamol', '1', 'Guardar', '123', 'd28b7ba474be254ea0b907303e8011a29bb6e052', '2019-09-25 14:20:37'); ) ) ) )
Hi angelmorales,
The MySQL query looks OK - what exactly doesn't work?
Have you tried testing the query using PHPMyAdmin to see if you get a more helpful error message?
Bob
The MySQL query looks OK - what exactly doesn't work?
Have you tried testing the query using PHPMyAdmin to see if you get a more helpful error message?
Bob
The data in the following text boxes saves in the table without problems : (Nuevo_Procedimiento,ID_Codigo_barras,Descripcion)But (id,username,name) doesnt saves in the table (i TRY TO UPLOAD IMAGES, BUT AN ERROR HAPPENS: "ERROR SAVING THE ATTACHMENT FILE", i try with .jpg, .png, .pdf but it doesnt seems to work )
I retrive the id,username,name data from "users" table, using chronoconnectivity, and it work fine, the data shows on the form , next I capture data in the rest of the textboxes: (Nuevo_Procedimiento,ID_Codigo_barras,Descripcion), then I submit, but when i check the table in the data base only the data in the : (Nuevo_Procedimiento,ID_Codigo_barras,Descripcion) textboxes has been saved, (id,username,name) don't.
The field names of the textboxes are like this:
Consulta_Pacientes[id]
Consulta_Pacientes[username]
Consulta_Pacientes[name]
Numero_Procedimiento
ID_Codigo_barras
Descripcion
Cantidad
The column name's in the table are like this:
idp
uniq_id
user_id
created
modified
id
username
name
Numero_Procedimiento
ID_Codigo_barras
Descripcion
Cantidad
button6
Sorry but the "Upload file option" doesnt work, i try to attach images but i didnt work
Thanks for your help!
I retrive the id,username,name data from "users" table, using chronoconnectivity, and it work fine, the data shows on the form , next I capture data in the rest of the textboxes: (Nuevo_Procedimiento,ID_Codigo_barras,Descripcion), then I submit, but when i check the table in the data base only the data in the : (Nuevo_Procedimiento,ID_Codigo_barras,Descripcion) textboxes has been saved, (id,username,name) don't.
The field names of the textboxes are like this:
Consulta_Pacientes[id]
Consulta_Pacientes[username]
Consulta_Pacientes[name]
Numero_Procedimiento
ID_Codigo_barras
Descripcion
Cantidad
The column name's in the table are like this:
idp
uniq_id
user_id
created
modified
id
username
name
Numero_Procedimiento
ID_Codigo_barras
Descripcion
Cantidad
button6
Sorry but the "Upload file option" doesnt work, i try to attach images but i didnt work
Thanks for your help!
This topic is locked and no more replies can be posted.