SESSION error...showing undefined index pls help
Posted: Tue Nov 15, 2011 1:11 am
My first php is....searchbook.php
(getting variable 'k' frm txtbox)
<?php
$k = $_GET['k'];
$terms = explode(" ", $k);
$query = "SELECT * FROM bookup WHERE";
$i = 0;
foreach ($terms as $each)
{
$i++;
if($i == 1)
$query .= " keywords LIKE '%$each%'";
else
$query .= " OR keywords LIKE '%$each%'";
}
mysql_connect("localhost","root","12345") or die("db prob");
mysql_select_db("games") or die("db prob test");
$query = mysql_query($query);
$numrows = mysql_num_rows($query);
if($numrows > 0)
{
while ($row = mysql_fetch_assoc($query))
{
$title = $row['gamename'];
$description = $row['gamedes'];
$keywords = $row['keywords'];
}
echo $title,$description;
$_SESSION['title'] = $title;
echo '<form method="GET" action="msearchbookh.php"><input type="submit" value="Have It!"></form><form method="GET" action="msearchbookw.php"><input type="submit" value="Want It!"></form>';
}
else
{
echo "No result FOund ";
}
?>
My second php is.... msearchbookh.php
<?php
$test = $_SESSION['title'];
$con = mysql_connect("localhost","root","abraham");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
mysql_query("UPDATE users SET haves = '$test'
WHERE name = '$sesname'");
echo "$test added to haves of $sesname";
?>
in this i hav undefined index in nxt php....pls help
Thanks in advance
(getting variable 'k' frm txtbox)
<?php
$k = $_GET['k'];
$terms = explode(" ", $k);
$query = "SELECT * FROM bookup WHERE";
$i = 0;
foreach ($terms as $each)
{
$i++;
if($i == 1)
$query .= " keywords LIKE '%$each%'";
else
$query .= " OR keywords LIKE '%$each%'";
}
mysql_connect("localhost","root","12345") or die("db prob");
mysql_select_db("games") or die("db prob test");
$query = mysql_query($query);
$numrows = mysql_num_rows($query);
if($numrows > 0)
{
while ($row = mysql_fetch_assoc($query))
{
$title = $row['gamename'];
$description = $row['gamedes'];
$keywords = $row['keywords'];
}
echo $title,$description;
$_SESSION['title'] = $title;
echo '<form method="GET" action="msearchbookh.php"><input type="submit" value="Have It!"></form><form method="GET" action="msearchbookw.php"><input type="submit" value="Want It!"></form>';
}
else
{
echo "No result FOund ";
}
?>
My second php is.... msearchbookh.php
<?php
$test = $_SESSION['title'];
$con = mysql_connect("localhost","root","abraham");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
mysql_query("UPDATE users SET haves = '$test'
WHERE name = '$sesname'");
echo "$test added to haves of $sesname";
?>
in this i hav undefined index in nxt php....pls help
Thanks in advance