Damian Garcia's questions

I have a MySQL query in which I want to fetch all records from a particular year and then export and import it locally. I would have liked to bring it for the year only, but since there were so many records (when I wanted to import it, it wouldn't let me because of its size) I had to split it into two parts, in months (01 to 06 and 07 to 12).

The query I made in the first half of the year between months 01 to 06 was done well, the problem was with the other half (07 to 12). The Date data type is datetime . The query, which is very simple, I did it like this:

select * from `estadistica` where Fecha BETWEEN '2020-07-01' and '2020-12-31'

And in this case, I don't know why, it only brings me up to the 30th of the 12th month (12/30), that is, it rules out the 12/31. And it's not that there are no records, there are, because I did a common query and it shows data from day 31.

I have also tried this other query (putting HH:MM:SS):

select * from estadistica where Fecha BETWEEN '2020-07-01 00:00:00' and '2020-12-31 00:00:00'

and the same thing happens, it only brings me until December 30 .

There are some errors on my website that only occur with certain images that are inside the tag <img>. Actually, the error only happens with the Mozilla Firefox browser , with the others (Chrome, Opera, Edge) it doesn't happen to me. The images load fine in Firefox , but the problem is that I right-click on the page ( "Inspect element" option ) to check the console and there I see some errors ( warnings ) and which says the following verbatim:

"XML parsing error: tag without pair. Expected: </img>."

I don't know why "XML parsing" (I don't have anything structured in that language). Then, below, it puts the location, which is where the image is. I have the image enclosed with a div:

<div style="text-indent:0px;text-align:center;margin:0.7em 0 1em 0"><img data-src="GloImg/Menu.png" class="lazyload" alt=""></div>

As far as I know, the tag <img>does not have a closure (I have also noticed it on the w3schools page ). Although in some places and looking for my error they say to put the closing slash at the end: <img data-src="GloImg/Menu.png" class="lazyload" alt="" />, but this closing is not necessary in HTML5 , it may be in XML .

As I said before, the strange thing is that the other browsers don't give me an error when I go to inspect the console. Is it something unimportant? The version of Firefox I have is 78.02 .

I need to create some rules in the .htaccess file so that certain conditions are met. For example, I want to show the file 404.shtml ( ErrorDocument 404 /404.shtml) only in the case where the generated URL has the extension .html or .php (when it is misspelled of course or I don't find it on my site), in the other cases I don't ( which is when the page behaves as SPA).

Being SPA (single-page application), it always works on the same page and here I don't need to see the 404.shtml file . So I have the following and it is already working:

RewriteCond %{REQUEST_FILENAME} !-s
RewriteCond %{REQUEST_FILENAME} !-l
Rewritecond %{REQUEST_FILENAME} !-d
RewriteRule ^.*$ index.php [NC,L]

Now I want the opposite case when it is not on the page of type SPA . I would need some rule so that the 404.shtml page is seen , when the other internal pages are already and they always have the .html or .php extension. and they are not on the site (page not found).

Just as an example, it would be something like this:

IF (la pagina es SPA){
    RewriteCond %{REQUEST_FILENAME} !-s
    RewriteCond %{REQUEST_FILENAME} !-l
    Rewritecond %{REQUEST_FILENAME} !-d
    RewriteRule ^.*$ index.php [NC,L]
} else {
    ErrorDocument 404 /404.shtml
}

Right now I have it like this in the .htaccess file :

...
...
RewriteCond %{REQUEST_FILENAME} !-s
RewriteCond %{REQUEST_FILENAME} !-l
Rewritecond %{REQUEST_FILENAME} !-d
RewriteRule ^.*$ index.php [NC,L]

ErrorDocument 404 /404.shtml

...but the 404.shtml is never generated when the page doesn't exist.

In short, I need that, if the URL is within those managed by the SPA, it is redirected to the SPA and in another case it is redirected to a 404.shtml page

Can something like this be done from the .htaccess file ?

I have a fixed div located below the page ( <div class="Letras">). What I cannot achieve with said div is that it stays centered . On top of that, I'd like the div to only start displaying when the user leaves the page header (scrolling down) and pop it out before it reaches the end (to the footer). In short, it should always be seen when it is in the middle of the page (which is where the content for which it will make use of that fixed div is).

If it helps here I leave you some of the Code that I put together in codepen. They need to be moved down a bit for the div to appear. There you can also read the comments I left.

I am working with HTML5, PHPand JQuerytogether with AJAX. Within a form I have 5 input type="radio"which changes the content of the page divdepending on which is selected. They are called "All", "Informatics", "Networks", "Multimedia" and "BD/Programming". It is a glossary and the content to show are the terms that correspond according to the selected input. It is a way to show the user a list (ordered by alphabet) of all the terms that are in the glossary.

By default, when the page is loaded, the content starts with the one that says "All" (which brings all the terms that are in the other four sections: Computing , Networks , Multimedia and BD/Programming , that is, all). The user, as you will notice, can filter the content by selecting sections; for example, if you select "Networks" it will only bring the terms that are in that section and so on with the other categories.

All this works almost perfectly, it does not refresh the entire page when using AJAXit and also the content is displayed correctly to the user. The problem is when you want to see the source code of the page ( Ctrl+u ). It always shows me the same thing. I mean that in that source code the terms that are seen are the ones that were searched for at the beginning, the one that was selected by default (input that says "All") .

For example: if I select the input that has "Networks", all the terms that correspond to that category are displayed on the page, but if I want to see the source code, something else is seen there . You see the same terms as when the page was first loaded ("All" input). I have already tried to empty the div with $(".Secc").empty()and also do a load with $('.Secc').load();but nothing happens, besides load()it duplicates the page for me.

Actually, I wouldn't mind if I didn't have to use those terms that you see on the page for something else, but I do have to use them for something else. It is that these terms are shown as links ( <a class="GloIT" href="ActiveX" title="ActiveX">ActiveX</a>, <a class="GloIT" href="Fragmentar" title="Fragmentar">Fragmentar</a>, <a class="GloIT" href="SDRAM" title="SDRAM">SDRAM</a>...) and they will change depending on the section that the user chooses. And when one of these links is clicked, it should show the definition of that term in the corresponding category. That's why it's important that they display well, both on the page and in the source code.

Here I pass the code that I have, which is all on the same page (the formulario, the of PHPand the of JQuery) which is called TerminosIT.php:

  <form id="frRadio" method="post" action="">
    <fieldset>
     <legend>Selección por secciones: </legend>
     <label for="radio-1">Todas</label>
     <input type="radio" name="radio" id="radio-1" value="0">
     <label for="radio-2">Informática</label>
     <input type="radio" name="radio" id="radio-2" value="1">
     <label for="radio-3">Redes</label>
     <input type="radio" name="radio" id="radio-3" value="2">
     <label for="radio-4">Multimedia</label>
     <input type="radio" name="radio" id="radio-4" value="3">
     <label for="radio-5">BD/Programación</label>
     <input type="radio" name="radio" id="radio-5" value="4">
    </fieldset>
  </form>

In PHPI have:

<div class="Secc">
<?php 
if (isset($_POST['radio'])){ 
    $Sel=$_POST['radio'];
    switch($Sel){ 
        case 0:
            Todas($cxn,$Let,$Band,$Comp);
            break;
        case 1:
            Informatica($cxn,$Let,$Band,$Comp);
            break;
        case 2:
            Redes($cxn,$Let,$Band,$Comp);
            break;
        case 3:
            Multimedia($cxn,$Let,$Band,$Comp);
            break;
        case 4:
            Programacion($cxn,$Let,$Band,$Comp);
            break;
    }// end switch
}else{Todas($cxn,$Let,$Band,$Comp);}?>
</div>

He <div class="Secc">is where everything will go showing. I don't know if it's worth putting the code that has each function that is inside each casein PHP. But there basically, by means of MySQL, it searches the corresponding tables for the terms to show them later inside the tag <a...>...</a>.

And lastly about JQuery:

$(function() {
    $("input").checkboxradio();
    $("#radio-1").attr("checked","checked").change();
     $("input").on("change", function(e){
        e.preventDefault();
        //$(".Secc").hide();
        $(".Secc").empty();
        var dataString = $("#frRadio").serialize() + '&' + encodeURI("radio")+ '='+ encodeURI($("input[name$='radio']:checked").val());
         $.ajax({
            url: "TerminosIT.php",
            type: "POST",
            data: dataString,
            cache: false,
            success: function (data) {
                //$(".Secc").show();
                var $response = $.parseHTML(data);
                $response = $('.Secc', $response).html();
                $(".Secc").html($response);
                }
            });
        return false;
     });
  });

In conclusion, in the source code you always see the same thing (what was loaded the first time) . Maybe it's a AJAXproblem and there is no solution. If I don't have a solution, I'm going to have to do it, although I wouldn't like it, without using AJAXand reloading the entire page when some of the checkboxradio. Maybe they know a better way.

Alternative : Maybe I can fix it by adding certain attributes to the tag <a>from JQuery. For example, when the "Networks" section is selected, the links remain in this way <a class="GloIT" href="IP" data-id="2" data-seccion="Redes" title="IP">IP</a>, in "Multimedia" <a class="GloIT" href="CD" data-id="3" data-seccion="Multimedia" title="CD">CD</a>, etc. Adding those data-as appropriate

But as I already said in the source code it puts it like this <a class="GloIT" href="IP" title="IP">IP</a>, <a class="GloIT" href="CD" title="CD">CD</a>this is without the data-, because when selecting "All" those data-do not go and they are only added when any of the other four sections ("Computers", "Networks", "Multimedia" and "BD/Programming").

So, since what interests me here is the data-idand the data-seccion, I could, through a switch{...}(to know which section to work on) and a for, go through all the tags ( <a>that have only the class="GloIT") and add those attributes ( data-) and remove them if necessary. select "All". Does anyone know how I could do that from JQuery? Is something like this possible?

I want an en to be executed, PHPbut only if any of the 4 buttons are clicked . The problem is that when the page loads, the instruction inside the with is still executed , but I only need it (as I said before) to only be executed when some of those buttons are clicked and nothing else.insertmysqliifinsert

Maybe I'm putting the if, the parentheses wrong, or the use and location of the operators. I have already tried some other combinations and it continues to enter insertwithout even having clicked on the buttons. As you can see I put all the conditions in the same if, maybe I should separate it into different ones if. I hope you can tell me what would be more effective and that works of course. The code of PHPis:

if(isset($_POST['Ant']) && !empty($_POST['Ant']) || 
  (isset($_POST['Sig']) && !empty($_POST['Sig'])) || 
  (isset($_POST['Pri']) && !empty($_POST['Pri'])) || 
  (isset($_POST['Ult']) && !empty($_POST['Ult'])))
    {
      $sql=mysqli_prepare($cxn,"Insert into esttips (ID,NroTips,UserIP,Fecha) 
      Values (?,?,?,?)");
      mysqli_stmt_bind_param($sql,'siss',$id,$F,$ip,$fecha2);
      if (!mysqli_stmt_execute($sql)) {die('Error: ' . mysqli_error($cxn));}
    }

I will explain a little better. I must clarify that I have all the code in the same file ( index.php ). The button clicks event is done in JQuerymaking use of AJAXwhich is already working:

$('body').on('click', '#Ant, #Sig, #Pri, #Ult', function(e) {
 ...
 ...
}

I only need, as I mentioned at the beginning, that when any of the buttons is clicked ( #Ant, #Sig, #Pri, #Ult) it makes the insertion in the MySQL database that I have. But it can be seen that since all the code is in the same file, when loading the page it already inserts the values, when I only want it to do so only when a button is clicked.

Can everything be done in the same index.php or should I do the php thing separately in another file and then from the index.php make the call?

I want to pass a value that is given in a PHP variable $_SESSION['T']to JQuery . This variable changes its value as the "button" type inputs that I have in HTML5 are pressed . For the "Previous" input, the variable decreases (-) and of course, for the "Next" input , the variable increases (+). This is perfect.

Now what I want is that when it reaches the first record (it is achieved by clicking on the "Previous" input ) that same button is disabled and if it reaches the end (click on the "Next" input ) the same.

The problem is that I cannot achieve this from JQuery , although I can see the value from the console (for example, register 21, which is the one it starts with) when I click on the "Previous" or "Next" buttons that variable T that is in PHP (in JQuery it is named as Nro ) does not change. Therefore it seems that it is always in the same record (21), when it should change to number 20 (for "Previous" ) or 22 (for "Next" ).

This is a part of the code I have from PHP :

session_start();
if (!isset($_SESSION['T'])) {
    $_SESSION['T']=21;
}else{
    if(isset($_POST['Ant']) && !empty($_POST['Ant'])) {
         $_SESSION['T']--;
    }
    if(isset($_POST['Sig']) && !empty($_POST['Sig'])) {
         $_SESSION['T']++;
    }
}
   $T=$_SESSION['T'];

And the code I have for both buttons from JQuery is:

$('body').on('click', '#Ant, #Sig', function(e) {
    e.preventDefault();
    var $btn = $(e.target);
    $(".Tips").hide();
    $("#carga").show();
    var dataString = $('#FrmBus').serialize() + '&' + 
    encodeURI($btn.attr('name')) + '=' + encodeURI($btn.val());
    $.ajax({
        url: "http://localhost:81/prueba/",type: "POST",
        data:dataString,
        cache:false,
        success:function(data)
        {
             $("#carga").hide();
             $(".Tips").show();
             var $response=$.parseHTML(data);
             $response=$('.Tips',$response).html();
             $(".Tips").html($response);
             $("input:button").button();
            //$btn.prop('disabled', false);
            var Nro = <?php echo $T?>;
            if (Nro==1){
                $("#Ant").prop('disabled',true);
            }else if (Nro==1){
                $("#Sig").prop('disabled',true);
            }else{
                console.log("El registro actual es el "+ Nro);
            }
        }});
       return false;
});

Perhaps it cannot be manipulated in that way, I am talking about the line var Nro = <?php echo $T?>;I have also tried with json_encode ()and it does not work for me either. Is it a server side settings issue?