Converting value of 'email_id ' (varchar field) in mysql database to ascii code

[gc5483]

 

Hi all,

 

I want to use value of 'email_id' (varchar field) in mysql database to covert into respective ascii code so that it can be used for future purpose.a part of my code is given below.can someoone guide me how to do that as I am new to PHP.I ma using PHP5.2 with mysql 5.0 nd IIS 6.0.

 

$result2 = mysql_query("SELECT * FROM registeration_details WHERE activation_status='NO'" );

 

while($row = mysql_fetch_array($result2) )

{

if($row['activation_status']=='NO')

{

$row['email_id'].'</br>';------------>email_id which is a DB field  is to be displayed as ascii in php

//echo cast($row['email_id'] AS ascii ).'</br>';

}

}

[obsidian]

I would recommend doing the translation within MySQL before you pull it out:

SELECT ASCII(email_id)
FROM registration_details;

[soycharliente]

There is also a function to give you the ascii value of a character, but obsidian's way is better.

 

http://us.php.net/manual/en/function.ord.php

[gc5483]

$result2 = mysql_query("SELECT ASCII(email_id) , activation_status FROM registeration_details WHERE activation_status='NO'" );

 

while($row = mysql_fetch_array($result2) )

{

if($row['activation_status']=='NO')

{

        echo $row['email_id'].'</br>';

}

}

 

 

I have just tried this but now its not printing the corresponding ascii values.

[obsidian]

$result2 = mysql_query("SELECT ASCII(email_id) , activation_status FROM registeration_details WHERE activation_status='NO'" );

 

while($row = mysql_fetch_array($result2) )

{

if($row['activation_status']=='NO')

{

        echo $row['email_id'].'</br>';

}

}

 

 

I have just tried this but now its not printing the corresponding ascii values.

 

You have to name the column to output it as you are trying:

SELECT ASCII(email_id) as email_id, activation_status FROM registeration_details WHERE activation_status='NO'

[gc5483]

Now its displaying ascii value of the first charcter only.but i have to use the value of the whole string .

[obsidian]

Now its displaying ascii value of the first charcter only.but i have to use the value of the whole string .

 

Ah, I see. You would be better of doing something like this, then, since the field will be varying length:

<?php
$q   = "SELECT email_id, activation_status FROM registeration_details WHERE activation_status='NO'";
$sql = mysql_query($q);
while ($row = mysql_fetch_assoc($sql)) {
  for ($i = 0; $i < strlen($row['email_id']); $i++) {
    echo ord($row['email_id']{$i});
  }
  echo "<br />\n";
}
?>

[gc5483]

Thnax obsidian nd charlieholder . I think now I will be able to do that.