Dynamic CSS Code

[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]

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]

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]

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]

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

[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