Database and Web Development

What is .htaccess?

2011-04-30T08:35:00.000+07:00

.htaccess is a configuration file for use on web servers running the Apache Web Server software. When a .htaccess file is placed in a directory which is in turn 'loaded via the Apache Web Server', then the .htaccess file is detected and executed by the Apache Web Server software. These .htaccess files can be used to alter the configuration of the Apache Web Server software to enable/disable additional functionality and features that the Apache Web Server software has to offer. These facilities include basic redirect functionality, for instance if a 404 file not found error occurs, or for more advanced functions such as content password protection or image hot link prevention .........http://www.htaccess-guide.com/

Free Download Scripts and Source Code

2011-04-26T14:46:00.001+07:00

Free Download Scripts and Source Code Free Download Scripts and Source Code, Clone Script, Nulled Script, Script Example, Flash Action Script, Javascript, Java, JQuery, Ajax, PHP, CSS, HTML, etc.

Reference:http://scriptexample.blogspot.com/2010/10/21-amazing-jquery-tabs-collection.html

Working Hard Is not Enough. Here's 18 Ways to Work Smart

2010-06-25T23:44:00.000+07:00

Get clear on the objective.
Everything has an objective. It's just a matter of whether you know it or not. What is the end objective you are looking for? The people who don't know the objective of what they are doing are the ones who waste the most time. If you know your objective, you can be laser-focused and cut right to the chase. The clearer you are, the better.

Create a vision.
Now that you know your objective, what is your vision? See the objective as your direction, and your vision as your destination. Knowing your objective lets you know where to travel in, while knowing your vision helps you charge forward.

Take the 80/20 route.
There are always many different ways to achieve the same outcome. 80/20 route refers to the route that takes the least effort but gives you the maximum results. What's the most effective route that will get you from where you are to where you want to be? Take that path.

Go for high impact items.
There are endless number of things you can do to achieve a goal. Go for the most important tasks - the ones that cause the highest impact. For example in school, I would not attend lectures if I felt they would not make a difference to my learning. As I develop my blog, I concentrate on the key tasks that make the most difference such as writing high quality content for my readers and spreading the word about my articles.

Create structures to maintain your flow.
If you know how motivation works, you will know it comes in bursts and waves. It's not possible to maintain a 100% full motivated state every single second. Hence, you need to create/leverage on your environment to maintain your flow. Examples are your physical environment, people you hang out with, your routine and communities you are a part of.

Stop being a perfectionist.
Being a perfectionist isn't all that perfect if it prevents you from achieving more. Release the perfectionist mindset. Stop obsessing about the details and specifics; they often take care of themselves.

Learn from others.
There are great resources, smart people, direct opportunities and top books around you all the time. Learn to make use of them. When I started out in my personal development industry and with my blog, I read materials from the experts and consulted the top bloggers, which helped me gain important insights immediately. Even today, I continue to do so as I expand my work. There is never a stop to how much you can learn from others.

If it works, stick to it.
If there is already a success formula that's working, then reapply that formula. There's no need to innovate or reinvent the wheel for the sake of it. Innovate only if there's value in doing so.

Ask for help.
Most of us prefer to do things by ourselves and not disturb others. That's a great work ethic, but sometimes asking for help gets us further than just doing it alone. People love to help. Many readers often email me at The Personal Excellence Blog for advice/help and I make an effort to answer their questions, because I want to see them do well too. Ask and you might get an answer. If you don't ask, you'll never get.

Cut out the fluff.
Going for high impact items (#4) means you have to cut out the fluff. There are the things that need to be done, and then there are the nice-to-do things that don't exactly contribute to anything in the long-run. Don't do things unless they are absolutely needed.

Automate.
Is there anyway to automate your tasks, especially labor intensive ones? It can be the simplest things such as setting up filters in your emails and using more functional applications that get the job done better. With The Personal Excellence Blog, I've automated several processes such as filtering specific emails to respective labels, having my new articles automatically feed to Twitter/Facebook, and having automatic thumbnails for my articles. That saves a lot of time so I can get right to creating quality content for readers.

Delegate.
For the lower impact items that need to get done (such as administrative activities), delegate them to someone else. If you are running a business, hire someone to take care of them.

Outsource.
If something is not your area of expertise or it can be better done by someone else, then outsource it. You only have 24 hours a day; your limited time should be spent only in places where you can add the most value. If you are running a business, examine if there are any aspects of your work (such as accounting, designing, programming) that can be outsourced to others. There's no need for you to learn and get hands-on on every single thing, especially if it's not the core of your work.

Wait.
Sometimes, waiting may be the best solution. Things resolve themselves when you wait for a little while longer. I have experienced fixes that rectify themselves when I waited a while longer. If you are stuck in a dilemma, new solutions may pop in if you pause your steps.

Pick your battles.
We often face roadblocks in things we do. Go up against the roadblocks only if they are worth the time and effort. That means you need to consciously weigh out the pros and cons first. Don't try to ram up against every barrier you face, especially if there's nothing much on the other side.

Always lookout for a better way.
Don't restrict yourself to a certain set rule of doing things just for the sake of status quo. Study others and learn from them (#7). Review your situation regularly (#18) and look for ways to improve what you are doing. Be flexible to usher in changes that can help you get more results.

Stop when you are tired.
I've realized from experience that trying to press on when you are tired only leads to slumps and ruts. Resting is paramount to accomplishing more. A tired person can't do meaningful work. When you are well-rested, you work faster and better.

Review regularly.
Do a regular review of what you have done in the past week and the corresponding results. Then analyze the things that are working and the things that aren't working. With the former, keep them; with the latter, remove them. Very soon you will have a very streamlined list of things that work.

Written on 6/24/2010 by Celestine Chua. Celestine writes atThe Personal Excellence Blog, where she shares her best advice on how to achieve personal excellence and live your best life. Get her RSS feed hereand add her on Twitter @celestinechua. Photo Credit: Incase.

Reference soure: Source Link

Using Khmer Unicode and Save Image to SQL Server in VB 2008

2010-06-24T15:30:00.000+07:00

'Please attach the database to your SQL Server 2000 Database first.
Public pubCnn As New OleDb.OleDbConnection
Public strCnn As String = "Provider=SQLOLEDB.1; Data Source=.; " & _
                                     " Initial Catalog=SCHOOLSTAT; User ID=sa; Password=;"
'insert data to table
Dim cmd As New OleDb.OleDbCommand
Dim arrImage As Byte()
Dim myMS As New IO.MemoryStream
Dim strImage As String = ""
If Not IsNothing(Me.picPhoto.Image) Then
     Me.picPhoto.Image.Save(myMS, Me.picPhoto.Image.RawFormat)
     arrImage = myMS.GetBuffer
     strImage = "?"
Else
     arrImage = Nothing
     strImage = "NULL"
End If
--------------
cmd.Connection = pubCnn
If Me.id = 0 Then
      id = GetSchoolID()
      cmd.CommandText = "INSERT INTO school(id, schoolcode, name" & _
                                      ",provinceid,phone,type, photo) " & _
                                      " VALUES(" & id & "," & SQLString(Me.txtSchoolCode.Text) & _
                                      "," & SQLString(Me.txtSchoolName.Text) & _
                                       "," & prID & "," & _
                                      SQLString(Me.txtPhone.Text) & "," & schtype & _
                                      "," & strImage & ")"
If strImage <> "NULL" Then
       Dim cmdPar As New OleDb.OleDbParameter
       cmdPar = cmd.Parameters.Add("?", OleDb.OleDbType.Binary)
       cmdPar.Value = arrImage
End If
Download Source Code and Database Here

The New Rules of Money

2010-06-24T15:11:00.000+07:00

THE OLD RULES:

Go to school so you can get a safe, secure job. During my dad’s time, people did this. They went to school, got a job, and stayed with the company until they retired. Today, we all know that job security is a myth, especially as jobs are exported. Billions of people in the third world enter the global market competing for your job at a lower wage, and technology wipes out companies that do not stay competitive. Today, rather than having a job for life, those born after 1970 will probably have four to seven jobs in their lifetime.
Work hard, climb the ladder, and earn more money. The problem with working hard as an employee is the tax laws are written against employees. The more money an employee makes, the higher the percentage in taxes the government takes.

Most of us have heard Warren Buffett say that he thought it unfair that he pays a lower percentage in taxes than his secretary.
Save money. Savers are losers, especially if you are saving U.S. dollars. Since 1971, the U.S. has been able to print money faster than the country earns it. This causes the value of savings to erode as prices increase. Adolf Hitler was elected Chancellor of Germany after the middle class had their savings wiped out due to hyperinflation. Stalin and Mao also rose to power when the previous leaders devalued their money.
Get out of debt. Because the value of the U.S. dollar is falling rapidly, it is important to know the difference between good debt and bad debt. Unfortunately, even the U.S. banks are loaded with bad debt, a.k.a. subprime debt. If you want to become wealthy in a subprime world, it is important to know how to use good debt to offset the falling value of the U.S. dollar. If they are smart, debtors can be winners.
Invest in a well-diversified portfolio of mutual funds through your company’s 401(k). First of all, Warren Buffett does not diversify. He says, “Diversification is for people who do not know what they are doing.” Second of all, John Bogle, founder of The Vanguard Group and one of the more brilliant minds in investing today, says that mutual fund companies have been ripping investors off. He states that investors in mutual funds put up 100% of the capital, absorb 100% of the risk, and receive only 20% of the rewards. The 80% in investor gains goes to the mutual fund company. On top of that, the Wall Street Journal called the last ten years “the lost decade” because there have been no real profits in stocks for the past ten years.

THE NEW RULES:

Keep your daytime job but start a part-time business. In other words, become an entrepreneur at home. Not only will you learn a lot, but the tax rules of the rich swing to your favor. If your business grows and can replace the income from your job, you may be ready to spread your wings and fly. As you may know, the richest people on earth are entrepreneurs who invest in real estate.
Become an entrepreneur. The world’s most successful entrepreneurs did not go to school nor did they climb the corporate ladder. Many of the most famous entrepreneurs did not do well in school. Some of them are: Henry Ford, founder of Ford Motor Company. Ford could use the old man today. Thomas Edison, the founder of General Electric, was called “addled” by his teachers. Others include Bill Gates of Microsoft, Michael Dell of Dell Computers, Steve Jobs of Apple, Richard Branson of Virgin.

Today, for a country to remain competitive, we need more entrepreneurs and fewer employees. With more entrepreneurs and fewer employees, wages could go back up. Unfortunately, most parents still say to their kids, “Go to school so you can get a job.” In other words, many people and our schools program kids to be employees – rather than entrepreneurs.
Hedge your money. Instead of saving money, keep your money liquid in assets that increase in value as the dollar drops in value. Personally, I keep my liquidity in gold and silver ETFs. I buy every time the price of gold or silver goes down. Today, as I write, I believe gold is a good price under $1000 and silver a bargain at under $25. If I need cash in a hurry, I sell my gold or silver ETFs.
Use debt as leverage. I am deeply in debt… good debt. I use debt to make me richer. I could pay off my home, but my effective interest is only 6%. As long as I can earn a 15% or higher return on my money, I’ll invest my money rather than pay off debt.

If you are a professional investor, a 50% to an infinite return on your money is possible. If you would like to find out how I achieve an infinite return, read my latest book, Rich Dad’s Increase Your Financial IQ.

One reason I do not diversify is because diversification is like going to the racetrack and betting on every horse. The only way you win by diversifying at the racetrack is if the dark horse wins. I would prefer to focus and pick winners. One myth in investing is that higher returns require higher risks. That is a huge myth. As Buffett says, “Risk comes from not knowing what you are doing.”
Know the difference between salespeople and rich people. One of the reasons so many people are in trouble financially today is because they get their financial advice from sales people. Today, I cringe whenever I hear so-called investment gurus, who are really sales people, recommending the old rules of money. As Warren Buffett says, “Wall Street is the only place that people ride to in a Rolls Royce to get advice from those who take the subway.”

Steve Forbes is a rich person who knows what he is talking about. His column in Forbes magazine, Fact and Comment, is a column I look forward to every month. If you want to grow rich – and stay rich – investing a few moments with Mr. Forbes is a priceless investment of your time.

by: by Robert Kiyosaki

VB.Net 2008 OleDb Connect to MS-Access with Password (Visual Basic 2008)

2010-06-24T15:04:00.000+07:00

To day i have found the way, how to make connection from VB.Net 2008 to Ms. Access from my friend block then i would like to keep on my block as well, if you interest then please try it with me here below.

As New OleDb.OleDbConnectioncon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Application.StartupPath & "\dbstudent.mdb;" & _"Jet OLEDB:Database Password=12345"

con.Open()
'----------------------Dim da As New OleDb.OleDbDataAdapter("SELECT * FROM tblstudent", con)'----------

con.Close()
con.Dispose()

Refference source: Iech Setha

copy all files from 1 folder to another folder

2010-06-22T13:35:00.002+07:00

Here is the function which is used for copy all files from 1 folder to another folder
=======================================
function copydir($dirname1,$dirname2) {

if (is_dir($dirname1))

$dir_handle = opendir($dirname1);
if (!$dir_handle)
return false;
while($file = readdir($dir_handle)) {
if ($file != "." && $file != "..") {
if (!is_dir($dirname1."/".$file))
$tempfile=fopen($dirname2."/".$file,"w+");
copy($dirname1."/".$file,$dirname2."/".$file);
//unlink($dirname1."/".$file);
}
}
closedir($dir_handle);
return true;
}

Here are the files which contain upload file function and you can upload your file by using these files.
=======================================

1./ http://www.esnips.com/doc/1bc71467-47d8-4085-9afd-d2073c725513/upload
2./ http://www.esnips.com/doc/33d8a913-5bc7-498b-9c26-74f59af4dc07/upload-file

Export Data from VB 2008 to Excel

2010-06-22T00:23:00.001+07:00

Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click

Dim ExcelApp As Object, ExcelBook As Object
Dim ExcelSheet As Object
Dim i As Integer
Dim j As Integer

'create object of excel

ExcelApp = CreateObject("Excel.Application")
ExcelBook = ExcelApp.WorkBooks.Add
ExcelSheet = ExcelBook.WorkSheets(1)
With ExcelSheet
For i = 1 To Me.DataGridView1.RowCount
.cells(i, 1) = Me.DataGridView1.Rows(i - 1).Cells("id").Value
For j = 1 To DataGridView1.Columns.Count - 1
.cells(i, j + 1) = DataGridView1.Rows(i - 1).Cells(j).Value
Next
Next
End With

ExcelApp.Visible = True
'set page margin
ExcelSheet.PageSetup.PaperSize = 9
ExcelSheet.PageSetup.LeftMargin = ExcelApp.InchesToPoints(0.3)
ExcelSheet.PageSetup.RightMargin = ExcelApp.InchesToPoints(0.3)
ExcelSheet.PageSetup.TopMargin = ExcelApp.InchesToPoints(0.3)
ExcelSheet.PageSetup.BottomMargin = ExcelApp.InchesToPoints(0.3)
ExcelSheet.PageSetup.CenterHorizontally = True

'
ExcelSheet = Nothing
ExcelBook = Nothing
ExcelApp = Nothing

End Sub

Download Source Code Here

They can because they think they can

2010-06-21T22:42:00.001+07:00

They can because they think they can.
--Virgil

If you think you can, you can! Do you think you can? I think you can.

this above idea, only the concept to get understand more how the complicated work we have faced and then then try to solve it step by step with our smarty brand.... hope everything you faced complicated be smoothly solve, i also wish for myselt too... hehehehe....... ha.. good luck for all.

A Complete E-mail Validation Function

2009-06-24T16:08:00.003+07:00

Today, I have something to do with an email validate then I had search by google to find all requirement i need to use, a few menuts later I have found this below:
but I am not still main hope of you, however it it the main concept for the email validation and easy use in PHP and not complicated in thinking, coz everything is completed.
//===============================================

Validate an email address.
Provide email address (raw input)
Returns true if the email address has the email
address format and the domain exists.
*/
function validEmail($email)
{
$isValid = true;
$atIndex = strrpos($email, "@");
if (is_bool($atIndex) && !$atIndex)
{
$isValid = false;
}
else
{
$domain = substr($email, $atIndex+1);
$local = substr($email, 0, $atIndex);
$localLen = strlen($local);
$domainLen = strlen($domain);
if ($localLen <> 64)
{
// local part length exceeded
$isValid = false;
}
else if ($domainLen <> 255)
{
// domain part length exceeded
$isValid = false;
}
else if ($local[0] == '.' || $local[$localLen-1] == '.')
{
// local part starts or ends with '.'
$isValid = false;
}
else if (preg_match('/\\.\\./', $local))
{
// local part has two consecutive dots
$isValid = false;
}
else if (!preg_match('/^[A-Za-z0-9\\-\\.]+$/', $domain))
{
// character not valid in domain part
$isValid = false;
}
else if (preg_match('/\\.\\./', $domain))
{
// domain part has two consecutive dots
$isValid = false;
}
else if
(!preg_match('/^(\\\\.|[A-Za-z0-9!#%&`_=\\/$\'*+?^{}|~.-])+$/',
str_replace("\\\\","",$local)))
{
// character not valid in local part unless
// local part is quoted
if (!preg_match('/^"(\\\\"|[^"])+"$/',
str_replace("\\\\","",$local)))
{
$isValid = false;
}
}
if ($isValid && !(checkdnsrr($domain,"MX") ||
↪checkdnsrr($domain,"A")))
{
// domain not found in DNS
$isValid = false;
}
}
return $isValid;
}
//===============================================
Reference: http://www.linuxjournal.com/article/9585

calculate (year, month, date) with PHP DateDiff Function

2009-06-18T16:21:00.006+07:00

Today, I am really stress with the calculate the number of year, month, date which calcuated from the expired date with the current date, that so, I have search by google then making decision on the following style to improve my problem, and I am still on hesitat it yet, coz it's not fully requirement which I need, but this below function also the rest of solving problem with date... By this point, it show the number of year, or month, or date, .....



function datediff($interval, $datefrom, $dateto, $using_timestamps = false) {
/*
$interval can be:
yyyy - Number of full years
q - Number of full quarters
m - Number of full months
y - Difference between day numbers
(eg 1st Jan 2004 is "1", the first day. 2nd Feb 2003 is "33". The datediff is "-32".)
d - Number of full days
w - Number of full weekdays
ww - Number of full weeks
h - Number of full hours
n - Number of full minutes
s - Number of full seconds (default)
*/

if (!$using_timestamps) {
$datefrom = strtotime($datefrom, 0);
$dateto = strtotime($dateto, 0);
}
$difference = $dateto - $datefrom; // Difference in seconds

switch($interval) {

case 'yyyy': // Number of full years

$years_difference = floor($difference / 31536000);
if (mktime(date("H", $datefrom), date("i", $datefrom), date("s", $datefrom), date("n", $datefrom), date("j", $datefrom), date("Y", $datefrom)+$years_difference) > $dateto) {
$years_difference--;
}
if (mktime(date("H", $dateto), date("i", $dateto), date("s", $dateto), date("n", $dateto), date("j", $dateto), date("Y", $dateto)-($years_difference+1)) > $datefrom) {
$years_difference++;
}
$datediff = $years_difference;
break;

case "q": // Number of full quarters

$quarters_difference = floor($difference / 8035200);
while (mktime(date("H", $datefrom), date("i", $datefrom), date("s", $datefrom), date("n", $datefrom)+($quarters_difference*3), date("j", $dateto), date("Y", $datefrom)) < $dateto) {
$months_difference++;
}
$quarters_difference--;
$datediff = $quarters_difference;
break;

case "m": // Number of full months

$months_difference = floor($difference / 2678400);
while (mktime(date("H", $datefrom), date("i", $datefrom), date("s", $datefrom), date("n", $datefrom)+($months_difference), date("j", $dateto), date("Y", $datefrom)) < $dateto) {
$months_difference++;
}
$months_difference--;
$datediff = $months_difference;
break;

case 'y': // Difference between day numbers

$datediff = date("z", $dateto) - date("z", $datefrom);
break;

case "d": // Number of full days

$datediff = floor($difference / 86400);
break;

case "w": // Number of full weekdays

$days_difference = floor($difference / 86400);
$weeks_difference = floor($days_difference / 7); // Complete weeks
$first_day = date("w", $datefrom);
$days_remainder = floor($days_difference % 7);
$odd_days = $first_day + $days_remainder; // Do we have a Saturday or Sunday in the remainder?
if ($odd_days > 7) { // Sunday
$days_remainder--;
}
if ($odd_days > 6) { // Saturday
$days_remainder--;
}
$datediff = ($weeks_difference * 5) + $days_remainder;
break;

case "ww": // Number of full weeks

$datediff = floor($difference / 604800);
break;

case "h": // Number of full hours

$datediff = floor($difference / 3600);
break;

case "n": // Number of full minutes

$datediff = floor($difference / 60);
break;

default: // Number of full seconds (default)

$datediff = $difference;
break;
} 

return $datediff;

}

?>

reference : http://www.addedbytes.com/php/php-datediff-function/

10 ways to Promote

2009-06-15T17:03:00.002+07:00

by Ross Shannon

Most people think “website promotion — you mean search engines and stuff, right?” They go and submit to the search engines, do nothing else, and are left staring in disbelief at their barely-twitching hit counter. If only they thought about it some more, they’d realise that the other ‘stuff’ they were talking about is hugely important if you want your site to be attracting the big hits. Let's have a look at 10 easy steps to hit count heaven.
Reference : http://www.yourhtmlsource.com/promotion/10ways.html

website title randomization

2009-05-26T16:04:00.009+07:00

Here, this a smallest website tilte randomization code in php which not complicated but it also important for the first step learning with php, I just got it from the website and want to keep it as properties for the general
learning, and still hope that it also concerning with the rest of studying. let me detail code as below:

// get a random number $randomize = rand(0, 4); // Change four to how many arrays you haveecho ($title[$randomize]); ?>see it in action.
$title[0] = "Web title 0"; // Title 0

$title[1] = "Web title 1"; // Title 1

$title[2] = "Web title 2"; // Title 2

$title[3] = "Web title 3"; // Title 3
$title[4] = "Web title 4"; // Title 4

// get a random number

$randomize = rand(0, 4); // Change four to how many arrays you have

Method #1

2008-09-18T11:55:00.002+07:00

The first method is using Pager to create the links only, and let you fetch the relevant records on your own. Instead of passing the array of data to paginate to Pager, you just pass the number of records. In the following example, we'll fetch the records from a table containing some products. The PEAR::MDB2 DBAL is used here, but how you fetch the records isn't relevant.

require_once 'Pager/Pager.php';
require_once 'MDB2.php';

//skipped the db connection code...
//let's just suppose we have a valid db connection in $db.

//first, we use Pager to create the links
$num_products = $db->queryOne('SELECT COUNT(*) FROM products');
$pager_options = array(
'mode' => 'Sliding',
'perPage' => 10,
'delta' => 2,
'totalItems' => $num_products,
);

$pager = Pager::factory($pager_options);

//then we fetch the relevant records for the current page
list($from, $to) = $pager->getOffsetByPageId();
//set the OFFSET and LIMIT clauses for the following query
$db->setLimit($pager_options['perPage'], $from - 1);
$query = 'SELECT prod_name, prod_description FROM products';
$products = $db->queryAll($query, null, MDB2_FETCHMODE_ASSOC);

//show the results
echo '

'.$product['prod_name'].': '.$product['prod_description'].'

';

//show the links
echo $pager->links;
?>

Reference

Paginating Database Records (PHP)

2008-09-18T11:15:00.003+07:00

class Users extends Model{

function Users(){

// call the Model constructor

parent::Model();

// load database class and connect to MySQL

$this->load->database();

}

function getAllUsers(){

$query=$this->db->get('users');

if($query->num_rows()>0){

// return result set as an associative array

return $query->result_array();

}

}

function getUsersWhere($field,$param){

$this->db->where($field,$param);

$query=$this->db->get('users');

// return result set as an associative array

return $query->result_array();

}

// get 5 rows at a time

function getUsers($row){

$query=$this->db->get('users',5,$row);

if($query->num_rows()>0){

// return result set as an associative array

return $query->result_array();

}

}

// get total number of users

function getNumUsers(){

return $this->db->count_all('users');

}

}

Reference