|
How can I put a database into a html page.plz forgive me if I ask some wrong question as I am a beginner BCA 1ST SEMESTER.
PLS GUIDE ME
|
|
|
|
|
|
I'm currently working on a project that uses the very same concept. So first thing: you need more than just HTML, but let's start with databases. You can start by using MySQL. Then you're going to need PHP to handle that data i.e. taking it from your database onto your webpage. This is where learning JSON, and by extension JavaScript, is going to actually make this work. Next up on your front end, your webpage, you'll need to use JavaScript with your HTML to get that database on the screen.
Also, what's BCA?
I did have some programming knowledge before doing this and some basic grasp of HTML and JavaScript before embarking on this sort of thing.
Oh one thing that you may find useful, before your website goes live, is XAMPP. It is a local server and has MySQL rolled into one platform. I found it very useful. IT's a great way of testing out your new website without having to spend anything just yet. Although with XAMPP it's still not live, it's good the testing stage.
Please excuse the excessive amounts of info. Welcome to the world of coding.
|
|
|
|
|
This message was not meant for me.
|
|
|
|
|
I'm trying to get some JavaScript to unpack some data using a JSON parse from a separate bit of PHP. Here's what that JSON parse looks like:
[{"ID":"0","Item":"A","Price":"100","Stock":"2214"}, {"ID":"1","Item":"B","Price":"100","Stock":"2214"}....to whatever]
Here's the Javascript that handles all of that:
txt += products[i].ID + ": " + products[i].Item + " \n" + "Price: " + products[i].Price + " \nStock availability: " + products[i].Stock + " \n\n";
$("#itemSelection").append($("<option></option>").text(products[i].Item +"" + products[i].Price).val( products[i].Price ));
This is actually the body of a for loop. So that 1st line unravels the string of data from before and the next line then displays that on a HTML dropdown box. Of course it displays the item and the price, but the actual value of the selection in the background is just the price. Is there a way that the value of the selection can be both the name of the item and the price? Moreover, is there a more efficient way of doing this, since my method for getting the selected item from the drop box into a form is the next bit.
So as part of the aforementioned for loop, this just take that info and sticks it into an array:
sqlStockArr.push( new sqlStock(products[i].Item, products[i].Price) );
Everytime a user makes a selection, this next bit takes the text, value and position of the selection:
var a = $( "#itemSelection option:selected" ).text();
var b = $( "#itemSelection option:selected" ).val();
var c = $("#itemSelection option:selected").index();
var selArrItem = sqlStockArr[ c ].item;
var selArrPrice = sqlStockArr[ c ].price;
$( document ).ready( function(){
$("#customerSelection").append($("<option></option>").text(a).val(b));
selectedArr.push( new sqlStock(selArrItem, selArrPrice) );
total += sqlStockArr[ c ].price;
$("#printPrice").text(total);
Pretty sure I've just made a mess of this. Also please note that I've only included the main chunks of code. If it was part of a function or something, that's not really the issue. Anyways, what you can see is once something has been selected from the aforementioned itemSelection and put into the customerSelection using .text(a).val(b), it does the same kind of thing as before. Another array is made to handle all of that data. Again, is there a less messy way of doing things.
Real sorry if this is just a confusing pile of mess. If anyone can offer up some constructive critique, please go right ahead.
|
|
|
|
|
Valecia_cho wrote: Is there a way that the value of the selection can be both the name of the item and the price?
There sure is, and it'll save you a lot of pain down the road as well:
...
for(var i=0;i<products.length;i++){
$("#itemSelection").append($("<option></option>").text(products[i].Item +"" + products[i].Price).val(i));
}
Then your detail selection becomes:
var idx = $( "#itemSelection option:selected" ).val();
var selected = products[idx];
In short, don't recreate objects that you already have available. Use the same collection, it has all the data that you need and much easier to just use it than trying to update a subordinate collection. Make your presentation dance to the tune of your models, not the other way around.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
That worked great. Looks so much more efficient.
Could I also ask: Is there a way of controlling the position the price and the item? I want them to be on opposite ends of the form.
I'm getting along great with the backend and data handling. That was the basic premise behind this project, but I want to make this look professional. I want to be able to get this website live and give myself an edge on the career front. Any advice on that end you could provide?
Thanks
|
|
|
|
|
Valecia_cho wrote: Could I also ask: Is there a way of controlling the position the price and the item? I want them to be on opposite ends of the form.
I'm not exactly clear on what you're asking here. I don't want to assume, so I'm not going to speculate.
Valecia_cho wrote: I want to be able to get this website live and give myself an edge on the career front. Any advice on that end you could provide?
This one is a bit trickier. I'm a back-system type as well, and developing good UX is definitely not a native talent for me. Fortunately, there are a number of tools to make life easier.
There are a few styling/functionality frameworks out there that will lend a real professional look and feel to your projects. I don't generally advocate framework bloat, but using something like Bootstrap can make it easy to build a clean, responsive page. There are other options, but this is the one that I prefer, largely because there are versions that I can strip jQuery out from.
Other than that, it helps to take a look at some designer-oriented blogs and sites to keep abreast of trends and techniques. Design work takes practice and is a genuine skill. One good one that I've read for years is Smashing.
I hope that helps.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
So if you look at a POS system in real life. Items usually on the far left, price on the far right. In my case they bunch up to the left.
|
|
|
|
|
No clue about POS systems, last time I worked retail I was grateful that the register was even electric.
That's just a flow control issue. Seriously, take a look at Bootstrap. Not only do you get responsive content, you get a pretty decent column layout system to boot.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
Peace be with you all,
So, I would like to set up a website with the following:
- Job listing where companies can list job openings and people can apply
- Business directory where organizations can list themselves and their main activities
- Ads component where people can put advertisements for a particular time frame
I'm looking for an advice on the best way to accomplish this. I know that there are some Joomla extensions that can do this, but also I see there are specially designed scripts/web applications that does this which have been there even before the coming of Joomla and are still in use. As an example, I want something like this website (if links will be allowed here, otherwise its zoomtanzania dot com)
Can you guys advice what would the best option/path for me to take?
|
|
|
|
|
The "best" option, in any endeavour, is to work to your strengths. From your post, I suspect your best option is to be a manager and find someone to work with who has the skills to do this. There are a number of different approaches / technologies available, and none is "best" in itself.
|
|
|
|
|
This morning (01/21/2018) , I ran update-package on a web app I'm working on, and when it tried updating from bootstrap 3 to bootstrap 4, the command froze while it tried to install something called popper.
This is how I learned about version restrictions in packages.config.
If your site relies heavily on bootstrap, and you're using v3, do NOT update to v4 (unless, of course, that is your intent). It is SIGNIFICANTLY different, and your site will look like crap as a result.
In your app's packages.config file, look for the line that manages bootstrap, and add this attribute:
allowedVersions="[3,4)"
This will allow any 3.n.n version to be installed, but nothing newer.
In the interest of completeness, I ran update-package earlier this week and it did not try to install 4.0, so this is something the bootstrap folks did, probably on Friday night (01/19).
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
John Simmons / outlaw programmer wrote: this is something the bootstrap folks did, probably on Friday night (01/19).
Indeed - v4 was released on 18th January:
Bootstrap 4 · Bootstrap[^]
Despite the fact that the site still says:
Currently v4.0.0-beta.3
There's some long documentation on migrating from v3 to v4:
Migrating to v4 · Bootstrap[^]
It looks like a metric crapton of work, especially if you need to support any version of Internet Explorer prior to 11.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
<!DOCTYPE <!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<div class="row">
<div class="col-md-8">
<h3>Data Pegawai</h3>
<a class="btn btn-sm btn-success" href="">Tambah Data</a>
<button class="btn btn-sm btn-default">Jumlah Data 89 </button>
</div>
<div class="col-md-4 col-md-offset-7">
<div class="input-group">
<input type="text" class="form-control" placeholder="Search for...">
<button class="btn btn-default" type="button">Go!</button>
</div><!-- /input-group -->
</div><!-- /.col-lg-6 -->
</div>
<br>
<table class="table table-striped">
<thead>
<tr>
<th>No</th>
<th>Nama</th>
<th>Alamat</th>
<th>Telepon</th>
<th>Username</th>
<th>Status</th>
<th>Opsi</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$q = mysqli_query($koneksi, 'SELECT * FROM tb_kasir');
while ($data = mysqli_fetch_array($q)) {
?>
<tr>
<td> <?php echo $no++; ?></td>
<td> <?php echo $data['nama']; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</body>
</html>
|
|
|
|
|
|
What is the question? 
|
|
|
|
|
If you put a CSS file into a ASP.Net folder, such as App_Code, your web site will NOT load the file using either the /Startup/BundleConfig.cs OR loading the file with <link rel.../>.
I have reasons not to just put the file into the supplied /Content folder, and ended up having to create a /SiteContent folder to allow the file to load.
Seriously - what difference does it make WHERE the file is located? What was MS thinking?
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
It's a "defence-in-depth" approach, in case someone configures IIS to serve .cs files as text; you don't want people being able to download your code. 
According to this thread[^], the following files and folders will all be blocked by default:
- web.config
- bin
- App_Code
- App_GlobalResources
- App_LocalResources
- App_WebReferences
- App_Data
- App_Browsers
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I have a application in node.js and i want to notify my customer on each transaction.
Any help is appreciated.
|
|
|
|
|
Hey Guys, I how can I detect if an element is dragged over another one in Javascript. The next step would be to exchange to position of these two elements. Can anybody help me?
Thank!
|
|
|
|
|
|
Hi Everyone, I am new to this discussion board and would like to clarify a doubt that I presently have whilst building my first Web Application. In Express JS, the web app that I built uses a couple of ejs pages to run the login and registration system through Node Passport. My question is, can I use concurrently use both HTML and ejs together to develop the web app.
Any enlightenment from you guys would be greatly appreciated
|
|
|
|
|
I am trying to implement Dependency Injection using Unity.Asp.Net.WebApi v5.0.11 in my Web API 2 project. When I run my code I get the following exception:
An unhandled exception of type 'System.StackOverflowException' occurred in Unity.Container.dll Below is my Application_Start() in Globalasax:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Http;
using System.Web.Routing;
namespace PaymentSummary
{
public class WebApiApplication : System.Web.HttpApplication
{
protected void Application_Start()
{
GlobalConfiguration.Configure(WebApiConfig.Register);
}
}
}I have looked at tutorials online on setting up Unity for Dependency Injection purposes and tried to add the following code but they are not recognized by Visual Studio.
AreaRegistration.RegisterAllAreas();
RegisterGlobalFilters(GlobalFilters.Filters);
RegisterRoutes(RouteTable.Routes);
BundleTable.Bundles.RegisterTemplateBundles();
Bootstrapper.Initialise();
Please point out what I might be missing in Application_Start(), thanks.
modified 12-Jan-18 21:44pm.
|
|
|
|
|
Please help, I am working on MVC5 platform, during development everything works fine, after the webpage has been deployed on server jquery and datatable plugins are not working.
Thanks in advance!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
