Training Database

Mint_Sauce

Mint_Sauce

Mint_Sauce

Soldato
Joined
25 Sep 2003
Posts
3,750
Location
Manchester
Hi,

I've been Googling about as you do, trying to find a database solution for something I'm putting together. I was wondering if anyone knew of any off the shelf solutions for some software that is able to take courses, and the dates those courses are running and show them on a website?

So overall, a student is able to go to the website, type in a course name, hit search then the course shows up, they click description to see the course outline and the dates that course runs. Ideally they would also be able to click a contact us button which would send their name, phone and e-mail along with the course they're looking at.

I think there should be enough companies out there that use this kind of thing so I'm hoping there's an off the shelf solution!

If not, does anyone know how much something tailored like this might cost?
 
surely a simple php page and sql table with course code, course name, dates & price etc would do.

Then when the click the button it takes their contact info and course code and sends it to you.

Doubt its anything very difficult and probably not worth paying for. Although, I have just started learning PHP myself otherwise I'd of been happy to help you.
 
Well, a friend who is a database engineer is totally fine with database side but neither of us know the bit in the middle. We have basic functionality by using visual studio and publishing as a website but really it's quite clunky and lacking all the functionality we need at the moment. :(

We need someone who is able to do the php and show everything nicely. It's got to the point we just need it done!

I was hoping there might be an off the shelf solution and I could put something together myself using his db or even just importing all the data.

Basically what you've said is what we need doing, seems so simple and I bet it is to someone who has half a clue! :)

Actually, if you're learning and fancied it as a project (no strings attached!) then please get in touch (e-mail in trust).
 
Last edited:
Actually Rocklobster, if someone were to help and come up with something that works well and we use it then renumiration would be the absolute first thing to happen. I never expect anything for free. I was merely saying he could have a go and then if it became useable and was integrated then we would send cold hard thanks to his bank account! But if he were to just play with it, get bored and walk away, that's cool too. :)

What you've done almost looks like what we are after. Do you have any pointers on what the main points to learn are? I've just this minute been looking at setting up a connection in PHP to our database using includes and stuff.

Unfortunately our hosting guys only allow one SQL connection at a time and my friend who is the DB guy is using it at the moment or something so I can't connect.

Still, it looks complicated now but with some practice if I get the time I may be able to put something together. Out of interest, how long do you think it would take someone with basic coding skills (i.e. I know about functions/arrays etc) to put what you have put together? Just so I get the idea wether or not i'm going to have the time to invest before I try and get in to it.

thanks.
 
Last edited:
To be honest, it would probably be worth you taking a look at some of the frameworks out there first. CakePHP, for example. I myself am developing a PHP+MySQL based framework at the moment, its an interesting challenge and I am learning a ton about how web application frameworks were developed simply by trying it.

Go on, try it, its fun :D
 
Mint_Sauce my PHP knowledge is limited although I would be happy to have a look in .NET providing you already have a design template (xhtml, css). I hate design :)
 
I've actually just been reading up about ASP all evening. I'm going to TRY and put something together myself. It's not so alien now and I realise the differences between php and asp. I used to do a bit of VB years ago so it's not so alien actually.

This could even be fun! :D

Sunday mission = set up a connection between asp and a test database and pull down some info to display in browser. Here goes....!
 
We are using MsSQL.

I've been playing around with ASP this afternoon, trying to cobble a game together and here it is in all its amazingly shoddy glory, behold!

Code: 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Number Game</title>
</head>

<body>

<form action="test.asp" method="post">
Your Guess: 
<input type="text" name="guess">
<input type="submit" name="Submit">
<br>

</form>

<%

DIM randomNumber
DIM guess 
DIM sesID 

sesID=Request.Cookies("gotnumber")
sesRnd=Request.Cookies("randomNumber")

if sesID="yes" then
Response.Write("Random Number already generated <br />")
Response.Write("sesID: " & sesID & "<br />")
Response.Write("sesNum: " & sesRnd & "<br />")

else

Randomize
randomNumber = int(Rnd *1000)+1
Response.Write ("Random Number: " & randomNumber & " <br />")
Response.Write ("sesID: " & sesID & "<br />Actual Session ID: " & Session.LCID)
'randomNumber = "12"
Response.Cookies("gotnumber")="yes"
Response.Cookies("randomNumber")=randomNumber

end if


if request.form("guess") = sesRnd then

Response.Write("<br />correct")

else

if request.form("guess") < sesRnd then
Response.Write("<br />Too low!")
else
Response.Write("<br />Too High!")
end if

end if
%>

</body>
</html>

The problem I have with it at the moment is that it doesn't compare numbers correctly. For example, you get the number 680 generated for you, you make a guess of 69 and it says too high as the 9 in 69 is higher than the 8 in 680, weird but true. What causes this, I thought it might have been comparing as a string and therefore going a bit crazy but it appears I can't specify (dim) my variables as a certain datatype, is that right?
 
Mint_Sauce said:
We are using MsSQL.
The problem I have with it at the moment is that it doesn't compare numbers correctly. For example, you get the number 680 generated for you, you make a guess of 69 and it says too high as the 9 in 69 is higher than the 8 in 680, weird but true. What causes this, I thought it might have been comparing as a string and therefore going a bit crazy but it appears I can't specify (dim) my variables as a certain datatype, is that right?
Click to expand...

Get yourself a copy of Visual Web Developer Express and do it in ASP.NET rather than using classic ASP.
It's much more flexible (even allowing you to define types as integers ;)) and you'll be glad you did it in the long run.

Free download here:
http://www.microsoft.com/express/vwd/
 
Haircut said:
Get yourself a copy of Visual Web Developer Express and do it in ASP.NET rather than using classic ASP.
It's much more flexible (even allowing you to define types as integers ;)) and you'll be glad you did it in the long run.

Free download here:
http://www.microsoft.com/express/vwd/
Click to expand...

Good call, already it's pointing out to me how badly written my code is.
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom