• 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!
Collapse

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

  • You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
  • You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
  • If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Previously on "Website with SQL server"

Collapse

  • hoganj
    replied
    Late joiner to this thread (and my first post in ContractorUK!)
    In short the solution to your problem depends on what you want to achieve with your website.
    I wouldn't recommend programming in PHP/Python/SQL or any other language if you are unfamiliar with scripting. Some of the packaged tools that come with hosting sites are quite nice and I presume there are some good website building tools out there as well. However they all have to link together etc to get your site up and running.
    It sounds to me like you (OP) are new to this and would greatly benefit with a chat from a friend in IT. However from what I know already I think using the tools the hosting site provides will allow you to build up a simple site to give you an 'online presence'. Once you get more used to the technologies you can then consider incorporating databases, SQL and possibly even PHP/Python scripting.

    From a professional standpoint I would use a flavour of Unix, Python, MySQL and Apache (all free) to build a site.

    Leave a comment:


  • quackhandle
    replied
    If you do want to dabble and use a SQL backend then SQL Server Express edn is free to download.

    qh

    Leave a comment:


  • original PM
    replied
    Originally posted by woohoo View Post
    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.
    +1 for this robust, mature, common architecture so you never need to buy people on high rates due to obscure tech stacks.

    so many advantages of this that unless what you are trying to do cannot be done using these tools then use these tools.

    Leave a comment:


  • lilelvis2000
    replied
    Originally posted by eek View Post
    Php is not what the cool kids are doing. Python or node is what the cool kids currently write
    U sure its not AngularJS with NodeJS and MongoDB?

    Cool stuff but probably not what the OP needs. .Net w/ SQL Server is a very good platform. Its what I use everyday!

    Leave a comment:


  • NickFitz
    replied
    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.

    Leave a comment:


  • xoggoth
    replied
    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.

    Leave a comment:


  • woohoo
    replied
    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.

    Leave a comment:


  • woohoo
    replied
    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.

    Leave a comment:


  • xoggoth
    replied
    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.

    Leave a comment:


  • xoggoth
    replied
    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.

    Leave a comment:


  • Bunk
    replied
    Originally posted by NickFitz View Post
    intercepting and re-writing MySQL queries


    That doesn't sound at all prone to error

    Leave a comment:


  • NickFitz
    replied
    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"

    Leave a comment:


  • eek
    replied
    Php is not what the cool kids are doing. Python or node is what the cool kids currently write

    Leave a comment:


  • TheFaQQer
    replied
    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.

    Leave a comment:


  • malvolio
    replied
    Originally posted by BoredBloke View Post
    I want to learn the technology - I don't expect to become a developer in it, but I'd like to be able to dabble in it!
    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.

    Leave a comment:

Working...
X