B&T's Tool Box
B&T's Tips & Scripts is a collection of Tips & Scripts to help you build a better website. The Tips & Scripts are targeted towards the native Apache PHP MySQL environment. Check back frequently as there will be additions and modifications. Please check our terms of use.
B&T's Tips & Scripts is a safe website.
No pop-up ads and no evil downloads.
No pop-up ads and no evil downloads.
Have you had enough programming and website building for a while?
Need a break to clear your mind?
Go to PrettyWorthless.com, where you will find nothing of value.
Need a break to clear your mind?
Go to PrettyWorthless.com, where you will find nothing of value.
Using .htaccess 
- .htaccess Basics Mar 9, 2006
- Domain & subdomain pointing May 12, 2005
- Automatic subdomains Jun 17, 2007
- Undefined subdomains Jul 20, 2008
- Prevent direct access to a pointer or subdomain directory Aug 15, 2006
- Forcing or eliminating the WWW. Feb 9, 2005
- Fixing the trailing slash problem May 11, 2005
- Friendly URLs Mar 21, 2007
- Rewrites and https Dec 18, 2007
- Blocking traffic to your website Jan 2, 2005
- Anti-leech May 25, 2005
- Fancy default index page Jan 25, 2005
Using .htaccess/.htpasswd Password Protection 
- Setting up password protection Feb 9, 2005
- Encrypt your password for .htpasswd Dec 21, 2007
- Auto Password Change and Email Notification Dec 21, 2007
php5 - Auto generate .htpasswd file Dec 18, 2007 php5
- Passing user authentication information to PHP Jun 13, 2004
Coding Tips 
- HTML "One Liners" Nov 13, 2005
- PHP "One Liners" Apr 5, 2007
- JavaScript "One Liners" Aug 25, 2007
- CSS examples Sep 9, 2006
- SQL coding examples Aug 29, 2006
- AJAX example Sep 24, 2006
Uploads and Downloads 
- File Upload Script Dec 20, 2007 php5
- Custom Download Page Dec 14, 2007 php5
- Tracking and Securing Downloads Dec 20, 2007 php5
Mail 
- Form Mail Aug 19, 2007
- Obfuscate your email address Nov 12, 2006
- Read and auto-process mail Nov 12, 2004
- Auto-responder Dec 18, 2007 php5
- Display your email message count Jul 30, 2004
- Setting up SPF Records Jan 4, 2007
- Specify a return-path for generated mail Jul 18, 2006
Working with Images 
- Watermark images Jul 14, 2007
- Resize images (create thumbnails) Jul 14, 2007
Frequently Requested Website Functionality 
- Visitor Counter Dec 14, 2007 php5
- 404 Error Page (with reporting and logging) Dec 20, 2007 php5
- CAPTCHA Aug 19, 2006
- Poll (voting) Dec 17, 2007 php5 see it on this page
- Weather Jul 27, 2008 php5
- FAQ Page May 23, 2005
- Random/weighted banners, quotes & more Feb 9, 2005
- Load a random image (simple) Jan 20, 2004
- Image (banner) rotation Oct 15, 2007
- Simple "members only" pages May 13, 2005
- Replace banned words Apr 5, 2007
- Get the most recent file date Jan 30, 2006
- Moving (bouncing) Image Nov 10, 2005
- Sticky default values for an input Oct 22, 2006
Using PHP 
- Creating a custom php.ini file Dec 18, 2007 php5
- Copying the php.ini file Dec 18, 2007 php5
- Deleteing php.ini files Dec 18, 2007 php5
- Clean up your PHP scripts Nov 11, 2005
- Regular Expression Rules Mar 22, 2006
Website Managment 
- Tips for keeping your website secure Jan 24, 2006
- Using Cron Sep 13, 2005
- Website Monitoring Dec 19, 2007
- Automated Site Backups Dec 19, 2007
- Automated MySQL Backups Dec 19, 2007
- Server-to-server file transfer December 16, 2006
- MySQL Error Notification Dec 20, 2007
- Find File and Directory Sizes Dec 14, 2007 php5
- Deleting session files Aug 9, 2006
- FTP made easy Mar 1, 2006
- Search and Replace Dec 14, 2007 php5
Other Tips 
- URL Validation Feb 8, 2008
- Stop direct links to web pages Jan 22, 2004
- Ensure your page is not opened in a frame May 5, 2005
- Masking your URL in the Address Bar Jul 20, 2004
- Ban or allow IP Addresses (without using .htaccess) Jan 19, 20008
- Using Cookies Sep 24, 2006
- View your website in different resolutions Jan 2, 2005
Back to Top Print this Tip
Auto generate .htpasswd file
This php script reads a MySQL database, encrypts the passwords and writes an htpasswd file. Using this script you can maintain a database of users and generate an .htpasswd file from the database.You can download this script as a .txt file. Remember to rename the file as a .php file.
- - Start Script Here - -
<?php
$filename = "your htpasswd file path goes here"; // your htpasswd file name - complete unix path - or relative to this script
$host="host"; // database host address
$dbuser="user"; // database user name
$dbpswd="password"; // database password
$mysqldb="db_name"; // name of database
$table="passwd_table"; // name of table
// modify the above lines for your environment
mysql_connect("$host", "$dbuser", "$dbpswd");
mysql_select_db ("$mysqldb");
$query = mysql_query("SELECT * FROM $table");
while ($row = mysql_fetch_array($query)) {
$user = $row['user'];
$pass = $row['password'];
$encrypted = crypt($pass);
$record .= "$user:$encrypted\r\n";
}
file_put_contents($filename,$record);
?>
- - End Script Here - -
Rate This Topic
