it wont connect to the database :(

alexander_s

Its the insert form that doesnt work, it wont connect to the mysql database 🙁

Whats wrong guys?
EDIT:
iv put the insert code in both index.php and insert.php just to see if it mattered.(it didnt)

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 />";
}
?>
<form action=insert.php method=post>
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>

$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);

statusquo

Why did you make a function to connect to the database and select the database for something that simple? Was it an assignment to make a function? I am not trying to be ignorant... I'm just curious. The connection and table selection could be made with fewer lines without using a function.

I just use something like :

//connect to MySQL
$connect = mysql_connect("localhost","username","password") or die("Can't connect to MySQL ".mysql_error());

//select the database
mysql_select_db ("movie_database");

//selection from the movie table
$query = "SELECT movie_name, movie_type FROM movie WHERE movie_year > 1990 ORDER BY movie_type";
$results = mysql_query($query,$connect) or die("Could not query the movie table ".mysql_error());

I've never had problems with this. I could also paste the above code into a file and just include that file whenever I want to make a connection to that database.

Hope this helps.

alexander_s

hehe the problems keep on coming, i aint getting any errors now tho it just doesnt happen anything

<?

//Connect to MySQL
$connect = mysql_connect("localhost","root","diewin") or die("Can't connect to MySQL ".mysql_error());

//select the database
mysql_select_db ("texter");
?>


<?


$title=$_POST['title'];
$date=$_POST['date'];
$text=$_POST['text'];


$query_details = "INSERT INTO details (title, date) VALUES ('$title', '$date')";
$last_id=mysql_insert_id();
$query_texts = "INSERT INTO texts (text) VALUES ('$text')";
mysql_query($query_details);
mysql_query($query_texts);
mysql_close();
?>

alexander_s

LOL im getting annoying here...
but i think its just the search form thats malfunctioning now.

cuse i can see my insertions from the mysql prompt but not threw the website

<?php

function texter()
{
  global $conn;
  $conn = mysql_connect("localhost", "root", "diewin") or die(mysql_error());
  mysql_select_db("texter",$conn) or die(mysql_error());
}
?>
<B>Insert & Search</B>
<body bgcolor="beige">
<br />
<br />

<form action="insert.php" method="POST">
Title: <input type="text" name="title"><br>
Date: <input type="text" name="date"><br>
Text: <input type="text" name="text"><br>
<input type="Submit" value="Insert!">
</form>
<br />
<br />



<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 />";
}
?>

</html>

alexander_s

im beginning to consider my self a joke..

but the search form doesnt work cus
my insert form will only adress the first textid column in the insert into details query...
and not the textid in the insert into texts query.

How do make it insert both textid?

cus if i get that right it will work 🙂

thanks!