problems displaying data

p2ptolu · May 11th, 2005, 09:21 AM

I am new in php help out please: my setup is below :

win XP pro
Apache 2.0.54
PHP 4.3.4
Mysql 3.23.49
PhpMyAdmin 2.6.2

i used the code in my php after creating my databse in PhpMyAdmin 2.6.2 but i got this error message:
(Notice: Undefined variable: metode in C:\DocRoot\updc\results.php on line 34

Notice: Undefined variable: search in C:\DocRoot\updc\results.php on line 34

Notice: Undefined variable: variable1 in C:\DocRoot\updc\results.php on line 51
No Record Found, to search again please close this window
)

Please help me out,

CODES IN PHP

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<center>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="60"><b>id</b></td>
<td width="100"><b>name</b></td>
<td width="70"><b>telephone</b></td>
<td width="150"><b>birthday</b></td>
</tr>
<tr>
<td>

<?

$hostname = "localhost"; // The Thinkhost DB server.
$username = "root"; // The username you created for this database.
$password = "unitysch"; // The password you created for the username.
$usertable = "details"; // The name of the table you made.
$dbName = "lopez"; // This is the name of the database you made.

MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection unavailable");
@mysql_select_db( "$dbName") or die( "Unable to select database");
?>
<?
//error message (not found message)begins
$XX = "No Record Found, to search again please close this window";
//query details table begins
$query = mysql_query("SELECT * FROM details WHERE $metode LIKE '%$search%' LIMIT 0, 50");
while ($row = @mysql_fetch_array($query))
{
$variable1=$row["id"];
$variable2=$row["name"];
$variable3=$row["telephone"];
$variable4=$row["birthday"];
//table layout for results

print ("<tr>");
print ("<td>$variable1</td>");
print ("<td>$variable2</td>");
print ("<td>$variable3</td>");
print ("<td>$variable4</td>");
print ("</tr>");
}
//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
}
//end
?>
</table>
</center>
</body>
</html>

Mantis · May 11th, 2005, 11:31 AM

1st look:

MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection unavailable");
@mysql_select_db( "$dbName") or die( "Unable to select database");
?>
<?//error message (not found message)begins

Remove
?>
<?

I'm also not so square about my coding, so I would have wrote this:
$query = mysql_query("SELECT * FROM details WHERE $metode LIKE '%$search%' LIMIT 0, 50");
while ($row = @mysql_fetch_array($query))
{
$variable1=$row["id"];
$variable2=$row["name"];
$variable3=$row["telephone"];
$variable4=$row["birthday"];
//table layout for results

print ("<tr>");
print ("<td>$variable1</td>");
print ("<td>$variable2</td>");
print ("<td>$variable3</td>");
print ("<td>$variable4</td>");
print ("</tr>");
}

like this:

$query = mysql_query("SELECT * FROM details WHERE $metode LIKE '%$search%' LIMIT 0, 50");
while ($row = @mysql_fetch_array($query))
{
extract($row);
?>
<tr>
<td><?php echo $id; ?></td>
<td><?php echo $name; ?></td>
<td><?php echo $telephone; ?></td>
<td><?php echo $birthday; ?></td></tr></table>
<?php } ?>

webphp · May 12th, 2005, 01:12 AM

hi
you should defined your variable $metode &search in
your program
OR
if you send these variable from another page to this page
you should submit your variable and use this code in your program:

$metode=&_POST['$metode'];
$search=$_POST['$searrch'];