We Require several Excel files whose data imported into corresponding new MySQL database from our site's admin area via new sections created in the admin area for import from Excel.
There are about 6 Excel sheet tables.
Then following that we need to create new data fields when new members register on the site, like his place of birth, the time of his birth. Birthdate is already captured when new members register on the site, and this will be compared against columns in the new MySQL tables created/updated from the corresponding Ms EXcel tables, to derive the user's corresponding zodiac sign.
The zodiac sign, and place of birth and time of birth of the user will be used in conjunction with these new MYSQL tables to retrieve data from the corresponding cells in the MySQL table and presented on the frontend pages of the website.
As a rule of thumb, these tables contain predictions of a user's compatibility with other users, and also predictions about his inner character, personality and his attitude when he is in love. So, matching with frontend data helps to pull out relevant data and show on frontend pages to users. When users press buttons (named after these Excel sheet columns), they can retrieve the above-mentioned data that are displayed on frontend pages for their viewing.
Hi, lets do it. This bid includes a) making importing tools and saving in database. b) Add new field zodiac sign in user registration c)update current users zodiac sign. Using those will be a separate job. Thanks