Questions tagged as 'mysqli'

Tagged questions
1
answer

pass parameters of evnto onclick to javascript function

//Obtener los permisos asignados al usuario $permisosAsignados = $permisos->listarPermisosMarcados($cedula,$id_item); //mostramos los permisos si estan o no marcados while ($reg = $permisosAsignados->fetch_object()){ $html = '<li>...
asked by 28.08.2018 / 00:32
0
answers

Function within an if else

I have the following function in PHP function verificar_status(){ global $db, $username, $usua, $ci_nro_cuenta, $monto, $nro_transf, $banco_emisor, $banco_destino, $fecha_transf, $status_pedido, $fecha_pedido, $status_pag...
asked by 08.09.2018 / 17:53
1
answer

query of 1 table related to 3 mysql

I have 3 tables: 1. contributions 2. contributions_volunteers 3. contributions_multas All these tables have an import field, and they are all related to the table: 4. associates What I want is to show the partner and the sum of their amounts in...
asked by 08.09.2018 / 16:45
1
answer

Decimals in SQL

I need to know how to make prices go like this: 1,250.00€ Now in the BD I have it put like this, decimal(10,2) and it looks like this: 1250.00€     
asked by 27.08.2018 / 11:34
0
answers

Update two records of a table without having the ID

I have a table that I want to update, where I am relating the PKs of three tables: Work teacher rollprof The table I want to update is structured in this way: CREATE TABLE IF NOT EXISTS 'sgtegcom'.'docente_has_rollprof' ( 'idd' INT...
asked by 27.08.2018 / 01:09
0
answers

Take the value of a select in a modal and a query

a few days ago a partner helps me to transfer the data from a table to a modal, in them there is a select that receives the status according to the value they have and they are selected. Well but now it is more complicated, I carry the name that...
asked by 24.08.2018 / 12:15
1
answer

Receive a notice when someone leaves a comment on my website

I have this code, which is a form to leave comments on my website. I would like to know if there is any way to get that by adding something else code I can get a notice to my email when someone leaves a comment on the web. The code that I leave...
asked by 29.08.2018 / 02:28
0
answers

Take the value out of an input id

I am passing data from a table to a modal to edit it, all this happened: So I send it to the modal: <td class="otrotdfgaz" id="Producto<?php echo $res['pedID']; ?>"><?php echo $res['producto']; ?> <?php echo $res['ali...
asked by 29.08.2018 / 11:18
0
answers

Codeigniter - expression # 1 of SELECT list contains nonaggregated column

I've done everything and still keeps sending me the error $this->db->distinct(); $this->db->select('s.id, COALESCE(SUM(sd.cajas),0) as cajas, COALESCE(SUM(sd.peso),0) as peso, c.nombre'); $this->db->fr...
asked by 16.08.2018 / 02:54
1
answer

Problem when calling an input I can not find a solution please help! JQUERY

Script where I send the information and show it <script> $(document).ready(function(){ $('.btcar').click(function(e){ e.preventDefault(); var car = $(this).attr("id"); var stock = $('#stock'+car).val();...
asked by 17.08.2018 / 09:09