corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Ive just had a really good idea.....


New Topic

New Poll
  <<  1    2  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Ive just had a really good idea.....
dave17
Member

Registered: 3rd Sep 02
Location: Greater London
User status: Offline
23rd Feb 05 at 12:45   View User's Profile U2U Member Reply With Quote


quote:

If you're serious about making it large you'll need to consider your hosting outlay, which if you're not taking money in will be a cost to yourself.



i was thinking of starting it small, on a cheap webhost, to see how it goes, if it starts to pick up, then il change hosting, or up it more.

im not sure how the chargint would work, maybe free for a month then pay onwards, but i dont see people paying to use the site really, its just a bit of fun!! Maybe i could look into advertising on the site if it takes off.


quote:

So far as the programming goes it sounds like you're a long way off, you need to get lots of experience of small scripts and projects before you even consider coding a thing like that from scratch. It took me a fair bit of time to code the garage and that was an addition to existing templates, data structure, functions etc.



granted, i dont know PHP or any other languages, but i do know HTMLso ive got a foot in the door with this kind of thing. Dom found me some scripts on the net, which are hot or not style etc, bits of these will work to creating the whole site.


quote:

You also need a well specced server and I dont necessarily mean speed, if you're uploading images you need to make system calls to resize and thumb them. We were only able to do this when we got our own dedicated hardware which on top of the bandwidth charges is of course another few k of expense.



images are not essential, would just add to the whole feel of the site really. also resising isnt absolutely nessasary, as u can jus put pic must be 300x250 pixels no bigger than 100k blah blah....


quote:

Having that said, the concept is sound. Faceparty certainly don't do badly and I think with an edge there's room for another one.




it has SOME similarities with faceparty, profiles etc, but the main concept for the site is the rating, not hot on not style either.


quote:

You have choices and the first one you'll need to make straight away is whether to programme it in ASP (Microsoft) or PHP which is a less commercial language. I personally prefer PHP which is what CS is written in although it is possible to upload files in ASP, done that as well. Didn't resize them though as they weren't images. I'm sure you can.



I aquired the XP boot cd last night, so im was thinking of goin with ASP. But PHP looks quite similar to HTML so that may be an option.


quote:

You'll need to know a limited amount of SQL as well, this is the query language for the database, you'll use this in both as the queries will be pretty much identical regardless of what programming language you use. You don't need to go too indepth with this but enough knowledge to query efficiently is good. You don't want to slow the system down by having a poor and inefficient database.



the who site is kinda based on database queries, so yes, il have to look into this.


quote:

There is then the twist that images can either be stored directly in the database as a thing called a BLOB - binary large object, or a file on the drive. BLOBS offer far greater control over the file, less opportunity for things to go out of sync, but they're also loads slower.



still unsure about the images, it would be a very nice option to add, seems complicated tho.


another factor is i would like people to be able to sing up, so they have more features (kinda like on here) this also seems complicated


i have spoken 2 my friends etc and they say its a great idea, i just want to get it done tho!! might pop down the library and get a few books out on PHP, ASP and SQL
dave17
Member

Registered: 3rd Sep 02
Location: Greater London
User status: Offline
23rd Feb 05 at 12:57   View User's Profile U2U Member Reply With Quote

oh, forgot to mention, i registered the domain last night, was only cheap so thought why not
Dom
Member

Registered: 13th Sep 03
User status: Offline
23rd Feb 05 at 16:25   View User's Profile U2U Member Reply With Quote

dave, install php mate (php.org, download the php package for windows) and go with that Although its harder, it will be alot easier to do things in the long run, plus hosting will be alot cheaper than windows hosting

As for imagery, sod greating thumbs - just restricted file sizes and/or in the process of upload the image, if its too big (ie: bigger than 200x200 or something) then resize etc.

And like Ian said, keeping track of files vs database shouldnt be to hard either - just set up a CRON job (a script that get executed repeated when you want - day, time etc) to go through the database and check the files against the record - if it isnt found delete entery alert poster of record etc etc

However, images can be added any time once the database side of things has been sorted so its not a problem

Anyways dave, like i said mate, keep it simple first and then build up upon it all
dave17
Member

Registered: 3rd Sep 02
Location: Greater London
User status: Offline
23rd Feb 05 at 19:06   View User's Profile U2U Member Reply With Quote

ok so ive installed all the things i need to, IIS/PHP/SQL. also jus got myself a copy of Dreamweaver ive just installed, taking a look at that too.

also ive downloaded some e-books on PHP and SQL, gona take a read of them.

also downloaded some script packages, about 400 of them gona see if i can use any of them to implement into the PHP

cheers 4 the help guys.
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
23rd Feb 05 at 20:37   View Garage View User's Profile U2U Member Reply With Quote

Sound - you're well on the way then.

You may be better with Apache web server, not sure if IIS does PHP?

The reason PHP looks like HTML is thats what it ends up being after its run. Just look at the source to this page, its just plain HTML but the results of PHP running and querying a database via MySQL.
Dom
Member

Registered: 13th Sep 03
User status: Offline
23rd Feb 05 at 21:00   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Ian
Sound - you're well on the way then.

You may be better with Apache web server, not sure if IIS does PHP?

The reason PHP looks like HTML is thats what it ends up being after its run. Just look at the source to this page, its just plain HTML but the results of PHP running and querying a database via MySQL.


php and IIS run fine, just get it setup to use the dll version for parsing script to
dave17
Member

Registered: 3rd Sep 02
Location: Greater London
User status: Offline
23rd Feb 05 at 23:37   View User's Profile U2U Member Reply With Quote

wel ive been doing a video tutorial i downloaded, and it is pretty good

managed to write this script already:

<html>
<head>
<title> My First PHP script </title>
</head>

<body>

Hi there

<?php

$myInteger = 5;
$myFloat = 55.63;
$myString = "Corsa Sport";
$todaysDate = date("d/m/y");
$firstName = "David";
$lastName = "Bevan";
$Name = $firstName . " " .$lastName;




echo $Name . "<BR>";
echo "$myInteger + $myFloat = " . ($myInteger + $myFloat) . "<BR>";
echo "Did you know the date was ";
echo $todaysDate;
echo "?";

?>

<BR>
Ok..... i am no longer in script. <BR>
Did you know that the time was <? echo date("h:i:s a"); ?>

<BR>

Your IP is : <? echo getenv ("REMOTE_ADDR");
?>


</body>


</html>

Which basically shows as this:

Hi there David Bevan
5 + 55.63 = 60.63
Did you know the date was 23/02/05?
Ok..... i am no longer in script.
Did you know that the time was 11:36:47 pm
Your IP is : 127.0.0.1




[Edited on 23-02-2005 by Dave17]

  <<  1    2  >>
New Topic

New Poll

Corsa Sport » Message Board » Off Day » Ive just had a really good idea..... 24 database queries in 0.0079820 seconds