Questions tagged as 'mysql'

Tagged questions
1
answer

I try to update two records at the same time in android studio and php pdo

I have a table with the fields Id, backup, family. What I'm trying to do is update a family record that matches the backup because they have the same value and at the time of updating the two values are updated both backup and of family. Anne...
asked by 31.10.2017 / 17:52
1
answer

get the values 0 in mysql query

estimates, I have a survey project for students in which there is a form_alumno table where students enter anonymously and fill out a form then it is redirected to the survey, which consists of 21 questions and each question has 5 types...
asked by 21.11.2017 / 00:29
0
answers

change date format in php

I have a code where I entered a specific dates that I uploaded with a pdf form, the case is that the format has to be in plan    November 20,2017 but when inserting the dates and calling them to the pdf, they remain like this    2017-1...
asked by 20.11.2017 / 17:28
2
answers

Mysql Update and insert in a single query

How can I write a Query to update certain fields where the only thing I want to check is the IDKey, but if it does not find the IDKey, the record does not exist, make an Insert of the record using this same information what I have: str="UPD...
asked by 28.10.2017 / 14:58
2
answers

how to view the records by user

Good evening, I'm doing a system for booking juices in php, but what happens is that when making a booking record, all users can see the reservations of others and I just want them to see their own reservation. //este codigo es para mostrar la...
asked by 09.11.2017 / 18:53
0
answers

How to extract data from a MYSQL query in .csv

Good afternoon, I'm trying to get the data from a query to a .csv file and I can not get it to work. Here I put my code. Thanks SELECT CAST(avg(numero) as decimal(18,2)) as media FROM ( SELECT DATE(fecha_creacion) fecha_creacion, COUNT(*)...
asked by 26.10.2017 / 15:13
0
answers

PHP MVC Submit button does not work

I have a problem, I have a very large table so I decided to use AJAX to be used as a filter, that is, the table will only show filtered data <script type="text/javascript"> $(document).ready(function(){ $('#search_apat, #sear...
asked by 26.10.2017 / 15:31
0
answers

mysql query with several filters

I have this query in MySQL and I would like to know if it is possible to make the following queries with this query: at least for the date range for a start date without providing the final date only by first name, last name, person...
asked by 26.10.2017 / 16:45
1
answer

Undefined variable: (2/2) ErrorException in a View.

I'm trying to import a view to a file in pdf format and it says that I do not have the variable defined. I'm using laravel-dompdf and the migrations are in MySQL . I have this error:    (2/2) ErrorException       Undefined variabl...
asked by 26.10.2017 / 07:46
1
answer

How to read files of EDB / PST mail copies from PHP / Laravel?

I am trying to read from the framework "Laravel 5.5" and / or directly PHP (it would even be worth something that happened to MySQL or a database manager to later deal with it) backups of 1TB in total, distributed in files 100GB, 200GB (size is...
asked by 26.10.2017 / 11:55