Php Autoscript

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 conversion CREATE 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 switches purchases,0,0,cm,100,q purchaseid,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 (default=table name) or f=newfilename
2nd row to 200 rows	fieldnames	variable types: varchar text mediumint decimal int smallint tinyint date datetime dummy *	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 $

* dummy = any non-database variable ** cannot mix variables

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)
w	Set Report table cell width manually in pixels w250
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	set the manual size of text boxes or report textareas. Example s5008 which means 50 columns and 8 rows. Inputs ignore the rows column.
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 separated by commas ) example: “a-myarray,c,dmytable”
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
i	Ignore special formatting uses stripslashes only.
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-Q-	no checkhtml5 check to turn of the required statement but still have a js check for valid data.
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

The public check box is used to create a single view php file without the forms and deletes since it is created without the edit buttons. This one works good with the f= switch to give it a new name not to interfere with the data php script files.