Tutorialshore
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.
LOAD DATA LOCAL INFILE
To export big size csv(e.g 10gb) files in to mysql database using phpmyadmin is difficult task ,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 we 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…)
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.