Questions tagged as 'mysql'

Tagged questions
2
answers

How to add decimals of a Mysql record with php?

I have a small drawback about adding up the total of a field in the database that is of type DOUBLE (6,3) . I have dealt with number_format and money_format. An example is when I'm going to register the field, I put 240 and when I sav...
asked by 26.08.2017 / 02:39
1
answer

Show data from today plus 1 week ahead in mysql

Good morning / afternoon / evening. I have a table in mysql that has a datetime field current_timestamp, name: Upload Date. What I need is to show the records where the load date is contemplated between the current day and 7 days ahead since the...
asked by 23.08.2017 / 21:26
1
answer

Save textarea line breaks

I'm using php and mysql, I need to replace the line breaks that I put in my textarea by \ n to save it in my database, I wanted to know how I can do this. Thanks!     
asked by 27.10.2017 / 17:02
1
answer

Error connecting to MySQL with CodeIgniter

I try to connect to MySQL but I get the following error    An uncaught Exception was encountered       Type: Error       Message: Call to undefined function mysql_pconnect ()       Filename: > C: \ xampp \ htdocs \ CodeIgniter \ system...
asked by 16.10.2017 / 21:03
1
answer

Table of answers with real results

I put a test to some students, I have a software so that they enter with their username and password, they choose one of 5 answers that there is in the page and already that is uploaded to a database. The tables that I have in the database ar...
asked by 19.09.2017 / 15:33
4
answers

Consultation with LEFT JOIN Mysql

I have three tables with the following data: varieties ------------------------------------ id | variety | status | ------------------------------------ 1 | VS1 | 1 | -----------------------------------...
asked by 18.09.2017 / 18:55
2
answers

Query database or json file

Good morning. I will write as specific as possible. I want to make a notification system which will inform users that an application has been answered. I use PHP without framework and Mysql. I can create a table to save and update the c...
asked by 06.01.2018 / 00:07
2
answers

How to call a MYSQL stored procedure from PHP?

I would like to know how to call a stored procedure of Mysql from PHP , I have tried it in several ways but of none I have given and I searched the Internet and neither. I tried it as a simple query like this: $cal = $_POST['calc...
asked by 02.01.2018 / 20:55
2
answers

Update two tables at the same time (Update)

Hi, I have a problem updating two tables at the same time    Appointment in block /*Si se ejecuta el update*/ if($this->miembro->editar_miembro($editar_miembro, $id_usuario)) { /*Redireccionamos al listado de usua...
asked by 22.06.2017 / 16:00
1
answer

Block record when reading it

I have a MySQL database with several tables and what I want is to block a record when reading it so that it is not read by another user until it stops reading or modifying it. Is there anything in MySQL that allows me to do that?     
asked by 11.06.2017 / 06:56