displaying mysql database fields

Question

I have a from which is linked to a PHP script. When the user enters their username I want to to display fields regarding to their record. Specifically 'DOB' and 'email'.

The problem is, when i enter the username it opens test.php but does not show up any records.

My form is:

<form id="form1" name="form1" method="post" action="test.php">
  <label>Name
  <input type="text" name="textfield" />
  </label>
  <p>
    <label>
    <input type="submit" name="Submit" value="Submit" />
    </label>

  </p>
</form>

My PHP script is:

  <?php 

    $host=""; // Host name 
    $username=""; // Mysql username 
    $password=""; // Mysql password 
    $db_name=""; // Database name 
    $tbl_name="members"; // Table name  

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

     $username = $_POST['textfield'];
      echo '</br>';
     $query = mysql_query("SELECT * FROM `members` WHERE `username`='$username'");

    while($result = mysql_fetch_array($query)) {
    //display
    echo $result['DOB'];
    echo $result['email'];
    }
    ?>

Please use PDO or MySQLi to connect to your databases. Wouldn't want any nasty hackers injecting through vulnerabilities now would we? — Casey Dwayne
– Casey Dwayne, Commented Apr 29, 2013 at 23:46
not sure how to do that. They can have access to it if they so wish. — Luke Ham
– Luke Ham, Commented Apr 29, 2013 at 23:50
You are setting $tbl_name="members"; // Table name but querying FROM `orders`. Also have you tried running the query directly in MySQL/phpMyAdmin? — Sean
– Sean, Commented Apr 29, 2013 at 23:51

Ken Richards · Accepted Answer · 2013-04-29 23:44:56Z

2

You should connect to a database before you run any queries:

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

answered Apr 29, 2013 at 23:44

Ken Richards

3,0512 gold badges22 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Luke Ham Over a year ago

thanks I have just revised my answer but still not calling up the results

bestprogrammerintheworld · Accepted Answer · 2013-04-29 23:46:09Z

0

Instead of

$query = mysql_query("SELECT * FROM `orders` WHERE `username`='$username'");

do this:

$sql = "SELECT * FROM `orders` WHERE `username`='$username'";
$query = mysql_query($sql) or die(mysql_error());
echo 'SQL=' . $sql;

What result do you get? (What is SQL?)

answered Apr 29, 2013 at 23:46

bestprogrammerintheworld

5,5299 gold badges48 silver badges76 bronze badges

Collectives™ on Stack Overflow

displaying mysql database fields

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related