April 27, 2015 at 4:24 pm
I am working on a small project and trying to:
Make a few simple pages to enter data into multiple tables in my SQL DB.
I have the DB designed and IIS setup but I am trying to wrap my head around the php connection to the DB and then relating the tables/columns in the "Input" page.
After this is done I will use SRS to use these entries to show reports hourly.
Can anyone help with the entry page?
May 15, 2015 at 4:21 pm
Any ideas?? ... crickets...
May 15, 2015 at 4:24 pm
You haven't said anything about your level of programming skills, so it's pretty hard for anyone to give decent advice.
For complete novices, I would suggest taking a look at Visual Studio Lightswitch - it is designed for exactly this type of simple web form.
If you have any development experience, you will probably hate that, so learn asp.net MVC.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);May 16, 2015 at 12:37 pm
You make good points. My Experience is mostly HTML, HTML5, and I have done creations with Lightswitch as well. I can read JAVA and ASP.
Not the best at writing it.
I thought lightswitch would work but I though there maybe a simple way to do it with just a single webpage front end screen. I wasn't a fan of the grids on lighswitch as they seemed a bit limited to what I could and could not do thus creating an issue with creating more webforms in the future.
May 16, 2015 at 2:15 pm
I second the recommendation of Lightswitch, it's what it's designed for. There's lots of pitfalls in 'simple' PHP pages, not least of which are very common security mistakes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply