What is wrong ? the second form where i insert data into the database fails.
it cant connect to the database
Here is my index.php file.
------------------------------------------------------------------------------------------------------------------
<?php
function texter()
{
global $conn;
$conn = mysql_connect("localhost", "root", "diewin") or die(mysql_error());
mysql_select_db("texter",$conn) or die(mysql_error());
}
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
Sök efter: <input type="text" size="25" name="searchfor" /><br />
<input type="submit" value="Sök!" />
</form>
<?php
if (isset($_POST['searchfor']) && trim($_POST['searchfor']) != '')
{
texter();
$searchfor = addslashes($_POST['searchfor']);
$sql="SELECT title, text FROM texts,details WHERE texts.textid=details.textid AND title LIKE '%".$searchfor."%';";
$result=mysql_query($sql, $conn);
if(mysql_affected_rows()>0)
{
echo "Följande poster hittades:<br /><br />";
while($row = mysql_fetch_array($result))
{
$details = $row['title'];
$texts = $row['text'];
printf("<B>%s</B><br /><textarea name=text COLS=80 ROWS=20>%s<textarea/>", $details, $texts);
}
mysql_free_result($result);
}
else
echo "Inga poster hittades.<br /><br />";
}
?>
Title: <input type="text" name="title"><br>
Date: <input type="text" name="date"><br>
text: <input type="text" name="text"><br>
<input type="Submit">
</form>
<?
$username="root";
$password="die!win";
$database="texter";
$title=$_POST['title'];
$date=$_POST['date'];
$text=$_POST['text'];
mysql_connect($localhost,$root,$diewin);
@mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO details VALUES ('','$title','$date')";
$query = "INSERT INTO details VALUES ('','$text')";
mysql_query($query);
mysql_close();
?>
</html>
----------------------------------------------------------------------------------------------------------------
My database structure:
create database texter;
create table details (textid int not null primary key auto_increment,title varchar(255),date date);
create table texts (textid int not null,text longtext);