Libero Ram

Add, Update, Delete and Read JSON Data/File usingPHP

jsonResultSet.json [ { “ID”: “1”, “Name”: “Ram “, “Sports”: “Base Ball” }, { “ID”: “2”, “Name”: “libero Ram”, “Sports”: “Soccer” }, { “ID”: “3”, “Name”: “kumar”, “Sports”: “Tennis” } ] Read JSON File in PHP <?php $data = file_get_contents(‘jsonResultSet.json’); $json_array = json_decode($data, true); foreach ($json_array as $key => $value) { echo $json_array[$key] . ” – ” .…

generate serial number using css

Demo

HTML :

<table border=”1″ class=”Serialnumber”> <thead> <tr> <th>Automatic Serial number</th> <th>Column 1</th> <th>Column 2</th> </tr> </thead> <tbody> <tr> <td></td> <!–leave it blank–> <td>Column 1</td> <td>Column 2</td> </tr> <tr> <td></td> <!–leave it blank–> <td>Column 1</td> <td>Column 2</td> </tr> <tr> <td></td> <!–leave it blank–> <td>Column 1</td> <td>Column 2</td> </tr> <tr>

how to calculate running balance like entries of bank passbook using php mysql

Inded.php

.mytab td, th { border: 1px solid #0da3e2; padding: 5px !important; text-align: center !important; }

.mytab { width: 100%; } .red{ color:red;} h2{ text-align:center; }

Libero Ram S.no date Credit Debit Balance

<?php $sql = mysql_query("select * from test"); $i =1; $x =1;

//

$cridit =mysql_query(“select sum(Credit) AS cri from test where…

send email with attachment using php

<?php function mail_attachment($filename,$path, $mailto, $from_mail, $from_name, $replyto, $subject, $message) { $body = ''; $headers = ''; $file = $path.$filename; $separator = md5(time()); $attachment = chunk_split(base64_encode(file_get_contents($file))); $headers = "From: ".$from_name."<".$from_mail.">" . PHP_EOL; $headers .= "Reply-To: ".$replyto . PHP_EOL; $headers .= "MIME-Version: 1.0".PHP_EOL; $headers .= "Content-Type: multipart/mixed; boundary=\"" . $separator . "\"" . PHP_EOL . PHP_EOL; $body .= "Content-Transfer-Encoding: 7bit" . PHP_EOL; $body .= "This is a MIME encoded message." . PHP_EOL; $body .= "--" . $separator . PHP_EOL; $body .= "Content-Type: text/html; charset=\"iso-8859-1\"" . PHP_EOL; $body .= "Content-Transfer-Encoding: 8bit" . PHP_EOL . PHP_EOL; $body .= $message . PHP_EOL; $body .= "--" . $separator . PHP_EOL; $body .= "Content-Type: application/octet-stream; name=\"" . $filename . "\"" . PHP_EOL; $body .= "Content-Transfer-Encoding: base64" . PHP_EOL; $body .= "Content-Disposition: attachment" . PHP_EOL . PHP_EOL; $body .= $attachment . PHP_EOL; $body .= "--" . $separator . "--"; if (mail($mailto, $subject, $body, $headers)) { echo "Message sent!"; } else { echo "ERROR sending message."; } } $my_file = "Sample_Trade_Journal.pdf"; $my_path = $_SERVER['DOCUMENT_ROOT']."/images/Journal/"; $my_name = "Your Name (or) Your Business"; $my_mail = "[email protected]"; $my_replyto = "[email protected]"; $to_email = "[email protected]"; $my_subject = "Your file has arrived!"; $requester = $_POST['Field101']; $message = "Hey $requester, Your custom email message goes here"; mail_attachment($my_file, $my_path, $to_email, $my_mail, $my_name, $my_replyto, $my_subject, $message); ?>

Calculate Date/Time Difference using php

<?php $date1 = strtotime('2013-07-03 18:00:00'); $date2 = strtotime(date('Y/m/d H:i:s'));                                $subTime = $date1 - $date2; $y = ($subTime/(60*60*24*365)); $d = ($subTime/(60*60*24))%365; $h = ($subTime/(60*60))%24; $m = ($subTime/60)%60;

echo “Difference between “.date(‘Y-m-d H:i:s’,$date1).” and “.date(‘Y-m-d H:i:s’,$date2).” is:\n”; echo $y.” years\n”; echo $d.” days\n”;

Get visitor’s location details from IP address using php

/*Get user ip address*/ $ip_address=$_SERVER['REMOTE_ADDR']; /*Get user ip address details with geoplugin.net*/ $geopluginURL='http://www.geoplugin.net/php.gp?ip='.$ip_address; $addrDetailsArr = unserialize(file_get_contents($geopluginURL)); /*Get City name by return array*/ $city = $addrDetailsArr['geoplugin_city']; /*Get Country name by return array*/ $country =…

Find and highlight text in document using JavaScript

  Demo

Index.html

Find and highlight text in document

JavaScript is the programming language of the Web. The overwhelming majority of modern websites use JavaScript, and all modern web browsers—on desktops, game consoles, tablets, and smart phones—include JavaScript interpreters, making Java- Script the most ubiquitous programming language in history. JavaScript is part of the triad of…

Datepicker from date to date validation using jquery

<label for=”from”>From</label> <input type=”text” id=”from” name=”from” /> <label for=”to”>to</label> <input type=”text” id=”to” name=”to” /> <link rel=”stylesheet” href=”http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css&#8221; /> http://code.jquery.com/jquery-1.9.1.js http://code.jquery.com/ui/1.10.3/jquery-ui.js

$(function () { $(“#from”).datepicker({ maxDate:+0, changeMonth: true,

php while loop form validation using jquery

https://code.jquery.com/jquery-2.1.1.min.js function sendContact(id) {

if(!$(“#userName_”+id).val()) { $(“#userName_”+id).focus();

alert(‘Enter the First Name’); valid = false; } return valid; }

</head> <body>

<?php $i=1; while($i<5){?> <div> <label>Name</label>

<input type=”text” name=”userName” id=”userName_<?php echo $i; ?>” >

<input type=”submit” name=”submit” value=”submit”…

explode functions using php

<?php $liberoram= mysql_query("SELECT * FROM items where id ='5"); while ($row= mysql_fetch_array($liberoram)) { $get_name=  $row['name']; $sringname=  explode (',',$get_name); $s=1; for ($i = 0; $i < count($sringname); $i++) { $name = mysql_real_escape_string($sringname[$i]); $s++; } } ?>

Splitting strings in PHP and get last letter:

$string = 'Ram-kumar-liber-liberoram'; echo…