Questions tagged as 'sql'

Tagged questions
2
answers

Problems with the DataTables plugin

I explain I'm doing a crud at the moment everything works well I followed a guide because I really do not have much knowledge and the guide did not have the dataTables plugin that I think is important in a CRUD but I add them and the modal is da...
asked by 18.06.2018 / 07:13
0
answers

Assign SQL Query to a Variable

I have this Consultation: $result = DB::table('cliente') ->select(DB::raw("CONCAT( TRIM(SUBSTRING( NombreCliente,1,1) ), TRIM(SUBSTRING( NombreCliente, locate( ' ',NombreCliente), 2) ) ) AS INICIALES")) ->get(); I get the...
asked by 14.06.2018 / 23:18
0
answers

how to show several regitrates of a table whose id is in another with PDO?

I just want to show the data of some related tables that would be events-> themes-> speakers two have their id in others and I would like to know how to show the data on the screen nothing else, try it with inner join but it does not work or onl...
asked by 13.06.2018 / 23:06
0
answers

Model database query

I write to make a query or guidance on a MER referring to an inventory system. I have two entities: Equipo ------------------- Usuario According to my requirements, I need to generate a many-to-many relationship, which is why I am gener...
asked by 13.06.2018 / 22:10
1
answer

How to validate that a date is not the same as another date already registered

Hello, good evening, I am doing a medical appointment control system for the university and I have already managed to do the complete crud to the bdd and I registered everything without problems but I can not validate that when the user chooses...
asked by 15.06.2018 / 04:24
0
answers

Fatal error: Unknown: Failed opening required in Unknown on line 0 Failed to upload URL from an image to a DB

I get an error when uploading the path of an image to a SQL database <?php session_start(); $mysqli = new mysqli("localhost","root","1234","basededatos"); $Foto = $_FILES['foto']['name']; $Tipo = $_FILES['foto']['type']; $Ruta = $_FIL...
asked by 18.06.2018 / 17:46
0
answers

Trigger in sqlserver 2012 to update Master with detail information

I want to raise the following problem. For reasons of agility, initially it is migrated to a table with name MtoRequerimiento 400 records with information to be able to perform the initial tasks with the following structure. TABLE...
asked by 14.06.2018 / 17:47
1
answer

Auto Increment in number string type (0001 0002 ... java

Hello, I have a problem when generating a consecutive code. My data in the database is of type string , since it is not shown I do not know if the code will be well implemented. DAO Class public String Datosiguiente() { Conne...
asked by 12.06.2018 / 22:42
0
answers

Create users in c #

How can I do so that each user who believes, can only see the content that he added? EXAMPLE: there are 2 teachers, each teacher has different students, how can I make a program so that each teacher can only see the students that correspond?...
asked by 13.06.2018 / 00:57
0
answers

Cycle for averages with Pandas, frequency every 5 minutes

Hi, I have this df. I am trying to obtain average values assigned to each hour of measured data with a frequency of 5 minutes. This is how I charge the df from MySQL: import mysql.connector from mysql.connector import errorcode import pa...
asked by 12.06.2018 / 22:45