Month: July 2022

Search Engine Optimization for Companies

Posted on by webatlanta_qruach

Web-Atlanta is a key component to the South Eastern technology engine. It’s important in web design to have good local web designers who are familiar with your project. The web designers you use for your web project should not be in India, Pakistan, Russia, or any location other than the United States. Your project should only be worked on by a local web expert. We are Atlanta web designers; our programmers are what makes the difference between us and our competition. Having a web design company that has a group of great web designers or freelancers is good; but having a company that has the web design team, the high level programmers, the database gurus and the project managers that have seen it all is much better.

The outsourcing scammers are cold calling Atlanta customers and pretending to be local companies. They make big promises and deliver no results. Foreign companies pretending to be the real local Atlanta web experts are easy to spot by their high pressure and extravagant claims.

It’s one thing to be in Atlanta and be a web expert or designer, but its another thing to try and trick companies from Atlanta, Georgia. Even when seeing a local 404, 770 or 678 number, know that anyone can get these numbers and use them from anywhere in the world. Atlanta, Georgia companies like Web-Atlanta have more clients in the south eastern United States than these off-shore boiler rooms. For real SEO expertise right here in Atlanta contact Web-Atlanta and maximize your keyword positioning.

Foreign companies pretending to be the real local Atlanta web experts are easy to spot by their high pressure and extravagant claims.

Basic Website Pricing Cost

Posted on by webatlanta_qruach

Many new business people fail to consider the cost of a website in their startup costs. They may also want to hold off on a website until other avenues are exhausted. The first rule of prospects and leads is to do business with people you know. Then ask them if they know anyone that could use your services. It’s all free!

But at some point you need to have a website. It is the new yellow pages. People need to find your phone number, and while they may remember your brand name, or your city and trade, we tend to misplace your business card and rely on looking up your phone number with google. That could suck for you.

To begin with, instead of wondering how much it will cost, set a budget of $ 750 for your first web-site. First you will have to register a domain, for at least five years, you have $ 700 left. Now you need a computer to store and provide your website to visitors, an annual service called hosting. There goes a hundred bucks a year. Your website should incorporate your logo. Don’t have one? There goes $ 150 to $ 500 for a digital branding package. That might leave you with from $ 100 to 500 to spend on the website design, and yes it can be done.

The most difficult part of the web design will not be the designers job, it will be talking about your business. You need 500 words about your business, philosophy, customers and market. You then need at least 500 words about your products and or services. Finally you need a contact page that contains your phone number, and if you have an office or mailing address, that should be included. There, we are done. That is a simple three page web-site.

If you have a business address, it is time to establish listings in Google Places and Bing Local Listings. These have become more important than the yellow and white pages. You can struggle through this yourself, or pay various professionals three to five hundred dollars to accomplish this somewhat technical task.

Been there done that, and ready to do it for real? Here is a guide to budgeting for a website upgrade, probably better suited for your second time through:

  Small BudgetBig Budget
Number of Pages6 to 10  $ 2,000  $ 3,000
Style and DesignSimple yet attractive  $ 2,000  $ 3,000
Copywritingthree to five pages  $ 1,000  $ 1,500
SEOmajor keywords and phrases   $ 2,000  $ 4,000
Graphical and Photography  Just Enough  $ 1,000  $ 2,000
Content Management System Standard  $ 2,000  $ 4,000
 TOTAL BUDGET COSTS $10,000 $15,500

Whoa, Nelly! Do I need all that? Probably not, but when you are ready to truly be found on search engines with an attractive web design, be prepared to budget three to five thousand. Need a professional photographer? Expect to spend from $ 300 to 1000 a session. Do you want to include products from your database, with current pricing or inventory levels? Expect to spend a couple thousand for the integration. Looking to sell things on-line? Expect to pay a consultant to help you with Amazon or Yahoo shopping to make an initial foray. If you want to run your own shopping site, the costs can be $ 10,000 quickly.

Python Mysql multi handle 2.7.2

Posted on by webatlanta_qruach

Real world use case for multiple instantiations of python classes, Use a Python Class more than once

At the beginning of our python program, we normally would import the library for MySql operations;

import MySQLdb

Using this library, we then use .connect() and .cursor but because we may be using the same database repeatedly, here is an alternate method of initializing our connection. First, we create a file called credentials.py in our working directory to initialize the database connection;

#!/usr/bin/python
import MySQLdb
def dbconn():
  server = 'localhost'
  user = 'MySql_user_name'
  password = 'MySql_password'
  dbase = 'MySql_database_name'
  return MySQLdb.connect(server,user,password,dbase)

This means that I can quickly connect to the same database, everytime I write a new Python program, substituting the new library for making the connection.

import credentials
handle = credentials.dbconn();

We now can look at some table rows with only four more statements;

cursor=handle.cursor()
sql="SELECT * FROM table_name WHERE 1=1"
cursor.execute(sql)
rowArray=cursor.fetchone()

Add on more statement, like ‘print rowArray’ or do whatever you need to do to look at the row. You probably will write a loop that encloses the last statement.

Just to take another approach, let’s look at our MySql Python connect without the separate credentials function;

#!/usr/bin/python
import MySQLdb
server = 'localhost'
user = 'MySql_user_name'
password = 'MySql_password'
dbase = 'MySql_database_name'
handle = MySQLdb.connect(server,user,password,dbase)

cursor=handle.cursor()
sql="SELECT * FROM table_name WHERE 1=1"
cursor.execute(sql)
rowArray=cursor.fetchone()

print rowArray

And with the credentials library;

#!/usr/bin/python
import credentials
handle=credentials.dbconn()
cursor=handle.cursor()
sql="SELECT * FROM table_name WHERE 1=1"
cursor.execute(sql)
rowArray=cursor.fetchone()

print rowArray

Next an example using your credentials.py to make a python program to read two tables,first we get the user record, and then their posts.

import credentials
userHandle=credentials.dbconn()
uSql="SELECT * FROM jos_users WHERE id=57"
cursor=userHandle.cursor()
cursor.execute(sql)
uArr=cursor.fetchone
contHandle=credentials.dbconn()
cSql="SELECT * FROM jos_content WHERE created_by=57"
cCursor=contHandle.cCursor()
cCursor.execute(cSql)
for i in cCursor.fetchone
  print i['title']

python string split example 2.7.2

Posted on by webatlanta_qruach

6 lines of code, no modules to import

x = 'joe fred terry mitch jane betty mary ellen'
while (1==1):
    y = x.find(" ")
    if y==-1: break
    print 'next name ',x[:y]
    x = x[y+1:]

3 lines of code, using the string module. Elegant because the loop definition is overt and evident.

import string

x = 'joe fred terry mitch jane betty mary ellen'
for name in string.split(x):
  print 'next name ',name

Other Examples

  1. split a semicolon delimitted string, or any delimiter in a string of fields
  2. some string library in python constants
  3. search a string (you don’t need the string library), i.e. ‘pos’ or re.search
import string

x = 'joe;fred;terry;mitch;jane;betty;mary;ellen'
for name in string.split(x,';'):
  print 'next name ',name


import string

print "1..",string.printable
print "2..",string.uppercase
print "3..",string.letters
print "4..",string.digits
print "5..",string.punctuation


x='joe,john'
print x.index('john')
# this yields the integer '4'
print x[4:]
# this would print john, or the rest of the string which is here john