Questions tagged as 'mysql'

Tagged questions
0
answers

Validate duplicate records when uploading CSV

What I need is to be able to upload a .CSV file, and if in the bd there is already a record with a duplicate RETURN and PROCESS number, I skipped a script saying that there is already a record with that number of the form and process . So far th...
asked by 10.07.2017 / 14:24
0
answers

Notice: Undefined variable: tmp_name in C:

Good morning Friends StackOverflow I have the following error when saving a form with an image, the error I receive:    \ xampp \ htdocs \ stock \ ajax \ new_categoria.php on line 20   The catalog has been successfully entered. I...
asked by 26.07.2017 / 15:47
1
answer

how to send the fk to another table?

I want to know how I can do to send the fk to another table at the same time that I register, I have 10 tables and the tables have pk which I want to send to another table I make the registration of the 10 tables at the same time f...
asked by 11.07.2017 / 22:00
0
answers

inner join at login is possible?

I want to do a inner join at the moment of starting so that everything is saved in a single variable and so I can use it in many parts that are required How can I generate it? my Query of MySQL is like this $state...
asked by 12.07.2017 / 00:14
2
answers

sql syntax error in mysql database with python 3

In my mysql project with python, when trying to modify a field of the table, the sequence sql generates error and I do not understand why. I accept the name change but when I enter the new price the error arises. The Cod element is the pr...
asked by 05.07.2017 / 17:48
0
answers

Unable to create class instance: Java ServerFace

I can not eject project tells me You can not create the class instance: my managed bean is the next one <managed-bean> <managed-bean-name>man_articulos</managed-bean-name> <managed-bean-class>control...
asked by 05.07.2017 / 02:50
1
answer

Overlap entry and exit records

I need to overlap records in the same query of a table. The records in the table are as follows: |---|--------|----------------|------------|-----------------|----------------|-----------------|----------------| |Id | Nombre | E-mail...
asked by 11.07.2017 / 16:51
1
answer

Show stored procedure values as json

Hi, I have the following problem, I am creating two functions to show queries in json format. This is my code: <?php include'db.php'; class Descuento extends Database{ public function listar_producto(){ $sql = "CALL sp_mostrar_p...
asked by 06.07.2017 / 04:07
1
answer

Call the value of a variable from one file to another

My situation is that I have two PHP files in which: Archivo1.php (form) Archivo2.php generates a consecutive code. How can I get my generated code in archivo2.php and send it or request it to my archivo1.php...
asked by 28.06.2017 / 21:50
1
answer

schedule weekly mysql and php inserts

I am using php with pdo and mysql in my project I need to create schedules, breaks and the positions in which they have to be weekly, I must create 2 weeks ahead of the current week, but there are some rules: they must be ordered first by order...
asked by 28.07.2017 / 04:05