It is not possible to change the order of sitelinks, it adjusts as the user needs, usually targeting the most searched or most searched links previously by the user, which may vary greatly as the asset of the Google searcher changes, as I replied https://pt.stackoverflow.com/a/70395/3635

According to propria https://support.google.com/webmasters/answer/47334?hl=pt :

Exhibit sitelinks of results only when we think they can be useful to the user. If your site structure does not allow our algorithms to locate good site links or if you find that the links to your site are not pertinent to the user query, we will not display them.

At the moment, the sitelinks are automated. We are constantly working to improve sitelink algorithms. It is possible that in the future we will incorporate suggestions and information provided by webmasters. However, there are best practices that can be followed to improve the quality of your sitelinks. For example, for the internal links of your site, use anchor texts and texts with informative, compact and non-repeated alt attribute.

That is the part that speaks:

It is possible that in the future we will incorporate suggestions and information provided by webmasters.

She claims that perhaps in the future the webmaster (you) can do something to control the links/suggestions, but so far sitelinks are automated.

It is also worth noting that the sitelinks are only displayed as the algorithm finds necessary/useful to the user. That is may even show, but the sitelinks may vary for each user, showing what the algorithm believes to be useful for each specific user.

The method query() of PDO does not support statements prepared. When passing placeholders to the insert they will be understood as strings.

To use prepared statements the first step is to call the method prepare() and then excute() passing the array with the values for the placeholders.

Change:

 $resultado = $db->query("INSERT INTO tb_exercicios(enunciado,pergunta,resposta1,resposta2,resposta3,respostacorreta,unidade) VALUES(:ENUNCIADO, :PERGUNTA, :RESPOSTA1, :RESPOSTA2, :RESPOSTA3, :RESPOSTACORRETA, :UNIDADE)",array(
                        ":ENUNCIADO"=>$Enunciado,
                        ":PERGUNTA"=>$Pergunta,
                        ":RESPOSTA1"=>$resposta1,    
                        ":RESPOSTA2"=>$resposta2,    
                        ":RESPOSTA3"=>$resposta3,    
                        ":RESPOSTACORRETA"=>$respostacorreta,    
                        ":UNIDADE"=>$unidade
                    ));

To:

$resultado = $db->prepare("INSERT INTO tb_exercicios(enunciado,pergunta,resposta1,resposta2,resposta3,respostacorreta,unidade) VALUES(:ENUNCIADO, :PERGUNTA, :RESPOSTA1, :RESPOSTA2, :RESPOSTA3, :RESPOSTACORRETA, :UNIDADE)");
$sucesso = $resultado->execute( array(":ENUNCIADO"=>$Enunciado,

":PERGUNTA"=>$Pergunta,

":RESPOSTA1"=>$resposta1,

":RESPOSTA2"=>$resposta2,

":RESPOSTA3"=>$resposta3,

":RESPOSTACORRETA"=>$respostacorreta,

":UNIDADE"=>$unidade));
if(!$sucesso){

echo '<pre>';

print_r($resultado->errorInfo());

}

I'm having an exercise to work out and I'm having some trouble.

This is the statement of the problem:

Again print the names of the students by order of enrollment, but only those whose initial letter is different from “T”.

That's my code.

$nomes = array('andre' => 1 , 'paulo' =>5, 'fabio' => 2,'tiago' => 4);
asort($nomes);
foreach ($nomes as $key => $value) {
  echo 

I read the PHP manual and checked the various functions for string. I tried some of them like count_chars(), str_word_countwithout success. Someone can give me a hand and explain if possible where I'm making the mistake and what would be the right function.

how do I get redirected to the "href" and not to the "value"?

Follow the code.

<form>
<input list="categorias" type="text" placeholder="O que você procura?" >
<datalist id="categorias">
<option value=" "> </option>

<option value="JOGOS"><a href="jogos.html"></a></option>

<option value=" "> </option>

<option value="PS4"><a href="PS4.html"></a></option>

<option value="PS3"><a href="PS3.html"></a></option>

<option value="Xbox One"><a href="xboxone.html"></a></option>

<option value="Xbox 360"><a href="xboxone.html"></a></option>
<option value=" "> </option>

<option value="Consoles"><a href="jogos.html"></a></option>

<option value=" "> </option>

<option value="PS4"><a href="consolesps4.html"></a></option>

<option value="PS4 PRO"><a href="consolesps4pro.html"></a></option>

<option value="Xbox One"><a href="consolesxboxone.html"></a></option>

<option value="Xbox One X"><a href="consolesxboxonex.html"></a></option>
</datalist>
<input type="submit" id="categorias" value="Procurar"/>
</form>

I have a view where I have dynamically generated selects and a link. I need you to click on the link <a id="add-cart" href="{{ route('site.add.cart', $product) }}" class="btn btn-danger mt-5">Adicionar ao Carrinho</a> it check that the selects are selected. It is working as expected, but the mandatory field notice appears at the end of the selects instead of one in each select

<div class="pages-header">
<div class="container">
    <h1 class="text-center pages-title">{{ $product->name }}</h1>
</div>
</div>
<div class="container">
<section>
    <div class="row">
        <div class="col-lg-3">
        <aside>
            <ul class="list-group pt-5 pb-5">
                <h5 class="text-uppercase font-weight-bold">Categorias</h5>
                <li class="list-group-item d-flex justify-content-between align-items-center list-aside-products">
                    <a href="{{ route('site.products') }}">Todos</a>   
                    <span class="badge badge-secondary badge-pill">{{ $productsCount }}</span>
                </li>
                @foreach($productCategories as $productCategory)
                    <li class="list-group-item d-flex justify-content-between align-items-center list-aside-products">
                        <a href="{{ route('site.product.category', $productCategory) }}">{{ $productCategory->name }}</a>   
                        <span class="badge badge-secondary badge-pill">{{ $productCategory->products->count() }}</span>
                    </li>
                @endforeach
                <h5 class="text-uppercase font-weight-bold pt-5">Subcategorias</h5>
                <li class="list-group-item d-flex justify-content-between align-items-center list-aside-products">
                    <a href="{{ route('site.products') }}">Todos</a>   
                    <span class="badge badge-secondary badge-pill">{{ $productsCount }}</span>
                </li>
                @foreach($subcategories as $subcategory)
                    <li class="list-group-item d-flex justify-content-between align-items-center list-aside-products">
                        <a href="{{ route('site.product.subcategory', $subcategory) }}">{{ $subcategory->name }}</a>  
                        <span class="badge badge-secondary badge-pill">{{ $subcategory->products->count() }}</span>
                    </li>
                @endforeach
                <h5 class="text-uppercase font-weight-bold pt-5">Marcas</h5>
                <li class="list-group-item d-flex justify-content-between align-items-center list-aside-products">
                    <a href="{{ route('site.products') }}">Todos</a>   
                    <span class="badge badge-secondary badge-pill">{{ $productsCount }}</span>
                </li>
                @foreach($brands as $brand)
                    <li class="list-group-item d-flex justify-content-between align-items-center list-aside-products">
                        <a href="{{ route('site.product.brand', $brand) }}">{{ $brand->name }}</a>  
                        <span class="badge badge-secondary badge-pill">{{ $brand->products->count() }}</span>
                    </li>
                @endforeach
                <h5 class="text-uppercase font-weight-bold pt-5">Opções</h5>
                <li class="list-group-item d-flex justify-content-between align-items-center list-aside-products">
                    <a href="{{ route('site.products') }}">Todos</a>   
                    <span class="badge badge-secondary badge-pill">{{ $productsCount }}</span>
                </li>
                @foreach($options as $option)
                    <li class="list-group-item d-flex justify-content-between align-items-center list-aside-products font-weight-bold">
                        <p class="mb-0">{{ $option->name }}</p>  
                    </li>
                    @foreach($option->optionValues as $optionValue)
                        <li class="list-group-item d-flex justify-content-between align-items-center list-aside-products ml-3">
                            <a href="{{ route('site.product.option.value', $optionValue) }}">{{ $optionValue->value }}</a> 
                            <span class="badge badge-secondary badge-pill">{{ $optionValue->products->count() }}</span>
                        </li>
                    @endforeach 
                @endforeach
            </ul>
        </aside>
        </div>
        <div class="col-lg-9 mt-5">
            <div class="row">
                <div class="col-lg-6">
                    @foreach($product->images as $image)
                    <img src="{{ asset('storage/' . $image->name) }}" class="img-fluid" alt="Responsive image"> @break @endforeach
                    <div class="row">
                        @foreach($product->images as $image)
                        <div class="col-4 mt-5">
                            <img src="{{ asset('storage/' . $image->name) }}" class="img-fluid" alt="Responsive image">
                        </div>
                        @endforeach
                    </div>
                </div>
                <div class="col-lg-6">
                    <div class="row">
                        <div class="col-12 select-option">
                            @foreach($product->options as $option)
                                <label>{{ $option->name }}</label>
                                </br>
                                <select class="form-control option" name="option">
                                    <option value="">Selecione</option>
                                    @foreach($product->optionValues as $optionValue) 
                                        @if($optionValue->option_id == $option->id)
                                            <option value="{{  $optionValue->id }}">{{ $optionValue->value }}</option>
                                        @endif 
                                    @endforeach
                                </select>
                            @endforeach
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-12 offset-lg-8">
                            <h3 class="card-text mt-5">R$ {{ number_format($product->price, 2, ',', '.') }}</h3>
                        </div>
                        <div class="col-12 offset-lg-6">
                            <a id="add-cart" href="{{ route('site.add.cart', $product) }}" class="btn btn-danger mt-5">Adicionar ao Carrinho</a>
                        </div>
                    </div>
                </div>
                <div class="col-lg-12">
                    <div class="ml-3 mt-5 mb-5">
                        <h4 class="card-title">Descrição</h4>
                        <p class="card-text">{!! $product->description !!}</p>
                    </div>
                </div>
                <div class="col-lg-12">
                    <div class="ml-3 mt-5 mb-5">
                        <h4 class="card-title">Atributos</h4>
                        @foreach($product->attributes as $attribute)
                        <p class="card-text">{{ $attribute->name }}: {{ $attribute->value }}</p>
                        @endforeach
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<script>
$("#add-cart").click(function(event) {
    $(".option").each(function(i, v) {
        if($(this).val() == '') {
            event.preventDefault();
            $(this).addClass("parsley-error");
            $(".select-option").append('<ul class="parsley-errors-list filled" id="parsley-id-10"><li class="parsley-required">Campo obrigatório.</li></ul>');
        } else {
            $(this).removeClass("parsley-error");
        }
    });
}); 
</script>

I need the return of a date if it is "Null" in the BD to return another date or another given that it is not "Null".

I'm passing the data from some inputs to a modal, I'm doing it with jquery, until ai blza, more accurate the data that were sent and use them in a mysqli query, my doubt as I pass the values sent by jquery to php variables and so use them in my query?

Form:

<form class="form-horizontal" action="data/form_cadastra_devolucao.php" method="POST">
    <input type="hidden" id="cliente" name="cliente" value="<?php echo $cliente ; ?>">
    <input type="hidden" id="nome"    name="nome"    value="<?php echo $nome ; ?>">
    <div class="comtainer">
        <div class="row">
            <div class="col-md-6">
                <label for="data">Data:</label>
                <input type="date" class="form-control" id="data" name="data" required>
            </div>
        &lt;div class="col-md-6"&gt;
            &lt;label for="loja"&gt;Loja:&lt;/label&gt;
            &lt;select class="form-control" id="loja" name="loja" required&gt;
                &lt;option &gt;&lt;/option&gt;
                &lt;option value="1"&gt;1&lt;/option&gt;
                &lt;option value="2"&gt;2&lt;/option&gt;
                &lt;option value="3"&gt;3&lt;/option&gt;
                &lt;option value="4"&gt;4&lt;/option&gt;
            &lt;/select&gt;

        &lt;/div&gt;
    &lt;/div&gt;
&lt;/div&gt;
&lt;br&gt;
&lt;div class="row"&gt;
    &lt;div class="col-md-6"&gt;
        &lt;label for="pdv"&gt;Pdv:&lt;/label&gt;
        &lt;input type="text" class="form-control" id="pdv" name="pdv" required&gt;   
    &lt;/div&gt;
    &lt;div class="col-md-5"&gt;
        &lt;label for="cupom"&gt;Cupom:&lt;/label&gt;
        &lt;input type="text" class="form-control" id="cupom" name="cupom" required&gt;
    &lt;/div&gt;
    &lt;div class="col-md-1"&gt;
        &lt;a data-toggle="modal" href="#modalItensCupom"&gt;VALIDAR&lt;/a&gt;
    &lt;/div&gt;
&lt;/div&gt;
&lt;br&gt;
&lt;label for="motivo"&gt;Motivo:&lt;/label&gt;
&lt;textarea class="form-control" rows="5" id="motivo" name="motivo"&gt;&lt;/textarea&gt;
&lt;br&gt;
&lt;button type="submit" class="btn btn-primary" style="float: right;"&gt;&lt;span class="glyphicon glyphicon-ok"&gt;&lt;/span&gt; CADASTRAR&lt;/button&gt;

</form>

Modal:

<!-- Modal -->

<div class="modal fade" id="modalItensCupom" role="dialog">

<div class="modal-dialog">

    &lt;!-- Modal content--&gt;
    &lt;div class="modal-content"&gt;
        &lt;div class="modal-header"&gt;
            &lt;button type="button" class="close" data-dismiss="modal"&gt;&amp;times;&lt;/button&gt;
            &lt;h4 class="modal-title"&gt;CUPOM &lt;div id="rcupom"&gt;&lt;/div&gt;&lt;/h4&gt;
        &lt;/div&gt;
        &lt;div class="modal-body"&gt;
            &lt;p id="rdata"&gt;&lt;/p&gt;
            &lt;p id="rloja"&gt;&lt;/p&gt;
            &lt;p id="rpdv"&gt;&lt;/p&gt;
            &lt;p id="rcupom"&gt;&lt;/p&gt;
        &lt;/div&gt;
        &lt;div class="modal-footer"&gt;
            &lt;button type="button" class="btn btn-default" data-dismiss="modal"&gt;Fechar&lt;/button&gt;
        &lt;/div&gt;
    &lt;/div&gt;

&lt;/div&gt;

</div>

Jquery:

<script type="text/javascript">

;(function($) {

$('#modalItensCupom').on('show.bs.modal', function() {

var idata  = $("#data").val();

var iloja  = $("#loja").val();

var ipdv   = $("#pdv").val();

var icupom = $("#cupom").val();

        $( '#rdata' ).text( idata );
        $( '#rloja' ).text( iloja );
        $( '#rpdv' ).text( ipdv );
        $( '#rcupom' ).text( icupom );
    });
}(jQuery));

</script>

With is application/x-www-form-urlencoded you will have to send this way:

 String params = "gran_type="+client_credentials+"&client_id="+CLIENT_ID+"&client_secret="+client_secret;
        byte[] post = params.getBytes( StandardCharsets.ISO_8859_1);
        URL url = new URL(URLEncoder.encode("https://api.myapi.com.br/api/oauth/token?", "ISO-8859-1"));
        HttpsURLConnection http = (HttpURLConnection) url.openConnection();
        http.setDoOutput(true);
        http.setDoInput(true);
        http.setFollowRedirects(false);
        http.setRequestMethod("POST");
        http.setRequestProperty("Content-Type", "application/x-www-form-urlencoded"); 
        http.setRequestProperty("charset", "ISO-8859-1");
        http.setUseCaches(false);
    try(DataOutputStream output = new DataOutputStream(http.getOutputStream())){
        output.write(post);
    }

I have some doubts about how to practice SEO. It's probably not just me with those doubts. I know there are a lot of articles on seo here, I did search for the site and I didn't get anything clarified because actually, I have doubts even is how to do SEO in Practice. I leave down some doubts:

• On a dynamic site, like a blog, whenever I create a post I have to manually index the links in google webmaster tools?
• How do I know when my post link was indexed on google?
• I submit a sitemap. xml, after a few days he's already outdated right? Do I have to submit this sitemap with some regularity or will google sweep in order to keep up to date?
• What free tools/software can I use?
• When you talk about betting on a Keyword, how's that? Every time I publish a post I have to put the same key word?
• 200? What is it? How to do correctly?

I'm sorry for my ignorance, but I'm a little lost. If anyone could help, I'd really appreciate it.

Thank you.

you can use the https://github.com/axios/axios or https://github.com/visionmedia/superagent to make requests in any API from within your nodejs code