Questions tagged as 'mysql'

Tagged questions
3
answers

Problem when inserting into the database [closed]

I have tried to store values in my database and I have run into a problem constantly since I can not insert one of the values and I do not understand why, the attribute is well defined in both html and php, but still I do not give with the error...
asked by 19.11.2016 / 15:11
0
answers

What SDK (Digital Persona) is the one I use for windows or linux?

Good afternoon, In my work they ask us to develop a fingerprint capture module to record the entries and exits of employees. We chose to buy the Digital Persona U.are.U 4500 and we are ready to buy the SDK, the software of the company is made...
asked by 29.12.2018 / 00:20
0
answers

Why is not my PHP properly creating foreign keys in MySQL?

I'm creating a very simple database administrator with PHP but for some reason I can not get the foreign keys to work with "on delete cascade". To add a foreign key column I am first creating the new column and then making it a foreign key: al...
asked by 30.12.2018 / 17:51
1
answer

Error when consulting Remote Database PHP 7

I have a type 500 error when starting this code When consulting the database my server only has PHP7 available As I read it may be because my code only works with PHP5 The code should show a series of queries, names and numbers but only se...
asked by 16.02.2017 / 16:14
1
answer

Update a field of the same table with Subquery that creates ranking

Objective: Create a ranking day by day, which is the warehouse that sells the most, it will be number 1, and so on. The fields in the table are: Date, Store, Sales, Rank_Sales_By_Date I would like to know if it is possible with a single...
asked by 24.02.2017 / 04:53
1
answer

Error making UPDATE

<html> <head> <title>Actualizacion completada.</title> </head> <body> <?php $docu = $_POST['docu']; $apat = $_POST['apat']; $amat = $_POST['amat']; $nomb = $_POST['nomb']; $corr = $_POST['corr'];...
asked by 07.09.2017 / 02:47
0
answers

How can I update the mysql data from java (netbeans)?

You also have to update an image, this is my code: PreparedStatement pps = cn.prepareStatement("UPDATE socios SET (nombre, nosocio, foto, apellido) VALUES (?,?,?,?)"); pps.setString(1, nombre.getText()); pps.setString(2, nosocio.getText());...
asked by 21.12.2018 / 19:32
1
answer

Mysql change week number

could you help me please, I have these records that have the week number. semana 42 43 44 45 46 47 48 49 50 51 52 1 2 3 4 5 6 7 8 9 10 but I would like to change them like that; 42->1 43->2 44->3 ... ... ... 52->11 1->12 2-...
asked by 28.12.2017 / 23:07
1
answer

Query that inherits twice from a table

Select v.id_user, uv.nombre_nacion as PaisEnvia, up.nombre_nacion as PaisRecibe From solicituds as v INNER JOIN pais as uv on v.id_pais_envia = uv.id_nacion INNER JOIN pais as up on v.id_pais_recibe =up.id_nacion; It would be...
asked by 17.12.2018 / 14:27
1
answer

As a solution Catchable fatal error: Object of class mysqli_result could not be converted to string

I want to show the name of him I have this code: <?php session_start(); $_SESSION['name'] = $_POST['usuario']; $usuario = $_POST['usuario']; $pass = $_POST['contra']; if(empty($usuario) || empty($pass)){ echo"<script type=\"te...
asked by 22.06.2017 / 18:21