Questions tagged as 'mysql'

Tagged questions
1
answer

Show mysql table in php, javascrip

I have the following database, if it is necessary to use javascrip it does not matter, but it is important to say that I use ajax and json. But I can only show the last record since I'm using ajax and json this is my code in...
asked by 10.08.2018 / 01:47
1
answer

Error in mysqli prepared query in PHP

Good day to the community. I have the following function: function insertar_producto_carrito($id_producto,$cantidad,$conexion){ try{ $sentencia = $conexion->prepare("insert into carrito(id_producto,cantidad)values(?,?)");...
asked by 10.08.2018 / 22:27
2
answers

Get milliseconds of a given date in MySQL

Is there a MySQL function that gives me the milliseconds of a date or how should I do one? I've been looking for some time if I had a function like JavaScript that is getTime () that returns the number of milliseconds since 1970/01/01 but I thin...
asked by 06.04.2018 / 00:54
1
answer

Join Query in one with JOIN [closed]

I'm trying to merge several SQL statements into one, the problem is that it has a JOIN and I do not know how to rename tables SELECT users.nombre,users.apellido,users.id, COUNT(ligauruguaya_v.primero) AS Primero FROM users LEFT JOIN ligaur...
asked by 24.03.2018 / 18:08
2
answers

Perform UPDATE to a column

My FORM <form action="submits/submit_ocupacion.php" method="POST"> <input class="form-control" type="text" id="user_user"> <input class="form-control" type="text" id="user_ocupacion"> <button type="submit" name="ocup...
asked by 27.03.2018 / 09:57
1
answer

VB.NET-MYSQL, ERROR the connection is already open

Hello good afternoon everyone, I turn to you for help, guidance ... I have a function that is responsible for finding a data in the Database in MySQL , if you find that data, I load the values in controls of the form (txtbox, lables, etc...
asked by 25.04.2018 / 18:45
1
answer

as valid that there are no duplicate records?

I need to avoid the duplication of records in my database, specifically in my table usuario taking into account the field id_Funcionario belonging to the table. This is the form: registro.php <!DOCTYPE html> <html&...
asked by 22.03.2018 / 16:34
1
answer

[HY093]: Invalid parameter number: parameter was not defined [closed]

In my opinion everything goes Ok, but when it makes the sentence it gives me the following error:    Fatal error: Uncaught exception 'PDOException' with message   'SQLSTATE [HY093]: Invalid parameter number: parameter was not defined'   in   ...
asked by 23.03.2018 / 13:12
1
answer

Load text file to mysql, using sql script

I'm trying to load a text file with the following format, to mysql: Clave Area¶Area de Venta¶F. Contable¶Sesión¶Fecha de Apertura¶Hora de Apertura¶AV/P¶Transacción¶Operación¶ID DE VTA¶Tipo¶Origen¶Destino¶Fecha Salida¶Hora Salida¶Folio Boleto¶A...
asked by 01.03.2018 / 21:35
1
answer

Error Object of class mysqli_result could not be converted to string when trying to display a value of a query in a php table

I am developing an inventory system where I have to show in a table the products with their respective stock and at the end the total stock of the whole warehouse. I have the following code to show that total $suma = mysqli_query($mysqli, "...
asked by 16.02.2018 / 21:26