Questions tagged as 'mysql'

Tagged questions
1
answer

Retrieve data from a table in a Database with incomplete conditions

In a table of a Database I have the following: id_video | nom_video ---------+----------------- 1 | Base de datos 2 | Programación With the following instruction I recover what is equal to "Database", but as I recover what c...
asked by 15.12.2018 / 08:16
1
answer

Problem query mysql

I have a problem with a query, I have never actually made this kind of query, I've tried but I still can not get what I want, so I explain what I want to do with the following table. I have this table, as you can see in user_ad the user...
asked by 16.12.2018 / 01:07
1
answer

avoid anchor tag behavior

Hello, I have a system that by clicking on a link, it verifies if the user is logged in and depending on this the link changes; it works well but if the user is not logged in yet he enters the section and then quickly redirects to the page I wan...
asked by 10.12.2018 / 05:15
1
answer

Read MySQL blob field and convert to JSON for android webservice

I am creating a webservice for Android, in which I have to read a blob field from a MySQL database. The problem is that I can not encode that field to JSON, which is the format I will need later to read the Android webservice. Let's see if an...
asked by 10.12.2018 / 17:42
1
answer

How to migrate a Mysql Database to Wordpress?

Very good colleagues, I want to turn to you to see if you can give me lights in this dark landscape for me. A Client has a website made in PHP, so that they have an idea, it deals with offers of temporary jobs. Therefore it has its Database,...
asked by 05.12.2018 / 16:23
4
answers

Do what I do in MySQL but in PDO with PHP

I'm trying to learn PDO , I'm handling PHP, but with mysql_query I wanted to migrate to PDO , but it gives an error, I tried inserting but it does not work now, I want to try doing a query but I do not know someone would know why he will n...
asked by 21.03.2017 / 22:59
1
answer

How to validate a datetime with date in a php and mysql query?

I want to validate the entries and exits of a number of people in the day, that is, count how many people have entered, how many have left. for this I have a field called fecha_entrada and fecha_salida (both fields are datetime), t...
asked by 17.12.2018 / 06:00
1
answer

Error in putting FK in table

I have a problem with my Database. I try to put an FK in my general table that is as PK in my table Rates, try the following way and I mark the following error.    Table where I have the PK    Table where I want the PK (I already ha...
asked by 26.11.2018 / 17:29
2
answers

How do I get a Select with PDO in Php correctly

I'm trying to get a select from a database. Index Code <?php @$mostrar=$_POST["mostrar"]; if($mostrar){ $form=1; $mMatricula=$_POST[...
asked by 24.11.2018 / 07:10
1
answer

Mysql criteria for the order of Rows

Good evening I hope you can guide me, I have two tables with the following information: (Client Table) clienteid nombre direccion telefono email --------- ------- --------- -------- -------- 001 gallo...
asked by 08.12.2018 / 01:20