php/mysql getting column values from db into textbox on a form

mrjameer · #1 18-Aug-2006, 15:11

iam storing a variable in db as follows
$str='<html>ABCD</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>ABCD</html> in that textbox.please tell me how to do it.

mrjameer

TreyAU21 · #2 18-Aug-2006, 15:28

you can't put in code like you would to run it inside an HTML page. you to fully construct the string via concatenation...

PHP Code:


$textbox1 = "name<input type=\"text\" name=\"t1\" value=\"" . $str ."\">";

mrjameer · #3 21-Aug-2006, 06:00

here is the code and help me where i was wrong
//program for storing html code in db

PHP Code:


<?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 Code:


<?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 Code:


<?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;
}
?>

iam getting blank textboxes or getting some value like <?php $var1;?>
help me i was strucked.

TreyAU21 · #4 22-Aug-2006, 09:08

In your second script above... print out the values for $var1, $var2, $var3, and $var4... or use a tool like phpmyadmin to see what these values are in the database.

I wouldn't think that they are being stored properly (if the scripts are actually broken into sections like you have displayed). You would need a SELECT query in the second script to retrieve the variables.

Code:

<?php
$conn4=mysql_connect("localhost","","");
mysql_select_db("mrj",$conn4);

//-----------------------//
//This is the added code //
//-----------------------//
$sql="SELECT * FROM mak";
$result=mysql_query($sql,$conn4);
$row = mysql_fetch_array($result);
//-----------------------//

$va1='variable1<input  type="text" name="vars1" size="35" value ="' . $row['var1'] . '"><br>';
$va2='variable2<input type="text" name="vars2" size="35" value ="' . $row['var2'] . '"><br>';
$va3='variable3<input type="text" name="vars3" size="35" value ="' . $row['var3'] . '"><br>';
$va4='variable4<input type="text" name="vars4" size="35" value ="' . $row['var4'] . '"><br>';
$updates='<input type="submit" value="update" onclick="this.form.action=\'upd.php\'"><br>';

//....

See if that fixes it... if not, let me know, and we can keep at it.

PS: Sorry about the formatting... if I put the code in the PHP tags, it would show all of the code on 1 line for some reason... so, I just put it in the generic CODE tag.

mrjameer · #5 23-Aug-2006, 04:36

treyAU21

thanks a lot.i got the result with your code.i want to know that iam using the following code for storing a variable in db,is it correct or not

for storing in db:
$var11='ABCD';
$var1 = htmlentities($var11);

iam retriving the variable from db and passing it through html_entity_decode(variable name):
$v1 = html_entity_decode($var1);

if i use above format then iam getting the correct output what i want.is it correct or i have to follow some other.please tell me.

my second question is that i want to create a horizontal menu in which one end is asusual but the other end should be like cross cut means like following format.

|------------------------------------\
|-------------------------------------\

mrjameer

LuciWiz · #6 23-Aug-2006, 06:39

Quote:

Originally Posted by TreyAU21

PS: Sorry about the formatting... if I put the code in the PHP tags, it would show all of the code on 1 line for some reason... so, I just put it in the generic CODE tag.

Hello, Trey.

I wanted to edit your post, and when I hit "Preview Changes", the code looked all right to me (see bellow). If that is not what it looked like to you, please let me know, and I will pass it to the admin.

PHP Code:


<?php
$conn4=mysql_connect("localhost","","");
mysql_select_db("mrj",$conn4);

//-----------------------//
//This is the added code //
//-----------------------//
$sql="SELECT * FROM mak";
$result=mysql_query($sql,$conn4);
$row = mysql_fetch_array($result);
//-----------------------//

$va1='variable1<input  type="text" name="vars1" size="35" value ="' . $row['var1'] . '"><br>';
$va2='variable2<input type="text" name="vars2" size="35" value ="' . $row['var2'] . '"><br>';
$va3='variable3<input type="text" name="vars3" size="35" value ="' . $row['var3'] . '"><br>';
$va4='variable4<input type="text" name="vars4" size="35" value ="' . $row['var4'] . '"><br>';
$updates='<input type="submit" value="update" onclick="this.form.action=\'upd.php\'"><br>';

//....

Best regards,
Lucian

TreyAU21 · #7 23-Aug-2006, 08:21

Hey Lucian,

No matter what I did, it sould strip out all of the line breaks. The code would appear in one line. I edited it several times... going through and and manually hitting enter after every line... copying to notepad and copying it back... and others.

Looks like it's working in this post below vvvvv... so maybe it was a fluke?

PHP Code:


<?php
$conn4=mysql_connect("localhost","","");
mysql_select_db("mrj",$conn4);

//-----------------------//
//This is the added code //
//-----------------------//
$sql="SELECT * FROM mak";
$result=mysql_query($sql,$conn4);
$row = mysql_fetch_array($result);
//-----------------------//

$va1='variable1<input  type="text" name="vars1" size="35" value ="' . $row['var1'] . '"><br>';
$va2='variable2<input type="text" name="vars2" size="35" value ="' . $row['var2'] . '"><br>';
$va3='variable3<input type="text" name="vars3" size="35" value ="' . $row['var3'] . '"><br>';
$va4='variable4<input type="text" name="vars4" size="35" value ="' . $row['var4'] . '"><br>';
$updates='<input type="submit" value="update" onclick="this.form.action=\'upd.php\'"><br>';

//....

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP/MySQL coding issue	cmarti	MySQL / PHP Forum	3	26-Jul-2004 08:01
help with form	orbitel	MySQL / PHP Forum	11	21-Jan-2004 15:29

php/mysql getting column values from db into textbox on a form

Re: php/mysql getting column values from db into textbox on a form

Re: php/mysql getting column values from db into textbox on a form

Re: php/mysql getting column values from db into textbox on a form

Re: php/mysql getting column values from db into textbox on a form

Re: php/mysql getting column values from db into textbox on a form

Re: php/mysql getting column values from db into textbox on a form