Zone 4 PHP Coder

How to Backup Database

2015-02-04T13:57:00.000-08:00

Class to back up entire databases and email them out, or individual tables.

<?php
   class Backup
       {
               /**
                * @var stores the options
                */
               var $config;

               /**
                * @var stores the final sql dump
                */
               var $dump;

               /**
                * @var stores the table structure + inserts for every table
                */
               var $struktur = array();

               /**
                * @var zip file name
                */
               var $datei;

               /**
                * this function is the constructor and phrase the options
                * and connect to the database
                * @return
                */
               public function Backup($options)
               {
                       // write options
                       foreach($options AS $name => $value)
                       {
                               $this->config[$name] = $value;
                       }

                       // check mysql connection
                       mysql_connect($this->config['mysql'][0], $this->config['mysql'][1], $this->config['mysql'][2]) or die(mysql_error());
                       mysql_select_db($this->config['mysql'][3]) or die(mysql_error());
               }

               /**
                * this function start the backup progress its the core function
                * @return
                */
               public function backupDB()
               {
                       // start backup
                       if(isset($_POST['backup']))
                       {
                               // check if tables are selected
                               if(empty($_POST['table']))
                               {
                                       die("Please select a table.");
                               }

                               /** start backup **/
                               $tables = array();
                               $insert = array();
                               $sql_statement = '';

                               // lock tables
                               foreach($_POST['table'] AS $table)
                               {
                                        mysql_query("LOCK TABLE $table WRITE");

                                       // Read table structure
                                       $res = mysql_query('SHOW CREATE TABLE '.$table.'');
                                       $createtable = mysql_result($res, 0, 1);
                                       $str = "\n\n".$createtable."\n\n";

                                       array_push($tables, $str);

                                       // Read table "inserts"
                           $sql = 'SELECT * FROM '.$table;
                           $query = mysql_query($sql) or die(mysql_error());
                           $feld_anzahl = mysql_num_fields($query);

                                       $sql_statement = '--
-- Data Table `$table`
--

                                               ';

                                       // start reading progress
                           while($ds = mysql_fetch_object($query)){
                               $sql_statement .= 'INSERT INTO `'.$table.'` (';

                               for ($i = 0;$i <$feld_anzahl;$i++){
                                   if ($i ==$feld_anzahl-1){
                                       $sql_statement .= mysql_field_name($query,$i);
                                   } else {
                                       $sql_statement .= mysql_field_name($query,$i).', ';
                                   }
                               }

                               $sql_statement .= ') VALUES (';

                               for ($i = 0;$i <$feld_anzahl;$i++){
                                   $name = mysql_field_name($query,$i);
                                   if (empty($ds->$name)){
                                       $ds->$name = 'NULL';
                                   }
                                   if ($i ==$feld_anzahl-1){
                                       $sql_statement .= '"'.$ds->$name.'"';
                                   } else {
                                       $sql_statement .= '"'.$ds->$name.'", ';
                                   }
                               }
                               $sql_statement .= ");\n";
                           }

                                       // insert "Inserts" into an array if not exists
                                       if(!in_array($sql_statement, $insert))
                                       {
                                               array_push($insert, $sql_statement);
                                               unset($sql_statement);
                                       }

                                       unset($sql_statement);

                               }

                               // put table structure and inserts together in one var
                               $this->struktur = array_combine($tables, $insert);

                               // create full dump
                               $this->createDUMP($this->struktur);

                               // create zip file
                               $this->createZIP();

                               /** end backup **/

                               // send an email with the sql dump
                               if(isset($this->config['email']) && !empty($this->config['email']))
                               {
                                       $this->sendEmail();
                               }

                               // output
                               echo '<h3 style="color:green;">Backup war erfolgreich</h3><a href="'.$this->datei.'">Download Backup</a>
                               <br />
                               <br />';
                       }
               }

               /**
                * this function generate an email with attachment
                * @return
                */
               protected function sendEmail()
               {
                               // start sending emails
                               foreach($this->config['email'] AS $email)
                               {
                                       $to = $email;

                                       $from = $this->config['email'][0];

                                       $message_body = "This email contains the database backup as a zip file.";

                                       $msep = strtoupper (md5 (uniqid (time ())));

                                       // set email header (only text)
                                       $header =
                                                 "From: $from\r\n" .
                                                 "MIME-Version: 1.0\r\n" .
                                                 "Content-Type: multipart/mixed; boundary="$msep"\r\n\r\n" .
                                                 "--$msep\r\n" .
                                                 "Content-Type: text/plain\r\n" .
                                                 "Content-Transfer-Encoding: 8bit\r\n\r\n" .
                                                 $message_body . "\r\n";

                                       // file name
                                       $dateiname = $this->datei;

                                       // get filesize of zip file
                                       $dateigroesse = filesize ($dateiname);

                                       // open file to read
                                       $f = fopen ($dateiname, "r");
                                       // save content
                                       $attached_file = fread ($f, $dateigroesse);
                                       // close file
                                       fclose ($f);

                                       // create attachment
                                       $attachment = chunk_split (base64_encode ($attached_file));

                                       // set attachment header
                                       $header .=
                                                  "--" . $msep . "\r\n" .
                                                  "Content-Type: application/zip; name='Backup'\r\n" .
                                                  "Content-Transfer-Encoding: base64\r\n" .
                                                  "Content-Disposition: attachment; filename='Backup.zip'\r\n" .
                                                  "Content-Description: Mysql Datenbank Backup im Anhang\r\n\r\n" .
                                                  $attachment . "\r\n";

                                       // mark end of attachment
                                       $header .= "--$msep--";

                                       // eMail Subject
                                       $subject = "Database Backup";

                                       // send email to emails^^
                                       if(mail($to, $subject, '', $header) == FALSE)
                                       {
                                               die("The email could not be sent. Please check the email address.");
                                       }

                                       echo "<p><small>Email was successfully sent.</small></p>";
                               }
               }

               /**
                * this function create the zip file with the database dump and save it on the ftp server
                * @return
                */
               protected function createZIP()
               {

                       // Set permissions to 777
                       chmod($this->config['folder'], 0777);

                       // create zip file
                       $zip = new ZipArchive();
                       // Create file name
                       $this->datei = $this->config['folder'].$this->config['mysql'][3]."_".date("j_F_Y_g:i_a").".zip";

                       // Checking if file could be created
                       if ($zip->open($this->datei, ZIPARCHIVE::CREATE)!==TRUE) {
                               exit("cannot open <".$this->datei.">\n");
                       }

                       // add mysql dump to zip file
                       $zip->addFromString("dump.sql", $this->dump);
                       // close file
                       $zip->close();

                       // Check whether file has been created
                       if(!file_exists($this->datei))
                       {
                               die("The ZIP file could not be created.");
                       }

                       echo "<p><small>The zip was created.</small></p>";
               }

               /**
                * this function create the full sql dump
                * @param object $dump
                * @return
                */
               protected function createDUMP($dump)
               {
                       $date = date("F j, Y, g:i a");

                       $header = <<<HEADER
-- SQL Dump
--
-- Host: {$_SERVER['HTTP_HOST']}
-- Erstellungszeit: {$date}

--
-- Datenbank: `{$this->config['mysql'][3]}`
--

-- --------------------------------------------------------

HEADER;
                       foreach($dump AS $name => $value)
                       {
                               $sql .= $name.$value;
                       }
                       $this->dump = $header.$sql;
               }

               /**
                * this function displays the output form to select tables
                * @return
                */
               public function outputForm()
               {
                       // select all tables from database
                       $result = mysql_list_tables($this->config['mysql'][3]);

                       $buffer = '
                       <fieldset>
                               <legend>Select some tables</legend>
                               <form method="post" action="">
                       <select name="table[]" multiple="multiple" size="30">';
                       while($row = mysql_fetch_row($result))
                       {
                               $buffer .= '<option value="'.$row[0].'">'.$row[0].'</option>';
                       }
                       $buffer .= '</select>
                       <br /><br />
                       <input type="submit" name="backup" value="Backup Tables" />
                       </form>
                       </fieldset>';

                       echo $buffer;
               }
       }
?>

Usage:

<?php

       //You can add as many email addresses as you like
       $options = array('email' => array('email1', 'email2'),
                                  'folder' => './backup/',
                                  'mysql' => array('localhost', 'root', '****', 'database'));

       $b = new Backup($options);

       // if submit form start backup
       if(isset($_POST['backup']))
       {
               // start backup
               $b->backupDB();
       }

       // display tables
       $b->outputForm();

?>

Detection iPad Visitor Using .htaccess

2014-12-02T14:53:00.000-08:00

Of course, the iPad is a pretty large screen and a fully capable browser, so most websites don't need to have iPad specific versions of them. But if you need to, you can detect for it with .htaccess

RewriteCond %{HTTP_USER_AGENT} ^.*iPad.*$
RewriteRule ^(.*)$ http://ipad.yourdomain.com [R=301]

This will redirect iPad users to a URL you specify. This is probably the best way to do it (assuming you are running an Apache server), but if you aren't, there are PHP and JavaScript methods here.

Automatic Display Copyright Year

2014-11-27T12:27:00.000-08:00

The following is a trick to display the copyright year ini php

Current year only

&copy; <?php echo date("Y") ?>

With start year

&copy; 2008-<?php echo date("Y") ?>

Start date with error protection

<?php function auto_copyright($year = 'auto'){ ?>
   <?php if(intval($year) == 'auto'){ $year = date('Y'); } ?>
   <?php if(intval($year) == date('Y')){ echo intval($year); } ?>
   <?php if(intval($year) < date('Y')){ echo intval($year) . ' - ' . date('Y'); } ?>
   <?php if(intval($year) > date('Y')){ echo date('Y'); } ?>
<?php } ?>

Usage:

<?php auto_copyright(); // 2014?>

<?php auto_copyright('2005');  // output 2005 - 2014 ?>

JavaScript call and apply

2014-01-06T14:39:00.000-08:00

JavaScript call and apply are functions that are used to call function within the context of another function. There is a fundamental difference between the two, call() takes parameters as a name while as apply() accepts parameters as an array.

I will show how to use call and apply to change the background of a page in JavaScript. Usually you won’t do such a basic thing as changing background via call or apply methods, but I wont to touch the basics of apply and call and show how to use them in function context. Otherwise you would never want to change the page background or for that matter any style property with JavaScript call and apply methods.

JavaScript call() function with Example.

function changeBackgroundColor(color)
{
            this.style.backgroundColor = color;
            this.innerHTML = "<h1>Body Background Changed Via JavaScript Call Function</h1>";
}
var bodyBackground = document.getElementsByTagName("body")[0];
changeBackgroundColor.call(bodyBackground,"#990000");

Quite simple, we use a function changeBackgroundColor(), pass it a parameter color. In this function we set the bodybackground with the follow statement
this.style.backgroundColor = color;
we also set the innerHTML of body to be a h1 tag with some descriptive text.

Now to call changeBackgroundColor function we use call like changeBackgroundColor.call(bodyBackground,”#990000″);

As I said call takes parameters as name, the bodyBackground is the node that we want the background to be changed. In our case body tag, the we pass the color that page background should take.

See the Demo of the above example in jsFiddle:

How to get the text value of a clicked link

2014-01-04T14:32:00.001-08:00

In your case I wouldn't use the text of the link, as it's possible it may change in the future (ie. you need to translate your website). The better solution is to add custom attribute to links:

<div id="my-div">
  <div><a href="#" sectionId="someId1">tag 1</a></div>
  <div><a href="#" sectionId="someId2">tag 2</a></div>
</div>

And then put the id of the hidden tag there, so you and up with:

$('#my-div a').click(function() {
  var sectionId = $(this).attr('sectionId');
  $('#' + sectionId).show();
  return false; // return false so the browser will not scroll your page
});

:)

Java Script Right Click Disable

2013-08-28T15:02:00.000-07:00

Wanna script or snippets to disable right click on your website? check it out..

Java Script Right Click Disable

<script language="javascript"

type="text/javascript"

src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js">

</script>

<script type="text/javascript" language="javascript">

$(function() {

$(this).bind("contextmenu", function(e) {

e.preventDefault();

});

</script>

PHP / MySQL select data and split on pages

2013-08-26T14:54:00.001-07:00

This tutorial is going to show you how to SELECT data from a MySQL database, split it on multiple pages and display it using page numbers.

We have MySQL table called “students” holding 90 records with the following fields:
Name – varchar(250)
PhoneNumber – varchar(250)
Instead of doing a single SELECT query and display all the 90 records on a single page we can have 5 pages each containing maximum 20 records. To do this we will need to use the LIMIT clause for SELECT command so we can limit the query to show only 20 records. The LIMIT clause also allows you to specify which record to start from. For example this query

$sql = "SELECT * FROM students ORDER BY name ASC LIMIT 0, 20";

returns 20 records sorted by name starting from the first record. This next query

$sql = "SELECT * FROM students ORDER BY name ASC LIMIT 50, 20";

shows 20 records sorted again by name but this time it will start from the 50th record.
So basically in this clause (LIMIT start, count) ‘start’ specify the starting record and ‘count’ specifies how many records to show.

Next thing to do is to make a PHP file called pagination.php which will show the first 20 records from our table. The code below selects and then prints the data in a table.

<?php 

if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 

$start_from = ($page-1) * 20; 

$sql = "SELECT * FROM students ORDER BY name ASC LIMIT $start_from, 20"; 

$rs_result = mysql_query ($sql, $connection); 

?> 

<table>

<tr><td>Name</td><td>Phone</td></tr>

<?php 

while ($row = mysql_fetch_assoc($rs_result)) { 

?> 

            <tr>

            <td><? echo $row["Name"]; ?></td>

            <td><? echo $row["PhoneNumber"]; ?></td>

            </tr>

<?php 

}; 

?> 

</table>

Now, when you open pagination.php in your web browser you will see table showing the first 20 records from your ‘students’ table.

The first 2 lines of the above code

if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 

$start_from = ($page-1) * 20;

are used to create a $start_from variable depending on the page that we want to view. Later you will see that we will pass a “page” value using the URL (e.g. pagination.php?page=2) to go to different pages. Next we need to find out the total amount of records in our table and the number of pages that we will need. To do this we run another query using COUNT() function.

$sql = "SELECT COUNT(Name) FROM students"; 

$rs_result = mysql_query($sql,$connection); 

$row = mysql_fetch_row($rs_result); 

$total_records = $row[0];

The $total_records is now equal to the number of records that we have in our database, in our case 90. We have 20 records per page so the total number of pages that will be needed is 5 (4 pages with 20 records and last page will have 10 records).

Calculating the amount of pages needed using PHP can be done using ceil() function.

$total_pages = ceil($total_records / 20);

We divide the total number of records by records per page and then the ceil() function will round up the result. Now we have 2 new variables - $total_records equal to 90 and $total_pages equal to 5.
To print page numbers and associate URLs to each number we will use for() cycle.

<?php 

for ($i=1; $i<=$total_pages; $i++) { 

 echo "<a href='pagination.php?page=".$i."'>".$i."</a> "; 

}; 

?>

Above code will print numbers from 1 to 5 and for each number will create different link.
pagination.php?page=1
pagination.php?page=2
pagination.php?page=3
pagination.php?page=4
pagination.php?page=5
as you can see each link passes different page value which is used in the SELECT query above.

At the end you should have a file like this (remember to add the MySQL connection string):

<?php 

if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 

$start_from = ($page-1) * 20; 

$sql = "SELECT * FROM students ORDER BY name ASC LIMIT $start_from, 20"; 

$rs_result = mysql_query ($sql,$connection); 

?> 

<table>

<tr><td>Name</td><td>Phone</td></tr>

<?php 

while ($row = mysql_fetch_assoc($rs_result)) { 

?> 

            <tr>

            <td><? echo $row["Name"]; ?></td>

            <td><? echo $row["PhoneNumber"]; ?></td>

            </tr>

<?php 

}; 

?> 

</table>

<?php 

$sql = "SELECT COUNT(Name) FROM students"; 

$rs_result = mysql_query($sql,$connection); 

$row = mysql_fetch_row($rs_result); 

$total_records = $row[0]; 

$total_pages = ceil($total_records / 20); 

 

for ($i=1; $i<=$total_pages; $i++) { 

            echo "<a href='pagination.php?page=".$i."'>".$i."</a> "; 

}; 

?>

This pagination.php file will print a table with maximum 20 records per page and at the bottom 5 page numbers each pointing to a page showing different 20 records.

Do not forget that for a small fee I can add pagination to all your PHP files. Let me know if you need help with this and I will give you a quote.

PHP & Javascript

2013-06-28T12:13:00.000-07:00

All the PHP code will execute on the server before the page is sent to the client, meaning all of the PHP calls have all been replaced by whatever text they returned once the JavaScript is able to execute.

<script>
document.write("<?php echo 'hello!'; ?>");
</script>

<?php 
echo "<script language=\"JavaScript\">"; 
echo "alert(\"Hello World\");"; 
echo "</script>"; 
?>

<?php $phpvar=1; ?>
<script type="text/javascript">
jsvar = 3;
//Assign jsvar javascript variable value to php variable $phpvar
'<?php $phpvar="<script>document.write(jsvar)</script>"; ?>';
</script>
<?php echo $phpvar; ?>

‘Loop’ Example

<script type="text/javascript">
var counter = 0;
for(i=0;i<10;i++){
counter++;
}
</script>

<?php 
$phpvar= "<script>document.write(counter)</script>"; 
echo $phpvar;
?>

‘Session’ Example

<?php session_start(); $_SESSION['nume']='Sanat';?>
<!-- HTML code -->
<script type="text/javascript">
alert("Welcome <?php echo $_SESSION['nume']; ?>");
</script>

‘Switch’ Example

<script type="text/javascript"> 
function test(){ 
 document.getElementById("php_code").innerHTML="<?php  
  $w="do"; 
  switch($w){ 
  case 'do': echo "You will be logged in?"; break; 
  case 'loguot': echo "You will be logged out?" ; break;
  } 
 ?>"; 
} 
</script> 

<a href="" onclick="test(); return false;"> test </a> <br>
<span id="php_code"> </span>

Pass the value within url.

<?php 
    if(isset($_GET[action])){
 // Retrieve the GET parameters and executes the function
   $funcName  = $_GET[action];
   $vars   = $_GET[vars];
   $funcName($vars); 
  } else if (isset($_POST[action])){
   // Retrieve the POST parameters and executes the function
   $funcName  = $_POST[action];
  $vars   = $_POST[vars];
  $funcName($vars);    
  } else {   
  echo "<INPUT NAME='click_me' TYPE='button' ONCLICK='javascript:javaFunction()' VALUE='Click Me'>";
  }
  
   function phpFunction($v1){
 // makes an array from the passed variable  
 // with explode you can make an array from string. 
 $varArray = explode(",", $v1); 
  
 echo "First Value: $varArray[0] <BR>";
 echo "Second Value: $varArray[1]<BR>"; 
   }
  ?> 
 
  <SCRIPT language="javascript">
   function javaFunction(){
 // In the varArray are all the variables you want to give with the function
 var varArray = new Array();
 varArray[0] = "Hello";
 varArray[1] = "World";
   
 // the url which you have to pass an action to the GET- or POST-variable
 var url="<?php echo $_SERVER[PHP_SELF];?>?action=phpFunction&vars="+varArray;
 
 // Opens the url in the same window
    window.open(url, "_self");
   }
  </SCRIPT>

Output :
First Value: Hello
Second Value: World

htaccess to redirect root domain to a subfolder

2013-06-26T14:09:00.003-07:00

If you want to redirect your domain yourdomain.com to yourdomain.com/blog then you need to add below code into a .htaccess file in your public_html folder.

Add the following lines to that file:
RewriteEngine On
RewriteCond %{HTTP_HOST} ^(www.)?YourDomain.com$
RewriteRule ^(/)?$ blog [L]

Htaccess code to redirect from http to www

2013-06-26T14:06:00.002-07:00

Add following code on your htaccess file to redirect http://yourdomain.com to http://www.yourdomain.com. Just change your domain name there, no other changes are required.

RewriteEngine On
RewriteCond %{HTTP_HOST} ^yourdomain.com
RewriteRule (.*) http://www.yourdomain.com/$1 [R=301,L]

Ajax Login form with jQuery and PHP

2012-11-29T15:55:00.000-08:00

In this tutorial, I will explain you how to create a ajax popup log in form with jquery and php.

Firstly let's create a folder in your www (for wamp) folder and name as ajax_login.

Crate a blank document in your favourite editor and paste following code in your document. And then save as index.php in your ajax_login folder. I have divided index.php into 2 parts. Below is our body part.

<body>
 <?php session_start(); ?>
 <div id="profile">
  <?php if(isset($_SESSION['user_name'])){
  ?>
   <a href='logout.php' id='logout'>Logout</a>
  <?php }else {?>
   <a id="login_a" href="#">login</a>
  <?php } ?>
 </div>
 <div id="login_form">
 <div class="err" id="add_err"></div>
 <form action="login.php">
  <label>User Name:</label>
  <input type="text" id="user_name" name="user_name" />
  <label>Password:</label>
  <input type="password" id="password" name="password" />
  <label></label><br/>
  <input type="submit" id="login" value="Login" />
  <input type="button" id="cancel_hide" value="Cancel" />
 </form>
 </div>
 <div id="shadow" class="popup"></div>
</body>

In this part, we use the php session variable to check whether the user have already logged in or not. To use session, you need to add session_start() function firstly. If the user has already logged in, we will show the logout. Else we will show login.

And then I create our login_form. We don't want to show this form before the user click the login link. So we need to add the css display:none to our css file for our login_form div.

Following code is our css file. So crate a blank document in your favourite editor and paste the following code. And then save as styles.css in our project folder.

.popup
{
   position: fixed;
   width: 100%;
   opacity: 0.9;
   top:0px;
   min-height:200px;
   height:100%;
   z-index: 100;
   background: #FFFFFF;
   font-size: 20px;
   text-align: center;
   display:none;
}
#login_form
{
 position:absolute;
 width:200px;
 top:100px;
 left:45%;
 background-color:#DDD;
 padding:10px;
 border:1px solid #AAA;
 display:none;
 z-index:101;
 -moz-border-radius: 10px;
 -moz-box-shadow: 0 0 10px #aaa;
 -webkit-border-radius: 10px;
 -webkit-box-shadow: 0 0 10px #aaa;
}

In the index.php head part, first attach the jQuery Library file. And you also need to attach our styles.css. Then write AJAX code into <head> section as following procedure:

<script type="text/javascript">
$(document).ready(function(){
 $("#login_a").click(function(){
  $("#shadow").fadeIn("normal");
  $("#login_form").fadeIn("normal");
  $("#user_name").focus();
 });
 $("#cancel_hide").click(function(){
  $("#login_form").fadeOut("normal");
  $("#shadow").fadeOut();
 });
 $("#login").click(function(){

  username=$("#user_name").val();
  password=$("#password").val();
  $.ajax({
   type: "POST",
   url: "login.php",
   data: "name="+username+"&pwd="+password,
   success: function(html){
    if(html=='true')
    {
     $("#login_form").fadeOut("normal");
     $("#shadow").fadeOut();
     $("#profile").html("<a href='logout.php' id='logout'>Logout</a>");

    }
    else
    {
     $("#add_err").html("Wrong username or password");
    }
   },
   beforeSend:function()
   {
    $("#add_err").html("Loading...")
   }
  });
  return false;
 });
});
</script>

Now let's create a login.php script.

<?php
 session_start();
 $username = $_POST['name'];
 $password = md5($_POST['pwd']);
 $mysqli=mysqli_connect('localhost','username','password','database');
 $query = "SELECT * FROM user WHERE username='$username' AND password='$password'";
 $result = mysqli_query($mysqli,$query)or die(mysqli_error());
 $num_row = mysqli_num_rows($result);
 $row=mysqli_fetch_array($result);
 if( $num_row >=1 ) {
  echo 'true';
  $_SESSION['user_name']=$row['username'];
 }
 else{
 echo 'false';
 }
?>

They are fairly straightforward to understand if you know about php and mysql. But you need to change username, password, database and table name for mysql. If you have a problem, don't hesitate to ask me.
The last thing we need to create is logout.php.

<?php
 session_start();
 unset($_SESSION['user_name']);
 header('Location: index.php');
?>

I think this tutorial will help you.

Download Source Code

Auto complete text box with PHP, jQuery and MySql

2012-11-27T15:53:00.001-08:00

In this tutorial I want to show you how easy to do a auto complete text box with PHP, jQuery and MySql.

Firstly download the autocomplete jQuery plugin and extract it to your hard drive.
And then create a folder in your localhost. Copy jquery.autocomplete.css and jquery.autocomplete.js file to your project folder. And you will also need jquery.js. Now we can start our project.

Creating database table

We need to create a table in our database before writing our script. I also add some data for this table. Import following SQL statement via phpMyAdmin or any other MySQL tool.

CREATE TABLE `tag` (
  `id` int(20) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

INSERT INTO `tag` (`id`, `name`) VALUES
(1, 'php'),
(2, 'php frameword'),
(3, 'php tutorial'),
(4, 'jquery'),
(5, 'ajax'),
(6, 'mysql'),
(7, 'wordpress'),
(8, 'wordpress theme'),
(9, 'xml');

index.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Auto Complete Input box</title>
<link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="jquery.autocomplete.js"></script>
<script>
 $(document).ready(function(){
  $("#tag").autocomplete("autocomplete.php", {
        selectFirst: true
  });
 });
</script>
</head>
<body>
<label>Tag:</label>
<input name="tag" type="text" id="tag" size="20"/>
</body>
</html>

autocomplete.php

This file is called from our jquery script. This php script is easy to follow.

<?php
 $q=$_GET['q'];
 $my_data=mysql_real_escape_string($q);
 $mysqli=mysqli_connect('localhost','username','password','databasename') or die("Database Error");
 $sql="SELECT name FROM tag WHERE name LIKE '%$my_data%' ORDER BY name";
 $result = mysqli_query($mysqli,$sql) or die(mysqli_error());

 if($result)
 {
  while($row=mysqli_fetch_array($result))
  {
   echo $row['name']."\n";
  }
 }
?>

We have done. Run your project and type in your text box you will see following screenshot.

By the way, I use the old jquery plug in this project. If you want to learn new thing, you can learn here and here. I create this tutorial because it is still useful and easy, although it is too old. I will also write about new jquery ui later.
Download Source Code

Read txt File

2011-07-27T15:09:00.001-07:00

This snippet opens a file, reads content from it and closes it.

<?php 

$myFile = "text.txt"; $fh = fopen($myFile, 'r'); $theData = fread($fh, 5); fclose($fh); 

echo $theData; ?>

Sending Mail Using Swift Mailer

2011-07-27T15:07:00.000-07:00

Swift Mailer is an alternative to PHPMailer and is a fully OOP library for sending e-mails from PHP websites and applications.

// include classes
require_once "lib/Swift.php";
require_once "lib/Swift/Connection/SMTP.php";

$swift =& new Swift(new Swift_Connection_SMTP("smtp.site.com", 25));
$message =& new Swift_Message("My Subject", "Hello How are you ?", "text/html");
if ($swift->send($message, "asvin [@] gmail.com", "noreply@htmlblog.net")){
echo "Message sent";
}
else{
echo 'There has been a mail error !';
}

//It's polite to do this when you're finished
$swift->disconnect();

Sending Mail Using PHPMailer

2011-07-27T15:06:00.000-07:00

PHPMailer a powerful email transport class with a big features and small footprint that is simple to use and integrate into your own software.

include("class.phpmailer.php");
$mail = new PHPMailer();
$mail->From = 'noreply@htmlblog.net';
$mail->FromName = 'HTML Blog';
$mail->Host = 'smtp.site.com';
$mail->Mailer = 'smtp';
$mail->Subject = 'My Subject';
$mail->IsHTML(true);
$body = 'Hello<br/>How are you ?';
$textBody = 'Hello, how are you ?';
$mail->Body = $body;
$mail->AltBody = $textBody;
$mail->AddAddress('asvin [@] gmail.com');
if(!$mail->Send())
 echo 'There has been a mail error !';

List files in directory

2011-07-27T15:05:00.000-07:00

List all files in a directory and return an array.

function dirList ($directory) {
    // create an array to hold directory list
    $results = array();

    // create a handler for the directory
    $handler = opendir($directory);

    // keep going until all files in directory have been read
    while ($file = readdir($handler)) {

        // if $file isn't this directory or its parent,
        // add it to the results array
        if ($file != '.' && $file != '..')
            $results[] = $file;
    }

    // tidy up: close the handler
    closedir($handler);

    // done!
    return $results;
}

Uploading of files

2011-07-27T15:04:00.000-07:00

Using class.upload.php from Colin Verot

$uploadedImage = new Upload($_FILES['uploadImage']);

if ($uploadedImage->uploaded) {
 $uploadedImage->Process('myuploads');
 if ($uploadedImage->processed) {
  echo 'file has been uploaded';
 }
}

Get IP address

2011-07-27T15:01:00.000-07:00

Returns the real IP address of a visitor, even when connecting via a proxy.function getRealIpAddr(){

02.if (!empty($_SERVER['HTTP_CLIENT_IP'])){

03.//check ip from share internet

04.$ip = $_SERVER['HTTP_CLIENT_IP'];

05.}

06.elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])){

07.//to check ip is pass from proxy

08.$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];

09.}

10.else{

11.$ip = $_SERVER['REMOTE_ADDR'];

12.}

13.return $ip;

14.}

Count the Words

2011-07-27T15:00:00.000-07:00

Count the words typed using exlpode function

 <style type="text/css"> 

body{ 

display: inline; 

font-family: courier; 

font-size: 160%; 

font-style: normal; 

font-weight:1024; 

color: #68677C 

} 

</style> 



<center> 



<table width=80 border=2><center> 

    <tr> 

        <td><center> 

        Count Words<br> 

        Enter the word / phrase in the form below 

         

<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> 



<input type="text" size="75" name="text"> 



<input type="submit" size="12" value=" hasil" name="submit"> 



<p> 

<table bgcolor="#000000"> 

  <tr> 

    <td> 

<? 

$text = $_POST['text']; $count = count(explode(" ", $text)); 

 if ($text == "" ) { 

echo ""; 

} 

else 



 echo"<strong><font color=red>$text</strong></font>   </td> 

  </tr>  

</table></br> words typed is $count "; ?>   

</p> 

</td> 

    </tr> 

    </form>

Check Domain Name Validator

2011-07-14T01:30:00.000-07:00

Snippet Name: Ultimate domain name validator
Description: This will validate nearly any domain name correctly.

<?
function checkDomain(nname)
{
var arr = new Array(
'.com','.net','.org','.biz','.coop','.info','.museum','.name',
'.pro','.edu','.gov','.int','.mil','.ac','.ad','.ae','.af','.ag',
'.ai','.al','.am','.an','.ao','.aq','.ar','.as','.at','.au','.aw',
'.az','.ba','.bb','.bd','.be','.bf','.bg','.bh','.bi','.bj','.bm',
'.bn','.bo','.br','.bs','.bt','.bv','.bw','.by','.bz','.ca','.cc',
'.cd','.cf','.cg','.ch','.ci','.ck','.cl','.cm','.cn','.co','.cr',
'.cu','.cv','.cx','.cy','.cz','.de','.dj','.dk','.dm','.do','.dz',
'.ec','.ee','.eg','.eh','.er','.es','.et','.fi','.fj','.fk','.fm',
'.fo','.fr','.ga','.gd','.ge','.gf','.gg','.gh','.gi','.gl','.gm',
'.gn','.gp','.gq','.gr','.gs','.gt','.gu','.gv','.gy','.hk','.hm',
'.hn','.hr','.ht','.hu','.id','.ie','.il','.im','.in','.io','.iq',
'.ir','.is','.it','.je','.jm','.jo','.jp','.ke','.kg','.kh','.ki',
'.km','.kn','.kp','.kr','.kw','.ky','.kz','.la','.lb','.lc','.li',
'.lk','.lr','.ls','.lt','.lu','.lv','.ly','.ma','.mc','.md','.mg',
'.mh','.mk','.ml','.mm','.mn','.mo','.mp','.mq','.mr','.ms','.mt',
'.mu','.mv','.mw','.mx','.my','.mz','.na','.nc','.ne','.nf','.ng',
'.ni','.nl','.no','.np','.nr','.nu','.nz','.om','.pa','.pe','.pf',
'.pg','.ph','.pk','.pl','.pm','.pn','.pr','.ps','.pt','.pw','.py',
'.qa','.re','.ro','.rw','.ru','.sa','.sb','.sc','.sd','.se','.sg',
'.sh','.si','.sj','.sk','.sl','.sm','.sn','.so','.sr','.st','.sv',
'.sy','.sz','.tc','.td','.tf','.tg','.th','.tj','.tk','.tm','.tn',
'.to','.tp','.tr','.tt','.tv','.tw','.tz','.ua','.ug','.uk','.um',
'.us','.uy','.uz','.va','.vc','.ve','.vg','.vi','.vn','.vu','.ws',
'.wf','.ye','.yt','.yu','.za','.zm','.zw');
 
var mai = nname;
var val = true;
 
var dot = mai.lastIndexOf(".");
var dname = mai.substring(0,dot);
var ext = mai.substring(dot,mai.length);
//alert(ext);
 
if(dot>2 && dot<57)
{
     for(var i=0; i<arr.length; i++)
     {
       if(ext == arr[i])
       {
           val = true;
          break;
       }     
       else
       {
           val = false;
       }
     }
     if(val == false)
     {
             alert("The domain extension "+ext+" is incorrect or unknown.");
           return false;
     }
     else
     {
          for(var j=0; j<dname.length; j++)
          {
            var dh = dname.charAt(j);
            var hh = dh.charCodeAt(0);
            if((hh > 47 && hh<59) || (hh > 64 && hh<91) || (hh > 96 && hh<123) || hh==45 || hh==46)
            {
                if((j==0 || j==dname.length-1) && hh == 45)     
                  {
                        alert("The domain name cannot begin or end with '-'");
                     return false;
                 }
            }
          else     {
                  alert("Your domain name cannot contain any special characters.");
                return false;
            }
          }
     }
}
else
{
 alert("The domain name entered is either too short or too long");
 return false;
}     
 
return true;
}

?>

How to Break Apart an Email Address

2011-07-14T01:25:00.000-07:00

Snippet Name: Easy way to break apart an email address
Description: Probably the easiest way to break apart an email address is to use split() command to break into two parts. Every valid email address will have one '@' between the user name and the host or domain name.

<?

// the easy way to break an email address into the 
// user name and domain name
 
$email = "somename@domain.com";
 
$email_parts = split("@",$email);
 
echo $email_parts[0];
echo '<br />';
echo $email_parts[1];
 
// This will output "somename" and "domain.com"

?>

Automatically process email

2011-07-14T01:22:00.000-07:00

Snippet Name: Automatically process email
Description: Automatically process incoming email with attachment(s) using PHP and PEAR Mail class.

<?php
 
/*
Prerequisites:
Linux/BSD
PHP with CLI enabled
PEAR
Sendmail with individual user account
 
Aim: Save attachments to server storage.
 
1. Setup sendmail account to forward to PHP script.
 
In the home directory (/home/user) on the foo.bar machine make 
and edit a file called ".forward". In this file put in the 
following.
 
|"/dir_to_php_script/process.php"
 
This will forward any email sent to user@foo.bar.com to the 
php script.
 
2. PHP script to process email "/dir_to_php_script/process.php"
[Don't forget to chmod 755 process.php]
 
*/
 
// begin contents of process.php
#!/usr/local/bin/php
<?php
// Need PEAR installed
include('Mail.php');
include('Mail/mime.php');
require_once 'Mail/mimeDecode.php';
 
// read email using stdin
$fd = fopen("php://stdin", "r");
$email = "";
while (!feof($fd)) {
        $email .= fread($fd, 1024);
}
fclose($fd);
 
$params['include_bodies'] = true;
$params['decode_bodies']  = true;
$params['decode_headers'] = true;
 
$message=new Mail_mimeDecode($email);
$mailObj=$message->decode($params);
 
// Who is it from
$from=$mailObj->headers['from'];
// Get Subject
$subj=$mailObj->headers['subject'];
// Get Message Body
$body=$mailObj->parts[0]->body;
$gather="From:$from\nSubject:$subj\nBody:$body";
 
 
// Get and Save the Attachments
foreach($mailObj->parts as $key=>$val):
        $tmpObj=$mailObj->parts[$key];
        $tmp=$tmpObj->d_parameters['filename'];
        if(!empty($tmp)):
                $fd = fopen($tmp, 'w');
                fwrite($fd, $tmpObj->body);
        endif;
 
} //endforeach;
 
// end of contents of process.php
?>

How To Encode IP Address in MySql Database With PHP

2011-07-11T04:47:00.000-07:00

if you want to insert user information like the user's ip address, but don't want to put the dots in the ip address, there is a better way. like many forums websited, for example, phpbb, they encode the ip address of the poster, so they use this fucnctions to encode and decode, its an effecient way to manage information in your database.
here and example:

function encode_ip($dotquad_ip){
$ip_sep = explode('.', $dotquad_ip);
return sprintf('%02x%02x%02x%02x', $ip_sep[0], $ip_sep[1], $ip_sep[2], $ip_sep[3]);
}
function decode_ip($int_ip){
$hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
return hexdec($hexipbang[0]). '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
}

Currency Format in PHP

2011-07-11T04:39:00.000-07:00

here's an example you can use if you want to display the value of $price in currency format:

for example:

<?php
$price = 1.51;
$tax = .19
$total = $price + $tax; // $1.70

echo $total;
?>

the OUTPUT will look like this: 1.7

but if you want it to show in currency value its better like this:

1.60 like in cents and dollars, well its simple, just add the number_format() function. we change our code to this:

<?php
$price = 1.51;
$tax = .19
$total = $price + $tax; // $1.70

echo number_format($total, 2, '.', ',');
?>

the OUTPUT will look like this: 1.70

hope that helps explain what i was trying to do on my previous post

Country from IP

2011-07-03T14:14:00.000-07:00

I was working on a advert site for a buddy, and needed to get the traffic's country code. This retrieves data (JSON format) and decodes it to get the user's country. If json_decode works on your server, you can remove json_decoder function, and change $json_Co=json_decoder($getCo); to $json_Co=json_decode($getCo);

 <? // Let me start off by saying I do not take full credit for this! 

// I needed a way to get my traffic's country for Adverts... 

// for some reason, json_decode wasn't working, so this is an alternative. 



// json_decoder function from PHP.net 

// file_get_contents_curl basic data retrieval function 



// how to use: 

// include('country.php'); 

// $userCountry=getTheCountry(); 

// output is 2 character country code, US, CA, etc... 

function file_get_contents_curl($url) { 

    $ch = curl_init(); 

    curl_setopt($ch, CURLOPT_HEADER, 0); 

    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 

    curl_setopt($ch, CURLOPT_URL, $url); 

    $data = curl_exec($ch); 

    curl_close($ch); 



    return $data; 

} 



function json_decoder($json) 

{ 

    $comment = false; 

    $out = '$x='; 

  

    for ($i=0; $i<strlen($json); $i++) 

    { 

        if (!$comment) 

        { 

            if (($json[$i] == '{') || ($json[$i] == '['))       $out .= ' array('; 

            else if (($json[$i] == '}') || ($json[$i] == ']'))   $out .= ')'; 

            else if ($json[$i] == ':')    $out .= '=>'; 

            else                         $out .= $json[$i];          

        } 

        else $out .= $json[$i]; 

        if ($json[$i] == '"' && $json[($i-1)]!="\\")    $comment = !$comment; 

    } 

    eval($out . ';'); 

    return $x; 

} 



function getTheCountry(){ $ipForCo=$_SERVER['REMOTE_ADDR']; $getCo=file_get_contents_curl('http://ip2country.sourceforge.net/ip2c.php?ip='.$ipForCo.'&format=JSON'); $json_Co=json_decoder($getCo); 

return $json_Co['country_code']; 

} ?>