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"); ?>