Saturday 23 August 2014

Read More option in large content..

If you want to show some content in large content. For that this code will help you...

<?php

function limit_text($text, $limit) 

{

if (str_word_count($text, 0) > $limit) {

$words = str_word_count($text, 2);

$pos = array_keys($words);

$text = substr($text, 0, $pos[$limit]) . '....<a href="" >Read More</a>';

}

return $text;

}

  

$str = "My Name is Karda Ji. I am From India . India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country. India is a greate Country.";

echo limit_text($str,30); //30 is number after that read more is                                            visible

?>

Wednesday 20 August 2014

Accepted Extension of File in HTML

Definition:-


The extensions is accepted by the types of files while uploading in form tag.

Note: The accept tag can only be used with file extension.


Syntax:-

<input accept="file_extension|audio/*|video/*|image/*|media_type">

List:- 

Attribute Values

ValueDescription
file_extensionA file extension starting with the STOP character, e.g: .gif, .jpg, .png, .doc
audio/*All sound files are accepted
video/*All video files are accepted
image/*All image files are accepted
media_typeA valid media type, with no parameters.
 Look at IANA Media Types for a complete list of standard media types


Monday 11 August 2014

How to get size of image and its height and width

This will work with modern browsers as from HTML 5 and the File API



<!DOCTYPE html>

<html>

<head>

<style>

#uploadPreview img{

 height:32px;

}

</style>

<script src="http://ajax.googleapis.com/ajax/libs/jquery/2.0.2/jquery.min.js"></script>


<meta charset=utf-8 />

<title>Multiple image upload with preview by Roko C.B.</title>

</head>

<body>

  <input type="file" id="choose" multiple="multiple" />

<br>

<div id="uploadPreview">

</div>

</body>

<script>

function readImage(file) {

 

var reader = new FileReader();

var image  = new Image();

 

reader.readAsDataURL(file);  

reader.onload = function(_file) {

image.src    = _file.target.result;              // url.createObjectURL(file);

image.onload = function() {

var w = this.width,

h = this.height,

t = file.type,                           // ext only: // file.type.split('/')[1],

n = file.name,

s = ~~(file.size/1024) +'KB';

$('#uploadPreview').append('<img src="'+ this.src +'"> '+w+'x'+h+' '+s+' '+t+' '+n+'<br>');

};

image.onerror= function() {

alert('Invalid file type: '+ file.type);

};      

};

}

$("#choose").change(function (e) {

//if(this.disabled) return alert('File upload not supported!');

var F = this.files;

if(F && F[0]) for(var i=0; i<F.length; i++) readImage( F[i] );

});

</script>

</html>

Saturday 12 July 2014

How to download image from server to local using database.



If you want that user can download your images that was uploaded by the other user.

For that this could will help you :

<?php

function output_file($file, $name, $mime_type='')

{

 if(!is_readable($file)) die('File not found or inaccessible!');

 $size = filesize($file);

 $name = rawurldecode($name);

 $known_mime_types=array(

    "htm" => "text/html",

    "exe" => "application/octet-stream",

    "zip" => "application/zip",

    "doc" => "application/msword",

    "jpg" => "image/jpg",

    "php" => "text/plain",

    "xls" => "application/vnd.ms-excel",

    "ppt" => "application/vnd.ms-powerpoint",

    "gif" => "image/gif",

    "pdf" => "application/pdf",

    "txt" => "text/plain",

    "html"=> "text/html",

    "png" => "image/png",

    "jpeg"=> "image/jpg"

 );

 

 if($mime_type==''){

     $file_extension = strtolower(substr(strrchr($file,"."),1));

     if(array_key_exists($file_extension, $known_mime_types)){

        $mime_type=$known_mime_types[$file_extension];

     } else {

        $mime_type="application/force-download";

     };

 };

 

 //turn off output buffering to decrease cpu usage

 @ob_end_clean(); 

 

 // required for IE, otherwise Content-Disposition may be ignored

 if(ini_get('zlib.output_compression'))

 ini_set('zlib.output_compression', 'Off');

 header('Content-Type: ' . $mime_type);

 header('Content-Disposition: attachment; filename="'.$name.'"');

 header("Content-Transfer-Encoding: binary");

 header('Accept-Ranges: bytes');

 

 // multipart-download and download resuming support

 if(isset($_SERVER['HTTP_RANGE']))

 {

    list($a, $range) = explode("=",$_SERVER['HTTP_RANGE'],2);

    list($range) = explode(",",$range,2);

    list($range, $range_end) = explode("-", $range);

    $range=intval($range);

    if(!$range_end) {

        $range_end=$size-1;

    } else {

        $range_end=intval($range_end);

    }


    $new_length = $range_end-$range+1;

    header("HTTP/1.1 206 Partial Content");

    header("Content-Length: $new_length");

    header("Content-Range: bytes $range-$range_end/$size");

 } else {

    $new_length=$size;

    header("Content-Length: ".$size);

 }

 

 /* Will output the file itself */

 $chunksize = 1*(1024*1024); //you may want to change this

 $bytes_send = 0;

 if ($file = fopen($file, 'r'))

 {

    if(isset($_SERVER['HTTP_RANGE']))

    fseek($file, $range);

 

    while(!feof($file) && 

        (!connection_aborted()) && 

        ($bytes_send<$new_length)

          )

    {

        $buffer = fread($file, $chunksize);

        echo($buffer); 

        flush();

        $bytes_send += strlen($buffer);

    }

 fclose($file);

 } else

 //If no permissiion

 die('Error - can not open file.');

 //die

die();

}


//Set the time out

set_time_limit(0);


$host = "database_host_name"; 

$db_user = "database_user_name"; 

$db_pwd = "database_password";

$db_name = "database_name";

$con = mysqli_connect($host,$db_user,$db_pwd,$db_name);


$filename = "";

$sqlimg = mysqli_query($con,"Select img from table_name");

if($rowimg = mysqli_fetch_array($sqlimg)){
         $filename = $rowimg[0];
}

//Call the download function with file path,file name and file type

if($filename!="")
{

    output_file($file_path, ''.$filename.'', 'text/plain');

}

?>

How to restore mysql database using PHP script

If you want to restore your database with all tables and their data using the code of PHP this will helps you.

Here is the example of Database Restore PHP Script :

<?php

if(isset($_POST['submit'])) //Set Click event on form load

{

$host = "database_host_name"; 

$db_user = "database_user_name"; 

$db_pwd = "database_password";

$db_name = "database_name";

error_reporting(0);

ini_set('memory_limit','128M'); 

$db = mysqli_connect($host,$db_user,$db_pwd,$db_name);


       

        //File name you want to upload.

$filename = $_FILES["filemainname"]["name"]; 


$fp = fopen($filename, 'r' );

$fetchData = fread($fp, filesize($filename));

$sqlInfo = explode(";\n", $fetchData);

foreach ($sqlInfo AS $sqlData )

{

$datad = mysqli_query($db,$sqlData);

}

echo 'Done';

}

?>


<form action="index.php" method="post" enctype="multipart/form-data">

<label for="file">Filename:</label>

<input type="file" name="filemainname" id="filemainname"><br>

<input type="submit" name="submit" value="Submit">

</form>

Tuesday 8 July 2014

How to get Mysql Database Backup Using PHP

If you want to get backup of all tables in your database or specific table in those database .
I think this script will help you for getting database backup.

Here is the example of Database Backup PHP Script :

<?php function backup_db() { $host="localhost"; $uname="database_username"; $pass="database_password"; $database = "databasename";  $return = ""; $connection=mysqli_connect($host,$uname,$pass,$database);  /* Store All Table name in an Array */ $allTables = array(); $result = mysqli_query($connection,'SHOW TABLES'); while($row = mysqli_fetch_row($result)){ $allTables[] = $row[0]; } foreach($allTables as $table){ $result = mysqli_query($connection,'SELECT * FROM '.$table); $num_fields = mysqli_num_fields($result); $return.= 'DROP TABLE IF EXISTS '.$table.';'; $row2 = mysqli_fetch_row(mysqli_query($connection,'SHOW CREATE TABLE '.$table)); $return.= "\n\n".$row2[1].";\n\n"; for ($i = 0; $i < $num_fields; $i++) { while($row = mysqli_fetch_row($result)){   $return.= 'INSERT INTO '.$table.' VALUES('; for($j=0; $j<$num_fields; $j++){   $row[$j] = addslashes($row[$j]);   $row[$j] = str_replace("\n","\\n",$row[$j]);   if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; }    else { $return.= '""'; }   if ($j<($num_fields-1)) { $return.= ','; } }   $return.= ");\n"; } } $return.="\n\n"; } // Create Backup Folder $folder = 'e:/DB_Backup/'; // I am getting database backup on my E driver. if (!is_dir($folder)) mkdir($folder, 0777, true); chmod($folder, 0777); date_default_timezone_set('Asia/Kolkata'); $date = date('m-d-Y-H-i-s', time());  $filename = $folder."db-backup-".$date;  $handle = fopen($filename.'.sql','w+'); fwrite($handle,$return); fclose($handle); } // Call the function backup_db();?>

Tuesday 11 February 2014

Working with Jquery datatable with dynamic data using PHP and Mysql

DataTables is a powerful jQuery plugin for creating table listings and adding interactions to them. It provides searching, sorting and pagination without any configuration. In this article we’ll go through the basics of DataTable and how to use some of the advanced features.

STEP 1 :- Create Database and Table.

We take Example : we create table user in which username and email_id is shown.




STEP 2 :- Now Create Connection in your PHP Page and Connect database with this table .

HERE is the Complete Code of PHP Page : 


<?php
$con = mysqli_connect('localhost','root','','test');
$sqlselect = mysqli_query($con,"SELECT * FROM User");
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico">

<title>DataTables example - Zero configuration</title>
<link rel="stylesheet" type="text/css" href="media/css/jquery.dataTables.css">
<link rel="stylesheet" type="text/css" href="resources/syntax/shCore.css">
<link rel="stylesheet" type="text/css" href="resources/demo.css">
<style type="text/css" class="init">

</style>
<script type="text/javascript" language="javascript" src="media/js/jquery.js"></script>
<script type="text/javascript" language="javascript" src="media/js/jquery.dataTables.js"></script>
<script type="text/javascript" language="javascript" src="resources/syntax/shCore.js"></script>
<script type="text/javascript" language="javascript" src="resources/demo.js"></script>
<script type="text/javascript" language="javascript" class="init">


$(document).ready(function() {
$('#example').dataTable();
} );


</script>
</head>

<body class="dt-example">
<div class="container">
<section>
<h1>DataTables example <span>- Dynamic with PHP and MYSQL</span></h1>

<div class="info">
<p>DataTables has most features enabled by default, so all you need to do to use it with your own
tables is to call the construction function.</p>

<p>Searching, ordering, paging etc goodness will be immediately added to the table, as shown in this
example.</p>
</div>

<table id="example" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th>ID</th>
<th>USERNAME</th>
<th>EMAIL-ID</th>
</tr>
</thead>

<tfoot>
<tr>
<th>ID</th>
<th>USERNAME</th>
<th>EMAIL-ID</th>
</tr>
</tfoot>

<tbody>
<?php
while($rowselect = mysqli_fetch_array($sqlselect))
{
echo"<tr>
<td>".$rowselect['ID']."</td>
<td>".$rowselect['usernam']."</td>
<td>".$rowselect['email']."</td>
</tr>";
}
?>
</tbody>
</table>
</div>
</body>
</html>
You Can Download It From Here : Click Here

For Any Query Please Write a comment !!

Thanks