SQL count rows

$RowCountResults = mysqli_query($con,"
SELECT COUNT(*) AS RowCountResultsToPrint FROM Sheet1;
");
while($row = mysqli_fetch_array($RowCountResults)){
$RowCountResultsToPrint=$row['RowCountResultsToPrint'];
}
echo "RowCountResultsToPrint = ".$RowCountResultsToPrint;

Linux, unix, centos

Search files for strings:

http://www.cyberciti.biz/faq/howto-use-grep-command-in-linux-unix/

Search for a file name:

http://www.cyberciti.biz/faq/howto-recursively-search-all-files-for-words/

Program Files

http://askubuntu.com/questions/27213/what-is-the-equivalent-to-the-windows-program-files-folder-where-do-things-g

unhide the .htaccess file: when browsing files use ctl+h.

http://www.diffen.com/difference/Linux_vs_Unix

How Unix systems work

http://unix.stackexchange.com/questions/682/how-does-a-unix-or-linux-system-work

Notes from above link:
The boot loader is at the first sector of a hard disk. It is started by the system and it loacates the Operating System kernel. The kernel is a computer program that manages input/output requests from software. http://en.wikipedia.org/wiki/Kernel_(operating_system)
Layering
The kernel is the central program … LEFT OFF … (with taking notes.)

http://en.wikipedia.org/wiki/Man_page

Basics

https://help.ubuntu.com/community/UsingTheTerminal

Notes from the link above:

https://www.edx.org/course/linuxfoundationx/linuxfoundationx-lfs101x-introduction-1621#.U9j9RfldWCm

Unix vs Linux

Linux: free alternative to UNIX.

UNIX: comercially supported. More likely to be Used by major companies.

Linux: More likely to be used by small companies. No standard set of tools, file systems or patches. Significant variation between diff strands of linux. Advantage: ability to pick and choose applications and functions.

UNIX: The commands, tools and major elements are the same. which means UNIX is easier to learn.

Unix: runs on just a few standard types of machines like MS Office.

Linux: Run anything from apps to OS to enterprise wide servers.

Linux: Users more often work at startups or freeware projects and hope to get paid to support the code they write.

Unix:

Unix: wins for economic opportunity.

Computer Hardware Diagnosis

While opperating the computer normally, with only a few windows open, and not running any large task. I received this error: Windows detected a hard disk problem. “Back up your files immediately to prevent information loss, and then contact computer manufacturer to determine if you need to repair or replace the disk.” I backed up my files.

In the past 3 weeks, the computer froze about 10 times. I was not able to click any thing with the mouse, and I could not use the keyboard to type or enter keyboard hotkey commands like ctrl-alt-delete, alt-tab, etc. I restarted the computer and it worked fine.

I ran a check for the C drive and no errors were found. Right click the drive > properties > tools > check.

View the details of the hard drive fail.

Event View > Custom Views > Summary Page Event > Summary Page Views

Appearing on Bing SERPs

I have an SEO campaing that I’m working on. Since Bing’s market share is up, and MicroSoft is spending money on their Bing marketing campaign: I’ll spend a little time looking into improving our ranking on the Bing SERPs.

I tested my keyword phrases on Bing and we’re not doing as well . We’re probably doing as well on Bing as we were on Google a few months ago. Reading this article and this quote:

http://searchenginewatch.com/article/2279842/How-to-Dominate-the-Entire-First-Page-of-Bing

“It’s important to remember that Bing indexes pages at a much slower rate compared with Google ever since the release of Caffeine. Don’t expect to see rankings change as quickly as they do in Google.”

This quote confirms my observation. I’m going to test the keyword phrases on Bing again to see what the results look like. If there’s an improvement, I think we’re good to go.

Here’s are some notes from the above link:

Ranking on Bing is the same as ranking for Google 2 years ago.

  • acquire high authority
  • relevant links with keyword optimized anchor text
  • Google’s new rules don’t apply
  • domain doesn’t have to be relevant
  • the page has to be relevant
  • title tag of the linking page is incredibly influential

We’re already doing all of these items.

Further Reading:

http://www.bing.com/webmaster/help/webmaster-guidelines-30fba23a