Search options

så här ser skapa.php ut, den som skapar databasen:

<?
include("data.php");

if ($_GET['vad'] == "skapa") {
$conn = mysql_connect("$dbhost", "$dbuser", "$dbpass");
mysql_select_db($databas); mysql_query("CREATE TABLE nyhet_members (
id INT( 9 ) NOT NULL AUTO_INCREMENT,
email TEXT NOT NULL,
ip TEXT NOT NULL,
PRIMARY KEY ( id )
) TYPE=MyISAM
") or exit( mysql_error());
mysql_close($conn);

echo "<font color='blue'>installationen Klar.</font><br><br><br>";
}

?>
create the table: <a href="skapa.php?vad=skapa">YES</a><br>

När jag körde koden ovan fick jag detta felmeddelande:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/vak/www.vak.nu/reg.php on line 8

Jag tog bort rad 30, och då fick jag inget felmeddelande! Det känns bättre! Tack!

Här kommer data.php:
<?
//mysql info

$dbhost = "localhost"; //mysql-server
$dbuser = "vak"; //username
$dbpass = ""; //password
$databas = "test"; //database

//Login till admin

$login = "login";
$pass = "ECBBBBdy";
?>

När jag kör index.php och registrerar en e-mail adress får jag följande felmeddelande:

Warning: Cannot modify header information - headers already sent by (output started at /home/vak/www.vak.nu/Nyhets brev/data.php:13) in /home/vak/www.vak.nu/Nyhets brev/index.php on line 14

Det finns fler delar, även en index.php som inte heller fungerar som jag vill! Dessa delar finns: skapa.php det fungerar bra (skapar en mysql databas) data.php som jag har ändrat till mina inställningar, (används till databasen) men här kommer index.php:

<?
include("data.php");
$conn = mysql_connect("$dbhost", "$dbuser", "$dbpass");
$week = date("W");
$yesterday = date('Y-m-d', time() -(60*60*24));

mysql_select_db($databas);

if ($_GET['join'] == "true") {
    $q = mysql_query ("SELECT * FROM nyhet_members WHERE ip = '$REMOTE_ADDR'") or exit(mysql_error());
    $r = mysql_fetch_array ($q);
    if ($r[ip]) {
        header("Location: index.php?error=ip");
        die();
    } else {
        mysql_db_query($databas, "INSERT nyhet_members (email, ip) VALUES ('".$_POST['email']."', '$REMOTE_ADDR')") or exit(mysql_error());
        header("Location: index.php?reggad=true");
        die();
    }
}
if ($_GET['exit'] == "true") {
    $q = mysql_query ("DELETE FROM nyhet_members WHERE email = '".$_POST['emaildel']."' AND ip = '$REMOTE_ADDR'") or exit(mysql_error());
        header("Location: index.php?exited=true");
        die();
}

?>
<table width="100%" height="100% cellpadding="0" cellspacing="0">
<tr>
<td width="100% height="100%" align="center" valign="middle">
<table width="200" height="100" bgcolor="#666666" cellpadding="4" cellspacing="1">
<tr>
<td width="100%" height="100%" bgcolor="#E8E8E8" valign="top" align="left">
<?
if ($_GET['error'] == "ip") {
    echo "<font color='red' size='1' face='verdana'><B>ERROR:</B> Du får bara bli medlem med En Email adress.</font><br>";
}
if ($_GET['reggad'] == "true") {
    echo "<font color='#000000' size='1' face='verdana'>Du har nu blivit registrerad.</font><br>";
}
if ($_GET['exited'] == "true") {
    echo "<font color='#000000' size='1' face='verdana'>Du har nu Lämnat Nyhetsbrevet.</font><br>";
}
?>
<font color='#000000' size='1' face='verdana'>
Email Adresser i Databasen: <B><? $count = mysql_db_query("$databas", "select count(*) from nyhet_members") or exit(mysql_error()); echo mysql_result($count, 0); ?>
</B><br><br>
<B>Bli medlem:</B><br>
<form action="index.php?join=true" method="post" onSubmit="submitonce(this)">
<b>Email:</B><br><input type="text" name="email" cols="20">
<input type="submit" value="Send">
</form>
<br>
<B>Gå Ur:</B><br>
<form action="index.php?exit=true" method="post" onSubmit="submitonce(this)">
<b>Email:</B><br><input type="text" name="emaildel" cols="20">
</font>
<input type="submit" value="Send">
</form>
</td>
</tr>
</table>
<table width="200" height="10" cellpadding="0" cellspacing="1">
<tr>
<td width="100%" height="100%" valign="top" align="right">
<font face="verdana" size="1" color="#000000">Script by <a href="mailto:webmaster@dis-vision.com">Luddep</a><br><a href="admin.php">Admin <<</a></font>
</td>
</tr>
</table>
</td>
</tr>
</table>