Jump to content

displaying data from database

toney

By toney
in PHP Coding Help

Recommended Posts

toney Member

toney

Posted
Posted

I am trying to display data from a database from a form entry

 

here is the php

 

<?php

include('dbconnect.php');

 

@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM child_info";

$result=mysql_query($query);

 

$num=mysql_numrows($result);

 

mysql_close();

 

echo "<b><center>Database Output</center></b><br><br>";

 

$i=0;

while ($i < $num) {

 

$field1-name=mysql_result($result,$i,"file_number");

$field2-name=mysql_result($result,$i,"first_name");

$field3-name=mysql_result($result,$i,"middle_name");

$field4-name=mysql_result($result,$i,"last_name");

$field5-name=mysql_result($result,$i,"birthdate");

$field6-name=mysql_result($result,$i,"gender");

$field7-name=mysql_result($result,$i,"features");

$field8-name=mysql_result($result,$i,"diagnosis");

$field9-name=mysql_result($result,$i,"description");

echo "<b>$field1-name

$field2-name2</b><br>$field3-name<br>$field4-name<br>$field5-name<hr><br>";

 

$i++;

}

 

?>

 

here is the form I am using

 

<form name="child_info" action="selectdata.php" method="post"  id="child_info">

                <table width="444" align="center" >

      <tr>

                                    <td>

                                    Search by Name:

                                    </td>

                                    <td>

                                    First Name:<input type="text" class="form-textbox " id="first_name" name="first_name" size="20" /><br />

                                        Last Name:<input type="text" class="form-textbox " id="last_name" name="last_name" size="20" />

                                    </td>

                                </tr>

                            <tr>

                                <td width="208">

                                    Choose Male or Female:                                    </td>

                                <td width="224">

                                <input type="radio" name="gender" value="male" />

              Male

              <input type="radio" name="gender" value="Female" />

              Female                                  </td>

                            </tr>

                            <tr>

                            <td>

                                Choose age range:                               

                                </td>

                                <td>

                                  <select name="first_age" id="first_age">

                                  <option value="00">From</option>

                                  <option value="1">1</option>

                                  <option value="2">2</option>

                                  <option value="3">3</option>

                                  <option value="4">4</option>

                                  <option value="5">5</option>

                                  <option value="6">6</option>

                                  <option value="7">7</option>

                                  <option value="8">8</option>

                                  <option value="9">9</option>

                                  <option value="10">10</option>

                                  <option value="11">11</option>

                                  <option value="12">12</option>

                                  <option value="13">13</option>

                                  <option value="14">14</option>

                                  <option value="15">15</option>

                                  <option value="16">16</option>

                                  <option value="17">17</option>

                                  <option value="18">18</option>

                                </select>

                                <select name="second_age" id="second_age">

                                  <option value="00">To</option>

                                  <option value="1">1</option>

                                  <option value="2">2</option>

                                  <option value="3">3</option>

                                  <option value="4">4</option>

                                  <option value="5">5</option>

                                  <option value="6">6</option>

                                  <option value="7">7</option>

                                  <option value="8">8</option>

                                  <option value="9">9</option>

                                  <option value="10">10</option>

                                  <option value="11">11</option>

                                  <option value="12">12</option>

                                  <option value="13">13</option>

                                  <option value="14">14</option>

                                  <option value="15">15</option>

                                  <option value="16">16</option>

                                  <option value="17">17</option>

                                  <option value="18">18</option>

                                </select>

                              </td>

                            </tr>

                            <tr>

                            <td>

                                </td>

                                <td>

                                </td>

                            </tr>

                            <tr>

                            <td>

                                </td>

                                <td>

                                <div align="right">

                                  <input type="submit" name="submit" id="submit" value="submit" />

                                  <input type="reset" name="reset" id="reset" value="reset" />

                                  </div></td>

                            </tr>

                    </table>

                    </form>

 

first problem is getting the form to use the php

 

second problem is when i try to use the php alone is I get this error

 

Parse error: syntax error, unexpected '=' in /home/fathersh/public_html/selectdata.php on line 17  17 is highlighted above in the php

Link to comment
https://forums.phpfreaks.com/topic/258476-displaying-data-from-database/
Share on other sites
Psycho Prolific Member

Psycho

Posted
Posted 
include('dbconnect.php');

@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT file_number, first_name, middle_name, last_name, birthdate
          FROM child_info";
$result = mysql_query($query);
mysql_close();

if(!$result)
{
    echo "There was a problem getting the data";
}
elseif(!$result)
{
    echo "There were no results";
}
else
(
    echo "<b><center>Database Output</center></b><br><br>\n";
    while($row = mysql_fetch_assoc($result))
    {
        echo "<b>{$row['file_number']}-name{$row['first_name']}-name2</b><br>\n";
        echo "{$row['middle_name']}-name<br>\n";
        echo "{$row['last_name']}-name<br>\n";
        echo "{$row['birthdate']}-name<hr><br>\n";

    }
}

Psycho Prolific Member

Psycho

Posted
Posted

Cleaned up form

<?php
$max_age = 18;

$ageOptions = "<option value='00'>From</option>\n";
for($age=1; $age<=$max_age; $age++)
{
    $ageOptions .= "<option value='{$age}'>{$age}</option>\n";
}

?>

<form name="child_info" action="selectdata.php" method="post"  id="child_info">
<table width="444" align="center" >
    <tr>
        <td>Search by Name:</td>
        <td>
            First Name:<input type="text" class="form-textbox " id="first_name" name="first_name" size="20" /><br />
            Last Name:<input type="text" class="form-textbox " id="last_name" name="last_name" size="20" />
        </td>
    </tr>
    <tr>
        <td width="208">Choose Male or Female:</td>
        <td width="224">
            <input type="radio" name="gender" value="male" /> Male
            <input type="radio" name="gender" value="Female" /> Female
        </td>
    </tr>
    <tr>
        <td>Choose age range:</td>
        <td>
            <select name="first_age" id="first_age">
            <?php echo $ageOptions; ?>
            </select>
            <select name="second_age" id="second_age">
            <?php echo $ageOptions; ?>
            </select>
        </td>
    </tr>
    <tr>
        <td></td>
        <td>
            <div align="right">
            <input type="submit" name="submit" id="submit" value="submit" />
            <input type="reset" name="reset" id="reset" value="reset" />
            </div>
        </td>
    </tr>
</table>
</form>

toney Member

toney

Posted
  • Author
Posted

<?php

$con = mysql_connect("localhost","fathersh_search","blanked out");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

mysql_select_db("fathersh_childsearch", $con);

@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT file_number, first_name, middle_name, last_name, birthdate

          FROM child_info";

 

$result = mysql_query($query);

 

mysql_close();

 

if(!$result)

{

  echo "There was a problem getting the data";

}

elseif(!$result)

{

echo "There were no results";

}

else

(

    "<b><center>Database Output</center></b><br><br>\n";

    while($row = mysql_fetch_assoc($result))

    {

echo "<b>{$row['file_number']}-name{$row['first_name']}-name2</b><br>\n";

echo "{$row['middle_name']}-name<br>\n";

echo "{$row['last_name']}-name<br>\n";

echo "{$row['birthdate']}-name<hr><br>\n";

 

}

}

?>

 

this is the new code but now giving me new error :

 

Parse error: syntax error, unexpected ';' in /home/fathersh/public_html/selectdata.php on line 27 in bold

toney Member

toney

Posted
  • Author
Posted

ok i fixed the parse error  there was a ) instead of a }      but now it says I cant select the database I know the database details are correct

<?php

$con = mysql_connect("localhost","fathersh_search","");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

mysql_select_db("fathersh_childsearch", $con);

@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT file_number, first_name, middle_name, last_name, birthdate

          FROM child_info";

 

$result = mysql_query($query);

 

 

if(!$result)

{

  echo "There was a problem getting the data";

}

else if(!$result)

{

echo "There were no results";

}

else

{

    echo "<b><center>Database Output</center></b><br><br>\n";"<b><center>Database Output</center></b><br><br>\n";

    while($row = mysql_fetch_assoc($result))

    {

echo "<b>{$row['file_number']}-name{$row['first_name']}-name2</b><br>\n";

echo "{$row['middle_name']}-name<br>\n";

echo "{$row['last_name']}-name<br>\n";

echo "{$row['birthdate']}-name<hr><br>\n";

 

}

}

mysql_close();

?>

toney Member

toney

Posted
  • Author
Posted

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/fathersh/public_html/selectdata.php on line 29 in bold

 

<?php

$con = mysql_connect("localhost","fathersh_search","f33321rh");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

mysql_select_db("fathersh_childsearch", $con);

@mysql_select_db($database) 'or die ("Unable to select database: " . mysql_error())"

$query = "SELECT file_number, first_name, middle_name, last_name, birthdate

          FROM child_info";

 

$result = mysql_query($query);

 

 

if(!$result)

{

  echo "There was a problem getting the data";

}

else if(!$result)

{

echo "There were no results";

}

else

{

    echo "<b><center>Database Output</center></b><br><br>\n";"<b><center>Database Output</center></b><br><br>\n";

    while($row = mysql_fetch_assoc($result))

    {

echo "<b>{$row['file_number']}-name{$row['first_name']}-name2</b><br>\n";

echo "{$row['middle_name']}-name<br>\n";

echo "{$row['last_name']}-name<br>\n";

echo "{$row['birthdate']}-name<hr><br>\n";

 

}

}

mysql_close();

?>

mikosiko Newbie

mikosiko

Posted
Posted

this are 2 lines in your posted code:

 

mysql_select_db("fathersh_childsearch", $con);
@mysql_select_db($database) 'or die ("Unable to select database: " . mysql_error())"

 

seems ok to you?  ... mysql_select_db() twice? and the second with more than evident errors?

smerny Advanced Member

smerny

Posted
Posted

this are 2 lines in your posted code:

 

mysql_select_db("fathersh_childsearch", $con);
@mysql_select_db($database) 'or die ("Unable to select database: " . mysql_error())"

 

seems ok to you?  ... mysql_select_db() twice? and the second with more than evident errors?

 

toney what are you using to edit your php? even a simple editor that color codes would give you a better idea of where you are messing up quotes.

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.