Text To Mysql Simple Php Code 01.07.08
Project is quite simple:
I need a php written code which will..
1- Pick random X number lines of a given text file(or an excel xls file)
2- Process the data and sort out/replace the characters which can not be used in web addresses. Then records the data as $data1
3- Replace the space characters with (-) and saves the new data as $data2
4- Saves the processed $data1 and $data2 in a given MySql table.
Example:
Text file is like..
word1
word2’s
word3 & word4
word^7h/
..
..
..
(10.000 lines)
Script will say pick the line2(word2’s) and line3(word3 & word4) randomly. (2 random lines each time) - This is section 1 described above.
Script will then process these datas and will remove the special characters and create the $data1 values for both lines. In that example lines should be “word2s” and “word3 word4″. This will be the section 2 described above.
Script will now process the $data1 values once again and will make them SEO friendly urls. In that case the $data2 values will be “word2s” and “word3-word4″. This is section 3 described above.
Script will then save the $data1 and $data2 to mysql for each row. So script will add the values for each id(line) to the MySQL $data1 and $data2 lines. This is the final step of the code.
I am planning to run this code by cron jobs. So the script(php code) should be run each time the cron loads it.
I know more or less how hard programming is but this is very very simple project for any experienced coders. Looking forward to recieve your bids.
Best Regards
Erk
