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
The search engine optimisation part is very important for websites - they have to match certain criteria in order to appear as often as possible in the search results on Google and Bing. SEO (search engine optimization) starts from site / online store / platform development because it involves a specific structure of the pages, it involves an ease to browse for the visitors (for your clients) and it involves quicky loading when accessed. Our sites are delived already optimized, but if you have already a solution developed by someone else we analize your website and we offer consultancy - we'll tell you about the options you have about to boost its visibility and organic traffic.
We develop websites to present your activity to the world and applications for internet that help you organize your activity as eficient as possible and without loses (in money, time and energy) wherever you are. Do you need an online store or a tool available for you anytime? We can develop that as long you reserve a domain name and some hosting space, the app is our job.
We develop web applications and mobile apps (Android) for various companies and organisations according to their specifications and requirements. The apps are being used by employees and partners to work more efficient and with less costs for the company: the web applications can be accessed through the browsers installed on smartphones and tablets but the usage of a complementary mobile app can make efficiency to go up (it can increase the communication between people or it can show things not so important on PC).
We offer consultancy about the informatic system you have installed and we offer sollutions to make the more efficient, to improve and develop them further, we analize the activities inside your company and / organisation and we offer sollutions for the projects you want to develop.
