An Easy To Use PHP Form Maker

For more details visit
http://mysqlreports.com/
Have you been looking for the ideal solution for generating web forms for your MySQL database? Well, look no further as the Smart Form Maker is the best option to go for!

---

Closed Caption:

welcome to PHP my sequel for maker the
best solution for generating an
unlimited number of dynamic forms
PHP my sequel for maker can insert
update
navigate and delete records from any my
sequel database
PHP my sequel for maker uses a wizard
type of interface that is very easy to
use
and requires no technical experience
forget the monthly subscription fees you
will pay only once to use PHP my sequel
for maker on your server forever in this
tutorial we will build a simple form for
managing products in my sequel database
in which products should be saved in one
table while product categories should be
stored in a separate table you can
select your forms actions for example
you can create a forum to insert or
update records only this is a form that
can only be used to insert records
similarly you can create forms to insert
edit navigate and delete records
in this example we will choose only the
insert and update options PHP my sequel
for maker handles relations in a very
unique way as we will see in a few
minutes in this step select the fields
that you want to show in the form in the
right panel we will find some field in
red color they are already chosen by PHP
my sequel for maker because these fields
don't allow a no value and will be
included in the form by default
let's go ahead and select the rest of
the fields
in this step we can
all the settings of the forms filled
giving meaningful labels to the fields
for example i will add a space here then
remove the ID and replace it with name
now continue adding spaces PHP my sequel
for maker handles foreign keys in a very
unique and simple way in this example
you have to foreign keys supplier ID and
categoryid all that is required is to
click the foreign key button select the
table in this case you'll select the
categories table and category name
column allowing you to select the
category name from a drop-down menu
instead of entering the category ID
similarly for the supplier ID click
foreign keys
select the suppliers table and the
company name as the displayed value now
select the fields that are required to
be filled in on the forum in other words
if you leave it empty
you should receive an error message
telling you that these fields shouldn't
be left empty fields that are checked
however can be left empty let's uncheck
the unit price so that it becomes
required in the generated form notice
that some fields such as product name
can't be checked because they are
required in the database structure
itself PHP my sequel for maker allows
you to set rules for data validation
in this example we will add a validation
rule to unit price that column includes
numeric data so the available rule is in
the miracle range
allow prices to range from 0 to 1000 if
the enterprise falls outside of this
range a customizable error message will
appear
let's make it price should be less than
one thousand dollars
PHP my sequel for maker supports three
different form layouts columnar
justified and tabular the tabular layout
allows many records to be managed at the
same time in this example we will choose
the tabular layout let's choose the form
style
there are many different styles
supported in this example we will choose
the style
let's make the forum title and name
something like products the description
will be please fill in the following
form
here is the generated form we can
navigate the store data using the pager
we can also insert new records by
choosing a category name
let's make the price 2002 click Save
here we will get the validation error
message now let's enter all the data
correctly and the new record is saved
the URL of this form will be saved so
that you can always use it simply by
linking to it
of course you can generate an unlimited
number of forms by clicking back you can
view all of the generated forms and also
edit any of them easily
here is a justified layout version of
the same form and here is a columnar
version try the published demo version
and see for yourself just how powerful
and easy-to-use PHP my sequel for maker
really is if you have any questions just
hit the support link on our website
technical support is absolutely free and
help is just a click away