Questions tagged as 'mysql'

Tagged questions
2
answers

Connect site from localhost to online database Is it possible?

The question is if I can connect a web saved in my localhost to a database that is hosted online, the idea is the following:    I have an online database with the necessary information so that   run my website, I also have registered the dom...
asked by 04.11.2017 / 05:11
0
answers

Translate a sentence from Mysql to to Eloquent, laravel drivers 5.4

Hello I still do not know much about how to pass the queries to laravel, I have the following (which runs perfectly what I want in Mysql): query in mysql    'select distinct a.temario as Event, count (b.id) as Participants from   events a,...
asked by 04.11.2017 / 17:05
2
answers

connect mysql database with django

Hi, I have my project done in django but I did it using a tutorial that used sqlite3 but I already have my database created and mysql and I want to connect, I modify the settings.py but I do not know what else to modify it: / I only have a singl...
asked by 04.11.2017 / 23:23
0
answers

Trigger To update Field every 24 hours

Update my question to reference me and explain better what I want to do. In my table I have a field called days, I want every 24 hours to run and trigger and subtract that field in 1 if it has a 30 subtract 29 and so on, but I do not know how...
asked by 04.11.2017 / 00:02
1
answer

Multiply mysql entry field and php form

Good I would like to do a calculation, between a field in my database and a data entered by a form, I can not get it out ... The database data is internal saved in one table and the other one that the user enters by a form. <?php $usuar...
asked by 06.11.2017 / 19:35
1
answer

ERROR WHEN CREATING FIELD WITH DATA TO MYSQL PHPMYADMIN (1 & 1 hosting)

When creating the field dateee I get an error, and that is when I put the datatype ... I'm using a paid hosting sql (1 & 1) and it creates conflict with a sql statement .. The sentence: ALTER TABLE publicaciones ADD dateee DATETIM...
asked by 06.11.2017 / 15:04
0
answers

problem calling the variable session in codeigneter

this is in the controller <?php defined('BASEPATH') OR exit('No direct script access allowed'); class Principal extends CI_Controller { public function __construct(){ parent::__construct(); $this->loa...
asked by 06.11.2017 / 13:44
1
answer

how to do a mysql query that delivers two columns and that one has the value of the next row

I need someone to help me in how to do a mysql query that delivers two columns and that one has the value of the next row. I have the following records in this table: and I need to do a SELECT which gives me in a column the values of...
asked by 05.11.2017 / 22:04
0
answers

Problem with result of a query in mysql

I make the following query, to be shown in a table. $qry= "select round(b.monto_final_adelantado*100/sum(a.monto) ) as por from fc_facturas a inner join rc_proyectos b on a.id_proyecto = b.id_proyecto where b.id_proyecto =".$i...
asked by 03.11.2017 / 20:46
1
answer

how to upload data to the field with MD5 with php and mysqli?

if(isset($_POST['regi'])){ $Nombre = $_POST['name']; $apellido = $_POST['apellido']; $email = $_POST['email']; $pass = $_POST['pass']; mysqli_query($conect,"INSERT INTO Usuario (Nombre,Apellido,Email,Password) VALUES ('$Nombre','$apellido','...
asked by 30.10.2017 / 00:10