Connect to MySQL from the command line
To connect to MySQL from the command line:
Log in to your A2 Hosting account using SSH.
At the command line, type the following command, replacing USERNAME with your username:
mysql -u USERNAME -p
At the Enter Password prompt, type your password. When you type the correct password,
the mysql> prompt appears.
To display a list of databases, type the following command at the mysql> prompt:
show databases;
To access a specific database, type the following command at the mysql> prompt,
replacing DBNAME with the database that you want to access:
use DBNAME;
After you access a database, you can run SQL queries, list tables, and so on. Additionally:
To view a list of MySQL commands, type help at the mysql> prompt.
To exit the mysql program, type \q at the mysql> prompt.
<script type="text/javascript">function googleTranslateElementInit() {
var elem = new google.translate.TranslateElement({
pageLanguage: "ca",
layout: google.translate.TranslateElement.InlineLayout.HORIZONTAL,
autoDisplay: false,
floatPosition: 0
});
elem.onTurnOffLanguageClick = function() {
var event = document.createEvent("Event");
event.initEvent("translateExt_disable_lang", true, true);
document.body.dispatchEvent(event);
};
var style = document.createElement("style");
style.appendChild( document.createTextNode( ".global_header { top: 40px !important; }" ) );
document.getElementsByTagName( "head" )[ 0 ].appendChild( style );
elem.showBanner(false);
}</script>
$(document).ready(function () {
//called when key is pressed in textbox
$("#quantity").keypress(function (e) {
//if the letter is not digit then display error and don't type anything
if (e.which != 8 && e.which != 0 && (e.which < 48 || e.which > 57)) {
//display error message
$("#errmsg").html("Digits Only").show().fadeOut("slow");
return false;
}
});
});
Number :
<input type="text" name="quantity" id="quantity" /> <span id="errmsg"></span>
var chkArray = [];
$(".chk:checked").each(function() {
chkArray.push($(this).val());
});
var selected;
selected = chkArray.join(',') + ",";
if(selected.length > 1){
alert("You have selected " + selected);
}else{
alert("Please at least one of the checkbox");
}
Windows Vista and Windows 7
Click Start.
Select Control Panel.
Click Uninstall a program.
Remove TV Wizard.
Windows XP
Click Start.
Select Control Panel.
Click Add or Remove Programs.
Uninstall the adware program.
Windows 8
Move the mouse pointer do the lower-left corner of the screen.
Right-click.
Select Control Panel.
Click Uninstall a program.
Remove the unwanted program.
document.onkeydown = myKeyDownHandler;
function myKeyDownHandler(event){
alert(event.keyCode)
}
<script src="https://www.google.com/jsapi" type="text/javascript">
</script>
<script type="text/javascript">
google.load("elements", "1", { packages: "transliteration" });
function onLoad() {
var options = {
sourceLanguage: google.elements.transliteration.LanguageCode.ENGLISH,
destinationLanguage: [google.elements.transliteration.LanguageCode.TAMIL],
shortcutKey: 'ctrl+g',
transliterationEnabled: true
};
var control = new google.elements.transliteration.TransliterationControl(options);
control.makeTransliteratable(['transliterateTextarea']);
}
google.setOnLoadCallback(onLoad);
</script>
<div class="Google-transliterate-Way2blogging">
Type in Hindi (Press Ctrl+g to toggle between English and Tamil)<br>
<textarea id="transliterateTextarea" style="width:600px;height:200px;resize:none;">
</textarea>
<span style="font-weight:bold;font-size:10px;float:right;margin:5px;">
</span>
</div>
// $ds contains the total number of bytes available on "/"
$ds = disk_total_space("/");
// On Windows:
$ds = disk_total_space("C:");
$ds = disk_total_space("D:");
echo php_uname();
echo PHP_OS;
/* Some possible outputs:
Linux localhost 2.4.21-0.13mdk #1 Fri Mar 14 15:08:06 EST 2003 i686
Linux
FreeBSD localhost 3.2-RELEASE #15: Mon Dec 17 08:46:02 GMT 2001
FreeBSD
Windows NT XN1 5.1 build 2600
WINNT
*/
if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
echo 'This is a server using Windows!';
} else {
echo 'This is a server not using Windows!';
}
Method I :
function distance($lat1, $lon1, $lat2, $lon2, $unit) {
$theta = $lon1 - $lon2;
$dist = sin(deg2rad($lat1))*sin(deg2rad($lat2))+
cos(deg2rad($lat1))*cos(deg2rad($lat2))*cos(deg2rad($theta));
$dist = acos($dist);
$dist = rad2deg($dist);
$miles = $dist * 60 * 1.1515;
$unit = strtoupper($unit);
if ($unit == "K") {
return ($miles * 1.609344);
} else if ($unit == "N") {
return ($miles * 0.8684);
} else {
return $miles;
}
}
echo distance(11.01078,76.93433,11.14137,78.59412,10.1, "M") . " Miles
";
echo distance(11.01078,76.93433,11.14137,78.59412,10.1, "K") . " Kilometers
";
echo distance(11.01078,76.93433,11.14137,78.59412,10.1, "N") . " Nautical Miles
";
Method II:
function calculateDistance($latitude1, $longitude1, $latitude2, $longitude2) {
$theta = $longitude1 - $longitude2;
$miles = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) +
(cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) * cos(deg2rad($theta)));
$miles = acos($miles);
$miles = rad2deg($miles);
$miles = $miles * 60 * 1.1515;
return $miles;
}
1. Open Internet Explorer and Select Proxy. 2. Choose Port and Proxy Address, right click on it and copy it. 3. Go to Tools > Internet Options 4. Select Connection Tab and go to LAN Settings. 5. Select Use a proxy server for your LAN in Proxy server 6. Paste Port & Proxy server in Port Box and Address box. 7. Click OK and Exit.
header('Content-Type: image/jpeg');
$w=100;
$h=100;
$filename = 'picture.jpg';
for($i=0;$i<10;$i++){
$rfname="images/re$i.jpg";
resize($filename,$w,$h,$rfname);
}
function resize($filename,$w,$h,$rfname){
list($width, $height) = getimagesize($filename);
$image_p = imagecreatetruecolor($w,$h);
$image = imagecreatefromjpeg($filename);
imagecopyresampled($image_p, $image, 0, 0, 0, 0, $w, $h, $width, $height);
imagejpeg($image_p,'', 100);
imagejpeg($image_p,$rfname);
}
1. mkdir - make directories 2. cd - change directories 3. mv- change the name of a directory Ex: mv testdir newnamedir 4. pwd - print working directory will show you the full path to the directory you are currently in. This is very handy to use, especially when performing some of the other commands on this page 5. rmdir - Remove an existing directory 6. rm -r Removes directories and files within the directories recursively. 7. chown - change file owner and group 8. chmod - change file access permissions 9. reboot - Reboots the system (requires root privileges). 10.ping host - Sends an echo request via TCP/IP to the specified host. A response confirms that the host is operational.
<?php
include 'reader.php';
$excel = new Spreadsheet_Excel_Reader();
?>
<table border="1">
<?php
$excel->read('sample.xls');//set the excel file name here
$x=1;
while($x<=$excel->sheets[0]['numRows']) { // reading row by row
echo "\t<tr>\n";
$y=1;
while($y<=$excel->sheets[0]['numCols']) {// reading column by column
$cell = isset($excel->sheets[0]['cells'][$x][$y])?$excel->sheets[0]['cells'][$x][$y] :'';
if($cell)
echo "\t\t<td>$cell</td>\n"; // get each cells values
$y++;
}
echo "\t</tr>\n";
$x++;
}
?>
</table><br/>
<div class="col-xs-12 col-sm-12 col-lg-12 cal">
<p id='demo' class="text-center cal-container"></p>
</div>
</a>
<?php
$current_timestamp = time();
?>
<script type='text/javascript'>
flag = true;
timer = '';
phpJavascriptClock();
setInterval(function(){phpJavascriptClock();},1000);
function phpJavascriptClock()
{
if ( flag ) {
timer = <?php echo $current_timestamp;?>*1000;
}
var d = new Date(timer);
months = new Array('Jan', 'Feb', 'Mar', 'Apr', 'May',
'Jun', 'Jul', 'Aug', 'Sept', 'Oct', 'Nov', 'Dec');
month_array = new Array('January', 'Febuary', 'March',
'April', 'May', 'June', 'July', 'Augest', 'September', 'October',
'November', 'December');
currentYear = d.getFullYear();
month = d.getMonth();
var currentMonth = months[month];
var currentMonth1 = month_array[month];
var currentDate = d.getDate();
currentDate = currentDate < 10 ? '0'+currentDate : currentDate;
var hours = d.getHours();
var minutes = d.getMinutes();
var seconds = d.getSeconds();
var ampm = hours >= 12 ? 'PM' : 'AM';
hours = hours % 12;
hours = hours ? hours : 12; // the hour ’0' should be ’12'
minutes = minutes < 10 ? '0'+minutes : minutes;
seconds = seconds < 10 ? '0'+seconds : seconds;
var strTime = hours + ':' + minutes+ ':' + seconds + ' ' + ampm;
document.getElementById("demo").innerHTML= currentMonth+'
' + currentDate+' , ' + currentYear + ' ' + strTime ;
flag = false;
timer = timer + 1000;
}
</script>