Hello,
I'm searching for a programmer who can create two files (and maybe a classes or db-file) to read data and import data in my database.
The 2 files must be:
- [login to view URL] (to update my database with information from a array)
- [login to view URL] (to read the information from the database)
My database contains 2 tables with the following information:
Table DOCUMENTS:
doc_id | author | publisher | title | url | category_id
Table CATEGORY:
id | categoryname | sub_cat_from
[login to view URL]:
This file contains an array with the following information:
Array
(
[result] => Array
(
[doc_id] => 127553
[author] => Johny
[Publisher] => My Publisher
[title] => My First book
[category] => New books|School|University
)
[result 2] => Array
[doc_id] => 102857
.........
Details:
- The update.php-script must convert the field ‘title' to url (e.g. ‘My First Book' to ‘my_first_book'
- The script must split the category-field (sample: ‘New books|School|University') and recognize that University is a sub from School and a sub from New books.
[login to view URL]
- Must read the documents from the database and put them in the right category.