1. Contracting
    1. General
      1. Brexit
    2. Business / Contracts
      1. Coronavirus Assistance
    3. Accounting / Legal
      1. Umbrella Companies
      2. HMRC Scheme Enquiries
      3. The Future of Contracting
      4. IR35 Reform
    4. Technical
    5. Welcome / FAQs
  2. Social
    1. Light Relief
    2. Social / Events
  • Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Website with SQL server

Collapse
X
11 to 20 of 24 Previous 1 2 3 template Next
Collapse
Reply to Thread
  •  
  • Filter
  • Time
  • Show
Clear All
new posts
11 to 20 of 24 Previous 1 2 3 template Next
    #11
    Originally posted by woohoo View Post
    So he has a copy of Visual Studio, SQL Server and has his hosting setup for this and your advice is to try PHP and MySQL. Why?
    Because (as I said at the start of my post), that's what the cool kids are doing.

    Ultimately, it depends on why you are trying to do something. If you want to do something to play around with, then you choose the tools that you want to play with; if you want to do something which might be more usable or give relevant experience, then you choose the tools that offer that.

    If you just want to use Visual Studio and SQL Server, then why bother making a web application for it? If you want to make a web application, why not use the tools that more people are using, which means that you can get more help when you need it?

    I don't see Visual Studio and SQL Server as something that I would ever consider using for a website, but maybe that's just me.
    Best Forum Advisor 2014
    Work in the public sector? You can read my FAQ here
    Click here to get 15% off your first year's IPSE membership

    Comment

      #12
      Php is not what the cool kids are doing. Python or node is what the cool kids currently write
      merely at clientco for the entertainment

      Comment

        #13
        Originally posted by malvolio View Post
        So set up a free hosted site at Wordpress.com and write some .php extensions and plugins. There's a huge help library on there as well.
        That's a bit like advising somebody seeking advice on providing management consultancy through a limited company to open a shop that sells pottery and run it through a limited liability partnership. The two things may both involve understanding how to manage people and take care of day-to-day operation of a business, but beyond that there's precious little similarity between them.

        Similarly, somebody wanting to apply their existing knowledge of Microsoft web and database technologies would find only the most abstract benefit from working with WordPress*.

        * There is a thing from Microsoft which allows WordPress to run on SQL Server (still reliant on PHP, of course) but it sounds like a massive hack: "the way the SQL Server patch is architected... is intercepting and re-writing MySQL queries"

        Comment

          #14
          Originally posted by NickFitz View Post
          intercepting and re-writing MySQL queries


          That doesn't sound at all prone to error

          Comment

            #15
            I'd agree with PHP and mySQL, just bang it together and it works. Cut this down from a much more complex page, so not sure it works as is but just to give you flavour of how simple it is. Press the button and it adds a record.

            <?php
            session_start();
            $custid = session_id();

            //open database
            $con = mysql_connect("localhost","xxxxx","xxxxx");
            if (!$con)
            {
            die('Could not connect: ' . mysql_error());
            }
            mysql_select_db("xxxxxx", $con);

            //add a record when submit is clicked
            if (isset($_POST['add'])
            {
            $sql="INSERT IGNORE INTO shop (date, custid, silly) VALUES (NOW(), '$custid', 'nostrils')";
            }

            //stops post being done again and cart going up on refresh
            header("Location: " . $_SERVER['REQUEST_URI']);
            ?>

            <!DOCTYPE HTML>
            <html>
            <head>
            <TITLE>Thing</TITLE>
            <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
            </head>

            <body>

            <form name="add" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" method="post">
            <input type="submit" name='add' value="Add to cart">
            </form>

            </body>
            </html>
            Last edited by xoggoth; 9 October 2014, 14:01.
            bloggoth

            If everything isn't black and white, I say, 'Why the hell not?'
            John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

            Comment

              #16
              Personally I'd avoid these off the shelf free things. May seem simpler but if you want to do summit a bit different they are nightmares. Wordpress - yech! My sister had a professional do a Wordpress site for her. It took about 50s to load and when you looked at the content it was hardly surprising, masses of libraries to do very little.
              Last edited by xoggoth; 9 October 2014, 13:58.
              bloggoth

              If everything isn't black and white, I say, 'Why the hell not?'
              John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

              Comment

                #17
                Originally posted by TheFaQQer View Post
                Because (as I said at the start of my post), that's what the cool kids are doing.

                Ultimately, it depends on why you are trying to do something. If you want to do something to play around with, then you choose the tools that you want to play with; if you want to do something which might be more usable or give relevant experience, then you choose the tools that offer that.

                If you just want to use Visual Studio and SQL Server, then why bother making a web application for it? If you want to make a web application, why not use the tools that more people are using, which means that you can get more help when you need it?

                I don't see Visual Studio and SQL Server as something that I would ever consider using for a website, but maybe that's just me.
                Most websites that I've developed have been with Visual Studio, most have a DB. With the odd exception SQL server. I think VS + Sql server is an excellent choice for web development. ASP.NET MVC is an excellent and mature product. Visual Studio is arguably the best IDE out there. I'm struggling to understand your comment, my assumption is that you don't know anything about VS and SQL server.

                Comment

                  #18
                  Originally posted by xoggoth View Post
                  I'd agree with PHP and mySQL, just bang it together and it works. Cut this down from a much more complex page, so not sure it works as is but just to give you flavour of how simple it is. Press the button and it adds a record.

                  <?php
                  session_start();
                  $custid = session_id();

                  //open database
                  $con = mysql_connect("localhost","xxxxx","xxxxx");
                  if (!$con)
                  {
                  die('Could not connect: ' . mysql_error());
                  }
                  mysql_select_db("xxxxxx", $con);

                  //add a record when submit is clicked
                  if (isset($_POST['add'])
                  {
                  $sql="INSERT IGNORE INTO shop (date, custid, silly) VALUES (NOW(), '$custid', 'nostrils')";
                  }

                  //stops post being done again and cart going up on refresh
                  header("Location: " . $_SERVER['REQUEST_URI']);
                  ?>

                  <!DOCTYPE HTML>
                  <html>
                  <head>
                  <TITLE>Thing</TITLE>
                  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
                  </head>

                  <body>

                  <form name="add" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" method="post">
                  <input type="submit" name='add' value="Add to cart">
                  </form>

                  </body>
                  </html>
                  Certainly quick and dirty.

                  Comment

                    #19
                    Maybe we should ask what the host platform is. If thinking of using VS, presume it's Windows? VS (but not used it in web context) is certainly pretty brill IMO. Slickest dev tool going.
                    Last edited by xoggoth; 9 October 2014, 14:42.
                    bloggoth

                    If everything isn't black and white, I say, 'Why the hell not?'
                    John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

                    Comment

                      #20
                      At the end of the day, all possible platforms are of high quality these days. But as the original question was about using Visual Studio, which implies one of the several variants of ASP.NET, and SQL Server, I don't think posts recommending PHP, MySQL, WordPress (which is just PHP and MySQL), or any other options are really on topic.

                      Comment

                      Reply to Thread
                      11 to 20 of 24 Previous 1 2 3 template Next

                      Advertisers

                      1. Contracting
                        1. General
                          1. Brexit
                        2. Business / Contracts
                          1. Coronavirus Assistance
                        3. Accounting / Legal
                          1. Umbrella Companies
                          2. HMRC Scheme Enquiries
                          3. The Future of Contracting
                          4. IR35 Reform
                        4. Technical
                        5. Welcome / FAQs
                      2. Social
                        1. Light Relief
                        2. Social / Events
                      Working...
                      X