0){ $pagos = get_pagos_by_id(); }else{ $pagos = get_all_pagos(); } if(count($pagos)>0){ foreach($pagos as $pago){ mysqli_query($link_base,"INSERT INTO autotransportes_pagossinsiniestro VALUES (".$pago['idmovimiento'].",".$pago['idpermisionario'].",".$pago['idoperador'].",".$pago['nombreoperador'].",".$pago['monto'].",".$pago['folio'].",".$pago['empresalog'].",".$pago['cancelado'].",".$pago['usuario'].",".$pago['fecha'].",".$pago['hora'],",".$pago['folioOpe'].",".$pago['folioPer'].",".$pago['corte'].",".$pago['notas'].")"); exit(); } } function get_pagos_by_id($id_movimiento){ $link = mysqli_connect("spsc.dynalias.net:3306", "root", "ercom"); mysqli_select_db($link, "autotransportes"); $result = mysqli_query($link, "SELECT * FROM pagosinsiniestro WHERE idmovimiento >".$id_movimiento); $data = []; if(mysqli_num_rows($result)>0){ foreach ($result as $item){ $data[] = $item; } }else{ $data=[]; } return $data; mysqli_close($link); } function get_all_pagos(){ $link = mysqli_connect("spsc.dynalias.net:3306", "root", "ercom"); mysqli_select_db($link, "autotransportes"); $result = mysqli_query($link, "SELECT * FROM pagosinsiniestro WHERE YEAR(fecha)>2018"); $data = []; if(mysqli_num_rows($result)>0){ foreach ($result as $item){ $data[] = $item; } }else{ $data=[]; } return $data; mysqli_close($link); } mysqli_close($link_base);