Tips, Expertise, Articles and Advice from the Pro's for Your Website or Blog to Succeed
Every day, the ProgrammableWeb team is busy, updating its three primary directories for APIs, clients (language-specific libraries or SDKs for consuming or providing APIs), and source code samples.
Hey all!
I've been a long-time lurker on this forum so I wanted to share some super powerful SEO link building tactics that I've used that I think might benefit a lot of you. I'm primarily a marketer, so dev is a weak point for me, and this forum has been very helpful for me. Conversely, I see a lot of awesome devs who sometimes need help on the SEO front.
Has anyone here tried using Q&A Links to generate referral traffic and boost your link profile? Its a strategy Ive been using for a while to build highly relevant backlinks and drive targeted traffic to my websites, and Ive seen some great results.
I havent been able to find any posts with instructions on how to actually go about building these links quickly, so I figured Id give something back and make one myself! Heres an in-depth explanation of exactly how I create Q&A Links:
Step 1: I Set Up The Accounts
The first thing I do is set up an account for each of the websites Im trying to rank on 10 different major Q&A sites (like Quora, Fluther, etc.). I then personalize the page as much as possible by creating a custom description, adding my social media accounts, and uploading my logo.
Step 2: I Choose Some Targeted, Relevant Questions
The next thing I do is choose 10 different questions related to my business niche. For example, if you were building links for an insurance website, you might choose questions like what is the best type of life insurance - you get the picture! Ive found it helps to get inside the head of my target market and try to think about what questions they might ask.
Step 3: I Write a Detailed, Relevant Answer
Finally, I do a little research on each question so that I can write an accurate answer. The answer should be of as much value to the reader as possible. The aim is to get upvotes so your answer commands more authority. I also include any target keywords that I want to rank for in each answer (as naturally as possible) and a natural, contextual backlink. I tend to vary between branded, naked, and generic anchor text for each answer. Once Ive written the 10 questions and answers, I post them to 10 different Q&A sites from the accounts I built in step 1.
The Results
The best thing about this strategy for me is that it lets me leverage the ranking power of authoritative Q&A sites. Q&A sites tend to rank on the first page of the SERPs for tons of search queries. By having a link in some of those pages, I can generate lots of referral traffic. I also get the added bonus of having 10 powerful, highly-relevant backlinks from high DA websites.
The biggest problem with this strategy for me is the amount of time I need to invest in researching and answering different questions. Those that don't have the time or the content writing ability are usually the types of clients that my company works with, but if you've never done any link building, this is an easy DIY strategy you can start with to bolster some quick wins.
Has anyone used any other link building strategies that theyd recommend? Let me know! Let's get a discussion started.
Cheers!
Hey everyone! Long-time lurker here, this forum has been super valuable for me as a marketer that's much less well-versed in dev. I made an account to engage more and help share some things that might help out other users the way youve helped me. Cheers!
Here's the screenshot:
Notice the browser tab showing a tag. Here's one that does not work like that:
https://www.daniweb.com/programming/software-development/threads/378481/need-algorithm-to-c-code-conversion-assistance
I don't see a tag being called out in all tabs so there's something of a randomness there.
Not a big deal and you have much bigger areas to work.
I am attempting to update my accounts table for the current session ID with the data posted from a form. My first prepare statement is functioning fine and can be seen functioning through the placeholder variables in the form. It is my second prepare statement that doesnt seem to be working. From what I can tell, form doesn't seem to be posting the data correctly and I am unsure what the error is. It may very well be a simple error but I am stuck. Any help would be massively appreciated!
<?php
if(!isset($_SESSION['account_loggedin']))
{
header("Location: index.php");
}
$pdo=mysqli_connect("localhost","root","root","shoppingcart_advanced");
if(!$pdo)
{
echo(' Please Check Your Connection'.mysqli_connect_error($pdo));
}
$msg = ' ';
$stmt = $pdo->prepare('SELECT email, first_name, last_name, address_street, address_city, address_state, address_zip, address_country FROM accounts WHERE id = ?');
// In this case we can use the account ID to get the account info.
$stmt->bind_param('i', $_SESSION['account_id']);
$stmt->execute();
$stmt->bind_result($email, $first_name, $last_name, $address_street, $address_city, $address_state, $address_zip, $address_country);
$stmt->fetch();
$stmt->close();
// Handle edit profile post data
if (isset($_POST['submit'], $_POST['email'], $_POST['first_name'], $_POST['last_name'], $_POST['address_street'], $_POST['address_city'], $_POST['address_city'], $_POST['address_state'], $_POST['address_zip'], $_POST['address_country'])) {
// Make sure the submitted registration values are not empty.
if (!$_POST['email'] ||!$_POST['first_name'] || !$_POST['last_name'] || !$_POST['address_street'] || !$_POST['address_city'] || !$_POST['address_city'] || !$_POST['address_state'] || !$_POST['address_zip'] || !$_POST['address_country'] ) {
$msg = 'The input fields must not be empty!';
} else if (!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) {
$msg = 'Please provide a valid email address';
}
if (empty($msg)) {
// Check if new email already exists in database
$stmt = $pdo->prepare('SELECT * FROM accounts WHERE email = ? AND email != ?');
$stmt->bind_param('ss', $_POST['email'], $email);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0) {
$msg = 'Account already exists with that username and/or email!';
} else {
// no errors occured, update the account...
$stmt->close();
$uniqid = $email != $_POST['email'] ? uniqid() : $email;
$stmt = $pdo->prepare('UPDATE accounts SET email = ?,first_name = ?, last_name = ?, address_street = ?, address_city = ?, address_state = ?, address_zip = ?, address_country = ? WHERE id = ?');
$stmt->bind_param('ss', $_POST['email'],$_POST['first_name'], $_POST['last_name'], $_POST['address_street'], $_POST['address_city'], $_POST['address_state'], $_POST['address_zip'], $_POST['address_country'], $_SESSION['account_id']);
$stmt->execute();
$stmt->close();
$msg = 'account updated!';
}
}
}
?>
<?=template_header('Edit Profile')?>
<!DOCTYPE html>
<html>
<div class="EditProfile">
<h2>Edit delivery information</h2>
<div class="block">
<form action="index.php?page=saveProfile" method="post">
<label for="email">Email</label>
<input type="email" value="<?=$email?>" name="email" id="email" placeholder="Email">
<br>
<label for="first_name">First Name</label>
<input type="text" value="<?=$first_name?>" name="first_name" id="first_name" placeholder="First Name">
<br>
<label for="last_name">Last Name</label>
<input type="text" value="<?=$last_name?>"name="last_name" id="last_name" placeholder="Last Name">
<br>
<label for="address_street">Street</label>
<input type="text"value="<?=$address_street?>" name="address_street" id="address_street" placeholder="Street">
<br>
<label for="address_state">City</label>
<input type="text" value="<?=$address_state?>" name="address_state" id="address_state" placeholder="Address">
<br>
<label for="address_zip">Postcode</label>
<input type="address_zip" value="<?=$address_zip?>" name="address_zip" id="address_zip" placeholder="Postcode">
<br>
<label for="address_country">Country</label>
<input type="text"value="<?=$address_country?>" name="address_country" id="address_country" placeholder="Country">
<br>
<input class="submit" name="submit" type="submit" value="Submit">
<p><?=$error?></p>
<p><?=$msg?></p>
</form>
</div>
<p><img src="Images/PSign.PNG" alt="Logo" width="100" height="100"></p>
</div>
<?=template_footer()?>
</html>