Is it possible priority of search in mysql Full text search

yes, it is possible priority of search in mysql  Full text search.we can define priority of search by adding + and – before search phrase in boolean mode

+ means include that word

– means Excluding  that word

For E.g  SELECT * FROM product_table WHERE MATCH (column1, column2) AGAINST (‘”+mobile -charger”‘ IN BOOLEAN MODE);

it will only search for only mobiles in db , if it find  “mobile charger ” it will skip that row.This way we can add priority of search in Full text search of MySQL.

How to export big size csv files mysql database

LOAD DATA LOCAL INFILE 

To export big size csv(e.g 10gb) files in to mysql database using phpmyadmin is difficult . Fortunately we have solution.You can use linux ssh prompt to insert big size csv files mysql database, for that we have MySQL function ” LOAD DATA LOCAL INFILE ” by using this we can insert big gb sql file in to database(export big size csv files in to database) directly, below i have mentioned syntax with example

 

# mysql -u admin -p`cat /etc/psa/.psa.shadow`;

mysql>LOAD DATA LOCAL INFILE ‘FileName.csv’ INTO TABLE table
FIELDS
TERMINATED BY ‘,’
LINES
TERMINATED BY ‘\\n’
IGNORE 1 LINES
(column1, column2, column3…)

see more about SSH

How to create Twitter tell a friend API

Twitter provided lot of api to share your website, here am going to show you how to create Twitter tell a friend API.

1) Create a tell a friend share action page

e.g refer-login.php

In this page you add twitter meta tag like image and content.

e.g

<meta name=”twitter:card” content=”photo” />

<meta name=”twitter:site” content=”@technomania” />

<meta name=”twitter:title” content=”To create Twitter tell a friend” />

<meta name=”twitter:description” content=”description” />

<meta name=”twitter:image” content=”image path” />

2)  Then in tell a friend page link twitter tell a friend share button to https://twitter.com/intent/tweet?text=share message&url=refer-login.php&via=sitename.  This will automatically fetch image from meta tag in refer-login.php and display in users tweet.