Website Help....Database

[Fuzion]

I would like users of my site to be able fill out a form regarding their 3DMark scores, and then submit it to a database. Also, I would them to be able to pull info from the database if they wish (lookup scores). Is this hard to do? I'm using PHP, any help would be greatly appreciated.

 

[deRusett]

SUPER easy to do


you want a config file to connect to your DB

maybe db.php

<?php
mysql_pconnect("localhost","username","password");
mysql_select_db("DBname");
?>
[code]

then on all your pages that need to access your DB,  you would put this line at the top

[code]
<?php include("db.php"); ?>

<!--then you can put some discriptive HTML-->
<form method=post action=pagename.php?action=submit>
<input type=text size=3 value=0 name=3dmark> 
<input type=submit value=submit>
</form>

<?php
if ($action == submit) {
        $3dmark =floor($3dmark);  //  this will keep people from imputting improper scores 
         $3dmark = str_replace("--","", $3dmark);
         mysql_query("INSERT INTO Tablename  (columb)  Values $3dmark");  // this is your DB connection,  saying what to put into your DB
         print "Thank you for submitting your score of $3dmark";
?>

thats for submitting, viewing them is a bit different but you shoudl beable to figure it out form the example above

 

[Fuzion]

Thanks man. I appreciate it alot.

 

[deRusett]

no problem, that stuff will be like second nature to you in no time,