Questions tagged as 'mysql'

1
answer

OG Dynamic Tags MySQL and PHP

I need help with the following problem since I have not been able to find the solution (I think it could be very simple) I have a web page in which I want to use OG Tags in a dynamic way (fill them depending on the information in the database)....
asked by 03.05.2017 / 17:22
1
answer

Import BD MYSQL relationships

I have a question, make some internal relations, by a BD designer this is the result: However, make an export of the BD and install it on another Computer, and although the data DB is fine, there are no relationships ... to what is due? an...
asked by 12.05.2017 / 13:25
1
answer

How can I upload multiple images with php and mysql?

What I want to do is upload a product (that works for me) and the images of that product in another table in this case, and then save the id of the product and the image and store them in the table productos_galeria. My tables are: product...
asked by 27.04.2017 / 15:53
0
answers

Problem entering phpMyAdmin

I have a problem to enter the control panel of phpMyAdmin, everything happened because I'm doing an application for Android in visual studio using xamarin, in which he asks for my username and password, after being investigated why he could not...
asked by 10.05.2017 / 05:40
2
answers

query on my mysql

hi friends could help me complete a query I have these records, from which I have to obtain day 1 the start date and the end date the day two start date and end date and so with the others, is what I get this way: (SELECT date_game_large...
asked by 09.05.2017 / 22:23
0
answers

Web system security issues

Greetings, I explain my case: Currently, in my system, in order to work, users log in and they see the corresponding options according to their user profile, the problem is that I only validate if the user has logged in, but not valid if the...
asked by 24.04.2017 / 21:59
0
answers

Encrypt data from query in PHP

In the following code I insert the data and it is not being encrypted $sentencia = $conn->prepare("insert into usuarios values(null,?,?,?,?,?,?,?,PASSWORD(?),?)"); $sentencia->bindParam(1,$dni); $sentencia->bindParam(2,$nombre...
asked by 03.05.2017 / 15:57
2
answers

error when doing procedure with cursor

I try to do this CREATE PROCEDURE temporal( IN temp INT) BEGIN DECLARE maxima INT SELECT MAX(ventas) FROM vendedor INTO maxima; CREATE TABLE ven_temp AS SELECT id_vendedor FROM vendedor; WHERE ventas=maxima; COMMIT; END; mark me:...
asked by 21.04.2017 / 07:19
0
answers

problem create user in mysql database

Well I get this box when I try to add a new user is in the phpmyadmin of XAMPP (it's the first time I have this problem)     
asked by 21.04.2017 / 01:55
0
answers

MySQL Installation

At the time of downloading and installing MySQL I had everything ready but in the requirements I said that I needed to have Python 3.4 and Visual Studio, so what I did was download the latest version of Python and even so I kept saying tha...
asked by 14.04.2017 / 03:48