Questions tagged as 'mysql'

Tagged questions
0
answers

"Intercept" incoming SMS from Android Studio app, Android 6.0 [closed]

I would like to know how I can intercept an SMS in Android 6.0 from my app, since it is a tracker service and receives the maps link from an SMS that we previously sent "Where" to the tracker and he responds, I am interested in giving it to the...
asked by 30.05.2017 / 15:19
1
answer

MySQL Query with a while and another query inside

I raise here a question that I have consulted in other places and nobody has been able to answer me. I'm a newbie in PHP and MySQL, and I'm doing my first steps. I just found a fairly frequent case, which is a query that leads to a while, within...
asked by 15.06.2017 / 15:11
1
answer

How to use trigger in mysql so that when you delete a record change the value of a column of the other records?

Well, what I'm trying to do is a query so that when a record is deleted from the "class" table, the value of the "counter" column of the other records is subtracted 1 as long as the id of the records is greater than the id of the record that I d...
asked by 04.04.2018 / 19:54
1
answer

Insert data from a table into another SQL

I have a MySQL database for a car dealership. There are 3 types of users: A, C and P. What I am trying to do is that when a new data is inserted in the table users with type "P", it is also inserted in the suppliers table. That is, when I add...
asked by 26.04.2018 / 15:41
2
answers

Log in on node.js

I am new programming in node.js and I wanted to ask you a question: I have the following log in (which works without problem) but I'm not sure if it is the most recommendable way of doing things since I do not know if you are doing it I work in...
asked by 02.01.2017 / 17:30
2
answers

Invalid parameter number: no parameters were bound when doing an INSERT in MySQL

I have encountered this problem when doing an INSERT in MySQL. I receive the data from a form that the user completes (it is a textarea to leave comments in the news). In this form I have several buttons enabled to post videos or tweets, and it...
asked by 10.10.2018 / 22:34
1
answer

Help with a JOINS in 2 tables in MySQLi in PHP

I commented to them I have read several times the blog of link but I can not implement a JOINS in my project, what I have so far works perfectly but I'm doing 2 or 3 queries and the idea is to optimize the queries to my database for logical...
asked by 12.10.2018 / 18:24
3
answers

How to display an image stored in BLOB format in a MySQL database in PHP

I have an image field that is a BLOB type in my MySQL database, I collect the data by PDO, but at the time of viewing it, it does not show me anything, I searched the Internet and everywhere I put the same thing with src="data:image/jpeg;base...
asked by 20.02.2017 / 12:06
2
answers

MySQL SUM () grouping by the same ID in different columns

This is the problem to solve: I have a table, in which 1 to 5 different products are registered, but there is no order control when registering the products, in one record a product can be in the product_1 field and in another record it can b...
asked by 03.03.2017 / 01:45
3
answers

get latest registration in MySQL

I have a database in MySQL and each table has its primary key that was inserted using the following structure: "INSERT INTO TABLA VALUES (UUID(),CAMPO1,CAMPO2)" , until then everything is perfect. My question is this, how can I get the...
asked by 13.11.2018 / 15:39