Blog - Supravirtual SRL, Oradea, Romania

How to show and optimize tables of mysql database

The mysql query to list the tables from a mysql database is show tables from `database` where `database` must be replace with the actual name of the database. The query lists the non-TEMPORARY tables in a given database.

You can use inside php like this:

$res=mysql_query("show tables from `database`") or die(mysql_error());
while($r=mysql_fetch_row($res))

{ 
    $resOpt=mysql_query("optimize table `database`.`".$r[0]."`") or die(mysql_error());

where optimize table is a mysql query that should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows. Deleted rows are maintained in a linked list and subsequent insert operations reuse old row positions. You can use optimize table to reclaim the unused space and to defragment the data file. After extensive changes to a table, this statement may also improve performance of statements that use the table, sometimes significantly.

More information about the show tables can be used here: http://dev.mysql.com/doc/refman/5.0/en/show-tables.html

More information about the optimize table can be used here: http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html

Blog

Local seo company versus off-shore company

Until now I've wrote about the seo techniques and some thing about what you should do and you must avoid in order to improve your page in ranking and content. I wrote almost nothing about what should be the criteria of selecting the seo company to work for you and it's time for that.

There are 2 distinct tendencies in choosing your collaborator in the seo world: to use local companies (close to you area of activity in the "real world") and to use off-shore companies (the work over internet but they are located physical in other countries or continents).

Blog

Local Search Engine Optimization & SEO Geo-targeting

Does you site appears on the first results page when run a search with the main search engines? That's excellent, but does it happen with the same success for all the areas you want to sell your products? For example, in the next town or the cities around you does your site have the same success as your home town? Why not?

Blog

Javascript: asking the visitor to confirm if he wishes to leave the page

Lately I've noticed more and more web pages that ask the visitor to confirm if he/she wishes to leave the page. The easiest way to do that is to use javascript, something like the following code:

<html>
<head>
<script language="javascript" type="text/javascript">
window.onbeforeunload = askConfirm;
function askConfirm()
{ return "You don't want to leave this page, do you?"; }
</script>
</head>
<body>
</body>
</html>

Blog

SEO, content writing and pagejacking

A few decades after the first hijacking we all know what that is: somebody take the control of a vehicle (car, bus, airplanes) and redirects it accordingly to his/her desire.

Another definition, a newer one, is the following one (the details can be found here):

Blog

Search engine optimization and the importance of the sitemaps

There are 2 types of sitemaps used for now in webdesign & seo: the XML sitemap and HTML (on-page) sitemap. They have a different structure and they don't have exactly the same target, but they both have the same purpose: to assure the best access on the site and all the pages (articles) of the site.

Blog

SEO: ToDo list when changing your site's URL structure

Changing the URL structure for your site is not recommended, but sometimes it is necessary. The motifs may vary, but from time to time this kind of things happen. The most important thing to remember when dealing with something like this is: do it as rarely as possible, if it is possible never do it. Search engines does not like this kind of changing (the site must be indexed all over again, duplicate content may occur, the ranking of the site could drop), especially if it is done often, and the targeted backlinks may be lost because of it. If your site is already big (for example: a blog or a newspaper site) it can take some time to make a full recovery.

Blog

Errors when using Community Builder 1.4 and Joomla 1.7.0

Recently Joomla 1.7.0 was released, so I've installed it on a development and test site and I've also installed Community Builder 1.4.

When trying to see the CB user list using the link http://joomla17.test/administrator/index.php?option=com_comprofiler&task=showusers&view=showusers (I've modified the test domain name) I've got the following error:

Blog

SEO for osCommerce online store

Installing an osCommerce Merchant Store on your server is not hard at all: it can be done in only few minutes if you know what you are doing. Configuring the store is a little harder (especially if you want a job well-done), but it is manageable. One of the most important things you must consider when doing that is the search engine optimization of your online store, you do want to be on the on the first page on the Google/Yahoo/Bing search results when something is searching the products you are selling. Don't you?

Blog

Reseting password for administrator for oscommerce

The misplace of the passwords is always a problem, especially if it is something important. And there is nothing more important when you have an online store and you can not log in to the backend to administrate your products.

There are several ways to reset your password:

Blog