Questions tagged as 'mysql'

Tagged questions
2
answers

Make Insert in a database with php

Good morning, I'm trying to add a statement to the database, I'm doing it from an insert. I have five variables, the id, the name, the description, the image and if I want to show the news or not. The connections to the database I have alread...
asked by 28.08.2017 / 09:20
2
answers

Preserve value in a select html + php

I am developing a simple form with html, php and MySQL, which has validations of mandatory fields, invalid characters, etc. html <?php include_once '../../includes/insert/insert_user.php'; ?> <h4 cla...
asked by 19.10.2018 / 19:33
3
answers

Error in consulting the database! from PHP to MYSQL

I had a problem doing this query to the data base. The query variable ($ result1) says 'Error in the query database'. <?php $con=mysqli_connect ('127.0.0.1','root','','freatico') or die ('Error en la conexion'); $username=$_POS...
asked by 19.05.2018 / 16:16
2
answers

Modify fields phpMyAdmin

I just started working with BDs , and I'm trying to update the value of a field in all rows. That is, in the table FRUITS I have the column color , and I want to put all the fruits have color rojo . The fact is that when trying...
asked by 14.05.2018 / 09:12
1
answer

merge select

SELECT vendedores.Nombre,(SELECT SUM(factura.Total) FROM factura WHERE vendedores.Codigo=factura.CodigoVendedor AND factura.Tipo='Factura' AND factura.Fecha BETWEEN '2018-09-13' AND '2018-09-14' GROUP BY vendedores.Nombre)+(SELECT SUM(sales.T...
asked by 26.09.2018 / 04:23
2
answers

Get JSON value in PHP

I'm having trouble accessing a specific value of a variable that returns a JSON in PHP. My code is as follows: //Llama el SP $sql="CALL tramites_G(".$valuesInsert.")"; $resultado = mysqli_query($database,$sql); if (!$resu...
asked by 24.08.2018 / 20:06
1
answer

Help with problem CS1586 visual studia next to MySQL

I do not understand why I get an error CS1586, specifically when I say new string[] class ConsultaMySQL { private MySqlConnection conexion = new MySqlConnection("server=localhost; database=thepacioli; Uid=root; pwd=Valentin_...
asked by 03.10.2018 / 02:43
2
answers

Take a row of Mysql with PHP without while

Hi, if you could help me, I'm trying to take a row from a Mysql table, I do not need to go through the table I just want to take a single row. $consulta_precio_seco="SELECT * FROM secos WHERE codigo=10" ; $resultados_precio_seco=mysqli_query($...
asked by 22.07.2018 / 18:35
3
answers

Help with the validation of a login with user privileges [closed]

I want to login with user privileges, I have a database called login , with a table accounts with the user fields, password and type_count . In the forms to log in I only have 2 inputs: user and password . When creating the accounts I...
asked by 22.03.2018 / 15:23
1
answer

Mysql LIKE does not filter PHP data

I have a problem in PHP when sending data to filter if I do it with the "=" no problem brings me the records but if I try to do it with LIKE, it does not return anything. It's the tm_profesor_dni. public function buscar_profesor_dni($dni){...
asked by 26.03.2018 / 18:52