web Development, PHP display variable from SQL as something else

Question

Ok So i have an PHP page and i have a database. In my database i have a table with a Field one of the fields is called accounttype it is enum('n', 'm', 's') I am trying to display on my PHP page if the user is N it should say Normal User if the user is E Expert user or S Super user...

How do i go about doing this?

Top of PHP Page

<?php
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE id='$id' LIMIT 1");
while($row = mysql_fetch_array($sql)){
    $phone = $row["phone"];
    $country = $row["country"];
    $state = $row["state"];
    $city = $row["city"];
    $accounttype = $row["accounttype"];
    $bio = $row["bio"];
}    
?>

Where i am trying to display on the page This is the code. Right now it just puts a blank space.

<span class="admin">Edward</span>
<span class="date">March 19, 2048</span>
<span class="tag"><?php echo "$accounttype"; ?></span>
<span class="comment"><a href="#">166 comments</a></span>

picture https://i.sstatic.net/KXu9A.png

This is not the cause of the issue, but the quotes around the $accounttype variable are unnecessary! — Ben Carey
– Ben Carey, Commented Dec 13, 2012 at 7:47
Read the last post in this link it might be what you are looking for 1-script.com/forums/php/… — v0d1ch
– v0d1ch, Commented Dec 13, 2012 at 7:57
How do you display the HTML? Is it inside or outside the loop? Will be easier for us if you put your complete code and maybe your database row values. — SubRed
– SubRed, Commented Dec 13, 2012 at 8:17
You should really select an answer if your problem is solved. — MOTIVECODEX
– MOTIVECODEX, Commented Jun 27, 2013 at 22:46

silly · Accepted Answer · 2012-12-13 08:22:16Z

1

first make a connection, than dont make a while, make a if like this

if($row = mysql_fetch_array($sql)){
    $phone = $row["phone"];
    $country = $row["country"];
    $state = $row["state"];
    $city = $row["city"];
    $accounttype = $row["accounttype"];
    $bio = $row["bio"];
}

and than

$speaking_type = null;
switch($accounttype) {
    case 'n':
        $speaking_type = 'Normal User';
        break;
    case 'm':
        $speaking_type = 'Expert User';
        break;
    case 's':
        $speaking_type = 'Super User';
        break;
    default:
        $speagink_type = 'none';
        //throw new Exception('unsupported account type '.$accounttype);
}

echo $speaking_type;

edited Dec 13, 2012 at 8:22

answered Dec 13, 2012 at 7:59

silly

7,8972 gold badges26 silver badges37 bronze badges

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

2 Comments

Alex Moneyy Amk Over a year ago

I am now getting this error Fatal error: Uncaught exception 'Exception' with message 'unsupported account type ' in /home/content/31/7044931/html/member/member_account.php:86 Stack trace: #0 {main} thrown in /home/content/31/7044931/html/member/member_account.php on line 86

silly Over a year ago

@AlexMoneyyAmk ok your field is nullable... i changed my code... check out

JNDPNT · Accepted Answer · 2012-12-13 07:59:11Z

0

I think the problem is your scope. Your variables are defined within the while-loop, and so they are unknown further in the document. Try instantiating them on top (before the while-loop) like this:

$phone = null;
$country = null;
$state = null;
$city = null;
$accounttype = null;
$bio = null;

Than the variables will be known outside the while and the values will be remembered when you print them.

answered Dec 13, 2012 at 7:59

JNDPNT

7,4752 gold badges37 silver badges40 bronze badges

1 Comment

Alex Moneyy Amk Over a year ago

That won't work. It doesn't know what rows to get it would leave all the information blank because you are not defining what row is what.

underscore · Accepted Answer · 2012-12-13 07:59:29Z

0

I thought u didn't connect to the database first .use following code to the connect with your credentials.That's why you are seeing a blank space

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code

mysql_close($con);

answered Dec 13, 2012 at 7:59

underscore

6,9277 gold badges44 silver badges82 bronze badges

1 Comment

Alex Moneyy Amk Over a year ago

i am connected to my database :) all the other information is passing threw except the accounttype. :/

Collectives™ on Stack Overflow

web Development, PHP display variable from SQL as something else

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related