Have a look:

“http://www.phpwebdevelopment.org/index.php?result=about”

//Output the value of $_GET['result'] from the url
{$smarty.get.result}

//Output the value of $_POST['result'] from a posted form
{$smarty.post.result}

//Output a cookie variable, $_COOKIE['status'] from request header
{$smarty.cookies.status}

//Output a server variable, $_SERVER['SERVER_NAME']
{$smarty.server.SERVER_NAME}

//Output a system environment variable, $_ENV['PATH']
{$smarty.env.PATH}

//Output a session variable, $_SESSION['userid']
{$smarty.session.userid}

//Output the value of "username" from merged get/post/cookies/server/env
{$smarty.request.username}

2. Just because of you have too many columns, don’t split a table . In accessing a row, the biggest performance hit is the disk seek needed to find the first byte of the row.

3.  A column should be declared as “NOT NULL” only if it really needs it — thus you speed up table traversing a bit.

4. Instead of using PHP loop to fetch rows from database one by one only because of you can, use IN , e.g.

SELECT *
FROM `table`
WHERE `id` IN (1,6,18);

5. Use column default value, and insert only those values that differs from the default one. This reduces the query parsing time.

6. Think of storing users sessions data (or any other non-critical data) in MEMORY table — it’s very fast.

7. Images and other binary assets, for your web application should normally be stored as files. Store only a reference to the file rather than the file itself in the database.

8. If you need to calculate COUNT or SUM based on information from a lot of rows (articles rating, poll votes, user registrations count, etc.) frequently, then it would be great to create a separate table and update the counter in real time, which is much faster. If you need to collect statistics from huge log tables, take advantage of using a summary table instead of scanning the entire log table every time.

9. Don’t use REPLACE query (which is DELETE+INSERT and wastes ids): use INSERT … ON DUPLICATE KEY UPDATE instead (i.e. it’s INSERT + UPDATE if  conflict takes place). The same technique can be used when you need first make a SELECT to find out if data is already in database, and then run either INSERT or UPDATE. Why to choose yourself — rely on database side.

10. Always divide complex queries into several simpler ones — they have more chances to be cached, so will be quicker.

11. Group several similar INSERTs in a long INSERT with multiple VALUES lists to insert several rows at a time: this way query will be quicker due to fact that connection + sending + parsing a query takes 5-7 times of actual data insertion (depending on row size).
But if that is not possible, use START TRANSACTION and COMMIT, if your database is InnoDB, otherwise you should use LOCK TABLES which will benefits the performance because the index buffer is flushed to disk only once, after all INSERT statements have completed; in this case unlock your tables each 1000 rows or so to allow other threads access to the table.

12. When loading a table from a text file, use LOAD DATA INFILE as it’s 20-100 times faster.

13. Avoid using ORDER BY RAND() to fetch several random rows. Fetch 10-20 entries (last by time added or ID) and make array_random() on PHP side.

14. Avoid using HAVING clause — it’s rather slow. In most of the cases, a DISTINCT clause can be considered as a special case of GROUP BY; so the optimizations applicable to GROUP BY queries can be also applied to queries with a DISTINCT clause. Also, if you use DISTINCT, try to use LIMIT (MySQL stops as soon as it finds row_count unique rows) and avoid ORDER BY (it requires a temporary table in many cases).

CREATE TABLE teasttable (
prkey int(11) NOT NULL auto_increment,
names varchar(20),
score int,
timeEnter timestamp(14),
PRIMARY KEY  (prkey)
);

And we have the formatted text file as shown below with the unix “tail”  command:

$ tail /tmp/out.txt
'name1880',94
'name1881',93
'name1882',91
'name1883',93
'name1884',90
'name1885',93
'name1886',93
'name1887',89
'name1888',85
'name1889',88

The  testtable contains the “prkey” and “timeEnter” fields which are not given in the “/tmp/out.txt” file. Therefore, to successfully load the specific fields you need to do the following:

mysql> load data infile ‘/tmp/out.txt’ into table testtable
fields terminated by ‘,’ (name,score);

You can use title variable in header template like this:

homepage.tpl

{include file="header.tpl" title="Home Page"}
{* Rest of the template body will go here *}

aboutus.tpl

{config_load file="aboutus.conf"}
{include file="header.tpl" title=#aboutusTitle#}
{* Rest of the template body will go here *}

header.tpl

<HTML>
<HEAD>
<TITLE>{$title|default:"THIS IS DEFAULT TITLE"}</TITLE>
</HEAD>
<BODY>

When the Home page will be load, the title “Home Page” will be to the header.tpl, and will be used as the title. When the aboutuspage is drawn, the title will be “About us”. Which is used in archives_page.conf file, as we are using a variable from the archives_page.conf file instead of a hard coded variable. Also notice that “THIS IS DEFAULT TITLE” will be printed using the default variable modifier,  if the $title variable is empty.

Using {if}

{if $title eq ""}
*
{else}
{$title}
{/if}

Using “default” modifier

{$title|default:"*"}

Here is a sample code that sets “oddstyle” or “evenstyle” css class to rows of a table in alternates.

<table>
{section name=i loop=$products}
<tr class="{cycle values='oddstyle,evenstyle'}">
<td>{$products[i].title}</td>
<td>{$products[i].description}</td>
</tr>
{/section}
</table>

In each class “oddstyle” and “evenstyle” set CSS “background-color” property with different colors.

Consider the code written in a index.tpl template:

{assign var='title' value='This is an example'}

Now Accessing variables after template execution:

Execute the index.tpl template and return the result to a variable in php file

$page = $smarty->fetch('index.tpl');

Given code will output “This is an example”:

echo $smarty->get_template_vars('title');

Assign value to that variable:

$smarty->assign('title', 'Value is changed');

Now this will output “Value is changed”:

echo $smarty->get_template_vars('title');

To dump all variables assigned in the template use the code:

var_dump($smarty->get_template_vars());

To access variables during template execution from inside {php} tags, you can use two ways:

{php}
// using $this->_tpl_vars
echo $this->_tpl_vars['title'];

// using $this->get_template_vars() method, the variable $this, is a smarty object
echo $this->get_template_vars('title');
{/php}

{capture name='navbar'}
<ul>
{section name=item loop=$nav}
<li><a href="{$nav[item].urlid}">{$nav[item].title}</a></li>
{/section}
</ul>
{/capture}

//To show the captured content.Use the code:

{$smarty.capture.navbar}

//You can also assign the output to a template variable.

{capture name='navbar' assign='navmenu'}

//Then display the content using the variable.

{$navmenu}

//if name is not specified, "default" is used and can be displayed like this:

{$smarty.capture.default}

create table testing (
a int,
b int,
UpdateTime timestamp,
EnterTime timestamp );

The first timestamp will always be the “automatically generated” time. So whenever a record is updated, or inserted, this time gets changed. If we change the order,like “timeEnter” is before “UpdateTime”, then,  “EnterTime” would get updated.  First timestamp column updates automatically.

Note, in the table given above EnterTime will only get updated if passed a null value.

insert into testing (a,b,EnterTime) values (1,2,NULL);
select a,b,DATE_FORMAT(UpdateTime,'%m-%d-%Y %T'),DATE_FORMAT(EnterTime,'%m-%d-%Y %T') from testing;

+——+——+—————————————+———————————————————————-+
| a    | b    | DATE_FORMAT(UpdateTime,’%m-%d-%Y %T’) | DATE_FORMAT(EnterTime,’%m-%d-%Y %T’)    |
+——+——+—————————————+———————————————————————-+
|    3 |    2 | 04-15-2004 19:14:36                                                   | 04-15-2004 19:15:07                                                  |
|    3 |    2 | 04-15-2004 19:14:39                                                   | 04-15-2004 19:15:07                                                  |
|    5 |    5 | 00-00-0000 00:00:00                                                 | 04-15-2004 19:15:53                                                   |
|    1 |    2 | 00-00-0000 00:00:00                                                  | 04-15-2004 19:20:15                                                  |
+——+——+—————————————+———————————————————————-+
4 rows in set (0.00 sec)

But you can open multiple gmail accounts in IE 8 as it provides you an option to open a new window with new session.For accessing multiple gmail accounts follow the steps:

1. First open Internet Explorer 8 and login to your Gmail account. But make sure that the Remember Me option is unchecked when you sign in.

2. Now Press Alt-F, I, and then hit Enter. or simply click new session option in file menu. This will open a new Internet Explorer session. Open Gmail and sign in with different account, and again make sure to uncheck Remember Me.
This way you can access all your Gmail Accounts simulteneously.