Questions tagged as 'mysql'

Tagged questions
0
answers

Syntax order in MySQL

I have a small problem with the order of a database where I use ORDER BY ASC and you show me the results backwards. I share the code and I leave an image: select 'Seleccione...' as analisis union (SELECT DISTINCT analisis FROM ensayos WHE...
asked by 30.10.2018 / 13:18
0
answers

how can I upload an image from android to my database but in a column that is longblob?

I tried to upload an image to my database but it was inserted in the longblob column but I could not find it here my php code: $host_name = "localhost"; $database = "base_olx"; $user = "root"; $password = ""; $con = mysqli_connect($host_nam...
asked by 30.10.2018 / 23:47
0
answers

put an arrangement in a text to be sent in laravel with a file

Good afternoon in the following my query is about the following, I have a table that has a checkbox in which I already map () and get the data I want to obtain, also formed as a kind of arrangement. What I have considered is the possibility of s...
asked by 30.10.2018 / 19:45
3
answers

How can I find a number in a string in PHP?

I have a field in a table called personal and the data that it saves is a string of numbers delimited by commas, ex: 10,32,43,55,2,45 At the moment of wanting to make a query to find a specific employee I want to use this function: fo...
asked by 30.10.2018 / 18:20
0
answers

React native problems when uploading image with data in php

the data is not being uploaded, this is my React Native: import React, { Component } from 'react'; import {View,Text,StyleSheet,TextInput,TouchableOpacity,Image} from 'react-native'; import ImagePicker from 'react-native-image-picker'; import...
asked by 29.10.2018 / 21:34
0
answers

FALSE MYSQL DUPLICATE ENTRY ERROR

By placing an index on the table I get this error Executing: ALTER TABLE 'esd'.'sdf' ADD UNIQUE INDEX 'index2' ('id' ASC, 'periodo' ASC);    Operation failed: There was an error while applying the SQL script to   the database ERROR 1062: D...
asked by 29.10.2018 / 23:25
1
answer

How can I read the data of a db sql in an input text html5?

Here I have the code that works with the select ... but I can not get it to the input text. <div class="form-group"> <input type="text" value="" name="nombrecliente" id="nombrecliente" class="form-control input-lg" autocomp...
asked by 01.11.2018 / 11:57
1
answer

Add all the fields of the same column of several MySQL records

I have a table with several records, and let's say that each one collects the visits it has (for example). How can I get the total of visits? But not of all, but of those who fulfill a condition. That is, if I have: | Cat | Visitas...
asked by 28.10.2018 / 12:03
0
answers

Error 404 login form in PHP with MySQL

Very good. I've been trying for a few days to make a small page to add users to my database in MySQL. Before I can add the users, I have made another page where I must enter a login correctly so that it redirects me to the user creation form....
asked by 28.10.2018 / 15:18
0
answers

Workbench options - Outdated diagram

I have a database diagram designed in MySQL Workbench, and I have my database fully exported in a file (.sql), I also have later versions (incremental backup). In summary I have the following files: database.mwb database.sql upda...
asked by 29.10.2018 / 12:20