Select Customer.AR Cust Password, Customer.AR Cust User Name FROM AR Customer AS Customer

SELECT DISTINCT `client`.id , COUNT(registro.id) AS nopay, SUM(registro.com_paym) AS monto
FROM registro
INNER JOIN `client` ON client.suscriberid = registro.subcriberid
WHERE client.id_agent = '61' AND registro.procedado > 0 AND SUBSTRING(registro.fecha, 1,4) = '2020' AND SUBSTRING(client.aplication_date, 1,4) = '2020' AND SUBSTRING(registro.fecha, 6,2) = '01' AND client.borrado <> 1 AND client.id_insured = '2' GROUP BY registro.procedado  ORDER BY  registro.procedado ASC

SELECT
    t1.suscriberid AS id,
    @var1:=t2.pyear AS año,
    (SELECT
            IF(SUM(payments_global.commission),
                    SUM(payments_global.commission),
                    0)
        FROM
            payments_global
        WHERE
            payments_global.p_number = bob_global.suscriberid
                AND payments_global.pyear = @var1
                AND payments_global.month = '01') AS ene
FROM
    bob_global t1
        LEFT JOIN
    payments_global t2 ON t1.suscriberid = t2.p_number
WHERE
    1 AND t2.pyear = '2020'
        AND t1.id_insured = '2'
GROUP BY t1.suscriberid
HAVING ene = '0'

mysqli_query

mysqli_multi_query

$numLineas = (count(file("storage/" . $files))) / 100;

 

		if (!is_int($numLineas)) {

			$numLineas = intval($numLineas) + 1;

		}

		$Resto = (count(file("storage/" . $files))) % 100;

 

		//Comenzamos a procesar el fichero.

		$v = 1;

		$c = 1;

		$cil = 1;

 

		if (($gestor = fopen("storage/" . $files, "r")) !== false) {

			while (($datos = fgetcsv($gestor, 1000, ",")) !== false) {

				if ($c != 1) {

                                      //Insertamos los datos siempre que la variable $v llegue a 100.

					if ($v == 100 and $cil <= $numLineas) {.

 

                                         //Insertamos los datos  y ponemos la variable $v en cero

 

						$cil++;

						$v = 0;

					}

 

					//Insertamos el resto que no corresponde a a la cantidad de 100

					if ($v == $Resto and $cil == $numLineas and $Resto != 0) {

 

	                                     //Insertamos el resto que queda.

 

						$v = 0;

					}

				}

				$v++;

				$c++;

			}

		}

Valora esta pregunta

	function panime (i = 0){

		 	$(ps[i]).text(function(){
			 	if(val != ''){
					a_str = $(this).text().trim().split(" ");
					len = a_str.length;
					var v = '';
					if(len > 5){
						v = len / 5;
						v = Math.round(v);
					}else{
						v = 1;
					}
					search = '';
					ini = 0;
					fin = 5;
					//Conformamos la cadena a trabajar.
					for(c = 0; c <= v; c++){
						a_seg = '';
						a_seg = a_str.slice(ini,fin);
						if(a_seg != ''){
						    hidden_text(a_seg,ps[i]);
						    search = '';
		    				ini = ini + 5;
		    				fin = fin + 5;						
						}
					}
					panime(i + 1);				
				}		 		
		 	});
	}	

	function hidden_text(a_seg,tp,callback) {
			
			for(i = 0; i < a_seg.length ; i++){
				search += a_seg[i]+" ";
			}
			
			search = search.replace(/&nbsp;/g,"").trim();
			var regex = new RegExp(search,'g');
		    $(tp).html($(tp).text().replace(regex,'<span style="color: #ff0000; font-size: 18px;">'+search+'</span>'));

	    if (callback && typeof(callback) === "function") {
	        callback();
	    }
	}

	
	function panime (i = 0){
		 $("p").html(function(){
		 	val = $(this).html();
			str = val.toString();
			str = str.replace(/<\/?[^>]+>/gi, '').trim();
			a_str = str.split(" ");
			//seg = a_str.splice(0,5);
			len = a_str.length;
			var v = '';
			if(len > 5){
				v = len / 5;
				v = Math.round(v);
			}else{
				v = 1
			}
			search = '';
			n = 1;
			ini = 0
			//Conformamos la cadena a trabajar.
			for(c = 0; c < v; c++){
				a_seg = '';
				a_seg = a_str.splice(ini,5);
				if(a_seg != ''){
					for(s = 0; s < a_seg.length ; s++){
						search += a_seg[s]+" ";
					}
						search = search.trim();
						search = search.replace(/&nbsp;/g,"");
						var regex = new RegExp(search,'gi');
					        $(this).html($(this).text().replace(regex,'<span style="color: #ff0000; font-size: 18px;">'+search+'</span>'));
					        $(this).html($(this).text().replace(regex,'<span style="font-size: 18px;"></span>'));	
					    search = '';
					    ini = ini + 5;					
				}
				n++;
			}
			i++;
		}); 
	}

			ini = 0
			//Conformamos la cadena a trabajar.
			for(c = 0; c < v; c++){
				a_seg = '';
				a_seg = a_str.splice(ini,5);
				if(a_seg != ''){
					for(s = 0; s < a_seg.length ; s++){
						search += a_seg[s]+" ";
					}
						search = search.trim();
						search = search.replace(/&nbsp;/g,"");
						var regex = new RegExp(search,'gi');
					        $(this).html($(this).text().replace(regex,'<span style="color: #ff0000; font-size: 18px;">'+search+'</span>'));
					        $(this).html($(this).text().replace(regex,'<span style="font-size: 18px;"></span>'));	
					    search = '';
					    ini = ini + 5;					
				}