Questions tagged as 'mysql'

Tagged questions
0
answers

Error: Crystal Reports - "errorKind"

I have a report made in Crystal Reports. The report works well, but this error appears when generating the report: According to the error message, an error is shown in the formula that I give below: if {registros1.subcartera}= 'CARTA...
asked by 23.02.2017 / 15:33
1
answer

MySQL query - [id's] separated by comma

I have two tables: table A has certain fields, including its primary key Id ; in the development they have table B with a field with which table A is related (conceptually, since there is no relationship created in the database). In cer...
asked by 22.02.2017 / 13:53
1
answer

Php and Mysqli encrypted keys

Good, what happens is that I'm super lost with this encrypted keys in php ..... I have a code that already keeps me in the database the keys (already encrypted) my problem now is how to verify them , I have the following code, I guess it will be...
asked by 02.03.2017 / 02:31
1
answer

Environment for manipulating MySQL data [closed]

Dear. I need to provide an end user, who does not know SQL syntax, a simple way to update and filter data from a MySQL database. Do you know any tool that facilitates this? Or something that can be integrated with the base to make simple queries...
asked by 20.02.2017 / 22:54
1
answer

MYSQL error SQLSTATE [HY000] [2003] when connecting to a remote database

I would like for you to please help me with this problem. I have two virtual machines in virtualbox the first on the web server (192.168.0.20 centos 6.8) and the second is the database server (192.168.0.50 centos 7) I have created a laravel a...
asked by 11.02.2017 / 18:36
2
answers

Pass a variable instead of a where & variable name

My query is the next. you can put a variable within a query variable $ size is the one I want to put inside my query inside the while $ok = "false"; $codigo = $datos[0]; $talla = $datos[1]; $existencia = $datos[2]; $sql = "SE...
asked by 17.02.2017 / 20:37
1
answer

create restrictions on one based on a date (mysql) [closed]

I would like someone to help me, I have three tables called "users", another called "activities" and the last one called control_activities, activities and users have a PK id, and in control activities what I intend is control which users are ta...
asked by 18.02.2017 / 18:32
0
answers

Save files to database with php

I have been investigating how to save files in a mysql database with php and I have not found anything, I have only seen that they save the files in a server and an id in the DB and they relate them, but they do not keep as such the Is it possib...
asked by 10.02.2017 / 19:24
4
answers

Help with Queries Count via mysql and php

I have 2 tables: assists Columns: (id, student_id, area, bimester, state, management, month, day) students Columns: (id, apaterno, amaterno, names, level, course, parallel, management) Support is recorded in the status colu...
asked by 16.02.2017 / 06:31
1
answer

Identify users and show their profiles

I am creating a user system that shows the profile of each one, I only show mine and the main objective is to see the other profiles of all registered users, something similar to facebook, try to do it with sessions and according to the id of th...
asked by 01.02.2017 / 16:58