Questions tagged as 'mysql'

Tagged questions
2
answers

Problem in mysql database when passing data with PHP

<?php include 'conexion_formulario.php'; $incidencia1 = $_POST['incidencia1']; $incidencia2 = $_POST['incidencia2']; if(isset($_POST['incidencia1']) || empty($_POST['incidencia1']) && isset($_POST['incidencia2']) || emp...
asked by 22.10.2017 / 19:08
2
answers

Error Notice: Undefined index: in search php

I'm doing a search in PHP and I get Notice: Undefined index:str I do not know how to solve it because I already have it called from the form where I get the information. I leave the search code. <form method="get" action="i...
asked by 19.10.2017 / 07:17
0
answers

SQL query does not run

I have a table [texts] in phpmyadmin like this: Column [column1] - > Type [int (20)] - > Null [no] - > Default [None] Column [column2] - > Type [text] - > Null [no] - > Default [None] . . The first column is used as...
asked by 19.10.2017 / 06:46
1
answer

sql-workbench find record that is not repeated in two tables

Good morning everyone ... Let's see who can help me with this simple query ... I have a database formula 1, in it there are two tables, one is cars and the other participation, the participation table has the key (codeCoche) foreign cars that pa...
asked by 01.11.2017 / 15:30
1
answer

Calculate Car Preventive Maintenance in JavaFX

First of all, good morning, everyone! Well today I have a small problem to solve with a program that I am asked to develop in Java is to calculate the figure in mileage that a car should be maintenance . For example, each vehicle is serviced...
asked by 18.10.2017 / 16:58
1
answer

How to create mysql database backup with c #

What I want is with a simple click on an option, a window appears to save the backup of the database. A dialog box in which the Backup can be stored anywhere.     
asked by 19.10.2017 / 01:25
0
answers

How to send a message when trying to delete a record that has a foreign key relationship?

What I need is that when the user presses the button to delete the record, it does not allow me to delete if it is related to another table, that is, I have a table grupo_cod, related to another one called items, at the moment to delete a record...
asked by 23.10.2017 / 16:58
1
answer

Query shows different data each time I execute Mysql

I have the following query: SELECT pr_production_units_details.id AS idProductionUnit, pr_production_units_details.production_units_detail AS productionUnit, IF(pr_varieties.variety IS NULL, 'SIN SEMBRAR O ERR', pr_varieties.variety) AS variet...
asked by 17.10.2017 / 14:34
1
answer

Query with fields from different tables

I am setting up a CRUD and I want to join fields from different tables, this would be: Customers table: customer, first and last name Invoice table: ID and quantity The code of the SELECT would be: $id = $_GET[ "IdCliente" ]; $no...
asked by 16.10.2017 / 21:19
2
answers

MySQL-PHP - ID auto_increment does not increase by 1

My web application registers a user and saves it in the BD but the id's go 4-9-18-27-48-57-66-75. How do you make the auto increment to be 1? Why can this be happening? This is the function that inserts the new $ user in the table: * the func...
asked by 16.10.2017 / 19:11