RyanTetek.com

Importing large SQL files through command line when using PHPMyAdmin/XAMPP

admin — Thu, 01 Sep 2011 04:27:37 +0000

This tutorial is on how to import large SQL files when your sql dump file cannot be handled by PHPMyAdmin due to its large file size. Importing large SQL file sizes in PHPMyAdmin will produce an error if maximum file upload size has been reached and sometimes may cause the browser to freeze. You have [...]

Date picker HTML select boxes with automatic date selection PHP snippet

admin — Tue, 09 Aug 2011 10:45:59 +0000

This PHP snippet creates a HTML datepicker and automatically selects the current date in the select boxes. <?php $current_month = date("m"); $current_day = date("d"); $current_year = date("Y"); ?> <select name="month"> <option value="01" <?php if($current_month == "01"){ echo "selected"; } ?>>January</option> <option value="02" <?php if($current_month == "02"){ echo "selected"; } ?>>February</option> <option value="03" <?php if($current_month == "03"){ echo "selected"; } ?>>March</option> <option value="04" <?php if($current_month == [...]

How to display PHP errors without altering php.ini file

admin — Wed, 13 Jul 2011 02:46:42 +0000

This quicktip will teach you on how display PHP errors on your website without altering your php.ini file and by just writing 2 lines of PHP code and including it in your config file or just including it into your page as an include file. Sometimes(or I say “always”) web hosting companies turn “display_errors” configuration [...]

IP address restrictions to protect directories using .htaccess

admin — Thu, 23 Jun 2011 07:47:42 +0000

This is a simple quick tool to protect any given directory of your choice by limiting the users viewing and accessing the folder by specifying the IP addresses that can only access it in .htaccess 1. Open your text editor, copy and paste the following code: AuthUserFile /dev/null AuthGroupFile /dev/null AuthName "Example Access Control" AuthType Basic <LIMIT GET> order deny,allow deny from all allow [...]

How to format MySQL Date and Time fields into user readable format

admin — Fri, 15 Apr 2011 04:06:21 +0000

Date and time fields or what we call timestamps stored in our Mysql databases has a format of “YYYY-MM-DD HH:MM:SS” or “2011-04-15 11:30:00″ . It is awkward for the users to to see dates outputted to something in that format, so for user readability and friendly purposes, we must output the date into something more [...]