Jump to content

Archived

This topic is now archived and is closed to further replies.

mrjameer

css in db

Recommended Posts

hi,

i want to store css template which has header,left navbar,center,right navbar,footer in mysql db.iam using like this

1..i will store a css template in db

2..retrieve it from db and assigned its value to some textarea for updations

3..update content

$header='<style type ="text/css">
#header{
background-color:white;
color:#009900;
border-style:solid;
border-width:3px;
height:200px;
width:300px;
padding:5px;}</style><div id="header">WELCOME</div>';
if i use this type everything is displayed correctly but when updating it iam getting error
is it the correct way to store in db or i have to use

$header='<link rel="stylesheet" type="text/css" href="abc.css"> <div id="header">WELCOME</div>';




mrjameer

Share this post


Link to post
Share on other sites
Is this what you are trying to do?

stylesheet.php: [code]<?php
$conn = mysql_connect("localhost","username","password");
mysql_select_db("some_db");

$query = mysql_query("SELECT * FROM skins WHERE id=1 LIMIT 1");

if(mysql_num_rows($query) > 0)
{
$skin_data = mysql_fetch_assoc($query);
header("Content-type: text/css");
echo $skin_data['css'];
}
?>[/code]

HTML code: [code]<link rel="stylesheet" type="text/css" href="stylesheet.php" />[/code]

Share this post


Link to post
Share on other sites
ya

i want to store css code in db and retrieve it and want to update css code from admin cp.i already tested htmlentities,htmlspecialchars like that.everything is displaying correctly but when updating it from admin panel it is not updated.

thanks
mrjameer

Share this post


Link to post
Share on other sites
here a good admin drop down colors to help you

you could use the dropdown menu to change all the colors if it helps ok.

[code]
<?php


if($_POST['submit']){

echo $back_ground;
}

?>
<table align="center" border="4" bordercolor="black">
<td align="center">

<form method="POST" action="">
<select name="back_ground">

<option value="">Highlight</option>
<option value="#000000" style="background-color: Black;color: #FFFFFF;">Black</option>
<option value="#808080" style="background-color: Gray;">Gray</option>
<option value="#A9A9A9" style="background-color: DarkGray;">DarkGray</option>
<option value="#D3D3D3" style="background-color: LightGrey;">LightGray</option>
<option value="#FFFFFF" style="background-color: White;">White</option>
<option value="#7FFFD4" style="background-color: Aquamarine;">Aquamarine</option>
<option value="#0000FF" style="background-color: Blue;">Blue</option>
<option value="#000080" style="background-color: Navy;color: #FFFFFF;">Navy</option>
<option value="#800080" style="background-color: Purple;color: #FFFFFF;">Purple</option>
<option value="#FF1493" style="background-color: DeepPink;">DeepPink</option>
<option value="#EE82EE" style="background-color: Violet;">Violet</option>
<option value="#FFC0CB" style="background-color: Pink;">Pink</option>
<option value="#006400" style="background-color: DarkGreen;color: #FFFFFF;">DarkGreen</option>
<option value="#008000" style="background-color: Green;color: #FFFFFF;">Green</option>
<option value="#9ACD32" style="background-color: YellowGreen;">YellowGreen</option>
<option value="#FFFF00" style="background-color: Yellow;">Yellow</option>
<option value="#FFA500" style="background-color: Orange;">Orange</option>
<option value="#FF0000" style="background-color: Red;">Red</option>
<option value="#A52A2A" style="background-color: Brown;">Brown</option>
<option value="#DEB887" style="background-color: BurlyWood;">BurlyWood</option>
<option value="#F5F5DC" style="background-color: Beige;">Beige</option>
</select>
<br><br>
<input type="submit" name="submit" value="choose a colour">
</select>
</form>
</td>
</table>
[/code]

Share this post


Link to post
Share on other sites
iam getting this error.iam using php4,mysql4,apache 1.3 ,windows platform[xp]
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'right='#right {position : relative; height : 779px; width : 267

mrjameer

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.