Poudo.com - Blogs http://www.poudo.com/blog.php en Sat, 11 Oct 2008 01:05:42 GMT vBulletin 60 http://www.poudo.com/{IF}/misc/rss.jpg Poudo.com - Blogs http://www.poudo.com/blog.php Clicks heatmap http://www.poudo.com/blog.php?b=52 Wed, 21 Nov 2007 17:05:44 GMT It is a visual heatmap of clicks on a HTML page, showing hot and cold click zones. Image: http://www.ajaxrain.com/rainImage/092201.jpg... It is a visual heatmap of clicks on a HTML page, showing hot and cold click zones.



Demo|Information|Download ]]> escapeboy http://www.poudo.com/blog.php?b=52 Whizzywig - Rich text editor http://www.poudo.com/blog.php?b=51 Wed, 21 Nov 2007 17:03:14 GMT It lets people create rich, formatted text through a web form. It creates html or xhtml. Image: http://www.ajaxrain.com/rainImage/093001.jpg... It lets people create rich, formatted text through a web form. It creates html or xhtml.



Demo|Instructions|Download ]]> escapeboy http://www.poudo.com/blog.php?b=51 Table Editor : jQuery http://www.poudo.com/blog.php?b=50 Wed, 21 Nov 2007 17:00:17 GMT TableEditor provides flexible in place editing of HTML tables. Image: http://www.ajaxrain.com/rainImage/100403.jpg Demonstration and Download... TableEditor provides flexible in place editing of HTML tables.



Demonstration and Download ]]> escapeboy http://www.poudo.com/blog.php?b=50 Tab container themes http://www.poudo.com/blog.php?b=49 Wed, 21 Nov 2007 16:57:33 GMT Great collection of Sample AjaxControlToolkit TabContainer Themes. Image: http://www.ajaxrain.com/rainImage/101001.jpg Demo... Great collection of Sample AjaxControlToolkit TabContainer Themes.



Demo

More Information

Download ]]> escapeboy http://www.poudo.com/blog.php?b=49 Lightbox for videos http://www.poudo.com/blog.php?b=48 Wed, 21 Nov 2007 16:55:00 GMT Videobox is a 6kb script, which shows your videos in the page with an overlay.



Demo & Usage: Lightbox for videos

Download ]]> escapeboy http://www.poudo.com/blog.php?b=48 jQuery Ajax Rater Plugin http://www.poudo.com/blog.php?b=47 Wed, 21 Nov 2007 16:51:17 GMT Demo & use here: jQuery Ajax Rater Plugin

Download:
jquery.rater.js - Size: 4,35K
jquery.rater.packed.js - Size: 1,59K
jquery.rater-1.0.zip - Size: 5K

]]> escapeboy http://www.poudo.com/blog.php?b=47 Page rank using ajax http://www.poudo.com/blog.php?b=46 Wed, 21 Nov 2007 16:47:36 GMT Google Pagerank function done using Ajax and php. Very handy and useful. Demo: click here (http://213.198.89.146/chi/) Download files: click here... Google Pagerank function done using Ajax and php. Very handy and useful.

Demo: click here
Download files: click here

]]> escapeboy http://www.poudo.com/blog.php?b=46 Starting with PHP and AJAX http://www.poudo.com/blog.php?b=44 Thu, 25 Oct 2007 22:52:49 GMT This tutorial makes use of prototype AJAX library which can be downloaded here. It's a single JavaScript file which can be simply embed in the header section of your HTML code:
HTML Code:
<head>
	<script type="text/javascript" src="prototype.js"></script>
</head>
So in this demo, we have two files. The first file test.html contains a form with one input text box and a submit button. It also contains the javascript code for making the ajax request to test.php.

The 2nd file is the test.php which receives the ajax request when we click on the submit button.

When you fill in the test box and click the submit button, it displays the value of the text box without refreshing the page. See demo here. This is achieved using AJAX and it is really simple to accomplish.

First, I'll just copy the code for both files for you to see and explain the code line by line.

text.html

HTML Code:
<html>
	<head>		
		<script type="text/javascript" src="prototype.js"></script>
		<script>

			function sendRequest() {
				new Ajax.Request("test.php", 
					{ 
					method: 'post', 
					postBody: 'name='+ $F('name'),
					onComplete: showResponse 
					});
				}

			function showResponse(req){
				$('show').innerHTML= req.responseText;
			}
		</script>
	</head>

	<body>
		<form id="test" onsubmit="return false;">
			<input type="text" name="name" id="name" >
			<input type="submit" value="submit" onClick="sendRequest()">
		</form>
		
		<div id="show"></div>
	</body>

</html>
test.php

PHP Code:
<?php

if($_POST["name"] == "")
    echo "name is empty";
else
    echo "you typed ".$_POST["name"];
?>

Code Explained

Making AJAX Request

The function below sends the request out to our text.php script using the method post with the value filled in the input text box 'name' using $F(‘name') which retrieves the values we put in the text box. The onComplete: showResponse returns the repose from test.php

PHP Code:
function sendRequest() {

    new Ajax.Request("test.php", 
        { 
        method: 'post', 
        postBody: 'name='+ $F('name'),
        onComplete: showResponse 
        });
} 
Displaying Response

Next we show the response we get from the text.php in the <div id=”show”></div>.

PHP Code:
function showResponse(req){

    $('show').innerHTML= req.responseText;

} 
So, when you click on submit you will either get a response saying 'name is empty' if the text box was left empty or "you typed <yourname>".

PHP Code:
<?php
if($_POST["name"] == "")
    echo "name is empty";
else
    echo "you typed ".$_POST["name"];
?>
]]> escapeboy http://www.poudo.com/blog.php?b=44 A Simple .gif Gallery http://www.poudo.com/blog.php?b=43 Thu, 25 Oct 2007 22:47:15 GMT
PHP Code:
<?php 

    $handle=opendir('.'); 
    $strSought = "gif"; 
    $imgCount = 5;  

    while ($file = readdir($handle)) 
    { 
        if ($strSought == substr($file, -3)) 
        { 
            $imgCount = $imgCount + 1; 
        } 
    } 

    closedir($handle);

    if ($imgCount != 5)
    {
        $handle=opendir('.'); 

        $perRow = 4;

        $numRows = $imgCount/$perRow;

        $imgNum = 0;

        echo "<table width=\"300\" border=\"0\">"; 

         //Note: readdir returns filenames in the order in which they are 
         //    stored by the filesystem. Future enhancement: sort by filename 
         //    (sequence they were shot) 
         
         while (false !== ($file = readdir($handle))) 
         { 
            if ($strSought == substr($file, -3)) 
            { 
                $imgNum++;

                $size = GetImageSize($file); 

                $jpglink = substr($file, 0, 8);

                echo "<td><img src=\"$file\" height=\"$size[1]\" width=\"$size[0]\" border=\"0\" hspace=\"5\" vspace=\"5\">";                        

                //modulus (%) $a % $b remainder of $a divided by $b 
                if ($imgNum%$perRow)
                {
                echo "</td>";
                }
                else                            
                {
                echo "</td></tr><tr>";
                }
              }
      } 

     closedir($handle); 
     echo "</table>"; 
  }

?>
you can change this:
PHP Code:
 $imgCount = 5; 
to however many images you want in a row ]]> escapeboy http://www.poudo.com/blog.php?b=43 Reading and Writing files in PHP http://www.poudo.com/blog.php?b=42 Thu, 25 Oct 2007 22:45:09 GMT PHP follows almost same way of writing and manipulating files as in standard C. That is why it becomes so easy for a developer with C lanaguage... PHP follows almost same way of writing and manipulating files as in standard C. That is why it becomes so easy for a developer with C lanaguage background to create php application that uses files to save and retrieve data. It is a short tutoril that will get you started with writng and manipulating text files.

To open a file either for writing, manipulating (adding new data, or appending new data at end of file), we use single function called fopen, but the second argument of the function changes accordingly.

For example:
PHP Code:
$F = fopen("myfile.txt","w"); 
Here the second argument passed was "w" only, which means write the file, if it does not exists then create it, and if does not exist create new file.
Now, if a file with name myfile.txt already exists, it will be rewritten and all of its bytes are lost, if it was not existing a new file with name myfile.txt is created.

The second argument (we used "w") is the file opening mode, is dependant upon your requirement. In general disadvantage of using "w" as mode is if your ifle already exists, it is rewritten, and you loose all existing bytes. So it is recomended that you use mode "w" only when you need to create a new file or really wish to turn filesize to 0 (zero).

Second mode is "r", which is using for reading and writing. Using this filemode you can open a file for reading and writing. Although modes "r" as well as (append "a") allows read and write but they do not affect the file while opening it, so the "w" also allows writing + reading but as mentioned, it rewrites the file.

So, to open a file for reading and writing we will write:
PHP Code:
$F = fopen("myfile.txt","r"); 
And same if we need to open a file which starts writing data to the end of file (appends data), we will srite:
PHP Code:
$F = fopen("myfile.txt","a"); 
Remember : With both of these modes you can read as well as write data anywhere in the file.


Now question appears, if I open a file with mode "r" now I have ended up reading soem data, how can I force my script to start writing data on the end of file ?

Two answers:
1. If you have read entire data, the next writing automatically starts at the end of file.
2. If you read data less then the file size, you must be somewhere within file, and if you start writing data, the script will write data to the last position of data you ended up reading with.

To obtain filesize we use a function filesize, to which we only pass name of file alongwith path (if not current directory) and it returns us the size of the file in bytes. e.g.
PHP Code:
$size = filesize("myfile.txt"); 
Now, when you have opened a file for reading and you wish to jump to a certain position (in this case end of file), you use a function fseek which lets you jump within file to any possible position. e.g.

suppose your file size is 10 bytes, you read very first two characters. Now you wish to jum pto the end of file.
PHP Code:
//reading done, assume $F is file variable

$size = filesize("myfile.txt");

fseek($F, $size); //now we are at end of file

//start writing here 
The same we will do when we need to jump to the start of file as:
fseek($F,0); //0 means very first byte position

Bytes position in a file have zero based indexes, 0 means 1st character, 9 means 10th character and so on.


Now come to core of reading and wrting:

Writing is very simple, as I have mentioned in all above talk the writing starts where pointer (position) currently is so the reading too.

Example 1: Create new file and write string "My name is Ali" in it
PHP Code:
$F = fopen("myfile.txt","w");

fwrite($F,My name is Ali);

fclose($f); 
In this example you see two new functions fwrite and fclose.
fwrite is used to write something in a file at current position, since we created new file so writing starts at very first byte autoatically. And fclose is used to stop using a file anymore. This is necessary, becuase there is always a limit of opened files in operating system, so if your script is used much and leaves every file open without closing, it will results in no more file openable until system restart, either an http server (a web host) and/or local host. So, a new file is created and stirng "My name is Ali" is written in it (14 bytes written).


Example 2: Read first 7 bytes from file we created in example 1 and print them to browser
PHP Code:
$F = fopen("myfile.txt","r");

$data = fread($F, 7);

fclose($f);

print $data; 
In this example you encounter a ne function, called fread. This function is used to read specific number of bytes from a file. Its first argument is the file variable, and second is number of bytes to read. So we passed 7, becuase our rquirement at this time, is to read 7 bytes only. This function returned us the bytes read and we simpyl displayed them using print function, so it will display "My name" only the first7 bytes we read. Take a look at next example

Example 3: Read all data from file we created in example 1 and print it to browser

PHP Code:
$F = fopen("myfile.txt","r");

$size = filesize("myfile.txt");

$data = fread($F, $size);

fclose($f);

print $data; 
In this example we used function filesize, which returned us the exact file size in bytes, we saved that size in a varible $size and then passed it to fread as secnd argument, so that the fread function reads all the data in file. I think it is simple to understand. It will display "My name is Ali" in the browser.

Modifying data

Example 4: Jump to byte # 12 and write string "Imran"
PHP Code:
$F = fopen("myfile.txt","r");

fseek($F, 11);

fwrite($F,"Imran");

fclose($f);

print $data; 
We opened file, jumped to byte number 12 using fseek function. Why used 11 when we need to start modifying from byte 12 ? Because I already mentioned that bytes in a file are accessed using zero based index, 11 means 12, 59 means 60, and 0 means 1st byte. Now run the example 3 and you will see the display in browser is "My name is Imran", which means we successfully have modified the file.

Example 5: Add string ". My age is 30" to the end of file we created in example 1
PHP Code:
$F = fopen("myfile.txt","a"); //note "a"

fwrite($F,". My age is 30");

fclose($f);

print $data; 
We opened file with append mode, using "a" as second argumen to function fopen, which automatically takes position to the end of file, s owe dont need to use fseek in thsi regards. Now if you repeat running example 3 you will get the output as "My name is Imran. My age is 30".


Extra things:

1. Another method to read entire file data in a variable
PHP Code:
$data = get_file_contents("myfile.txt"); 
2. Read text file as an array of strings, where each line of text is an ite of array
PHP Code:
$arr = file("myfile.txt"); 
3. If you dont have above function in your php distribution, use following ot read entire data
PHP Code:
$data = implode("",file("myfile.txt")); 
4. to delete a file
PHP Code:
unlink("myfile.txt"); 
5. read page from internet
pass url instead of fileme in ne of first 3 examples.

I hope I have explained some.

Let me know if you have any question. ]]> escapeboy http://www.poudo.com/blog.php?b=42 Easy way to Upload files using PHP http://www.poudo.com/blog.php?b=41 Thu, 25 Oct 2007 22:38:46 GMT There is a traditional way of uploading files in php usually developers use, that is, use functions is_uploaded_file() and move_uplaoded_file().... There is a traditional way of uploading files in php usually developers use, that is, use functions is_uploaded_file() and move_uplaoded_file(). These functions my create problems sometimes. function move_uplaoded_file() sometimes does not let you move file to a specific folder, may be becuase your account does not have permission to move a temporary file to some folder in your account. I encountered same problem when my client reported me that he has ful permissions to write a file anywhere in any folder, and he has successfully chmod-ed the folders to 777 / 666 (on unix server), but he still cannot get the admin panel script to perform uploading of image. Then I came to know that I must not use move_uplaoded_file, but find some other way to read the file data and write it myself whereever I want. So I came up with following things.

PHP Code:
//First check types and errors and make sure file is right



$file_to_read = $_FILES['myfilevar']['tmp_name']; //access tmp_name that is temporary file

$file_data = implode("",file($file_to_read)); 
Now we have full data of file in variable $file_data and we can use it to write the file anywhere allowed.

For example you wish to write the uplaoded file 'mynewfile.png' to a sub folder called 'myfiles', you write as.
PHP Code:
$f = fopen("./myfiles/mynewfile.png","w");

fwrite($f,$file_data);

fclose($f); 
That's it - you nomore need to use move_uploaded_file. ]]> escapeboy http://www.poudo.com/blog.php?b=41 Super Fast Form Processing Via PHP http://www.poudo.com/blog.php?b=40 Thu, 25 Oct 2007 22:33:30 GMT This system is very easy. All it requires is 2 files, an html, and a php file. 1. Create a html file named *contact_us.html* 2. Insert the following... This system is very easy. All it requires is 2 files, an html, and a php file.

1. Create a html file named contact_us.html
2. Insert the following code

HTML Code:
<title>NeoGT Mail Form</title><body>
<form action="mail.php" method="POST">
Your Name: <input type="text" name="name" size="20" /><br />
Your Email: <input type="text" name="email" size="20"/><br />
Subject: <input type="text" name="subject" size="20"/><br />
Comments:<textarea name="text" name="text" cols="50" rows="10"></textarea><br />
<input type="submit" name="submit" value="Send" />
</form>
</body>
3. Create a php file named mail.php
4. Insert the following code

PHP Code:
<?php
@extract($_POST);
$name = stripslashes($name);
$email = stripslashes($email);
$subject = stripslashes($subject);
$text = stripslashes($text);
mail('email@address.com',$subject,$text,"From: $name <$email>");
echo("Your email was sent, thank you!");
?>
Notes:
@extract will attempt to collect the post data
Field names with the '$' symbol provide variables, hence;[*]$name[*]email[*]$subject[*]$text
Echo command displays any desired text ]]> escapeboy http://www.poudo.com/blog.php?b=40 PHP: PHPBB2 integration with your site http://www.poudo.com/blog.php?b=39 Sun, 21 Oct 2007 12:32:05 GMT In this tutorial I will teach you how to integrate PHPBB2 into your main site. This includes a login form, showing user info, and more. PHPBB2 keeps... In this tutorial I will teach you how to integrate PHPBB2 into your main site. This includes a login form, showing user info, and more.

PHPBB2 keeps sessions using cookies. Making the cookies extend to your main site is a fairly simple task.

There is a small complication with keeping the PHPBB2 sessions active when linking from your integrated main site to your forum. You have to use the append_sid() function on all the links to your forum. It is also recommended to do this with all links that point to the mainsite, but it is not required.

Lets start with a simple file that we will include in all our main site pages. This file will take care of the cookies PHPPBB2 uses and allow us to use PHPBB2 defined functions.

PHP Code:
<?php
define('IN_PHPBB', true);
$phpbb_root_path = 'forums/'; //Relative path to your PHPBB2 installation
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
?>
Make sure that the variable with the path to your forum is correct, otherwise the sessions will not work.

Now lets make an example page witch includes the above file and checks if a user is logged in and if the user is a guest displays a login form.

PHP Code:
<?php
include('include.php'); //include our session handling file, make sure you have the right file name

if( !$userdata['session_logged_in'] ) // Is the user NOT logged in?
   {
      ?>
<form action="forums/login.php" method="post" name="login"> <!-- Show a simple login form -->
<input type="text" name="username"><br />
<input type="password" name="password"><br />
<input type="hidden" name="redirect" value="../index.php"> <!-- Redirect the user to a page different than the PHPBB2 index page. You can delete this if you want. The path must be relative from the PHPBB2 login file. -->
<input type="submit" value="login" name="login">
</form>
      <?php
   }
?>
Make sure that the action attribute of the form tag points to your forums login page.

Now for the append_sid() function, here is an example of how the function can be use on your URLs.

PHP Code:
<?php
$phpbb_links = array ( //start our array
'home' => append_sid("index.$phpEx"), // .$phpEx is the way PHPBB2 writes the .php file extension, change this to just .html if you use .html files or other file extensions.
'forums_home' => append_sid("forums/index.$phpEx"),
'tolist' => append_sid("toplist.$phpEx"), // notice the comma after each line
'downloads' => append_sid("downloads.$phpEx") // there is no comma on the last line
); // end our array
?>
You can simply put this code at the top of your page or even better put it in the sessions file that you include on each page.

Then you simply call the variable when you want the link.
PHP Code:
<a href="<?php echo $phpbb_links['home']; ?>">Site Home</a>
It's as simple as that. The last thing I will show you how to do is to display some information about a user when he or she is logged in.

PHP Code:
<?php
include('include.php'); //include our session handling file
if( $userdata['session_logged_in'] ) // Is the user logged in?
   {
    $appendLogout = $u_login_logout = $phpbb_root_path.'login.'.$phpEx.'?logout=true&amp;sid=' . $userdata['session_id']; // Add the session ID to the logout link
    echo "Welcome back, <a href=\"forums/profile.php?mode=viewprofile&u=".$userdata['user_id']."\" title=\"".$userdata['username']."\">".$userdata['username']."</a>!<br />"; // Show a welcome message
    echo "<a href=\"forums/privmsg.php?folder=inbox\" title=\"You have ".$userdata['user_unread_privmsg']." new messages\">(".$userdata['user_unread_privmsg'].") New Messages</a><br />"; // Any new PMs?
    echo "<a href=\"forums/profile.php?mode=editprofile\" title=\"My Profile\">My Profile</a><br />"; // Edit your profile link
    echo "<a href=\"".$appendLogout."\" title=\"Logout\">Logout</a><br />"; // Logout link
   } // end if, if you want you could add a login form in an else statement below
?>
Make sure you make the links point to your forums, if you want you can change all the links to use the $phpbb_root_path set in the included file as I have done in the logout link. Also notice that i didn't use append_sid() on the logout link, it is required to add the session id manually on a logout link otherwise you will get an error from the logout page.

You can download the entire script in .zip format from:
http://www.marek.litomisky.com/tutor...ntegration.zip
Just make sure you change the forum path to the correct one.

That's about all there is to site integration with PHPBB2! If you have any questions or comments leave them using the form below and if you liked this tutorial, please think about registering at Design Avarice. ]]> escapeboy http://www.poudo.com/blog.php?b=39 Creating a count down system http://www.poudo.com/blog.php?b=38 Sun, 21 Oct 2007 12:26:40 GMT In this tutorial I will show you how to create a simple count down system.

Step 1.
First of all let's collect what we need to make our idea to a working code. We want to calculate how many day, hours, minutes and seconds are until a given date is coming. To do this we need the date and time in the future (let's call it to target date) and the actual date and time informations. In this tutorial we will use a hard coded target date. To make our calculation more easy and to avoid any date/time string format problem just define each date component separate like this:

PHP Code:
<?php
// Define your target date here
    $targetYear   = 2007;
    $targetMonth  = 9;
    $targetDay    = 10;
    $targetHour   = 12;
    $targetMinute = 00;
    $targetSecond = 00;

?>
Step 2.
As next step we have to calculate the difference between the actual date and the target date. To do this we will convert/get both date values to a UNIX timestamp in a long integer format which containing the number of seconds between the Unix Epoch (January 1 1970 00:00:00 GMT) and the time specified. To convert the target date use the built in PHP function mktime()

Synatx:
int mktime ( [int hour [, int minute [, int second [, int month [, int day [, int year [, int is_dst]]]]]]] )

As you can see we can use here the date components defined in Step 1.

PHP Code:
<?php
$targetDate = mktime($targetHour,$targetMinute,$targetSecond,$targetMonth,$targetDay,$targetYear);
?>
To get the actual date we can simply use an oyher built in PHP function time() which function returns the actual date in UNIXtimestamp format as the mktime function.

Syntax:
int time ( void )

PHP Code:
<?php
$actualDate = time();
?>
Step 3.
Now we have both the dates so we can calculate the difference quite easy: target date - actual date. Let's make some calculation how many full days, hours, minutes is it. As the difference is in seconds we will use the following approach. A day is 24 hours, each hours has 60 minutes and each minute has 60 seconds so at the end a full day is 60*60*24 seconds. We want to get only the full days so during our calculation we will use the floor() function which returns the next lowest integer value by rounding down value if necessary. So the complete calculation process looks like this:

PHP Code:
<?php

$secondsDiff = $targetDate - $actualDate;

$remainingDay     = floor($secondsDiff/60/60/24);
$remainingHour    = floor(($secondsDiff-($remainingDay*60*60*24))/60/60);
$remainingMinutes = floor(($secondsDiff-($remainingDay*60*60*24)-($remainingHour*60*60))/60);
$remainingSeconds = floor(($secondsDiff-($remainingDay*60*60*24)-($remainingHour*60*60))-($remainingMinutes*60));

?>
Step 4.
As last step we makes some formatting. In this case I will display the target date, the actual date and the remaining time. To make a nice formatting let's define a fomatting string for the date() function.

Synatx:
string date ( string format [, int timestamp] )

So the code which formats the output is the following:

PHP Code:
<?php
// Define date format
$dateFormat = "Y-m-d H:i:s";

$targetDateDisplay = date($dateFormat,$targetDate);
$actualDateDisplay = date($dateFormat,$actualDate);
?>
And as result here is the complete PHP code:

PHP Code:
<?php
// Define your target date here
    $targetYear   = 2007;
    $targetMonth  = 9;
    $targetDay    = 10;
    $targetHour   = 12;
    $targetMinute = 00;
    $targetSecond = 00;
// End target date definition

$targetDate = mktime($targetHour,$targetMinute,$targetSecond,$targetMonth,$targetDay,$targetYear);
$actualDate = time();

$secondsDiff = $targetDate - $actualDate;

$remainingDay     = floor($secondsDiff/60/60/24);
$remainingHour    = floor(($secondsDiff-($remainingDay*60*60*24))/60/60);
$remainingMinutes = floor(($secondsDiff-($remainingDay*60*60*24)-($remainingHour*60*60))/60);
$remainingSeconds = floor(($secondsDiff-($remainingDay*60*60*24)-($remainingHour*60*60))-($remainingMinutes*60));

// Define date format
$dateFormat = "Y-m-d H:i:s";

$targetDateDisplay = date($dateFormat,$targetDate);
$actualDateDisplay = date($dateFormat,$actualDate);

?>
HTML Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<html>
<body>
 TARGET DATE : <?php echo $targetDateDisplay; ?><br/><br/>
 ACTUAL DATE : <?php echo $actualDateDisplay; ?><br/><br/>
 REMAINING   : <?php echo "$remainingDay days, $remainingHour hours, $remainingMinutes minutes, $remainingSeconds seconds";?>
</body>
]]> escapeboy http://www.poudo.com/blog.php?b=38 Image upload with MYSQL database http://www.poudo.com/blog.php?b=37 Sun, 21 Oct 2007 12:24:44 GMT In this tutorial is presented a simple code with informations about programing a script that uses MYSQL database to upload images. Very simple to... In this tutorial is presented a simple code with informations about programing a script that uses MYSQL database to upload images. Very simple to interpretate, to code and to test, its a simple way to learn how to program a upload script that select images from the MYSQL database using php programing. Image upload with MYSQL databaseThere will be 3 PHP files in this tutorial: readdir.php - this puts all the images in a folder into the database image.php - the actual image script that displays the imag view.php - an example file that shows you how to call the imageCreating the Image DatabaseFirst, create a mysql database called base64imgdb (this is the name that will be used throughout the tutorial)Second, create a table called images with two rows. Name the first one imgid, and give it the parameters TYPE: INT EXTRA: auto_increment, and check the circle under Primary. Name the second sixfourdata, and make it TYPE: LONGTEXT. Here is the sql code:

Code:
CREATE TABLE `images` (
`imgid` INT NOT NULL AUTO_INCREMENT ,
`sixfourdata` LONGTEXT NOT NULL ,
PRIMARY KEY ( `imgid` )
);
The READDIR.PHP script
This script reads a directory within the server, selects all the jpg and gif images, encodes them into base64, and uploads them to the database, except in a different order. This is because the script reads each image in a loop, and we would like to keep a constant connection to the mysql database instead of creating multiple ones. Here is the database connection where: username and password

is the directory the readdir.php file is located:
PHP Code:
$path = "./";
$dir_handle = opendir($path) or die("Unable to open directory $path"); 
PHP Code:
<?
while ($file = readdir($dir_handle)) {
$filetyp = substr($file, -3);
if ($filetyp == 'gif' OR $filetyp == 'jpg') {
$handle = fopen($path . "/" . $file,'r');
$file_content = fread($handle,filesize($path . "/" . $file));
fclose($handle);
$encoded = chunk_split(base64_encode($file_content));
$sql = "INSERT INTO images SET sixfourdata='$encoded'";
mysql_query($sql);
}
}
?>
This is the last and final part of the readdir.php: closing the directory and stating the proccess is complete:

PHP Code:
<?
closedir($dir_handle);
echo("complete");
mysql_close($dbcnx);
?>
The Image Reader IMAGE.PHP
This file may be the hardest file to understand whenever you see how simple view.php is, but bear with me, your patience will pay off. This file takes a request, requests the row in the table, decodes the data, and presents itself as an image. First, we have to connect to the database again:

PHP Code:
$dbcnx = mysql_connect("localhost", "username", "password");
mysql_select_db("base64imgdb"); 

After this, we need to connect to the table, get the data, and set it into variables:


PHP Code:
<?
    $result = mysql_query("SELECT * FROM images WHERE imgid=" . $img .
"");
    if (!$result) {
      echo("<b>Error performing query: " . mysql_error() . "</b>");
      exit();
    }
    while ($row = mysql_fetch_array($result)) {
    $imgid = $row["imgid"];
    $encodeddata = $row["sixfourdata"];
    }
?>
Now here is the last and most confusing part of the file:
[/php]
mysql_close($dbcnx);
echo base64_decode($encodeddata);
?>

The files:
readdir.php:
PHP Code:
<?
###############################
# DB CONNECTION
# CHANGE THESE VALUES
###############################
$dbcnx = mysql_connect("localhost", "username", "password");
mysql_select_db("base64imgdb");
$path = "./";
$dir_handle = opendir($path) or die("Unable to open directory $path");
while ($file = readdir($dir_handle)) {
$filetyp = substr($file, -3);
if ($filetyp == 'gif' OR $filetyp == 'jpg') {
$handle = fopen($file,'r');
$file_content = fread($handle,filesize($file));
fclose($handle);
$encoded = chunk_split(base64_encode($file_content));
$sql = "INSERT INTO images SET sixfourdata='$encoded'";
mysql_query($sql);
}
}
closedir($dir_handle);
echo("complete");
mysql_close($dbcnx);
?>
image.php:
PHP Code:
<?
$dbcnx = mysql_connect("localhost", "username", "password"); 
mysql_select_db("base64imgdb");
$img = $_REQUEST["img"];
$result = mysql_query("SELECT * FROM images WHERE imgid=" . $img . "");
    if (!$result) {
      echo("<b>Error performing query: " . mysql_error() . "</b>");
      exit();
    }
    while ($row = mysql_fetch_array($result) ) {
    $imgid = $row["imgid"];
    $encodeddata = $row["sixfourdata"];<
    }
mysql_close($dbcnx);
echo base64_decode($encodeddata);
?>
<?
$dbcnx = mysql_connect("localhost", "username", "password"); 
mysql_select_db("base64imgdb");
$img = $_REQUEST["img"];
$result = mysql_query("SELECT * FROM images WHERE imgid=" . $img . "");
    if (!$result) {
      echo("<b>Error performing query: " . mysql_error() . "</b>");
      exit();
    }
    while ($row = mysql_fetch_array($result) ) {
    $imgid = $row["imgid"];
    $encodeddata = $row["sixfourdata"];
    }
mysql_close($dbcnx);
echo base64_decode($encodeddata);
?>
]]> escapeboy http://www.poudo.com/blog.php?b=37