[RESOLVED] get user details from mysql database using php?

ckerr27

Hi, I have created a form (code below) to show details about members of my website. When the user enters the username of a certain member the form should retrieve these details from my database(phpmyadmin) and display them. I cant get this to work. It simply returns an empthy page??

Here is the code for my form:

<form name="form1" method="post" action="getdetails.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong><center>Personal Details</center> </strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input name="Submit" type="text" id="username"></td>
</tr>
<tr>

<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="username" value="Get Details"></td>
</tr>
</table>
</td>
</form>

This is my getdetail.php file

<?php
mysql_connect ("localhost","root","");
mysql_select_db ("test");

if (isset($_POST['Submit'])){
$username=mysql_real_escape_string(trim($_POST['username']));   

$sql = "select * from memberdetails WHERE username='$username'";
       $result = mysql_query ($sql);

   while ($row = mysql_fetch_array($result))
                     {
          $username= $row["username"];
          $firstname= $row["firstname"];
          $surname= $row["surname"];
          $dob= $row["dob"];
          $totalwins= $row["totalwins"];   
          $totalloses= $row["totalloses"];
          $email= $row["email"];
          $country= $row["country"];

		  print_r($_POST);

echo "<b><u>Username:</b></u>  $username<br>";
	echo "<b><u>Firstname:</b></u> $firstname<br>";
	echo "<b><u>Surname: </b> </u> $surname<br>";
	echo "<b><u>Date of Birth:</b></u> $dob<br>";
	echo "<b><u>Total Chess Wins:</b></u>  $totalwins<br>";	
	echo "<b><u>Total Chess loses:</b></u> $totalloses<br>";
	echo "<b><u>Email Address: </b></u> $email<br>";
	echo "<b><u>Born in: </b></u> $country<br>";
	echo "<b><u>Other Details:</b></u>  $info<br>";
          }}
?>

bradgrafelman

EDIT: Welcome to PHPBuilder! When posting HTML or PHP code, please use the board's [noparse]

..

..

[/noparse] bbcode tags (respectively) as they make your code much easier to read and analyze.

Your getdetails.php script is checking for the existence of an element named 'Submit' in the POST'ed data, but your form has no such element.

Bonesnap

bradgrafelman;11000703 wrote:
Your getdetails.php script is checking for the existence of an element named 'Submit' in the POST'ed data, but your form has no such element.

It does except it's a text field and not the submit button.

@: Switch the values of the name attribute of these two elements

<input name="Submit" type="text" id="username">

<input type="submit" name="username" value="Get Details">

ckerr27

@Bonesmap

do you mean as follows:

It is giving an error on the follwing line in getdetails.php

$username=mysql_real_escape_string(trim($_POST['username']));

Undefined index: username

traq

no...

Your PHP script is checking "Submit" to see if the form is submitted, and is using "username" as the value to search the DB for. HOWEVER, that's not how you assigned the names:

<input name="Submit" type="text" id="username">
<!-- ... -->
<input type="submit" name="username" value="Get Details">

the value of "username" will always be "Get Details" - and you probably don't have a user with that username, so your query returns nothing. Bonesnap is suggesting that you probably mixed up the names for your form fields, and that you should probably change them so the submit button is named "Submit" and the username field is named "username":

<input name="[b]username[/b]" type="text" id="username">
<!-- ... -->
<input type="submit" name="[b]Submit[/b]" value="Get Details">

php_rockzz

u have used the following code to get the submitted username:

$username=mysql_real_escape_string(trim($_POST['username']));   

$sql = "select * from memberdetails WHERE username='$username'";

Here, i want u to note that u r fetching the value of the input type which has name='username', as the post method fetches values by name.
And u have assigned ur submit button with the name='username'.
that is the reason why u r not getting any values in the variable $username.
I would suggest u two methods.
One being, as Bonesnap suggested, switch the values of name attribute.
Or, you change ur php code and use:

$username=mysql_real_escape_string(trim($_POST['Submit']));   

$sql = "select * from memberdetails WHERE username='$username'";

Also, it would b a lot easier for u to understand and write codes if u keep ur name and id attributes the same for each field.

ckerr27

That code works perfectly. Thanks for all your help everyone!!😃