Dynamic CSS Code

This site is best viewed in a modern browser with JavaScript enabled.

william232

Hi all i have created my own template system well i am attempting to any way i have the template information in the database in a seperate table called templates

anyway i have this code to bring the header part of the template depending on the which template is selected in this case its the default template which is this code

<?php 
						include("dbconnect.php");
						$kQuery="SELECT * FROM template Where selected='1'";
						$rs=mysqli_query($con,$kQuery);
						if(!$rs)
						{
							echo "Error:".mysqli_error($con);
						}
						else
						{
							$count=mysqli_num_rows($rs);
							if($count>0)
							{
								$data=mysqli_fetch_assoc($rs);
								extract($data);
								$Header=stripslashes($Header);
							}
							else
							{
								echo " Error:The Header you are Looking for cannot be found";
							}
						}
				echo ($Error)?$Error:"";
				echo ($Header)?$Header:"";	
				?>

How can i get it to do the CSS So if i remove the CSS Style sheet from server everything will remain the same as if the style sheet is from the server in a file called Layout.CSS?

Is this Possible maybe get some php code in the css document?

Can this be done?

What other Options are there for me in this case?

bokeh

Of course the stylesheet can be a php document. stylesheet.php for example or /css/index.php Don't forget to add the correct header for a stylesheet though (text/css).

Charles

However, browsers tend to cache stylesheets so dynamic content will tend to get lost or ignored. You'll need to provide each call to the stylesheet with a unique URL or put the styles in the HTML.

pcthug

Charles wrote:
However, browsers tend to cache stylesheets so dynamic content will tend to get lost or ignored. You'll need to provide each call to the stylesheet with a unique URL or put the styles in the HTML.

You can disable caching by sending a no-cache header and an expire header which is set in the past:

header('Cache-Control: no-cache, must-revalidate');
header('Expires: Thur, 01 Jan 1970 00:00:00 UTC');

NogDog

I just tried an experiment with adding the following cache-control header to a PHP style sheet file:

<?php
header("Content-Type: text/css");
header("Cache-Control: no-store");
// rest of style sheet with random color values follows....

Seems to do the trick: http://www.charles-reace.com/test/nocache/. The stylesheet is called via a normal link tag:

<link rel='stylesheet' href='style.php' type='text/css'>

Tried it with both FF and IE on Win XP, and colors changed on every page load.

Charles

pcthug wrote:
You can disable caching by sending a no-cache header and an expire header which is set in the past.

You can only request that the page not be cached. The granting of your request will depend upon the browser and the user settings.

Charles

NogDog wrote:
I just tried an experiment with adding the following cache-control header to a PHP style sheet file:
<?php
header("Content-Type: text/css");
header("Cache-Control: no-store");
// rest of style sheet with random color values follows....
Seems to do the trick: http://www.charles-reace.com/test/nocache/. The stylesheet is called via a normal link tag:
<link rel='stylesheet' href='style.php' type='text/css'>
Tried it with both FF and IE on Win XP, and colors changed on every page load.

Did you first set the browsers to cache stylesheets to see if the header request overrides the user preference?

bokeh

Another way to attack the caching issue is this:

<link rel='stylesheet' href='style.php?<?php echo time() ?>' type='text/css'>

NogDog

Charles wrote:
Did you first set the browsers to cache stylesheets to see if the header request overrides the user preference?

Presumably I'm using whatever the default settings are for that, since I don't even know where to change it for IE or FF.

jeddik

Hello -
propbably I am being a bit obvious ( or just thick)
but is the point of this so that you can write something like
this in the style sheet :

<?php 
header("Content-Type: text/css"); 
header("Cache-Control: no-store"); 

.bar{
  height: $hgt;
  width: $wdth;
  }
?>

OR would it need to echo'ed ?

<?php 
header("Content-Type: text/css"); 
header("Cache-Control: no-store"); 

echo "
.bar{
  height: $hgt;
  width: $wdth;
  }":
?>

Which is correct ???

Looks pretty useful - does anyone use this ??

jeddik

I looked at the example given and the style.php reads.

body {
margin: 0;
padding: 1em 2em;
font: medium arial, sans-serif;
background-color: rgb(80%, 93%, 90%);
color: rgb(57%, 33%, 18%);
}
h1 {
background-color: rgb(84%, 87%, 84%);
color: rgb(6%, 40%, 19%);
}
h2 {
background-color: rgb(100%, 85%, 93%);
color: rgb(27%, 16%, 10%);
}

This bit
<?php
header("Content-Type: text/css");
header("Cache-Control: no-store");

was not included - so now I am confused !!!

Also where is the dynamic element ?
I must be completely mis-understanding this :o

NogDog

Here's the style.php source code in my above example:

<?php
header("Content-Type: text/css");
header("Cache-Control: no-store");
?>
body {
   margin: 0;
   padding: 1em 2em;
   font: medium arial, sans-serif;
   <?php
   printf("   background-color: rgb(%d%%, %d%%, %d%%);\n",
          rand(80,100), rand(80,100), rand(80,100));
   printf("   color: rgb(%d%%, %d%%, %d%%);\n",
          rand(0,60), rand(0,40), rand(0,20));
   ?>
}
h1 {
   <?php
   printf("   background-color: rgb(%d%%, %d%%, %d%%);\n",
          rand(80,100), rand(80,100), rand(80,100));
   printf("   color: rgb(%d%%, %d%%, %d%%);\n",
          rand(0,20), rand(0,60), rand(0,40));
   ?>
}
h2 {
   <?php
   printf("   background-color: rgb(%d%%, %d%%, %d%%);\n",
          rand(80,100), rand(80,100), rand(80,100));
   printf("   color: rgb(%d%%, %d%%, %d%%);\n",
          rand(0,40), rand(0,20), rand(0,60));
   ?>
}

jeddik

Thank you
So I wasn't barking up the wrong tree then