Har ett ICQ script som jag bygger om till ett Msn script. Nåja.. Kan lägga till id. då jag ser dom olika id.en i databasen men den visar inte innehållet alltså dom olika id.ena i index.php. Något som inte stämmer...
Eftersom tabellerna i ICQ scriptet hette
-id
-name
-icq
-email
så gjorde jag det enkelt för mig och la till bokstäver och bytte ut icq mot msn, men förmodar att jag missat msn och msnn nånstans....
Databasen innehåller följande:
<?
include("data.php");
if ($_GET['vad'] == "skapa") {
$conn = mysql_connect("$dbhost", "$dbuser", "$dbpass");
mysql_select_db($databas); mysql_query("CREATE TABLE msn (
idd INT( 9 ) NOT NULL AUTO_INCREMENT,
namee VARCHAR( 100 ) NOT NULL ,
msnn VARCHAR( 100 ) NOT NULL ,
emaill VARCHAR( 100 ) NOT NULL ,
PRIMARY KEY ( id )
);") or exit( mysql_error());
mysql_close($conn);
echo "Klart!";
} else {
print "<a href=\"skapa.php?vad=skapa\">Skapa Tabell</a>";
print "<a href=\"skapa.php?vad=delete\">Tabort Tabell</a>";
}
if ($_GET['vad'] == "delete") {
$conn = mysql_connect("$dbhost", "$dbuser", "$dbpass");
mysql_select_db($databas);
mysql_query("DROP TABLE msn") or exit( mysql_error());
mysql_close($conn);
echo "<font color='blue'>Tabellen borta.</font><br><br><br>";
}
?>
Out.php
<?
include("data.php");
$conn = mysql_connect("$dbhost", "$dbuser", "$dbpass");
mysql_db_query($databas, "UPDATE links set klicks = klicks + 1 where id = '".$_GET['idd']."'") or exit(mysql_error());
$get = mysql_db_query($databas, "SELECT * FROM links WHERE idd = '".$_GET['idd']."'");
while ($r = mysql_fetch_array($get)) {
?>
<link rel="stylesheet" href="style.css" type="text/css">
<meta http-equiv="Refresh" content="1; URL=<? print $r["url"]; ?>">
: <?
}
mysql_close($conn);
?>
Index.php
<?
include("data.php");
$conn = mysql_connect("$dbhost", "$dbuser", "$dbpass");
if ($_GET['add'] == "true") {
$obj = mysql_db_query($databas, "SELECT * FROM msn WHERE msnn = '".$_POST['msnn']."'") or exit(mysql_error());
if ($find = mysql_fetch_array($obj)) {
if($_POST['icq'] == $find['msnn']) {
header("Location: index.php?error=true");
die();
}
}
mysql_db_query($databas, "INSERT msn (namee, msnn, emaill) VALUES ('".$_POST['namee']."', '".$_POST['msnn']."', '".$_POST['emaill']."')") or exit(mysql_error());
header("Location: index.php");
}
?>
<body bgcolor="cccccc" link="000000" alink="ff0000" vlink="000000">
<font size="1" face="Verdana, Helvetica, sans-serif" color="000000"><strong>
<style type="text/css">
<!--
body { scrollbar-base-color: #cccccc; scrollbar-track-color: #cccccc; scrollbar-arrow-color: #000000;}
-->
</style>
<?
if ($_GET['add'] == "yes") {
?>
<script>
function submitonce(theform){
if (document.all||document.getElementById){
for (i=0;i<theform.length;i++){
var tempobj=theform.elements[i]
if(tempobj.type.toLowerCase()=="submit"||tempobj.type.toLowerCase()=="reset")
tempobj.disabled=true
}
}
}
</script>
<form action="index.php?add=true" method="post" onSubmit="submitonce(this)">
<b>Name:</B><br>
<input type="text" name="namee" cols="30"><br>
<b>Email:</B><br>
<input type="text" name="emaill" cols="30"><br>
<b>Msn id:</B><br>
<input type="text" name="msnn" cols="30" value=""><br>
<br>
<input type="image" src="images/submit.bmp" value="skicka">
</form>
<?
} else {
if ($_GET['error'] == "true") {
echo "<font color='red'><B>Error: </B>This Msn id. is allready existing in the database.</font><br><br>";
}
?>
<img src="images/msn.bmp" align="absbottom">
<a href="index.php?add=yes">Add your Msn id.</a><br><br>
<?
$get = mysql_db_query($databas, "SELECT * FROM msn ORDER BY id DESC");
while ($r = mysql_fetch_array($get)) {
print "<img src='http://wwp.icq.com/scripts/online.dll?icq=";
print $r["msn"];
print "&img=5'>";
print " | <a href='mailto:";
print $r["emaill"];
print "'>";
print $r["namee"];
print "</a> | #";
print $r["msnn"];
print "<br>";
}
}
?>