Questions tagged as 'mysql'

Tagged questions
1
answer

Insert data from an array to mysql with php

I have two tables related to the principal and the detail. I have to register for example: Tabla 1 Idpersona persona 01 Juan Tabla 2 ID idpersona pedido 1 01 zcahs 2 01 bitcoin 3 01 Eterium To insert...
asked by 25.02.2018 / 13:33
1
answer

Do not insert all my records (type Time) in PHP AND MYSQL

I make a form which is a schedule for workers, which contains shifts, time of entry, time of departure and day for the assignment. The problem I have is that I insert the shift and the day in my BD but the time of entry and exit in my BD...
asked by 23.02.2018 / 04:51
1
answer

How can you get the number of matches in a mysql query with left join?

I have in a database a table where the logins of each user are registered, and another where I store the modifications that the same user makes in the system. If the user does not make any changes to the system, nothing will be saved in the tab...
asked by 23.02.2018 / 18:45
1
answer

How to have a mysql container that updates my db in Docker Hub?

I am new with docker, I need to have a container that is running a mysql server, and that when I modify the data of the db, do a commit and push to docker hub, my partner downloads it and has the same data as me .     
asked by 23.02.2018 / 16:07
3
answers

Error: SQLSTATE [28000] [1045] Access denied for user 'digital_chuser' @ 'localhost' (using password: YES)

I have the following problem, I am trying to connect to the database with pdo in HostGator but I receive the following error:    Error: SQLSTATE [28000] [1045] Access denied for user   'digital_chuser' @ 'localhost' (using password: YES)...
asked by 08.03.2018 / 17:41
1
answer

Apply an update statement, when uploading file to mysql table

The following script takes a file and places it in a table, what I'm trying to add is an update statement of one of the added fields, where if the amount that (decimal mysql field (8,2)) is less than 0 , place in field num_boletos of that row in...
asked by 08.03.2018 / 20:05
2
answers

Error uploading images in Laravel

I am doing a blog in Laravel, the posts have images and when creating a post an image is uploaded. If the post is created the image is uploaded perfectly but when the post is edited and another image is uploaded it does not go up and also the ad...
asked by 15.02.2018 / 23:53
2
answers

Export DATA from PhpMyAdmin NO structure

again with a query. This time my question is How to export the DATA from PhpMyAdmin I do not need to back up its structure, ie the tables and columns only, also the data, of course, if this is possible . If it is not, it may be possible to s...
asked by 27.02.2018 / 15:20
1
answer

Show mysql data in a table with php

I have an input where I put a query and it returns the data of the query, but I want the data that I returned to be in a table so that they can be visualized better. Nowadays I get something like this: first name first name last name first na...
asked by 17.02.2018 / 12:12
2
answers

Insert a record in two related tables

I'm doing a project where I want to insert a record into two tables, where the user table has a primary key , and I have a client table > where there is a foreign key related to the primary key of the first one. What I have tried to...
asked by 13.02.2018 / 20:41