ArcanisGK507's questions

I have been researching how to find duplicates of a record in a database and in that I find this answer:

Finding Duplicates in MySQL - This answer aims to find duplicates in multiple columns of the same table, while I look for duplicates in a single column.

But I don't achieve my goal. what I intend is to visualize the N duplicate records.

Structure and example data:

DROP TABLE IF EXISTS `prueba`;
CREATE TABLE IF NOT EXISTS `prueba` (
  `id` bigint(21) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Id de la tabla',
  `name` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'nombre',
  `prod_ft` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'codigo',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
SET FOREIGN_KEY_CHECKS=1;

INSERT INTO `prueba` VALUES 
(1, 'Pepe Pelotas 1', 'FT202201001'),
(2, 'Pepe Pelotas 2', 'FT202201001'),
(3, 'Pepe Pelotas 3', 'FT202201003'),
(4, 'Pepe Pelotas 4', 'FT202201004'),
(5, 'Pepe Pelotas 5', 'Actualizar');

Query:

SELECT * FROM prueba WHERE `prod_ft` != 'Actualizar' GROUP BY `prod_ft` HAVING COUNT(*) > 1;

Result:

Example in sqlfiddle

Expected result:

I have a development in C# and Winform for Windows which has an installer.msi

This development includes a web container that implements the library CefSharp; which I like for its low ram memory consumption.

The problem is that by default all the pages that I open are executed implementing the dedicated graphic; and I want that by default if there is a dedicated graphics card it will be pulled for hardware acceleration.

1. In between investigating a solution is for the user to go and touch the GPU usage log in System and change the option to high performance:

So this doesn't really help me since I depend on the user having to make configurations or change on their device, so I have the following doubts:

Is there a way in C# to force the program to pull the dedicated graph if it exists for the execution of all processes and threads?

my program starts here:

using System;
using System.IO;
using System.Threading;
using System.Windows.Forms;
using System.Xml;

namespace Web_Desktop
{
    public partial class Loader : Form
    {

        public VarManager varManager = new VarManager();

        public Common commonClass = new Common();

        public XmlManager xmlManager = new XmlManager();

        public WebSelector webSelector;

        public Loader()
        {

            InitializeComponent();

        }

        public void StartUp()
        {

            
            bool filecheck = File.Exists(varManager.configfile);

            if (!filecheck)
            {

                if (varManager.isAdministrator)
                {

                    xmlManager.CreateConfXML();

                }
                else
                {

                    commonClass.RestartApp(true);
                    
                }

            }
            else
            {

                bool checkRunAs = false;

                XmlNodeList admSetting = xmlManager.ReadRunAS();
                XmlNode nodoAdm = admSetting.Item(0);

                if (nodoAdm.InnerText == "true")
                {

                    checkRunAs = true;

                }

                if (checkRunAs && !varManager.isAdministrator)
                {

                    commonClass.RestartApp(true);

                }
                else
                {

                    webSelector = new WebSelector(this);

                    Thread.Sleep(1500);

                    webSelector.ShowDialog();

                }
                
                

            }

        }

        private void Loader_Load(object sender, EventArgs e)
        {
            Thread thread = new Thread(StartUp);

            thread.Start();
        }

        private void Loader_FormClosed(object sender, FormClosedEventArgs e)
        {
            Application.Exit();
        }
    }
}

Hi guys I have the following ListView:

This ListView has 3 columns in the second placed the URLs using a button containing this code:

    ListViewItem listViewItem= new ListViewItem();
    String url = textBox1.Text;
    listViewItem.SubItems.Add(url);
    listViewItem.Name = url;
    listView1.Items.Add(listViewItem);

and the third column is left empty; once hydrated ListViewwith the URL and Status columns; I have added a button to validate these URLS which has the following code:

    private void button5_Click(object sender, EventArgs e)
    {

        PictureBox picture = new PictureBox
        {
            SizeMode = PictureBoxSizeMode.StretchImage,
            BorderStyle = BorderStyle.None,
        };


        foreach (ListViewItem eachItem in listView1.Items)
        {

            if (webRequestManager.ValidateURL(eachItem.Name))
            {

                picture.Image = Properties.Resources.correct;

            }
            else
            {

                picture.Image = Properties.Resources.incorrect;

            }

            //Aqui no se que poner para que la columna status en el row especifico se Actualice y agregue el pitcute box.
        
        }

    }

As you can see, once I have generated the picture box, I don't know how to inject it into the status column of each row.

I have already searched the site and these suggested posts do not achieve or contribute to solving my scenario:

Position yourself in a specific column and row

How to pass image from ListView to a pictureBox?

This is more or less the expected result:

update

I have implemented an ImageList:

private void button5_Click(object sender, EventArgs e)
        {

            ImageList imagenes = new ImageList
            {
                ImageSize = new Size(16, 16),
                ColorDepth = ColorDepth.Depth8Bit
            };
            
            imagenes.Images.Add(Properties.Resources.correct);
            imagenes.Images.Add(Properties.Resources.incorrect);

            listView1.SmallImageList = imagenes;

            foreach (ListViewItem eachItem in listView1.Items)
            {

                if (webRequestManager.ValidateURL(eachItem.Name))
                {

                    listView1.Items[eachItem.Index].ImageIndex = 1;

                }
                else
                {

                    listView1.Items[eachItem.Index].ImageIndex = 0;

                }

            }

        }

But I have not been able to make the image appear in column #3 of status:

If I have an asynchronous method I can put it inside a promise to force it to wait for it to be fulfilled but use it in a previous instance:

This is the example:

class meta {
    obj = null;
    test = () => {
        return new Promise((resolve) => {
            fetch('https://reqres.in/api/products/3')
                .then((response) => {
                    this.obj = response;
                    resolve(true);
                });
        })
    }
}

let mt = new meta();

mt.test().then(()=>{
    console.log(mt.obj); // en este punto siempre tendra un valor la variable y puede ser usada en esta instancia.
})

Is this correct or is there a better way to do it? With this I avoid having to continue nesting code inside the fetch then ....

the purpose of this function is to add data to an object saved in chrome.storage.local; I am implementing this function:

/**
 * Set object setting
 * 
 * @param {object} setting 
 */

function addSetting(setting) {
    chrome.storage.local.set({ atsu_setting: setting });
}

Then in different areas of the code I try to add more data to what already exists:

chrome.storage.local.set({ atsu_setting: {opened:false} });
chrome.storage.local.set({ atsu_setting: {url:"dato"} });

The problem is that I am monitoring the data they are saving with:

setInterval(()=>{ 
    chrome.storage.local.get(atsu)
    .then((setting) => {
        console.log(setting);
    });
}, 10000);

but this only shows me the last saved; They told me that this is because I have to obtain the information, merge it and then save it again; this implies that I must use async; therefore do this:

chrome.storage.local.set({ atsu_setting: {opened:false} });
metodo_siguiente();

You will have unwanted behavior; since the asynchronization that I know asks me to implement something like this; causing that in each memory read you need to nest code inside a.then

.then((setting) => {
     metodo_siguiente();
})

How do I resolve/improve Data Update? I am needing to read the data; save, the new ones and return this data to a variable:

Example:

function udateSetting(objeto){
    chrome.storage.local.get(atsu_setting)
    .then((setting) => {
        //validar que existe:
        if(setting){
            //agregarmos nuevos datos
            setting[Object.keys(objeto)]='dato';
            chrome.storage.local.set(setting);
            return setting;
        }
    });
}

let new_setting = udateSetting({nueva_propiedad:"dato de la propiedad"});

console.log(new_setting);

Hello friends, I am using the stylebot extension that allows you to edit or add CSS to web pages:

As the publication says, I am trying to agregar contenido a hipervínculos por defecto distinto a los visitados.

I am doing this with CSS:

a.question-hyperlink {
  font-family: Calibri;
  font-weight: 100;
  font-style: italic;
}


a.question-hyperlink {
  color: #c27ba0;
}

a.question-hyperlink::before {
  content: "[New] -> ";
}

a.question-hyperlink:visited {
  color: #f6b26b;
}

a.question-hyperlink:visited::before {
  content: "[Rev] -> ";
}

but I am not getting the expected result since the visited links; The content added to the default ones continues to appear [New] -> and not this [Rev] ->, which would be the expected content:

Starting from the following hypothetical example structure:

Table: Master_Product

Prod_Code   perfil  Marca   Orden   Categoría
1           1       10      25      2
2           1       10      26      2
3           1       10      27      2
4           1       10      28      6
5           1       10      29      6
6           1       10      30      6
7           1       10      31      6

Table: Product_Structure

Prod_Code   perfil  UxC CxP
1           1       4   60
2           1       10  60
3           1       8   60
4           1       12  60
5           1       20  60
6           1       24  60
7           1       50  60

Table: Product_Supplier

Prod_Code   perfil  Proveedor
1           1       30
2           1       30
3           1       30
4           1       30
5           1       40
6           1       40
7           1       40

Table: Product_Price

Prod_Code   perfil  Price  Prod_DateUpd
1           1       10     20/10/2021
2           1       10     20/10/2021
1           1       5      19/10/2021
2           1       5      19/10/2021
3           1       20     20/10/2021
1           1       20     15/10/2021
1           1       15     15/10/2021

implement the following query to fetch all the data:

SELECT * FROM Master_Producto
LEFT JOIN(SELECT * FROM Producto_Estructura) AS Producto_Estructura ON ( Master_Producto.Prod_Code = Producto_Estructura.Prod_Code AND Master_Producto.Prod_PF = Producto_Estructura.Prod_PF)
LEFT JOIN(SELECT * FROM Producto_Proveedor) AS Producto_Proveedor ON ( Master_Producto.Prod_Code = Producto_Proveedor.Prod_Code AND Master_Producto.Prod_PF = Producto_Proveedor.Prod_PF)
LEFT JOIN(SELECT * FROM Producto_Precio ORDER BY Prod_DateUpd DESC) AS Producto_Precio ON ( Master_Producto.Prod_Code = Producto_Precio.Prod_Code AND Master_Producto.Prod_PF = Producto_Precio.Prod_PF)

Tested with phpmyadminit works correctly, but I can't get it to work from the php.

it happens that this is executed by ajaxand the responseand errorare returned empty; when you expect something to always come, hopefully it's garbage...

the scenario as I was commenting is hypothetical, let's say that the real query uses the same pattern, to 10 tables where there are between 2000 products in the master and in the other tables there can be between 2000 and 500,000 records. I go back and repeat in phpmyadminthe Query.

there are like 500 columns...

These are the scripts:

where everything starts:

<?php
    $stmtpre           = "SELECT * FROM Master_Producto
    LEFT JOIN(SELECT * FROM Producto_Estructura) AS Producto_Estructura ON ( Master_Producto.Prod_Code = Producto_Estructura.Prod_Code AND Master_Producto.Prod_PF = Producto_Estructura.Prod_PF)
    LEFT JOIN(SELECT * FROM Producto_Proveedor) AS Producto_Proveedor ON ( Master_Producto.Prod_Code = Producto_Proveedor.Prod_Code AND Master_Producto.Prod_PF = Producto_Proveedor.Prod_PF)
    LEFT JOIN(SELECT * FROM Producto_Precio ORDER BY Prod_DateUpd DESC) AS Producto_Precio ON ( Master_Producto.Prod_Code = Producto_Precio.Prod_Code AND Master_Producto.Prod_PF = Producto_Precio.Prod_PF);";
    $data              = $this->BDquery($stmtpre, DB_PRODUCT); //aquí se queda
    //nada despues de este punto se ejecuta;
    echo '<pre>';
    echo var_export($data,true);
    echo '</pre>';

and the database connection scripts:
Note: This script is only used to search for data that does not require search parameters.

<?php

    function Open_Con_DB($dbUsing) {
            $error            = [];
            $error['dberror'] = 'no';
            $dblink           = mysqli_connect(DB_HOST, DB_USERNAME, DB_PASS); # verificar donde se incluye el puerto
            $selected         = mysqli_select_db($dblink, DB_PRE . $dbUsing); # verificar donde se incluye el puerto
            if (!$selected) {$error = $this->errorDB($dblink);} # Verificacion de Errores de Coneccion a la base de Datos
            try {
                if ($error['dberror'] == true) {
                    throw new Exception('A ocurrido un Error De coneccion a la Base de Datos.<br>' . $error['msg']);
                }
            } catch (Exception $e) {
                echo 'Error: ' . $e->getMessage() . '<br>Error Trasado:' . $e->getTraceAsString();
                die('Proceso Cancelado');
            }
            $dblink->query("SET NAMES 'utf8'"); # Enlace de Coneccion UTF-8
            return $dblink;
    }
    
    function Close_Con_DB($dblink) {
        mysqli_close($dblink);
    }
    
    function ErrorDB($dblink) {
        $error['msg']     = 'Indicacion: ' . mysqli_error($dblink);
        $error['dberror'] = true;
        return $error;
    }

    function BDquery($dbquery, $dbUsing) {
        $dblink = $this->Open_Con_DB($dbUsing);
        $datos  = mysqli_query($dblink, $dbquery) or $this->errorDB($dblink);
        $this->Close_Con_DB($dblink);
        return $datos;
    }

MySQL configuration:

[client]
#password=your_password
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
key_buffer_size=512M
max_allowed_packet=2048M
table_open_cache=256
sort_buffer_size=8M
read_buffer_size=8M
read_rnd_buffer_size=16M
myisam_sort_buffer_size=64M
thread_cache_size=8

secure-file-priv=""
explicit_defaults_for_timestamp=1
datadir= "C:/laragon/data/mysql"
lower_case_table_names=2
sql_mode=""


[mysqldump]
quick
max_allowed_packet=2048M

Update #1:
I had forgotten to check the MySQL Log, here is the data:

2021-10-01T22:12:10.757688Z 120 [Note] Aborted connection 120 to db: 'dbproducts' user: 'root' host: 'localhost' (Got an error writing communication packets)

Update #2:
I have decided to check the Apache log:

[Fri Oct 01 19:29:28.308182 2021] [cgi:error] [pid 12144:tid 1124] [client 127.0.0.1:58769] AH01215: PHP Fatal error:  Allowed memory size of 1073741824 bytes exhausted (tried to allocate 24576 bytes) in Unknown on line 0: C:/laragon/bin/php/php72/php-cgi.exe, referer: http://avi2.me/

for so few bytes:

Setting:

the web server runs php 7.2as in the following images, but the phpmyadmin runs with php 7.4 apache handler 2.0, the two environments have the same environment variables 3gb of memory limit.

PHPMyAdmin executes everything correctly and the web app does not

Environment Variables, it will be that 1 GB is very little:

Doubts:
if the problem is memory it goes to more than 3GB but I still don't understand why in php-cgi it dies for and not in phpmyadmin?
If the connection was aborted why don't I get an error?
So I don't know where the error could be or what I should correct?

Get records from multiple tables from a single query.

I have the following structure and data, there are 4 tables:

Table: Master_Product

Prod_Code   perfil  Marca   Orden   Catengoria
1           1       10      25      2
2           1       10      26      2
3           1       10      27      2
4           1       10      28      6
5           1       10      29      6
6           1       10      30      6
7           1       10      31      6

Table: Product_Structure

Prod_Code   perfil  UxC CxP
1           1       4   60
2           1       10  60
3           1       8   60
4           1       12  60
5           1       20  60
6           1       24  60
7           1       50  60

Table: Product_Supplier

Prod_Code   perfil  Proveedor
1           1       30
2           1       30
3           1       30
4           1       30
5           1       40
6           1       40
7           1       40

Table: Product_Price

Prod_Code   perfil  Price  Prod_DateUpd
1           1       10     20/10/2021
2           1       10     20/10/2021
1           1       5      19/10/2021
2           1       5      19/10/2021
3           1       20     20/10/2021
1           1       20     15/10/2021
1           1       15     15/10/2021

these tables have a Manual relationship by product code and profile: then the previous programmer developed a script that executes 4 queries individually to extract the data:

$stmtpre1 = "SELECT * FROM Master_Producto WHERE Prod_Code='$Prod_Code' AND perfil=$Prod_FT;";
$stmtpre2 = "SELECT * FROM Producto_Estructura WHERE Prod_Code='$Prod_Code' AND perfil=$Prod_FT;";
$stmtpre3 = "SELECT * FROM Producto_Proveedor WHERE Prod_Code='$Prod_Code' AND perfil=$Prod_FT;";
$stmtpre4 = "SELECT * FROM Producto_Precio WHERE Prod_Code='$Prod_Code' AND perfil=$Prod_FT;";

It then executes the queries, associates them and returns a single array:

$result = [];
$data1                  = $this->BDquery($stmtpre1, DB_PRODUCT);
$result['Prod_Profile'] = $this->BDasociar($data1);
$data2                  = $this->BDquery($stmtpre2, DB_PRODUCT);
$result['Prod_Info']    = $this->BDasociar($data2);
$data3                  = $this->BDquery($stmtpre3, DB_PRODUCT);
$result['Prod_Prov']    = $this->BDasociar($data3);
$data4                  = $this->BDquery($stmtpre4, DB_PRODUCT);
$result['Prod_Precio']  = $this->BDasociar($data4);

return $result;

I have come to the conclusion that this implementation is not efficient, and that the multiple connections and analysis in queries when handling more than 2000 products will drastically penalize the execution time, I have thought about rethinking the script and refactoring it, but I do not know how to implement it UNION of tables.

rent collaborates with me with the refactoring of the Query, the ideal would be to execute only one.

$stmtpre = implode(" UNION ", [$stmtpre1,$stmtpre2,$stmtpre2,$stmtpre2]);

But it's not working.

UPDATE #1

Example:

(SELECT * FROM Master_Producto WHERE Prod_Code='1' AND perfil=1) UNION (SELECT * FROM Producto_Estructura WHERE Prod_Code='1' AND perfil=1) UNION (SELECT * FROM Producto_Proveedor WHERE Prod_Code='1' AND perfil=1) UNION (SELECT * FROM Producto_Precio WHERE Prod_Code='1' AND perfil=1) 

Mistake:

The SELECT command used has different number of columns

UPDATE #2 Another Attempt using Right Join: note: it is contemplated to fetch only the last record ofProducto_Precio

SELECT
    *
FROM
    Master_Producto
RIGHT JOIN(
        Producto_Estructura
    ON
        Master_Producto.Prod_Code = Producto_Estructura.Prod_Code AND Master_Producto.Prod_PF = Producto_Estructura.Prod_PF
    )
RIGHT JOIN(
        Producto_Proveedor
    ON
        Producto_Estructura.Prod_Code = Producto_Proveedor.Prod_Code AND Producto_Estructura.Prod_PF = Producto_Proveedor.Prod_PF
    )
RIGHT JOIN(
        Producto_Precio
    ON
        Producto_Estructura.Prod_Code = Producto_Precio.Prod_Code AND Producto_Estructura.Prod_PF = Producto_Precio.Prod_PF
    ORDER BY
        Prod_DateUpd
    DESC
LIMIT 1
    )

Mistake:

Something is wrong in your syntax near 'ON

Is there another alternative?: yes.

I have the following structure:

The directory exampleis my directory root, for the project; in the Filetest_web_full_1.php

I try to load the file BSand it gives me an error 404and I have no idea why, this is the path I'm using:

<link rel="stylesheet" href="../../src/sources/bs5/bootstrap.min.css">

Someone tell me the error. I do not see it.

I am struggling with 1 div in your CSS inline implement these 3 options:

#1

<div style="padding: 10px; background-color: rgb(072,000,017); border-radius: 10px;">

#two

<div style="position: relative; padding: 10px; background-color: rgb(072,000,017); border-radius: 10px;">

#3

<div style="position: absolute; padding: 10px; background-color: rgb(072,000,017); border-radius: 10px;">

the problem is that this div does not cover 100% of the width that if it covers its child elements and there is a horizontal scroll, I am using a label codethat contains labels spanand that in turn contain spaces html(  ) that I should not touch, as I do for this div to cover those spaces?:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <style>
        .container {
            height: 97vh;
        }

        .helper {
            float: left;
            width: 50%;
            height: 100%;
            min-height: 100%;
            white-space: nowrap;
            overflow: scroll;

        }
    </style>
</head>
<body>
<div class="container">
    <div class="helper">
        <div style="padding: 10px; background-color: rgb(072,000,017); border-radius: 10px;">
            <!--NO Tocar esto es automatico-->
                <code><span style="color: rgb(102,217,239); background-color: rgb(072,000,017); white-space: nowrap;">
                <span style="color: rgb(189,063,075); background-color: rgb(072,000,017); white-space: nowrap;"></span><span style="color: rgb(254,172,002); background-color: rgb(072,000,017); font-style: italic; white-space: nowrap;">//&nbsp;Theme:&nbsp;(Red)|&nbsp;Given&nbsp;Variable&nbsp;|&nbsp;Type:&nbsp;object&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br></span><span style="color: rgb(189,063,075); background-color: rgb(072,000,017); white-space: nowrap;">$given_var&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: rgb(254,254,254); font-weight: bold; background-color: rgb(072,000,017); white-space: nowrap;">=(object)[&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: rgb(254,172,002); background-color: rgb(072,000,017); font-style: italic; white-space: nowrap;">//&nbsp;object&nbsp;node&nbsp;of&nbsp;Class:&nbsp;MyHelloWorld,&nbsp;implement&nbsp;of&nbsp;traits:&nbsp;talkWorld.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;</span><span style="color: rgb(189,008,025); background-color: rgb(072,000,017); white-space: nowrap;">'__construct'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: rgb(254,254,254); font-weight: bold; background-color: rgb(072,000,017); white-space: nowrap;">=&gt;&nbsp;</span><span style="color: rgb(189,008,025); background-color: rgb(072,000,017); white-space: nowrap;">"no&nbsp;parameters"</span><span style="color: rgb(254,254,254); font-weight: bold; background-color: rgb(072,000,017); white-space: nowrap;">,&nbsp;&nbsp;&nbsp;</span><span style="color: rgb(254,172,002); background-color: rgb(072,000,017); font-style: italic; white-space: nowrap;">//&nbsp;Method&nbsp;of&nbsp;class:&nbsp;MyHelloWorld,&nbsp;modifiers:&nbsp;(public),&nbsp;return&nbsp;type:&nbsp;undefined.&nbsp;<br>&nbsp;&nbsp;</span><span style="color: rgb(189,008,025); background-color: rgb(072,000,017); white-space: nowrap;">'sayHello'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: rgb(254,254,254); font-weight: bold; background-color: rgb(072,000,017); white-space: nowrap;">=&gt;&nbsp;</span><span style="color: rgb(189,008,025); background-color: rgb(072,000,017); white-space: nowrap;">"no&nbsp;parameters"</span><span style="color: rgb(254,254,254); font-weight: bold; background-color: rgb(072,000,017); white-space: nowrap;">,&nbsp;&nbsp;&nbsp;</span><span style="color: rgb(254,172,002); background-color: rgb(072,000,017); font-style: italic; white-space: nowrap;">//&nbsp;Method&nbsp;of&nbsp;class:&nbsp;MyHelloWorld,&nbsp;modifiers:&nbsp;(public),&nbsp;return&nbsp;type:&nbsp;undefined.&nbsp;<br></span><span style="color: rgb(254,254,254); font-weight: bold; background-color: rgb(072,000,017); white-space: nowrap;">];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br></span><span style="color: rgb(254,172,002); background-color: rgb(072,000,017); font-style: italic; white-space: nowrap;">//&nbsp;[BOH]&nbsp;Basic&nbsp;Output&nbsp;Handler&nbsp;for&nbsp;PHP&nbsp;-&nbsp;Copyright&nbsp;2020&nbsp;-&nbsp;2021&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>//&nbsp;Open&nbsp;Source&nbsp;Project&nbsp;Developed&nbsp;by&nbsp;Icaros&nbsp;Net.&nbsp;S.A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>
                </span>
                </code>
            <!--NO Tocar esto es automatico-->
        </div>
    </div>
    <div class="helper">
        Otro Sitio.
    </div>
</div>

</body>

</html>

Current result and expected result that covers the missing spaces:

I have a method that does Insertand Updatesin PHP to a Database MySQLusing PDO.

In this case, the structure of the tables is not relevant since if the query does not meet the minimally necessary data of each column, the Script will perform a roleback of the insert.

This Script has a serious error and it is that it executes the insert and update from a query string armed as plain text .

What does the method receive?

Note: these queries are an example, they are not always the same or similar, they may vary depending on the scenario, the data may also change; but the theory is that an insert or update query string is always received.

Currently one arraywith the following example structure:

    $dbquery =[
        'DB1'=>[
            '0' =>'INSERT INTO table_name(column1,column2,column3) VALUES (value11,value21,value31)',
            '1' =>'INSERT INTO table_name(column1,column2,column3) VALUES (value21,value22,value23)',
            '2' =>'INSERT INTO table_name(column1,column2,column3) VALUES (value31,value32,value33)',
        ],
        'DB2'=>[
            '0' =>'INSERT INTO table_name(column1,column2,column3) VALUES (value41,value42,value43)',
            '1' =>'INSERT INTO table_name(column1,column2,column3) VALUES (value51,value52,value53)',
            '2' =>'INSERT INTO table_name(column1,column2,column3) VALUES (value61,value62,value63)',
        ],
    ];

The Script Used is this:

Which takes the example structure and goes through it... exchanging databases, tables and executing each Query (Insert, Update) to finally perform a commit:

public function SetData($Query, $Conf = [])
    {
        try {
            $conn = $this->DataBaseConnection($this->CheckServerSwitch($Conf)); //establece la conexion
            $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $conn->beginTransaction();
            $conn->exec("set names utf8");
            foreach ($Query as $DB_2USE => $QArr) {
                $conn->exec('USE ' . $DB_2USE);
                foreach ($QArr as $key => $QString) {
                    $cQ = $conn->exec($QString); //ejecuta el query
                    if ($this->CheckIfStartWith(['str' => $QString, 'beg' => 'UPDATE'])) { //valida si es un Update
                        $count['u'] = $count['u'] + $cQ;
                    }
                    if ($this->CheckIfStartWith(['str' => $QString, 'beg' => 'INSERT'])) { //valida si es un Insert
                        $count['i'] = $count['i'] + $cQ;
                    }
                    ++$cT;
                }
            }
            if (0 != $count['i']) {
                $smgINS_TXT = 'Registros Insertados: ' . $count['i'] . '<br>';
            }
            if (0 != $count['u']) {
                $smgUPD_TXT = 'Registros Actualizados: ' . $count['u'];
            }
            $conn->commit();
            return $smgINS_TXT . $smgUPD_TXT;
        } catch (PDOException $e) {
            $conn->rollback();
            return ['error'=>true, 'type'=>6, 'obj'=>$e]
        }
    }

Questions and doubts:

In the research carried out, the examples I find Examples that implement bind (bindValue, bindParam) use a single insert, but in my scenario I am trying to insert/update several records, so that at the end I can do the commit and if there is an error I do rollback and avoid badly inserted data... but I'm not implementing bind ...

How is the implementation of Bindwhen the scenario is the one I present?

I know that I should start by changing my array to something like this:

    $dbquery =[
        'DB1'=>[
            '0' =>[
                'query' => 'INSERT INTO table_name(column1,column2,column3) VALUES (?,?,?)',
                'column1'=>value11,
                'column2'=>value12,
                'column3'=>value13,
            ],
            '1' =>[
                'query' => 'INSERT INTO table_name(column1,column2,column3) VALUES (?,?,?)',
                'column1'=>value21,
                'column2'=>value22,
                'column3'=>value23,
            ],
            '2' =>[
                'query' => 'INSERT INTO table_name(column1,column2,column3) VALUES (?,?,?)',
                'column1'=>value31,
                'column2'=>value32,
                'column3'=>value33,
            ],
        ],
        'DB2'=>[
            '0' =>[
                'query' => 'INSERT INTO table_name(column1,column2,column3) VALUES (?,?,?)',
                'column1'=>value41,
                'column2'=>value42,
                'column3'=>value43,
            ],
            '1' =>[
                'query' => 'INSERT INTO table_name(column1,column2,column3) VALUES (?,?,?)',
                'column1'=>value51,
                'column2'=>value52,
                'column3'=>value53,
            ],
            '2' =>[
                'query' => 'INSERT INTO table_name(column1,column2,column3) VALUES (?,?,?)',
                'column1'=>value61,
                'column2'=>value62,
                'column3'=>value63,
            ],
        ],
    ];

Another example of the Array but with different nodes:

$dbquery =[
        'DB1'=>[
            '0' =>[
                'query' => 'INSERT INTO table_name_1(column1,column2) VALUES (?,?)',
                'column1'=>value11,
                'column2'=>value12,
            ],
            '1' =>[
                'query' => 'INSERT INTO table_name_2(column1,column2,column3,column4) VALUES (?,?,?,?)',
                'column1'=>value21,
                'column2'=>value22,
                'column3'=>value23,
                'column4'=>value24,
            ],
        ],
    ];

but what changes should I make to my script (if refactoring)?

I am implementing a autoloadergiven the following scenario:

Structure:

There is an X Application that through FTP generates a structure of directories and php files: Example:

Where:
index.php: would be the controller.
libs: is the directory where the X application connects and creates the structure.
p_xxxx: is the directory for each form, from 0001to 9999.
process.php: is the file phpwhere the logic of the form is developed p_xxx.
lista.php: is the file phpwhere the html view of the form is developed p_xxx.

According to the documentation, for a class file with this structure:
process.php

<?php

namespace Prueba\Dinamico\p_0001;

class Process
{
    public function Ejemplo(){
        echo 'process: p_0001';
    }
}

my index should look like this:

index.php

<?php

namespace Prueba\Dinamico;

/**
 * En esta sección es donde se agrega el formulario:
 * p_0001
 * pero se supone que este valor se recibe desde una variable de sesión del usuario:
 * $_SESSION['currentForm']='p_0001';
 *
 * entonces la linea de código del use no logro implementarla de forma dinámico:
 * y que cumpla con el PSR-4 y 12
 *
 */

use Libs\p_0001\Lista;
spl_autoload_register(function ($clase) {
    $file = strtolower(str_replace('\\', DIRECTORY_SEPARATOR, $clase)).'.php';
    if(file_exists($file)){
        require_once $file;
    }else{
        echo 'no se pudo cargar la Librería para esta Gestión.';
        die;
    }
});

$EjemploClase = new Lista();
$EjemploClase->Ejemplo();

The problem

As you can see, use Libs\p_0001\Lista;it's static. I don't know how to access, for example p_0003, the needed node, implementing $_SESSION['currentForm']which is where the value of the form is saved, e.g.: p_0003.

I don't know how to implement this and at the same time maintain the PSR 4 and 12 standard, since if I use or implement Magic Methods, the IDE does not recognize what is programmed as it is a value that changes at run time.

As you will see in the images, the system detects that these two stringhave 4 characters UTF-8, it is a view html, bone that is accessible from the browser:

//1234
//عباس

but when placing them one below the other they are not aligned, in the text with Arabic characters there is a loss of pixel space which I attribute to the fonts.

I implement normalizeversion 8.0.1for the css reset.

I have tried to use these fonts: consola, monospaceand jetbrain monowithout any positive result.

I have investigated what font can display this correctly aligned and I find that when entering the browser console it looks like this, almost perfectly aligned but with a minimum increase in pixels:

I tried to investigate what Font and setting it uses devtoolsbut google chrome browserI found absolutely nothing in the documentation, I just need how they apply the font of the html code viewer and what font they use.

Try to validate what it looks like in my IDE I use PHPStorm and guess what it looks like:

perfectly aligned; I validate the font and settingof my IDE and they are these:

I implement the same in my HTML:

<!DOCTYPE html>
    <html>
        <head>
            <meta charset="UTF-8">
            <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/normalize/8.0.1/normalize.min.css">
            <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Fira+Code">
            <style>
                body, span {
                    font-family: "Fira Code", monospace !important;
                    line-height: 1.2;
                    font-size: 12px;
                }
            </style>
        </head>

and on the website it continues to display badly:

I can't find what I'm doing wrong?

This is what comes out in the google chrome CSS viewer:

update

and this is what happens when you have data in different languages: view on website

Is it possible to get a domain from ICAAN without the service of third parties?

Local domains with a DNS server are not useful to me and I am not available to rent a domain from a third party like: Hostinger, GoDaddy

I have not been able to find documentation in Spanish on the subject.

Note: This topic is related to the Configuration Procedures of a Public Hosting and is part of the configuration/Programming of the DNS and Domain Services for access to the programming of a website.

I am creating an application with electron which will have 3 windows:

1. A Loader(it is in charge of verifying if there are updates or not).
2. Configuration and Updates.
3. The main Window where a URL is loaded.

Problem: I am trying to integrate an image into the Loader.

I understand that I should have a file loader.hmlwhere I would put the htmlso that it shows the image.

const appIcon = new Tray('/app/resource/images/icon.png')
const win = new BrowserWindow({ icon: '/app/resource/images/icon.png' })

but it is possible to load an image of a specific size without having to load the html file. as if it were an icon or application resource?

The idea would be to add this image as part of the main application or installation and display it while the loader checks for updates.

Update: Code I have:
Main.js

const electron = require('electron');
const url = require('url');
const path = require('path');
const isAdmin = require('is-admin');

const { app, BrowserWindow, Tray } = electron;
const Menu = electron.Menu;
const MenuItem = electron.MenuItem;

let loaderWindow;

function appLoader() {
  loaderWindow = new BrowserWindow({ width: 400, height: 200, frame: false });
  loaderWindow.loadURL(`file://${__dirname}/app/loader.html`);
}

app.on("ready", appLoader);

Html code (loader.html):

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body style="display: block; margin: 0px; overflow: hidden;">
<img src="assets/img/loader.png" alt="Browser Loader" style="width: 100%; margin: 0px 0px;padding: 0px 0px; overflow: hidden;">
</body>
</html>

Another alternative exists:

new BrowserWindow({
  backgroundColor: "#F7C136"
});

either:

mainWindow.setBackgroundColor('#56cc5b10')

But I don't find something for resources like an image.

I have created an application that has an update system, something unconventional:

this app is installed and run from:

C:\Program Files (x86)\Application test

the executable is called:

searchdata.exe

but at some point I had the great idea to make an update system that executes the following steps:

1. Click the update button: check if the executable exists update.exe.

• if it exists, run it immediately and close searchdata.exe.
• does not exist - download update.datfrom a URL and rename it to update.exe.

2. This is the download and progress bar script:

private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
        {
            DownloadFileWithProgress("http://test.pro/installer/update.dat", AppDomain.CurrentDomain.BaseDirectory + "update.exe", ProgressBar1, Label4);
        }

        private void DownloadFileWithProgress(string DownloadLink, string TargetPath, ProgressBar Progress, Label LabelProgress)
        {
            int bytesProcessed = 0;
            Stream remoteStream = null;
            Stream localStream = null;
            HttpWebResponse response = null;
            try
            {
                WebRequest request = WebRequest.Create(DownloadLink);
                double TotalBytesToReceive = 0;
                var SizewebRequest = WebRequest.Create(new Uri(DownloadLink));
                SizewebRequest.Method = "HEAD";
                using (var WebResponse = SizewebRequest.GetResponse())
                {
                    var fileSize = WebResponse.Headers.Get("Content-Length");
                    TotalBytesToReceive = Convert.ToDouble(fileSize);
                }
                response = (HttpWebResponse)request.GetResponse();
                if (response.StatusCode == HttpStatusCode.OK)
                {
                    remoteStream = response.GetResponseStream();
                    string filePath = TargetPath;
                    localStream = File.Create(filePath); // Aquí mero es el error
                    byte[] buffer = new byte[1024];
                    int bytesRead = 0;
                    do
                    {
                        bytesRead = remoteStream.Read(buffer, 0, buffer.Length);
                        localStream.Write(buffer, 0, bytesRead);
                        bytesProcessed += bytesRead;
                        double bytesIn = double.Parse(bytesProcessed.ToString());
                        double percentage = bytesIn / TotalBytesToReceive * 100;
                        percentage = Math.Round(percentage, 0);
                        if (Progress.InvokeRequired)
                        {
                            Progress.Invoke(new MethodInvoker(() =>
                            {
                                Progress.Value = int.Parse(Math.Truncate(percentage).ToString());
                            }));
                        }
                        else
                        {
                            Progress.Value = int.Parse(Math.Truncate(percentage).ToString());
                        }
                        if (LabelProgress.InvokeRequired)
                        {
                            LabelProgress.Invoke(new MethodInvoker(() =>
                            {
                                LabelProgress.Text = int.Parse(Math.Truncate(percentage).ToString()) + "%";
                            }));
                        }
                        else
                        {
                            LabelProgress.Text = int.Parse(Math.Truncate(percentage).ToString()).ToString() + "%";
                        }
                    }
                    while (bytesRead > 0);
                }
                else
                {
                    throw new ArgumentException(response.StatusDescription, "Respuesta del Servidor");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error en DownloadFileWithProgress" + ex.Message);
            }
            finally
            {
                if (response != null)
                    response.Close();
                if (remoteStream != null)
                    remoteStream.Close();
                if (localStream != null)
                    localStream.Close();
            }
        }

3. the problem is that I'm running with normal privileges, I don't want to have to use administrative privileges , but running gives me an access denied error when trying to write the file to the application directory.

I have a fixed window without borders, to which I remove the maximize and minimize buttons, etc., which completely covers the user's screen, but leaves the taskbar visible as follows:

FormBorderStyle = FormBorderStyle.None;
Left = Top = 0;
Width = Screen.PrimaryScreen.WorkingArea.Width;
Height = Screen.PrimaryScreen.WorkingArea.Height;
ShowInTaskbar = true;

but not having the maximize and minimize buttons does not allow you to minimize the window and it feels unnatural to navigate between open programs or search for something on the desktop...

I have tried to replicate the minimize and maximize event by capturing the event with activate as follows:

public void Toggle_Windows(object sender, EventArgs e)
{
    if(this.WindowState == FormWindowState.Maximized | this.WindowState == FormWindowState.Normal)
    {
        this.WindowState = FormWindowState.Minimized;
        ShowInTaskbar = true;
    }
    else
    {
        this.WindowState = FormWindowState.Maximized;
    }
}

but it does not work correctly since it hides the window and hides the icon in the task bar. I don't get any messages or errors from the code debugger

I have a class and in the constructor I determine the value of a property of the class; Why can't I use this class property as a default value in a method?

Or am I not using the proper property or property type?

class FooClass
{
    public string $defenv = '';
    public function __construct($theme = 'default')
    {
        //En el constructor determino el tipo de interface usada
        $this->defenv = $this->IsCommandLineInterface() ? 'cli' : 'web';
    }
    private function IsCommandLineInterface()
    {
        return (php_sapi_name() === 'cli');
    }
    public function foo($env = $this->defenv){
        echo $env;
    }
}

Mistake

Fatal error: Constant expression contains invalid operations in

I find myself needing to make these changes to make it work (it's still inside the class):

public function foo($env = ''){
    if ($env == '') {
        $env = $this->defenv;
    }
    echo $env;
}

Note: I have previously instantiated the class and call it as follows:

$example = new FooClass();
$example->foo()

Some time ago I have been developing on a platform that, although it is functional, they leave me negative comments and opinions about the Architecture/Structure/design pattern/anti-design pattern, because it is outdated, I have not even been able to find which pattern they used.

I have done some extensive research and both composer and other frameworks use class loaders.

Some of these loaders use spl_autoload_#######, in their architecture; with the idea that the developer uses namespaces or class instances like:

<?php
class Foo {
    public $aMemberVar = 'aMemberVar Member Variable';
    public $aFuncName = 'aMemberFunc';
   
   
    function aMemberFunc() {
        print 'Inside `aMemberFunc()`';
    }
}

$foo = new Foo;
?>

for later:

<?php
$element = 'aMemberVar';
print $foo->$element; // prints "aMemberVar Member Variable"
?>

the criteria of the Autoload of the Composer or framewrok is in charge of carrying out the include_onceor require_once, spl_autoload_#######of the necessary file where the class or function is located; this also allows you to run standalone PHP files as long as you have the USE NAMESPACE/NAMESPACE.

spl_autoload_register(function ($clase) {
    include 'clases/' . $clase . '.clase.php';
});

either

namespace Foobar;

class Foo {
    static public function test($nombre) {
        print '[['. $nombre .']]';
    }
}

spl_autoload_register(__NAMESPACE__ .'\Foo::test'); // A partir de PHP 5.3.0

new ClaseInexistente;

Mistake

[[Foobar\NonexistentClass]] Fatal error: Class 'Foobar\NonexistentClass' not found in ...

So, in the code I'm working on, they do something completely different:

The file index.phpthat acquires the system constants through a requiere_once, also has a Parent class CoreAppthat is always the one that receives everything: initial access, Requests: Get, POST, etc.

<?php
//require_once 'configs/const/loader.php'; // Acceso a las constantes del sistema
//se agrego las definiciones para hacer que el codigo sea ejecutable.
if (!defined('FILEROOT')) {
    define('FILEROOT', $_SERVER['DOCUMENT_ROOT']);
}
$paths = [
    'CLASSEXT'  => FILEROOT.'/apps/class/ext/',
    'CLASSMVC'  => FILEROOT.'/apps/class/mvc/',
    'CLASSGEN'  => FILEROOT.'/apps/class/gen/',
    'CLASSCORE' => FILEROOT.'/apps/core/',
    'TPLSTATIC' => FILEROOT.'/html/static/',
    'TPLDASH'   => FILEROOT.'/html/dash/',
    'TPLSITE'   => FILEROOT.'/html/site/',
    'TPLSTATUS' => FILEROOT.'/html/status/',
    'TPLSTORE'  => FILEROOT.'/html/store/'
];
if (!defined('PATHS')) {
    define('PATHS', $paths);
}

class CoreApp
{
    public static $oclass = null;

    // propiedad de la clase en donde se Guardaran las clases que se heredaran en las sub-capas

    public static $ovars = null;

    //  propiedad de la clase en donde se Guardaran las variables que se heredaran en las sub-capas

    private static $instance = null;

    public static function _getInstance()
    {
        if (!self::$instance instanceof self) {
            self::$instance = new self;
        }
        return self::$instance;
    }

    public function goCoreApp()
    {
        $this->popClass();
        echo 'hello World';
        //self::$oclass['GEN']['APP']->runInit();
        //self::$oclass['MVC']['CONTROLLER']->runController();
        //self::$oclass['GEN']['APP']->runClose();

    }

    private function popClass()
    {
        //se llama al archivo y la funcion que se encargara de poblar la porpiedad $oclass
        require_once FILEROOT.'/apps/class-manager.php';
        ClassManager::_getInstance()->LoadClass();
    }
}
ob_start();
CoreApp::_getInstance()->goCoreApp();

Then in the next layer it calls ClassManager::_getInstance()->LoadClass();which is a class loader which is going to populate the property CoreApp::$oclassthat is executed in the following way:

<?php
class ClassManager
{
    private static $instance = null;

    public function LoadClass()
    {
        $classPaths = [
            'GEN' => PATHS['CLASSGEN'],
            'MVC' => PATHS['CLASSMVC']
        ];
        $this->requireClassFile(PATHS['CLASSEXT'].'vendor/autoload.php');
        $this->ClassLoader($classPaths);
    }

    public static function _getInstance()
    {
        if (!self::$instance instanceof self) {
            self::$instance = new self;
        }
        return self::$instance;
    }

    private function CheckFileIntegrity($file)
    {
        $dl    = ['st' => false, 'msg' => ''];
        $smg1  = '';
        $fileR = file($file);
        $c     = 1;
        foreach ($fileR as $line) {
            if (!strlen(trim($line))) {
                $smg1 .= 'Incorrect space/Linebreak found file: '.$file.EOL_SYS.'Line: '.$c.EOL_SYS;
                $dl['st'] = true;
                ++$c;
            } else {
                break;
            }
        }
        $dl['msg'] = $smg1;
        return $dl;
    }

    private function ClassLoader($classPaths)
    {
        foreach ($classPaths as $key => $path) {
            $dl          = [];
            $class_store = &CoreApp::$oclass[$key];
            $files       = array_diff(
                scandir($path, 1),
                ['..', '.']
            );
            foreach ($files as $key => $name) {
                if (strpos($name, 'class-') !== false) {
                    $fl_dir = $path.$name;
                    $dl     = $this->CheckFileIntegrity($fl_dir);
                    if (!$dl['st']) {
                        $this->requireClassFile($fl_dir);
                        $name = explode("-", preg_replace('#\.php#', '', $name));
                        foreach ($name as $key => $cl_name) {
                            $name[$key] = ucfirst(strtolower($cl_name));
                        }
                        $new_name_class = implode('', $name);
                        $instance_class = strtoupper(
                            preg_replace('#\Class#', '', $new_name_class)
                        );
                        $new_name_class .= 'Manager';
                        $class_store[$instance_class] = $new_name_class::_getInstance();
                    } else {
                        echo
                            'PHP files cannot have line breaks at the beginning '.
                            'or end.<br> There is a problem with this file: <b> '.
                            PATHS['CLASSGEN'].$name.'</b> <br> <br>'.
                            $dl['msg'];
                        die;
                    }
                }
            }
        }
    }

    private function requireClassFile($file)
    {
        return require_once $file;
    }
}

Dependency: For this Script to work, it is necessary to create a folder in root with the following structure:

/apps/class/ext/#where all the composer installation and external libraries accessible by composer autoload will be placed.

/apps/class/gen/#where all the generic classes will be placed.

/apps/class/mvc/# where all the mvc classes will be placed.

Example of a Generic Class and an MVC:

class-test.php //class name must start withclass-

class ClassTestManager
{
    private static $instance = null;
    
    public static function _getInstance()
    {
    
        if (!self::$instance instanceof self) {
            self::$instance = new self;
        }
        return self::$instance;
    }
    public function test()
    {
        echo 'hello world';
    }
}

In summary:

for the end they have the property CoreApp::$oclasswith all the classes pre-instantiated. once this is done from any layer you can call a function as follows:

self::$oclass['GEN']['TEST']->test();

self::$oclass['GEN']['APP']->runInit();
self::$oclass['MVC']['CONTROLLER']->runController();
self::$oclass['GEN']['APP']->runClose();

either

CoreApp::$oclass['GEN']['VARS']->expVariable(true, true, false, true, CoreApp::$ovars, [$stuser, $isdata, $isdatatype, $iscron, $iswser])

does not require the use of USE NAMESPACE/NAMESPACEor the use of Instancias; neither of extender.

But I've never had a canonical answer as to why?
Project Link on Github
this is a project with little documentation in the code, Questions:

1. What pattern is it?
2. What are the weaknesses of this Architecture/Structure/design pattern/anti design pattern or the logic of using an Object or property to inherit pre-initialized Classes and Functions?
3. What errors can I be making, that the application stops working or is it an exploit?
4. What improvements (re-factory) can the class code have class ClassManagerto make it more efficient?

Update Comments / Clarifications

1. They tell me that there is a weakness in pre-initializing classes that are not used because they read from disk and save data in ram memory and can impact the speed of the system, for example knowing the server time for any use within the system.

Ans: The truth is that it is only read from disk once, and it is also saved once in ram, and the resource is saved in the object/Property CoreApp::$oclasswhich provides RAM access at runtime to any Class/function without need to resort to SPL_AUTOLo-... It is or is not a Weakness; I would need to test the scalability right.

How can I update a database with the following scenario?

I have a database in a test environment (server1) and I must update it with the one in the development environment (server2), but I only want to make the changes in the structure, without deleting the data already stored, I have already checked that:

I will not update the structure of existing columns, I will only add new ones, and the data that does not exist will be placed with a defaultor put as null.

So, how to make the comparison of the development server and get the differences with respect to the production server and bring as a result the changes that I must make in the production server?