Menu

Create a web-page that shows Database results

Help
2004-05-28
2004-05-28
  • Nobody/Anonymous

    How to create a web-page connected to a Database and how to shows all data records?

     
    • FMJ

      FMJ - 2004-05-28

      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.

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.