Friday, October 10, 2014

Tuesday, October 7, 2014

When you run the php website involved to full text search that might be occurs this problem.

SQL query :

$q = "SELECT uname,post_date,subject,message FROM forum WHERE MATCH (message) 
AGAINST ( '$target') ORDER BY post_date ASC";

“Warning: mysqli_num_rows( ) expects parameter 1 to be
mysqli_result, boolean"

Database engine type : innoDB

You need to choose Full Text Search for the table.

SQL syntax :

ALTER TABLE FORUM ADD FULLTEXT(column )

Example

ALTER TABLE table_test ADD FULLTEXT(message_test)

Thursday, September 18, 2014

SHA1 encryption

When we have to involved to develop a interactive web site such as online forum or e commercial simultaneously we need to store and protect the information of user. Password security problem would be usually occurs to mostly website. Developer should be considered majority of scenario or circumstances for choosing a appropriate method for password encryption. SHA1('$p') is a function for protecting a password. The acronym SHA stands for Secure Hash Algorithm, which is a security measure created by the US National Security Agency. It instructs MySQL to encode the password by converting it to a string 40 characters.

SQL syntax:

VALUES (' ', '$fn', '$ln', '$e', SHA1('$p'), NOW() )";

Saturday, September 6, 2014

Shibuya Hikarie Gorgeous building short movie

Shibuya Hikarie

Gorgeous building short movie

The Shibuya Hikarie (渋谷ヒカリエ) is a Tokyu skyscraper and retail complex completed in 2012 and located in the Shibuya shopping district of Tokyo, Japan

Thursday, September 4, 2014

Max and Min-width Properties and Pre tag

When we want to our website design or other web application suitable displaying for different device, you should be setting the max-width and min-width properties. Most of browser support ( IE7-> Firefox )

div {
min-width : 200px;
max-width : 500px;
padding : 5px;
border : 1px solid #000000;
}

If you would like to preserves both spaces and line breaks in your content.

Please using the <pre> tag

<pre>
Westlife

I Have A Dream

    ：Bjorn Ulvaeus、Benny Andersson
    ：Bjorn Ulvaeus、Benny Andersson

    I have a dream, a fantasy
    To help me through reality
    And my destination makes it worth the while
    Pushing through the darkness still another mile
    I believe in angels

</pre>