Guest mrjameer Posted August 21, 2006 Share Posted August 21, 2006 iam storing a variable in db as follows$str='<html><b>ABCD</b></html>';by using insert query,i put it in mysql db.in my second program iam creating one textbox and inserting it in db as follows$textbox1='name<input type="text" name="t1" value="<?php echo $str;?>">';by using insert query iam storing it in db....finally i have written a third program to retrieve these textboxes with $str values from db;but iam getting textbox with <?php echo $str;?> value.but i want to get <html><b>ABCD</b></html> in that textbox.please tell me how to do it.//program for storing html code in db<?php$var1='<html><b>ABCD</b></html>';$var2='<html><h3>EFGH</h3></html>';$var3='<html><b>IJKL</b></html>';$var4='<html><b>MNOP</b></html>';$conn4=mysql_connect("localhost","","");mysql_select_db("mrj",$conn4);function escape_quotes( $html ) { if ( get_magic_quotes_gpc() ) { return( $html ); } else { return( addslashes( $html ) ); } } $var1 = escape_quotes( $var1 ); $var2 = escape_quotes( $var2 ); $var3 = escape_quotes( $var3 ); $var4= escape_quotes( $var4 ); $sql="INSERT INTO mak VALUES('$var1','$var2','$var3','$var4')";$result=mysql_query($sql,$conn4);echo "record inserted";?>//program for storing textboxes with some values in db<?php$conn4=mysql_connect("localhost","","");mysql_select_db("mrj",$conn4);$va1='variable1<input type="text" name="vars1" size="35" value ="' .$var1.'"><br>';$va2='variable2<input type="text" name="vars2" size="35" value ="' .$var2.'"><br>';$va3='variable3<input type="text" name="vars3" size="35" value ="' .$var3.'"><br>';$va4='variable4<input type="text" name="vars4" size="35" value ="' .$var4.'"><br>';$updates='<input type="submit" value="update" onclick="this.form.action=\'upd.php\'"><br>';function escape_quotes( $html ) { if ( get_magic_quotes_gpc() ) { return( $html ); } else { return( addslashes( $html ) ); } } $va1 = escape_quotes( $va1 ); $va2 = escape_quotes( $va2 ); $va3 = escape_quotes( $va3 ); $va4 = escape_quotes( $va4 ); $updates = escape_quotes( $updates ); $sql="INSERT INTO sampl1 VALUES('$va1','$va2','$va3','$va4','$updates')";$result=mysql_query($sql,$conn4) or die (mysql_error());echo "record inserted";?>//program for retriving the textboxes with the values from db (the values which i stored in db by writing first program)<?php$conn4=mysql_connect("localhost","","");mysql_select_db("mrj",$conn4);$sql="SELECT * FROM sampl1";$result=mysql_query($sql,$conn4);while($newarray=mysql_fetch_array($result)){$va1=$newarray['va1'];$va2=$newarray['va2'];$va3=$newarray['va3'];$va4=$newarray['va4'];$updates=$newarray['updates'];echo $va1."".$va2."".$va3."".$va4."".$updates;}?>with this code either iam getting the value in textbox is <?php echo $str;?> like that or some blank textboxes.please help me to solve my problemmrjameer Link to comment Share on other sites More sharing options...
justsomeguy Posted August 21, 2006 Share Posted August 21, 2006 Replace this:$textbox1='name<input type="text" name="t1" value="<?php echo $str;?>">';With this:$textbox1='name<input type="text" name="t1" value="' . $str . '">'; Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now