Posts Tagged: mysql
-
Aug 29, 2011
Comments OffBlocking access to the login page after three unsuccessful login attempts
Sometimes you need to add an extra protection to password-protected website. This article explains how access to the login page can be restricted after three unsuccessful login attempts. This schema uses visitors IP address to store log attempts in the database and block access to login feature for 30 minutes after third unsuccessful attempt. There...
-
Aug 29, 2011
Comments OffHow to Encrypt Passwords in the Database
If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. What is “secure,” anyway? Realize that the data in your database is not safe. What if the password to the database is compromised? Then your entire user password database will be compromised as...
-
Nov 30, 2010
Comments OffOpen Source Human Resource Management System using PHP and Mysql
Administration Module (Admin) The part of the system where the HR Manager or other appointed personnel perform all system administration tasks. This include defining company structure, pay grades and other information that serves as the backbone for the rest of the system. Security issues are taken care of through this module as well by defining...
-
Nov 30, 2010
Comments OffCreate a CSV file from MySQL with PHP
There are a couple of ways to export data from MySQL to a CSV file but neither of them supports adding a header row to the CSV which contains the column names. This post looks at how to export the data from MySQL into a CSV file with PHP including a header row. The example...
-
Nov 30, 2010
Comments OffPaging Using PHP and MySQL
When there’s more than one column involved in paging there isn’t much that we need to modify. We only need to decide how to count the total number of rows we have in the table. Consider the student table. This table have five columns as shown in the SQL below. CREATE TABLE student( id INTEGER...
-
Nov 30, 2010
Comments OffLoad JSON data with jQuery, PHP and MySQL
This post shows how to populate a select box based on the value of the another, by getting JSON data with jQuery from a PHP script that gets the data from a MySQL database. HTML Code The initial HTML code looks like this: Fruit: Apple Orange Banana Pear Variety: The set of fruit names was...
-
Nov 09, 2010
Comments OffHow did I reduce CPU overhead problem caused by MySql?
We were having problem with a project which was shut down in the middle due to heavy traffic. As a technical manager, I was the person who to take charge over the project bring it down to the track. After doing few benchmark test, I came to know that the MySql access from a PHP...
-
Mar 16, 2010
Comments OffHow did I reduce CPU overhead problem caused by MySql?
From last day, We were having problem with a project which was shut down in the middle due to heavy traffic. As a technical manager, I was the person who to take charge over the project bring it down to the track. After doing few benchmark test, I came to know that the MySql access...
-
Mar 03, 2010
Comments OffHow did I reduce CPU overhead problem caused by MySql?
From last day, We were having problem with a project which was shut down in the middle due to heavy traffic. As a technical manager, I was the person who to take charge over the project bring it down to the track. After doing few benchmark test, I came to know that the MySql access...