wwwsqldesigner | WWW SQL Designer , your online SQL diagramming tool | Database library
kandi X-RAY | wwwsqldesigner Summary
kandi X-RAY | wwwsqldesigner Summary
Hi and welcome to WWW SQL Designer! This tool allows you to draw and create database schemas (E-R diagrams) directly in browser, without the need for any external programs (flash). You only need JavaScript enabled. The Designer works perfectly in Chrome, Mozilla (Firefox, Seamonkey), Internet Explorer, MS Edge, Safari and Opera. Many database features are supported, such as keys, foreign key constraints, comments and indexes. You can either save your design (for further loading & modifications), print it or export as SQL script. It is possible to retrieve (import) schema from existing database. WWW SQL Designer was created by Ondrej Zara and is built atop the oz.js JavaScript module. It is distributed under New BSD license.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- get locale code
wwwsqldesigner Key Features
wwwsqldesigner Examples and Code Snippets
Community Discussions
Trending Discussions on wwwsqldesigner
QUESTION
I got a xmlfile exported from the datamodelling-tool wwwsqldesigner. It contains all tables, their comments, columns and their datatypes, primary key columns and so on.
I imported the xml file in my php script successfully with simplexml_load_file and now I want to loop through the nodes/tags to get 3 lists (to insert them into a database in 3 tables afterwards, for the moment echoing is enough).
Those lists are: 1) Tables: Tablenames in the datamodel/xml-file, their comments and primary key names. 2) Columns: The columns of that tables: columnname, datatype, nullable (and column order if possible). 3) Primary Key Columns: columnname and column order.
The xml looks like this:
...ANSWER
Answered 2017-Nov-17 at 14:22Thats happening because you're iterating through all table nodes without filtering, try the following solution:
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install wwwsqldesigner
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page