displaying data from database

toney · March 7, 2012

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

<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>

Choose Male or Female: </td>

Male

Female </td>

</tr>

<tr>

<td>

Choose age range:

</td>

<td>

</select>

</select>

</td>

</tr>

<tr>

<td>

</td>

<td>

</td>

</tr>

<tr>

<td>

</td>

<td>

</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

Psycho · March 7, 2012

Hmm, that's a pretty rough implementation on working with queries. But, the crux of your problem is that variables cannot have dashes in the name

Psycho · March 7, 2012

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 · March 7, 2012

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 · March 7, 2012

<?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

smerny · March 7, 2012

27:

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

Pikachu2000 · March 7, 2012

Look at it again. Do you notice something missing on that line? Maybe at the very beginning of it?

Genesis730 · March 7, 2012

also the line before (line 26) has a ( and needs a {

toney · March 7, 2012

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 · March 7, 2012

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();

?>

smerny · March 7, 2012

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

look at that line

mikosiko · March 7, 2012

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 · March 7, 2012

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.

toney · March 7, 2012

Dreamweaver is what I am using

Sign In

displaying data from database

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information