Home / user-172993

julio's questions

Martin Hope
julio
Asked: 2022-10-21 07:25:27 +0800 CST
  • 3

I am preparing a common schemao databasethat contains tables in common use across multiple projects. All MySQL users must have permission to run ONLY selecton those tables. For that I do:

drop database if exists common_schema;

CREATE DATABASE common_schema CHARACTER SET utf8 COLLATE utf8_general_ci;
grant select on common_schema.* to ""@"";
flush privileges;
use common_schema;

set foreign_key_checks = 0;

-- creación_de_tablas
-- inserts
-- foreign_keys

set foreign_key_checks = 1;

The entire operation is executed with a bash script that is as follows:

cat *.sql  > sql_completo.sql1
mv sql_completo.sql1 sql_completo.sql
mysql -u root -p < sql_completo.sql
rm sql_completo.sql

This script concatenates all the SQL files and loads it into MySQL. The problem is that any user can insert, modify or delete records from common_schema, which it shouldn't be.

I am using MySQL 5.6.51.

Thanks in advance!

mysql
Martin Hope
julio
Asked: 2022-09-13 03:48:09 +0800 CST
  • -2

I have this little code in JS that shows or hides a div. I use it in three sections and the same thing happens in all three: I have to click twice to show the details for the first time. From there it works fine with a single click to both show and hide

<!DOCTYPE HTML>
<html lang="es">
    <head>
        <meta charset = "UTF-8">
        <link rel="stylesheet" type="text/css" href="css/base.css" />
        <link rel="stylesheet" type="text/css" href="css/menu.css" />
        <link rel="stylesheet" type="text/css" href="css/presupuestos_ficha.css" />
        <title>Título de la pagina</title>
        <script>
            function ver_detalles(seccion) {
                if (document.getElementById(seccion).style.display === "none") {
                    document.getElementById("btn_"+seccion).innerHTML = "ocultar detalle";
                    document.getElementById(seccion).style.display = "block";
                    document.getElementById(seccion).style.visibility = "visible";
                } else {
                    document.getElementById("btn_"+seccion).innerHTML = "mostrar detalle";
                    document.getElementById(seccion).style.display = "none";
                    document.getElementById(seccion).style.visibility = "hidden";
                }
            }
        </script>
    </head>
    <body>
        <h4>Desglose de gastos - <span id="btn_detalle_gastos" onclick="ver_detalles('detalle_gastos')">mostrar detalle</span></h4>
        <div id="detalle_gastos"> <!-- este div se carga oculto y se muestra/oculta con la llamada a la función -->
            <div>item 1: $ 32.90</div>
            <div>item 2: $ 72000.00</div>
            <div>item 3: $ 6950.00</div>
            <div>item 4: $ 768.00</div>
            <div>item 5: $ 500.00</div>
        </div>
    </body>
</html>

I have tested the function by placing it in different places on the page and the same thing always happens.

javascript
Martin Hope
julio
Asked: 2020-05-16 10:10:31 +0800 CST
  • 0

First of all thanks to this community. This is my first query.

I have a javascript function that makes an ajax call to a script. Inside this function, the value of the variables is correct. This is the function (I emphasize that it is the same as many other calls with different "data" parameters):

function existe_dni(dni_a_verificar)
{
        $.ajax({
                type:'POST',
                url:'validacion.php',
                data:'dni_existe='+dni_a_verificar,
                success:function(html){
                        var validacion = $.parseJSON(html);
                        console.log("DNI: " + dni_a_verificar + " (" + typeof(dni_a_verificar) + ")");
                        console.log("Validacion: " + validacion + " (" + typeof(validacion) + ")");
                        console.log("");
                        return validacion;
                },
                error:function(jqxhr, status, exception){
                        return -1;
                }
        });
}

And this is the function that receives the previous return. Here, the variable exists_el_dni always and at all times has the value undefined:

else {
                var existe_el_dni = existe_dni(dni);
                console.log("(if) DNI: " + dni + " (" + typeof(dni) + ")");
                console.log("(if) Existe? " + existe_el_dni);
                if (existe_el_dni == -1)
                {
                        dni_ctl.style.borderColor = "red";
                        errores_personal_cnt++;
                        errores_personal += "\t- el D.N.I. ya existe\n";
                }
        }

I really don't know what is not working, since as I said, this function to many others. The console.logs of the first and second functions show the correct values ​​for the dni variable.

From already thank you very much!

javascript