how to retreive specific values from database to display on webpage

learner0001 · September 8, 2014

i have a register and login page where the users can perform register and login task and their detail gets saved in the database. my requirement is that when the user enters his/her account, they should be redirected to their profile page, where they can view all their profile details. Till now i have been able to make the user login and dislay a part of their profile page, for this purpose the code that i am using is

<code>

<?php

include('retailer_session.php');

?>

<!DOCTYPE>

<html>

<head>

<title>Welcome to your homepage</title>

</head>

<body>

<a href="#" class = "navbar-brand"> <id="welcome">Welcome : <i><?php echo $login_session; ?></i> </a>

</button>

</ul>

</div>

</body>

</html>

Apart from this i want a listing where the user can view their data and edit their details as it is done on many websites. can anyone please help me with the code

</code>

Richard_Grant · September 8, 2014

<?php

$conn = mysql_connect("localhost", "mysql_user", "mysql_password");

if (!$conn) {
    echo "Unable to connect to DB: " . mysql_error();
    exit;
}

if (!mysql_select_db("mydbname")) {
    echo "Unable to select mydbname: " . mysql_error();
    exit;
}

$sql = "SELECT id as userid, fullname, userstatus
        FROM   sometable
        WHERE  userstatus = 1";

$result = mysql_query($sql);

if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}

// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
//       then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
    echo $row["userid"];
    echo $row["fullname"];
    echo $row["userstatus"];
}

mysql_free_result($result);

?>

Get the Values you need by running the php above, then store them in a session. and then change your .html file to a .php filetype.

and then you can put <?PHP echo $_SESSION['value']; ?> where ever you want.

Edited September 8, 2014 by Richard_Grant

cyberRobot · September 8, 2014

Get the Values you need by running the php above...

Just be aware that mysql_* functions have been deprecated. If you're not doing so already, you'll need to switch to PDO or MySQLi at some point. More information can be found here:

http://php.net/manual/en/mysqlinfo.api.choosing.php

Richard_Grant · September 8, 2014

Just be aware that mysql_* functions have been deprecated. If you're not doing so already, you'll need to switch to PDO or MySQLi at some point. More information can be found here:

http://php.net/manual/en/mysqlinfo.api.choosing.php

I agree, i use prepared statements in mysqli, mysql is depreciated. Good point out.

Sign In

how to retreive specific values from database to display on webpage

Recommended Posts

learner0001

Link to comment

Share on other sites

Richard_Grant

Link to comment

Share on other sites

cyberRobot

Link to comment

Share on other sites

Richard_Grant

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information