<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5028150151420187119</id><updated>2024-10-24T15:38:49.231-07:00</updated><category term="5"/><category term="automated"/><category term="automating"/><category term="basic"/><category term="design"/><category term="designer"/><category term="login"/><category term="of"/><category term="php development"/><category term="php software"/><category term="rules"/><category term="software"/><category term="web"/><category term="web design"/><category term="web development"/><category term="web site"/><category term="website"/><title type='text'>ZULKRONZ BORNEO ICT CENTER</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://zulkronzborneoictcenter.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5028150151420187119/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://zulkronzborneoictcenter.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Kehidupan</name><uri>http://www.blogger.com/profile/05224445797713999245</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>4</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5028150151420187119.post-8756252830169240175</id><published>2013-03-15T12:26:00.000-07:00</published><updated>2013-03-15T12:26:00.650-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="automated"/><category scheme="http://www.blogger.com/atom/ns#" term="automating"/><category scheme="http://www.blogger.com/atom/ns#" term="web site"/><title type='text'>For Automated Sites - PHP and MySQL Are A Perfect Match</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
&lt;br /&gt;
You’ve decided to automate your web site. Now what? Here are some ideas to help you choose how to automate your site.&lt;br /&gt;
&lt;br /&gt;
A bit of programming is going to be necessary if you want to automate a site. There are many types of programs that can be used to automate a web site including JavaScript, PHP, Perl, ASP, Java and more. So, which do you use? For many, it is a personal choice.&lt;br /&gt;
&lt;br /&gt;
I prefer PHP for programming. PHP is a particularly useful programming language because it allows for advanced programming and is easy to integrate with web pages. Another plus of PHP is that the language interfaces very well with MySQL, a popular type of online database.&lt;br /&gt;
&lt;br /&gt;
Yet another plus of PHP is that it is Open Source Code. The actual code that is PHP is available to the public for free, while the source code for products such as ASP are not. Because PHP is open source, there is a large community of PHP programmers that help each other with code. This means PHP programmers can rely on each other by using reusable pieces of code called functions and classes rather than constantly reinventing the wheel. This can dramatically cut down on production time.&lt;br /&gt;
&lt;br /&gt;
Overall, PHP is flexible, cheaper than many alternatives, and built around a community. PHP and MySQL are excellent choice for webmasters looking to automate their web sites.&lt;br /&gt;
&lt;br /&gt;
What Can PHP and MySQL do for me? Just about anything you can think of. That is the beauty of custom programming. A few ideas of what you can do with a PHP and MySQL driven site include:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;h4 style=&quot;text-align: left;&quot;&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;E-commerce&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;User Polls&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Keyword Tracking&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Set User Preferences&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Manage Password Protected Member&#39;s Areas&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Lead Follow Up&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Customer Relations&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Content Management&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Email Newsletters&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Accounting&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Invoicing&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Scheduled Updates&lt;/li&gt;
&lt;/ul&gt;
&lt;/h4&gt;
&lt;br /&gt;
&lt;br /&gt;
The list is limited only by your imagination. Once you have decided to go with a PHP and MySQL site, you can either get a custom program created, use a prepackaged version or a combination of both. Many PHP and MySQL programs that come prepackaged are easy to customize and can save you a lot of time and money over starting from the ground up.&lt;br /&gt;
&lt;br /&gt;
Zulkronz IT&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://zulkronzborneoictcenter.blogspot.com/feeds/8756252830169240175/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://zulkronzborneoictcenter.blogspot.com/2013/03/for-automated-sites-php-and-mysql-are.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5028150151420187119/posts/default/8756252830169240175'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5028150151420187119/posts/default/8756252830169240175'/><link rel='alternate' type='text/html' href='http://zulkronzborneoictcenter.blogspot.com/2013/03/for-automated-sites-php-and-mysql-are.html' title='For Automated Sites - PHP and MySQL Are A Perfect Match'/><author><name>Kehidupan</name><uri>http://www.blogger.com/profile/05224445797713999245</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5028150151420187119.post-6410935662217783487</id><published>2013-03-14T12:23:00.000-07:00</published><updated>2013-03-14T12:23:00.493-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="login"/><category scheme="http://www.blogger.com/atom/ns#" term="php development"/><category scheme="http://www.blogger.com/atom/ns#" term="php software"/><category scheme="http://www.blogger.com/atom/ns#" term="software"/><category scheme="http://www.blogger.com/atom/ns#" term="web design"/><category scheme="http://www.blogger.com/atom/ns#" term="web development"/><title type='text'>A login system with PHP and MySQL</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Many interactive websites nowadays require a user to log in into the website&#39;s system to provide a customized experience for the user. Once the user has logged in, the website will be able to provide a presentation that is personalized to the user&#39;s preferences.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
A basic login system typically contains 3 components which can be created using PHP and MySQL :&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;Component 1: Allows registration of preferred login Id and password.&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
This is created in simple HTML form that contains 3 fields and 2 buttons:&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;&amp;nbsp;A preferred login id field&amp;nbsp;&lt;/li&gt;
&lt;li&gt;A preferred password field&amp;nbsp;&lt;/li&gt;
&lt;li&gt;A valid email address field&amp;nbsp;&lt;/li&gt;
&lt;li&gt;A Submit button&amp;nbsp;&lt;/li&gt;
&lt;li&gt;A Reset button&amp;nbsp;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Lets say the form is coded into a file named register.html. The following HTML code extract is a typical example. When the user has filled in all the fields and clicks on the submit button, the register.php page is called for.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
[form name=&quot;register&quot; method=&quot;post&quot; action=&quot;register.php&quot;]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input name=&quot;login id&quot; type=&quot;text&quot; value=&quot;loginid&quot; size=&quot;20&quot;/][br]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input name=&quot;password&quot; type=&quot;text&quot; value=&quot;password&quot; size=&quot;20&quot;/][br]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input name=&quot;email&quot; type=&quot;text&quot; value=&quot;email&quot; size=&quot;50&quot;/][br]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input type=&quot;submit&quot; name=&quot;submit&quot; value=&quot;submit&quot;/]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input type=&quot;reset&quot; name=&quot;reset&quot; value=&quot;reset&quot;/]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
[/form]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
The following code extract can also be used as part of register.php to process the registration. The code connects to the MySQL database and inserts a line of data into the table used to store the registration information.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
@mysql_connect(&quot;localhost&quot;, &quot;mysql_login&quot;, &quot;mysql_pwd&quot;) or die(&quot;Cannot connect to DB!&quot;);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
@mysql_select_db(&quot;tbl_login&quot;) or die(&quot;Cannot select DB!&quot;);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
$sql=&quot;INSERT INTO login_tbl (loginid, password and email) VALUES (&quot;.$loginid.&quot;,&quot;.$password.&quot;,&quot;.$email.&quot;)&quot;;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
$r = mysql_query($sql);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
if(!$r) {&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; $err=mysql_error();&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; print $err;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; exit();&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
}&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
The code extract assumes that the MySQL table that is used to store the registration data is named tbl_login and contains 3 fields - the loginid, password and email fields. The values of the $loginid, $password and $email variables are passed in from the form in register.html using the post method.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;Component 2: Verification and authentication of the user.&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
In this the HTML form typically contains 2 fields and 2 buttons:&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;A login id field&amp;nbsp;&lt;/li&gt;
&lt;li&gt;A password field&amp;nbsp;&lt;/li&gt;
&lt;li&gt;A Submit button&amp;nbsp;&lt;/li&gt;
&lt;li&gt;A Reset button&amp;nbsp;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Assume that such a form is coded into a file named authenticate.html. The following HTML code extract is a typical example. When the user has filled in all the fields, the authenticate.php page is called when the user clicks on the Submit button.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
[form name=&quot;authenticate&quot; method=&quot;post&quot; action=&quot;authenticate.php&quot;]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input name=&quot;login id&quot; type=&quot;text&quot; value=&quot;loginid&quot; size=&quot;20&quot;/][br]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input name=&quot;password&quot; type=&quot;text&quot; value=&quot;password&quot; size=&quot;20&quot;/][br]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input type=&quot;submit&quot; name=&quot;submit&quot; value=&quot;submit&quot;/]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input type=&quot;reset&quot; name=&quot;reset&quot; value=&quot;reset&quot;/]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
[/form]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
The following code extract can be used as part of authenticate.php to process the login request. It connects to the MySQL database and queries the table used to store the registration information.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
@mysql_connect(&quot;localhost&quot;, &quot;mysql_login&quot;, &quot;mysql_pwd&quot;) or die(&quot;Cannot connect to DB!&quot;);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
@mysql_select_db(&quot;tbl_login&quot;) or die(&quot;Cannot select DB!&quot;);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
$sql=&quot;SELECT loginid FROM login_tbl WHERE loginid=&#39;&quot;.$loginid.&quot;&#39; and password=&#39;&quot;.$password.&quot;&#39;&quot;;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
$r = mysql_query($sql);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
if(!$r) {&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; $err=mysql_error();&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; print $err;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; exit();&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
}&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
if(mysql_affected_rows()==0){&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; print &quot;no such login in the system. please try again.&quot;;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; exit();&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
}&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
else{&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; print &quot;successfully logged into system.&quot;;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; //proceed to perform website&#39;s functionality - e.g. present information to the user&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
}&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
As in component 1, the code excerpt assumes that the MySQL table that is used to store the registration data is named tbl_login and contains 3 fields - the loginid, password and email fields. The values of the $loginid and $password variables are passed in from the form in authenticate.html using the post method.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;Component 3: &amp;nbsp;When the user forgets his logion password this 3rd component sends his password to the users registered email address.&amp;nbsp;&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
The HTML form typically contains 1 field and 2 buttons:&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;A login id field&amp;nbsp;&lt;/li&gt;
&lt;li&gt;A Submit button&amp;nbsp;&lt;/li&gt;
&lt;li&gt;A Reset button&amp;nbsp;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Assume that such a form is coded into a file named forgot.html. The following HTML code excerpt is a typical example. When the user has filled in all the fields, the forgot.php page is called when the user clicks on the Submit button.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
[form name=&quot;forgot&quot; method=&quot;post&quot; action=&quot;forgot.php&quot;]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input name=&quot;login id&quot; type=&quot;text&quot; value=&quot;loginid&quot; size=&quot;20&quot;/][br]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input type=&quot;submit&quot; name=&quot;submit&quot; value=&quot;submit&quot;/]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; [input type=&quot;reset&quot; name=&quot;reset&quot; value=&quot;reset&quot;/]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
[/form]&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
The following code excerpt can be used as part of forgot.php to process the login request. It connects to the MySQL database and queries the table used to store the registration information.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
@mysql_connect(&quot;localhost&quot;, &quot;mysql_login&quot;, &quot;mysql_pwd&quot;) or die(&quot;Cannot connect to DB!&quot;);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
@mysql_select_db(&quot;tbl_login&quot;) or die(&quot;Cannot select DB!&quot;);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
$sql=&quot;SELECT password, email FROM login_tbl WHERE loginid=&#39;&quot;.$loginid.&quot;&#39;&quot;;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
$r = mysql_query($sql);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
if(!$r) {&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; $err=mysql_error();&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; print $err;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; exit();&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
}&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
if(mysql_affected_rows()==0){&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; print &quot;no such login in the system. please try again.&quot;;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; exit();&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
}&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
else {&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; $row=mysql_fetch_array($r);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; $password=$row[&quot;password&quot;];&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; $email=$row[&quot;email&quot;];&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; $subject=&quot;your password&quot;;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; $header=&quot;from:you@yourdomain.com&quot;;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; $content=&quot;your password is &quot;.$password;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; mail($email, $subject, $row, $header);&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp; print &quot;An email containing the password has been sent to you&quot;;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
}&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
As in component 1, the code excerpt assumes that the MySQL table that is used to store the registration data is named tbl_login and contains 3 fields - the loginid, password and email fields. The value of the $loginid variable is passed from the form in forgot.html using the post method.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
This is how a basic login system can be created. The software developer can include additional tools like password encryption, access to the user profile in case they wish to edit their profile etc.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
This article has been compiled by the content development team at Pegasus InfoCorp which pulls subject matter specialists from different work domains. They can be contacted through the Pegasus InfoCorp website at info@pegasusinfocorp.com. Pegasus InfoCorp is an India based web design, web development and online/offline software development company. Please visit http://www.pegasusinfocorp.com to read more articles and know more about us!&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Other companies and organizations are welcome to reprint this article on their websites provided the following conditions are met.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;amp;#61607;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;The article is not changed in any manner&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;amp;#61607;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;The article is copied as is in its entirety (including back links to the Pegasus InfoCorp website).&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;amp;#61607;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;The company/ organization reprinting the article agrees to defend, indemnify and hold harmless Pegasus InfoCorp, its employees, directors, officers, agents, partners and their successors and assigns from and against any and all liabilities, damages, losses, costs and expenses, including attorney&#39;s fees, caused by or arising out of claims based upon the use of the article, including any claim of libel, defamation, violation of rights of privacy or publicity, loss of service by subscribers and infringement of intellectual property or other rights&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Zulkronz IT&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://zulkronzborneoictcenter.blogspot.com/feeds/6410935662217783487/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://zulkronzborneoictcenter.blogspot.com/2013/03/a-login-system-with-php-and-mysql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5028150151420187119/posts/default/6410935662217783487'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5028150151420187119/posts/default/6410935662217783487'/><link rel='alternate' type='text/html' href='http://zulkronzborneoictcenter.blogspot.com/2013/03/a-login-system-with-php-and-mysql.html' title='A login system with PHP and MySQL'/><author><name>Kehidupan</name><uri>http://www.blogger.com/profile/05224445797713999245</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5028150151420187119.post-7054699056199074142</id><published>2013-03-13T12:19:00.004-07:00</published><updated>2013-03-13T12:19:58.234-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="5"/><category scheme="http://www.blogger.com/atom/ns#" term="basic"/><category scheme="http://www.blogger.com/atom/ns#" term="design"/><category scheme="http://www.blogger.com/atom/ns#" term="designer"/><category scheme="http://www.blogger.com/atom/ns#" term="of"/><category scheme="http://www.blogger.com/atom/ns#" term="rules"/><category scheme="http://www.blogger.com/atom/ns#" term="web"/><category scheme="http://www.blogger.com/atom/ns#" term="website"/><title type='text'>5 Basic Rules of Web Design</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
5 Basic Rules of Web Design the most important rule in web design is that your web site should be easy to read. What does this mean? You should choose your text and background colours very carefully. You don&#39;t want to use backgrounds that obscure your text or use colours that are hard to read. Dark-coloured text on a light-coloured background is easier to read than light-coloured text on a dark background.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
You also don&#39;t want to set your text size too small (hard to read) or too large (it will appear to shout at your visitors). All capitalised letters give the appearance of shouting at your visitors.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Keep the alignment of your main text to the left, not cantered. Centre-aligned text is best used in headlines. You want your visitors to be comfortable with what they are reading, and most text is left aligned.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Your web site should be easy to navigate&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
All of your hyperlinks should be clear to your visitors. Graphic images, such as buttons or tabs, should be clearly labelled and easy to read. Your web graphic designer should select the colours, backgrounds, textures, and special effects on your web graphics very carefully. It is more important that your navigational buttons and tabs be easy to read and understand than to have &quot;flashy&quot; effects. Link colours in your text should be familiar to your visitor (blue text usually indicates an unvisited link and purple or maroon text usually indicates a visited link), if possible. If you elect not to use the default colours, your text links should be emphasized in some other way (boldfaced, a larger font size, set between small vertical lines, or a combination of these). Text links should be unique - they should not look the same as any other text in your web pages. You do not want people clicking on your headings because they think the headings are links.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Your visitors should be able to find what they are looking for in your site within three clicks. If not, they are very likely to click off your site as quickly as they clicked on.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;Your web site should be easy to find&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
How are your visitors finding you online? The myth, &quot;If I build a web site, they will come,&quot; is still a commonly held belief among companies and organisations new to the Internet. People will not come to your web site unless you promote your site both online and offline.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Web sites are promoted online via search engines, directories, award sites, banner advertising, electronic magazines (e-zines) and links from other web sites. If you are not familiar with any of these online terms, then it is best that you have your site promoted by an online marketing professional.&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Web sites are promoted offline via the conventional advertising methods: print ads, radio, television, brochures, word-of-mouth, etc. Once you have created a web site, all of your company&#39;s printed materials including business cards, letterhead, envelopes, invoices, etc. should have your URL printed on them.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Not only should your web site be easy to find, but your contact information should be easy to find. People like to know that there is a person at the other end of a web site who can help them in the event that:&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;They need answers to questions which are not readily available on your web site;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;Some element on your site is not working and end users need to be able to tell you about it, and&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Directory editors need you to modify parts of your site to be sure that your site is placed in the most relevant category.&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
By giving all relevant contact information (physical address, telephone numbers, fax numbers, and email address), you are also creating a sense of security for your end users. They can contact you in the way that makes them feel the most comfortable.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;Your web page layout and design should be consistent throughout the site&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Just as in any document formatted on a word processor or as in any brochure, newsletter, or newspaper formatted in a desktop publishing program, all graphic images and elements, typefaces, headings, and footers should remain consistent throughout your web site. Consistency and coherence in any document, whether it is a report or a set of web pages, project a professional image.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
For example, if you use a drop shadow as a special effect in your bullet points, you should use drop shadows in all of your bullets. Link-colours should be consistent throughout your web pages. Typefaces and background colours, too, should remain the same throughout your site.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Colour-coded web pages, in particular, need this consistency. Typefaces, alignment in the main text and the headings, background effects, and the special effects on graphics should remain the same. Only the colours should change.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;Your web site should be quick to download&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Studies have indicated that visitors will quickly lose interest in your web site if the majority of a page does not download within 15 seconds. (Artists&#39; pages should have a warning at the top of their pages.) Even web sites that are marketed to high-end users need to consider download times. Sometimes, getting to web sites such as Microsoft or Sun Microsystems is so difficult and time consuming that visitors will often try to access the sites during non-working hours from their homes. If your business does not have good brand name recognition, it is best to keep your download time as short as possible.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
A good application of this rule is adding animation to your site. Sure, animation looks &quot;cool&quot; and does initially catch your eye, but animation graphics tend to be large files. Test the download time of your pages first. If the download time of your page is relatively short and the addition of animation does not unreasonably increase the download time of your page, then and ONLY then should animation be a consideration.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Finally, before you consider the personal preferences of your web page design, you should consider all of the above rules FIRST and adapt your personal preferences accordingly. The attitude &quot;I don&#39;t like how it looks&quot; should always be secondary to your web site&#39;s function. Which is more important: creative expression/corporate image or running a successful business?&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Zulkronz IT&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://zulkronzborneoictcenter.blogspot.com/feeds/7054699056199074142/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://zulkronzborneoictcenter.blogspot.com/2013/03/5-basic-rules-of-web-design.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5028150151420187119/posts/default/7054699056199074142'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5028150151420187119/posts/default/7054699056199074142'/><link rel='alternate' type='text/html' href='http://zulkronzborneoictcenter.blogspot.com/2013/03/5-basic-rules-of-web-design.html' title='5 Basic Rules of Web Design'/><author><name>Kehidupan</name><uri>http://www.blogger.com/profile/05224445797713999245</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5028150151420187119.post-6400435624045623984</id><published>2011-03-27T04:27:00.001-07:00</published><updated>2011-03-27T04:29:42.811-07:00</updated><title type='text'></title><content type='html'>&lt;iframe src=&quot;http://astore.amazon.com/gaimonmormon-20&quot; width=&quot;90%&quot; height=&quot;4000&quot; frameborder=&quot;0&quot; scrolling=&quot;no&quot;&gt;&lt;/iframe&gt;</content><link rel='replies' type='application/atom+xml' href='http://zulkronzborneoictcenter.blogspot.com/feeds/6400435624045623984/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://zulkronzborneoictcenter.blogspot.com/2011/03/blog-post.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5028150151420187119/posts/default/6400435624045623984'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5028150151420187119/posts/default/6400435624045623984'/><link rel='alternate' type='text/html' href='http://zulkronzborneoictcenter.blogspot.com/2011/03/blog-post.html' title=''/><author><name>Kehidupan</name><uri>http://www.blogger.com/profile/05224445797713999245</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>