Anyone can help? (Need to finish this asap)

Question

Tonkz 0 Light Poster

14 Years Ago

Im getting this error:
Parse error: syntax error, unexpected $end in /hsphere/local/home/blah/blahblah.com/home/phonenumber.php on line 188. Problem is line 188 is </html> only. Also, I'm having problem making this code to work, it doesnt display the tables that I want

<?php
$selection = $_POST['person'];
$conn = mysql_connect("mrrrr.com","yyyyy","yyfffsd");


mysql_select_db("hhhh_ggg", $conn);

// For Students
if ($selection == 'student') {

$sql="SELECT student.first_name AS first,
             student.last_name AS last,
             student.phone AS phonenum
      FROM student
      ORDER BY last, first;";

$result = mysql_query($sql, $conn)
          or die(mysql_error());

echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">';
echo '<html xmlns="http://www.w3.org/1999/xhtml">';
echo '<head>';
echo '<title>Student Phone Book</title>';
echo '</head>';
echo '<body>';
echo '<h2>Student Phone Book</h2>';
echo '<table width="100%" border="2">';
   echo '<tr>';
      echo '<th>First Name</th>';
      echo '<th>Last Name</th>';
      echo '<th>Phone</th>';
   echo '</tr>';

   while ($row = mysql_fetch_array($result)) {
      echo "<tr>";
         echo "<td>";
         echo  $row["first"];
         echo "</td>";
         echo "<td>";
         echo  $row["last"];
         echo "</td>";
         echo "<td>";
         echo  $row["phonenum"];
         echo "</td>";
      echo "</tr>";

   }
echo '</table>';
mysql_close($conn);

//faculty
if ($selection == 'faculty') {

$sql="SELECT faculty.first_name AS first,
             faculty.last_name AS last,
             faculty.phone AS phonenum
      FROM faculty
      ORDER BY last, first;";

$result = mysql_query($sql, $conn)
          or die(mysql_error());

echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">';
echo '<html xmlns="http://www.w3.org/1999/xhtml">';
echo '<head>';
echo '<title>Faculty Phone Book</title>';
echo '</head>';
echo '<body>';
echo '<h2>Faculty Phone Numbers</h2>';
echo '<table width="100%" border="2">';
   echo '<tr>';
      echo '<th>First Name</th>';
      echo '<th>Last Name</th>';
      echo '<th>Phone</th>';
   echo '</tr>';

   while ($row = mysql_fetch_array($result)) {
      echo "<tr>";
         echo "<td>";
         echo  $row["first"];
         echo "</td>";
         echo "<td>";
         echo  $row["last"];
         echo "</td>";
         echo "<td>";
         echo  $row["phonenum"];
         echo "</td>";
      echo "</tr>";

   }
echo '</table>';
mysql_close($conn);

//department

if ($selection == 'department') {

$sql="SELECT department.first_name AS first,
             department.last_name AS last,
             department.phone AS phonenum
      FROM department
      ORDER BY last, first;";

$result = mysql_query($sql, $conn)
          or die(mysql_error());

echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">';
echo '<html xmlns="http://www.w3.org/1999/xhtml">';
echo '<head>';
echo '<title>Student Phone Book</title>';
echo '</head>';
echo '<body>';
echo '<h2>Department Phone Numbers</h2>';
echo '<table width="100%" border="2">';
   echo '<tr>';
      echo '<th>First Name</th>';
      echo '<th>Last Name</th>';
      echo '<th>Phone</th>';
   echo '</tr>';

   while ($row = mysql_fetch_array($result)) {
      echo "<tr>";
         echo "<td>";
         echo  $row["first"];
         echo "</td>";
         echo "<td>";
         echo  $row["last"];
         echo "</td>";
         echo "<td>";
         echo  $row["phonenum"];
         echo "</td>";
      echo "</tr>";

   }
echo '</table>';
mysql_close($conn);

//student

if ($selection == 'studentid') {

$sql="SELECT student.first_name AS first,
             student.last_name AS last,
             student.phone AS phonenum
      FROM student
      ORDER BY last, first;";

$result = mysql_query($sql, $conn)
          or die(mysql_error());

echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">';
echo '<html xmlns="http://www.w3.org/1999/xhtml">';
echo '<head>';
echo '<title>Student Phone Book</title>';
echo '</head>';
echo '<body>';
echo '<h2>Student Phone Book</h2>';
echo '<table width="100%" border="2">';
   echo '<tr>';
      echo '<th>First Name</th>';
      echo '<th>Last Name</th>';
      echo '<th>Phone</th>';
   echo '</tr>';

   while ($row = mysql_fetch_array($result)) {
      echo "<tr>";
         echo "<td>";
         echo  $row["first"];
         echo "</td>";
         echo "<td>";
         echo  $row["last"];
         echo "</td>";
         echo "<td>";
         echo  $row["phonenum"];
         echo "</td>";
      echo "</tr>";
   }
echo '</table>';
mysql_close($conn);
}
?>
<a href="test2.htm">Back to previous page</a>
</body>
</html>

php

2 Contributors
8 Replies
106 Views
6 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by Tonkz

All 8 Replies

nav33n 472 Purple hazed!

14 Years Ago

I have a suggestion for you. Never post your username and password in a forum. :) You can still edit your post and replace username and password with null or * or whatever.
And also, fix your [code] tags .

nav33n 472 Purple hazed!

14 Years Ago

And, the solution for your problem is, none of your code blocks are closed. if($selection == 'student') { is opened, but you have forgotten to close it after mysql_close($conn);

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Tonkz 0 Light Poster · Answer 1 · 2009-04-23T01:04:00+00:00

Tonkz 0 Light Poster

14 Years Ago

Thanks, sorry about that all fixed up

Tonkz 0 Light Poster · Answer 2 · 2009-04-23T01:08:48+00:00

Tonkz 0 Light Poster

14 Years Ago

Oh gosh I just forgot to end it, thank you.

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 3 · 2009-04-23T01:10:26+00:00

nav33n 472 Purple hazed!

14 Years Ago

:) n/p ! Good luck.

Tonkz 0 Light Poster · Answer 4 · 2009-04-23T01:31:43+00:00

how will you do this, if you click on th radio button and press submit it will also get the input value in text form and find it in the database
Note: same php code in my first post Line 143-184

<input type="radio" name="person" value="id" />A student. Type Student ID here: 
<input type="text"  name="studentid" value="" size="10" maxlength="8">

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 5 · 2009-04-23T01:42:04+00:00

When you click submit, all the form elements (radio, checkbox, select, textbox, etc) inside a form will be submitted to the script mentioned in the action of the form (if no action is specified, it will submit to the same script).

<?php
if(isset($_POST['submit'])) {
   print "<pre>";
   print_r($_POST);
   print "</pre>";
}
<html>
<body>
<form method='post'>
<input type='radio' name='person' value='1' /> Person 1 <br />
<input type='radio' name='person' value='2' /> Person 2 <br />
Name: <input type='text' name='name' /> <br />
<input type='submit' name='submit' value='submit' />
</form>
</body>
</html>

In the above example, you will see all the posted form elements. Do whatever you want with it! I don't understand what you mean by "find it in the database". If you want to search a table, then use it in the query.

$value = $_POST['textboxname'];
$query = "select * from table where user = '$value'";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0 ) {
echo "Found!";
} else {
 echo "Not found!";
}

something like that ?

P.S. Its 1 am and I am going to hit the sack. Cheers!

Tonkz 0 Light Poster · Answer 6 · 2009-04-23T01:44:42+00:00

Tonkz 0 Light Poster

14 Years Ago

ok good night and thank you

Anyone can help? (Need to finish this asap)

Recommended Answers Collapse Answers

All 8 Replies

Recommended Answers