Caldeiro's questions

In the following piece of code I make a connection to my raspberry from pycharm. ledon makes the connection correctly and allows me to turn the led on/off by running the program from windows.

from tkinter import *
from tkinter import ttk


from gpiozero import LED, Motor
from gpiozero.pins.pigpio import PiGPIOFactory


factory = PiGPIOFactory(host='192.168.31.150')
ledon = LED(17, pin_factory=factory)
ledon.on()
motor1 = Motor(23, 24, pwm=True, pin_factory=factory)
motor1.forward()

In the case of motor1 it gives the following error I don't quite understand what is missing, I have tried to install the RPi.GPIO package in pycharm but it gives an error there is no way

C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\devices.py:288: PinFactoryFallback: Falling back from rpigpio: No module named 'RPi'
  warnings.warn(
C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\devices.py:288: PinFactoryFallback: Falling back from lgpio: No module named 'lgpio'
  warnings.warn(
C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\devices.py:288: PinFactoryFallback: Falling back from rpio: No module named 'RPIO'
  warnings.warn(
C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\devices.py:288: PinFactoryFallback: Falling back from pigpio: failed to connect to localhost:8888
  warnings.warn(
C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\devices.py:288: PinFactoryFallback: Falling back from native: [Errno 2] No such file or directory: '/proc/cpuinfo'
  warnings.warn(
Traceback (most recent call last):
  File "P:\PROYECTOS\RCC\main.py", line 29, in <module>
    motor1 = Motor(23, 24, pwm=True, pin_factory=factory)
  File "C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\devices.py", line 108, in __call__
    self = super(GPIOMeta, cls).__call__(*args, **kwargs)
  File "C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\output_devices.py", line 1223, in __init__
    super(Motor, self).__init__(_order=devices.keys(), **devices)
  File "C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\mixins.py", line 85, in __init__
    super(SourceMixin, self).__init__(*args, **kwargs)
  File "C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\devices.py", line 432, in __init__
    super(CompositeDevice, self).__init__(pin_factory=pin_factory)
  File "C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\devices.py", line 250, in __init__
    Device.pin_factory = Device._default_pin_factory()
  File "C:\Users\calde\AppData\Local\Programs\Python\Python39\lib\site-packages\gpiozero\devices.py", line 291, in _default_pin_factory
    raise BadPinFactory('Unable to load any default pin factory!')
gpiozero.exc.BadPinFactory: Unable to load any default pin factory!

The error when installing the module:

It turns out that by jQuery.ajax()stepping through dataa value containing the character +multiple times. When receiving it with $_POSTin the PHP file these characters are no longer there.

JavaScript code:

  var ejemplo = "esto+ es un ejem+plo";
  var postData = 'ejemplo='+ejemplo;

  $.ajax({
       url: "ejemplo.php",
       type: "POST",
       data: postData,
       success: function(data, status, xhr){
         // Els inputs de tipus cam:contacte esborraran el seu value
         $('input[tipus=camp_contacte]').val('');
         $('#btn_close').click();

       },
       error: function(jqXhr, status, errorThrown){
         console.log("POST " + status + " -> " + errorThrown);
       }
     });

PHP code:

 $texto = $_POST['ejemplo'];

I save the variable $textoin a database and it is inserted without the +. I have checked by doing a INSERTdirectly and it does let me save +.

It is just in the POST that I receive them without the +. I have also verified that ajax() he sends it well with a console.log(postData)and they also appear there.

Good I have never done this and it is something that I am trying and I do not get it. I would like to create a shortcut that goes to the console, and this in a specific folder for example D:\project\xxxx . So when accessing that SHORTCUT it will open the terminal in that PATH.

Once this is done as an example, as you will see in the select I look for the id of the offer, the name of the client, and the status of the offer.

Said query status must be 2 . How can I add to the where so that the client can be null. I know that I ask for the name of the client and if it is null it will not have it, that is what I want. Tell me all the offers with status 2 have a client or not. The problem is that if I have a client I have to know the name

create table clientes(Cliente_id integer primary key, Nombre varchar(50), 
Direccion varchar(100), NIF integer);
create table ofertas(id integer primary key, codigo_oferta 
integer,cliente_id integer, fecha date, estado integer, 
CONSTRAINT fk_Cliente FOREIGN KEY (cliente_id) REFERENCES clientes 
(Cliente_id));

show tables;

insert into clientes values (1,'Luis','asdaddasdsda',23858870);
insert into clientes values (2,"Maria","Daigonal 234",12345678);

insert into ofertas values (1,00001,1,default,2);
insert into ofertas values (2,00002,1,default,1);
insert into ofertas values (3,00003,null,default,2);
insert into ofertas values (4,00004,null,default,1);

Select O.id, C.Nombre, O.estado from ofertas O, clientes C where 
C.Cliente_id = O.cliente_id  and O.estado = 2 \G

  for (var i = 0; i < 5; i++) {
     setTimeout(function() { 
        console.log(i); 
     },i * 1000 );
    }

Hello, in the following piece of code, the value of i is always 5 , in the console.log(). Why?

<?php

$abc = array("a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","x","y","z");
$valores = array("luna","sol","abrir","acceso");

$contador = 0;
$result = array();

foreach ($valores as $value){

    for ($i = 0; $i < strlen($value); $i++) {

        $letra = $value[$i];

        for($z = 0; $z < sizeof($abc); $z++){

            if($abc[$z] === $letra){

                echo $letra; // Debug

            }

        }

    }
    $contador++;

}

I have this code that checks that each letter of each word in the array values ​​against the abc array . On echo letrascreen printing the result lunasolabriaccess . It checks it well, in that same piece of code I want to do what I am going to explain next and I don't know where to start.

As you can see there is a result array that is not being used at any time. In that array I want to save the words moon, sun .... from the values ​​array but with the condition only save until in the abc array I don't have to go back in the dictionary.

So the result should be:

mon, s, apr, acces

I don't know if I explained it well, since it is somewhat complex to explain. If there is any doubt I will try to express myself better. I don't know how to start doing this. Thank you

I have a .php file from which I connect to a remote database of a server that I have. It never makes the connection, and I think it's the fault of the code. Since remote configuration is enabled, the sql user is configured to connect from any IP .

The DB is MariaDB

From the mysql workbench I can connect without any problem, from php code it gives me an error

PHP version: 7.3.11

DB Version: 10.3.17-MariaDB

Code

$user = "remote";
$password = "1234";
$server = "192.168.1.17";
$bbdd = "login";
$table_users = "login";


$connect =  mysqli_connect($server, $user, $password);

$db = mysqli_select_db($connect, $bbdd);


if (isset($_POST['username']) && isset($_POST['password']) ){
  $query = "SELECT * from " + $table_users + " WHERE user = '" + $_POST['username'] + "'";
  $result = mysqli_query($connect , $query);

  // No esta en un while porque solo devolvera una linea de la bbdd, ya que el username es unico
  $info = mysqli_fetch_array($result);
  if ($info['user'] !== $_POST['username'] &&  $info['passw'] !== $_POST['password']) {
    echo 0;
  }else {
    echo 1;
  }
}else{
 echo 0;
}

I have the following data.

Two p tags with a name and an age. Then I have a list with certain values.

With jquery I get the name and the user without problem. But I don't know how to get all the values ​​from the list, I guess I need a loop.

 <p class="name"> User </p>
 <p class="age"> 99 </p>
 <ul>
   <li> item1 </li>
   <li> item2 </li>
   <li> item3 </li>
   <li> item4 </li>
 </ul>

Once all the data is obtained, I would appreciate the methodology or what is used in js to create a json with said data

How can I save in dteDiff the sum of the differences between dates that I do in the loop?

$dteDiff = ??????;  // <-- no sé cómo definirlo aquí

for ($i=1; $i < sizeof($Result); $i+=2) { 
    $strStart = $Result[$i-1]['tiempo'];
    $strEnd = $Result[$i]['tiempo'];

    $dteStart = new DateTime($strStart); 
    $dteEnd   = new DateTime($strEnd); 

    $dteDiff  += $dteStart->diff($dteEnd); 

}

$tiempoTemporal = $dteDiff->format("%H:%I:%S"); 

echo $tiempoTemporal;

We start with a div tag with an attribute

<div atr="1">a</div>

I have not found an operator for this case, I want to know if the attribute is greater than X . To add the class disabled. X is any number example 5.

$("div [atr<='X']").addClass('disabled');

The not equals operator does not work for me because there are several that should not be disabled and several that should.

I have this string:

"a:11: i:0;s:3:"191";i:1;s:3:"256";i:2;s:3:"247";i:3;s:3:"244";i:4;s:3:"257";i:5;s:3:"250";i:6;s:3:"253";i:7;s:3:"258";i:8;s:3:"261";i:9;s:3:"259";i:10;s:3:"542";}

I want to get the numbers that are in quotes ex: "191"

I've tried explode, but it cuts in places where it doesn't work for me. Neither split, up to strpos, but returns the position of the first match.

I would need something like what is between "%"

I have a macro that consists of adding the cell values ​​according to their background color. But the file in particular, when opening it gives me the following error.

BASIC error, object variable not set

It should be said that the macro works correctly, I only get the error when opening the file, but it is tedious since it jumps 5/6 times from accepting each time I open the file.

I leave you the code of the macro below.

Function SUMARCOLOR(CeldaColor As String, RangoSuma As String) As Double
Dim oRango As Object
Dim oCelda As Double
Dim c As Integer
Dim f As Integer
Dim oCuenta as DOUBLE
oCuenta = 0
oRango = ThisComponent.CurrentController.ActiveSheet
oCelda = oRango.GetCellRangeByName(CeldaColor).CellBackColor
oRango = oRango.GetCellRangeByName(RangoSuma)
For c = 0 to oRango.Columns.Count - 1
For f = 0 to oRango.Rows.Count - 1
 If    oRango.GetCellByPosition(c,f).CellBackColor = oCelda Then
     oCuenta = oCuenta+ oRango.GetCellByPosition(c,f).value
  End If
 Next
Next
SUMARCOLOR = oCuenta
End Function

Good, I have a code that collects jobs from a custom post in wordpress, I show them in a foreach . I would like to know some way to make pagination of 6 elements per page.

 <?php
/* Template Name: Lista Jobs */

/**
 * Blog list template
 *
 * @package vogue
 * @since 1.0.0
 */

//Funciones
function check_in_range($fecha_inicio, $fecha_fin, $fecha){

 $fecha_inicio = strtotime($fecha_inicio);
 $fecha_fin = strtotime($fecha_fin);
 $fecha = strtotime($fecha);

 if(($fecha >= $fecha_inicio) && ($fecha <= $fecha_fin)) {

     return true;

 } else {

     return false;

  }
}


// File Security Check
if ( ! defined( 'ABSPATH' ) ) { exit; }

$config = Presscore_Config::get_instance();
$config->set( 'template', 'page' );

//Libreria para poder usar wordpress.
include('../../../wp-load.php');

//Argumentos para hacer la Query.
$args = array(
'post_type' => 'ofertasempleo',
'post_status '=> 'publish',
'posts_per_page' => -1
);

//Obtenemos las clinicas del sistema.
$jobsAUX = new WP_Query($args);

//var_dump($jobsAUX);
//Si tenemos clinicas disponibles.
if ( $jobsAUX->have_posts() ) {
//Creamos pila de trabajos.
$jobs = array();

//Entramos en bucle para obtener los jobsAUX.
while ( $jobsAUX->have_posts() ) : $jobsAUX->the_post();
     $location = array(
            "titulo" => get_the_title(),
            "activo" => get_field("activo"),
            "imagen" => get_the_post_thumbnail_url(),
            "url" => get_the_permalink(),
            "inicio" => get_field("fecha_inicio"),
            "fin" => get_field("fecha_fin")
        );
    //Almacenamos las posiciones.
    array_push($jobs, $location);
endwhile;

//Reseteamos el postdata.
wp_reset_postdata();
} 

get_header();

if ( presscore_is_content_visible() ): ?>

        <!-- Content -->
        <div id="content" class="content content-empleo" role="main">

            <?php
            if ( have_posts() ) : while ( have_posts() ) : the_post(); // main loop

                do_action( 'presscore_before_loop' );
                the_content();
                //Cotenido // SACAR STYLE DE AQUI
                ?>
                <div class="jobs-container">

                    <?php

                    foreach ($jobs as $job) {
                        $titulo = $job['titulo'];
                        $img = $job['imagen'];
                        $url = $job['url'];

                        $fechaInicio = $job['inicio'];
                        $fechaFin = $job['fin'];
                        $fechaActual = date('Y-m-d');
                        $caducado  = $job['activo'];

                        if($fechaInicio != null && $fechaFin != null){
                            $activo = check_in_range($fechaInicio,$fechaFin,$fechaActual);
                        }else{
                            $activo = $caducado;
                        }
                        ?>

                        <div class="cajaEmpleo">
                            <a class="empleoUrl" href="<?php echo $url;?>">
                                <div class="contenidoEmpleo">
                                    <div class="blackground">
                                        <img class="imgEmpleo" src="<?php echo $img;?>" alt="GMEDIA"/>
                                    </div>
                                    <div class="tituloEmpleo" >
                                        <h3><?php echo $titulo; ?></h3>
                                    </div>

                                    <?php if($activo){?>
                                        <div class="estadoEmpleo" style="background: #00a000;">Activa</div>
                                        <?php }else{ ?>
                                        <div class="estadoEmpleo" style="background: #be3631;">Caducada</div>
                                    <?php }?>

                                </div>
                            </a>
                        </div>
                    <?php
                    }

                    ?>
                </div>

                <?php
                //Fin Contenido
                do_action( 'presscore_after_loop' );

            endwhile; endif; // main loop
            ?>

        </div><!-- #content -->

        <?php do_action('presscore_after_content');

endif; // if content visible

get_footer(); ?>

I'm trying to use the more tag in wordpress but it doesn't do anything, I leave screenshots below.

And that's how it looks, the "read more" does not appear

Hi, I have this script in js that adds a class to these two classes to change the style when clicking on the div that has the letterBox class.

The question is I want to remove the alphabetical class, which is the one I put when they click on any other place than letterboxes.

<script type="text/javascript">
(function($){
$(document).ready(function(){
    $(".cajasLetras").click(function () {
        $('.cajasLetras').addClass('alphabetical');
        $('.Linearicons-Free-text-format').addClass('alphabetical');

    });
});
})(jQuery)

</script>


<div class="cajasLetras">
    <div class="dropdown-menu-letras">
        <span class="topbar-text">
           <i class="Linearicons-Free-text-format"></i>&nbsp;ALPHABETICAL
        </span>
    </div>  
</div>

When I click on this div, the alphabetical class is added to letterboxes, but when I try to removeClass, the addClass stops working.

import java.io.*;
import java.util.*;

public class E11 extends Thread {
public void run() {
    ArrayList<Integer> primos = new ArrayList<Integer>();
    boolean primo = true;
    for (int i = 1; i <= 100; i++) {
        for (Integer numero: primos) {
            if (numero != 1 && i % numero == 0) {
                primo = false;
                break;
            }else {
                primo = true;
            }               
        }
        if (primo) {
            primos.add(i);
            System.out.print(i + " ");
        }
    }
}

public static void main(String[] args){
    Thread primo = new E11();
    primo.start();
}

}

Good with the following code that I put above, I know what it says about the first 100 integers, those that are primes, but I don't quite understand the for . Can someone explain that for to me?

Thanks in advance

I have this program that I must run from another.

public class Exercici8_p1 {
   public static void main(String[] args) {
    System.out.println("Introduzca texto -> ");
    Scanner sc = new Scanner(System.in);
    String texto = sc.nextLine();
    String[] parts = texto.split("\\*");
    System.out.println(parts[0]);
  }
}

From this I must execute the previous one

public class Exercici8_p1b {
 public static void main(String[] args) {
    try
    {
        Process process =  Runtime.getRuntime().exec("java Exercici8_p1");
    }
        catch(Exception e)
    {
        System.err.println("Error on exec() method");
    }
 }
}

//Argumentos para hacer la Query.
$args = array(
'post_type' => 'sectores',
'post_status '=> 'publish',
'posts_per_page' => -1
);

//Obtenemos las clinicas del sistema.
$sectores = new WP_Query($args);

//Si tenemos clinicas disponibles.
if ( $sectores->have_posts() ) 
{
//Creamos pila de clinicas.
$infoSector = array();       


  //Entramos en bucle para obtener las clinicas.
while ( $sectores->have_posts() ) : $sectores->the_post();
    if(get_the_post_thumbnail_url()){
        $location = array(
            "nombre" => get_the_title(),
            "slug" => get_post_field( 'post_name', get_post()),
            "imagen" => get_the_post_thumbnail_url(),
            "main" => get_field("main"),
            "custom_link" => get_field("custom_link"),
            "category" => get_the_terms( $post->ID, 'categoria_sector' ),
            "descripcion" => get_field("descripcion"),
            "orden" => get_field("orden")
        );
    } else {
        $location = array(
            "nombre" => get_the_title(),
            "slug" => get_post_field( 'post_name', get_post()),
            "imagen" => "http://www.yupcharge.com/wp-content/uploads/2018/08/sectores-yupcharge.jpg",
            "main" => get_field("main"),
            "custom_link" => get_field("custom_link"),
            "category" => get_the_terms( $post->ID, 'categoria_sector' ),
            "descripcion" => get_field("descripcion"),
            "orden" => get_field("orden")
        );
    }

    //Almacenamos las posiciones.
    array_push($programasEnvio, $location);

I have this data that I take with custom fields.

$sectoresPrint = array();
    foreach ($programasEnvio as $sector ) {
        if($sector['category'][0]->name == "Sector principal") {
            array_push($sectoresPrint, $sector);
        }
    }

How can I order the sectoresPrint array by the order field from lowest to highest

Well as the title says I need to add an svg image to the background of a div. I have to add the image by css yes or yes.

css

.catalogo-gallery .btn-pdf
{
   font-size: 17px;
   font-weight: 800;
   font-family: "Open Sans";
   background-color: rgb(255, 255, 255);
   border-style: solid;
   border-width: 2px;
   padding: 12px 50px;
   text-decoration: none;
   background-image: url("image.svg");
   width:100%;
   height: 100%;
}

html

 <div class="div-btn" >
   <a style="color:'.$color.'; border-color:'.$color.';" class="btn-pdf" href="'.$tipo_catalogo["pdf"]["url"].'">DESCARGAR</a>
</div>

I have a variable in php called

$nombre = "img.jpg";

(The string could be: "www.example.com/content/something.jpg")

I want to find a way to add something in the middle of the string

$nombre = "img-150x150.jpg";

the solution i found

$imagenTMP = explode(".", $imagen);
$imagen = $imagenTMP[0].'.'.$imagenTMP[1].'.'.$imagenTMP[2]."-150x150.".$imagenTMP[3];