To connect a page to a Database is very simple with VisualDBScript...
Click on ASP(or PHP) Toolbar and click on the numbered icon 1,2,3,4,5
This 5 Steps are:
- DATABASE SETTINGS VARIABLES
- SERVER CREATE OBJ
- SQL QUERY
- EXEC QUERY
- SHOW RESULTS
The first step is about Database Name, User and Password. If you are using ASP remember to set the file name (example: mydatabase.mdb), if you are using PHP remember to set MYSQL name(example: mydatabase).
The second step create the syntax to connect to Database.
The third step is the SQL syntax(not yet implemented). Remember to change "table" with your table name:
sql = "SELECT * FROM table"
The fourth step exec the query.
The fifth step show results in a table.
You must entered the number of columns (of the table) and their names (that are the names of the Database columns).
Now save file and put it on a server web that support PHP/ASP languages.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
How to create a web-page connected to a Database and how to shows all data records?
To connect a page to a Database is very simple with VisualDBScript...
Click on ASP(or PHP) Toolbar and click on the numbered icon 1,2,3,4,5
This 5 Steps are:
- DATABASE SETTINGS VARIABLES
- SERVER CREATE OBJ
- SQL QUERY
- EXEC QUERY
- SHOW RESULTS
The first step is about Database Name, User and Password. If you are using ASP remember to set the file name (example: mydatabase.mdb), if you are using PHP remember to set MYSQL name(example: mydatabase).
The second step create the syntax to connect to Database.
The third step is the SQL syntax(not yet implemented). Remember to change "table" with your table name:
sql = "SELECT * FROM table"
The fourth step exec the query.
The fifth step show results in a table.
You must entered the number of columns (of the table) and their names (that are the names of the Database columns).
Now save file and put it on a server web that support PHP/ASP languages.