Questions tagged as 'mysql'

Tagged questions
0
answers

Problem with the php.ini

I have a server in Debian, I need to enable extensions php_pdo_mysql php_pdo I have seen that I have several php.ini files, apparently the server has zendserver installed. Run php --ini and it appears: Configuration File (php.ini)...
asked by 15.12.2017 / 17:18
1
answer

View the details of an employee

I have a database of employees, with a search form, search the user says the name, surname, photo and the position. I have below the names of the employees and I want them to click on a page with their details (Name, Surname, position and photo)...
asked by 02.12.2017 / 08:54
1
answer

Error with a mySql query

I am trying to make a query with mySql but the result is not as expected as rows are repeated and some data have no relation at all. I need to select from the table list_task the NAME and the PUBLIC_NUMBER and the table...
asked by 01.12.2017 / 10:27
2
answers

Why can not I see a JSON query using the Volley library (Web Services)?

I'm trying to create a web service using the Volley library, only when I run my app on a physical device I do not see the data that is hosted on a free server. The data is already in JSON but it does not remain unseen, already searched on the...
asked by 05.12.2017 / 22:17
1
answer

Pagination with Stored Procedure and Cakephp 3

I have a function in which I set up my records with a Store Procedure and I want to do a paging, of course in this case I can not use the predefined function of CakePHP here my code: public function index() { $id_user = $this->Auth->user...
asked by 30.11.2017 / 23:09
1
answer

mySQL - Can you do something similar to INDEX + MATCH?

Good morning, I need to update data in bulk in mySQL tables. What I have: Tabla1 => Donde quiero actualizar datos, tengo 2 columnas, ID1 y VIEJOTEXTO. Tabla2 => Una tabla con 2 columnas, ID1 y ID3. Tabla3 => Tabla donde tengo que...
asked by 28.12.2017 / 16:38
2
answers

Cutting Box X and Z point of sale system (php mysql)

Previously my cash flow systems ( Revenues - Expenses ) handled it daily, but the problem now is to accommodate a system for shift tellers and the establishment works 24 hours a day. Turn day (8am - 8pm). Night shift (8pm - 8am). I have research...
asked by 30.11.2017 / 05:33
2
answers

MySQL query with Ajax PHP

I need to query my database from a button, and I've had problems with that. I have a "button" or an "a" or an "input type" and I want to change a record with the "onclick", that is, if I press the button, the "state" field of my table will ch...
asked by 10.12.2017 / 07:20
1
answer

Error in MySQL / JAVA syntax

Good morning, I have the following code and I do not know why it is failing me. I think it's an error in my syntax because writing the following code was where the program stopped recognizing all my variables. import java.sql.Connection;...
asked by 25.11.2017 / 21:24
0
answers

Continue with ajax request, after validations in php

How could I build a form that after collecting the form data, send them by means of an AJAX request to a PHP file and this in turn validates them in the BD, return a response and this response is sent to an HTML message with validation buttons a...
asked by 25.11.2017 / 16:45