Apache Friends Support Forum

Notice: Use of undefined constant localhost - assumed 'localhost' in C:\xampp\htdocs\hofiles\tenantnumbers.php on line 2

Notice: Use of undefined constant root - assumed 'root' in C:\xampp\htdocs\hofiles\tenantnumbers.php on line 2

Notice: Use of undefined constant prerentdb - assumed 'prerentdb' in C:\xampp\htdocs\hofiles\tenantnumbers.php on line 3

Code: Select all

<?php
mysql_connect(localhost,root,"");
mysql_select_db(prerentdb) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
 $apt = $_POST['apt'];
 $query="SELECT * FROM payments Where apt='$apt'";
$result=mysql_query($query);
if(mysql_num_rows($result))
{
  echo "<form action='#' method='post'><b>Tenant Phone #s<br><br>";
  echo"<table border='0'>
<tr>
<th>Apt</th>
<th>Tenant</th>
<th>Phone#</th>
<th>Emergency#</th>
<th>Cell#</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['apt'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['phone'] . "</td>";
echo "<td>" . $row['ephone'] . "</td>";
echo "<td>" . $row['cell'] . "</td>";
echo "</tr>";
}
echo "</table>";
echo "</form>";
}
else{echo "no entry for apt $apt ...Select Another?";}
}
?>
<form method="post" action="#">
 <br />
 <input type="text" name="apt"/> <p>
<input type="submit" name="submit" value="selected apartment"/>
</form>

Code: Select all

[...]
mysql_connect('localhost','root','');
mysql_select_db('prerentdb') or die( "Unable to select database");
[...]