mysqladmin -u root -p password Newspassword
Monthly Archives: April 2011
MySQL command to show list of tables – Linux
show tables;
MySQL command to show list of databases – Linux
show databases;
How to connect to MySQL Database server using command line
mysql -h localhost -u root -ppassword
Load tinymce editor on client side – Joomla
<?php $editor =& JFactory::getEditor(); echo $editor->display( 'story', $story , '600', '300', '5', '2' ); ?>
How to get prefix of tables in Joomla site
<?php $dVar=new JConfig(); echo $dVar->dbprefix //jos_ ?>
How to check whether the user is logged in or not – Joomla
<?php
$user = & JFactory::getUser();
if($user_id=$user_id=$user->get('id'))
echo "Logged in user"
?>
Find out the user id of the logged in user – Joomla
<?php
$user = & JFactory::getUser();
echo $user_id=$user_id=$user->get('id');
?>
How to decode the data – PHP
<?php
$enData =base64_encode("First");
echo base64_decode($enData);//First
?>
How to encode the data – PHP
<?php
echo base64_encode("First");
?>