Архиви на блога

most userful joomla function to debug database query

// Get a db connection. $db = JFactory::getDbo();   // Create a new query object. $query = $db->getQuery(true);   // Select all articles for users who have a username which starts with ‘a’. // Order it by the created date.

С етикет: , , , , , ,
Публикувано в Joomla

mysql import all sql files from directory

for SQL in *.sql; do  echo importing $SQL; mysql -u user  -ppassword table< $SQL;rm $SQL; done

С етикет: , , , , , ,
Публикувано в linux