Search database on website
What is good approach- which application to use to create on company website option for a user first to log in, verify and then search by one parameter(product catalog#) to display info about products. Products info are stored in database is SQL Server.
Company do not have data warehouse.
Please any suggestion.
Company do not have data warehouse.
Please any suggestion.
ASKER
Info are changing daily and need to be updated per day. I always thing about back end as database and front end is application -presentation - form - visual part (HTML,CS and JS). Not sure why is .NET and PHP end tire? Are they kind middle tire between front and back end?
Depends on the life cycle of the site + how site will change over time.
Using https://WordPress.org is a good starting point with lots of different search approach plugins.
Using https://WordPress.org is a good starting point with lots of different search approach plugins.
I always thing about back end as database and front end is application
That is exactly right.
Where it can get muddy is the back end code can generate the front end code.
If you want to end up with
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>test</title>
</head>
<body>
Shirt
</body>
</html>You can get there in multiple ways.
Could be as simple as
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>test</title>
</head>
<body>
<?php
// CODE TO ACCESS DATABASE
$product = $db['Name'];
echo $product
?>
</body>
</html><!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>test</title>
</head>
<body>
<div id="response"></div>
<script>
// AJAX CODE TO FETCH DATA AND INJECT INSIDE OF div#response
</script>
</body>
</html>All of this is really another discussion.
Your question is, "...which application to use to create on company website ..."
The answer to that is it depends on the factors that I already mentioned. If you do not have somebody that knows front end, back end and database (could be multiple people), then going down the road of PHP, .NET, Java, Node etc is not an option unless you decide to go with an outside firm to develop your site.
The other end of the spectrum is using a low-code/no-code option. Those get to be expensive and are really geared for larger companies that have the budget.
In the middle are wordpress/woo, shopify and the others. If your pricing only changes daily, that is still one human upload. There will be ways to automate as I showed you or you can do some custom programming.
Without more details about your business and if you are looking to code something, use low-code or something in between.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank you, for giving me good info to start.
There are low-code/no-code options as well like those mentioned in this pros/cons article https://www.liquidweb.com/kb/the-top-five-open-source-nocode-tools/. You will see that they can get pricy.
The fastest and least expensive alternative would be to use Wordpress with Woocommerce or Shopify or other shopping site like https://squareup.com/us/en/ecommerce. With these options, you will need to import your products manually. If your products do not change very often this is not an issue. You can find connectors like zapier https://zapier.com/apps/sql-server/integrations/woocommerce or https://automate.io/integration/sql-server/woocommerce. Importing once and then just updating pricing is going to be the easiest.
To give you a direct answer will depend on your capabilities, the type of products, how often they change and any other features you require vs would just be nice to have.