PHP Programming 101

October 10th, 2010

How to Export Data From MySql to CSV

Posted by Edi in Codes, PHP

This is a simple code that exports mysql database data to csv (delimated) data.

//a small class for database connectivity
class database {
private $db_handle;
private $user_name;
private $password;
private $data_base;
private $host_name;
private $sql;
private $results;
function __construct($host = “localhost”, $user, $passwd) {
$this->db_handle = mysql_connect($host, $user, $passwd);
}
function dbSelect($db) {
$this->data_base = $db;
if (!mysql_select_db($this->data_base, $this->db_handle)) {
error_log(mysql_error(), 3, “/phplog.err”);
die(”Error connecting to Database”);
}
}
function executeSql($sql_stmt) {
$this->sql = $sql_stmt;
$this->result = mysql_query($this->sql);
}
function returnResults() {
return $this->result;
}
}
//database variables
$host = “localhost”;
$user = “root”;
$passwd = “”;
$db = “bg_db”;
$sql = “SELECT * FROM table ORDER BY id”; // a query to fetch records from database
$dbObject = new database($host, $user, $passwd);
$dbObject->dbSelect($db);
$dbObject->executeSql($sql);
$res = $dbObject->returnResults(); // result reasource
$newFileName = “emp_names.csv”; //file name that you want to create
$fpWrite = fopen($newFileName, “w”); // open file as writable
$nameStr = “”;
$rows = mysql_fetch_assoc($res); // fetching associate records
$sStr = “”;
//first store the fields name as header of csv in $sStr
foreach($rows as $key=>$val) {
$sStr .= $key.”,”;
}
//then store all records
do {
$sStr .= “– —–\n”; //to seprate every record
foreach($rows as $key=>$row) {
$sStr .= $row.”,”;
}
}while($rows = mysql_fetch_assoc($res));
$sStrExp = explode(”– —–”, $sStr);//separate every record
foreach($sStrExp as $val) {
$sStr2 .= rtrim($val, “,”);
}
echo $sStr2;
fwrite($fpWrite, $sStr2); //now write to csv file
fclose($fpWrite);//close file
?>

September 10th, 2010

Random Numbers

Posted by Conrad in Basic Programming, PHP, Programming


int rand ( [int min, int max])
int mt_rand ( [int min, int max])
int getrandmax ( )
int mt_getrandmax ( )
void srand ( [int seed])
void mt_srand ( [int seed])

Sometimes you want to take random actions in your code – it might be to give your web site visitors a different greeting each time they visit, you might be programming a game, or you might be trying to secure data by hashing it. Either way, randomisation is simple and helpful thing to remember, and has just two functions: rand(), and mt_rand().

Both functions do the same thing, and both take the same parameters, so what is the difference between the two? Well, rand() is a basic randomisation function that is very quick but not very “random” – the numbers it generates are slightly more predictable. Mt_rand() on the other hand, is more complicated – the “mt” parts means Mersenne Twister, as that is the name of the randomisation algorithm it uses. Mt_rand() returns much more “random” numbers, but does so at the expense of some speed.

As mentioned, both functions have the same parameters – two optional numbers, for the minimum number to return and the maximum number to return. Either you supply no parameters, which will result in PHP returning a random number between one and a very high number, or you can supply the two parameters. Here is an example:

$random = rand();
$randrange = rand(1,10);
$mtrandrange = mt_rand(1,100);
?>

Note that the two numbers passed in are inclusive. That is, our $randrange number could be anywhere between 1 and 10 including 1 and 10.

As mentioned, if you do not pass any parameters to your rand() and mt_rand() calls, PHP will generate a random number from 1 to a high number. If you want to find out the maximum number PHP can return from a rand() call, use getrandmax(). There is a similar function, mt_getrandmax() for mt_rand().

Now you know how randomisation works, here is a quick example to show you how you can make use of randomisation to greet web site visitors in various ways:


switch(rand(1,6)) {
case 1:
$greet = 'Hello!'; break;
case 2:
$greet = 'Welcome!'; break;
case 3:
$greet = 'Greetings!'; break;
case 4:
$greet = 'Salutations!'; break;
case 5:
$greet = 'Good day!'; break;
case 6:
$greet = 'Yo!'; break;
}

print $greet;
?>

Here we have not bothered assigning the result of rand() to a variable before putting it into the switch statement, but you can do it whichever way is easier for you to read.

One important thing to note is that the speed of randomisation does not depend on the sizes you pass into it – rand() is just as fast in rand(1,3) as it is in rand(1, 10000000). Mt_rand() works just short of 50% slower than rand(), which means you should only be using it if you particularly need the extra randomisation it brings.

To give you an idea of how fast the two run and how using larger values for randomisation makes no difference, try this script:


$START = time();
for ($i = 1; $i < 1000000; ++$i) {
$j = rand(1,100);
}
$END = time() - $START;
print "Short rand() took $END seconds\n";

$START = time();
for ($i = 1; $i < 1000000; ++$i) {
$j = mt_rand(1,100);
}
$END = time() - $START;
print "Short mt_rand() took $END seconds\n";

$START = time();
for ($i = 1; $i < 1000000; ++$i) {
$j = rand(1,10000000);
}
$END = time() - $START;
print "Long rand() took $END seconds\n";

$START = time();
for ($i = 1; $i < 1000000; ++$i) {
$j = mt_rand(1,10000000);
}
$END = time() - $START;
print "Long mt_rand() took $END seconds\n";
?>

Most random number generators require “seeding” – initialising with a starting value – because the numbers they generate are not truly random. Instead, they are known as pseudo-random, meaning that they appear to be random. The seed value is used to generate the first number, the first number is used to generate the second number, the second for the third, etc, meaning that if you always supply the same seed value you will always get the same string of “random” numbers. This is actually advantageous. Many years ago there was a popular game called Elite available on the BBC Micro, where the player was allowed to fly around a large universe of eight galaxies, each with thousands of star systems. Each star system had a very precise number of planets, a distinct economy situation, etc, and yet the entire universe fit into just 22K of memory. How was this possible? Simple: by providing the same seed to their random number generator, the exact same universe could be generated each time.

Of course, this is a fairly rare situation. More often than not you will want numbers that look random as opposed to numbers that are always the same, and this is where random seeding comes in. If you provide a random number to the random number generator as its seed, you will have a new and original string of random numbers coming out. Does this sound like a chicken and egg situation to you? That is, how do we get the random number to provide to the random number generator? Well, think of what randomness – usually called entropy – you can draw upon in your scripts.

  • The number of files in your temp directory?
  • The number of rows in your database?
  • The time your script was called?

Of all three of these, the latter is potentially the most random – you do not control when your script is called, and you are certainly never likely to have the same script called in the exact same microsecond, so you could use the return value from microtime() as your initial random seed.

The seed function for rand() is srand(), and it takes one parameter – an integer to use as the seed value. If you are using mt_rand(), you should use mt_srand() for seeding. If you recall from earlier, microtime() returns a floating-point number – this is no good for use as the parameter to srand() (or mt_srand() – it is exactly the same), so you need to make it into an integer before use.

Now, as we know that microtime() returns the time in millionths of a second, we can convert its return value to an integer by multiplying it by a million, like this:

srand((double)microtime()*1000000);

The code above should seed the standard random number generator fairly well. You can do the same for the Mersenne Twister generator with this code:

mt_srand((double)microtime()*1000000 );

If you want your random number to always generate the same string of numbers, simply supply a seed that is a known value. For example, no matter how often you run it, this next script will always generate the same “random” numbers:


mt_srand(123456);
echo mt_rand(1, 100), "\n";
echo mt_rand(1, 100), "\n";
echo mt_rand(1, 100), "\n";
?>

The last option is just to call srand()/mt_srand() without any parameters at all. In this situation, PHP will attempt to generate a random seed for you – not much good if you want reliably random numbers or if you have a particularly good source of entropy for your seed value, but generally good enough for most people.

As of PHP 4.2.0, there is no need to seed the random number generator with srand() or mt_srand() as this is done automatically.

Source

July 10th, 2010

Reading the current time: time() and microtime()

Posted by Conrad in Basic Programming, PHP


int time ( )
mixed microtime ( [bool get_as_float])

PHP has a basic function to get the current time in epoch format: time(). Time() takes no parameters, and returns the current timestamp representing the current time. As time() is the first function we have looked at, here is an example script:


print time();
$foo = time();
print $foo;
?>

As you can see, we can either print the return value of time() directly, or we can store it away in a variable then print the contents of the variable – the result is identical.

Working in Unix time means you are not tied down to any specific formatting – you do not need to worry about whether your date has months before days or vice versa, whether long months are used, whether day numbers of day words (Saturday, Tuesday, etc) are used, and so on.

Furthermore, to add one to a day (that is, to get the date of tomorrow), you can just add one day’s worth of seconds to your current timestamp: 60 x 60 x 24 = 86400. So, adding or subtracting 86400 to a date moves forward by one day, and so on – easy, really.

For more precise time values, you can use the microtime() function. When called without any parameters, this returns the current system time in seconds and microseconds, ordered microseconds first. For example: 0.82112000 1174676574

If you pass true to microtime() as its only parameter, PHP will return the time in a more obvious format – seconds.microseconds, like this: 1174676587.5996

When using microtime(), keep in mind that the return value is a floating-point number. There is a setting in your php.ini file called “precision”, which sets the number of significant digits to show in floating-point numbers – note that is significant digits, not decimal places, which means your return value from microtime() may not be as precise as you want. Above, for example, you can see we only have four decimal places returned – this is because php.ini defaults precision to 14, and there are ten digits before the decimal place.

If you increase the value of precision up to, say, 18, and run microtime() again, you will get results that are more accurate: 1174677004.8997819.

Source

December 17th, 2009

6 Tips For Better Form Design (3/3)

Posted by binary in PHP


INFORM THE USERS ABOUT INPUT LIMITS

When your database has a field limit, situate a size limit on a text box – this stops people from entering too much text only to find out that their data has been trimmed down by your database.

KEEP FORMS SHORT
Never make forms too long and verbose- this may cause confusion to people and may intimidate them.

TELL THEM WHERE THEY ARE
In case of splitting forms by pages, it is a good idea to let your visitors know how far they are through the process of form submission. This lets people know where they are at the process all times.

November 15th, 2009

6 Tips For Better Form Design (2/3)

Posted by binary in PHP

ERROR HANDLING
When there is an error within a field, always put a notice next to it and a message at the top indicating the user about the error – if you don’t put the message at the top, people will not notice that there is an error, and if you don’t put a notice near the problem field, people might not tell it from the others.


MARKING NECESSARY FIELDS

Always mark required fields – either with bold text, or, more commonly, an asterisk *. This is to make the users aware that the essential fields must first be satisfied before proceeding to the next step.

To be continued…

October 12th, 2009

6 Tips For Better Form Design (1/3)

Posted by binary in PHP

The use of forms is the main method in which users can send data to the scripts, so it is essential to get them right. Aside from the coding aspect of forms, there are a number of basic usability guidelines to follow to further improve the effectivity:

TABLES

The use of tables will make the layout of the elements appear neat and organized. Tables make the form easier to read, and it would also be easier to report individual errors that occur on fields. Also tables can also be utilized to give the form a design that would be pleasing to the eye without sacrificing practicality.

To be continued…

September 19th, 2009

SERVER REVIEW: APACHE vs. IIS (cont…)

Posted by binary in PHP

(cont…)

On the other hand, Microsoft’s Internet Information Server (IIS) is a group of internet servers which has additional fetures for Microsoft operating system such as Windows NT and windows 2000 operating system servers. IIS can’t use Java, Perl and PHP on a .Net platform because Microsoft doesn’t support those technologies but Web developers can use Microsoft’s Active Server Page (ASP)technology otherwise. IIS has server administrators which include console from which all services and users can be administered. According to www.microsoft.com “I IS 6.0 which is redesigned with a new fault-tolerant process architecture that greatly boosts the reliability of Web sites and applications. IIS 6.0 isolates Web sites and applications into self-contained units called application pools, which separate applications from the other applications that are hosted on the same server.” Now i give you free hand to choose on what server you want to use? IIS or APACHE?

ssl-iis51.gif

Image Source: www.trustis.com

August 16th, 2009

SERVER REVIEW: APACHE vs. IIS

Posted by binary in PHP

Apache is an open source http server named after the Native American. It is then first release in the year 1995. Now a day, Apache is considered as the most used http server in the world. It is compatible with almost all operating systems like Linux, Windows, Mac and etc. Almost anyone can adopt with this http server because of its source code is freely available. The Apache 2.0 which comes with a new Windows optimization technology called the Apache Portable Runtime (APR) while previous Apache version were not optimized for Windows. Apache developers can use Java, Perl and PHP on a .Net platform.

to be continued…

4229-apache-server.jpg

Image Source: www.pdftown.com

July 15th, 2009

OPENSOURCE DATABASE: MySQL

Posted by binary in PHP

MySQL is a Database Management System (DBMS) that is released in May of 1995. It’s commonly use for web applications and acts as the database component of different Platforms such as Linux/BSD/Mac/W-A-M-P/Perl/Python and for open-source bug tracking tools like bugzilla. MySQL are essential components of content management systems such as Joomla, Word Press, Drupal and some Bit Torrent trackers that is written in PHP and uses a MySQL database. The latest MySQL product version is the MySQL 5.0 that is launched last August 2007. It has two different variants such as MySQL Community Server and MySQL Enterprise Server. And soon to release is the MySQL 5.1.

logo-mysql.jpg

Image Source: www.openlife.cc

June 22nd, 2009

PHP Browser Checking Script

Posted by Conrad in Basic Programming, Information, PHP

Several factors are to be considered should one be involved with deploying projects over the internet. One of the things you could do would be to have a nifty script that checks for the particular browser your clients might be using. This can be done with a simple and short piece of code that can mean the difference between a successful deployment without problems allowing proper extensions and plugins to be included. A sample of the code can be seen below for your reference which makes it easier for your program/web page to know which set of scripts and what parameters to adhere with. (more…)

Next Page »