‘Mysql’ Archives
select multiple column from multiple table in cakePHP
$markers = $this->Post->find('all', array( 'joins' => array( array( 'table' => 'cp_user', 'alias' => 'users', 'type' => 'left', 'foreignKey' => false, 'conditions'=> array('Post.postauthor = users.id') ) ), [...]
How to fetch multi-lingual content from database
The basic purpose of this post is to guide you all about fetching multilingual content from database. I mean to say that, if you have stored japanese text in your database, So in order to fetch the japanese content , you need to set the character encoding to UTF-8 format, while communication with the database for fetching the result. In Case [...]
How to import data into mysql db from sql file
Open your shell prompt navigate to the mysql directory (default is /var/lib/mysql) cd /pathToYourMysqlDirectory/ then type the below command $ mysql -u mysqlUserName -p Password -h HostName DatabaseName < /loactionOfYourSqlFile/yourSqlFileName.sql Where mysqlUserName = Mysql User Name Password = Mysql User Password HostName [...]
Latest music . videos and songs
PHP Manual
