Questions tagged as 'mysql'

Tagged questions
2
answers

Work with three arrays and insert with PHP in MySQL database

I have the following code: foreach ( $_POST["num_cod"] as $num_cod) { echo $num_cod; } foreach ( $_POST["fec_cod"] as $fec_cod ) { echo $fec_cod; } foreach ( $_POST["nro_oper"] as $nro_oper ) { echo $nro_oper; } Wher...
asked by 20.09.2018 / 14:50
2
answers

Query with MySQL Options

I am working in a search engine where I can have two search options. The question is in how I do to make the query according to the values that the selection has. <select> <option>Selecciona una Opcion</option> <op...
asked by 11.10.2018 / 19:32
1
answer

Add results of a SUM in SQL Server

I need to add a series of elements that are in fact the result of a sum, I will try to explain myself as best as possible. I have the following query: select distinct cp.descripcion, cp.idSysCPPuestos, em.nombreLargo ,sum(CAST(em.sueldoDi...
asked by 23.10.2018 / 21:28
1
answer

Show phpmyadmin variable in PHP

I want that when editing the variable from the phpmyadmin change here. I hope to explain, because I do not know how to explain it. echo '$' . $rows_dbpartidos['color_local'] . ''; and it shows a code that I already have organized, for exam...
asked by 21.08.2018 / 22:44
2
answers

Transform boolean from sql to boolean java?

I'm in a problem, I have a SELECT that asks for ususario (int) , contraseña (String) and tipo (boolean) of a database, I keep them in a Object [][] , all right there, but when I want to save those 3 values in oth...
asked by 25.10.2018 / 04:59
1
answer

Problem with MySQL and Visual Studio [error when adding to table] specifically ExecuteNonQuery ();

The error appears on line 43 when trying to insert data. Specifically where it says int filasafectadas = cmd.ExecuteNonQuery(); Here I leave all the code.    MySql.Data.MySqlClient.MySqlException: 'Column count does not match   value c...
asked by 05.10.2018 / 01:33
3
answers

Obtain a set of data for each user

Hello friends I need help on how to get the 3 biggest results of the column 'result' of each user with their corresponding data that is shown in the table, please friends I tried to perform the following shown below and if it brings me all data...
asked by 05.08.2018 / 16:42
1
answer

How to filter explicit images when the user uploads their profile picture in php?

Well here with another doubt. We know that any person, out of simple curiosity or annoyance, when uploading their profile picture on a web page, could happen to upload images to the server with explicit content. This is where I wonder how...
asked by 03.08.2018 / 00:23
1
answer

Query Mysql Product Category Subcategory

I have this relationship: And I would like to make the appropriate consultation that the Products that belong only to a Subcategory, of a specific category, would throw at me. If you could help me, I'd appreciate it, I'm going around...
asked by 27.10.2018 / 00:34
2
answers

Get the results inserted

I have a stored procedure that stores data in the db, and I want to know if there is any function to get that record that is saved in the database. $sql = "CALL registrar(?,?,?,?,?,?,?)"; $stm = $this->db->prepare($sql); $stm->bindPar...
asked by 01.08.2018 / 16:09