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.
- 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!
Reply to: Website with SQL server
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.
Logging in...
Previously on "Website with SQL server"
Collapse
-
If you do want to dabble and use a SQL backend then SQL Server Express edn is free to download.
qh
Leave a comment:
-
+1 for this robust, mature, common architecture so you never need to buy people on high rates due to obscure tech stacks.Originally posted by woohoo View PostMost 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.
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:
-
U sure its not AngularJS with NodeJS and MongoDB?Originally posted by eek View PostPhp is not what the cool kids are doing. Python or node is what the cool kids currently write
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:
-
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:
-
Certainly quick and dirty.Originally posted by xoggoth View PostI'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>
Leave a comment:
-
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.Originally posted by TheFaQQer View PostBecause (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:
-
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:
-
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:
-
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.Originally posted by malvolio View PostSo 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.
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:
-
Php is not what the cool kids are doing. Python or node is what the cool kids currently write
Leave a comment:
-
Because (as I said at the start of my post), that's what the cool kids are doing.Originally posted by woohoo View PostSo 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?
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:
-
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.Originally posted by BoredBloke View PostI 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!
Leave a comment:
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers


Leave a comment: