Hjälp med MySQL och PHP
Hej!
Jag har ett problem med MySQL och PHP. Jag har tre sidor som article.php, add.php och news.php.
Problemet är efter man fyllt i formuläret i artilce.php så kommer man till add.php som addar till databasen och kan jag visa det i news.php. Problemet är att add.php lägger inte information (data) i databasen. Här får ni se alla koder på sidorna.
article.php
<html>
<head>
<title>Add News</title>
</head>
<body>
<form method="post" action="add.php">
<TABLE>
<TR>
<TD>Title:</TD>
<TD><INPUT TYPE='TEXT' NAME='tiit' VALUE='Random Update' size=60></TD>
</TR>
<TR>
<TD>Message:</TD>
<TD><INPUT TYPE='TEXT' NAME='mess' VALUE='' size=60></TD>
</TR><br>
<TD></TD><br>
<TD><INPUT TYPE="submit" name="submit" value="submit"></TD>
</TR>
</TABLE>
</form>
</body>
</html>
--------------------------------------------------------------------------------------------
add.php
<?
//initilize PHP
if($_POST['submit']) //If submit is hit
{
//then connect as user
//change user and password to your mySQL name and password
mysql_connect("xxx","xxx","xxx");
//select which database you want to edit
mysql_select_db("newstb");
//Insert the values into the correct database with the right fields
//mysql table = news
//table columns = id, title, message, who, date, time
//post variables = $title, $message, '$who, $date, $time
// now we insert it into the database
mysql_query("INSERT INTO newstb (tiit, mess) VALUES ('".$_POST['tiit']."', '".$_POST['mess']."') ");
//confirm
echo "Query Finished <a href=news.php>See the News</a>";
}
?>
-------------------------------------------------------------------------------------------
news.php
<?
$username="xxx";
$password="xxx";
$database="xxx";
mysql_connect("xxx",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM newstb";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {
$title=mysql_result($result,$i,"tiit");
$message=mysql_result($result,$i,"mess");
echo "<b>Title: $title <br> Message: $message<br>";
$i++;
}
?>
----------------------------------------------------------------------------------------
Tack för att ni svarar!
