Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Or there’s also watched topics. You can click the little eye in the first post of any thread to watch/unwatch a topic.

From your member profile, you can choose whether to automatically watch topics you post in. You can also choose whether to receive an email when there is a new post in a topic you’re watching.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Click the little hamburger icon to the left of the DaniWeb logo to open the sidebar.

In the Your Content Finder section, click Topics and Posts.

You can add your own tags as well, but you need to have more than a few posts to make up your own words to prevent spamming. Moderators may delete/retag if they don’t make sense for the benefit of the community.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

When I was in school, we were required to use Turbo C++. However, it was 1997 at the time.

rproffitt commented: It was 1972 and my first programming as on a GE 210. Assembler, paper tape, core memory, switches. +15
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Sometimes you need to delete duplicate rows in a database :)

In the future, set UNIQUE keys when you need them :)

In the example below, we have a table appropriately named TABLE_NAME and there are multiple rows that have the same value for the duplicate_field field. In this example, we want to remove the ones where the id field is set to "remove". In other examples, you can pick any conditional you want when choosing which of the rows to remove or which to keep, including conditionals between them (e.g. foo.id < bar.id will keep the row with the highest id value and delete the others).

Alternatively, if you do want to add that UNIQUE index, you can do the following to brute force dropping duplicate rows:

ALTER IGNORE TABLE TABLE_NAME
ADD UNIQUE INDEX index_name (duplicate_field);
dshort501 commented: cool +0
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I know it’s been a long time coming, but better late than never. In your control panel, you can now choose to hide your location from others in your member profile.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

localhost and 127.0.0.1 should point to the same location. 127.0.0.1 is the IP address for localhost, your local machine.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I'm the founder of DaniWeb. Here's my about me

Ask Me Anything!! :)

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I just spent way too long realizing that by setting the boundary property for Twitter Bootstrap popover Javascript to viewport (I believe it's parent element by default), it gets rid of the flickering issue I was having with popovers triggered on hover. If anyone else is having that problem, this fixes it. :)

data-toggle: popover
data-container: body
data-boundary: viewport
data-trigger: hover focus
rproffitt commented: Excellent. That flickering was showing for me a lot. Thank you, thank you, thank you. +0
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I recall it worked a year ago but over the last few months discussions I could find with a "word" no longer show on the first page if at all.

What was the word you're thinking of?

rproffitt commented: If the word comes back to me I'll be sure to tell you. For now it's lost to me as well as Google. +15
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Get them on the first 10 search results.

As a developer, the best thing I can liken this question to is it being the equivalent of someone asking, "How can I ensure I create a bug-free program?" Your answer would be some mixture of, "Become a seasoned programmer, write elegant code, organize your code into digestable components, etc." It's entirely plausable to work towards creating a bug-free program, but all the specific techniques to achieve it are things that could be construed as entirely subjective, and essentially boil down to "become a seasoned programmer".

The answer to this question is the same exact thing. The goal of any SEO campaign is to work on being in the top 10 results. Seasoned SEOs are more familiar with what the formula is to achieve this, and the formula is different depending on the keywords being targeted you want to rank for. How to choose which keywords to rank for is a part of the job of any good SEO. I guess the best way I can answer this question is to just keep reading the forums, following SEO blogs, practicing SEO, and getting better, and it's a skill you can eventually learn.

Do this in a few days or one week.

Search engine optimization is broken up into two components: on-page SEO and off-page SEO. Off page SEO is the stuff you have no control over ... which mostly boils down to links from other sites. To build …

rproffitt commented: Thanks for expanding here. There's a lot to take in here, much like "a sip from the fire hose." +15
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

It matters a ton from personal experience. DaniWeb is an English-based site but unfortunately most of our back links are not on English websites. The result is most of our organic traffic originates from non-English speaking countries.

alexandrap commented: I think SEO will never die. But It will be more complicated. Nowadays google search engine shows various ads on search pages. Still analysing th +0
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

It depends who you’re targeting (niche audience, geo, etc) and what keywords you’re targeting.

I use organic and PPC to target completely different audiences.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Google has actually come out and said that incorporating schemas does not affect your rank in the organic serps, outside of being in the answer box and having expanded results. Not sure I believe that one.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Try using full paths (beginning with https://...) in the header redirects.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Did that work?

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I didn’t get a chance to read all your code but stop using preventDefault if you want it to execute the jQuery as well as the normal form submission.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

By PPC engine do you mean PPC ad network? And for you being in the capacity of a publisher?

Years ago I knew a whole bunch offhand but most of them probably don’t exist anymore (Chitika, for example), and I’m typing on my phone. I’ll look into this later.

In the meantime try doing a quick google search for “ad network for Blogspot” since blogspot urls are in the form of name.blogspot.com

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

There is no reason to use a timeout because the document.ready() function waits until the DOM is ready before executing.

What if you just did something like this:

<script>
 $(function () {
          $(".start-tour").trigger('click');
      });
</script>
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Memcached is simpler, faster, and has less overhead. I use it to cache large portions of pre-generated HTML to reduce the amount of PHP and MySQL that needs to execute to build a page. I use Memcached when there’s absolutely nothing to lose if it ejects a key too early and I just need it to cache long strings of content to save a few milliseconds from page loads.

I use Redis when I need to take advantage of its ability to store volatile data objects in a fast and reliable way, such as to store user session data, API tokens, etc. In such cases, I use Redis as the primary database because MySQL is not performant for us when working with active sessions, and file based sessions (PHP native sessions) are slower over the network when being accessed by multiple web servers than our Redis server is.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Sorry for posting so many times in a row, but just to clarify ...

  • In the left sidebar, click 'Coverage' under the Index section
  • Click 'Excluded' to filter pages excluded and then click 'Error' if it's selected to un-filter
  • For each category in the Details section, click the category, and then take a screenshot of the links it shows
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

When you get a chance, please let me know what that report says. That should answer all your questions :)

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Post comments are now sorted oldest to newest.

Reverend Jim commented: Thanks. +0
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Way too many reasons.

Yes, there are lots of reasons. But luckily Google Search Console does provide some tools to give us insight into what those reasons might be so that we can get to the bottom of it and correct the problem.

The second article rproffitt linked to suggests exactly what I posted above, which is noindex errors.

But, yeah, the Coverage section of GSC should give you some insight into what all the pages that are indexed have in common and what all the pages that are not indexed have in common.

If you'd like, export the results of the Coverage and Sitemaps reports here so I can take a look myself and come up with something actionable for you to do.

rproffitt commented: Thanks. I'm still learning about that console. +15
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Look in the Coverage and Sitemaps section to see if you have pages that have inadvertently been noindexed. If you break your site up into multiple sections each with their own sitemap file, you can narrow it down to which sections Google is not liking.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

This page keeps crashing on my iPhone, both in Mobile Safari as well as Chrome.

https://www.daniweb.com/connect/developers/endpoints

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

It's rather simple ... just get and set.

Basically ...

$result = $cache->get('key');

if ($result === false)
 {
     $result = mysql_query($key);

     $cache->set('key', $result);

 }

  echo 'The result is: ' . $result;
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I'm trying to read your code but I'm not sure what bootstrapValidator does? It seems this is a third-party plugin. Unfortunately, it's not possible for us to debug your code because the bug seems to either be within the bootstrapValidator function or a bug with the way you are sending your data to it.

Do you have a link to bootstrapValidator for us to investigate?

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I thought the wording made sense because when I think of participants of a chat room, I think of how many people are in the room listening. Not necessarily how many people have spoken up over the past X minutes/hours.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

RuMedia, I think what the OP is saying is that he’s aware of that, but he doesn’t mind if they go stale.

What I do is I use an in memory cache such as Memcached (non-persistent) or Redis (persistent) where I store the results of the query for up to X minutes. They are both key-value pair caches. I then query memcached unless there’s a miss in which case I query the database again.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

188 members are enrolled in the group and will receive a notification if you send a message to the group. Sorry for the misleading wording. 188 members aren't actively sending messages. 188 members are "listening in" in the chat room.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

You find folk that think they have a gold mine rarely want to talk about the mine's location, operations and such.

Ahh, which is why I expanded the DaniWeb feature-set to include private one-on-one mentorship while still keeping these users within the DaniWeb brand. See what I did there? :)

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Sorry, I guess I’m not understanding what you’re saying. What do you mean if I think you can edit an external homepage so people will buy the book? Sorry but I don’t know what you mean by that?

rserhatduygun commented: I mean to convince people in writing or visually to buy the file to be sold. +0
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I think the reason you haven't received too many responses is because you're question is basically talking about this sophisticated app that searches various fields in a database with filtering, and the code you provided just connects to the database server, so it's hard to know what exactly you're asking or where you're stuck.

However, I would highly, highly suggest you use a PHP templating engine because having php code intermingled within your HTML code gets really confusing really quickly.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I don't know anything about angular, but I believe it needs to be compiled. I don't know how to do this as I have no angular experience, but is there a reason you chose an angular template?

This tutorial should help you get started with compiling your angular code into javascript that your browser can interpret.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Hi there! Nice to virtually meet you.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Just want to chime in ... We initially discussed the idea of a multi-threaded system where you could comment on comments of comments, etc. However, doing so would take a massive restructuring of our platform and I'm not so sure that it would result in immediate benefits that were worthy of the time it took. Basically deciding to go that route would require some type of proof of concept that there would be a return on my time investment.

In terms of having comments hidden by default, it wouldn't be a massive coding effort, but I'm not really sure I understand the benefits. Not enough people comment on posts to make discussions hard to read. I think that I can see the idea of comments posted by newbies or "untrustworthy" members being hidden by default, but I'm not so sure I see strong benefits to make all comments hidden by default.

Thoughts??

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

When you include an image in the post, it shrinks it down. Here's the original.

https://static.daniweb.com/attachments/0/d280b511ad5b908abe08570148fcd9b2.jpg

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

then you have robots not really understanding what you are doing (I wouldn't be supprised if search engines couldn't conclude that such a site is "mobile friendly")

The Javascript only triggers on desktops. As mentioned, the core CSS that is common between desktop and mobile is always loaded. Then, desktop browsers additionally use JS to load CSS that is only used in desktop features. Google seems to perfectly recognize that we are mobile friendly, according to Google Search Console.

Adaptive and then responsive is easy , you do it server side with a class (I could share with you mine in PHP or in a PHP extension in C++ , but there are many out there) that you can detect if it is mobile / tablet or desktop and serve the apropriate files in View (templates , js , css , images) .

The issue with this approach is it tends to be based on useragents. This doesn't take into consideration browser window size, and, more importantly, can be considered cloaking, which is a black hat SEO technique. Google defines cloaking as the web server serving different content depending on the user agent, referrer, etc. For this reason, they have come out and said that they do not want sites to use https://m.example.com etc where mobile experiences are served via a different subdomain, etc. They recommend to always use a responsive layout, which means that the difference between desktop and mobile always be handled clientside. …

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I'll mark this thread solved since it's now understood why this functionality doesn't exist, and I was able to use Javascript to achieve the desired result, such that the CSS common to both desktop and mobile is included in static HTML, and then javascript which checks the resolution is used to dynamically inject the additional CSS that the full desktop experience requires.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Use next-gen image formats. Photos should be JPEGs, animated images should be GIFs, icons and vectors that need to scale should be SVGs, and everything else shoudl be PNGs.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

So I realized after I posted this last night that device width can be changed simply by rotating your tablet (changing the orientation between portrait and landscape) or changing your desktop resolution, neither of which are much of edge cases at all really.

rproffitt commented: Much better examples than mine. +0
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

So I googled it and came to the conclusion the reason that both files are downloaded, albeit the rules in one of them are completey ignored, is because the browser size can be adjusted after the fact, so the browser needs to know the contents of the file at page load to accomidate window resizing. I tried changing to max-device-width and min-device-width since, surely, the device width can't change willy nilly, but unfortunately it still downloaded both.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

I'm trying to use CSS as so:

<link rel="stylesheet" media="screen and (max-width: 991.98px)" href="/files/mobile_css/daniweb.css" type="text/css">
<link rel="stylesheet" media="screen and (min-width: 992px)" href="/files/css/daniweb.css" type="text/css">

I want to load one CSS file for our mobile layout and a different one for our desktop layout. The problem is the web browser always downloads both files, which completely eliminates the performance advantages of having a more lightweight mobile CSS.

What I'm thinking of doing is using a <link rel> to download all of the CSS that's common between mobile and desktop. Then, conditionally, via javascript, injecting CSS via @import (I guess?) to load the additional CSS that the desktop requires. Pretty obnoxious, no? Is there a better way? And why aren't web browsers smarter here?

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

My guess is the reason you haven't gotten any responses to this thread so far is because you really have only done the very, very, very bare minimum SEO.

Inspecting your site (my guess is your site is the one you link to in your forum signature), you have a ridiculous amount of Javascript plugins. You also call the jQuery library twice in a row. I suggest you fix those issues and that will increase your website's performance, and, in turn, you will see SEO benefits.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Does anyone have any experience using Ezoic to increase site speed? Namely ...

  • Is their site speed increase predictor accurate?
  • Does complicated Javascript still work perfectly? What are the trade-offs?
  • What is their pricing?! It says it's based on traffic, once the free trial ends, but I can't find anywhere that actually says what the actual pricing is
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

There is an error in your MySQL query.

Firstly, it's important that you escape all of the variables pulled in via $_POST before inserting them into the database to prevent MySQL injection errors. Please look into https://www.php.net/manual/en/mysqli.real-escape-string.php

rproffitt commented: Thank you for mentioning SQL injection here. +15
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

A new Daniweb home/top page.

Link me to content you wish was on the homepage for you but isn't. I guess I'm just of the belief the reason there isn't a lot of quality content presented on the homepage is because there just isn't a lot of quality content on the site as a whole nowadays.

rproffitt commented: Happy New Year to you as well. I think I'll make a top post about this. +0
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Either it can’t connect to the database or there is an error in the SQL query. The query is failing for some reason or another.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Hi there! Welcome to DaniWeb.

Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member

Welcome back!! I’m not feeling too well myself right now. Bronchitis after a germy Thanksgiving vacation at Disney World. Also my computer is out of commission having its battery replaced at the Apple store so I won’t be around much until Friday or so. (They quoted 5 days on Saturday).