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 https://forums.phpfreaks.com/topic/18188-phpmysql/ Share on other sites More sharing options...
onlyican Posted August 21, 2006 Share Posted August 21, 2006 Double Postedhttp://www.phpfreaks.com/forums/index.php/topic,105050.0.html Link to comment https://forums.phpfreaks.com/topic/18188-phpmysql/#findComment-78039 Share on other sites More sharing options...
wildteen88 Posted August 21, 2006 Share Posted August 21, 2006 Topic locked. Please don't double post. Link to comment https://forums.phpfreaks.com/topic/18188-phpmysql/#findComment-78095 Share on other sites More sharing options...
Recommended Posts