LFS Forum - Team KA

#1 - hughesie89

Team KA

Wed, 16 Jan 2008 08:32

Hi all, i know this isn't really an insim thing, but i thought it was the best place to ask

i am looking at create a form for people to put in their infomation so that they can register for upcoming events (like the one used to sign up to this forum, the one that ask username and password and so on)

any idea of how to do it

edit:
the web host offers me database options of
mysql
and
phpmyadmin

#2 - Krammeh

Wed, 16 Jan 2008 11:54

Basically, you need to make a HTML output, with a form, the form will include several fields (username,pass and so on).

It will then post the form to post.php - and that script will take those variables, and put it into the database.

Here is a very very simple sample I just made- shoudl work - but not tested it

[html]<html>
<head>
<title>test</title>
</head>
<body>
<form action="post.php" method="post">
lfs user: <input name="lfsuser"><br>
which event: <input name="event"><br>
<input type="submit" value="send">
</form>
</body>
</html>[/html]



<?php 
php
  // this file needs to be called post.php - if changed, also in above code
 
  $db=mysql_connect("dbhost", "dbuser", "dbpass");
  mysql_select_db("dbname");
 
  $query='INSERT INTO `event_log` (`lfsuser`, `event`)
          VALUES("'.addslashes($_POST['lfsuer']).'",
                 "'.addslashes($_POST['event']).'")';
  mysql_query($query, $db);
  echo 'Your request has been stored';
?>

#3 - the_angry_angel

Wed, 16 Jan 2008 12:31

Cross site scripting issues there Krammeh.

#4 - Krammeh

Wed, 16 Jan 2008 13:18

well of course you would have to include an auth MD5 code, or similar (randomised) or such like.

its just an example.

#5 - hughesie89

Wed, 16 Jan 2008 22:47

alright, i think im over my head here, i do most of my webdev in dreamweaver and contribute and im not a very techniclly minded person.

but i shall give it a go and be back