Script requirements for [login to view URL]
[login to view URL] provides free scripts to webmasters to Read, Write and Search a Flatfile CSV database on a website.
BEFORE YOU BID on upgrading and writing new versions of the scripts you must download and install CSVread Xtra CSVwrite CSVsearch and CSVdelete on your server and post the URL with your bid to demonstrate an understanding of the issues.
Bids from people who have not taken the time to understand the job will not be considered. We don’t need any more time wasters please we have customers who want to see scripts done and working.
Step 1 CSVedit
This script will need to open a CSV database in full to allow people to edit fields. The database can be any size with any number of fields.
The database will have the top row as the name of the fields, this is then separated by a pipe with the data below.
This data should then be displayed as one page of information with the field name on the left and the data on the right. The data will be displayed in a text box for editing.
A tick box is then displayed below each line of the database. A button is displayed at the bottom. On clicking the edit button at the bottom, the records that have been ticked will change to the new value that has been put in, using the same values as CSVwrite.
The script then re-runs from the start reading the database again in full. This will stop errors if the refresh button is pushed. (See CSVdelete as example)
Field name 1 Value 1
Field name 2 Value 2
Field name 3 Value 3
Field name 4 Value 4
[ x ]
Field name 1 Value 1
Field name 2 Value 2
Field name 3 Value 3
Field name 4 Value 4
[ x ]
[ EDIT ]
Step 2 CSVwrite
Changes to CSVwrite. For added security hardcode thedatabase location to the main script. allow the location of the Thank You file to be in the form rather than the script.
If the form field is "DATE_LOCAL" then the server date is automatically added to the database field "DATE_LOCAL" The script would return an error using the current error system if the database has not got this field to write to. The other Environmental variables would act in the same way.
REMOTE_ADDR Will display the visitors IP Address
HTTP_USER_AGENT Will display the visitors Browser information
DATE_LOCAL Will display the Date and Time
Step 3 CSVwrite special version
Using the changed CSVwrite as above we then have 3 new editions, the first to have required field, that are checked, so if it is email it will ensure it is in the right format, if it is numbers only it will check 0-9 only and if it just required then just ensure it has something. I expect that to do this the user will enter the fields they wish to have required in the 3 sections at the top of the script.
3.2 special version to email the webmaster and/or an address if submitted by the user a copy of the form they have sent.
3.3 both of the options together.
Step 4 CSVread Xtra * changes
Changes to CSVread Xtra. Many users have requested that the number of results per page can be set. This would then have buttons at the bottom of the page to move on to the next page or previous page.
*ensure you don’t change the standard CSVread
Step 5
Fix CSVsearch. The basic script and searching is fine, but advanced filtering and searching is not working as described in the instructions.
5.2 Add the results per page solution (Step 4) to CSVsearch also.
[login to view URL]
better make 4 scripts in one:) or use adminscript to all tables. If i have in my base 30 tables, no good idea have per table delete&read scripts