Posts by Dani

I'm attaching the image here so everyone can see the image without having to click on a third-party link (that might be deleted, etc. in the future).

It's not a weird item. It just is a link from within phpMyAdmin to create a new table in your database. If you click it, you'll be brought to the screen to name your table and decide what fields it should have.

OK, that's good. Sometimes you have a manual action penalty for keyword stuffing, in which case you have to file a request to have the penalty lifted.

If I understand you correctly, you're now on the first page for some of your keywords, and the second page for others? Depending on how often your webpage changes, Google adjusts how often it recrawls it. You can use search console to force Google to reindex the homepage.

You are preloding style version 1.02 but then loading stylesheet version 1.01, which is causing both files to be downloaded unnecessarily. You're doing something similar with Font Awesome in which you preload one URL for but then include a different one.

You also have JPG files that are being 301 redirected to other JPG files. Minimize, if not completely eliminate, all internal 301 redirects if you can help it.

I really think the keyword stuffing was causing you all your problems. Remove any and all keyword stuffing from every single page of your site.

Then, file a reconsideration request with Google Search Console. You're going to have to plea your case and ask for the penalty to be lifted. Do not do this until every single page of your site is no longer using any spammy SEO techniques.

Good luck!

I just took another look at your site and noticed you still have a lot more keyword stuffing going on. The bottom of your homepage looks like:

Kottayam Matrimony | Pathanamthitta Matrimony | Alappuzha Matrimony | Ernakulam Matrimony | Kannur Matrimony | Idukki Matrimony | Kollam Matrimony | Kozhikode Matrimony | Malappuram Matrimony | Thrissur | Thiruvananthapuram Matrimony | Wayanad Matrimony | Kasaragod Matrimony

I get that you want to have navigation to the different sections, but how many more times can you repeat the word Matrimony?! Remove all links that look like they're just anchor text.

In the About Mis Matrimony paragraphs, you have bold links that are anchor text there too. Remove all content that only exists for the benefit for SEO.

Then, once that's done, you can file a reinclusion request with Google Search Console.

Prototypes can be exported to HTML with the paid version, but unfortunately not with the free version. However, I believe (but might be wrong) that there's a free trial of the paid verison availabe.

Much better!!

The MySQL function UNHEX() "interprets each pair of hexadecimal digits as a number and converts it to a character". However, you're trying to store those characters in MySQL integer columns. Store them as varchars instead.

So I'm investigating your homepage now. It does look like you have javascript in place that disables right clicking when your webpage is loaded. This is horrible for accessibility, and Google probably doesn't like that you're doing this and is penalizing you for it.

I do see that you're using schema.org to describe your organization, so that's good. Google does like that you have a legitimate address, Twitter, LinkedIn, Facebook, etc. because it shows that you're a real company with a real social media presence.

The page title on your homepage does look like keyword stuffing, and Google absolutely hates that. Your page title shoudl be your company name, like BisMatrimony, with an optional tagline. By having your page title be a list of keywords, it's a bad user experience, and you're probably being penalized for it, if not delisted entirely. The same goes for your twitter:title and og:title in your meta tags.

I notice you have: <meta name="robots" content="index,follow,noodp,noydr">

I would remove the robots tag entirely, or else change it to <meta name="robots" content="all">. index and follow are not valid. You can use noindex or nofollow, but not index or follow. Also, you're probably sending Google mixed messages by saying you don't want to be included in the Open Directory Project or in Yahoo Directory.

Good job having rel preloads. That probably is helping page performance a bit.

Also, you don't have a ridiculous number of third-party javascript libraries that are super slow loading, so that is good as …

As such, wouldn't your teachers have such answers?

Unfortunately, very few front-end web developers take the time to learn and understand SEO enough to incorporate it into their HTML. As such, most SEO firms operate independently. My guess is that's the boat you are in ... you work for a web development firm and want to evaluate your options to the quickest path to incorporate SEO into what you do. If that's what's going on, GREAT! Not very many web development firms take SEO seriously, so just by asking this question, you're a step ahead.

The basics can be learned in just a couple of days, but the industry is constantly changing. SEO is all about following the latest trends and algorithmic changes to give Google what they're looking for. Considering there are 500+ Google algorithm updates every year, that means there's a LOT of moving parts. As rproffitt points out, it's not something that's "set it and forget it" or something that can be learned just once.

I baked pretzels today. Photo on my Twitter.

Why can't it be a web app (HTML, Javascript, etc.) instead of be limited to a mobile device?

Wow, crazy to think I posted this 5 months ago and the world is still exactly the same where I am. Still not leaving the house at all.

I'm not too good with regex, but if you're using jQuery, there's a built-in utility where you pass it an HTML string, and it converts that string to valid dom nodes for you to do what you want with. Hope maybe this will help with whatever it is you're trying to do.

Please start a new discussion asking your questin instead of "hijacking" this 7 year old topic.

For those of you unsure of what I'm talking about, I'm referring to https://www.seroundtable.com/google-update-was-glitch-bug-29923.html

There was a huge fluctuation in the SERPS yesterday that left a lot of people baffled by the unannounced algorithm ... until Google officially announced it was a bug that was rolled out.

Unlike just about everyone who commented on WW, SEW, etc., I actually fared well from it, until it was reverted, of course.

Do you think it's a sign of good things to come? Or that it's a sign that I'm on the wrong end?

Googlebot is crawling my AMP pages more than they are crawling my desktop pages. I have the appropriate canonical from AMP to desktop and amphtml from desktop to AMP. The desktop version also has a self-referencing canonical. Only canonical pages are in the sitemap.

This is a concern because less than 10% of our traffic is from mobile devices (unique, I know), yet it's more than 50% of our crawl budget.

The one thing that we do, which I'm not sure if this is appropriate or not, is whenever a desktop page 1 links to an internal page 2, the AMP version of page 1 links to the AMP version of page 2. Therefore, there are internal links pointing to AMP pages, but only from other AMP pages.

The other thing I was wondering is whether anyone has heard of Google serving AMP pages to desktop users behind low bandwidth connections, where they could benefit from AMP. Supposedly AMP doesn't have to be for only mobile anymore, but Google hasn't really demonstrated this. We don't get a lot of mobile traffic, but we do get a lot of third-world / low-bandwidth traffic.

Oh, also ... the pages are noindexed, although I do know the page needs to be seen by Google in order to see there's a noindex directive. I don't want to remove the pages from robots.txt because there's a lot of faceted navigation involved so it would eat up my entire crawl budget. That's why I thought that requesting a temporary removal would do the trick, but it hasn't.

I am trying to remove an entire folder of thin content from Google to help me recover from a Panda/EAT-related penalty. I want to keep the content on the site for the benefit of users, but not waste crawl budget or have Google think that we have so many pages of thin content.

I added the folder to robots.txt quite a few months ago. While some pages are showing up as "Blocked by robots.txt", the majority of pages now show up in my coverage report as "Indexed, though blocked by robots.txt". About 2 months ago, I submitted a removal request for all URLs that begin with the prefix, but there's been no change. Google Search Console's report updates every few days, but the number of URLs that say, "Indexed, though blocked by robots.txt" is increasing, even months after the removal request for those same pages.

Also, your question asks how you can select from these two tables using a single query. When selecting from multiple tables at once, the tables need to relate to each other somehow ... in other words, there needs to be a column in one table that matches up to a column in the other table. What do you envision the query result looking like in tabular format, that includes both users and courses? Are users taking courses? Is there a table of what courses each user is taking? Otherwise, what do users and courses have in common?

I have no experience with PDO but I'm pretty good at basic MySQL. Here is what I am understanding so far:

users table:
user_id
firstname
lastname
username
email

courses table:
cid
c_name
code
duration
start

However, I'm a bit confused what you're asking. When you have SELECT * you are retrieving all possible columns from that table. Therefore, each $row in $results already has access, not just to $row['cid'] and $row['c_name'], but to $row['duration'] etc. as well. The loop seems to be various options in a dropdown list. Can you explain where / how you want the user information to be printed within the loop?

... Additionally, when is uploadadv() called? When it runs, it overwrites all the HTML in the #messageeditcheckadv element. Is the dropdown inside that element?

You have the code onkeydown="IgnoreAlpha(event);" to run the IgnoreAlpha() function on a key down event on the select. Can you show the code for IgnoreAlpha()? Thanks!

This appears to just be a homework question. Do you have a question about it? Where are you stuck? How can we help you? Please provide your code along with any errors you're having or where you're stuck so we can try to help.

Also ... that's how I started DaniWeb 20 years ago! I turned my class notes into tutorials and published them and they became popular and the rest is history.

Record your teachers, with their permission of course. Learn how to use video and sound editing apps. Create fun little videos that will help you and other students learn lessons or use them to study with. Publish them on Youtube. Make money from Youtube ads.

The bottom of the article I linked to in my previous post says:

Just to be clear, Google Guaranteed is not new, it has been around for years. What is new is this $50 per month subscription package that businesses can buy to get Google Guaranteed and possibly other services from Google.

So it seems like it's a pay-to-play type thing. This errily reminds me of what made Google so great in the first place back in the very early 2000s. At the time, GoTo.com was the first pay-per-click search engine, where companies could bid a couple of cents to be listed higher up in the search results. The idea really caught on with some other search engines at the time. Google stood out in that they offered an AdWords PPC model that put the paid ads off in the sidebar, making money from ads, yet clearly differentiating what was paid from what was organic listings. To me, this feels as if Google forgot their beginnings, allowing businesses to buy their way into getting a badge that they didn't earn organically.

While researching ideas to improve crawl budget, I stumbled upon this article over at Search Engine Land.

It alludes to the idea that:

Google bot may assume you've made a mistake if you disallow lots of content or if a restricted page receives a lot of incoming links and it may still crawl these pages.

In other words, because our robots.txt is rather large, and blocks a significant chunk of our pages, Googlebot may think that we made a mistake and didn't mean to block so much content, so they're ignoring our robots.txt in an effort to do what they think is in our best interests.

However, it's possible the author of the article misspoke, and is confusing crawling with indexing. It's well known that if a restricted page receives a lot of incoming links, it may still be indexed albeit not crawled. In such cases, the naked, description-less links will show up in the Google search results for highly relevant searches.

You mention you have a question? I see you’ve posted your homework assignment, but what is your question about it?

We won’t just do your assignments for you. Please post the code you have so far along with where you’re stuck, and we’ll help you to learn.

Time for Google's own to give up ideas.

This isn't the type of thing that Google representatives will officially comment on. This is the type of thing that's often asked and discussed ad nauseam within SEO forums such as this one, WebmasterWorld, BlackHatWorld, DigitalPoint, etc. :)

And be careful of SQL injection attacks! Always escape any variables containing user-entered data before including them in your SQL queries.

Yes, please show us the code you already have so we can see where it is that you're stuck. Is this a homework assignment that doesn't allow you to use the sum function?

I have no experience with RevGlue. A long time ago CommissionJunction (CJ) was the big player.

I would recommend you check out Affiliate Summit if you aren't already familiar with them.

Good luck!

If I remember correctly, you have to use Adobe's proprietary Typekit in order to use their fonts on the web. You have to continuously pay for a Typekit license for as long as the font is in use on the web, according to their licensing.

https://helpx.adobe.com/support/fonts.html

Hi there and welcome to DaniWeb. I have over 20 years of SEO experience so feel free to ask any questions and I'll do my best to answer them.

It looks like you're outputting a binary string (a PDF, perhaps?) but you're not setting the proper HTTP header.

What happens if, right above line 81 in the code above, where you call Output(), you do: header('Content-Type: application/pdf');

Looks to be that a post was created in the database and then rolled back, because the transaction failed for one reason or another. I'll inspect the server log in a bit to see if I can figure out why the query didn't go through.

It would probably help if you let us know why you wanted to do it in a less performant way, using a subquery? This is thoroughly untested, but I guess you could do something like:

UPDATE books
SET location_id = 2
WHERE location_id IN (
    SELECT location_id
    FROM books
    WHERE location_id = 4
)

It's normal for www and non-www versions of your site to have different page authority. After all, links often point to one or to the other.

It's important to choose the canonical version ... the version that you consider the primary, and to do your best to have all links pointing just to that one version.

If you're unable to do a server-side 301 redirect from the non-canonical version to the canonical version, then the second best thing to do is add rel="canonical" meta tag to the top of both, pointing to the version you consider the canonical version.

Good luck, and let me know if you need more help with canonicals.

One word. Wordpress.

Welcome!!

Hi there and welcome to DaniWeb!!

I don't know Python but I do have a lot of experience with MySQL. Does it work if you're not trying to insert BLOB content? Is the MySQL column set to the right data type?

Do you have an app in mind? You can make money by selling your app in the app store. You can use a freemium model where the app is downloaded for free but then users pay for upgrades and premium features. Or you can sell advertising within your app.

Hi there! Welcome to DaniWeb.

Hi there. Welcome to DaniWeb. How did you find out about us?

You mean by using an SSL certificate so that the website is accessible via https:// and not just via http:// ??

Hi there. Nice to meet you!

BTW: can your CSS be used outside of DW?

I guess so although I’m not sure of any use cases for it. Due to trademarks, the same purple color scheme / logo style can’t be used by another tech forum.

Fixed.