mysqlaccount

Verified account like twitter

I would like to install on my website a «verefied account» feature. But I wondered what was the best way to get there, with MySQL and PHP?

I tried to put a column «verified», in witch I post the badge picture name (verified.png), but by doing it this way, users with no verified account saw the space occupied by the badge, with empty space with an X in the upper left corner.

So, any idea on the best way to achieve this?

Thanks!

Solution

  • You need to go deeper. You are missing huge part of web design and PHP.

    What's the correct way too implement this?

    1- Add a Boolean/Bit "Verified" Column 0/1

    2- In your PHP page, you need a simple condition:

    If(Column("Verified") == True) {
 echo '<img src=\"verified.png\" />'
} else { 
   //Nothing! 
}