using font values from the database

[mdj]

Hi Guys,

In my database the customer can specify font values such as colour, size, face.

But they dont seem to appear on the page inside the echo command.

I have pasted the snip of the script that calls the values and also prints, or i should say doesnt.

$colname_pref = "1";
if (isset($HTTP_POST_VARS['$userid'])) {
  $colname_pref = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['$userid'] : addslashes($HTTP_POST_VARS['$userid']);
}
mysql_select_db($database_smslist, $smslist);
$query_pref = sprintf("SELECT f_face, f_color, f_size, bg_color FROM customers WHERE username = '$userid'", $colname_pref);
$pref = mysql_query($query_pref, $smslist) or die(mysql_error());
$row_pref = mysql_fetch_assoc($pref);
$totalRows_pref = mysql_num_rows($pref);

SNIP

echo "<center><font face='$f_face' color='#$f_color' size='$f_size'>Please fix the following errors: <br />";
echo "The mobile number you have entered is already been entered in our database.<br />";
	unset($username);
echo "<a href='javascript: history.go(-1)'>click here to try again</a></font></center>";
exit();  // exit the script so that we do not create this account!
 }

[m_tt]

This method hasn't failed me yet:

mysql_connect(host,user,pass)or die(mysql_error());
mysql_select_db(database)or die(mysql_error());

$get_fonts = mysql_query("SELECT f_face,f_color FROM table WHERE username='$user'")or die(mysql_error());

if (mysql_num_rows($get_fonts) > 0) {
 list($font_face,$font_color) = mysql_fetch_row($get_fonts);
 ## use $font_face and $font_color
 ## ie:
 echo '<font face="' . $font_face . '" color="' . $font_color . '">pretty</font>';
} else {
 ## use defaults
}

[mdj]

Mmm, I have changed the way the fonts are displayed but still no luck,

Im already running in an if statement so i cant copy what you have done above so any other thoughts would be appreciated.

I have pasted the complete code below upto the section that doesnt work.

<?php require_once('*******.php'); ?>
<?php
$colname_pref = "1";
if (isset($HTTP_POST_VARS['$userid'])) {
  $colname_pref = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['$userid'] : addslashes($HTTP_POST_VARS['$userid']);
}
mysql_select_db($database_smslist, $smslist);
$query_pref = sprintf("SELECT f_face, f_color, f_size, bg_color FROM customers WHERE username = '$userid'", $colname_pref);
$pref = mysql_query($query_pref, $smslist) or die(mysql_error());
$row_pref = mysql_fetch_assoc($pref);
$totalRows_pref = mysql_num_rows($pref);

/* Let's do some checking and ensure that the user's email address or username
 does not exist in the database */

 $sql_tel_check = ("SELECT m_tel FROM mem_$userid WHERE m_tel='$m_tel'");
 mysql_select_db($database_smslist, $smslist);
 $sqlu = mysql_query($sql_tel_check, $smslist) or die(mysql_error());
 $tel_check = mysql_num_rows($sqlu);

 if(($tel_check > 0)){

echo '<center><font face="' . $f_face . '" color="' . $f_color . '" size="' . $f_size . '">Please fix the following errors: <br />';
echo "The mobile number you have entered is already been entered in our database.<br />";
	unset($username);
echo "<a href='javascript: history.go(-1)'>click here to try again</a></font></center>";
exit();  // exit the script so that we do not create this account!
 }

[cgraz]

try replacing this part of your code with my code below

 mysql_select_db($database_smslist);
 $sql_tel_check = "SELECT m_tel FROM mem_$userid WHERE m_tel='$m_tel'"; // i removed the parenthesis
 $sqlu = mysql_query($sql_tel_check) or die(mysql_error());
 $row = mysql_fetch_array($sqlu); // you gotta put the results in an array so you can display them later
 $tel_check = mysql_num_rows($sqlu);

 if(($tel_check > 0)){

 echo '<center><font face="' . $row["f_face"] . '" color="' . $row["f_color"] . '" size="' . $row["f_size"] . '">Please fix the following errors: <br />';
echo "The mobile number you have entered has already been entered in our database.<br />";
     unset($username);
 echo "<a href='java script: history.go(-1)'>click here to try again</a></font></center>";
 exit();  // exit the script so that we do not create this account!
 }

I made a few comments here and there.

Cgraz

[mdj]

Hi cgraz

Thanks for the code,

ive tried adding your modified code, and although i get no errors it still displays the font tags as empty in the source code when the page is viewed.

i take it i still need to leave the

mysql_select_db($database_smslist, $smslist);
$query_pref = sprintf("SELECT f_face, f_color, f_size, bg_color FROM customers WHERE username = '$userid'", $colname_pref);
$pref = mysql_query($query_pref, $smslist) or die(mysql_error());
$row_pref = mysql_fetch_assoc($pref);
$totalRows_pref = mysql_num_rows($pref);

section in as this calls the values for the font?

[cgraz]

whoops! I edited the wrong piece of code. Replace the following parts of your code.

mysql_select_db($database_smslist, $smslist);
$query_pref = "SELECT f_face, f_color, f_size, bg_color FROM customers WHERE username = '$userid'";
$pref = mysql_query($query_pref) or die(mysql_error());
$row_pref = mysql_fetch_assoc($pref);
$totalRows_pref = mysql_num_rows($pref);

Then further down, replace the part of your code with this

 if(($tel_check > 0)){

 echo '<center><font face="' . $row_pref["f_face"] . '" color="' . $row_pref["f_color"] . '" size="' . $row_pref["f_size"] . '">Please fix the following errors: <br />';
echo "The mobile number you have entered has already been entered in our database.<br />";
     unset($username);
 echo "<a href='java script: history.go(-1)'>click here to try again</a></font></center>";
 exit();  // exit the script so that we do not create this account!
 }

Also note that this forum changes javascript to java script (two words). So be sure to change that back to one word when you use it.

Cgraz

[mdj]

WeHEy!!

You true guru you.

I was nearly there, i had worked out that by using this piece of code

$colname_pref = "1";
if (isset($HTTP_POST_VARS['$userid'])) {
  $colname_pref = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['$userid'] : addslashes($HTTP_POST_VARS['$userid']);
}

It wasnt reading anything from the database, I changed this and it was reading the correct information.

All i then needed to do was work out the last part $row_pref but you saved me what would have probably taken me about an hour!!

Thank you so much.

I hope this thread helps others in the future.