Is there a difference in the treatment between alt and title attributes for tags in terms of SEO implications? – SEO Help (General Chat)

First, to be terminologically clear, there is no such thing as an alt tag. It is an alt attribute within an img tag.

Secondly, title attributes are not considered important in the SEO rankings, as it can be easily spammed (you can put a title attribute on many different tags).

sql – Data modeling -Records that have tags across multiple categories

I have a table that stores different software services a company offer. The services are tagged by the Industry it serves, the LoB it belong to, and the technology involved in the service .
The service can have multiple tags on each of Industry,LOB and Technology.

For eg: Following colud be the master data:

enter image description here

And a transaction data could look like this :

enter image description here

I need to create a view that can query data by Industry/LoB and Technology tags. For time being I’ve Left outer joined all tagtoService relation tables(service-technology, service-LoB,Service-Industry tables) to the services transaction table. but this goes for a huge number of records as it is possible to typically have one service tagged to upto 10-15 industries and technologies.

Just wanted to know what is the optimal way to model this data so that i have provision to query for a service by all three tags in one view.

I am not a Data modelling expert and this is more of my first venturing into the data modeling side- so please pardon the noobness in my question :).
I use SAP HANA as the database and expose data via an oData service for which i want to provide the database view as a data provider.

javascript – Site dinâmico de acordo com tags UTM na url de origem

tenho uma landing page em bootstrap para anuncios de gooogle ads.
todos os grupos de anuncio geram uma ID na url atravez de tags UTM.
(exemplo https://dranimal.com.br/v4/veterinario.html?utm_content=102723745367&utm_term=&utm_campaign=campanha) em que ele gera uma id na url para cada grupo de anuncios. gostaria de alterar um texto no site de acordo com a utm que a pessoa chegar.

considerando que eu uso

function GetURLParameter(sParam)
{
    var sPageURL = window.location.search.substring(1);
    var sURLVariables = sPageURL.split('&');
    for (var i = 0; i < sURLVariables.length; i++)
    {
        var sParameterName = sURLVariables(i).split('=');
        if (sParameterName(0) == sParam)
        {
            return sParameterName(1);
        }
    }
}​

var grupo = GetURLParameter('utm_content');

como alterar a url paraa cada utm_content que tenho numa lista?

<a href="**>>>URL DINAMICA DE ACORDO COM A ID DO GRUPO DE ANUNCIO AQUI <<<<<<<**">Quero receber atendimento veteriário a domicílio</a>

EX:
se utm_content=77777 então, url do botão será xxx
se utm_content=88888 então, url do botão sera yyy
se utm_content=99999 então, url do botão será zzz

são pelo menos 12 grupos de anuncios.

php – Auto tagging wordpress products – Create and insert wordpress product tags programatically

This is something I’m trying to do..Trying since a month…still trying:

I have around 2500 products in my wordpress. No products have any tags. I am using the code below to insert PRODUCT_TITLE = PRODUCT_TAG

<?php
//Get WordPress Tables Prefix
global $wpdb;
$table_prefix = $wpdb->prefix;
//echo $table_prefix;

// Create Connection
$conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
else
{
//echo "Connection Established.";
}

//Query to Database
$sql = 'SELECT ID, post_title FROM '.$table_prefix.'posts WHERE LENGTH(post_title) > 5 AND  post_status="publish"';
$result = $conn->query($sql);
//Counting SQL Records
$count = $result->num_rows;
//echo $count;
//Limiting Returned Records
$lmSQL = 'SELECT ID, post_title FROM '.$table_prefix.'posts WHERE LENGTH(post_title) > 5 AND post_status="publish"';
$lmResult = $conn->query($lmSQL);
//Looping Through Returened Records
if ($result->num_rows >= 1) {
// output data of each row
while($row = $lmResult->fetch_assoc()) {
    //echo  . $row("post_title"). "<br>";
    $post_ID = $row('ID');
    $post_title = $row('post_title');
    $smpost_title = strtolower($post_title);
    //echo ''.$post_ID.' '.$smpost_title.'';
    //echo "<br>";
    
    //Check if Post Has Already Tags
    $posttags = get_the_tags($post_ID);
    
    if ($posttags) 
    {
        foreach($posttags as $tag) 
        {
            //If Tags Are Available, Do Nothing 
        }
        } 
            else
        {
    
    //Looping Returned Post Title for String Break and Words Length
    $string = $smpost_title;
    $arr = preg_split('/(, .;)/', $string);
    $keywords = array_unique($arr);
    $i=0;
    foreach ($keywords as $keyword){
        if ((preg_match("/^(a-z0-9)/", $keyword) ) && (strlen($keyword) > 3)){
                //echo $final_tags = ''.$keyword.'';
                $final_tags = ''.$keyword.'';
                //echo "<br />";
                $i++;
                if ($i==7) break;
                
                //Updating Post Tags
                //If Tags Are Not Available, Add Tags to It
                
                    wp_set_post_tags($post_ID, $final_tags, true ); 
            }   
        }
    }
} } 
//Closing Database Connection
$conn->close();

This code is working fine. But it just adds “ONE WORD” tag into posts.

But now i want to set multiple tag using product title with above code by rotating WORDS OF PRODUCT TITLE. (including 2 static words)

Ex. I have product name – ADIDAS FLEXIBLE SHOES and static words are BIG SALE

Above code just sets ADIDAS FLEXIBLE SHOES as product tag.

But i want many tags for a product like below (by spinning product title words + STATIC WORDS)

tag1 - ADIDAS FLEXIBLE SHOES BIG SALE
tag2 - SALE ADIDAS FLEXIBLE SHOES BIG
tag3 - BIG SALE FLEXIBLE SHOES ADIDAS
tag4 - SALE ADIDAS SHOES FLEXIBLE BIG
tag5 - BIG SHOES SALE FLEXIBLE ADIDAS

and all possible combination like if 5 words then 5 factorial combinations.

I really tried hard to reach here. and i hope i will cross the bar.

php – como fazer informação dinamica com tags utm de origem?

tenho uma landing page em bootstrap para anuncios de gooogle ads. todos os grupos de anuncio geram uma ID na url atravez de tags UTM. (exemplo https://dranimal.com.br/v4/veterinario.html?utm_content=102723745367&utm_term=&utm_campaign=campanha) em que ele gera uma id na url para cada grupo de anuncios. gostaria de alterar um texto no site de acordo com a utm que a pessoa chegar.

como usar o $_SERVER(‘HTTP_REFERER’) e após fazer várias variaveis de acordo com as id de grupos de anuncio?
EX:

se na url de origem contiver (id do anuncio 77777) então, url do botão será xxx
se na url de origem contiver (id do anuncio 88888) então, url do botão sera yyy

são pelo menos 12 grupos de anuncios.

como usar o $_SERVER(‘HTTP_REFERER’) e após fazer várias variaveis de acordo com as id de grupos de anuncio?

Role of Heading Tags

I am starting this thread because i see many websites (Specially in WordPress) that in theme H1 tags not available and theme is using H2 on place of H1 ….. and then other heading tags like H3, H4 etc.
SEMrush

So my question is If we are missing H1 and start to show our keywords with H2 then is it ok? According to me its not but heading tag show search engines our main keywords or keywords phrases. So what if we start to show our keywords from H2 and then for secondary keywords H3, H4 etc.

Note : And if we are putting H1 on place of H2 or want to add H1 tags additionally then site design is going bad a bit.

So what do you think about it ….. Is it ok to go with H2 to show search engines our main keywords?

 

php – How to enable HTML tags in category description without breaking the category page

I’m trying to include hyperlinks as part of the description on a category page.

Since WordPress strips the necessary HTML tags, I’ve added the following PHP code in a plugin, which stops the HTML tags from getting stripped:

add_action('init','disable_kses');

function disable_kses() {
    remove_filter('pre_term_description', 'wp_filter_kses');
    }

This lets me include HTML tags fine, but when I include a hyperlink in the description, it breaks the page in a weird way, with material from the description being reproduced above the header. This includes all the text from the first hyperlink until the end of the description, but the first link itself isn’t reproduced (only the text for it is). In addition, at the very end of the material, the following is appended to the text:

“>

Other than that, in the place where the description should appear (under the title), everything renders properly, including the hyperlinks.

The HTML that I use to include the hyperlinks is standard:

<a href="http://example.org/">example</a>

My question is what should I be doing differently in order to be able to include hyperlinks as part of the category page description?

plsql – Convert column value stripping html tags into sql view with rows and columns

I have a table named data with a column desc_data.
The value of this column is as below :

Row ID 1, Desc_data= <span class ="label">A</span><br> <span class ="value">A-Class</span> <span class ="label">B</span><br> <span class ="value">B-Class</span>.

Row ID 2: Desc_data= <span class ="label">A</span><br> <span class ="value">E-Class</span> <span class ="label">B</span><br> <span class ="value">F-Class</span>.
And so on….
The labels are constant for all rows which would become column headers. Values are changing with respect to labels..

I want to parse this column value,strip html tags and into a new view split it using sql query(Regexp_Replace maybe) such that:
All label values become columns, i.e.
<span class ="label"> A & <span class ="label">B become columns. And <span class ="value">A-Class and <span class ="value">B-Class becomes the column value respectively.

The actual data is much more with many labels and values however this is just sample to get help.
The expected result should be:

View data_View

Col name:ID  A          B
          1  A-Class    B-Class
          2  E-Class    F-Class