Php Autoscript
Create your mysql database. Use PHPAutoScripter to create code in less than 5 minutes that will use your data in thousands of different ways. Contact us to get your beta version.
Runs on all versions of windows and will run by copying into any folder.
How does it work?
You can export the table structure from phpmyadmin and this program will create all of the files necessary to add, edit, delete, view records and upload files. It uses embed points to allow the insertion of code to customize the output. The code generated is well formated to view what is going on.
Before conversionCREATE TABLE IF NOT EXISTS `purchases` (`purchaseid` mediumint(11) NOT NULL AUTO_INCREMENT, `vendor` varchar(30) NOT NULL, `methodid` tinyint(4) NOT NULL, `amount` decimal(8,2) NOT NULL, `description` varchar(200) NOT NULL, `date` date NOT NULL, `personal` tinyint(4) NOT NULL, `reimbursed` tinyint(4) NOT NULL, | After conversion and suppling some switchespurchases,0,0,cm,100,qpurchaseid,mediumint,i,u,h,q vendor,varchar,pvendor@vendors,"l,f",n,q amount,decimal,t10,t2,n2,q description,varchar,a0499,n,n,q date,date,t12,n,o0d,r methodid,tinyint,omethod@method,n,n,"n,r" personal,tinyint,c,n,"`date` DESC",r reimbursed,tinyint,c,n,n,r |
By using the switches created after preping the info, you can create total columns, control multiple sorts, add multiple search fields and add dummy fields to do calculations and sums. View the switches below to see what kind of code you can generate.
Switches
| col 1 | col 2 ** | col 3 | col 4 | col 5 | col 6 | |
| 1st Row: | Table Name | Database | Username | Password cm ch chm | Report Rows | Rename File |
| 2nd row to 200 rows |
field names |
variable types: |
a c e h i o p q r tn un |
f h l n p u s t |
c l h n o s t |
a c d e f h l n p q r s t u v w z $ |
| Column 3 Switches (Cannot mix switches) | |||||||||||||||||||||||||||||||||||||||
| a | textarea (add 4 digit code like 4099 which represents 40 rows and 99 cols. default 1080) | ||||||||||||||||||||||||||||||||||||||
| c | check box. tinyint is field type | ||||||||||||||||||||||||||||||||||||||
| e | embed code follow by the `code` area (example field,smallint,egalleryshowid,n,n,n) | ||||||||||||||||||||||||||||||||||||||
| h | hidden | ||||||||||||||||||||||||||||||||||||||
| i | autoincrement | ||||||||||||||||||||||||||||||||||||||
| o | combobox-use formula (Displayfield@tablex) to provide external field and the table it resides in. | ||||||||||||||||||||||||||||||||||||||
| p | same as o but uses text BOX to supply info. the combo is optional if text box is left blank | ||||||||||||||||||||||||||||||||||||||
| q | same as o but uses text AREA to supply info. the combo is optional if text box is left blank | ||||||||||||||||||||||||||||||||||||||
| r | radiobuttons-use formula (Displayfield@tablex) to provide external field and the table it resides in OR r|dbvalue|visualvalue|. Always end with a | or program crashes. | ||||||||||||||||||||||||||||||||||||||
| t | text size=n maxlength=n | ||||||||||||||||||||||||||||||||||||||
| u | MULTIPLE RECORD INPUT! Like "t" above. Requires seting the multiple records checkbox. text size=n maxlength=n. CLICK on the now visible "txtbox" hyperlink to switch views. | ||||||||||||||||||||||||||||||||||||||
| v | MULTIPLE RECORD INPUT! LIKE "a" above. Requires seting the multiple records checkbox. TEXTAREA CLICK on the now visible "txtbox" hyperlink to switch views. | ||||||||||||||||||||||||||||||||||||||
| 4th column or Form Switches (Can mix switches. Must be between quotes) | |||||||||||||||||||||||||||||||||||||||
| f | first caps | ||||||||||||||||||||||||||||||||||||||
| h | hide from update in Verify.php | ||||||||||||||||||||||||||||||||||||||
| l | locate | ||||||||||||||||||||||||||||||||||||||
| n | normal | ||||||||||||||||||||||||||||||||||||||
| p | protect! update will not happen on this field if it is null. Does NOT affect insert | ||||||||||||||||||||||||||||||||||||||
| u | update | ||||||||||||||||||||||||||||||||||||||
| s | security | ||||||||||||||||||||||||||||||||||||||
| t | total this field (t2 means 2 decimal places) Add number to format column. Do not forget to format the number in column 5 below: | ||||||||||||||||||||||||||||||||||||||
| 5th column or Report Switches (Cannot mix switches) | |||||||||||||||||||||||||||||||||||||||
| c | checkboxed field | ||||||||||||||||||||||||||||||||||||||
| l | link field to previous field | ||||||||||||||||||||||||||||||||||||||
| h | Hide field from Report | ||||||||||||||||||||||||||||||||||||||
| n | Normal. Adding number x at end to create a grand total field decimal places x. | ||||||||||||||||||||||||||||||||||||||
| o | Order by option if another field is selected for sort. Add number after "o" to define importance. "o1d" means it is descending. "o1m" means changes when 0 changes. | ||||||||||||||||||||||||||||||||||||||
| s | Sort my records on this field. | ||||||||||||||||||||||||||||||||||||||
| t | title for field example tEmail/Url | ||||||||||||||||||||||||||||||||||||||
6th column or Report Switches (Can mix switches. Must be between quotes)
| a | array Value is stored in an array. The array can be filled in the "Report Start" embed point. syntax: a-myarray
| c | clone..adds content from this record into a new one. MUST BE APPLIED TO THE UPDATE FIELD
| d | Delete check to prevent orphans on another table. MUST BE APPLIED TO THE UPDATE FIELD Syntax: dmytable
| e | email (creates form javascript)
| f | filtered report from another report created from h. GIVE the filename to link back to h. This should be used an a table that is the child to a parent table
| h | hyperlink filter. Parent table to a Child table. FOLLOW with the file you are linking to. "f" should be used in other file
| l | minimum and maximum size. Follow with length. l-5-50 (creates form javascript)
| n | number (creates form javascript)
| p | phone (creates form javascript)
| q | no check
| r | range filter
| s | string (creates form javascript)
| T | title for field example TEmail/Url
| t | upload file. default jpg. add extension like .pdf (example u../logos|.jpg). THUMBS ARE CREATED IN EXISTING FOLDER ending in 'logos/thm'.
| u | upload file. default jpg. add extension like .pdf (example u../logos|.pdf)
| v | picture link created in view
| w | web address- does not check but makes url into a hyperlink.
| z | zip code type field.
| $ | If a field is formatted using example t2(col 4) and/or n2
(col 5). This will add a dollar sign to the front of the number | | |