Kan ikke poste til database
Nu har jeg efterhånden brugt adskillige timer på dette spørgeskema jeg er i gang med til en skoleopgave:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>AAGIF.DK</title>
<link rel="stylesheet" type="text/css" href="style.css">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
</head>
<body>
<h1>Spørgeskema ang. spillet Oni</h1>
<?
function convert_links($str)
{return preg_replace("/((http|https|ftp)+(s)?:(\/\/)([\w]+(.[\w]+))([\w\-\.,@?^=%&:;\/~\+#]*[\w\-\@?^=%&:;\/~\+#])?)/i", "<a href=\"\\0\" class=\"gbook\">\\0</a>", $str);};
$db = mysql_connect("localhost","******","******");
mysql_select_db("aagif_dk", $db);
if(isset($_POST[skriv])){
echo "Dit svar er modtaget";
$know = $_POST["know"];
$hear = $_POST["hear"];
$play = $_POST["play"];
$own = $_POST["own"];
$buy = $_POST["buy"];
$graphic = $_POST["graphic"];
$sound = $_POST["sound"];
$gameplay = $_POST["gameplay"];
$overall = $_POST["overall"];
$platform = $_POST["platform"];
$comment = convert_links($_POST["comment"]);
$sex = $_POST["sex"];
$age = $_POST["age"];
mysql_query("INSERT INTO oni (know, hear, play, own, buy, graphic, sound, gameplay, overall, platform, comment, sex, age) VALUES ('$know', '$hear', '$play', '$own', '$buy' '$graphic', '$sound', '$gameplay', '$overall', '$platform', '$comment', '$sex', '$age')");
} else {
?>
<form method=post action=<? echo $PHP_SELF; ?>>
<input type=hidden name=skriv value=1>
<table>
<tr>
<td>Kender du spillet Oni?
</td>
<td>
<label><input type="radio" name="know" value="Ja" />Ja</label>
<label><input type="radio" name="know" value="Nej" />Nej</label>
</td>
</tr>
<tr>
<td>Hvor har du hørt om spillet?
</td>
<td>
<label><input type="radio" name="hear" value="Online" />Online</label>
<label><input type="radio" name="hear" value="Blade" />Blade/Magasiner</label>
<label><input type="radio" name="hear" value="Tv" />Tv-spots</label>
<label><input type="radio" name="hear" value="Andet" />Andet</label>
</td>
</tr>
<tr>
<td>Har du spillet Oni?
</td>
<td>
<label><input type="radio" name="play" value="Ja" />Ja</label>
<label><input type="radio" name="play" value="Nej" />Nej</label>
</td>
</tr>
<tr>
<td>Ejer du selv en kopi af spillet?
</td>
<td>
<label><input type="radio" name="own" value="Ja" />Ja</label>
<label><input type="radio" name="own" value="Nej" />Nej</label>
</td>
</tr>
<tr>
<td>Hvis du ikke ejer en kopi af spillet, ville du da overveje at købe det nu?
</td>
<td>
<label><input type="radio" name="buy" value="Ejer">Jeg har allerede spillet</label>
<label><input type="radio" name="buy" value="Ja">Ja</label>
<label><input type="radio" name="buy" value="Nej">Nej</label>
<label><input type="radio" name="buy" value="Ved ikke">Ved det ikke</label>
</td>
</tr>
<tr>
<td>Hvordan vil du vurdere spillet på følgende områder:
</td>
</tr>
<tr>
<tr>
<td>Grafik:
</td>
<td>
<label><input type="radio" name="graphic" value="10">10</label>
<label><input type="radio" name="graphic" value="9">9</label>
<label><input type="radio" name="graphic" value="8">8</label>
<label><input type="radio" name="graphic" value="7">7</label>
<label><input type="radio" name="graphic" value="6">6</label>
<label><input type="radio" name="graphic" value="5">5</label>
<label><input type="radio" name="graphic" value="4">4</label>
<label><input type="radio" name="graphic" value="3">3</label>
<label><input type="radio" name="graphic" value="2">2</label>
<label><input type="radio" name="graphic" value="1">1</label>
</td>
</tr>
<tr>
<td>Lyd:
</td>
<td>
<label><input type="radio" name="sound" value="10">10</label>
<label><input type="radio" name="sound" value="9">9</label>
<label><input type="radio" name="sound" value="8">8</label>
<label><input type="radio" name="sound" value="7">7</label>
<label><input type="radio" name="sound" value="6">6</label>
<label><input type="radio" name="sound" value="5">5</label>
<label><input type="radio" name="sound" value="4">4</label>
<label><input type="radio" name="sound" value="3">3</label>
<label><input type="radio" name="sound" value="2">2</label>
<label><input type="radio" name="sound" value="1">1</label>
</td>
</tr>
<tr>
<td>Gameplay:
</td>
<td>
<label><input type="radio" name="gameplay" value="10">10</label>
<label><input type="radio" name="gameplay" value="9">9</label>
<label><input type="radio" name="gameplay" value="8">8</label>
<label><input type="radio" name="gameplay" value="7">7</label>
<label><input type="radio" name="gameplay" value="6">6</label>
<label><input type="radio" name="gameplay" value="5">5</label>
<label><input type="radio" name="gameplay" value="4">4</label>
<label><input type="radio" name="gameplay" value="3">3</label>
<label><input type="radio" name="gameplay" value="2">2</label>
<label><input type="radio" name="gameplay" value="1">1</label>
</td>
</tr>
<tr>
<td>Samlet:
</td>
<td>
<label><input type="radio" name="overall" value="10">10</label>
<label><input type="radio" name="overall" value="9">9</label>
<label><input type="radio" name="overall" value="8">8</label>
<label><input type="radio" name="overall" value="7">7</label>
<label><input type="radio" name="overall" value="6">6</label>
<label><input type="radio" name="overall" value="5">5</label>
<label><input type="radio" name="overall" value="4">4</label>
<label><input type="radio" name="overall" value="3">3</label>
<label><input type="radio" name="overall" value="2">2</label>
<label><input type="radio" name="overall" value="1">1</label>
</td>
</tr>
<tr>
<td>På hvilken platform har du spillet Oni?
</td>
<td>
<label><input type="radio" name="platform" value="PC" />PC</label>
<label><input type="radio" name="platform" value="Mac" />Mac</label>
<label><input type="radio" name="platform" value="PS2" />Playstation 2</label>
</td>
</tr>
<tr>
<td>Evt. kommentarer, f.eks. fejl og mangler, som du mener gjorde spillet dårligt og/eller uholdbart.
</td>
<td>
<textarea cols="40" rows="5" name="comment"></textarea>
</td>
</tr>
<tr>
<td>Til sidst vil vi gerne bede om dit køn og alder:
</td>
<td>Køn:
<label><input type="radio" name="sex" value="M" />Mand</label>
<label><input type="radio" name="sex" value="K" />Kvinde</label>
Alder:
<input type="text" name="age" size="2" maxlength="2" />
</td>
</tr>
<tr>
<td><input type="submit" value="Send" /></td>
</tr>
</table>
</form>
<? } ?>
</body>
</html>
Er der nogen der kan fortælle mig, hvorfor det ikke poster noget i databasen?! Jeg har selvfølgelig indsat database-navn og kodeord i stedet for de stjerner, der står her.
Jeg har desuden via phpmyadmin indsat en række i tabellen, og det var der ingen problem ved. Den skriver også "Dit svar er modtaget", så man skulle jo tro, at det var forløbet korrekt, men der bliver altså ikke indsat noget!
Kan godt være det bare er mig der har stirret mig blind på en stavefejl, men kan ikke finde den!
